This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47129 | 47129 | 1928-06-09 | 8 | a | A big plane manufactured in Berlin, Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47130 | 47130 | 1928-06-09 | 8 | a | Zhang Zuolin has left Beijing for the north-east. | China | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47131 | 47131 | 1928-06-09 | 8 | a | Zhang Zuolin is killed in a bomb explosion on his way from Beijing to Fengtian. | Japan | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47132 | 47132 | 1928-06-09 | 8 | b | Soviet Russia provides assistance to the strikers in India. | Other... | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47133 | 47133 | 1928-06-09 | 8 | b | Sun Chuanfang resigns from the position of General Commander of Zhili and Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47134 | 47134 | 1928-06-09 | 8 | b | Zhang Zuolin dies in a bomb explosion and the report. | Japan | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
47135 | 47135 | 1928-06-09 | 8 | b | Feng Yuxiang is considering to defect once again. | China | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
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]);