This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54320 | 54320 | 1934-07-14 | 6 | a | Japanese in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54321 | 54321 | 1934-07-14 | 6 | a | Revolution in Chile. | America | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54322 | 54322 | 1934-07-14 | 6 | a | Japan has new cabinet. | Japan | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54323 | 54323 | 1934-07-14 | 6 | b | Battles on the border of China and Burma. | Other... | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54324 | 54324 | 1934-07-14 | 6 | c | American celebrates their independence. | America | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54325 | 54325 | 1934-07-14 | 6 | c | Heavy snow in the South Island of New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54326 | 54326 | 1934-07-14 | 6 | d | Influence of Soviet Russia in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54327 | 54327 | 1934-07-14 | 6 | e | Australia news/ Federal election to be held. Deputy Prime Minister quit politics. Aboriginal people in Darwin beat Chinese. Italian man arrested in Sydney for opium smuggling. Number of population in New South Wales. China purchase Australian flour. Arms smuggling in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 |
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]);