This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
11426 | 11426 | 1903-01-17 | 3 | b | Sydney Chinese Empire Reform Association holds farewell party for Chen Shou and Xu Zunsan who are leaving for China. Attendants include Liu Ruxing, Xian Junhao, Chen Lianke, Ye Bingnan, Huang Zaixing, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11429 | 11429 | 1903-01-17 | 3 | c | The Chinese opera troupe (yue ju) performs again in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11430 | 11430 | 1903-01-17 | 3 | c | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 |
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]);