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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
53195 | 53195 | 1933-08-19 | 3 | d | Air defence in Tokyo. | China | http://trove.nla.gov.au/newspaper/page/24091333 | 24091333 | |
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 | |
53207 | 53207 | 1933-08-19 | 6 | c | Britain manufactures new gas mask. | Britain | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
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 | |
53206 | 53206 | 1933-08-19 | 6 | c | Dutch colonies restrict entry of immigrants. | Other... | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
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 | |
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 | |
53188 | 53188 | 1933-08-19 | 2 | e | Han Fuqu in recent days. | China | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53199 | 53199 | 1933-08-19 | 5 | a | Japan's plan to control Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 | |
53205 | 53205 | 1933-08-19 | 6 | a | Japanese army on exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
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 | |
53192 | 53192 | 1933-08-19 | 2 | f | Liu Wenhui is ready to step down. | 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 | |
53204 | 53204 | 1933-08-19 | 6 | a | Peaceful solution to the Chaha'er issues. | China | http://trove.nla.gov.au/newspaper/page/24091338 | 24091338 | |
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 | |
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 | |
53191 | 53191 | 1933-08-19 | 2 | f | Song Ziwen borrows loans from Britain. | China | http://trove.nla.gov.au/newspaper/page/24091334 | 24091334 | |
53197 | 53197 | 1933-08-19 | 3 | e | Song Ziwen in London. | 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 | |
53201 | 53201 | 1933-08-19 | 5 | d | The suicide of Chinese culture. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 |
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]);