This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25675 | 25675 | 1912-02-03 | 2 | c-d | World of overseas Chinese students | American Columbia University provided free tuition fees for some Chinese students. Cheng Huacan, Chen Jiangshi, Jiang Fuzhen, and Cheng Kangen received degrees in California university. Chen Chongyuan is returning China after having received PhD in America. | Other... | http://trove.nla.gov.au/newspaper/page/24092091 | 24092091 |
25695 | 25695 | 1912-02-03 | 7 | b-c | Beijing news | Yuan Shikai has utmost power over state affairs. Members of State Advisory Committee leave Beijing one after another. Manchu aristocrats worry about their future. | Other... | http://trove.nla.gov.au/newspaper/page/24092094 | 24092094 |
25696 | 25696 | 1912-02-03 | 8 | a | Republic-Qing peace negotiation | Republic representatives and Qing government representatives hold peace negotiation in Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24092097 | 24092097 |
25697 | 25697 | 1912-02-03 | 8 | a-c | Change of governor in Guangdong | Change of governor in Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092097 | 24092097 |
25698 | 25698 | 1912-02-03 | 8 | c-d | Donations to republic China | More than 20 companies and 200 names listed for their donations to republic China. | Other... | http://trove.nla.gov.au/newspaper/page/24092097 | 24092097 |
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]);