This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
42875 | 42875 | 1925-03-21 | 3 | d | Royal British navy has a meeting for its future. | Britain | 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 | |
42878 | 42878 | 1925-03-21 | 3 | e | Epidemic in Chicago. | America | 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 |
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]);