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 |
|---|---|---|---|---|---|---|---|---|---|
| 48288 | 48288 | 1929-07-20 | 2 | b | Comments by Tung Wah Times on villain and their personalities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099288 | 24099288 | |
| 48289 | 48289 | 1929-07-20 | 2 | c | Second part of the detailed report and statistics on the military expenditure of the Guangdong province in the past 10 years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099288 | 24099288 | |
| 48290 | 48290 | 1929-07-20 | 2 | e | Women in America also have to enlist for military service. | America | http://trove.nla.gov.au/newspaper/page/24099288 | 24099288 | |
| 48291 | 48291 | 1929-07-20 | 2 | e | Liu Zuolong is now a monk. Yu Youren advises Wang Jingwei to return home. Several appointments by the Nanjing government. Nanjing government has appoint new commanders to suppress Feng Yuxiang. The Second Session of the Central Political Council and the release of Li Jishen. | China | http://trove.nla.gov.au/newspaper/page/24099288 | 24099288 | |
| 48292 | 48292 | 1929-07-20 | 3 | a | Detailed report on the search in the Soviet Russian consulate in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099287 | 24099287 | |
| 48293 | 48293 | 1929-07-20 | 3 | c | Soviet Russian consulate in Harbin and the communist activities. | China | http://trove.nla.gov.au/newspaper/page/24099287 | 24099287 | |
| 48294 | 48294 | 1929-07-20 | 3 | d | Communist members are arrested in local Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24099287 | 24099287 | |
| 48295 | 48295 | 1929-07-20 | 3 | e | Diplomatic tensions between China and Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24099287 | 24099287 | |
| 48296 | 48296 | 1929-07-20 | 3 | e | The Communist leaders in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099287 | 24099287 | |
| 48297 | 48297 | 1929-07-20 | 5 | a | Hong Kong news/ Xu Jingtang's troops have arrived south Fujian province. Hong Kong government authority collects beggars. Fire alarm on the Baiyun Road. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099289 | 24099289 | |
| 48298 | 48298 | 1929-07-20 | 5 | c | Ghost in the Jiangyin county, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24099289 | 24099289 | |
| 48299 | 48299 | 1929-07-20 | 5 | e | Please come to collect remains of the deceased countrymen, notice by a Chinese shop in a remote Queensland town. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099289 | 24099289 | |
| 48300 | 48300 | 1929-07-20 | 6-7 | a-d | Guangdong news/ Central Troops (zhong yang jun) attack Xunzhou, Guangxi. Song Ziwen arrives Guangzhou. News on the Guangxi army. Chen Jitang recovers and his discussion on the military and political affairs. Female teachers are fully paid for their maternal leave. Large amount of cash transported to Guangzhou. Post office on the mail | http://trove.nla.gov.au/newspaper/page/24099292 | 24099292 | ||
| 48301 | 48301 | 1929-07-20 | 8 | b | Investigation finds that many people are involved in the opium smuggling following the detainment of Chinese deputy-consul's wife in San Francisco. A further report on the investigation on the opium smuggling. | America | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48302 | 48302 | 1929-07-20 | 8 | b | Chinese authority arrests some Soviet Russians in Harbin, Heilongjiang province. Soviet Russian employees are also dismissed from the Heilongjiang railway management. | China | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48303 | 48303 | 1929-07-20 | 8 | c | A Belgian diamond businessman is robbed in London. | Britain | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48304 | 48304 | 1929-07-20 | 8 | c | Textile factories in Britain reduce wages of workers. | Britain | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48305 | 48305 | 1929-07-20 | 8 | c | Soviet Russia protests against the dismissal of Russian railway employees in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48306 | 48306 | 1929-07-20 | 8 | d | Chinese government has drafted specific policy towards Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48307 | 48307 | 1929-07-20 | 8 | d | China and Soviet Russia may have a war and a further report. | Britain | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48308 | 48308 | 1929-07-20 | 8 | d | Arsenal explodes in Yunnan province. | Britain | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48309 | 48309 | 1929-07-20 | 8 | d | Chinese students in the Sun Yatsen University of Moscow and their communist training. | Britain | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48310 | 48310 | 1929-07-20 | 8 | e | Nanjing government dispatches more troops to guard against Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
| 48311 | 48311 | 1929-07-20 | 8 | e | Australia news/ Chinese priest in Melbourne Zhang Zhuoxiong dies and his assets. Timber workers in Sydney back to work. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 |
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]);