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 |
---|---|---|---|---|---|---|---|---|---|
25092 | 25092 | 1911-10-07 | 2 | d | Budget reduction for imperial family | Budget for imperial family is to be reduced. | Other... | http://trove.nla.gov.au/newspaper/page/24091947 | 24091947 |
25093 | 25093 | 1911-10-07 | 2 | d | Imperial family members and relatives set up a fund for floods | Imperial family members and their relatives set up a fund for floods. | Other... | http://trove.nla.gov.au/newspaper/page/24091947 | 24091947 |
25094 | 25094 | 1911-10-07 | 2 | d | A woman director for American Coin Bureau | A woman is promoted director for American Coin Bureau. | America | http://trove.nla.gov.au/newspaper/page/24091947 | 24091947 |
25095 | 25095 | 1911-10-07 | 2 | d | On current affairs | The article comments officials' corruption in China. | Other... | http://trove.nla.gov.au/newspaper/page/24091947 | 24091947 |
25119 | 25119 | 1911-10-07 | 8 | d | Chats | Unique wedding in Romania. Japanese story about a wild island. | Other... | http://trove.nla.gov.au/newspaper/page/24091953 | 24091953 |
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]);