This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52987 | 52987 | 1933-06-17 | 6 | a | Headquarters of Russian navy on fire. | Britain | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52988 | 52988 | 1933-06-17 | 6 | a | British employee of Chinese customs is murdered by bandits. | China | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52989 | 52989 | 1933-06-17 | 6 | a | Song Ziwen in Britain and his talks. | Britain | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52990 | 52990 | 1933-06-17 | 6 | a | League of Nations refuses to recognise the Manchurian state government. | Britain | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52991 | 52991 | 1933-06-17 | 6 | c | Feng Yuxiang vows to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52992 | 52992 | 1933-06-17 | 6 | c | Truce between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52993 | 52993 | 1933-06-17 | 6 | d | Hot weather in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52994 | 52994 | 1933-06-17 | 6 | d | Disputes between Britain and Japan over the tariff rate. | Britain | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52995 | 52995 | 1933-06-17 | 6 | e | Australia news/ British missionary talks in Sydney the war between China and Japan. Two Chinese in the court for disputes over the war in China. Japanese man in Darwin on trial for mistreatment to aboriginal woman. Trade exhibition ship returns to Australia after a visit to Asia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 |
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]);