This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16471 | 16471 | 1906-11-24 | 3 | a | Russian authority prohibits newspaper from publishing their comments on the future parliament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 | |
16472 | 16472 | 1906-11-24 | 3 | a | Black people in Lesotho of South Africa are fighting for more political rights. | Britain | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 | |
16473 | 16473 | 1906-11-24 | 3 | a | New York authority seeks to bar Japanese children from being co-educated with American children. President Roosevelt is to mediate. | America | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 | |
16474 | 16474 | 1906-11-24 | 3 | a | President Roosevelt of the United States orders an investigation into the alleged embezzlement of donations to the victims of San Francisco earthquake. | America | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 | |
16475 | 16475 | 1906-11-24 | 3 | a | A woman and four men in Russia are sentenced for trying to bomb government offices. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 | |
16476 | 16476 | 1906-11-24 | 3 | a | Emperor of Japan launches the biggest ever warship, Samoa, in Yokohama. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 | |
16477 | 16477 | 1906-11-24 | 3 | b | Chile recovers from the earthquake. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 | |
16478 | 16478 | 1906-11-24 | 3 | b | Japanese navy fleet is to visit America next year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 | |
16479 | 16479 | 1906-11-24 | 3 | b | Survey. A survey of railway in Britain: length, investment, passengers, travelling charges, cargo transportation, number of employees, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801142 | 26801142 |
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]);