This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36092 | 36092 | 1920-09-04 | 8 | b-c | Guangdong news/ Self-government movement in Guangdong. Li Hu and his troops in Xijiang area. Military government and its policy towards the northern government. The Save China Army in Zengcheng county. Joint defence plan for eight provinces. Revolutionaries are executed in Guangzhou. Storm and heavy rain in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098300 | 24098300 |
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]);