This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43287 | 43287 | 1925-06-06 | 2 | b-c | Zhang Zuolin on the current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24101158 | 24101158 | |
43294 | 43294 | 1925-06-06 | 3 | b-c | The Nationalist Party (Guomindang) splits in Beijing and the members who are against communists (Zhang Binglin, Peng Yangguang, Feng Ziyou, Wu Chaoshu, Wang Zhengting, Dan Maoxi, Wu Qingyang, Zhang Jingjiang, Zhang Juzheng, Tang Shaoyi, Sun Ke, Ma Junwu, and many others). | China | http://trove.nla.gov.au/newspaper/page/24101157 | 24101157 |
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]);