This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22680 | 22680 | 1910-04-23 | 2 | b-c | News in brief/ More petitions for the setup of national parliament. Imperial scholar Hu Sijing suggests reducing some local official candidates. New policy for Tibet. Yin Chang to replace Tie Liang as army commander. British loan and the railway project from Tianjin to Pukou. Preparation program for study in America and the supervisors. Chinese student in America Rui Sen invents model warship. | China | http://trove.nla.gov.au/newspaper/page/26802599 | 26802599 | |
22688 | 22688 | 1910-04-23 | 3 | b-c | Naval forces in America, Austria, Germany and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/26802598 | 26802598 | |
22705 | 22705 | 1910-04-23 | 8 | b-c | Jiang Chunlin and his story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802605 | 26802605 |
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]);