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 |
---|---|---|---|---|---|---|---|---|---|
53090 | 53090 | 1933-07-22 | 2 | c | Yang Xingfo is assassinated in Shanghai. The Chinese Civil Rights Protection Alliance in Shanghai, Song Qingling and Cai Yuanpei. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53091 | 53091 | 1933-07-22 | 2 | d | Budget prepared by the Nanjing government for 1933. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53092 | 53092 | 1933-07-22 | 2 | d | Japanese troops are withdrawing. The battlefields in Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53093 | 53093 | 1933-07-22 | 2 | f | The last words of Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53094 | 53094 | 1933-07-22 | 2 | f | China starts to manufacture planes. | China | http://trove.nla.gov.au/newspaper/page/24091302 | 24091302 | |
53095 | 53095 | 1933-07-22 | 3 | a | Japanese invasion of China and their cost. | China | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53096 | 53096 | 1933-07-22 | 3 | b | The world economic conference in Washington and the speeches. | China | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53099 | 53099 | 1933-07-22 | 3 | e | Muslims in Xinjiang and their independence movement. | China | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53101 | 53101 | 1933-07-22 | 5 | c | Sun Dianying and his resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091303 | 24091303 | |
53104 | 53104 | 1933-07-22 | 7-8 | a-f | Guangdong news/ The opposition to Jiang Jieshi in the southwest. Cai Tingkai organises a spy unit. The Southwest Foreign Affairs Association refuses to recognise the Nanjing government. Local courts and its operation in Guangdong. Civil corps in Guangdong and Guangxi. Zhang Yan reports that his troops have arrived Shaoguan. Many soldiers request to leave the 19th Route Army. Xiao Focheng warns Wang Zhaoming. Huang Jie to return to Guangzhou. The communists troops leave Xunwu in Jiangxi province. Import of agricultural products to Manchuria banned. Journalists detained in Guangzhou. An old woman remarries in Enping county. Japanese envoy meets Wang Jingwei. Aircraft factory in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24091305 | 24091305 |
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]);