This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49951 | 49951 | 1931-01-31 | 8 | a | Many poor people in America need help. | America | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49952 | 49952 | 1931-01-31 | 8 | b | Total number of unemployed workers around the world. | Britain | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49953 | 49953 | 1931-01-31 | 8 | b | Japanese foreign minister is optimistic on the future of China. | Japan | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49954 | 49954 | 1931-01-31 | 8 | b | Epidemic disease in Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49955 | 49955 | 1931-01-31 | 8 | b | More unemployed workers in France. | France | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49956 | 49956 | 1931-01-31 | 8 | b | Labour disputes in a textile factory in Britain and the loss of both sides. | Britain | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49957 | 49957 | 1931-01-31 | 8 | b | Ghandi is released by Indian authority. | Other... | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49958 | 49958 | 1931-01-31 | 8 | b | Convicts in Japanese prison are allowed meet their wives and have sexual life. | Japan | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49959 | 49959 | 1931-01-31 | 8 | c | Tragedy on the Independence Day in India. | Other... | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
49960 | 49960 | 1931-01-31 | 8 | c | Australia news/ Cliff collapses in the Blue Mountain, Sydney. Two lives claimed in an air accident in Geelong, Victoria. Young boy on trial in Sydney for murder. Some unemployed workers have to live in tents. Police raid Chinese opium dens and injure the people. Italian immigrant is shot dead in Sydney. Land rates higher in Victoria. Oil production in New Zealand. NSW state government helps the unemployed. Police in Darwin and the communist demonstration. Influence of high exchange rate upon Australian economy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 |
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]);