This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56372 | 56372 | 1936-10-31 | 6-7 | a-d | Guangdong news/ Jiang Jieshi to unify the leadership of army and the government. Cai Tingkai talks in Guangzhou on his return from Guangxi. Japanese to set up textile factory in Hong Kong. Plan to ban opium trade and opium smoking in Guangdong. A fire in Guangzhou. Japanese sailors land in Beihai, of Guangxi province. Famine in Longchuan county. New penalties in Boluo county. | China | http://trove.nla.gov.au/newspaper/page/24097048 | 24097048 |
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]);