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 |
---|---|---|---|---|---|---|---|---|---|
53773 | 53773 | 1934-01-20 | 2 | a | First part of an open letter from Hu Hanmin on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24091503 | 24091503 | |
53774 | 53774 | 1934-01-20 | 2 | d | Candidates for the governor of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091503 | 24091503 | |
53775 | 53775 | 1934-01-20 | 2 | d | Nanjing government sends more warplanes to Hangzhou. | China | http://trove.nla.gov.au/newspaper/page/24091503 | 24091503 | |
53776 | 53776 | 1934-01-20 | 2 | e | Military officers in north China seek to overthrow Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24091503 | 24091503 | |
53777 | 53777 | 1934-01-20 | 2 | e | Chinese government to collect inheritance tax. | China | http://trove.nla.gov.au/newspaper/page/24091503 | 24091503 | |
53778 | 53778 | 1934-01-20 | 2 | f | The second declaration issued by Fujian government. | China | http://trove.nla.gov.au/newspaper/page/24091503 | 24091503 | |
53779 | 53779 | 1934-01-20 | 3 | a | Mao Weishou leads his troops to Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24091502 | 24091502 | |
53781 | 53781 | 1934-01-20 | 3 | e | Japanese warships are leaving Shanghai and Taiwan for the coast of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091502 | 24091502 | |
53783 | 53783 | 1934-01-20 | 3 | e | Russian planes spy over Manzhouli. | China | http://trove.nla.gov.au/newspaper/page/24091502 | 24091502 | |
53784 | 53784 | 1934-01-20 | 3 | f | Japanese build two airports in Manchuria. Russian build a secret airport in Chita. Manchurian state government recruits soldiers for Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091502 | 24091502 | |
53786 | 53786 | 1934-01-20 | 5 | e | Chen Jitang proposes to resume memorial ceremony service on the birthday of Confucius. | China | http://trove.nla.gov.au/newspaper/page/24091504 | 24091504 | |
53787 | 53787 | 1934-01-20 | 7-8 | a-f | Guangdong news/ Zhang Ji arrives Hong Kong. Reorganisation of police forces in Guangzhou. Water projects in Guangzhou and the agricultural production. Xiao Focheng to return to Thailand. Delegation of Chinese businessmen from Hong Kong comes to visit Australia. Market for Chinese products in the Nanyang area. | China | http://trove.nla.gov.au/newspaper/page/24091506 | 24091506 | |
53789 | 53789 | 1934-01-20 | 6 | a | Chinese government imposes new tax on wheat flour. | China | http://trove.nla.gov.au/newspaper/page/24091507 | 24091507 | |
53790 | 53790 | 1934-01-20 | 6 | b | Political reform in Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24091507 | 24091507 | |
53791 | 53791 | 1934-01-20 | 6 | d | The war in Fujian province and the fall of Fuzhou. | China | http://trove.nla.gov.au/newspaper/page/24091507 | 24091507 | |
53792 | 53792 | 1934-01-20 | 6 | e | Sun Dianying leads his troops to attack Ningxia. | China | http://trove.nla.gov.au/newspaper/page/24091507 | 24091507 |
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]);