This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31434 | 31434 | 1916-07-22 | 8 | a-b | Beijing news/ The political situations in Beijing after the death of Yuan Shikai. Some provinces cancel their independence. Nanjing Conference and the comments. Yuan Shikai's government and their rumours. The murder of Chen Qimei and Liang Shiyi. Liu Guanxiong and the Nanjing Conference. | China | http://trove.nla.gov.au/newspaper/page/24095345 | 24095345 | |
31435 | 31435 | 1916-07-22 | 8 | b-d | Guangdong news/ Liang Qichao resigns and why. Gambling in Guangzhou permitted. Wei Bangping resigns. Flood in the west of Guangzhou. Yuan Dexin is killed by civil corps. Taishan county magistrate flees. A monster baby born in Dongguan county. Women commit suicide in the social turmoil. Kaijian county magistrate reports floods there. Bandits in Nanhai, Xinhui, and Bao'an county. | China | http://trove.nla.gov.au/newspaper/page/24095345 | 24095345 |
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]);