This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52924 | 52924 | 1933-05-27 | 6 | a | Muslims in Xinjiang, northwest of China, fight for independence. | Other... | http://trove.nla.gov.au/newspaper/page/24091240 | 24091240 | |
52925 | 52925 | 1933-05-27 | 6 | a | Japanese navy on exercise in the Pacific. | Britain | http://trove.nla.gov.au/newspaper/page/24091240 | 24091240 | |
52926 | 52926 | 1933-05-27 | 6 | a | Report on Japanese invasion of north China. | China | http://trove.nla.gov.au/newspaper/page/24091240 | 24091240 | |
52927 | 52927 | 1933-05-27 | 6 | d | The Nationalist Party government in Nanjing sends envoy to the north for a peace talks with Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091240 | 24091240 | |
52928 | 52928 | 1933-05-27 | 6 | d | Huang Fu, Political Commissioner of Beijing, narrowly escapes an assassination in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24091240 | 24091240 | |
52929 | 52929 | 1933-05-27 | 6 | e | The Nationalist government in Nanjing refuses to a peace talks with Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091240 | 24091240 | |
52930 | 52930 | 1933-05-27 | 6 | f | Shi Yousan makes trouble in Tianjin. Japanese planes fly over Beijing. Japanese guard in Beijing is killed. Truce in north China. Peace talks between China and Japan ceases. | China | http://trove.nla.gov.au/newspaper/page/24091240 | 24091240 | |
52931 | 52931 | 1933-05-27 | 6 | g | Britain refuses to recognise the puppet Manchurian state. | Britain | http://trove.nla.gov.au/newspaper/page/24091240 | 24091240 |
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]);