This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37611 | 37611 | 1921-09-24 | 3 | b | France returns to China some Boxer Indemnity. | China | http://trove.nla.gov.au/newspaper/page/24093694 | 24093694 | |
37612 | 37612 | 1921-09-24 | 3 | b | Regimental Commander of Hubei army Pan Shouzheng falls in the battle with Hunan army, and the report. | China | http://trove.nla.gov.au/newspaper/page/24093694 | 24093694 | |
37621 | 37621 | 1921-09-24 | 7 | b | An open letter by the Chinese Chamber of Commerce in New South Wales, signed by Chairman Guo Shun and Deputy Chairman Chen Zhuchen, calls for support from its members and the whole Chinese community to the China-Australia Mail Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093698 | 24093698 |
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]);