This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
33751 | 33751 | 1918-10-19 | 8 | c-d | Guangdong news/ A meeting of the military government. Tang Shaoyi is to return to Guangdong. River Project Office reports water levels in various rivers in Guangdong. Report on the floods in different regions. Floods in Nanhai, Shunde, Dongguan, Yingde and other counties. Disaster Relief office in Guangzhou reports their work done. Robbery and theft in Songlong Town, of Gaoyao county. Floods in Songlong, of Gaoyao. | 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]);