This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18687 | 18687 | 1907-12-28 | 6 | b | Hundreds of thousands of people are leaving the United States to return to Europe. | Britain | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
18688 | 18688 | 1907-12-28 | 6 | b | Political chaos in Teheran, Persia (Iran). | Britain | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
18689 | 18689 | 1907-12-28 | 6 | b | Japan's military budget for the next six years. | Britain | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
18690 | 18690 | 1907-12-28 | 6 | b | Russia in panic. | Britain | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
18691 | 18691 | 1907-12-28 | 6 | b | German ministry of war purchases radios for communication. | Australia | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
18692 | 18692 | 1907-12-28 | 6 | b | A coal mine in Pittsburgh, USA, explodes and 250 miners are trapped underground. | Australia | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
18701 | 18701 | 1907-12-28 | 7 | b | Japanese government pays close attention to wool industry in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801591 | 26801591 | |
18702 | 18702 | 1907-12-28 | 7 | b | Two illegal Chinese immigrants are detained in Adelaide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801591 | 26801591 | |
18703 | 18703 | 1907-12-28 | 7 | b | Correspondence from Beijing. Wang Daxie is punished for his mediation between British company and railway building in Jiangsu and Zhejiang provinces. Chinese government notifies Japanese mission in Beijing on the boundary between China and Korea. Foreign settlement in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/26801591 | 26801591 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] ( [date] TEXT, [page] TEXT, [column] TEXT, [title] TEXT, [description] TEXT, [source] TEXT, [page_url] TEXT, [trove_id] TEXT ); CREATE INDEX [idx_article_index_date] ON [article_index] ([date]);