This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42869 | 42869 | 1925-03-21 | 2-3 | c-a | First part of a report on the national congress in Beijing (shan hou hui yi) to deal with the aftermath. Delegates to the conference. | China | http://trove.nla.gov.au/newspaper/page/24101070 | 24101070 | |
42870 | 42870 | 1925-03-21 | 3 | a | Prominent figures in Beijing are to organise a big political party. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42871 | 42871 | 1925-03-21 | 3 | b | Chamber of commerce in Shanghai takes over the ammunition factory and the report. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42872 | 42872 | 1925-03-21 | 3 | b-c | Sun Yatsen's handling of the Guomindang affairs and the report. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42873 | 42873 | 1925-03-21 | 3 | c | China to quit the World League of Taxation. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42874 | 42874 | 1925-03-21 | 3 | d | Sun Yatsen's army occupy Shantou, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42876 | 42876 | 1925-03-21 | 3 | d | Puyi (Emperor Xuantong) talks in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42877 | 42877 | 1925-03-21 | 3 | d-e | Sun Yatsen dies in Beijing and his last minutes. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42879 | 42879 | 1925-03-21 | 3 | e-f | The testament of Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42880 | 42880 | 1925-03-21 | 3 | f | Typhoon in the west of Japan and a ship sinks. | China | http://trove.nla.gov.au/newspaper/page/24101069 | 24101069 | |
42883 | 42883 | 1925-03-21 | 6 | b-c | Power struggle between the left and right factions of Guomindang after the death of Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24101074 | 24101074 |
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]);