This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36157 | 36157 | 1920-09-25 | 8 | b-c | Guangdong news/ Provincial military government on the peace talks. Bandits in Heyuan county. Chen Jiongming's offices in Shantou are closed. Guangdong troops attack Fujian province and the report. More arrests of the revolutionaries in Guangzhou. Magistrate of Boluo county orders to arrest all revolutionaries. | China | http://trove.nla.gov.au/newspaper/page/24098326 | 24098326 |
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]);