This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18096 | 18096 | 1907-09-14 | 2 | d | Translation. Chinese translation of the treaty recently signed by Japan and Korea (Emperor of Korea dethroned, Korea totally conquered by Japan). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801468 | 26801468 | |
18107 | 18107 | 1907-09-14 | 3 | d | Report on ant-Asian (Japanese, Korean and Chinese) movement in Vancouver, Canada. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801467 | 26801467 | |
18108 | 18108 | 1907-09-14 | 3 | d | Bandits in Korea attack and murder Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801467 | 26801467 | |
18109 | 18109 | 1907-09-14 | 3 | d | Imperial edict. Imperial edict on June 24 encourages agriculture, enterprise, commerce and mining. Imperial edict on July 2 to abolish boundary between Han and Manchurian peoples. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801467 | 26801467 | |
18110 | 18110 | 1907-09-14 | 3 | d | A letter from Tung Wah (dong hua) Hospital in Hong Kong to the Sydney Chinese Empire Reform Association, Tung Wah Times, and Chinese communities in Australia acknowledging receipt of their donations for Guangdong rice market. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801467 | 26801467 |
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]);