This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28769 | 28769 | 1914-05-02 | 2 | b-c | Chinese President Yuan Shikai on the revision of constitution. | China | http://trove.nla.gov.au/newspaper/page/24093094 | 24093094 | |
28788 | 28788 | 1914-05-02 | 7 | b-c | Government troops defeat Bailang bandits in China. | Britain | http://trove.nla.gov.au/newspaper/page/24093097 | 24093097 | |
28793 | 28793 | 1914-05-02 | 8 | b-c | Guangdong news/ Military governor Long Jiguang says finance and local security should be managed simultaneously. Provincial authority to publicise the tactics of rebels. Deng Yaoguang advises local residents not to support revolutionary rebels. Curfew imposed in Xiangshan county town once again. Government troops try to suppress bandits in Nanhai county and the tragedy. Military governor disciplines government troops. | China | http://trove.nla.gov.au/newspaper/page/24093100 | 24093100 |
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]);