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 |
---|---|---|---|---|---|---|---|---|---|
52740 | 52740 | 1933-04-08 | 2 | b | Liu Chongjie presents awards to the army units in north China. | China | http://trove.nla.gov.au/newspaper/page/24091180 | 24091180 | |
52741 | 52741 | 1933-04-08 | 2 | f | Yan Xishan reports his troops have arrived Rehe. Feng Yuxiang may enter Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24091180 | 24091180 | |
52742 | 52742 | 1933-04-08 | 3 | a | Battles in north China between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091179 | 24091179 | |
52743 | 52743 | 1933-04-08 | 3 | c | Tang Yulin troops retreat without fighting. | China | http://trove.nla.gov.au/newspaper/page/24091179 | 24091179 | |
52744 | 52744 | 1933-04-08 | 3 | e | Britain denies any knowledge of Japanese invasion of Rehe in north China. | China | http://trove.nla.gov.au/newspaper/page/24091179 | 24091179 | |
52746 | 52746 | 1933-04-08 | 5 | a | Japanese respect Jiang Jieshi and Cai Tingkai. | China | http://trove.nla.gov.au/newspaper/page/24091181 | 24091181 | |
52749 | 52749 | 1933-04-08 | 7-8 | a-f | Guangdong news/ A meeting on national defence in Guangzhou. Authorities in north China plea for help from Guangdong and the response. Zhu Qinglan sends another telegram to Guangdong for help. Preparation in the southwest for troops departure to fight Japanese in north China. Chen Jitang sets up a model rehabilitation centre. Second Unit of the airforce troops are ready to enter Jiangxi province. Japanese economy collapses. Local security troops must be under the commander of the county authority, an order issued by the provincial government. Businessmen in Macao and their manipulation of currency in Guangdong. Foreign business in Guangdong. Disputes solved between China and Portugal over the Hengqin island. Police in Guangzhou close a newspaper. Guangdong to have an airforce unit. Vietnam reduce rice tariff. | China | http://trove.nla.gov.au/newspaper/page/24091183 | 24091183 |
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]);