This data as json, CSV (advanced)
Suggested facets: page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22476 | 22476 | 1910-03-12 | 2 | b-c | Imperial edict on October 20 and December 24 for the establishment of national parliament. | China | http://trove.nla.gov.au/newspaper/page/26802552 | 26802552 | |
22479 | 22479 | 1910-03-12 | 2-3 | d-a | Beijing news/ Prince Regent works hard. Emperor Xuantong likes to read books. Prince Regent to have a new mansion. New plan for development in Qinghai. China considers renewal of the treaty with Russia. Lu Zhengxiang reports to Beijing the international peace conference in Hague. Navy school to be built in seven province. Number of school and student in Zhili province. | China | http://trove.nla.gov.au/newspaper/page/26802552 | 26802552 | |
22505 | 22505 | 1910-03-12 | 8 | a | Recent activities of Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/26802559 | 26802559 |
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]);