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 |
---|---|---|---|---|---|---|---|---|---|
53831 | 53831 | 1934-02-10 | 2 | a | Editorial on the report by Wang Zhaoming on the situation in Fujian. A copy of Wang Zhaoming's report at the Central Executive Committee meeting in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091527 | 24091527 | |
53834 | 53834 | 1934-02-10 | 3 | a | Fighting in Gutian between Fujian troops and Jiang Jieshi's army. | China | http://trove.nla.gov.au/newspaper/page/24091526 | 24091526 | |
53838 | 53838 | 1934-02-10 | 5 | a | Second part of an open letter from Wu Xianzi to Hu Hanmin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091528 | 24091528 | |
53842 | 53842 | 1934-02-10 | 6 | a | Anti-Russian demonstration in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53843 | 53843 | 1934-02-10 | 6 | a | Earthquake in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53841 | 53841 | 1934-02-10 | 7-8 | a-f | Guangdong news/ Xiao Focheng leaves Hong Kong for Thailand. Zhang Xueliang in Hong Kong on his war back to China. Joint defence of Huiyang, Boluo, Heyuan and other counties. Hu Hanmin on the current situations. Funeral prepared for Wu Chaoshu. A businessmen on the decline of business in Hong Kong. Statistics of China's foreign trade in 1933. | China | http://trove.nla.gov.au/newspaper/page/24091530 | 24091530 | |
53844 | 53844 | 1934-02-10 | 6 | b | The possibility of a Pacific war. | Singapore | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53845 | 53845 | 1934-02-10 | 6 | b | British doctor is kidnapped in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53846 | 53846 | 1934-02-10 | 6 | c | Li Minzhou, businessman returned from Australia and major shareholder of the Sun Sun Company in Shanghai, is assassinated. | China | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53847 | 53847 | 1934-02-10 | 6 | c | Britain encourage to immigrate to Australia. | Britain | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53832 | 53832 | 1934-02-10 | 2 | d | Zhang Xueliang arrives Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091527 | 24091527 | |
53835 | 53835 | 1934-02-10 | 3 | d | The Manchurian state government will move to Rehe. | China | http://trove.nla.gov.au/newspaper/page/24091526 | 24091526 | |
53839 | 53839 | 1934-02-10 | 5 | d | Soviet Russia manufactures new type of train. | Russia | http://trove.nla.gov.au/newspaper/page/24091528 | 24091528 | |
53848 | 53848 | 1934-02-10 | 6 | d | Britain sets up radio station in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53849 | 53849 | 1934-02-10 | 6 | d | America is afraid of that Japan and Russia may start a war soon. | America | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53833 | 53833 | 1934-02-10 | 2 | e | Plan for autonomous administration in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091527 | 24091527 | |
53836 | 53836 | 1934-02-10 | 3 | e | Independence movement in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091526 | 24091526 | |
53837 | 53837 | 1934-02-10 | 3 | e | American President Roosevelt increases price of silver. | America | http://trove.nla.gov.au/newspaper/page/24091526 | 24091526 | |
53850 | 53850 | 1934-02-10 | 6 | e | Security arrangement during the enthroning ceremony. | China | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53851 | 53851 | 1934-02-10 | 6 | f | Australia news/ Gold price in Sydney going up dramatically. Miners on riots in South Australia and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53840 | 53840 | 1934-02-10 | 5 | g | English class in Sydney and its notice of admission. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091528 | 24091528 |
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]);