This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54886 | 54886 | 1935-02-16 | 7-8 | a-f | Guangdong news/ The communist troops under Zhu De and Mao Zedong arrive Zunyi, of Guizhou province. British engineer arrives Guangzhou for the project of steel factory. Pirates in Macao hijack ships. The communist troops in Sichuan. Local security troops in Bao'an county. Rice industry in Hong Kong last year. Cotton production in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24096330 | 24096330 |
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]);