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 |
---|---|---|---|---|---|---|---|---|---|
48531 | 48531 | 1929-10-12 | 2 | b | Comments on the silence and awakening of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099389 | 24099389 | |
48532 | 48532 | 1929-10-12 | 2 | c | Zionism and the Jewish people in China. | China | http://trove.nla.gov.au/newspaper/page/24099389 | 24099389 | |
48533 | 48533 | 1929-10-12 | 2 | d | Japan is building more warships. | Japan | http://trove.nla.gov.au/newspaper/page/24099389 | 24099389 | |
48534 | 48534 | 1929-10-12 | 2 | d | Farewell to the troops in Shenyang for Wang Shuchang's troops on the departure to fighting Russian army. | China | http://trove.nla.gov.au/newspaper/page/24099389 | 24099389 | |
48535 | 48535 | 1929-10-12 | 2 | d | Zhang Ji on the way to Japan for peace talks. | China | http://trove.nla.gov.au/newspaper/page/24099389 | 24099389 | |
48536 | 48536 | 1929-10-12 | 2 | e | Liang Zhongshen reports from the border with Russia. | China | http://trove.nla.gov.au/newspaper/page/24099389 | 24099389 | |
48537 | 48537 | 1929-10-12 | 2 | e | Businessman from Hong Kong, Sir He Dong, to tour Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099389 | 24099389 | |
48538 | 48538 | 1929-10-12 | 2 | f | Silk production in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24099389 | 24099389 | |
48539 | 48539 | 1929-10-12 | 3 | a | Defence of the Chinese troops along the border with Russia. | China | http://trove.nla.gov.au/newspaper/page/24099388 | 24099388 | |
48540 | 48540 | 1929-10-12 | 3 | b | Opium smuggling in Xiamen, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24099388 | 24099388 | |
48541 | 48541 | 1929-10-12 | 3 | d | The Communist riots in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24099388 | 24099388 | |
48542 | 48542 | 1929-10-12 | 3 | e | Japanese demands the control of railway in Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24099388 | 24099388 | |
48543 | 48543 | 1929-10-12 | 5 | a | Second part of the report on the typhoon and damages in local Guangdong (Shunde, Zhongshan, Qujiang and Zhaoqing). | China | http://trove.nla.gov.au/newspaper/page/24099390 | 24099390 | |
48544 | 48544 | 1929-10-12 | 5 | d | Hong Kong news/ Human traffic in Hong Kong. Prediction on the future of Christmas. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099390 | 24099390 | |
48545 | 48545 | 1929-10-12 | 6-7 | a-d | Guangdong news/ Guangdong commercial chamber appeal to abolition of two taxes. Shops in Guangzhou required to pay monthly tax. Fishing men and the petitions. Guangdong to have women judges. Financial director Fan Qiwu on the currency changes. Tax exemption for soybean oil and others. Bridegroom is in turn a lover. Fortress collapse in Zengcheng county. Tax collector in Shantou and his embezzlement. Mining resources in Qinxian and Liancheng counties. Clan feud and fighting in Taishan county. Clan fighting in Wenchang county. Sericulture in Shunde county. City wall demolished for road construction in Sanshui county. Public hospital to be built in Taishan county. Examination committee to be organised for stamp duties inspection. Marriage custom in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24099393 | 24099393 | |
48546 | 48546 | 1929-10-12 | 8 | c | Russian troops on the Chinese border and their intentions. | Japan | http://trove.nla.gov.au/newspaper/page/24099395 | 24099395 | |
48547 | 48547 | 1929-10-12 | 8 | c | Zhang Fakui occupies Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24099395 | 24099395 | |
48548 | 48548 | 1929-10-12 | 8 | c | Robbery in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099395 | 24099395 | |
48549 | 48549 | 1929-10-12 | 8 | d | Australia news/ Residents required to report their pension income. Robbery in Newtown, Sydney. Chinese communities in Sydney celebrate the National Day on October 10 and the birthday of Confucius, and speakers include Zhu Songqing, Ye Bingnan, Zheng Fanchang, He Youwen, Zhang Fu and Liu Junchen. Baby girl's body found in Bondi, Sydney. Chinese Consul-General Song Faxiang's wife arrives Sydney. A notice issued by the Australian Oriental Line Company in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099395 | 24099395 |
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]);