This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40310 | 40310 | 1923-09-01 | 2 | a-b | Sports is critical to national strength, editorial by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40311 | 40311 | 1923-09-01 | 2 | b-c | Second and final part of a report on that the Chinese communities in California welcome education delegation from China to the world education conference (zhong hua hui guan, Chinese Chamber of Commerce, Chenzhong Chinese school, Chinese Students Association in California, Chinese Students Association in Stanford University, Chinese Youth Club, St Mary School, and other Chinese associations). | America | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40312 | 40312 | 1923-09-01 | 2 | c-d | Chinese delegation to the world education conference in San Francisco and their proposals. | America | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40313 | 40313 | 1923-09-01 | 2 | c-d | Population of the world. | Germany | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40314 | 40314 | 1923-09-01 | 2 | d | Hong Kong businessmen He Dong suggests for a unified China and response of different political parties including Sun Yatsen. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40315 | 40315 | 1923-09-01 | 2 | d | Chinese communities in Nanyang issue a public statement and attack Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40316 | 40316 | 1923-09-01 | 2 | d-e | Japanese provide weapon and other assistance to the bandits in China. | Japan | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40317 | 40317 | 1923-09-01 | 2 | e | Qi Xieyuan denies any donations to the presidential election. | China | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40318 | 40318 | 1923-09-01 | 2 | e-f | Liu Xianshi denies any banditry in Guiyang, capital of Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40319 | 40319 | 1923-09-01 | 2 | f | Zhang Qihuang becomes new governor of Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 |
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]);