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 |
|---|---|---|---|---|---|---|---|---|---|
| 48271 | 48271 | 1929-07-13 | 2 | b | Editorial by Tung Wah Times on muzzling public opinion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099280 | 24099280 | |
| 48272 | 48272 | 1929-07-13 | 2 | c | First part of a 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/24099280 | 24099280 | |
| 48273 | 48273 | 1929-07-13 | 2 | e | The Nationalist government in Nanjing closes 65 newspapers and magazines in China. | China | http://trove.nla.gov.au/newspaper/page/24099280 | 24099280 | |
| 48274 | 48274 | 1929-07-13 | 2 | e | Soviet Russian frontier guards shoot at Chinese soldiers. | China | http://trove.nla.gov.au/newspaper/page/24099280 | 24099280 | |
| 48275 | 48275 | 1929-07-13 | 3 | a | Japanese government has finalised its China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24099279 | 24099279 | |
| 48276 | 48276 | 1929-07-13 | 3 | a | Refugees in Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24099279 | 24099279 | |
| 48277 | 48277 | 1929-07-13 | 3 | b | Secret documents from Soviet Russia on their conspiracy in China. | China | http://trove.nla.gov.au/newspaper/page/24099279 | 24099279 | |
| 48278 | 48278 | 1929-07-13 | 3 | d | Communist forces under Zhu De and Mao Zedong flee the Jinggangshan and their looting in the neighbouring counties. | China | http://trove.nla.gov.au/newspaper/page/24099279 | 24099279 | |
| 48279 | 48279 | 1929-07-13 | 3 | e | Heilongjiang provincial authority bans opium trade or smoking. | China | http://trove.nla.gov.au/newspaper/page/24099279 | 24099279 | |
| 48280 | 48280 | 1929-07-13 | 5 | a | Hong Kong news/ Zhang Fakui may lead his troops back to Guangdong. Troops in Shantou. Zhongshan county prepares to raise funds among the Chinese community in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099282 | 24099282 | |
| 48281 | 48281 | 1929-07-13 | 5 | b | Women and the inheritance of assets, article written by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099282 | 24099282 | |
| 48282 | 48282 | 1929-07-13 | 6-7 | a-d | Guangdong news/ Trade unions in Guangzhou and their constitutions. Many Guangxi soldiers are drowned when crossing a river during their retreat. Police in Guangzhou advises shops to hang blue lanterns on the day of burial service for Sun Yatsen. Li Yun seeks to lead his troops to enter south Fujian province. Restaurants oppose to the banquet levy in Guangzhou. Companies and firms have to buy unified letter papers before their registration. Fruit businessmen complain about the exorbitant taxes. Soldiers indicate that offices are embezzling. Collection of fruit taxes. Deng Yanhua has to pay ransom. Martial law enforced suddenly in Guangzhou. Boatmen complain over the exorbitant taxes. Bandits rob the customs office in Shenzhen. Smallpox in Zhongshan county. Bandits in Huilai and Zijin county. Zhongshan county authority stop some levies. Business in Tangjiawan, Zhongshan county. Zhongshan county magistrate to ban gambling. Communist bandits in Puning county loot local villages. Bandits in Dongjiang area. Bandits in Yangchun county. | China | http://trove.nla.gov.au/newspaper/page/24099284 | 24099284 | |
| 48283 | 48283 | 1929-07-13 | 8 | c | French concession in Shanghai bans gambling. | China | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
| 48284 | 48284 | 1929-07-13 | 8 | c | Yan Xishan delays his overseas tour due to illness. | China | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
| 48285 | 48285 | 1929-07-13 | 8 | c | New era for the aviation industry in China. | China | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
| 48286 | 48286 | 1929-07-13 | 8 | c | Wife of Chinese deputy consul to San Francisco is detained by American customs for opium smuggling. | America | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
| 48287 | 48287 | 1929-07-13 | 8 | c | Australia news/ How to apply for the subsidy from the government for children education. Post office start to sell new and hard envelopes. Chinese businessman in Sydney Ye Tonggui's third daughter, Ye Zuyi, is engaged with Tsung Yung Lo (Luo Zengrong), and a photograph of the wedding. Statistics on the burglaries in Sydney in the past eight days. Chinese opium addicts are arrested in Sydney. A notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 |
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]);