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 | |
| 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 | |
| 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 | |
| 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 | |
| 53782 | 53782 | 1934-01-20 | 3 | f | Japanese navy on exercise. | Japan | 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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]);