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 |
---|---|---|---|---|---|---|---|---|---|
49612 | 49612 | 1930-10-25 | 2 | b | Second part of a letter from Zhang Junmai to Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24099822 | 24099822 | |
49613 | 49613 | 1930-10-25 | 2 | d | Miscellaneous report on the war of warlords in China. | China | http://trove.nla.gov.au/newspaper/page/24099822 | 24099822 | |
49614 | 49614 | 1930-10-25 | 3 | a | Dethroned emperor of Qing dynasty Puyi offers sacrifices to the East Graves. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
49615 | 49615 | 1930-10-25 | 3 | a | Another court hearing to be organised for the case of Liu Jiwen. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
49616 | 49616 | 1930-10-25 | 3 | b | War planes from Nanjing to bomb Zhengzhou, capital of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
49617 | 49617 | 1930-10-25 | 3 | b | Report from the battle field in the east of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
49618 | 49618 | 1930-10-25 | 3 | d | Movement in Hunan province to suppress the Communists. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
49619 | 49619 | 1930-10-25 | 3 | e | Wang Zhengting reports the foreign affairs. | China | http://trove.nla.gov.au/newspaper/page/24099821 | 24099821 | |
49621 | 49621 | 1930-10-25 | 6-7 | a-d | Guangdong news/ Police in Guangzhou search and arrest communist members. Why the Huangpu Military Academy is closed and the true causes. Butchers request to be exempt from exorbitant taxes. Monopoly of sales of human droppings and urine. News on the Guangxi army. Chen Jitang sets up an engineering troops. Insect pest in the Beijiang area. Taishan county convenes a joint defence conference. Bandits loot villages. A case of murder in Zengcheng. Zhongshan county authority takes over the sand land bureau. Bandits in Zhongshan. Silly woman in Xinhui gives birth to a snake. Nanhai county abolish government bonds. Superstitious books burned in Yangjiang county. New market in Heshan county. | China | http://trove.nla.gov.au/newspaper/page/24099826 | 24099826 | |
49624 | 49624 | 1930-10-25 | 8 | b | Two female British missionaries are murdered in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
49625 | 49625 | 1930-10-25 | 8 | b | American missionary is kidnapped in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
49630 | 49630 | 1930-10-25 | 8 | d | Communists kidnap foreign missionaries in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 |
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]);