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 |
|---|---|---|---|---|---|---|---|---|---|
| 45150 | 45150 | 1926-09-18 | 2 | c | Editorial on the situation changes in Hunan and Hubei following the war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
| 45151 | 45151 | 1926-09-18 | 2 | d | Wu Peifu on the organisation of Chinese cabinet. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
| 45152 | 45152 | 1926-09-18 | 2 | e | Department of Justice in Beijing orders to reform the prison. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
| 45153 | 45153 | 1926-09-18 | 2 | f | War news from the Northwest China. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
| 45154 | 45154 | 1926-09-18 | 3 | d | Jiang Jieshi (Chiang Kai-shek) is keen to occupy Jiangxi province and his strategies. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
| 45155 | 45155 | 1926-09-18 | 3 | f | Sun Chuanfang's attitude towards Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
| 45156 | 45156 | 1926-09-18 | 3 | f | Defence plan of the Jiangxi authority. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
| 45157 | 45157 | 1926-09-18 | 5-6 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101713 | 24101713 | |
| 45158 | 45158 | 1926-09-18 | 6 | b-c | The Chinese Chamber of Commerce in Sydney organises a special committee for the birthday celebration of Confucius. Name of the committee members and photograph of Chen Zanhua, chairman of the committee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101716 | 24101716 | |
| 45159 | 45159 | 1926-09-18 | 7 | a | Australia news/ The Labour Party in New South Wales opposes to any interference with the Chinese affairs. Australian naval fleet may join the action in China. A Chinese is robbed in Sydney. Fighting in the Chinese temple in Melbourne. Tragedy of railway accident in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
| 45160 | 45160 | 1926-09-18 | 7 | a | The war in Wuhan, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
| 45161 | 45161 | 1926-09-18 | 7 | b | Heavy rain in New York. | America | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
| 45162 | 45162 | 1926-09-18 | 7 | b-c | The arrest and exile of Chinese immigrants in the Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
| 45163 | 45163 | 1926-09-18 | 8 | a-d | Guangdong news/ The Nationalist government in Guangzhou issues the second bonds. Troops loot in Taishan county. Charity institutions in Guangzhou and their call for help in the disaster relief. Bandits in Gaoyao county. Zou Lu seeks collaboration with bandits in Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24101718 | 24101718 |
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]);