This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25459 | 25459 | 1911-12-23 | 3 | a | Britain and Germany are to fight each other | A British senator says in New York that a war will occur between Britain and Germany. | America | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25460 | 25460 | 1911-12-23 | 3 | b | American navy is powerful | American navy has 99 various warships and the president inspects navy port. | America | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25462 | 25462 | 1911-12-23 | 3 | b | Overseas Chinese students supported by the government are short of fund | No fund is provided from the government to overseas students in America since the revolutionary uprising. | America | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
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]);