This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25433 | 25433 | 1911-12-16 | 7 | a-b | Australian news | Call from Hong Kong Donghua hospital asking for donations to Hankou people suffering from war disasters. Donators include Xin Suihe, Wu Shihua, Zhanfu, Gong Lisheng, Chen Xingyuan, Zhen Fanchang and Cai Chang. Sydney Hospital celebrates its 100 anniversary. New German ship owner kind to Chinese. More British immigrants to West Australia. Federal parliament members are to visit North Territory. New York cinema starts showing American movies. | Other... | http://trove.nla.gov.au/newspaper/page/24092038 | 24092038 |
25434 | 25434 | 1911-12-16 | 7 | b | European boxers visit Australia | European boxing champions compete in Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092038 | 24092038 |
25435 | 25435 | 1911-12-16 | 7 | b | British king's coronation in India | British King has his coronation in India with 60,000 people in attendance. | http://trove.nla.gov.au/newspaper/page/24092038 | 24092038 | |
25436 | 25436 | 1911-12-16 | 7 | b | Guangdong military government's notes to all foreign consulates to China | Guangdong military government sends notes to all foreign consulates to China in Guangdong announcing independent as republic government. | Other... | http://trove.nla.gov.au/newspaper/page/24092038 | 24092038 |
25437 | 25437 | 1911-12-16 | 7 | b-c | Northern Expeditionary Army | Northern Expeditionary Army is marching to Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/24092038 | 24092038 |
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]);