This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18460 | 18460 | 1907-11-16 | 2 | a-b | An article written by anonymous author claims that unhygienic life style helps Chinese people to be conquered. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801540 | 26801540 | |
18461 | 18461 | 1907-11-16 | 2 | b | A survey of constitutionalism and the parliamentary system in Britain, France, Germany, Italy, Belgium, Spain, Portugal, Austria-Hungary, Holland, Switzerland, Sweden and Norway, Denmark, Romania, Greece, United States, Mexico, Peru, Chile and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801540 | 26801540 | |
18462 | 18462 | 1907-11-16 | 2 | b-c | Introductory message, written by Kang Youwei, to a Chinese school in Mexico. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801540 | 26801540 | |
18463 | 18463 | 1907-11-16 | 2 | c | Diplomatic negotiations. China and Japan negotiate over the Jiandao island in Tumenjiang River. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801540 | 26801540 |
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]);