This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33113 | 33113 | 1918-03-16 | 7 | b-c | Australia news/ George Morrison speaks in Melbourne on the Chinese politics and others. Number of casualties of the Australian army in the World War I. Two illegal Chinese immigrants are found in Melbourne. Fire in Goulburn, New South Wales. Storm swaps north Queensland. Economic loss due to the strike in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097219 | 24097219 | |
33114 | 33114 | 1918-03-16 | 7 | c-d | China on the edge of political disruption. | Britain | http://trove.nla.gov.au/newspaper/page/24097219 | 24097219 | |
33115 | 33115 | 1918-03-16 | 7 | d | Report on the Chinese troops in Siberia. | Britain | http://trove.nla.gov.au/newspaper/page/24097219 | 24097219 | |
33116 | 33116 | 1918-03-16 | 7 | d-e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097219 | 24097219 |
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]);