This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25555 | 25555 | 1912-01-13 | 2 | a | On Chinese dragon flags | Comments on the power of Chinese dragon flags. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
25556 | 25556 | 1912-01-13 | 2 | a | National Republic China Association | Newly established National Republic China Association in Suzhou, Jiangsu issues a statement about its aims, structure and membership. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
25557 | 25557 | 1912-01-13 | 2 | b-c | Beijing correspondence | Government bans publication of notices against government found in Beijing. Navy department sends two spies to persuade foreign warships in Shanghai against revolutionaries. Corruption of the parliament for selling Shangdong for money. Yuan Shikai intends to borrow more foreign loans from Britain, France and Belgium. Republic sympathiser Yang Du hides in Tianjin. Princes set ban on all newspapers and close all universities. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
25558 | 25558 | 1912-01-13 | 2 | c | Hubei governor's special message | Hubei governor sends special message to all other provincial governments for help after he lost Hanyang to revolutionaries. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
25559 | 25559 | 1912-01-13 | 2 | c | Republic military government should be dissolved | Republic military government should be dissolved due to their advocacy for one party government. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
25560 | 25560 | 1912-01-13 | 2 | c-d | Guilin situation | Guilin back to normal after three day riots. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
25561 | 25561 | 1912-01-13 | 2 | d | Fort barbettes along Yangtze River | Number and arrangements of government fort barbettes along Yangtze River. | Other... | http://trove.nla.gov.au/newspaper/page/24092067 | 24092067 |
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]);