This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17412 | 17412 | 1907-05-11 | 3 | b | More Japanese immigrants arrive in British Colombia for the railway building. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
17413 | 17413 | 1907-05-11 | 3 | b | South Africa to lift its ban on Indian immigrants. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
17414 | 17414 | 1907-05-11 | 3 | b | Australian taxation commissioner tells the colony conference in London that Australia should remain white forever. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
17415 | 17415 | 1907-05-11 | 3 | b | Acting governor of South Africa seeks to send back all Chinese labourers. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
17417 | 17417 | 1907-05-11 | 3 | c | On his way home, King Edward VII of Britain meets French president. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
17418 | 17418 | 1907-05-11 | 3 | c | Japan and Russia reach a trade agreement. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
17419 | 17419 | 1907-05-11 | 3 | c | Germany to set up bank in Teheran, capital of Persia. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 | |
17420 | 17420 | 1907-05-11 | 3 | c | Japanese envoy talks with French authority in Paris on their trade interest in the Far East. | Australia | http://trove.nla.gov.au/newspaper/page/26801323 | 26801323 |
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]);