This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41812 | 41812 | 1924-07-12 | 7 | a | Xia Congzhou reports from Hong Kong the heavy flooding in Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41813 | 41813 | 1924-07-12 | 7 | a | Zhi Gong Tang in Sydney farewells Tang Longxiang on his return to China. And speakers include Huang Zhu, Wu Gen, Wu Elou, Ye Bingnan, Liu Guangfu, Li Xiangbo, Peng Lichuan, Tang Longxiang and white guests. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41814 | 41814 | 1924-07-12 | 7 | b | Sydney Chinese communities farewell Tang Longxiang, Ye Tonggui, Ye Bingnan and Huang Zaihong, who are returning to China by Victoria, passenger liner of the China-Australia Steamship Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41815 | 41815 | 1924-07-12 | 7 | b | State government of New South Wales and the Salvation Army help the unemployed and homeless people in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41816 | 41816 | 1924-07-12 | 7 | b | Body of baby girl is found in Manly, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41817 | 41817 | 1924-07-12 | 7 | b | Three bandits are detained for trying to steal a car owned by Chilean consul. | Australia | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41818 | 41818 | 1924-07-12 | 7 | b | Dozens of Chinese and white gamblers are arrested in Little Bourke Street, Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41819 | 41819 | 1924-07-12 | 7 | b-c | Chinese football team arrives Sydney on their way to New Zealand. Chinese communities in Sydney refuse to welcome the football team because they travel by Japanese liner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41820 | 41820 | 1924-07-12 | 7 | c | Guangdong army defeat the united armies in Pinghu area, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
41821 | 41821 | 1924-07-12 | 7 | c | Farewell message by Xu Yaoyuan and Xu Chengjun on the return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 |
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]);