This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50189 | 50189 | 1931-04-11 | 8 | b | Bandits and robberies in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
50190 | 50190 | 1931-04-11 | 8 | b | Earthquake in central America. | America | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
50191 | 50191 | 1931-04-11 | 8 | b | Chinese government may stop import of foreign wheat. | Canada | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
50192 | 50192 | 1931-04-11 | 8 | c | Australia news/ Liner Melba is stranded on its way from Singapore to Melbourne. Two girls extort bishop in Goulburn, NSW. Storm in Darwin destroy houses. Chinese Christian associations in Sydney welcome Dr Gu Ziren and speakers include Rev. Liang Lanxun, Rev. Fu Liming, Rev. Li Shaoqin and others. Chinese communities in Sydney welcome Dr Gu Ziren and speakers include Rev. Liang Lanxun, Ouyang Nan, Chinese Consul-General Gui Zhi, Liu Guangfu, Guo Jianying, Li Youfang and Zeng Guangqi. Federal government sues the NSW state government for repayment of debts. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 |
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]);