This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15803 | 15803 | 1906-06-16 | 6 | a | A message from the Chinese Empire Reform Association in Sydney to its members on the change of membership cards. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 | |
15804 | 15804 | 1906-06-16 | 6 | a | Chinese communities in Cairns, Queensland, have set up a new society chong xin she. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 | |
15805 | 15805 | 1906-06-16 | 6 | a | A census on March 31 in Queensland, and statistics of coloured people in 1905 and 1906, including Chinese, Indian, Japanese, Singaporean, Pacific Islanders, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 | |
15806 | 15806 | 1906-06-16 | 6 | a-b | City council of Ashfield, Sydney, holds a meeting on immigration policy and suggests increasing the number of immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 | |
15807 | 15807 | 1906-06-16 | 6 | b | City council of Waterloo, Sydney, proposes to ban Chinese working overtime or on weekend. Offenders will be punished. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 | |
15808 | 15808 | 1906-06-16 | 6 | b | Eight Chinese are arrested on Elizabeth Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 | |
15809 | 15809 | 1906-06-16 | 6 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 | |
15810 | 15810 | 1906-06-16 | 6 | b | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801006 | 26801006 |
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]);