This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52219 | 52219 | 1932-11-19 | 8 | a | Storm in Cuba and the disasters. | Other... | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52220 | 52220 | 1932-11-19 | 8 | a | Result of the election in America. | America | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52221 | 52221 | 1932-11-19 | 8 | a | A blood tragedy in Geneva. | Other... | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52222 | 52222 | 1932-11-19 | 8 | b | Chinese armies in Manchuria and their fighting of Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52223 | 52223 | 1932-11-19 | 8 | b | Storm in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52224 | 52224 | 1932-11-19 | 8 | c | Australia news/ A man in Sydney poisons his younger brother to death. Police in Sydney raid opium dens. Convicts in Sydney prison beat guards. Underground mint raided in Sydney. Budget report of the NSW state government. Memorial Day in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52225 | 52225 | 1932-11-19 | 8 | f | The 40th meeting of the Sydney Chinese Saving China Association and its telegram to compatriots inside China and overseas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52226 | 52226 | 1932-11-19 | 8 | f | Chinese communities in New Zealand condemn the proposal to prohibit Chinese from employing white women employees. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 |
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]);