This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23946 | 23946 | 1910-12-10 | 3 | a | Guangdong news/ Riots in Lianzhou. Gambling in Guangdong. Police system in Guangzhou. Report on military budget in Guangdong. Foreign ambassadors want to help suppress bandits in Guangdong and Guangxi. Restriction on property purchase by foreigners in Guangzhou. Improvement of sugar industry in China. Renovation of a temple in Foshan costs a lot. Governor Yuan Shuxun donates to an American newspaper. Consul general in Canada Gong Xinzhao reports that Chinese community there has elected candidates for the provincial legislature assembly. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802865 | 26802865 | |
23962 | 23962 | 1910-12-10 | 6 | a | More petition to the establishment of national parliament. | China | http://trove.nla.gov.au/newspaper/page/26802870 | 26802870 | |
23965 | 23965 | 1910-12-10 | 7 | a | Chinese community in Sydney celebrates the decision to establish a national parliament in China in 1914. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802869 | 26802869 | |
23966 | 23966 | 1910-12-10 | 7 | a | Ballot in the state election of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802869 | 26802869 | |
23967 | 23967 | 1910-12-10 | 7 | a | Trade between Britain and Australia in the past nine months. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802869 | 26802869 | |
23968 | 23968 | 1910-12-10 | 7 | a | Population in Western Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802869 | 26802869 | |
23969 | 23969 | 1910-12-10 | 7 | a | More white immigrants to settle in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802869 | 26802869 | |
23978 | 23978 | 1910-12-10 | 8 | a | Revolutionary movement in Portugal and its lesson to us, probably written by Liang Qichao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802872 | 26802872 |
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]);