This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45490 | 45490 | 1927-02-19 | 7 | a-b | Australia news/ Bandits in Darling Harbour and the robbery. Bank manager commits suicide in Sydney. Chinese shop Jinshun on fire in Sydney. Bush fire in Victoria. Tornado in Queensland. Gathering of Labour Party in Sydney oppose to any foreign interference with the Chinese affairs. Chinese associations in Sydney welcome Wu Tianbao and Li She and the itinerary. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101887 | 24101887 | |
45491 | 45491 | 1927-02-19 | 7 | b | British troops land in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101887 | 24101887 | |
45492 | 45492 | 1927-02-19 | 7 | b | Declaration issued by Zhu Zhaoxin. | China | http://trove.nla.gov.au/newspaper/page/24101887 | 24101887 | |
45493 | 45493 | 1927-02-19 | 7 | b | Japan's China policy. | China | http://trove.nla.gov.au/newspaper/page/24101887 | 24101887 | |
45494 | 45494 | 1927-02-19 | 7 | b | Wu Peifu under besieged. | China | http://trove.nla.gov.au/newspaper/page/24101887 | 24101887 | |
45495 | 45495 | 1927-02-19 | 7 | c | Earthquake in Yugoslavia. | Other... | http://trove.nla.gov.au/newspaper/page/24101887 | 24101887 | |
45496 | 45496 | 1927-02-19 | 7 | c-e | Names listed for donations to Dongguan hospital. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101887 | 24101887 |
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]);