This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
11892 | 11892 | 1903-05-30 | 2 | b | Empress Dowager wants Yuan Shikai to be in the Cabinet; Yuan Shikai reports to the Empress; homage to the Western Imperial Mausoleum; Pan Qinglan proposes to abolish imperial examination; Li Zhuohua impeaches Zhang Zhidong and Yuan Shikai; Japanese experts invited to revise China's law; foreign missions want to open Beijing for international trade. | China | http://trove.nla.gov.au/newspaper/page/26800232 | 26800232 | |
11893 | 11893 | 1903-05-30 | 2 | b | Students of a military school boycott class. | China | http://trove.nla.gov.au/newspaper/page/26800232 | 26800232 | |
11894 | 11894 | 1903-05-30 | 2 | b | Forty students from Hunan province are to study in Japan; Fifty-two students from Hubei and Zhejiang provinces are on the way to Japan. | China | http://trove.nla.gov.au/newspaper/page/26800232 | 26800232 | |
11902 | 11902 | 1903-05-30 | 3 | b | Many Jewish people have been murdered in Russia. Responses from America, Britain and other areas of the world. | Britain | http://trove.nla.gov.au/newspaper/page/26800231 | 26800231 | |
11903 | 11903 | 1903-05-30 | 3 | b | A fire in Manila. | Australia | http://trove.nla.gov.au/newspaper/page/26800231 | 26800231 |
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]);