This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13859 | 13859 | 1904-10-01 | 2 | a-b | First part of a report, published by a Chinese newspaper in San Francisco, on the Chinese exhibition in the international fair in St Louis. | America | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13860 | 13860 | 1904-10-01 | 2 | b | Chinese Empire Reform Association has been set up in New Orleans. Preparation is underway for establishment of the Chinese Empire Reform Association in St Paul, Minnesota. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13861 | 13861 | 1904-10-01 | 2 | b-c | China to build an embassy in Lisbon. Memorial report from Robert Hart. A foreign government has set up customs office in Kulun, Heilongjiang province. Number of temples to be reduced in China. Further report on America's request for land near Nanjing. Stubborn magistrates in Zhili province and modern education. Feud and family fighting in Quanzhou, Fujian province. Criminal suspect Pei Jingfu is to go on trial. | China | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13862 | 13862 | 1904-10-01 | 2 | c | Ito Hirobumi has become an advisor for the Korean government. | Japan | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13863 | 13863 | 1904-10-01 | 2 | c | Women's education prospers in America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13864 | 13864 | 1904-10-01 | 2 | c | Some Korean people organised a society to protect themselves from Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13865 | 13865 | 1904-10-01 | 2 | d | A comparison between Moscow and St Petersburg. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13866 | 13866 | 1904-10-01 | 2 | d | Report on the revolutionary party in Russia and the assassination of the Minister for Internal Affairs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13867 | 13867 | 1904-10-01 | 2 | d | Report on the suffering of Chinese labourers in South Africa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
13868 | 13868 | 1904-10-01 | 2 | d | Report on demands of Japanese government after their win in the Russo-Japanese War. | Japan | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 |
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]);