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 |
---|---|---|---|---|---|---|---|---|---|
52485 | 52485 | 1933-02-04 | 2 | d | Japanese troops attack Heihe in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52486 | 52486 | 1933-02-04 | 2 | d | Japanese transport more weaponry to Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52487 | 52487 | 1933-02-04 | 2 | d | Cai Tingkai sends telegram to the Central Government in Nanjing on the loss of Yuguan. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52488 | 52488 | 1933-02-04 | 2 | d | People in Rehe province start resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52489 | 52489 | 1933-02-04 | 2 | e | Huang Xuchu, chairman of the Guangxi provincial government, leads a delegation to visit Vietnam and the report. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52490 | 52490 | 1933-02-04 | 2 | e | The aftermath in Fujian province following the execution of Chen Guohui. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52491 | 52491 | 1933-02-04 | 2 | f | Korean people fail to assassinate Japanese prime minister. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52492 | 52492 | 1933-02-04 | 2 | f | Sun Ke to publish his comments on the constitutional reform. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52493 | 52493 | 1933-02-04 | 2 | f | Army heroes are awarded in Nanjing for their bravery in fighting Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52494 | 52494 | 1933-02-04 | 2 | f | Earthquake in Gansu province, northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52495 | 52495 | 1933-02-04 | 3 | a | A detailed report on Japanese take-over of Yuguan, and the responses of British, American, French and German governments. | China | http://trove.nla.gov.au/newspaper/page/24091105 | 24091105 | |
52496 | 52496 | 1933-02-04 | 3 | d | Bombs discovered in the skating rink in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091105 | 24091105 | |
52498 | 52498 | 1933-02-04 | 5 | a | A petition from the Chinese soldiers wounded in the war of resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091107 | 24091107 | |
52502 | 52502 | 1933-02-04 | 6-7 | a-f | Guangdong news/ Leaders of the Nationalist Party in Guangzhou on the three-year administrative plan. Municipal government publishes a survey on the population of Guangzhou. Chinese communities in the Philippines donate to help aviation development in China. Commercial representatives meet in Guangzhou for the help to volunteer armies in Manchuria. Government troops in Zhongshan county detain smuggled silver. An old couple in Huiyang county. Seven people die in a fire in Shantou. Gaoyao county government tries to eradicate banditry. Cargo ship sinks in Shunde county. Rice price going up dramatically in Nanxiong county. A fireworks shop in Dongguan on fire and the tragedy. Xinhui county authority closes the hospitality centre for Chinese returned from overseas. Clan fighting in Shunde county. Taishan county authority release some convicts. | China | http://trove.nla.gov.au/newspaper/page/24091110 | 24091110 | |
52506 | 52506 | 1933-02-04 | 8 | b | Japanese authority asks Duan Qirui to seek peace in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091112 | 24091112 |
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]);