This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52775 | 52775 | 1933-04-22 | 3 | a | Battles in north China. Jiang Zuobin talks on his arrival in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52776 | 52776 | 1933-04-22 | 3 | c | Japanese to build a secret airport in Nanyang. | Britain | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52777 | 52777 | 1933-04-22 | 3 | c | German changes its national flag. | Germany | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52778 | 52778 | 1933-04-22 | 3 | c | Japanese fleet arrives Fuzhou, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52779 | 52779 | 1933-04-22 | 3 | d | Chinese foreign minister Luo Wengan arrives Beijing and denies direct talks with Japanese. | China | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52780 | 52780 | 1933-04-22 | 3 | d | American government replies to the League of Nations and agrees to join the advisory committee for mediation of Manchurian issues. | America | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52781 | 52781 | 1933-04-22 | 3 | e | Duan Qirui talks in the national crisis. | China | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52782 | 52782 | 1933-04-22 | 3 | e | Zhang Huichang's wife's sister is charged in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52783 | 52783 | 1933-04-22 | 3 | e | Yan Xishan to meet Jiang Jieshi in Shijiazhuang. | China | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
52784 | 52784 | 1933-04-22 | 3 | e | Rebellions in Xijiang, northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 |
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]);