This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18750 | 18750 | 1908-01-11 | 2 | c-d | China news. Financial situation in Guangxi province. Fashion and proposal to abolish boundary between Manchurian and Han women. Department of foreign affairs investigates the number of foreign troops in south China and the report. Lu Baozhong might resume his official position. Zhao Binglin impeaches chairman of the political consulting committee. Chinese government is determined to rejuvenate navy. Chinese government relaxes its ban on opium smoking. Descendants of the "Eight Banners" will be reclassified into different groups. | China | http://trove.nla.gov.au/newspaper/page/26801604 | 26801604 | |
18775 | 18775 | 1908-01-11 | 8 | b-c | Miscellaneous news. Chinese military inspectors visit Japan and review parade together with Emperor of Japan. | China | http://trove.nla.gov.au/newspaper/page/26801610 | 26801610 |
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]);