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 |
---|---|---|---|---|---|---|---|---|---|
55514 | 55514 | 1935-10-19 | 2 | f | A robbery in Shanghai in the broad daylight. | China | http://trove.nla.gov.au/newspaper/page/24096612 | 24096612 | |
55518 | 55518 | 1935-10-19 | 3 | c | American Secretary of State on the war between Italy and Algeria. | America | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
55528 | 55528 | 1935-10-19 | 8 | f | Australia news/ Sydney has secured more cannons for defence purpose. The whereabouts of Australian fleet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096618 | 24096618 | |
55517 | 55517 | 1935-10-19 | 3 | a | Britain seeks cooperation from Japan for the loans to China. | Britain | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
55522 | 55522 | 1935-10-19 | 3 | e | British Liberal Party leader condemns Italian Prime Minister Mussolini. | Britain | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
55516 | 55516 | 1935-10-19 | 3 | a | British government is determined to protect Egypt. Italian army in Egypt. | Other... | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
55527 | 55527 | 1935-10-19 | 8 | e | British warships gather in the Mediterranean Sea. | Britain | http://trove.nla.gov.au/newspaper/page/24096618 | 24096618 | |
55521 | 55521 | 1935-10-19 | 3 | e | Germany refuses to join other European countries for the group safety. | Germany | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
55525 | 55525 | 1935-10-19 | 6-7 | a-f | Guangdong news/ Further report on the bankruptcy of the Bank of Guangdong and its influence upon other banks. The government and the civilians are co-operating for the air defence. Kong Xiangxi sends representatives to the south. Family members of the government civil servants are required to wear standard clothes. Promotion of agriculture and afforestation starts from Sanshui, Heshan and Conghua counties. First group of new army recruits arrive Guangzhou. Kong Xiangxi to come to Guangzhou for the infrastructure development in Guangdong. Australian merchants ships on the way to Hong Kong for trade purpose. Opposition to the registration of local sugar factories in Guangdong. Proposal in Guangzhou to save sugar industry. Zhongshan county authority plans to reclaim some waste land. Modern women in Zhongshan county. Chamber of commerce in Taishan county. Charity institution in Dongguan donates medicine. Ban on modern clothes in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24096616 | 24096616 | |
55519 | 55519 | 1935-10-19 | 3 | c | Japan protests against Britain for the loans to China. | China | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
55520 | 55520 | 1935-10-19 | 3 | d | Japanese economic delegation comes to visit China. | China | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
55523 | 55523 | 1935-10-19 | 3 | e | Japanese embassy moves to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
55508 | 55508 | 1935-10-19 | 2 | b | Jiang Jieshi is urged to keep his promise of the Northern Expedition. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096612 | 24096612 | |
55512 | 55512 | 1935-10-19 | 2 | d | Jiang Zuobin promotes economic cooperation between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096612 | 24096612 | |
55510 | 55510 | 1935-10-19 | 2 | d | More Japanese are going to investigate in the northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24096612 | 24096612 | |
55524 | 55524 | 1935-10-19 | 5 | a | Stories of Empress Dowager Cixi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096613 | 24096613 | |
55513 | 55513 | 1935-10-19 | 2 | f | The Grand Canal dam breaks near Xuzhou, north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24096612 | 24096612 | |
55511 | 55511 | 1935-10-19 | 2 | d | The Philippines authority forces more than 20,000 Chinese labourers to leave the country. | China | http://trove.nla.gov.au/newspaper/page/24096612 | 24096612 | |
55515 | 55515 | 1935-10-19 | 2 | f | The communists troops on the border of Sichuan and Yunnan province. Hang Yingbai seeks to resign once again. | China | http://trove.nla.gov.au/newspaper/page/24096612 | 24096612 | |
55526 | 55526 | 1935-10-19 | 8 | a | The war between Italy and Algeria. | Britain | http://trove.nla.gov.au/newspaper/page/24096618 | 24096618 | |
55509 | 55509 | 1935-10-19 | 2 | b | Wang Jingwei in Nanjing meets the Guangdong delegation. | China | http://trove.nla.gov.au/newspaper/page/24096612 | 24096612 |
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]);