This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25204 | 25204 | 1911-10-28 | 7 | a | Notice for donations | Sydney Imperial Constitution Association asks for donations to floods in Anhui. | Other... | http://trove.nla.gov.au/newspaper/page/24091979 | 24091979 |
25205 | 25205 | 1911-10-28 | 7 | a-b | Australian news | Celebration for Confucius's birthday. Federal army chief asks for attention to Japan. Sydney train station is to be built. Sydney World Workers Union Conference opened yesterday. Chairman of Sydney Imperial Constitution Association gives a report on his visit to China. Celebration for Confucius's birthday held outside Sydney. | http://trove.nla.gov.au/newspaper/page/24091979 | 24091979 | |
25206 | 25206 | 1911-10-28 | 7 | b | Korean hero sentenced | Korean hero against Japanese control over Korea is sentenced. | Other... | http://trove.nla.gov.au/newspaper/page/24091979 | 24091979 |
25207 | 25207 | 1911-10-28 | 7 | b | Martyr Liu | Appraisal of Martyr Liu Shengyuan for his devotion to protection of China's railways. | Other... | http://trove.nla.gov.au/newspaper/page/24091979 | 24091979 |
25208 | 25208 | 1911-10-28 | 7 | b-c | Revolutionary riots | Imperial family members fled to Hebei for the fear of revolutionary riots in Beijing. (continued on supplement page) | Britain | http://trove.nla.gov.au/newspaper/page/24091979 | 24091979 |
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]);