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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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]);