This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35753 | 35753 | 1920-05-29 | 7 | a | Message by Song Dongping advises fellows passengers not to carry weapons when leaving Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098180 | 24098180 | |
35754 | 35754 | 1920-05-29 | 7 | a-b | Australia news/ A woman in Waterloo, Sydney, is penalised for wearing men's clothes. Chinese Chamber of Commerce in New South Wales writes to the state authority for the sale of rice at Chinese shops. A letter to Wei Zijing, Chinese Consul-General in Australia from the representatives of the Chinese communities in Sydney (Huang Zhu on behalf of zhi gong tang, Guo Shun on behalf of the Chinese Chamber of Commerce, Yu Rong on behalf of the Nationalist Party or Guomindang, Zheng Fanchang on behalf of the Constitutionalist Association or xian zheng dang, Li Chun on behalf of Xiangshan county fellows, Ye Bingnan on behalf of Zengcheng fellows, Zhao Peichang on behalf of si yi fellows, Chen Zhuchen on behalf of Dongguan fellows, and Cai Rong on behalf of Gaoyao fellows.) | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098180 | 24098180 | |
35755 | 35755 | 1920-05-29 | 7 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098180 | 24098180 | |
35756 | 35756 | 1920-05-29 | 7 | b | A special notice jointly issued by Dongguan gong yi tang and Zengcheng lian fu tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098180 | 24098180 |
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]);