This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36111 | 36111 | 1920-09-11 | 7 | a-b | Australia news/ Chinese Consul-General Wei Zijing writes to the Chinese Chamber of Commerce in Sydney on the visa requirements (of the Australian government) for Chinese arrivals. Japan takes over from Germany some Pacific islands. Labour Party in Sydney fights for the 44-hours work per week. Chinese Chamber of Commerce farewells Guo Shun, who is going to visit Zhejiang on behalf of the Australian Chinese community, Deng Weixi and Li Jindong, and attendants include Chen Zhuchen, Ye Bingnan, Lin Dasan, Liu Ruxing, Ye Tonggui, Zheng Fanchang, Luo Run, Guo Jianying, Ma Xinsi, Wu Zhaoquan, Zhang Fu, Peng Lichuan, Liu Guangfu and Wu Elou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098306 | 24098306 | |
36112 | 36112 | 1920-09-11 | 7 | d | Farewell message by Deng Weixi on his returning to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098306 | 24098306 | |
36113 | 36113 | 1920-09-11 | 7 | a-c | Advertisement for China Trading Company, 54 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098306 | 24098306 |
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]);