This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25026 | 25026 | 1911-09-23 | 3 | a | Emperor starts schooling | Emperor starts his schooling. | China | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25027 | 25027 | 1911-09-23 | 3 | a | Famine in Singapore | Singapore suffers a famine due to natural disaster. | Singapore | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
25035 | 25035 | 1911-09-23 | 6 | a | Notice from Sydney Imperial Constitution Assoication | Notice from Sydney Imperial Constitution for recruitment of its members. | Other... | http://trove.nla.gov.au/newspaper/page/24091934 | 24091934 |
25036 | 25036 | 1911-09-23 | 6 | a | Advertisement of the World's Chinese Student's Journal | An advertisement by the World's Chinese Student's Journal. | Other... | http://trove.nla.gov.au/newspaper/page/24091934 | 24091934 |
25040 | 25040 | 1911-09-23 | 7 | a | Donations to floods in Anhui | Sydney Imperial Constitution Association calls for donations to the floods in Anhui. | Other... | http://trove.nla.gov.au/newspaper/page/24091933 | 24091933 |
25045 | 25045 | 1911-09-23 | 8 | a | Attack on Sun Wen's speech | An attack on Sun Wen's speech for revolutionary actions. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24091936 | 24091936 |
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]);