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 |
---|---|---|---|---|---|---|---|---|---|
45020 | 45020 | 1926-08-07 | 2 | d-e | Wu Peifu, Zhang Zuolin and their policies in the Northwest China. | China | http://trove.nla.gov.au/newspaper/page/24101656 | 24101656 | |
45021 | 45021 | 1926-08-07 | 2 | e | Zhang Zuolin's troops and the security arrangement in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101656 | 24101656 | |
45022 | 45022 | 1926-08-07 | 2 | f | Correspondence between Sun Chuanfang and military commanders in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101656 | 24101656 | |
45023 | 45023 | 1926-08-07 | 3 | d | Tang Shengzhi is preparing to attack Guangxi once again. | China | http://trove.nla.gov.au/newspaper/page/24101655 | 24101655 | |
45024 | 45024 | 1926-08-07 | 3 | f | Comprise between Guizhou governor Peng Hanzhang and Ye Kaixin of Hunan. | China | http://trove.nla.gov.au/newspaper/page/24101655 | 24101655 | |
45030 | 45030 | 1926-08-07 | 5 | b | Post officer workers to start a strike in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101657 | 24101657 | |
45031 | 45031 | 1926-08-07 | 5 | c | Western priest is released in Datong, Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24101657 | 24101657 | |
45032 | 45032 | 1926-08-07 | 5 | c | The coming war in China between the north and the south. | China | http://trove.nla.gov.au/newspaper/page/24101657 | 24101657 | |
45038 | 45038 | 1926-08-07 | 8 | a-d | Guangdong news/ Name list of the county magistrates in Guangdong. The attempt to assassinate Jiang Jieshi. Conflict between the Nationalist and the Communist members. Civil corps in Sanshui county. More clan fighting in Nanhai county. | China | http://trove.nla.gov.au/newspaper/page/24101662 | 24101662 |
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]);