This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40163 | 40163 | 1923-07-28 | 6 | b-c | The China Mail Line Company Ltd, established by Chinese businessmen in America, is bankrupt, and its liner Nile has been auctioned. | America | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
40173 | 40173 | 1923-07-28 | 7 | b-c | Zhi gong tang in Sydney celebrates the birthday of Huang Zhu, chairman of the association. Speakers include Tang Longxiang, Li Xiangbo, Ye Tonggui, Peng Lichuan, Wu Elou, Wu Gen, Lin Dasan and many white people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 |
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]);