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 |
---|---|---|---|---|---|---|---|---|---|
11308 | 11308 | 1902-12-20 | 2 | c | Stories of Wen Ti, magistrate of Kaifeng, Henan province. | China | http://trove.nla.gov.au/newspaper/page/24100554 | 24100554 | |
11309 | 11309 | 1902-12-20 | 2 | c | De Shou, governor of Guangdong and Guangxi provinces, was impeached. | China | http://trove.nla.gov.au/newspaper/page/24100554 | 24100554 | |
11310 | 11310 | 1902-12-20 | 2 | c | Pei Jingfu, magistrate of Nanhai county, settled a dispute skilfully and peacefully. | China | http://trove.nla.gov.au/newspaper/page/24100554 | 24100554 | |
11311 | 11311 | 1902-12-20 | 2 | c | Liang Dingfen feels embarrassed as Zhang Zhidong is leaving. | China | http://trove.nla.gov.au/newspaper/page/24100554 | 24100554 | |
11312 | 11312 | 1902-12-20 | 2 | c | Japan proposes to open the three northeastern provinces (Manchuria) to international trade. | China | http://trove.nla.gov.au/newspaper/page/24100554 | 24100554 | |
11313 | 11313 | 1902-12-20 | 2 | c | Guangdong government is investigating weapon smuggling. | China | http://trove.nla.gov.au/newspaper/page/24100554 | 24100554 | |
11322 | 11322 | 1902-12-20 | 3 | c | French in Thailand. | Australia | http://trove.nla.gov.au/newspaper/page/24100553 | 24100553 | |
11323 | 11323 | 1902-12-20 | 3 | c | Chinese ambassador to America, Wu Tingfang, is returning. | America | http://trove.nla.gov.au/newspaper/page/24100553 | 24100553 | |
11324 | 11324 | 1902-12-20 | 3 | c | Wu Rulun was sadly moved by the sights in Shimonoseki, Japan, where Li Hongzhang once signed a treaty with Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24100553 | 24100553 | |
11325 | 11325 | 1902-12-20 | 3 | c | Australian federal parliament sits again and will debate immigration restrictions. | Australia | http://trove.nla.gov.au/newspaper/page/24100553 | 24100553 | |
11326 | 11326 | 1902-12-20 | 3 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100553 | 24100553 |
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]);