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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 55327 | 55327 | 1935-08-10 | 3 | d | Italian government has a secret military conference. | Other... | 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 | |
| 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 | |
| 55332 | 55332 | 1935-08-10 | 5 | d | Donations to the Melbourne Chinese School. | Tung Wah | 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 | |
| 55334 | 55334 | 1935-08-10 | 8 | a | A robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
| 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 | |
| 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 | |
| 55337 | 55337 | 1935-08-10 | 8 | b | Expenditure of Japanese navy increases. | Japan | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
| 55338 | 55338 | 1935-08-10 | 8 | b | Russian submarine sinks during an exercise. | Russia | 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 | |
| 55340 | 55340 | 1935-08-10 | 8 | d | Russian troops are ready to enter Mongolia. | China | 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 | |
| 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]);