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 |
|---|---|---|---|---|---|---|---|---|---|
| 56346 | 56346 | 1936-10-24 | 2 | b | China news/ Japanese military policeman in Hankou are killed. Japanese soldiers in Shanghai. Guangdong troops in Hankou have a car accident. Li Zongren talks about peace in Guangxi. Wong Zhaoyuan is determined to protect the Chinese territory. | China | http://trove.nla.gov.au/newspaper/page/24097036 | 24097036 | |
| 56347 | 56347 | 1936-10-24 | 3 | a | Chinese gathering in New York and their circular telegram to resist Japanese invasion of China. | America | http://trove.nla.gov.au/newspaper/page/24097035 | 24097035 | |
| 56348 | 56348 | 1936-10-24 | 3 | a | Chinese troops in Manchuria form an alliance on the fifth anniversary of Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097035 | 24097035 | |
| 56349 | 56349 | 1936-10-24 | 3 | b | Soviet Russian troops gather on their border with Poland. | Russia | http://trove.nla.gov.au/newspaper/page/24097035 | 24097035 | |
| 56350 | 56350 | 1936-10-24 | 3 | c | British businessmen request to restrict import of foreign products. | Britain | http://trove.nla.gov.au/newspaper/page/24097035 | 24097035 | |
| 56351 | 56351 | 1936-10-24 | 3 | d | The Times in London comments on Japanese new demands to the Chinese government. | Britain | http://trove.nla.gov.au/newspaper/page/24097035 | 24097035 | |
| 56352 | 56352 | 1936-10-24 | 5 | a | Telegrams from the Chinese Constitutionalist Party in America to Li Zongren, Bai Chongxi, Cai Tingkai and Jiang Jieshi. | America | http://trove.nla.gov.au/newspaper/page/24097037 | 24097037 | |
| 56353 | 56353 | 1936-10-24 | 6-7 | a-d | Guangdong news/ Jiang Jieshi seeks to control the 19th Route Army. Jiang Jieshi accepts the requests of Guangxi authority to fight Japanese invaders. Li Zongren and Huang Xuchu arrive Guangzhou. Teachers and students in Guangzhou present their petition to the government. Sales and monopoly of tobacco products in Guangdong. Railway project from Guangzhou to Shantou. The command of Guangxi troops has been finalised. Turbulence in the schools in Zhongshan county. The ban of gambling in Shunde county. | China | http://trove.nla.gov.au/newspaper/page/24097040 | 24097040 | |
| 56354 | 56354 | 1936-10-24 | 8 | a | Typhoon in the Philippines and the casualties. | Other... | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
| 56355 | 56355 | 1936-10-24 | 8 | a | Britain seeks to expand its business in China. | Britain | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
| 56356 | 56356 | 1936-10-24 | 8 | b | Britain seeks to block Japanese occupation of China. | Japan | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
| 56357 | 56357 | 1936-10-24 | 8 | d | Revolution in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
| 56358 | 56358 | 1936-10-24 | 8 | e | Students in Beijing and their demonstration against the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
| 56359 | 56359 | 1936-10-24 | 8 | e | Japanese smuggle Australian wool. | Japan | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
| 56360 | 56360 | 1936-10-24 | 8 | f | The Chinese communist troops in Shaanxi province. | Britain | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
| 56361 | 56361 | 1936-10-24 | 8 | g | Chinese Tennis Club in Sydney to have a dancing party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
| 56362 | 56362 | 1936-10-24 | 8 | g | Chinese businessman in Sydney Guo Cai dies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 |
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]);