This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31367 | 31367 | 1916-07-01 | 7 | a-b | Australia news/ Chinese men in Sydney are shot and injured and the court hearings. Opium smuggled and caught by the New South Wales customs. Census and the statistics of population in New South Wales in 1915. | Australia | http://trove.nla.gov.au/newspaper/page/24095319 | 24095319 | |
31368 | 31368 | 1916-07-01 | 7 | b | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095319 | 24095319 | |
31369 | 31369 | 1916-07-01 | 7 | c | A passenger ship and a warship collide in Zhejiang province, China, and the report. | China | http://trove.nla.gov.au/newspaper/page/24095319 | 24095319 | |
31370 | 31370 | 1916-07-01 | 7 | c | Chinese navy commander Liu Guanxiong requests sitting of the national parliament. | China | http://trove.nla.gov.au/newspaper/page/24095319 | 24095319 | |
31371 | 31371 | 1916-07-01 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095319 | 24095319 |
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]);