This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52424 | 52424 | 1933-01-21 | 2 | a | Editorial on the help from Heaven and the self-help during China's resistance to Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52425 | 52425 | 1933-01-21 | 2 | b | Chinese delegate Yan Huiqing speaks at the League of Nations conference. | Other... | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52426 | 52426 | 1933-01-21 | 2 | c | Japanese troops in Manchuria are enlisting more soldiers. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52427 | 52427 | 1933-01-21 | 2 | d | Yan Huiqing on the resumption of diplomatic relations between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52428 | 52428 | 1933-01-21 | 2 | d | Russian government permits Chinese General Su Bingwen to stay for the time being. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52429 | 52429 | 1933-01-21 | 2 | d | Proposals by Sun Ke, Song Ziwen, Wu Tiecheng and others to fighting Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52430 | 52430 | 1933-01-21 | 2 | e | Chinese foreign minister Luo Wengan reports recent relations between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52431 | 52431 | 1933-01-21 | 2 | e | Zheng Xiaoxu supports a restoration. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52432 | 52432 | 1933-01-21 | 2 | f | Jiang Jieshi, Hu Hanmin, Wang Jingwei and others become members of the Standing Committee of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52433 | 52433 | 1933-01-21 | 2 | f | American President Roosevelt and his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52434 | 52434 | 1933-01-21 | 2 | f | Panchen Lama on the situations in Tibet. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52435 | 52435 | 1933-01-21 | 2 | f | Central authority in Nanjing provides munitions to Guangdong and Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
52436 | 52436 | 1933-01-21 | 2 | f | Cheng Guorui and his traitor activities. | China | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 |
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]);