This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17531 | 17531 | 1907-06-01 | 2 | b-c | News on the Chinese Empire Reform Association. Delegations from branches of the Chinese Empire Reform Association around the world gather in New York. They call for donations from members of the association in order to set up the association school. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801348 | 26801348 | |
17536 | 17536 | 1907-06-01 | 3 | b-c | A bomb blast in Russia. A suspect has been detained. | Australia | http://trove.nla.gov.au/newspaper/page/26801347 | 26801347 | |
17547 | 17547 | 1907-06-01 | 6 | b-c | Report submitted by imperial scholar Zhao Qilin suggests postponing reform of local civil service system. | China | http://trove.nla.gov.au/newspaper/page/26801352 | 26801352 |
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]);