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 |
---|---|---|---|---|---|---|---|---|---|
52771 | 52771 | 1933-04-22 | 2 | c | Commercial chamber in Shanghai issues an open letter to the Chinese businessmen. | China | http://trove.nla.gov.au/newspaper/page/24091196 | 24091196 | |
52772 | 52772 | 1933-04-22 | 2 | c | A recent talk by Song Ziwen. | China | http://trove.nla.gov.au/newspaper/page/24091196 | 24091196 | |
52773 | 52773 | 1933-04-22 | 2 | e | A recent talk by Sun Dianying. | China | http://trove.nla.gov.au/newspaper/page/24091196 | 24091196 | |
52774 | 52774 | 1933-04-22 | 2 | e | A plea of the people in Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24091196 | 24091196 | |
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 | |
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 | |
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 | |
52786 | 52786 | 1933-04-22 | 5 | b | Wong Zhaoyuan and his relationship with Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24091197 | 24091197 | |
52788 | 52788 | 1933-04-22 | 7-8 | a-f | Guangdong news/ An observance on the situations in the north and south China. Financial situation in Guangzhou. Chen Jitang is bombed during his inspection to the east. Exhibition closed in Guangzhou. Women's association in Guangzhou promote Chinese products. No date finalised for the return of Chen Jitang to Guangzhou. Overseas Chinese Committee of the Central Government in Nanjing urges overseas Chinese communities to help the war of resistance in China. Beautiful female bandits found in Guangzhou. Sun Ke cares about the development of Zhongshan county. A big gathering of beggars in Foshan. | China | http://trove.nla.gov.au/newspaper/page/24091199 | 24091199 | |
52796 | 52796 | 1933-04-22 | 6 | d | Battles in north and central China between Chinese and Japanese armies. | China | http://trove.nla.gov.au/newspaper/page/24091200 | 24091200 |
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]);