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 |
---|---|---|---|---|---|---|---|---|---|
11606 | 11606 | 1903-03-14 | 2 | b | A Japanese businessman tries to set up a transportation company in Beijing. | China | http://trove.nla.gov.au/newspaper/page/26800187 | 26800187 | |
11607 | 11607 | 1903-03-14 | 2 | b | An official in Beijing suggests collecting a patriotic tax. | China | http://trove.nla.gov.au/newspaper/page/26800187 | 26800187 | |
11608 | 11608 | 1903-03-14 | 2 | b | Jiang Shixing, an upright official, has resigned. | China | http://trove.nla.gov.au/newspaper/page/26800187 | 26800187 | |
11609 | 11609 | 1903-03-14 | 2 | b | Duan Fang, governor of Hubei province, set a time limit for a navy officer to quit opium smoking. | China | http://trove.nla.gov.au/newspaper/page/26800187 | 26800187 | |
11610 | 11610 | 1903-03-14 | 2 | b | Cheats found in the imperial examination in Sichuan. | China | http://trove.nla.gov.au/newspaper/page/26800187 | 26800187 | |
11611 | 11611 | 1903-03-14 | 2 | b | Dong Fuxiang only wants to protect himself with his army. | China | http://trove.nla.gov.au/newspaper/page/26800187 | 26800187 | |
11623 | 11623 | 1903-03-14 | 3 | b | Ten poems written by Kang Youwei on the departure of his daughter, Kang Tongbi, for Europe and America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800186 | 26800186 | |
11624 | 11624 | 1903-03-14 | 3 | b | A further report on the Hanoi fair. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800186 | 26800186 | |
11625 | 11625 | 1903-03-14 | 3 | b | James Zhu Xing teaches English to Chinese migrants at the Chinese church in Tooma, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800186 | 26800186 | |
11626 | 11626 | 1903-03-14 | 3 | b | A man in Perth was penalised for ganging up with Chinese gamblers. | Australia | http://trove.nla.gov.au/newspaper/page/26800186 | 26800186 |
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]);