This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33743 | 33743 | 1918-10-19 | 6 | a-c | The murder and robbery in Xiangshan county, Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24097474 | 24097474 | |
33750 | 33750 | 1918-10-19 | 8 | a-c | Beijing news/ Feng Guozhang is eager to step down. Ni Sichong and the new cabinet. Xu Shuzheng liaise with the Zhang Zuolin's army. Cao Kun and Zhang Zuolin are preparing to go south. Wang Kemin and his plan for rice sale. China's export to France. China's export to Japan and the statistics. | China | http://trove.nla.gov.au/newspaper/page/24097476 | 24097476 |
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]);