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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
55531 | 55531 | 1935-10-26 | 2 | d | Economic cooperation between China and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096620 | 24096620 | |
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 | |
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 | |
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 | |
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 | |
55536 | 55536 | 1935-10-26 | 3 | c | Japanese industry is prosperous. | Japan | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 | |
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 | |
55538 | 55538 | 1935-10-26 | 3 | e | Another border dispute between Russia and Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096619 | 24096619 | |
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 | |
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 | |
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 | |
55542 | 55542 | 1935-10-26 | 8 | a | Greek army seeks to restore monarchy. | Other... | 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 | |
55544 | 55544 | 1935-10-26 | 8 | b | The war between Italy and Algeria. | Britain | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
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 | |
55546 | 55546 | 1935-10-26 | 8 | e | The power of Emperor of Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
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 |
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]);