This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25026 | 25026 | 1911-09-23 | 3 | a | Emperor starts schooling | Emperor starts his schooling. | China | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25027 | 25027 | 1911-09-23 | 3 | a | Famine in Singapore | Singapore suffers a famine due to natural disaster. | Singapore | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25028 | 25028 | 1911-09-23 | 3 | a-b | Chaos again in Sichuan | Another chaos resulted from anti-nationalisation of private railways happened in Sichuan. | China | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25029 | 25029 | 1911-09-23 | 3 | b | No result from China-Morocco negotiation | No result has been achiveed from China's negotiation with Morocco over the compensation of the killing of Chinese there. | Other... | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25030 | 25030 | 1911-09-23 | 3 | b | Russian president is shot | Russian president was shot. | Russia | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25031 | 25031 | 1911-09-23 | 3 | b | China's post office | A French is appointed as chief of China's post office. | Other... | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25032 | 25032 | 1911-09-23 | 3 | b | China's navy | China's navy orders two cruisers from Britain and France and more budget for the navy. | China | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25033 | 25033 | 1911-09-23 | 3 | c | Beijing news | Inspector to Shandong asks for sympathy from imperial cabinet. Department of Ariculture provides more fund for Chinese Tea Association in London for promotion of Chinese tea. The issue of China's tariff ownership. Contributions of Yan Huiqing and Gao Erqian for China's relations with the west. Japanese police is at amuck in Jilin province. | Other... | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25034 | 25034 | 1911-09-23 | 3 | c-d | Guangdong news | The issue of gangsters. Revolutionary activities in Guangdong. The expenses of spies in Hong Kong. The cost of governor's office. Number of police in Guangdong. Gangsters and robberies in Gangming and Qingxiang counties. | Other... | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
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]);