This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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]);