This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45358 | 45358 | 1926-12-11 | 5 | a-c | Miscellaneous report on the conflict in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24101809 | 24101809 | |
45360 | 45360 | 1926-12-11 | 7 | a-c | Australia news/ A family tragedy in Sydney. Labour Party MP of Western Australia on the boycott in China to British goods. New South Wales State parliament debates the revision of Factory Act. Duke of York comes to visit Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101811 | 24101811 |
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]);