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 |
---|---|---|---|---|---|---|---|---|---|
56404 | 56404 | 1936-11-14 | 2 | b | Editorial on the recent diplomatic relations between China and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097060 | 24097060 | |
56405 | 56405 | 1936-11-14 | 2 | d | General Cai Tingkai in Wuzhou of Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24097060 | 24097060 | |
56406 | 56406 | 1936-11-14 | 2 | e | Japanese soldiers in Shanghai injure a Chinese woman. | China | http://trove.nla.gov.au/newspaper/page/24097060 | 24097060 | |
56407 | 56407 | 1936-11-14 | 2 | e | Seven thousand workers in Shanghai are determined to fight to death for the nation. | China | http://trove.nla.gov.au/newspaper/page/24097060 | 24097060 | |
56408 | 56408 | 1936-11-14 | 2 | f | Earthquake in northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24097060 | 24097060 | |
56409 | 56409 | 1936-11-14 | 2 | f | Civilians in Shanghai and their attitudes towards Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24097060 | 24097060 | |
56410 | 56410 | 1936-11-14 | 3 | a | Chinese people have stood up to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
56411 | 56411 | 1936-11-14 | 3 | a | New Japanese governor in Taiwan sets up office in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
56412 | 56412 | 1936-11-14 | 3 | c | Number of white Russian refugees inside China. | Other... | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
56413 | 56413 | 1936-11-14 | 3 | c | Japanese force Song Zheyuan to relieve his garrisons. | China | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
56414 | 56414 | 1936-11-14 | 3 | c | Japanese new demands to the Nanjing government. | Britain | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
56415 | 56415 | 1936-11-14 | 3 | d | Naval agreement between Britain and Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
56416 | 56416 | 1936-11-14 | 3 | e | Japanese to use drugs to conquer Asia. | China | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
56417 | 56417 | 1936-11-14 | 3 | e | Japanese are arrested in Shanxi province for drug smuggling. | China | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
56418 | 56418 | 1936-11-14 | 5 | a | Newspapers in Beijing and Shanghai publish comments on the attitude of the Chinese government towards Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097061 | 24097061 | |
56419 | 56419 | 1936-11-14 | 6-7 | a-d | Guangdong news/ General Cai Tingkai talks in Guangxi. Members of the Nationalist Party to pay more dues to their organisation. Thousands of women from Panyu and Shunde are on the way to Nanyang for job. Japanese in Shantou open dancing clubs. News from Shantou. Income tax in Guangdong. Zou Lu is recuperating in a temple. Sales of textile products from Guangdong. Prostitutes in Dongguan raise funds to build a nursing home. Farm is robbed in Nanhai. Feud and fighting in Dongguan. A plea for relief work in Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24097064 | 24097064 | |
56420 | 56420 | 1936-11-14 | 8 | a | Japanese policemen humiliate British sailor and the negotiations followed. | Britain | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56421 | 56421 | 1936-11-14 | 8 | a | The earthquake under the Pacific Ocean. | Japan | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56422 | 56422 | 1936-11-14 | 8 | a | Duan Qirui dies in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56423 | 56423 | 1936-11-14 | 8 | a | Japanese purchase grains in China. | China | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56424 | 56424 | 1936-11-14 | 8 | b | Presidential election in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56425 | 56425 | 1936-11-14 | 8 | c | Communist leader is beheaded in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56426 | 56426 | 1936-11-14 | 8 | c | The revolution in Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56427 | 56427 | 1936-11-14 | 8 | d | Celebration of October Revolution in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56428 | 56428 | 1936-11-14 | 8 | d | Number of population of the world. | America | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56429 | 56429 | 1936-11-14 | 8 | e | Australia news/ Hot weather in Sydney. Bush fire in New South Wales. Three Chinese immigrants are barred from entry in Sydney. Proposal to reform medical system in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 |
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]);