This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6257 | 6257 | 1900-10-10 | 2 | f | Shanhaiguan has been occupied by foreign troops. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6258 | 6258 | 1900-10-10 | 2 | f | Britain and other European countries praise German's suggestion on China affairs. | Australia | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6259 | 6259 | 1900-10-10 | 2 | f | Chinese and German troops fought near Beijing. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6260 | 6260 | 1900-10-10 | 2 | f | Russian troops in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6261 | 6261 | 1900-10-10 | 2 | f | Bandits in Nanling county, Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6262 | 6262 | 1900-10-10 | 2 | f | Bandits in south Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6263 | 6263 | 1900-10-10 | 2 | f | Bandits captured in Wenzhou were sent to provincial capital under escort. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6264 | 6264 | 1900-10-10 | 2 | f | The army from Guangdong under the command of Liu Yuanting and Feng Cuiting found a way to keep out the cold on their way north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 |
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]);