This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19270 | 19270 | 1908-05-02 | 2 | a-b | Second part of Kang Youwei's travel notes to Germany and Austria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801718 | 26801718 | |
19279 | 19279 | 1908-05-02 | 3 | a-b | Beijing news. Tang Shaoyi is summoned to Beijing for new appointment. Preparation under way for the autumn military parade in north China. China to conduct a survey on Cantonese business overseas. Yuan Shikai seeks to quit from the department of foreign affairs. Hunan representatives arrive Beijing for constitutional reform and establishment of parliament. Koreans on Jiandao island want to stay with China. | China | http://trove.nla.gov.au/newspaper/page/26801717 | 26801717 | |
19293 | 19293 | 1908-05-02 | 7 | a-b | Chinese community in Rockhampton, Queensland, supports boycott of Japanese goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801721 | 26801721 | |
19307 | 19307 | 1908-05-02 | 8 | a-b | First part of the draft bank regulation submitted by Board of Revenue. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801724 | 26801724 |
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]);