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 |
|---|---|---|---|---|---|---|---|---|---|
| 45584 | 45584 | 1927-04-02 | 2 | c | Editorial by Tung Wah Times on the possibility of a world war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101932 | 24101932 | |
| 45585 | 45585 | 1927-04-02 | 2 | d | Proposal for the revision of Chinese tariff. | China | http://trove.nla.gov.au/newspaper/page/24101932 | 24101932 | |
| 45586 | 45586 | 1927-04-02 | 2 | e | Japanese foreign minister on the current situation in Europe. Japanese foreign minister on their China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24101932 | 24101932 | |
| 45587 | 45587 | 1927-04-02 | 3 | c | Foreign gunboats in Shanghai and a survey. | China | http://trove.nla.gov.au/newspaper/page/24101931 | 24101931 | |
| 45588 | 45588 | 1927-04-02 | 3 | d | Governor of Shandong province Zhang Zongchang and his plan of transportation. | China | http://trove.nla.gov.au/newspaper/page/24101931 | 24101931 | |
| 45589 | 45589 | 1927-04-02 | 3 | e | Zhang Jingjiang is considering to topple the Chinese Communist Party and Jiang Jieshi supports his plan. | China | http://trove.nla.gov.au/newspaper/page/24101931 | 24101931 | |
| 45590 | 45590 | 1927-04-02 | 3 | f | Chinese students are returning from France and Belgium. | China | http://trove.nla.gov.au/newspaper/page/24101931 | 24101931 | |
| 45591 | 45591 | 1927-04-02 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101933 | 24101933 | |
| 45592 | 45592 | 1927-04-02 | 5 | c | Businessmen in the Beijiang area and the conflict with the government authority. | China | http://trove.nla.gov.au/newspaper/page/24101933 | 24101933 | |
| 45593 | 45593 | 1927-04-02 | 7 | a-b | Australia news/ A meeting notice by the Chinese Chamber of Commerce. Thief in Sydney and the pocket lift. Women thief in Sydney. Young woman dies while on holiday in the beach. Tariff increased for imported rice. Whale catching makes huge profit. Chinese gardener is injured in an accident. Dozens of Chinese artists arrive Sydney for the Oriental Arts Company Ltd. Glass industry in Sydney and the impacts of imported products. Chinese carpenter is penalised for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101935 | 24101935 | |
| 45594 | 45594 | 1927-04-02 | 7 | c | Standards for man to be married. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101935 | 24101935 | |
| 45595 | 45595 | 1927-04-02 | 7 | c | Folk songs selected from Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101935 | 24101935 | |
| 45596 | 45596 | 1927-04-02 | 7 | d | Mother Stone in Xinhui county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101935 | 24101935 | |
| 45597 | 45597 | 1927-04-02 | 7 | e | Notice by the Dongguan gong yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101935 | 24101935 | |
| 45598 | 45598 | 1927-04-02 | 8 | a-d | Guangdong news/ A survey on the mining resources in Guangdong. Xiangshan county authority orders to stop harassment to local churches. Tax on gambling in Xiangshan county. Bandits in Xiangshan county are besieged. Bandits in Gaoming county hijack ferries. Dongguan Public Society asks for help to suppress bandits. Bandits in Yangjiang county. Transportation on the Guangzhou-Hankou railway. New orders on the house maids. Director of Public Security Bureau Deng Yanhua and his speech in Guangzhou. Army enlistment in Guangzhou and the resistance. | China | http://trove.nla.gov.au/newspaper/page/24101938 | 24101938 |
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]);