This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36356 | 36356 | 1920-12-04 | 3 | b-c | News on the famine relief in north China. | China | http://trove.nla.gov.au/newspaper/page/24098402 | 24098402 | |
36368 | 36368 | 1920-12-04 | 8 | b-c | Guangdong news/ Wei Bangping writes to Guangxi military officer Ma Ji. Shops in Zhaoqing are required to provide foods to Guangxi troops. Guangxi troops in Zhaoqing. Railway workers in Guangdong boycott to the Guangxi troops. | China | http://trove.nla.gov.au/newspaper/page/24098409 | 24098409 |
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]);