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 |
---|---|---|---|---|---|---|---|---|---|
50289 | 50289 | 1931-05-16 | 2 | b | Editorial by Tung Wah Times on the true meaning of peace. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090381 | 24090381 | |
50295 | 50295 | 1931-05-16 | 3 | b | The Communist troops in south China. | China | http://trove.nla.gov.au/newspaper/page/24090380 | 24090380 | |
50303 | 50303 | 1931-05-16 | 8 | b | Fire in Yamanaka, Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 | |
50304 | 50304 | 1931-05-16 | 8 | b | Soviet Russian seek to control navigation in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 | |
50305 | 50305 | 1931-05-16 | 8 | b | Delegates to the national conference in Nanjing on the consular jurisdiction. | China | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 | |
50306 | 50306 | 1931-05-16 | 8 | b | Burmese people executed in India for political instigation. | Other... | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 | |
50307 | 50307 | 1931-05-16 | 8 | b | Passenger liner Taiping is stranded in heavy fog. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 | |
50308 | 50308 | 1931-05-16 | 8 | b | Indian delegation reports the riots in Burma. | Britain | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 | |
50309 | 50309 | 1931-05-16 | 8 | b | Train derails in India. | Other... | http://trove.nla.gov.au/newspaper/page/24090387 | 24090387 |
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]);