This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31035 | 31035 | 1916-03-18 | 2 | a-c | Comment/ Terrifying news of attempting to assassinate head of China | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095195 | 24095195 | |
31052 | 31052 | 1916-03-18 | 6 | c | Satire on Yuan Shikai's restoring imperial system in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095199 | 24095199 | |
31057 | 31057 | 1916-03-18 | 8 | d-e | Wing On & Company in Hong Kong raises more funds by floating shares and its notice, signed by Guo Le, Guo Quan, Yang Huiting, Du Zewen, Li Gen, Lin Zesheng, Li Yanxiang, Sun Zhixing, Yang Jinhua and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095200 | 24095200 |
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]);