This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50270 | 50270 | 1931-05-09 | 2 | b | Second part of editorial on the negotiations between China and Japan over the Manchurian railways. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090373 | 24090373 | |
50274 | 50274 | 1931-05-09 | 3 | b | Soviet Union tries to control business activities in north Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090372 | 24090372 | |
50275 | 50275 | 1931-05-09 | 3 | b | Value of books of the Haiyuan Library in Liaocheng, Shandong province, collected by the Yang family. | China | http://trove.nla.gov.au/newspaper/page/24090372 | 24090372 | |
50280 | 50280 | 1931-05-09 | 5 | b | Chinese Consul-General in Australia Gui Zhi talks to shipping company regarding the passenger liner Melba that is stranded on the way. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090374 | 24090374 | |
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 |
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]);