This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56293 | 56293 | 1936-09-26 | 6-7 | a-d | Guangdong news/ Li Zongren delivers a speech to save the nation in Guangzhou. Jiang Jieshi demands Nanjing authority to suppress rebellions in Guangxi. Military officers in Guangdong request to stop attack on Guangxi. Chinese communities in the Philippines and America support General Cai Tingkai. Bandits in Zengcheng and Dongguan county. Floods in Zhongshan. Textile factory in Huiyang sacks its workers. Drought in Shunde. | China | http://trove.nla.gov.au/newspaper/page/24097008 | 24097008 |
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]);