This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47115 | 47115 | 1928-06-09 | 2 | c | Foreign ministry of the Beijing government protests against Japanese invasion in Shandong. | China | 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 | |
47121 | 47121 | 1928-06-09 | 3 | c | American naval fleet suddenly arrives Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098833 | 24098833 | |
47136 | 47136 | 1928-06-09 | 8 | c | Zhang Xueliang, Yang Yuting, and Yan Xishan after the death of Zhang Zuolin. | Japan | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
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]);