This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25147 | 25147 | 1911-10-14 | 7 | a | Australia news | Australian businessman is well treated in Japan. Labour Party of south Australia wins its parliament majority. Chief of British opium ban association comes to Australia. Newcastle's coal export in September. Federal Foreign Minister passed away. Labour power increases and leads to loss of both labour and capital. A Chinese shop in Melbourne is found doing gambling business. Memorising Confucius birthday in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
25148 | 25148 | 1911-10-14 | 7 | b | Yangtse River flooding donation | Name list of donations. | Australia | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
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]);