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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
56427 | 56427 | 1936-11-14 | 8 | d | Celebration of October Revolution in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
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 | |
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 | |
56425 | 56425 | 1936-11-14 | 8 | c | Communist leader is beheaded in Germany. | Britain | 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 | |
56408 | 56408 | 1936-11-14 | 2 | f | Earthquake in northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24097060 | 24097060 | |
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 | |
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 | |
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 | |
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 | |
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 | |
56423 | 56423 | 1936-11-14 | 8 | a | Japanese purchase grains in China. | China | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
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 | |
56416 | 56416 | 1936-11-14 | 3 | e | Japanese to use drugs to conquer Asia. | China | 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 | |
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 | |
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 | |
56428 | 56428 | 1936-11-14 | 8 | d | Number of population of the world. | America | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56412 | 56412 | 1936-11-14 | 3 | c | Number of white Russian refugees inside China. | Other... | http://trove.nla.gov.au/newspaper/page/24097059 | 24097059 | |
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 | |
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 | |
56421 | 56421 | 1936-11-14 | 8 | a | The earthquake under the Pacific Ocean. | Japan | 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 |
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]);