This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36460 | 36460 | 1921-01-01 | 7 | a | Chinese Chamber of Commerce in New South Wales meets and calls for donations to the war disaster area in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093381 | 24093381 | |
36461 | 36461 | 1921-01-01 | 7 | a-b | Fierce clash between Japanese and Manilamen in Broome, Western Australia has claimed several lives, and response of Australian government and society. Prime Minister William Morris Hughes sends cruiser there to protect white residents. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093381 | 24093381 | |
36462 | 36462 | 1921-01-01 | 7 | b-c | Chinese passengers write to praise the service of China-Australia Mail S. S. Line during their travel between Hong Kong and Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093381 | 24093381 | |
36463 | 36463 | 1921-01-01 | 7 | a-b | Advertisement for the China-Australia Mail S. S. Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093381 | 24093381 |
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]);