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 |
---|---|---|---|---|---|---|---|---|---|
35280 | 35280 | 1920-01-31 | 3 | b | Police commissioner in Guangzhou resigns. | China | http://trove.nla.gov.au/newspaper/page/24098023 | 24098023 | |
35285 | 35285 | 1920-01-31 | 6 | b | Japan to withdraw its troops from Siberia. | America | http://trove.nla.gov.au/newspaper/page/24098028 | 24098028 | |
35286 | 35286 | 1920-01-31 | 6 | b | Railway workers in Italy are on strike. | Britain | http://trove.nla.gov.au/newspaper/page/24098028 | 24098028 | |
35287 | 35287 | 1920-01-31 | 6 | b | Strike in Fiji. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098028 | 24098028 | |
35288 | 35288 | 1920-01-31 | 6 | b | Epidemic in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24098028 | 24098028 | |
35289 | 35289 | 1920-01-31 | 6 | b | Japan to build more submarines. | America | http://trove.nla.gov.au/newspaper/page/24098028 | 24098028 | |
35295 | 35295 | 1920-01-31 | 7 | b | Farewell message by Liu Yufang and Cai Jingchu, representatives of the Hanyang China Iron Tools Company, on the return. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098027 | 24098027 |
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]);