This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10981 | 10981 | 1902-09-06 | 2 | a | Imperial edicts on May 21. | China | http://trove.nla.gov.au/newspaper/page/24100485 | 24100485 | |
10982 | 10982 | 1902-09-06 | 2 | a | Second and final part of the editorial saying that only the downfall of Qing dynasty is a hope of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100485 | 24100485 | |
10983 | 10983 | 1902-09-06 | 2 | b | China prefers to pay silver dollars for the Boxer indemnity and has disputes with foreign missions; a foreign mission serves as mediator for this dispute; China to collect gold for customs duties. | China | http://trove.nla.gov.au/newspaper/page/24100485 | 24100485 | |
10984 | 10984 | 1902-09-06 | 2 | b | Li Shengduo, former ambassador to Japan reports to the Empress; relations between Zhang Yeqiu, Rong Lu and Li Shengduo. | China | http://trove.nla.gov.au/newspaper/page/24100485 | 24100485 | |
10985 | 10985 | 1902-09-06 | 2 | b | Huang Zengyuan impeaches Chen Bi. | China | http://trove.nla.gov.au/newspaper/page/24100485 | 24100485 | |
10986 | 10986 | 1902-09-06 | 2 | b | Report on an imperial examination. | China | http://trove.nla.gov.au/newspaper/page/24100485 | 24100485 | |
10987 | 10987 | 1902-09-06 | 2 | b | Shen Jiaben and others are instructed to revise China's law. | China | http://trove.nla.gov.au/newspaper/page/24100485 | 24100485 |
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]);