This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13684 | 13684 | 1904-08-20 | 2 | a-b | First part of Liang Qichao's article, The Future of Guangdong. Current situation in Guangdong. Number of Cantonese people in America, Australia, Hawaii, the Philippines, Central and South America, Canada, Mexico, and other regions. How much they earn, how much they send back to Guangdong, and the total number. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13685 | 13685 | 1904-08-20 | 2 | b | Empress Dowager donates to the Red Cross. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13686 | 13686 | 1904-08-20 | 2 | b | A prince is trying to raise funds for a new design. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13687 | 13687 | 1904-08-20 | 2 | b | An official's attitude towards a school teacher in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13688 | 13688 | 1904-08-20 | 2 | b | Teaching of chemistry science in a Sichuan university. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13689 | 13689 | 1904-08-20 | 2 | c | France and Japan compete for mineral resources in Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13690 | 13690 | 1904-08-20 | 2 | c | An English newspaper in Shanghai comments on China affairs. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13691 | 13691 | 1904-08-20 | 2 | c | Russia is trying to get Xinjiang from China. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13692 | 13692 | 1904-08-20 | 2 | c | Mining in Jiangxi, Jiangsu and Anhui provinces. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13693 | 13693 | 1904-08-20 | 2 | c | Kong Yanting, descendant of Confucius, helps to promote education. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13694 | 13694 | 1904-08-20 | 2 | c | Modern machines and technology are welcome in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13695 | 13695 | 1904-08-20 | 2 | d | Students from Hubei province make up to Prince Duan. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13696 | 13696 | 1904-08-20 | 2 | d | Mr Zhou, of Nanhai county, tries to publish a newspaper in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13697 | 13697 | 1904-08-20 | 2 | d | Two families, Zheng and Zhang, were in a fight in Chaozhou, Guangdong, and caused casualties. | China | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13698 | 13698 | 1904-08-20 | 2 | d | Fourth part of the battlefield report on the war with Russia on the Yalu River, written by Japanese journalist. | Japan | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 |
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]);