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 |
---|---|---|---|---|---|---|---|---|---|
11803 | 11803 | 1903-05-02 | 2 | c | A flying ship (aeroplane) was tested in America. | Australia | http://trove.nla.gov.au/newspaper/page/26800215 | 26800215 | |
11804 | 11804 | 1903-05-02 | 3 | a | A rich man in America was charged over his involvement in illegal gambling. | Australia | http://trove.nla.gov.au/newspaper/page/26800214 | 26800214 | |
11807 | 11807 | 1903-05-02 | 3 | a | King of the Philippines is in danger. | Australia | http://trove.nla.gov.au/newspaper/page/26800214 | 26800214 | |
11808 | 11808 | 1903-05-02 | 3 | a | Flu in Cowra, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/26800214 | 26800214 | |
11809 | 11809 | 1903-05-02 | 3 | a | Two Sydney boys, charged with throwing stones at a Chinese gardener, have been found not guilty. | Australia | http://trove.nla.gov.au/newspaper/page/26800214 | 26800214 | |
11810 | 11810 | 1903-05-02 | 3 | a | Governors of Australian states held a meeting in Sydney. They discussed the naturalisation of Chinese migrants and their treatment in each state. | Australia | http://trove.nla.gov.au/newspaper/page/26800214 | 26800214 | |
11812 | 11812 | 1903-05-02 | 3 | b | Storm was followed by flooding in Miranda, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/26800214 | 26800214 |
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]);