This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25885 | 25885 | 1912-03-16 | 7 | a-b | Australian news | Chinese consulate in Melbourne passes on President Yuan Shikai's message to Chinese organisations in Sydney for their support. Several Australian warships are to be ready for service. Australian wool export increased. Robbery caught. German consulate robbed. Young girl charged for theft. Several Chinese beaten by westerners. Illegal entrees from Hong Kong. Two ships collided. | Other... | http://trove.nla.gov.au/newspaper/page/24092169 | 24092169 |
25886 | 25886 | 1912-03-16 | 7 | b | Yuan Shikai's inaugural ceremony | Yuan Shikai has president inaugural ceremony. | China | http://trove.nla.gov.au/newspaper/page/24092169 | 24092169 |
25887 | 25887 | 1912-03-16 | 7 | b | Tianjin told to arrest all rebel soldiers | Tianjin government and foreign concessions told to arrest all rebel soldiers. | China | http://trove.nla.gov.au/newspaper/page/24092169 | 24092169 |
25888 | 25888 | 1912-03-16 | 7 | b-c | Rebels in Guangzhou | Rebels fight government troops in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24092169 | 24092169 |
25889 | 25889 | 1912-03-16 | 7 | c | Tang Shaoyi elected premier | Tang Shaoyi elected premier of the republic. | Britain | http://trove.nla.gov.au/newspaper/page/24092169 | 24092169 |
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]);