This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31333 | 31333 | 1916-06-17 | 8 | a-b | Beijing news/ Liang Qichao refuses to recognise the new cabinet. Liang Qichao and Feng Guozhang. The Alliance to denounce Yuan Shikai. Hu Hanmin arrives Shanghai and the report. Zhang Qian and his hometown of Nantong, Jiangsu province. Yuan Shikai prepares a military ship for escape. | China | http://trove.nla.gov.au/newspaper/page/24095306 | 24095306 | |
31334 | 31334 | 1916-06-17 | 8 | b-d | Guangdong news/ Provincial authority and the local civil corps. Circular telegram issued by Tan Xueheng. Qin Chunxuan consoles foreign missions. Staff of the military headquarters. A telegram from Wei Bangping to Long Jiguang. Qin Chunxuan and Long Jiguang jointly to recruit local civil corps. Liang Qichao thanks Long Jiguang. The execution of Cai Naihuang. | China | http://trove.nla.gov.au/newspaper/page/24095306 | 24095306 |
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]);