This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36119 | 36119 | 1920-09-18 | 2 | a-c | First part of the comments by Liang Qichao on the self-defence of ordinary people. | China | http://trove.nla.gov.au/newspaper/page/24098313 | 24098313 | |
36120 | 36120 | 1920-09-18 | 2 | c | Tung Wah Times comments on the restoration of old system in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098313 | 24098313 | |
36121 | 36121 | 1920-09-18 | 2 | d | Orders issued by the Chinese President Xu Shichang. | China | http://trove.nla.gov.au/newspaper/page/24098313 | 24098313 | |
36122 | 36122 | 1920-09-18 | 2 | e | Zhang Yilin on the proposed national conference of Chinese citizens. | China | http://trove.nla.gov.au/newspaper/page/24098313 | 24098313 | |
36123 | 36123 | 1920-09-18 | 3 | a | Wu Peifu suggests to dissolve the old parliament. | China | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36124 | 36124 | 1920-09-18 | 3 | a | Brief biography of Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36125 | 36125 | 1920-09-18 | 3 | b | A report on the peace talks in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36126 | 36126 | 1920-09-18 | 3 | b | Recent relations between Sun Yatsen, Tang Shaoyi and Wu Tingfang. | China | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36127 | 36127 | 1920-09-18 | 3 | c | Yunnan people refuse Li Liejun. | China | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36128 | 36128 | 1920-09-18 | 3 | c | Restoration of old system in China and the rumours. | America | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36129 | 36129 | 1920-09-18 | 3 | d | Hundreds of Chinese enter the Philippines illegally. | America | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36130 | 36130 | 1920-09-18 | 3 | d | Business in Siberia. | America | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36131 | 36131 | 1920-09-18 | 3 | d | Chinese authorities raise funds for the disaster relief. | Britain | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36132 | 36132 | 1920-09-18 | 3 | d | Report on the famine in China. | America | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36133 | 36133 | 1920-09-18 | 3 | d | Japan withdraws its troops from Siberia. | America | http://trove.nla.gov.au/newspaper/page/24098312 | 24098312 | |
36134 | 36134 | 1920-09-18 | 6 | a | Poems by Zhou Fengzhen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098317 | 24098317 | |
36135 | 36135 | 1920-09-18 | 6 | b | Guangdong army are attacking Fujian and the report. | China | http://trove.nla.gov.au/newspaper/page/24098317 | 24098317 | |
36136 | 36136 | 1920-09-18 | 7 | a-c | Australia news/ Thoughts on the birthday of Confucius. Guo Shun farewells friends in Sydney on his return to China and the attendants include Deng Weixi, Li Jindong, Huang Zhu, Yu Rong, Zhou Rongwei, Song Dongping, Lin Dasan, Li Ziyun, Zheng Fanchang, Wu Elou and others. Farewell to Guo Shun in Sydney. A man is arrested in Sydney for sodomy. Another arrest in Sydney for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098316 | 24098316 | |
36137 | 36137 | 1920-09-18 | 7 | c | Farewell message by Guo Shun on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098316 | 24098316 | |
36138 | 36138 | 1920-09-18 | 8 | a-c | Guangdong news/ Provincial legislature assembly is dissolved. Bandits in Zengcheng county. Robbery in Xiangshan county. Nanhai county authority arrests revolutionary activist. Bandits in Dongguan county. Storm in Deqing, Gaoyao and other areas. A woman in Guangzhou is found adultery. | China | http://trove.nla.gov.au/newspaper/page/24098319 | 24098319 |
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]);