This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18211 | 18211 | 1907-09-28 | 8 | a-b | A public letter from Chinese Constitutional Reform Society in Tokyo (dongjing zhongguo jiang xi xian zheng hui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801490 | 26801490 | |
18212 | 18212 | 1907-09-28 | 8 | b-c | Survey and a report on Chinese students in Japan and their distribution. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801490 | 26801490 | |
18213 | 18213 | 1907-09-28 | 8 | c | Miscellaneous notes/ Zhong Rongguang (Xingke), a native of Guangzhou, is imprisoned for his revolutionary activity and a detailed report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801490 | 26801490 |
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]);