This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24629 | 24629 | 1911-06-03 | 7 | a | Notes of Sydney Empire Constitutional Association | Aims of the Association and regulations on memebership. | Australia | http://trove.nla.gov.au/newspaper/page/24091798 | 24091798 |
24630 | 24630 | 1911-06-03 | 7 | a | Australian news | Some Chinese were treated well in a foreign ship. The Jewish people tell sad stories of Jews ill-treated in Russia. Warships come to Australia for military exercise. Notes on shareholders to refund their shares from Guangdong railway. New governor of Australia is coming. Plan of immigrating Europeans for the sake of white Australia. Ceremony and holidays on British King's birthday. Smuggling opium was discovered. | Other... | http://trove.nla.gov.au/newspaper/page/24091798 | 24091798 |
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]);