This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
216 | 216 | 1898-07-20 | 3 | a | Adelaide gunman wins London championship. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
217 | 217 | 1898-07-20 | 3 | a | Black Flag rebels in Guangxi cause social chaos and take over seven towns. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
218 | 218 | 1898-07-20 | 3 | a | Man in Sydney kills himself with gun. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
219 | 219 | 1898-07-20 | 3 | a-b | Guangdong government issues new policy encouraging people to cultivate wasteland. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
220 | 220 | 1898-07-20 | 3 | b-c | The Yuan family in Dongguan resume fighting with enemies in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
221 | 221 | 1898-07-20 | 3 | c | Disease epidemic spreads though Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
222 | 222 | 1898-07-20 | 3 | c-d | Court case, Bombala, NSW, gold dispute between Chinese and government. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
223 | 223 | 1898-07-20 | 3 | d | Man killed by Sydney train. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
224 | 224 | 1898-07-20 | 3 | d-e | Famine in Wenzhou, Zhejiang province, his followed by chaos. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
225 | 225 | 1898-07-20 | 3 | e | War, Philippines, fighting between American troops and Luzon military forces continues. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
226 | 226 | 1898-07-20 | 3 | e-f | Corrupt official in Zhejiang province has been sentenced. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 |
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]);