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 |
---|---|---|---|---|---|---|---|---|---|
52581 | 52581 | 1933-02-25 | 2 | c | Japanese army in Shanghai have an exercise. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52582 | 52582 | 1933-02-25 | 2 | c | Soviet Russia prepares for a war. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52584 | 52584 | 1933-02-25 | 2 | d | Civilians in Beijing organise a self-defence committee. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52585 | 52585 | 1933-02-25 | 2 | d | Rice production in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52586 | 52586 | 1933-02-25 | 2 | e | The Council of Administration in Nanjing issue new regulations on military secrets. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52587 | 52587 | 1933-02-25 | 2 | f | Chinese agricultural authority encourages farming. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52588 | 52588 | 1933-02-25 | 2 | f | Royalties in Mongolia request to remove Shi Qingyang. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52589 | 52589 | 1933-02-25 | 2 | f | Wang Delin leads his troops retreat into Russia. | China | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52591 | 52591 | 1933-02-25 | 3 | a | The war in Yuguan between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091129 | 24091129 | |
52595 | 52595 | 1933-02-25 | 7-8 | a-e | Guangdong news/ Li Zongren on the resistance to Japanese invasion. A national defence committee set up in the southwest of China. Troops from the southwest on the way to fight Japanese in north China. Tang Yulin reports Japanese invasion of Kaifeng and Shandong. Military officers in Guizhou province want to fight Japanese invaders in the north. Snow in the Luofu Mountain. Business in Zhaoqing last year. Chen Yong'an sue Tang Shaoyi, magistrate of the Zhongshan county. | China | http://trove.nla.gov.au/newspaper/page/24091133 | 24091133 |
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]);