This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22159 | 22159 | 1909-12-25 | 2 | c | China under the pressure of Japan, America, Britain and other countries. | China | http://trove.nla.gov.au/newspaper/page/26802440 | 26802440 | |
22161 | 22161 | 1909-12-25 | 2-3 | d-a | Beijing news/ Candidates for the new prime minister. Legislative assembly members in Jiangsu province suggest abolishing official newspapers. Lian Yu and Wen Zongyao report from Tibet. Budget for the security troops in Beijing. Funeral of the late Empress Dowager and the after. Negotiation with Britain on the coal mine in Kaiping county. Lu Zhengxiang and Liu Shixun report that China in serious crisis. Transportation infrastructure in Gansu, Xinjiang and Yili. | China | http://trove.nla.gov.au/newspaper/page/26802440 | 26802440 |
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]);