This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26650 | 26650 | 1912-08-31 | 2 | c-d | Beijing army succeeds in maintaining peace in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26653 | 26653 | 1912-08-31 | 2 | d | Japan-Russian treaty on invasion of Manchu and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24092360 | 24092360 | |
26655 | 26655 | 1912-08-31 | a | a | Beijing senate inquires about prosecution of two senior army officials. Sun Yat-sen goes to Tianjin to meet former premier. Newspapers in the south accuse President Yuan's killing of two senior army officials. Fights start in Hubei. | China | http://trove.nla.gov.au/newspaper/page/24092357 | 24092357 | |
26661 | 26661 | 1912-08-31 | 3 | b | British ambassador criticises President Yuan's killing of two senior army officials. | China | http://trove.nla.gov.au/newspaper/page/24092359 | 24092359 | |
26662 | 26662 | 1912-08-31 | 3 | b | President Yuan has persuaded senate on killing of two senior army officials. | China | http://trove.nla.gov.au/newspaper/page/24092359 | 24092359 | |
26666 | 26666 | 1912-08-31 | 3 | b | Sun Yat-sen intends to reconciliate various parties. | China | http://trove.nla.gov.au/newspaper/page/24092359 | 24092359 | |
26667 | 26667 | 1912-08-31 | 3 | b | Sun Yat-sen welcomed by all in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24092359 | 24092359 |
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]);