This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52452 | 52452 | 1933-01-28 | 2 | b | Editorial by the Tung Wah Times on the Rehe issues and the motive of Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52453 | 52453 | 1933-01-28 | 2 | c | Soviet Russian government on the resumption of diplomatic relations with China. | Russia | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52454 | 52454 | 1933-01-28 | 2 | c | Central authority orders Chinese troops in Rehe to fight Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52455 | 52455 | 1933-01-28 | 2 | d | Chinese Ministry of Industry to set up big factory in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52456 | 52456 | 1933-01-28 | 2 | d | Chen Guohui is executed in Fujian. Two Korean men are arrested in Changchun for assassination. Japanese encourage independence of Mongolia. Fortification along the Yangtze River. Li Guojie is sentenced to three years' imprisonment in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52457 | 52457 | 1933-01-28 | 2 | f | Russian people welcome Chinese national hero of fighting Japanese. | Russia | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52458 | 52458 | 1933-01-28 | 2 | f | Japanese plan to eliminate Chinese armies in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52459 | 52459 | 1933-01-28 | 2 | f | Liu Wenhui stops fighting in Sichuan. Traitors in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 |
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]);