This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31134 | 31134 | 1916-04-15 | 3 | a | Fake telegrams on the false public opinions by Sun Yujun, Zhu Qiqin and others. | China | http://trove.nla.gov.au/newspaper/page/24095227 | 24095227 | |
31135 | 31135 | 1916-04-15 | 3 | b | Beijing news/ Refusal to withdraw the Saving the Nation Funds (jiu guo chu jin). Disputes between China and Britain on the department store in Hankou. Agreement between China and Japan on the construction of the Jilin-Changchun Railway. Zhang Xun threatens to Yuan Shikai. Ni Sichong to be removed from Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24095227 | 24095227 | |
31136 | 31136 | 1916-04-15 | 3 | c-d | China seeks Japan's recognition to its autocratic monarchy and the offers. | China | http://trove.nla.gov.au/newspaper/page/24095227 | 24095227 | |
31137 | 31137 | 1916-04-15 | 3 | d | Yuan Shikai and the fake public opinion. | China | http://trove.nla.gov.au/newspaper/page/24095227 | 24095227 | |
31138 | 31138 | 1916-04-15 | 3 | e-f | People of Sichuan province hate troops from the North. | China | http://trove.nla.gov.au/newspaper/page/24095227 | 24095227 | |
31139 | 31139 | 1916-04-15 | 3 | e | Reform in China/ The independence of Guangdong. Japan questions the future of China. Yuan Shikai and his difficulties. Troops from the North on their way to Shanghai. | Britain | http://trove.nla.gov.au/newspaper/page/24095227 | 24095227 | |
31140 | 31140 | 1916-04-15 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095227 | 24095227 |
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]);