This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32710 | 32710 | 1917-11-24 | 3 | a-b | Operation of the railway lines from Tianjin to Pukou and from Beijing to Hankou. | China | http://trove.nla.gov.au/newspaper/page/24095915 | 24095915 | |
32717 | 32717 | 1917-11-24 | 6 | a-b | Editorial comments on the attitudes of the authorities in the southeastern provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095920 | 24095920 | |
32720 | 32720 | 1917-11-24 | 7 | a-b | Australia news/ Chinese communities in Sydney are planning to set up a mail steamship company and their plan to purchase ships. Winners of the horse race in New South Wales on Melbourne Cup. Statistics on the casualties of Australian troops in the World War I. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095919 | 24095919 |
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]);