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 |
|---|---|---|---|---|---|---|---|---|---|
| 45569 | 45569 | 1927-03-26 | 2 | c | Jiang Jieshi talks about his anti-Communist attitude and comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101924 | 24101924 | |
| 45570 | 45570 | 1927-03-26 | 2 | d | Treaty talks between China and Belgium. | China | http://trove.nla.gov.au/newspaper/page/24101924 | 24101924 | |
| 45571 | 45571 | 1927-03-26 | 2 | e | Preparation for the set-up of provincial government in Hubei. | China | http://trove.nla.gov.au/newspaper/page/24101924 | 24101924 | |
| 45572 | 45572 | 1927-03-26 | 2 | e | Talks between China and Britain on the case of Hankou. | China | http://trove.nla.gov.au/newspaper/page/24101924 | 24101924 | |
| 45573 | 45573 | 1927-03-26 | 3 | c | People in Hunan on the Guangzhou-Hankou railway. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
| 45574 | 45574 | 1927-03-26 | 3 | c | Strike in Shanghai and the report. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
| 45575 | 45575 | 1927-03-26 | 3 | d | Riots in Nanchang on the New Year's eve. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
| 45576 | 45576 | 1927-03-26 | 3 | e | Japan and the Nationalist government in Guangzhou. Japanese policy in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
| 45577 | 45577 | 1927-03-26 | 3 | f | Chinese residents in the international concessions in Shanghai. Strike in preparation in Xiamen, of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
| 45578 | 45578 | 1927-03-26 | 5 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101925 | 24101925 | |
| 45579 | 45579 | 1927-03-26 | 7 | a-c | Australia news/ Meeting notice by the Chinese Chamber of Commerce. Welcome ceremony for the Duck and Duchess of York. Chinese Chamber of Commerce farewells Wei Zijing on his return to Melbourne, and Ye Tonggui, Chen Yin, Wu Tianbao and Li Xinshe. Fund-raising for the Dongguan hospital. Advertisement for The Primary Producers' Bank of Australia Ltd. Farming and grains in New South Wales. Tourism and theft in Sydney. Sharks caught in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101927 | 24101927 | |
| 45580 | 45580 | 1927-03-26 | 7 | c | A Huangdi Temple to be built in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101927 | 24101927 | |
| 45581 | 45581 | 1927-03-26 | 7 | d | A notice by the Dongguan gong yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101927 | 24101927 | |
| 45582 | 45582 | 1927-03-26 | 7 | e | A notice by the Chinese Presbyterian church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101927 | 24101927 | |
| 45583 | 45583 | 1927-03-26 | 8 | a-d | Guangdong news/ Provincial government to reduce land tax. Li Jishen to appoint Zhen Runqi. Tan Pingshan returns to Guangdong. Chen Yaozu reports road construction in local counties. Road construction in Heshan county. Pharmacy workers on strike in Guangzhou. Big garrison to be built in Zhaoqing. Shops reopened in Shilong town, of Nanhai. Decline of silk industry in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101930 | 24101930 |
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]);