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 |
---|---|---|---|---|---|---|---|---|---|
55538 | 55538 | 1935-10-26 | 3 | e | Another border dispute between Russia and Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 | |
55547 | 55547 | 1935-10-26 | 8 | f | Australia news/ Lord Mayor of Sydney passed away. Australian flour businessmen boycott to Italy. Hails in Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
55543 | 55543 | 1935-10-26 | 8 | a | Border clash between Russia and Japan. | Russia | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
55535 | 55535 | 1935-10-26 | 3 | c | British economic expert Ross leaves Nanjing for Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 | |
55529 | 55529 | 1935-10-26 | 2 | b | Comments on the fundamental strategies to save the Chinese industries, selected from the China Daily. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096620 | 24096620 | |
55531 | 55531 | 1935-10-26 | 2 | d | Economic cooperation between China and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096620 | 24096620 | |
55537 | 55537 | 1935-10-26 | 3 | e | Germany has failed to secure loans from Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 | |
55542 | 55542 | 1935-10-26 | 8 | a | Greek army seeks to restore monarchy. | Other... | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
55541 | 55541 | 1935-10-26 | 6-7 | a-f | Guangdong news/ Huang Jilu is leaving Shanghai for Guangdong by the end of this month. Overseas Chinese Commission in Nanjing sends their representatives to Guangdong for political purpose. Banks in Guangdong are required to audit their accounts. The National Bank is closed down yesterday. Three-year development plan of Guangxi. There are much less illegal prostitutes in Guangzhou. New army recruits in from local counties. Business in Shantou. China's tea export increases. American businessmen require to improve manufacturing of fireworks. New tax on fresh fish in Dongguan. Taishan county authority protects returned overseas Chinese to reclaim waste land. Woman is buried alive in Taishan for chastity. Counterfeit bank notes found in Gaoyao. Hepu county authority ban sales of wives. | China | http://trove.nla.gov.au/newspaper/page/24096624 | 24096624 | |
55536 | 55536 | 1935-10-26 | 3 | c | Japanese industry is prosperous. | Japan | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 | |
55532 | 55532 | 1935-10-26 | 2 | d | Japanese troops are moving west from north China. | China | http://trove.nla.gov.au/newspaper/page/24096620 | 24096620 | |
55539 | 55539 | 1935-10-26 | 3 | e | Mongolian and Russian troops have a joint exercise. | China | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 | |
55545 | 55545 | 1935-10-26 | 8 | d | Negotiations between Russia and Japan over the border disputes. | China | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
55530 | 55530 | 1935-10-26 | 2 | d | Song Zheyuan assumes office as commander-in-chief of the security troops in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096620 | 24096620 | |
55540 | 55540 | 1935-10-26 | 5 | e | The Chinese Society (zhong hua gong hui) in Melbourne donates to floods victims in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096621 | 24096621 | |
55533 | 55533 | 1935-10-26 | 3 | a | The anti-Chinese movement in Thailand and the response in China. | China | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 | |
55546 | 55546 | 1935-10-26 | 8 | e | The power of Emperor of Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
55544 | 55544 | 1935-10-26 | 8 | b | The war between Italy and Algeria. | Britain | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
55534 | 55534 | 1935-10-26 | 3 | a | The war clouds in Europe. Japanese troops have taken Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 |
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]);