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 |
---|---|---|---|---|---|---|---|---|---|
25596 | 25596 | 1912-01-20 | 2 | c-d | Anhui governor | Anhui people want to kill their corrupted governor. | Other... | http://trove.nla.gov.au/newspaper/page/24092075 | 24092075 |
25613 | 25613 | 1912-01-20 | 3 | c-d | Guangdong news | Huang Shilong determines to resign from the government. Governor Hu asks Huang Shilong not to resign. Elected military representives are going to Hunan to assist military planning. A robbery occurs in a hotel in Guangdong. Some people advise Guangdong government to levy heavy tax on opium rather than ban it. A conflict occurs between two troops resulting in battles in Guangdong. The revolutionary troops disembowelled Zhen Jiasheng for revenging his killing revolutionaries. More than twenty people were disembowelled in various ways by the revolutionary troops. Temporary government in Guangzhou is electing its chiefs of the senate. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25631 | 25631 | 1912-01-20 | 8 | c-d | Robberies occur often in Guangdong after revolution | Gun robberies after revolution occurred in many places in Guangdong, leading to great panic of people. | China | http://trove.nla.gov.au/newspaper/page/24092081 | 24092081 |
25632 | 25632 | 1912-01-20 | 8 | c-d | Poetry | Some poems of Wang Jingwei's. | Other... | http://trove.nla.gov.au/newspaper/page/24092081 | 24092081 |
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]);