This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55056 | 55056 | 1935-04-27 | 8 | a | A meeting of government leaders of Britain, France and Italy. | Britain | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55057 | 55057 | 1935-04-27 | 8 | a | Sandstorm in America. | America | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55058 | 55058 | 1935-04-27 | 8 | b | Test of mail planes in America. | America | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55059 | 55059 | 1935-04-27 | 8 | c | League of Nations and its arbitration. | Britain | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55060 | 55060 | 1935-04-27 | 8 | d | A labour conference in Geneva. | Japan | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55061 | 55061 | 1935-04-27 | 8 | d | Dethroned emperor of Germany is sick. | Germany | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55062 | 55062 | 1935-04-27 | 8 | d | Earthquake in Taiwan and the damages. | Japan | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55063 | 55063 | 1935-04-27 | 8 | e | Australia news/ State election to be held in NSW. Wages increase in Sydney. A skilled thief in Sydney and his radio communication equipment. Circus performance during the Royal Agricultural Show in Sydney. Japanese naval fleet comes to visit Australia. Chinese men beaten and robbed in Albury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 |
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]);