This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45855 | 45855 | 1927-07-02 | 2 | b | Tung Wah Times comments on the alliance between Feng Yuxiang and Jiang Jieshi and its future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098440 | 24098440 | |
45856 | 45856 | 1927-07-02 | 2 | b-c | Defence plan on the border of Jilin and Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24098440 | 24098440 | |
45857 | 45857 | 1927-07-02 | 2 | c-d | Hu Hanmin and the West Mountain (xi shan) faction (the rightist and leftist factions within the Nationalist Party or Guomindang). | China | http://trove.nla.gov.au/newspaper/page/24098440 | 24098440 | |
45858 | 45858 | 1927-07-02 | 2 | d | Zhang Taiyan's properties are sealed up. | China | http://trove.nla.gov.au/newspaper/page/24098440 | 24098440 | |
45859 | 45859 | 1927-07-02 | 2 | d | Sichuan troops firmly support Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24098440 | 24098440 | |
45860 | 45860 | 1927-07-02 | 2 | e | Hu Shi is on the way to Hangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098440 | 24098440 | |
45861 | 45861 | 1927-07-02 | 2 | e | The headquarters of the Nationalist Party tries to eliminate all communist party members. | China | http://trove.nla.gov.au/newspaper/page/24098440 | 24098440 | |
45862 | 45862 | 1927-07-02 | 2 | f | Wu Chaoshu, foreign minister of the Nationalist government, comes to Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098440 | 24098440 |
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]);