This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46386 | 46386 | 1927-11-05 | 3 | b | Business in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098583 | 24098583 | |
46387 | 46387 | 1927-11-05 | 3 | c | Song Qingling visit Moscow (Lenin's grave, the welcome and Chinese students in the Sun Yatsen University). | Russia | http://trove.nla.gov.au/newspaper/page/24098583 | 24098583 | |
46388 | 46388 | 1927-11-05 | 3 | c | Liu Zhe and Beijing government authorities try to collect antiquities for the historical museum. | China | http://trove.nla.gov.au/newspaper/page/24098583 | 24098583 | |
46389 | 46389 | 1927-11-05 | 3 | d | Jiang Jieshi in Shanghai and his guests. The wedding of Jiang Jieshi and Song Meiling. | China | http://trove.nla.gov.au/newspaper/page/24098583 | 24098583 | |
46390 | 46390 | 1927-11-05 | 3 | e | Branch of political society in Wuhan. Sun Chuanfang on travel. Finance in Wuhan. Tang Jiyu attacks Kunming. Soviet Russia recognises Mongolia. Jiang Jieshi on the way to Japan. Coming war between Shandong and Henan. Bandits in the Taihu Lake, Jiangsu province. Circular telegram by Wang Jingwei. Jiang Jieshi and the cadets of Huangpu Military Academy. Jin Yunpeng mediates the conflicts between the south and the north. Wu Peifu seeks to stage comeback. | China | http://trove.nla.gov.au/newspaper/page/24098583 | 24098583 |
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]);