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 |
---|---|---|---|---|---|---|---|---|---|
21095 | 21095 | 1909-06-05 | 2 | c | List of provincial officials in China (governor, imperial commissioner, military commander, etc.). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802206 | 26802206 | |
21096 | 21096 | 1909-06-05 | 2 | c | Hong Kong to establish a university. | Britain | http://trove.nla.gov.au/newspaper/page/26802206 | 26802206 | |
21113 | 21113 | 1909-06-05 | 6 | c | The wealth of Korea (territory, personal property, library, railway, mining resources, and others). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802210 | 26802210 | |
21122 | 21122 | 1909-06-05 | 7 | c | Sa Zhenbing, Li Jingyi and 47 other officials from Fujian province ask for rehabilitation of the officials who were removed after the 1898 Reform movement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802209 | 26802209 | |
21123 | 21123 | 1909-06-05 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802209 | 26802209 |
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]);