This data as json, CSV (advanced)
Suggested facets: source, 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 |
25685 | 25685 | 1912-02-03 | 3 | c-d | Guangdong news | Luo Ming is elected as governor of Gaoyao county, Guangdong. Long Jiguang is allowed to stay in Guangdong for protecting social security. Huang Xing and Hu Hanming entreats Guangdong people not to harm Tang Shaoyi's family. New government in Guangzhou entertain American delegation. A county governor is involved with prostitution. Chen Jinghua asks for resignation due to inability to stop increasing violence in Guangdong. Guangdong Education Department protects Luo Boyia, a principal of primary school. | China | http://trove.nla.gov.au/newspaper/page/24092090 | 24092090 |
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]);