This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36331 | 36331 | 1920-11-27 | 2 | b-d | More report on the peace talks in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24098395 | 24098395 | |
36350 | 36350 | 1920-11-27 | 8 | b-d | Guangdong news/ Mo Rongxin executes Xu Chonghao. Shen Hongying's troops return to Guangzhou. Mo Rongxin is leaving Guangdong. Qin Chunxuan leaves Guangdong. Guangxi army leave Huizhou. Guangxi army loot in Sihui county and the report. | China | http://trove.nla.gov.au/newspaper/page/24098401 | 24098401 |
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]);