This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 30963 | 30963 | 1916-02-19 | 3 | c-d | Information about process of the uprise of Yunnan Republican Troops. | China | http://trove.nla.gov.au/newspaper/page/24095162 | 24095162 | |
| 30977 | 30977 | 1916-02-19 | 8 | c-d | Chen Junming is the head of revolutionary troops in Guangdong for this uprise. The Republican troops attack different places through three major routines. The Revolutionary government notifies that good awards will be given to those who kill major military officials of Yuan's government. Two persons in Gaoyao, Guangdong, are arrested as suspects of riot party members. | China | http://trove.nla.gov.au/newspaper/page/24095169 | 24095169 |
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]);