This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33193 | 33193 | 1918-04-13 | 7 | b-c | Australia news/ Federal government takes over all inland navigation. A Chinese tram driver is brought to trial in Sydney for opium smuggling. Huge income of tram tickets in the past two weeks. Chinese communities in New South Wales donate to the Red Cross and their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097251 | 24097251 | |
33194 | 33194 | 1918-04-13 | 7 | d | Chinese naval commander in the south Cheng Biguang is assassinated and the report. | China | http://trove.nla.gov.au/newspaper/page/24097251 | 24097251 | |
33195 | 33195 | 1918-04-13 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097251 | 24097251 |
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]);