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 |
|---|---|---|---|---|---|---|---|---|---|
| 47787 | 47787 | 1929-02-02 | 2 | b | Second and final part of the editorial on the ultimate from Japanese government to the Chinese authority regarding the tariff issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099106 | 24099106 | |
| 47788 | 47788 | 1929-02-02 | 2 | c | Zhang Dingfan refuses to cooperate with Jiang Jieshi and may go to Beiping for Bai Chongxi. The Nanjing government and the Nationalist associations in Tianjin. Zheng Yuxiu and Zheng Hongnian in tears before the portrait of Sun Yatsen. Zhou Xicheng in Guizhou wins again. A report submitted by Zhang Zhijiang for his investigation on the opium smuggling in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099106 | 24099106 | |
| 47789 | 47789 | 1929-02-02 | 2 | f | Feng Yuxiang attacks Liu Jiwen once again. | China | http://trove.nla.gov.au/newspaper/page/24099106 | 24099106 | |
| 47790 | 47790 | 1929-02-02 | 3 | b | Anti-Japanese demonstration in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099105 | 24099105 | |
| 47791 | 47791 | 1929-02-02 | 3 | d | Profit of the Kailuan coal mine in Zhili (Hebei) province. | China | http://trove.nla.gov.au/newspaper/page/24099105 | 24099105 | |
| 47792 | 47792 | 1929-02-02 | 3 | e | Trade between China and America increases dramatically. | China | http://trove.nla.gov.au/newspaper/page/24099105 | 24099105 | |
| 47793 | 47793 | 1929-02-02 | 5 | a | Hong Kong news/ Building progress of a library by the Chinese Chamber of Commerce in Hong Kong. Public assets of a trade union are confiscated. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099107 | 24099107 | |
| 47794 | 47794 | 1929-02-02 | 5 | f | Growing of mushroom. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099107 | 24099107 | |
| 47795 | 47795 | 1929-02-02 | 6-7 | a-d | Guangdong news/ First part of the inaugural speech by Chen Mingshu, chairman of the provincial government. Thailand starts to collect special tax for Chinese imports. Statistics of the natural disasters in Guangdong. Survey on the sink production in Guangdong. The Political Branch disband the Huangpu commercial companies. Report submitted by the director of the Yao minority people affairs bureau in Lianping and Yangjiang. Zhongshan is now model county. News from Taishan. Road construction and the plan in Xinhui county. Rice robbed in Dongguan. Ferries in Heshan county appeal for the cancellation of army levies. | China | http://trove.nla.gov.au/newspaper/page/24099110 | 24099110 | |
| 47796 | 47796 | 1929-02-02 | 8 | a | Natural and the Communist disasters in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24099112 | 24099112 | |
| 47797 | 47797 | 1929-02-02 | 8 | a | Famine in Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24099112 | 24099112 | |
| 47798 | 47798 | 1929-02-02 | 8 | a | Australia news/ Chinese are arrested in Sydney for gambling. Young woman in Wagga Wagga buries her new-born baby. Workers in Melbourne protest against the 48 hours' working per week. Fire in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099112 | 24099112 |
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]);