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 |
|---|---|---|---|---|---|---|---|---|---|
| 45365 | 45365 | 1926-12-18 | 2 | c | Open telegrams issued by the Chinese National Chamber of Commerce. | China | http://trove.nla.gov.au/newspaper/page/24101816 | 24101816 | |
| 45366 | 45366 | 1926-12-18 | 2 | d | The second protest issued by the Beijing government on the Wanxian case in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101816 | 24101816 | |
| 45367 | 45367 | 1926-12-18 | 2 | f | The Chinese government and the international tariff conference. | China | http://trove.nla.gov.au/newspaper/page/24101816 | 24101816 | |
| 45368 | 45368 | 1926-12-18 | 2 | f | Restrictions imposed by Chinese authority on foreign accountants for their practice in China. | China | http://trove.nla.gov.au/newspaper/page/24101816 | 24101816 | |
| 45369 | 45369 | 1926-12-18 | 3 | d | Chinese government sets up special committee to revise treaties with foreign countries. | China | http://trove.nla.gov.au/newspaper/page/24101815 | 24101815 | |
| 45370 | 45370 | 1926-12-18 | 3 | d | The abrogation of the treaty between China and Belgium. | China | http://trove.nla.gov.au/newspaper/page/24101815 | 24101815 | |
| 45371 | 45371 | 1926-12-18 | 3 | e | Chen Yi is now governor of Zhejiang province and the ceremony. | China | http://trove.nla.gov.au/newspaper/page/24101815 | 24101815 | |
| 45372 | 45372 | 1926-12-18 | 5 | a-c | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101817 | 24101817 | |
| 45373 | 45373 | 1926-12-18 | 7 | a-b | Australia news/ Notice for Christmas holiday. Heat waves in Sydney and the casualties. Mother and son die one after another in Sydney. Sydney customs check luggage carefully. New post office to be set up in Hay Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101819 | 24101819 | |
| 45374 | 45374 | 1926-12-18 | 7 | b | Bandits in Xiangshan, Guangdong, and the robbery. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101819 | 24101819 | |
| 45375 | 45375 | 1926-12-18 | 7 | c | Wu Peifu and his wife. | China | http://trove.nla.gov.au/newspaper/page/24101819 | 24101819 | |
| 45376 | 45376 | 1926-12-18 | 7 | d | Military commanders under Sun Chuanfang. | China | http://trove.nla.gov.au/newspaper/page/24101819 | 24101819 | |
| 45377 | 45377 | 1926-12-18 | 8 | a-d | Guangdong news/ Railway workers on strike in Ningyang. Xu Shaozheng in the Guomindang and his political attitudes. Commission of Overseas Chinese set up in Guangzhou and its functions. Land evaluation in Guangzhou and the new office. Clan feud and fighting in Dongguan county. Road to be build to the Qixingyan. Women communist arrested in Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24101822 | 24101822 |
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]);