This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26768 | 26768 | 1912-09-21 | 3 | b | Two Russian warships's coup fail. | Russia | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26769 | 26769 | 1912-09-21 | 3 | b | France has a big military exercise. | France | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26770 | 26770 | 1912-09-21 | 3 | b | China and Britain plan to have a joint bank in London. | Britain | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26771 | 26771 | 1912-09-21 | 3 | b | Sun Yat-sen proposes to have a China and foreign nations joint railway company for contructing railways in China. | China | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26772 | 26772 | 1912-09-21 | 3 | b | More riots in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
26773 | 26773 | 1912-09-21 | 3 | b | Former Japanese king has a big funeral. | Japan | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 |
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]);