This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39260 | 39260 | 1923-01-13 | 3 | a | A notice issued by the Chinese consulate in Mexico on the Chinese immigration to Mexico, family reunion, new application for business or study in Mexico and other matters. | America | http://trove.nla.gov.au/newspaper/page/24094251 | 24094251 | |
39270 | 39270 | 1923-01-13 | 7 | a | A letter from Jin Boshun and Wang Zuyao, of the Zhejiang Commercial association in Hangzhou, and Lu Yongxiang and Shen Jinjian, of the Zhejiang government, appeals for help to the flooding victims in Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 |
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]);