This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33365 | 33365 | 1918-06-15 | 2 | c-e | Chinese commercial association meets in Tianjin to mediate the north-south disputes in China. | China | http://trove.nla.gov.au/newspaper/page/24097322 | 24097322 | |
33384 | 33384 | 1918-06-15 | 8 | c-e | Guangdong news/ A bomb explosion in Guangzhou. Liu Daqing leads his army to take over Huazhou. Military report from Nanxiong county. Wei Bangping leads his troops to enter Hainan island in order to suppress remains of Long Jiguang. Government troops from the north attack Nanxiong county. Long Rongting awards Long Jiguang's troops and the report. | China | http://trove.nla.gov.au/newspaper/page/24097327 | 24097327 |
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]);