This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12346 | 12346 | 1903-10-24 | 2 | a | First part of Qin Chunxuan's proposal to set up a commercial association in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/26800313 | 26800313 | |
12353 | 12353 | 1903-10-24 | 3 | a | Pei Jingfu, magistrate of Nanhai county in Guangdong, is in trouble. | China | http://trove.nla.gov.au/newspaper/page/26800312 | 26800312 | |
12354 | 12354 | 1903-10-24 | 3 | a | Government forces defeated. Possible involvement of secret party members in the banditry. Guangxi authority seeks help from the central government. | China | http://trove.nla.gov.au/newspaper/page/26800312 | 26800312 | |
12355 | 12355 | 1903-10-24 | 3 | a | A Society of Equality has been set up in Russia which is more aggressive. | Russia | http://trove.nla.gov.au/newspaper/page/26800312 | 26800312 | |
12356 | 12356 | 1903-10-24 | 3 | a | Chinese businessmen in Malaysia, Feng Zhaonian, Fan Chang, Liu Wenjin, Liu Wende, You Ruiyue, You Shiqin, Wang Junzan, Wang Yingxuan, Huang Lishui, Xie Wenzhe and Liu Sichuan, sent a telegram to Beijing to urge the Empress to return power to Emperor. | Malaysia | http://trove.nla.gov.au/newspaper/page/26800312 | 26800312 | |
12357 | 12357 | 1903-10-24 | 3 | a | Japan has purchases two gunboats from America. Japanese students have been recalled from their studies in European army schools. More Russian gunboats are going to east Asia. Russia sends more troops to east Asia. Russian ambassador talks to Chinese government on Manchuria issue. Most Japanese workers in Lushun have resigned. | Other... | http://trove.nla.gov.au/newspaper/page/26800312 | 26800312 |
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]);