This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40279 | 40279 | 1923-08-25 | 3 | a-b | First 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/24094519 | 24094519 | |
40280 | 40280 | 1923-08-25 | 3 | b | Luo Wengan is found no guilty in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40281 | 40281 | 1923-08-25 | 3 | b-c | Japanese in Changsha, capital of Hunan province, kill Chinese residents and the negotiations. | China | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40282 | 40282 | 1923-08-25 | 3 | d | Flood in Korea. | China | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40283 | 40283 | 1923-08-25 | 3 | d | Chinese government in Beijing has a new treasurer. | China | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40284 | 40284 | 1923-08-25 | 3 | d | Foreign missions in Beijing and their demands for the kidnap of foreign travellers in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40285 | 40285 | 1923-08-25 | 3 | d | America and Mexico resume diplomatic relations. | Canada | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40286 | 40286 | 1923-08-25 | 3 | d-e | Missionary hospital and foreign church are robbed in Shashi, Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40287 | 40287 | 1923-08-25 | 3 | e | China has cleared its debt with Germany. | America | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40288 | 40288 | 1923-08-25 | 3 | e-f | Typhoon in Hong Kong and the casualties. | China | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 |
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]);