This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45013 | 45013 | 1926-07-31 | 6 | a-c | Chinese community in the Philippines and the legal suit with the government authority. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101652 | 24101652 | |
45015 | 45015 | 1926-07-31 | 7 | a-c | Australia news/ Liners to Asian ports increase fares. Illegal Chinese immigrants detained in Singapore. Storm in Geelong, Victoria. Western priest talks on the Chinese situation on his return to Sydney. Japanese immigrants in north Queensland. Welcome ceremony at the Chinese Presbyterian church in Sydney for Rev. Liang Lanxin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101651 | 24101651 |
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]);