This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50284 | 50284 | 1931-05-09 | 8 | b | Earthquake in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24090379 | 24090379 | |
50285 | 50285 | 1931-05-09 | 8 | b | A train in Egypt is set on fire. | Other... | http://trove.nla.gov.au/newspaper/page/24090379 | 24090379 | |
50286 | 50286 | 1931-05-09 | 8 | b | Naval laboratory explodes in Brazil. | Other... | http://trove.nla.gov.au/newspaper/page/24090379 | 24090379 | |
50287 | 50287 | 1931-05-09 | 8 | b | Another revolution erupts suddenly in Guangzhou. Guangdong declares independence. Negotiations between China and foreign countries over the consular jurisdiction. Opening of the national conference in Nanjing and report on the ceremony. | China | http://trove.nla.gov.au/newspaper/page/24090379 | 24090379 | |
50288 | 50288 | 1931-05-09 | 8 | c | Australian news/ Inauguration of the new board of the Chinese Chamber of Commerce in Sydney and speakers include Chinese Consul-General in Australia Gui Zhi, Zhu Songqing, Ye Bingnan, Zheng Fanchang and others. Young Chinese man Zheng Zhenhua, nephew of Zheng Fanchang, graduates from the University of Sydney and a photograph of Zheng Zhenhua. Bank notes robbed from a train in Sydney and numbers of these notes. The Savings Bank of New South Wales resumes its operation. Chinese sailor detained in Sydney for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090379 | 24090379 |
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]);