This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54804 | 54804 | 1935-01-19 | 6 | a | National debt of the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 | |
54805 | 54805 | 1935-01-19 | 6 | a | League of Nations on the membership of Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 | |
54806 | 54806 | 1935-01-19 | 6 | b | Police in Shanghai raid drug smuggling chains. | China | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 | |
54807 | 54807 | 1935-01-19 | 6 | d | Australia news/ Storm in Victoria and the damages. Chinese ferry in Melbourne has an accident. Chinese swimmer Guo Zhenheng joins the competition in Canberra. Chinese government murders journalists. Japanese are very confident in the New Year. Chinese General Qiu Zhaoshen tours Albury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 |
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]);