This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48792 | 48792 | 1930-01-11 | 8 | c | Quite a few people commit suicide in Germany since the New Year. | Germany | http://trove.nla.gov.au/newspaper/page/24099493 | 24099493 | |
48793 | 48793 | 1930-01-11 | 8 | c | Foreign countries show their sympathy on the abolition of consular jurisdiction. | China | http://trove.nla.gov.au/newspaper/page/24099493 | 24099493 | |
48794 | 48794 | 1930-01-11 | 8 | d | Australia news/ Two trams collide and injure passengers. Trial on the case of rape in Sydney. Air force officers die in the test flight in Melbourne. Military officers from Java come to purchase war horse in Australia. Cai Chang of The Sun Company writes to Ye Tonggui in Sydney on the Guangdong situations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099493 | 24099493 | |
48795 | 48795 | 1930-01-11 | 8 | f | A public notice issued by the Chinese Consul-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099493 | 24099493 |
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]);