This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15630 | 15630 | 1906-05-05 | 2 | a-b | Report on the tour of the three Chinese officials Zai Ze, Li Shengduo and Shang Qiheng in the United States. Their speeches to the Chinese Empire Reform Association in St Louis and New York. And their talks with the association members. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800969 | 26800969 | |
15646 | 15646 | 1906-05-05 | 6 | a-b | A census on March 31, 1906 and population statistics in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800973 | 26800973 |
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]);