This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6072 | 6072 | 1900-09-15 | 2 | b-c | The second and final part of Kang Youwei's interview with a Hong Kong newspaper on China's foreign policy. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102948 | 24102948 | |
6078 | 6078 | 1900-09-15 | 2 | e | Emperor calls ministers to discuss current situation in China, opinions amongst ministers differ. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102948 | 24102948 | |
6082 | 6082 | 1900-09-15 | 2 | f | Reformers in Shanghai had a meeting in Yuyuan park discussing the establishment of a parliament in China. The speaker will be Rong Hong, the first Chinese student to America and former Chinese ambassador, while the deputy speaker will be Yan Fu, former president of Beiyang school in Tianjin. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102948 | 24102948 | |
6088 | 6088 | 1900-09-15 | 3 | a | The number of foreign soldiers in China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102947 | 24102947 |
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]);