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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
56359 | 56359 | 1936-10-24 | 8 | e | Japanese smuggle Australian wool. | 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 | |
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 | |
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 | |
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 | |
56360 | 56360 | 1936-10-24 | 8 | f | The Chinese communist troops in Shaanxi province. | Britain | http://trove.nla.gov.au/newspaper/page/24097042 | 24097042 | |
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 | |
56354 | 56354 | 1936-10-24 | 8 | a | Typhoon in the Philippines and the casualties. | Other... | 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]);