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 |
---|---|---|---|---|---|---|---|---|---|
15162 | 15162 | 1905-12-23 | 2 | c | A telegram from See Yup Society and Chinese communities in Melbourne to Beijing Chinese department of foreign affairs and Liang Zhendong, Chinese ambassador to Washington, to protest against American immigration policy that to ban Chinese immigrants. A letter from Chinese community in Cairns, Queensland, also on this matter. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800859 | 26800859 | |
15186 | 15186 | 1905-12-23 | 6 | c | Donations from Chinese community in Gladstone, Queensland, for the protest movement against American immigration policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800863 | 26800863 | |
15187 | 15187 | 1905-12-23 | 6 | c | Kang Youwei's poems when travelling across the Atlantic Ocean for the second time. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800863 | 26800863 | |
15188 | 15188 | 1905-12-23 | 6 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800863 | 26800863 | |
15189 | 15189 | 1905-12-23 | 6 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800863 | 26800863 |
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]);