This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53223 | 53223 | 1933-08-26 | 6 | a | Japanese navy on exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53224 | 53224 | 1933-08-26 | 6 | a | Japanese ambassador to Poland is baptised before dies. | Britain | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53225 | 53225 | 1933-08-26 | 6 | a | Floods of the Yellow River. | China | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53226 | 53226 | 1933-08-26 | 6 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53227 | 53227 | 1933-08-26 | 6 | b | The end of dictatorship in Cuba and the celebrations. | Other... | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53228 | 53228 | 1933-08-26 | 6 | c | Air force troops in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53229 | 53229 | 1933-08-26 | 6 | d | Floods in China. | China | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53230 | 53230 | 1933-08-26 | 6 | d | Australia news/ Another court hearing on the case of Huang Huazhi. Famous Chinese businessman and accountant of the Chinese Baptism church in Sydney Huang Si dies. Chinese gardener is found embezzlement. Chinese man killed in a tram accident, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 |
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]);