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 |
|---|---|---|---|---|---|---|---|---|---|
| 56463 | 56463 | 1936-12-05 | 2 | b | Teachers and students in Beijing are determined to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097085 | 24097085 | |
| 56464 | 56464 | 1936-12-05 | 2 | d | China news/ Han Fuqu on the way to meet Jiang Jieshi in Hangzhou. There are 2.6 million opium smokers registered nation-wide. The national congress is postponed. Grain prices going up in China. Jiang Jieshi flies to Xi'an to personally command the suppression of Chinese Communist troops. China and Japan have nearly conclude their treaty talks. | China | http://trove.nla.gov.au/newspaper/page/24097085 | 24097085 | |
| 56465 | 56465 | 1936-12-05 | 3 | a | British newspaper reports the resistance in China to Japanese invasion. | Britain | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 | |
| 56466 | 56466 | 1936-12-05 | 3 | a | Mussolini seeks to eradicate the Soviet Union influence in Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 | |
| 56467 | 56467 | 1936-12-05 | 3 | a | China orders cannons from Britain and Germany. | China | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 | |
| 56468 | 56468 | 1936-12-05 | 3 | b | Hundreds of people are arrested in Taiwan for attempt to overthrow the current government. | Japan | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 | |
| 56469 | 56469 | 1936-12-05 | 3 | b | German newspaper on the relations between China and Japan. | Germany | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 | |
| 56470 | 56470 | 1936-12-05 | 3 | b | American navy to have exercise in the Pacific. | China | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 | |
| 56471 | 56471 | 1936-12-05 | 3 | d | Japanese goods in the Nanyang area are replacing British goods. | Singapore | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 | |
| 56472 | 56472 | 1936-12-05 | 5 | b | Second part of a report on Guilin, new capital of Guangxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097086 | 24097086 | |
| 56473 | 56473 | 1936-12-05 | 5 | c | Li Zongren and Bai Chongxi and their impacts on the development in Guangxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097086 | 24097086 | |
| 56474 | 56474 | 1936-12-05 | 6-7 | a-d | Guangdong news/ Sun Ke in Guangdong. The assassination of Yang Yongtai and its influence. Students of Zhongshan University mourns their school mates who are killed in the demonstration. Guangxi provincial authority to develop the mountains. Huang Musong to govern Hubei province. Japanese in south China. Bandits in Taishan, Zengcheng and Gaoyao. Land tax in Panyu and the plea for reform. | China | http://trove.nla.gov.au/newspaper/page/24097089 | 24097089 | |
| 56475 | 56475 | 1936-12-05 | 8 | a | The Nanjing government orders to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097091 | 24097091 | |
| 56476 | 56476 | 1936-12-05 | 8 | b | Japanese troops to occupy Suiyuan province. | China | http://trove.nla.gov.au/newspaper/page/24097091 | 24097091 | |
| 56477 | 56477 | 1936-12-05 | 8 | b | American authority destroy drugs. | America | http://trove.nla.gov.au/newspaper/page/24097091 | 24097091 | |
| 56478 | 56478 | 1936-12-05 | 8 | b | Berlin reveals the treaty signed between Germany and Japan and the international response. | Britain | http://trove.nla.gov.au/newspaper/page/24097091 | 24097091 | |
| 56479 | 56479 | 1936-12-05 | 8 | f | Australia news/ Sydney newspaper criticises Chinese vegetable pedlars. New South Wales to have five dollar notes. Chinese murderer not to be bailed. Chinese man is arrested for illegal immigration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097091 | 24097091 |
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]);