This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54887 | 54887 | 1935-02-16 | 6 | a | British ship Tongzhou is hijacked near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
54888 | 54888 | 1935-02-16 | 6 | b | Japanese envoy in Nanjing and their talks with Chinese officials. | Japan | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
54889 | 54889 | 1935-02-16 | 6 | b | Japanese investment in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
54890 | 54890 | 1935-02-16 | 6 | b | Singaporean air force troops on exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
54891 | 54891 | 1935-02-16 | 6 | b | Soviet Russia changes its parliament system. | Russia | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
54892 | 54892 | 1935-02-16 | 6 | d | Japanese seeks cooperation from the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
54893 | 54893 | 1935-02-16 | 6 | e | Australia news/ Chinese consul-general in New Zealand arrives Sydney on his way back to China. Melbourne police raid smuggled opium. Young Chinese man Wu Pengbiao is drowned. Chinese man injured in Sydney while working for the state government. Chinese shop in NSW is robbed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 |
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]);