This data as json, CSV (advanced)
Suggested facets: column
date (date) 4 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10930 | 10930 | 1902-08-16 | 5-6 | b | Two White employees of Chengdu Steamship Company were brought to trial in Sydney for murdering their Chinese colleague on the way from Hong Kong to Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100466 | 24100466 | |
11058 | 11058 | 1902-10-04 | 5-6 | a-b | A further report on how Cai Jun, Chinese ambassador to Japan, helps Japanese police arrest Chinese students in his embassy. | Japan | http://trove.nla.gov.au/newspaper/page/24100503 | 24100503 | |
43426 | 43426 | 1925-07-04 | 5-6 | a-c | Anti-foreign movement in Shanghai, Nanjing, Hefei, Wuhu, Ningbo, Zhenjiang, Chongqing, Hankou, Henan province, Guangzhou, Philippines, and other cities in China. And the influence of the anti-foreign demonstration. | China | http://trove.nla.gov.au/newspaper/page/24101193 | 24101193 | |
45157 | 45157 | 1926-09-18 | 5-6 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101713 | 24101713 |
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]);