This data as json, CSV (advanced)
Suggested facets: page, column, source, 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 | |
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 | |
53785 | 53785 | 1934-01-20 | 5 | a | Third and final part of greetings by Tung Wah Times on the occasion of New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091504 | 24091504 | |
53788 | 53788 | 1934-01-20 | 6 | a | Japan has built a submarine for inland rivers. | Japan | http://trove.nla.gov.au/newspaper/page/24091507 | 24091507 | |
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 | |
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 | |
53790 | 53790 | 1934-01-20 | 6 | b | Political reform in Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24091507 | 24091507 | |
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 | |
53780 | 53780 | 1934-01-20 | 3 | d | Japanese cabinet has finalised its new foreign policy. | Japan | http://trove.nla.gov.au/newspaper/page/24091502 | 24091502 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53778 | 53778 | 1934-01-20 | 2 | f | The second declaration issued by Fujian government. | China | http://trove.nla.gov.au/newspaper/page/24091503 | 24091503 | |
53782 | 53782 | 1934-01-20 | 3 | f | Japanese navy on exercise. | Japan | 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 | |
53793 | 53793 | 1934-01-20 | 6 | f | Soviet Russia applies to join the League of Nations. | Britain | http://trove.nla.gov.au/newspaper/page/24091507 | 24091507 | |
53794 | 53794 | 1934-01-20 | 6 | f | Australia news/ New tax on wheat flour in China and its impact on Australian export. Chinese houses in Ballarat, Victoria, are set on fire and a further report. | Tung Wah | 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]);