This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47114 | 47114 | 1928-06-09 | 2 | b | Editorial by Tung Wah Times on China's foreign policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098834 | 24098834 | |
47120 | 47120 | 1928-06-09 | 3 | c | Ancient Chinese bell found in Java and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098833 | 24098833 | |
47126 | 47126 | 1928-06-09 | 5 | b | Fifth part of the survey on the tobacco production in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098835 | 24098835 | |
47137 | 47137 | 1928-06-09 | 8 | c | Australia news/ Baby girl found abandoned in Sydney railway station. Polish immigrant in Geelong, Victoria, is found forging bank notes. Australian pilot flies directly from North America to Australia. Chinese gardener is burgled in New South Wales. Chinese man is charged with illegal entry before marrying a white girl. Chinese man in Sydney is hospitalised in madhouse. A Sydney girl is raped. Illegal wine sold in Sydney and the investigation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 |
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]);