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 | |
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 | |
53199 | 53199 | 1933-08-19 | 5 | a | Japan's plan to control Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53195 | 53195 | 1933-08-19 | 3 | d | Air defence in Tokyo. | China | http://trove.nla.gov.au/newspaper/page/24091333 | 24091333 | |
53201 | 53201 | 1933-08-19 | 5 | d | The suicide of Chinese culture. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);