This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17674 | 17674 | 1907-06-29 | 2 | b-c | Detailed report on the rebellion in Chaozhou, Shantou area and response of the government authorities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801380 | 26801380 | |
17690 | 17690 | 1907-06-29 | 6 | b-c | Actual number of overseas Chinese (in Japan, Korea, Asian part of Russia, Macao, Hong Kong, Malaya peninsula, Thailand, Burma, Vietnam, Taiwan, Philippines islands, Java islands, Africa, Australia, America and European countries). A survey of railway in Vietnam. A survey of Chinese graduates from Tokyo Law School. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26801384 | 26801384 |
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]);