This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16940 | 16940 | 1907-02-09 | 8 | a | Message from Huang Houcheng, envoy of Chinese government, to the Chinese communities in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801230 | 26801230 | |
16941 | 16941 | 1907-02-09 | 8 | a | Tung Wah Times calls for donations to the flooding and famine victims of north Jiangsu and Anhui provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801230 | 26801230 | |
16942 | 16942 | 1907-02-09 | 8 | a-c | Comments on the building of superstitious alter in Guangzhou, selected from a Guangzhou newspaper yue bao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801230 | 26801230 | |
16943 | 16943 | 1907-02-09 | 8 | c-d | Jokes. Misunderstanding between father and son. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801230 | 26801230 | |
16944 | 16944 | 1907-02-09 | 8 | c-d | Chinese Empire Reform Association calls for donation from its members to build the headquarters in Guangzhou, China. Draft picture of the proposed headquarters of the Chinese Empire Reform Association that to be built in Guangzhou, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801230 | 26801230 |
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]);