This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29674 | 29674 | 1915-02-06 | 6 | d | Penalty regulations on official corruption in China. | China | http://trove.nla.gov.au/newspaper/page/24094716 | 24094716 | |
29675 | 29675 | 1915-02-06 | 6 | a-c | Headline news miscellany/50 one-line news items covering current government policy changes, official promotions, official inspections, and important events. Yuan Shikai, Song Yuren, Kong Saoyian, Qu Yinguang, Xu Shichang, Wu Tingfang, Tian Liang, Cheng Diquang, Long Jianzhang, Xu Guiqiang, Nao Neixuan, Lin Maode, Liu Guangxun, Sun Baoqi, Liang Dunyian, Zhou Zhiqi, Zhou Xuexi, Wang Dahao, Zhang Zhenfang, are included. | China | http://trove.nla.gov.au/newspaper/page/24094716 | 24094716 |
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]);