This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56218 | 56218 | 1936-08-29 | 8 | a | Further report on the revolution in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56219 | 56219 | 1936-08-29 | 8 | b | Typhoon and casualties in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56220 | 56220 | 1936-08-29 | 8 | c | Guangxi military commanders refuse the peace office from Nanjing government. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56221 | 56221 | 1936-08-29 | 8 | c | Mexico helps Spanish government. | America | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56222 | 56222 | 1936-08-29 | 8 | c | More Japanese immigrants arrive Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56223 | 56223 | 1936-08-29 | 8 | d | Five eastern European countries to jointly guard against Soviet Russia. | Germany | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56224 | 56224 | 1936-08-29 | 8 | e | A naked parade in New York. | America | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56225 | 56225 | 1936-08-29 | 8 | e | Australia news/ The national defence and the Commonwealth Government. Deadline for the personal income tax. Chinese adventurer Zhang Shangren leaves Australia. Reserve Bank to issue five dollar notes. Trade dispute between Australia and Japan. Japanese immigrant is punished in Darwin for harbouring Aboriginal woman. Shops and factories in NSW are required to register at the state government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 |
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]);