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