This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25865 | 25865 | 1912-03-16 | 2 | c-d | Conditions for imperial abdication | Republic representative Wu Tingfang presents Yuan Shikai beneficial conditions for imperial abdication. | Other... | http://trove.nla.gov.au/newspaper/page/24092165 | 24092165 |
25877 | 25877 | 1912-03-16 | 3 | c-d | Guangdong news | Various organisations recommend Sun Mei as Guangdong governor. Drug smoking ban bureau still no pratical ways to stop drug smoking. Zhaoqing county security committee set up. Guangdong and Guangxi jointly control Xijiang River. Missionary shot down by gangsters. Blood appeal for overthrow of Qing government. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25894 | 25894 | 1912-03-16 | 8 | c-d | Donations to republic army | Sydney Bureau for Donations to Republic Army issues its notice. More than 500 names listed for their donations. | 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]);