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 |
---|---|---|---|---|---|---|---|---|---|
55334 | 55334 | 1935-08-10 | 8 | a | A robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55341 | 55341 | 1935-08-10 | 8 | d | A cartoon picture published in an American newspaper. | America | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55336 | 55336 | 1935-08-10 | 8 | a | British army start to use new machine guns. | Britain | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55339 | 55339 | 1935-08-10 | 8 | c | League of Nations fails to mediate conflict between Italy and Algeria. | Britain | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55321 | 55321 | 1935-08-10 | 2 | b | Report on Japanese invasion of north China. | China | http://trove.nla.gov.au/newspaper/page/24096529 | 24096529 | |
55322 | 55322 | 1935-08-10 | 2 | b | Floods of the Yangtze River in China and the report. | China | http://trove.nla.gov.au/newspaper/page/24096529 | 24096529 | |
55323 | 55323 | 1935-08-10 | 2 | f | Banquets at the Fujian provincial government. | China | http://trove.nla.gov.au/newspaper/page/24096529 | 24096529 | |
55325 | 55325 | 1935-08-10 | 3 | a | Economic cooperation between Japan and Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096528 | 24096528 | |
55326 | 55326 | 1935-08-10 | 3 | c | Japanese economic invasion of Inner Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096528 | 24096528 | |
55330 | 55330 | 1935-08-10 | 3 | e | Pope in Rome prays for the peace in China. | China | http://trove.nla.gov.au/newspaper/page/24096528 | 24096528 | |
55331 | 55331 | 1935-08-10 | 5 | a | Comments selected from the New Life Weekly in Shanghai on Japanese invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24096530 | 24096530 | |
55333 | 55333 | 1935-08-10 | 6-7 | a-f | Guangdong news/ Zou Lu encourages graduates of Zhongshan University to save China. The First Group Army to discharge some soldiers. Jiahua Bank in Guangdong to resume its business. Guangdong provincial Overseas Chinese Commission to dispatch envoys and appease overseas Chinese communities. A female martial arts master in Guangzhou. Public Security in Guangzhou executes bandits. Guangdong's foreign trade and the value of Hong Kong currency. Many fabrics shops are closed down in Guangzhou. Gaoming county magistrate reports the floods. Famine in Zhongshan county. Bandits in Taishan. | China | http://trove.nla.gov.au/newspaper/page/24096533 | 24096533 | |
55335 | 55335 | 1935-08-10 | 8 | a | The Chinese Communist Party also claims to resist Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55340 | 55340 | 1935-08-10 | 8 | d | Russian troops are ready to enter Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55324 | 55324 | 1935-08-10 | 3 | a | Japanese report on the resistance of Chinese armies in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24096528 | 24096528 | |
55328 | 55328 | 1935-08-10 | 3 | e | New dispute between Russia and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096528 | 24096528 | |
55329 | 55329 | 1935-08-10 | 3 | e | Japanese Cultural Minister proposes cooperation with China. | Japan | http://trove.nla.gov.au/newspaper/page/24096528 | 24096528 | |
55337 | 55337 | 1935-08-10 | 8 | b | Expenditure of Japanese navy increases. | Japan | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55327 | 55327 | 1935-08-10 | 3 | d | Italian government has a secret military conference. | Other... | http://trove.nla.gov.au/newspaper/page/24096528 | 24096528 | |
55338 | 55338 | 1935-08-10 | 8 | b | Russian submarine sinks during an exercise. | Russia | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55332 | 55332 | 1935-08-10 | 5 | d | Donations to the Melbourne Chinese School. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096530 | 24096530 | |
55342 | 55342 | 1935-08-10 | 8 | e | Australia news/ Achievements of the Chinese Chamber of Commerce in New South Wales. Sydney has a cold winter. Chinese magician Wang Caixin and his performance in Sydney. Advertisement of the Mick Simmons Ltd in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 |
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]);