This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24407 | 24407 | 1911-03-11 | 3 | a | The epidemic in Manchu | More than ten thousand died of the epidemic in Manchu. | Russia | http://trove.nla.gov.au/newspaper/page/24091693 | 24091693 |
24409 | 24409 | 1911-03-11 | 3 | a | Chinese hatred of foreigners | Chinese hatred of foreigners is spreading in Manchu. | Russia | http://trove.nla.gov.au/newspaper/page/24091693 | 24091693 |
24410 | 24410 | 1911-03-11 | 3 | a | Budget for building areoboats in Russia | Russia has announced its budget for building its areoboats. | Russia | http://trove.nla.gov.au/newspaper/page/24091693 | 24091693 |
24411 | 24411 | 1911-03-11 | 3 | a | The pain of nationless Jews | The Russian government has made a policy to expel Jews in Russian army and politics. | Russia | http://trove.nla.gov.au/newspaper/page/24091693 | 24091693 |
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]);