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 |
---|---|---|---|---|---|---|---|---|---|
53186 | 53186 | 1933-08-19 | 2 | a | Editorial on the future of Chaha'er province in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53187 | 53187 | 1933-08-19 | 2 | c | Feng Yuxiang reports his fighting with Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53188 | 53188 | 1933-08-19 | 2 | e | Han Fuqu in recent days. | China | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53189 | 53189 | 1933-08-19 | 2 | e | People in Shanghai welcome General Ma Zhanshan and Su Bingwen. | China | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53190 | 53190 | 1933-08-19 | 2 | f | Liu Wenhui leads his troops to the south of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53191 | 53191 | 1933-08-19 | 2 | f | Song Ziwen borrows loans from Britain. | China | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53192 | 53192 | 1933-08-19 | 2 | f | Liu Wenhui is ready to step down. | China | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53193 | 53193 | 1933-08-19 | 3 | a | Resistance to Japanese invasion in north China (by Feng Yuxiang and others). | China | http://trove.nla.gov.au/newspaper/page/24091333 | 24091333 | |
53194 | 53194 | 1933-08-19 | 3 | c | Japanese have totally controlled the railway in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091333 | 24091333 | |
53195 | 53195 | 1933-08-19 | 3 | d | Air defence in Tokyo. | China | http://trove.nla.gov.au/newspaper/page/24091333 | 24091333 | |
53196 | 53196 | 1933-08-19 | 3 | e | The Manchurian state government and the railway administration. | China | http://trove.nla.gov.au/newspaper/page/24091333 | 24091333 | |
53197 | 53197 | 1933-08-19 | 3 | e | Song Ziwen in London. | China | http://trove.nla.gov.au/newspaper/page/24091333 | 24091333 | |
53198 | 53198 | 1933-08-19 | 3 | e | Chinese government to reduce its military forces. | China | http://trove.nla.gov.au/newspaper/page/24091333 | 24091333 | |
53199 | 53199 | 1933-08-19 | 5 | a | Japan's plan to control Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 | |
53200 | 53200 | 1933-08-19 | 5 | c | A letter of love written by Wang Jiefu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 | |
53201 | 53201 | 1933-08-19 | 5 | d | The suicide of Chinese culture. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 | |
53202 | 53202 | 1933-08-19 | 5 | e | Chinese in Wellington, New Zealand, organise an association and the report. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 | |
53203 | 53203 | 1933-08-19 | 7-8 | a-f | Guangdong news/ Li Jishen and Chen Mingshu jointly question He Yingqin. Feng Yuxiang reports his victory. Wong Zhaoyuan to visit Europe for aviation development. Resistance to Japanese invasion. Silk factory collapses in Shunde county. Gambling banned in Guangxi. Battle followed by search of smuggled opium in Dongguan. More train service between Guangzhou and Kowloon. A woman in Shunde murders her husband and father-in-law. | China | http://trove.nla.gov.au/newspaper/page/24091337 | 24091337 | |
53204 | 53204 | 1933-08-19 | 6 | a | Peaceful solution to the Chaha'er issues. | China | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
53205 | 53205 | 1933-08-19 | 6 | a | Japanese army on exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
53206 | 53206 | 1933-08-19 | 6 | c | Dutch colonies restrict entry of immigrants. | Other... | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
53207 | 53207 | 1933-08-19 | 6 | c | Britain manufactures new gas mask. | Britain | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
53208 | 53208 | 1933-08-19 | 6 | c | Army in Cuba involved in revolution. | Other... | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
53209 | 53209 | 1933-08-19 | 6 | e | Australia news/ Total number of population in Australia. Companies are required to report their staff number. Chinese priest killed in a fire in Geelong, Melbourne. Chinese man killed in a tram accident. Cold weather in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 |
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]);