This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21171 | 21171 | 1909-06-19 | 3 | b | The officialdom in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
21191 | 21191 | 1909-06-19 | 7 | b | Chinese man Miu Yang, of Sydney, is sentenced to nine months' prison for killing a white man by accident. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802225 | 26802225 | |
21192 | 21192 | 1909-06-19 | 7 | b | Chinese community in Sydney welcomes Liang Lanxun, Chinese consul general in Melbourne. Liang Lanxun speaks to the gathering and other speakers include Ye Bingnan, Cai Xing, Li Chun, Xian Junhao, Wu Shihua, Zheng Fanchang, Zhou Rongwei and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802225 | 26802225 | |
21193 | 21193 | 1909-06-19 | 7 | b | Letter from reader Huang Luqi on discrimination against Chinese migrants in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802225 | 26802225 | |
21198 | 21198 | 1909-06-19 | 8 | b | Fourth part of the report on election of members of the Guangdong legislature assembly (qualifications, election procedure and others). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802228 | 26802228 |
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]);