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 |
---|---|---|---|---|---|---|---|---|---|
26314 | 26314 | 1912-06-22 | 2 | b | Comment on donation | Comment on benefit of people's donation against borrowing foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/24092280 | 24092280 |
26328 | 26328 | 1912-06-22 | 3 | b | German newspaper talks about British navy | German newspaper thinks British navy is not strong enough against German navy if war starts between them. | Britain | http://trove.nla.gov.au/newspaper/page/24092279 | 24092279 |
26329 | 26329 | 1912-06-22 | 3 | b | German businessman hands over his property to his assistant | German businessman in Russia hands over his property to his shop assistant. | Russia | http://trove.nla.gov.au/newspaper/page/24092279 | 24092279 |
26330 | 26330 | 1912-06-22 | 3 | b | Soldier riot in Shandong | About 2000 soldiers in Shandong riot due to no food supplies. | China | http://trove.nla.gov.au/newspaper/page/24092279 | 24092279 |
26331 | 26331 | 1912-06-22 | 3 | b | British prime minister embarrassed | British prime minister embarrassed by protesters in India. | Britain | http://trove.nla.gov.au/newspaper/page/24092279 | 24092279 |
26332 | 26332 | 1912-06-22 | 3 | b | Spain detains suspect ship | Spain detains suspect ship. | Other... | http://trove.nla.gov.au/newspaper/page/24092279 | 24092279 |
26333 | 26333 | 1912-06-22 | 3 | b | Australian ambassador to Britain toursAmerica | Australian ambassador to Britain tours around America. | America | http://trove.nla.gov.au/newspaper/page/24092279 | 24092279 |
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]);