This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25509 | 25509 | 1911-12-30 | 7 | a-b | Australia news | Federal government is to grant fund for officials to inspect different places. Statistics of foreign trade in New South Wales. Perth may nationalise its trams. Governors of six states meets to discuss politics. Black boxers are fighting in Sydney. Statistics of income of Victoria railways. | Australia | http://trove.nla.gov.au/newspaper/page/24092054 | 24092054 |
25510 | 25510 | 1911-12-30 | 7 | b | Census of New Zealand | Census of New Zealand and New Zealand people residing in Sydney. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092054 | 24092054 |
25511 | 25511 | 1911-12-30 | 7 | b | Revolution tide in China | More Guangdong troops join north expedition army. Sun Yatsen is to arrive in Shanghai. Twelve provinces are now belong to revolutionaries. Republic school is to elect Sun Yatsen as president. Shanghai peace negotiation meeting proposes to discuss political system for future government. | China | http://trove.nla.gov.au/newspaper/page/24092054 | 24092054 |
25512 | 25512 | 1911-12-30 | 7 | b | Liang Qicao's letter to Yuan Shikai | Liang Qicao refuses to take office in Yuan's government and suggests Yuan to listen to voice of the people. | China | http://trove.nla.gov.au/newspaper/page/24092054 | 24092054 |
25513 | 25513 | 1911-12-30 | 7 | b | Donations to Hankou people | Statistics of donations to people stricken by wars in Hankou, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24092054 | 24092054 |
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]);