This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17902 | 17902 | 1907-08-03 | 8 | a-b | Fourth part of the report, prepared by Xu Rui, envoy of Chinese government, suggests to set up China Prosperity Commercial Company (zhongguo zhenxing shangwu zong gongsi) among overseas Chinese communities in order to protect the interest of China and overseas Chinese communities. The company will include steamship company, bank and insurance company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801426 | 26801426 | |
17903 | 17903 | 1907-08-03 | 8 | b-c | Article written by Liu Mingbo in memory of Chen Tianting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801426 | 26801426 | |
17904 | 17904 | 1907-08-03 | 8 | c | Military budget in various countries (Britain, France, Germany, United States, Russia, Italy and Japan) from 1881 to 1885 and from 1901 to 1905. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801426 | 26801426 | |
17905 | 17905 | 1907-08-03 | 8 | c-d | Jokes. Opium addiction and prostitution. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801426 | 26801426 |
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]);