This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
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 | |
40287 | 40287 | 1923-08-25 | 3 | e | China has cleared its debt with Germany. | America | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
40291 | 40291 | 1923-08-25 | 6 | a-b | Hawaiian authority bans for foreign language schools (Japanese, Chinese, Korean and Russian) and response of the ethnic communities. | America | http://trove.nla.gov.au/newspaper/page/24094524 | 24094524 |
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]);