This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35217 | 35217 | 1920-01-03 | 7 | a-c | Australia news/ Chinese Chamber of Commerce in New South Wales writes to Chinese Consul-General in Melbourne asking for his protection of Chinese nationals. Two men are arrested in Sydney for fighting. Milkmen in Sydney ask for more pay. Chinese community in Sydney, including zhi gong tang and the Nationalist Party (Guomindang), to organise celebrations on the New Year. A clothes shop in Sydney is burgled during the Christmas holiday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097995 | 24097995 | |
35218 | 35218 | 1920-01-03 | 7 | c | Students in Fuzhou have clash with Japanese, the report and the support by Shanghai students. | China | http://trove.nla.gov.au/newspaper/page/24097995 | 24097995 |
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]);