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 |
---|---|---|---|---|---|---|---|---|---|
53139 | 53139 | 1933-08-05 | 2 | b | Speeches by Jiang Guanglai and Cai Tingkai, commanders of the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24091318 | 24091318 | |
53140 | 53140 | 1933-08-05 | 2 | e | China sets up committee to take over Japanese-occupied territories. | China | http://trove.nla.gov.au/newspaper/page/24091318 | 24091318 | |
53141 | 53141 | 1933-08-05 | 2 | f | Three warships arrive Guangdong from Qingdao. | China | http://trove.nla.gov.au/newspaper/page/24091318 | 24091318 | |
53142 | 53142 | 1933-08-05 | 2 | f | The Nanjing government to develop the border areas of China. | China | http://trove.nla.gov.au/newspaper/page/24091318 | 24091318 | |
53143 | 53143 | 1933-08-05 | 3 | a | The Cooperation Movement in Nanjing and the future of Asia. | China | http://trove.nla.gov.au/newspaper/page/24091317 | 24091317 | |
53144 | 53144 | 1933-08-05 | 3 | a | Feng Yuxiang insists to fight Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091317 | 24091317 | |
53145 | 53145 | 1933-08-05 | 3 | b | Chinese and Japanese delegates meet in Dalian for truce talks. | China | http://trove.nla.gov.au/newspaper/page/24091317 | 24091317 | |
53146 | 53146 | 1933-08-05 | 3 | c | Japanese seek to occupy mineral resources in Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24091317 | 24091317 | |
53148 | 53148 | 1933-08-05 | 3 | e | Chinese financial minister Song Ziwen on the international economic cooperation. | China | http://trove.nla.gov.au/newspaper/page/24091317 | 24091317 | |
53149 | 53149 | 1933-08-05 | 5 | a | The Rehe province in north China under the control of Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091319 | 24091319 | |
53152 | 53152 | 1933-08-05 | 7-8 | a-f | Guangdong news/ Two telegrams issued by the officers and soldiers in north China. Warning by Xiao Focheng. Communist troops are attacking Wuzhou in Guangxi province. Exercise of the airforce troops in Guangdong. Hard life of the fishermen in Hong Kong. Economic crisis in Guangdong. Feng Yuxiang urges the southwest to fight Japanese and to defect Jiang Jieshi. Wong Zhaoyuan arrives Hong Kong unexpectedly. Power people of the commercial chamber in Zengcheng county. Weather changes in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24091321 | 24091321 |
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]);