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 |
|---|---|---|---|---|---|---|---|---|---|
| 45287 | 45287 | 1926-11-13 | 2 | c-d | Editorial by Tung Wah Times expresses optimism on the communications between Guangzhou and Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101776 | 24101776 | |
| 45288 | 45288 | 1926-11-13 | 2 | d | Gu Weijun becomes new premier of China and his effort to set up the cabinet. | China | http://trove.nla.gov.au/newspaper/page/24101776 | 24101776 | |
| 45289 | 45289 | 1926-11-13 | 2 | f | The army under Wu Peifu after Cao Kun's arrival in Zhengzhou, of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24101776 | 24101776 | |
| 45290 | 45290 | 1926-11-13 | 3 | c | Wu Peifu speaks to his troops. | China | http://trove.nla.gov.au/newspaper/page/24101775 | 24101775 | |
| 45291 | 45291 | 1926-11-13 | 3 | d | Refugees in Wuchang, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101775 | 24101775 | |
| 45292 | 45292 | 1926-11-13 | 3 | e | Coastal defence in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101775 | 24101775 | |
| 45293 | 45293 | 1926-11-13 | 5 | a-c | Miscellaneous report on the war in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24101777 | 24101777 | |
| 45294 | 45294 | 1926-11-13 | 7 | a | Australia news/ Chinese sailors would rather quit their job than take the unacceptable salary. Hundreds of cars stolen in Sydney. Seventeen people are detained in Sydney for opium smoking. A case of divorce in Sydney. Labour Party members in Sydney gather in protest against foreign interference with the Chinese affairs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101779 | 24101779 | |
| 45295 | 45295 | 1926-11-13 | 7 | c | The war in the Southeast of China. | China | http://trove.nla.gov.au/newspaper/page/24101779 | 24101779 | |
| 45296 | 45296 | 1926-11-13 | 7 | b | Fire in Guangzhou destroys the union house. | China | http://trove.nla.gov.au/newspaper/page/24101779 | 24101779 | |
| 45297 | 45297 | 1926-11-13 | 7 | b | Nanjing commercial chamber issues a circular telegram on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24101779 | 24101779 | |
| 45298 | 45298 | 1926-11-13 | 8 | a-d | Guangdong news/ Stamp duty is now applicable to grains. Transportation resumed in Guangdong. Fire in Shiqi town. People in Jiangmen fight for the public property. High school students on class strike in Zhaoqing and the report. | China | http://trove.nla.gov.au/newspaper/page/24101782 | 24101782 |
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]);