This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43841 | 43841 | 1925-09-19 | 5 | a | Tung Wah Times comments on the republic and the communism. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43842 | 43842 | 1925-09-19 | 5 | b | Typhoon in south Korea. | China | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43843 | 43843 | 1925-09-19 | 5 | b | Timber burned to ashes in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43844 | 43844 | 1925-09-19 | 5 | b | Police in New York orders Chinese communities to stop fighting and arrest some. | America | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43845 | 43845 | 1925-09-19 | 5 | b | Statistics on Britain's import and export. | Britain | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43846 | 43846 | 1925-09-19 | 5 | c | Population increases sharply in America from 1870 to 1920. | America | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43847 | 43847 | 1925-09-19 | 5 | c | Members of the Bolshevik increase in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43848 | 43848 | 1925-09-19 | 5 | c | King of Belgium tours India. | Other... | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43849 | 43849 | 1925-09-19 | 5 | c | A joint committee of justice, comprised by British, Japanese and American judges, investigates the May 30 incident in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43850 | 43850 | 1925-09-19 | 5 | c | Bank employees are on strike in Paris. | France | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 |
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]);