This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31456 | 31456 | 1916-08-05 | 3 | b-c | Sichuan provincial authority cuts its relationship with Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24095354 | 24095354 | |
31460 | 31460 | 1916-08-05 | 6 | b-c | Collection of telegrams (Huang Xing to Tang Shaoyi, Huang Xing to Lu Rongting, Huang Xing to the military governor of Zhejiang province, Huang Xing to military commander in Guangdong, and Wang Xishan to his school mates of the Baoding Army School). | China | http://trove.nla.gov.au/newspaper/page/24095359 | 24095359 | |
31463 | 31463 | 1916-08-05 | 7 | b-c | A Maori man in New Zealand claims himself a prophet and is brought to trial. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095358 | 24095358 |
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]);