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 |
|---|---|---|---|---|---|---|---|---|---|
| 45432 | 45432 | 1927-01-22 | 2 | c | Editorial by Tung Wah Times on the will of the people and the military force. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101856 | 24101856 | |
| 45433 | 45433 | 1927-01-22 | 2 | d | Zhang Zuolin on the current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24101856 | 24101856 | |
| 45434 | 45434 | 1927-01-22 | 2 | e | War clouds in central China. | China | http://trove.nla.gov.au/newspaper/page/24101856 | 24101856 | |
| 45435 | 45435 | 1927-01-22 | 3 | d | Two declarations issued by Zhang Zuolin to condemn the communist movement. | China | http://trove.nla.gov.au/newspaper/page/24101855 | 24101855 | |
| 45436 | 45436 | 1927-01-22 | 3 | d-f | Third and final part of the open letter issued by commander-in-chief Jiang Jieshi to the nation wide. | China | http://trove.nla.gov.au/newspaper/page/24101855 | 24101855 | |
| 45437 | 45437 | 1927-01-22 | 3 | f | Rapid changes of political situations in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24101855 | 24101855 | |
| 45438 | 45438 | 1927-01-22 | 5 | a-c | News on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101857 | 24101857 | |
| 45439 | 45439 | 1927-01-22 | 7 | A | A meeting notice by the Chinese Chamber of Commerce in Sydney. Smuggled opium seized in a Japanese liner in Sydney. A Chinese gardener in Sydney is drowned. A case of murder Chinese in Queensland. Heat waves in New South Wales. Wine prices in Adelaide. An Australian-born Chinese woman is barred from return by the customs officers. Revision of factory act in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101859 | 24101859 | |
| 45440 | 45440 | 1927-01-22 | 7 | c | Chinese immigrants are imprisoned on arrival in Cuba. | Other... | http://trove.nla.gov.au/newspaper/page/24101859 | 24101859 | |
| 45441 | 45441 | 1927-01-22 | 8 | a-d | Guangdong news/ The new form of revolutionary army in the future. People in Fujian province ask for exempt from military levies. Trade union in Guangzhou harass charity institution. Gaoyao fellows in Hong Kong care about their home town. Bandit chieftain is killed in Xiangshan county. Wu Tiecheng is on the way to Shanghai. House maids in Foshan. Peasant army collect land tax in Shunde and Zhongshan county. | China | http://trove.nla.gov.au/newspaper/page/24101862 | 24101862 |
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]);