This data as json, CSV (advanced)
Suggested facets: page, title, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25860 | 25860 | 1912-03-16 | 2 | a | Notice of Sydney Imperial Constitution Association | Notice of Sydney Imperial Constitution Association for clarification, the Association is not an imperial protection organisation. | Other... | http://trove.nla.gov.au/newspaper/page/24092165 | 24092165 |
25861 | 25861 | 1912-03-16 | 2 | a | Notice of Sydney Imperial Constitution Association | Notice of Sydney Imperial Constitution Association claims change of Association name to Nationalist Party. | Other... | http://trove.nla.gov.au/newspaper/page/24092165 | 24092165 |
25868 | 25868 | 1912-03-16 | 3 | a | Beijing mutiny | Riot in Beijing results from mutiny. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25869 | 25869 | 1912-03-16 | 3 | a | Italian navy chief dies | Italian navy chief dies. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25870 | 25870 | 1912-03-16 | 3 | a | Italian excellent weapons | Italian excellent weapons of aircraft bombs. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25871 | 25871 | 1912-03-16 | 3 | a | Riot in Mexico | Revolutionaries vows riot and killing of foreigners in Mexico if America intervenes Mexico affairs. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25878 | 25878 | 1912-03-16 | suppl. | a | Notice for donations to republic army | Members of Xiangshan Bureau for Donations in Hong Kong issues notice for donations to republic army. | Other... | http://trove.nla.gov.au/newspaper/page/24092166 | 24092166 |
25879 | 25879 | 1912-03-16 | suppl. | a | Xiangshan county mayor's notice | Xianshan county mayor's notice for donations to republic army. | Other... | http://trove.nla.gov.au/newspaper/page/24092166 | 24092166 |
25881 | 25881 | 1912-03-16 | 6 | a | Notice for donations to disasters in Hankou | Notice of Sydney Business Protection Assoication and Sydney Imperial Constitution Association for donations to disasters in Hankou. | Other... | http://trove.nla.gov.au/newspaper/page/24092170 | 24092170 |
25890 | 25890 | 1912-03-16 | 8 | a | Miscellany of democratic nations | Development of democracy in France. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24092172 | 24092172 |
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]);