This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24785 | 24785 | 1911-08-05 | 2 | a-b | The tragedy in Mexico | Details reveal the tragedy in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091867 | 24091867 |
24786 | 24786 | 1911-08-05 | 2 | b-c | Imperial edicts | Several imperial edicts. | Other... | http://trove.nla.gov.au/newspaper/page/24091867 | 24091867 |
24787 | 24787 | 1911-08-05 | 2 | c | Brief headline news | New money is to be in use. Russia horse cavalry is three times more than Chinese's in Manchu and Mongolia. Governor Zhang Renjun orders Dai Naihuang to pay his debts. Money supplies for empress's life at Summer Palace. The design of uniform for diplomats. Flood in Hunan. The navy department asks the cruiser to go to Germany after its visit to America. | Other... | http://trove.nla.gov.au/newspaper/page/24091867 | 24091867 |
24792 | 24792 | 1911-08-05 | 3 | a | Turkey fire | Fire in Turkey destroyed thousands of houses and other properties. | Other... | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24798 | 24798 | 1911-08-05 | 3 | b | Plague in Singapore | Forty people died of plague in Singapore. | Other... | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24807 | 24807 | 1911-08-05 | 6 | b | Wealth of France | Statistics show industrial and agricultural wealth of France. | Other... | http://trove.nla.gov.au/newspaper/page/24091871 | 24091871 |
24808 | 24808 | 1911-08-05 | 6 | b | Criticism | Criticising corruptions in China. | Other... | http://trove.nla.gov.au/newspaper/page/24091871 | 24091871 |
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]);