This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17604 | 17604 | 1907-06-15 | 2 | c | Fire in Shanghai destroys Eastern Times (shi bao), shen zhou bao, Guangzhi Bookshop, and many other shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801360 | 26801360 | |
17611 | 17611 | 1907-06-15 | 3 | c | Kind of Denmark visits Britain. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801359 | 26801359 | |
17612 | 17612 | 1907-06-15 | 3 | c | Tsar of Russia has approved to build a railroad from Russia to Alaska. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801359 | 26801359 | |
17613 | 17613 | 1907-06-15 | 3 | c | Motor racing from Beijing to Paris. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801359 | 26801359 | |
17614 | 17614 | 1907-06-15 | 3 | c | Marriage statistics in New York. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801359 | 26801359 | |
17620 | 17620 | 1907-06-15 | 6 | c | Special report. Shanxi students in Japan write to Yuan Shikai regarding the foreign exploitation of mining resources in Shanxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801368 | 26801368 | |
17621 | 17621 | 1907-06-15 | 6 | c | Names listed for donations to flooding victims of Jiangsu province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801368 | 26801368 | |
17634 | 17634 | 1907-06-15 | 7 | c | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 | |
17637 | 17637 | 1907-06-15 | 8 | c | Miscellaneous report. Salary of journalist in America. A railway company in Canada offers reward for street name. Belgian authority auctions Waterloo battlefield. Britain has the smallest colony. History of desk used by American president. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801370 | 26801370 |
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]);