This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54394 | 54394 | 1934-08-04 | 3 | a | Japanese in Shanghai beat French man. | China | http://trove.nla.gov.au/newspaper/page/24096107 | 24096107 | |
54395 | 54395 | 1934-08-04 | 3 | a | Japanese newspaper in Manchuria advocates anti-Russia sentiment. | China | http://trove.nla.gov.au/newspaper/page/24096107 | 24096107 | |
54396 | 54396 | 1934-08-04 | 3 | a | Japanese in Shanghai seek to take over the police forces in Hongkou district and the response of Japanese consulate. | China | http://trove.nla.gov.au/newspaper/page/24096107 | 24096107 | |
54397 | 54397 | 1934-08-04 | 3 | b | Responses of the commercial circles in Shanghai to the new tariff rate introduced by the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096107 | 24096107 | |
54398 | 54398 | 1934-08-04 | 3 | c | Envoys of the central government He Jian and Xue Yue in Guangdong. Fang Shengtao dies in Shanghai. Ms Li Xiaqing and her story. Yellow River is flooding. Cai Tingkai meets Italian Prime Minister Mussolini. | China | http://trove.nla.gov.au/newspaper/page/24096107 | 24096107 | |
54399 | 54399 | 1934-08-04 | 3 | e | Wu Peifu is cultivating farm now. Hanjiang River is flooding. Battles in the south of Xinjiang. Plan to eradicate the communist forces in the south. | China | http://trove.nla.gov.au/newspaper/page/24096107 | 24096107 |
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]);