This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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]);