This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53153 | 53153 | 1933-08-05 | 6 | a | Suicides in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53154 | 53154 | 1933-08-05 | 6 | a | Spain recognises Soviet Russian government. | Britain | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53155 | 53155 | 1933-08-05 | 6 | a | American government approves gold export. | America | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53156 | 53156 | 1933-08-05 | 6 | b | Nanjing government engages foreign economic advisors. | Britain | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53157 | 53157 | 1933-08-05 | 6 | b | Sale of American wheat in China. | America | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53158 | 53158 | 1933-08-05 | 6 | c | Volcano erupts in Sumatra. | Other... | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53159 | 53159 | 1933-08-05 | 6 | c | The world economic conference concludes in London. | Britain | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53160 | 53160 | 1933-08-05 | 6 | d | American to borrow naval port from China. | Japan | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53161 | 53161 | 1933-08-05 | 6 | d | Britain sells arms in the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53162 | 53162 | 1933-08-05 | 6 | d | Japan demands China to repay the debts. | Japan | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53163 | 53163 | 1933-08-05 | 6 | d | Australia news/ Australian businessmen ask Chinese government to exempt wheat flour from taxation. Federal minister of internal affairs on the New Guinea issues. Income of train tickets decline. Chinese arrested in Darwin for opium smuggling. A revenue report of the Shanghai customs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 |
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]);