This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52658 | 52658 | 1933-03-18 | 2 | c | Chen Youren on the diplomacy of Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24091156 | 24091156 | |
52659 | 52659 | 1933-03-18 | 2 | d | Hu Hanmin on the current situations in China. | China | http://trove.nla.gov.au/newspaper/page/24091156 | 24091156 | |
52660 | 52660 | 1933-03-18 | 2 | e | Luo Wengan and his foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24091156 | 24091156 | |
52661 | 52661 | 1933-03-18 | 3 | a | Battles in Rehe and other parts of north China between the Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091155 | 24091155 | |
52662 | 52662 | 1933-03-18 | 3 | b | League of Nations and its committee on the Manchurian issues. | China | http://trove.nla.gov.au/newspaper/page/24091155 | 24091155 | |
52664 | 52664 | 1933-03-18 | 3 | d | Japanese in Hankou, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24091155 | 24091155 | |
52665 | 52665 | 1933-03-18 | 5 | a | Zhu Qinglan reports Japanese aggression in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091157 | 24091157 | |
52669 | 52669 | 1933-03-18 | 7-8 | a-f | Guangdong news/ The whereabouts of Bai Chongxi, Jiang Guanglai, Huang Shaoxiong, Wang Jialie and Zou Haibin. Li Jishen sends telegram to the Nanjing government. Cai Tingkai returns to Fujian province. Guangdong provincial authority on the departure of troops to fight Japanese in the north. Epidemic in Guangzhou. Overseas propaganda team arrives Hong Kong. Feng Zhuwan on the war in north China. Women's association in Guangzhou sets up a childcare centre. Xinhui county authority imposes special levies for luxurious banquets. Gentry in Dongguan county support the dam building. | China | http://trove.nla.gov.au/newspaper/page/24091159 | 24091159 | |
52674 | 52674 | 1933-03-18 | 6 | b | Jiang Jieshi and Zhang Xueliang to meet in Baoding, Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52678 | 52678 | 1933-03-18 | 6 | d | The war between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 |
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]);