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 |
---|---|---|---|---|---|---|---|---|---|
25379 | 25379 | 1911-12-09 | 2 | c | Message from Beijing | A message from Beijing that Hanyang is recaptured by government troops. | China | http://trove.nla.gov.au/newspaper/page/24092027 | 24092027 |
25380 | 25380 | 1911-12-09 | 2 | c | Reports on progress of revolution | Several reports about progress of revolution in various parts of China. | China | http://trove.nla.gov.au/newspaper/page/24092027 | 24092027 |
25391 | 25391 | 1911-12-09 | 3 | c | Government's attitude toward public opinions | Government is more careful of public opinions. | China | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25392 | 25392 | 1911-12-09 | 3 | c | New regulations in the constitution | New important regulations in the constitution include emperor's limits of right etc. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25393 | 25393 | 1911-12-09 | 3 | c | Chaos in Hubei government | Officials of Hubei government flee one after another due to revolutionary riots. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25394 | 25394 | 1911-12-09 | 3 | c | Military office examines Hubei financial account | Military office examines Hubei financial account. | Other... | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
25409 | 25409 | 1911-12-09 | 7 | c | Japanese miliatry and economy | Japan decides to build more warships next year, which is to affect its economy greatly. | Japan | http://trove.nla.gov.au/newspaper/page/24092030 | 24092030 |
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]);