This data as json, CSV (advanced)
Suggested facets: page, title, source
date (date) 5 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19064 | 19064 | 1908-03-21 | 3 | b | Chinese students in Japan and a survey of their monthly publications. | Japan | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
25172 | 25172 | 1911-10-21 | 6 | b | Memorising Panama Canal's establishment | America celebrates Panama Canal's establishment in San Francisco. | Other... | http://trove.nla.gov.au/newspaper/page/24091971 | 24091971 |
25271 | 25271 | 1911-11-11 | 6 | b | Zhang Yunan passes away | Zhang Yunan, a wealthy man in Guangdong, passes away. | China | http://trove.nla.gov.au/newspaper/page/24091997 | 24091997 |
25513 | 25513 | 1911-12-30 | 7 | b | Donations to Hankou people | Statistics of donations to people stricken by wars in Hankou, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24092054 | 24092054 |
46466 | 46466 | 1927-11-26 | 2 | b | Editorial by Tung Wah Times on the army men and their destiny. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098608 | 24098608 |
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]);