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 |
---|---|---|---|---|---|---|---|---|---|
20868 | 20868 | 1909-04-03 | 6 | b | Chinese government asks Japan to transfer Manchuria issue to the International Peace Convention. | Britain | http://trove.nla.gov.au/newspaper/page/26802136 | 26802136 | |
20869 | 20869 | 1909-04-03 | 6 | b | American comments on the British naval vessels. | Britain | http://trove.nla.gov.au/newspaper/page/26802136 | 26802136 | |
20870 | 20870 | 1909-04-03 | 6 | b | Number of British immigrants to Australia and New Zealand in 1908. | Britain | http://trove.nla.gov.au/newspaper/page/26802136 | 26802136 | |
20871 | 20871 | 1909-04-03 | 6 | b | Japanese naval fleet to visit Vancouver. | Australia | http://trove.nla.gov.au/newspaper/page/26802136 | 26802136 | |
20872 | 20872 | 1909-04-03 | 6 | b | An American bride is accused for marrying a Japanese man. | Britain | http://trove.nla.gov.au/newspaper/page/26802136 | 26802136 | |
20881 | 20881 | 1909-04-03 | 7 | b | Chinese businessmen Cai Chang, Ou Liang, Gao You, Pang Zijun, Guang Huang, Ma Zhao and Chen Qingyun report their travels and situations of other Chinese passengers on their way back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802135 | 26802135 | |
20882 | 20882 | 1909-04-03 | 7 | b | Advertisement for Wirth Brothers Circus on George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802135 | 26802135 | |
20883 | 20883 | 1909-04-03 | 7 | b | Miscellaneous notes/ American Chinese citizens and their rights to vote. Descendants of George Washington demand compensation from American government. New comet found. Clock can talk in Switzerland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802135 | 26802135 |
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]);