This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45442 | 45442 | 1927-01-29 | 2 | c-d | Editorial on China's foreign policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101864 | 24101864 | |
45446 | 45446 | 1927-01-29 | 7 | a-b | Australia news/ A notice by the Chinese Consulate-General in Melbourne on the Chinese immigration to Fiji and the new regulations issued by Fijian authority. Workers' union federation in Australia opposes to any foreign interference with the Chinese affairs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101865 | 24101865 |
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]);