This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53807 | 53807 | 1934-01-27 | 7-8 | a-f | Guangdong news/ Xiao Focheng condemns the Nanjing government for their bombing of Fujian. Report on the bombing of Fujian by Jiang Jieshi's warplanes. Decline of the silk industry in Guangdong. Business in Shiqi town, Shunde county. Villagers in Nanhai county set fire on the police office. | China | http://trove.nla.gov.au/newspaper/page/24091514 | 24091514 |
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]);