This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56239 | 56239 | 1936-09-05 | 6-7 | a-d | Guangdong news/ The central government troops gather in the north of Guangdong province for coming military action. Central authority in Nanjing to reform the currency system in Guangdong. Chen Lizhen is appointed chief supervisor of the Sincere Company in Shanghai and the report. Guangdong province prepares to reform currency system. Commerce and industry in Guangxi. The magistrate and the prisoner in Dongguan county. Bandits in Zhongshan county. Floods in Kaiping. | China | http://trove.nla.gov.au/newspaper/page/24096982 | 24096982 |
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]);