This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53034 | 53034 | 1933-07-01 | 6 | a | Failed revolution in San Marino. | Other... | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53035 | 53035 | 1933-07-01 | 6 | a | A man arrested in New York for attempting to assassinate American President. | America | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53036 | 53036 | 1933-07-01 | 6 | a | New warship manufactured in France. | Britain | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53037 | 53037 | 1933-07-01 | 6 | b | Effort to restore the monarch system in Austria. | Britain | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53038 | 53038 | 1933-07-01 | 6 | b | Austrian parliament to remove the supporters of Hitler. | Other... | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53039 | 53039 | 1933-07-01 | 6 | c | German government bans Socialist Party members. | Germany | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53040 | 53040 | 1933-07-01 | 6 | c | Famine in the south of Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53041 | 53041 | 1933-07-01 | 6 | c | Ireland subsidises the exports. | Britain | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53042 | 53042 | 1933-07-01 | 6 | d | Flooding of the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53043 | 53043 | 1933-07-01 | 6 | d | Australia news/ Court hearing in Sydney on the robbery of a Chinese shop. Visitor talks about Japan on his return. Chinese man is arrested in Sydney for using fake notes. Census in Australia. Manager of liner service company in Sydney entertains Chinese passengers. Two white men are arrested in Perth for opium smuggling. Sydney Chinese Saving China Association acknowledges receipt of donations to the war of resistance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 |
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]);