This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27484 | 27484 | 1913-05-24 | 3 | a | America sends more troops to Honolulu. | Britain | http://trove.nla.gov.au/newspaper/page/24092688 | 24092688 | |
27490 | 27490 | 1913-05-24 | 3 | b | China first gets 1.2 million foreign loans. | Britain | http://trove.nla.gov.au/newspaper/page/24092688 | 24092688 | |
27491 | 27491 | 1913-05-24 | 3 | b | China's national bonds on sale in London. | Britain | http://trove.nla.gov.au/newspaper/page/24092688 | 24092688 | |
27492 | 27492 | 1913-05-24 | 3 | b | British women continue activities for their vote right. | Britain | http://trove.nla.gov.au/newspaper/page/24092688 | 24092688 | |
27494 | 27494 | 1913-05-24 | 3 | b | Tornado in Philippine kills 57 persons. | Britain | http://trove.nla.gov.au/newspaper/page/24092688 | 24092688 | |
27495 | 27495 | 1913-05-24 | 3 | b | Cost detail of Balkan war. | Britain | http://trove.nla.gov.au/newspaper/page/24092688 | 24092688 | |
27504 | 27504 | 1913-05-24 | 7 | b | Beijing government strengthens its army force against south's intention of independence. | Britain | http://trove.nla.gov.au/newspaper/page/24092692 | 24092692 |
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]);