This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52759 | 52759 | 1933-04-15 | 6 | a | Japanese Prime Minister on the world peace. | Japan | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52760 | 52760 | 1933-04-15 | 6 | a | American warplane crushes. | America | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52761 | 52761 | 1933-04-15 | 6 | a | A secret telegram from Japanese ambassador in Washington to his government. | America | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52762 | 52762 | 1933-04-15 | 6 | bb | Bandits in Niuzhuang, north China. | China | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52763 | 52763 | 1933-04-15 | 6 | c | New politics in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52764 | 52764 | 1933-04-15 | 6 | c | American to convene an international conference on economic development. | America | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52765 | 52765 | 1933-04-15 | 6 | d | Russia and the puppet Manchurian state have disputes over the railway management. | Japan | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52766 | 52766 | 1933-04-15 | 6 | d | Jiang Jieshi back to Nanchang, Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52767 | 52767 | 1933-04-15 | 6 | d | Crisis between Germany and Poland. | Germany | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52768 | 52768 | 1933-04-15 | 6 | f | Australia news/ Federal government promotes trade with Asia. Chinese man in Sydney is on trial for fake legal documents. State election in Western and South Australia. Heavy rain in NSW. Passenger liner Taiping to leave Sydney soon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52769 | 52769 | 1933-04-15 | 6 | f | A meeting notice of the Chinese Chamber of Commerce in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 |
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]);