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 |
---|---|---|---|---|---|---|---|---|---|
10415 | 10415 | 1902-04-26 | 2 | d | Yuan Shikai once again put forward his reform proposal. | China | http://trove.nla.gov.au/newspaper/page/24100404 | 24100404 | |
10416 | 10416 | 1902-04-26 | 2 | d | Chinese cabinet decides that some official positions will be sold in order to lighten tax burden of the state. | China | http://trove.nla.gov.au/newspaper/page/24100404 | 24100404 | |
10417 | 10417 | 1902-04-26 | 2 | d | China is going to re-organise the security troops employed to protect the imperial court. | China | http://trove.nla.gov.au/newspaper/page/24100404 | 24100404 | |
10418 | 10418 | 1902-04-26 | 2 | d | Foreign language school to be established in Baoding, Zhili province. Foreign teachers needed. Timothy Richard and foreign language education in Shanxi. | China | http://trove.nla.gov.au/newspaper/page/24100404 | 24100404 | |
10419 | 10419 | 1902-04-26 | 2 | d | Yan Fu recommended Yuan Shikai for university management. | China | http://trove.nla.gov.au/newspaper/page/24100404 | 24100404 | |
10420 | 10420 | 1902-04-26 | 2 | d | Zhang Yeqiu proposes establishing a translation & publishing office, a library and a museum but the funds are in short. | China | http://trove.nla.gov.au/newspaper/page/24100404 | 24100404 | |
10421 | 10421 | 1902-04-26 | 2 | d | Several imperial scholars in Beijing try to stop sending Chinese students to study in Japan. | China | http://trove.nla.gov.au/newspaper/page/24100404 | 24100404 | |
10441 | 10441 | 1902-04-26 | 3 | d | A shop in Dongguan, Guangdong, was destroyed in fire after burglary. | China | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10442 | 10442 | 1902-04-26 | 3 | d | Earthquake in America. | Australia | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 | |
10443 | 10443 | 1902-04-26 | 3 | d | A big fire in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100403 | 24100403 |
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]);