This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18180 | 18180 | 1907-09-28 | 2 | b-c | Influence of assassination upon Chinese politics (Empress Dowager comments on revolutionaries, government officials in Beijing comment on revolutionaries, Tie Liang comments on revolutionaries, local governors and imperial commissioners comment on revolutionaries.) | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801484 | 26801484 | |
18197 | 18197 | 1907-09-28 | 6 | b-c | A report on current Chinese affairs, submitted by Huang Tong, a resident from Taiwan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801488 | 26801488 | |
18206 | 18206 | 1907-09-28 | 7 | b-c | Correspondence from Singapore. Singaporean authority bans opium trading and smoking, and the specific measures. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801487 | 26801487 | |
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 |
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]);