This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
40325 | 40325 | 1923-09-01 | 3 | d | American government will not change its China policy. | America | http://trove.nla.gov.au/newspaper/page/24094527 | 24094527 |
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]);