This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24420 | 24420 | 1911-03-11 | 6 | a | Headline news | Zegong was appointed Premier and other new appointments; Governor of Yunan province asked for help to deal with the British over its boarder; both Japan and Russia used excuses to interfere northeast China; State council member quited; postpone of the national examination due to its too restrict regulations; Noble Xun would inspect Tianjin and decided to build a shipyard and have more troops; State Council will issue the election law; the Transport Department would postpone the suggestion of transport privitalisation. | China | http://trove.nla.gov.au/newspaper/page/24091698 | 24091698 |
24421 | 24421 | 1911-03-11 | 6 | a-b | National traitors | Two persons illegally sold mines in Hunan to foreigners. | China | http://trove.nla.gov.au/newspaper/page/24091698 | 24091698 |
24422 | 24422 | 1911-03-11 | 6 | b | Massacre in Suzhou | A fight happened between refugees from Xuhai and residents of Kunshan which ended a massacre of all the refugees. | China | http://trove.nla.gov.au/newspaper/page/24091698 | 24091698 |
24423 | 24423 | 1911-03-11 | 6 | b-c | Some commentaries | Tokyo news about comments on a British writer's concept of Japan; and comments on China's advisory committee. | Other... | http://trove.nla.gov.au/newspaper/page/24091698 | 24091698 |
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]);