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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
53837 | 53837 | 1934-02-10 | 3 | e | American President Roosevelt increases price of silver. | America | http://trove.nla.gov.au/newspaper/page/24091526 | 24091526 | |
53842 | 53842 | 1934-02-10 | 6 | a | Anti-Russian demonstration in Harbin, Heilongjiang province. | 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 | |
53847 | 53847 | 1934-02-10 | 6 | c | Britain encourage to immigrate to Australia. | Britain | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53848 | 53848 | 1934-02-10 | 6 | d | Britain sets up radio station in Shanghai. | China | 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 | |
53843 | 53843 | 1934-02-10 | 6 | a | Earthquake in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
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 | |
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 | |
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 | |
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 | |
53836 | 53836 | 1934-02-10 | 3 | e | Independence movement in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091526 | 24091526 | |
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 | |
53833 | 53833 | 1934-02-10 | 2 | e | Plan for autonomous administration in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091527 | 24091527 | |
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 | |
53850 | 53850 | 1934-02-10 | 6 | e | Security arrangement during the enthroning ceremony. | China | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53839 | 53839 | 1934-02-10 | 5 | d | Soviet Russia manufactures new type of train. | Russia | http://trove.nla.gov.au/newspaper/page/24091528 | 24091528 | |
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 | |
53844 | 53844 | 1934-02-10 | 6 | b | The possibility of a Pacific war. | Singapore | 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 |
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]);