This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25899 | 25899 | 1912-03-23 | 2 | c-d | Preferentials for the imperial abdication | Nanjing republic government upper house passed a solution of preferentials for the imperial abdication. | Other... | http://trove.nla.gov.au/newspaper/page/24092174 | 24092174 |
25914 | 25914 | 1912-03-23 | 3 | c-d | Guangdong news | Troops of both the revolutionaries and Beijing government agree to establish a united organisation, however, a certain country (Japan, not named) is trying to break it. Some government troops in Guangdong are robbing too. An assassination organisation is set up in Guangdong to wipe away diehards of the Qing government. An organisation of textile and dying firms is established in Guangdong. Illegal associations in Gaoyao, Guangdong, aroused social instabilities. The military government in Guangzhou can't deal with bandits' robberies. A man was shot dead for damaging guns on important sites. Bandits robberies in Xijiang, Guangdong, are still increasing. | http://trove.nla.gov.au/newspaper/page/24092173 | 24092173 | |
25924 | 25924 | 1912-03-23 | 8 | c-d | Donation advertisement | Donations for the revolutionary army in China; names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092180 | 24092180 |
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]);