This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26277 | 26277 | 1912-06-15 | 2 | c | Letters form Beijing | Premier Tang attempted to place people in Domestic Ministry and conflicted with the minister. Domestic minister Zhao claims to resign. Yang Jinchen and Tang Jirao are competing for governor of Guizhou. | China | http://trove.nla.gov.au/newspaper/page/24092272 | 24092272 |
26299 | 26299 | 1912-06-15 | 6 | c | Reducation of overstaffed members | New government is reducing overstaffed members in each department. | China | http://trove.nla.gov.au/newspaper/page/24092276 | 24092276 |
26300 | 26300 | 1912-06-15 | 6 | c | Military coup in Guangxi | Military coup which made heavy damage in Guangxi was crashed. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24092276 | 24092276 |
26301 | 26301 | 1912-06-15 | 6 | c | Government troops attack local gangsters | Government troops attack local gangsters in Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24092276 | 24092276 |
26302 | 26302 | 1912-06-15 | 6 | c | party representatives in republic parliament | Number of various party representatives in republic parliament. | China | http://trove.nla.gov.au/newspaper/page/24092276 | 24092276 |
26305 | 26305 | 1912-06-15 | 7 | c | China borrows more foreign loans | China borrows more foreign loans from America for rebuilding business in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24092275 | 24092275 |
26306 | 26306 | 1912-06-15 | 7 | c | An American's comments | An American makes his comments on current China. | Other... | http://trove.nla.gov.au/newspaper/page/24092275 | 24092275 |
26310 | 26310 | 1912-06-15 | 8 | c | New plan for rebuilding Hankou | New plan for rebuilding Hankou as new investor joins. | Other... | http://trove.nla.gov.au/newspaper/page/24092278 | 24092278 |
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]);