This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37783 | 37783 | 1921-10-29 | 7 | a | Australian parliament debates new immigration policy on Australian-born Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37784 | 37784 | 1921-10-29 | 7 | a | Sydney police detain street girls. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37785 | 37785 | 1921-10-29 | 7 | a | The plague in Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37786 | 37786 | 1921-10-29 | 7 | a | A white man hangs himself in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37787 | 37787 | 1921-10-29 | 7 | a-b | A Sydney man is poisoned by a woman. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37788 | 37788 | 1921-10-29 | 7 | b | Burglary of the post office in Yass, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37789 | 37789 | 1921-10-29 | 7 | b | Hailstorm in Moree, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37790 | 37790 | 1921-10-29 | 7 | b-c | News in Brief/ Li Yuanhong seeks to organise a third government in Tianjin. Sichuan troops enter Yichang, Hubei province. Xu Shichang seeks comments on the proposed Lushan conference. Pacific Affairs Association in Shanghai has a meeting. Foreign affairs authority in Beijing comments on the Washington Conference and others. Leader of the Anfu faction is seeking a pardon through bribery. Social response in Beijing to the Shandong problem. Jin Yunpeng is determined to resign while Cao Kun and Zhang Zuolin respond to his decision. Zhang Shaozeng, Wu Peifu, Sun Chuanfang and Zhao Hengti on the proposed Lushan conference. Jiang Zuobin on the self-government in Hubei. Wu Peifu and Tang Jiyao. Battle between Hubei and Sichuan troops in Yichang. | China | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37791 | 37791 | 1921-10-29 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 | |
37792 | 37792 | 1921-10-29 | 7 | d | Chinese Speech Society in Sydney (hua qiao yan shuo hui) to gather and the topic will be 'Freedom and Happiness'. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093738 | 24093738 |
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]);