This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5166 | 5166 | 1900-05-09 | 2 | a-b | Kuang Rupan, a member of the reform party, was arrested after returning to China from Japan. The British Governor of Hong Kong sends a telegram to the Governor of Guangdong, requesting Kuang's release immediately. | China | http://trove.nla.gov.au/newspaper/page/24102796 | 24102796 | |
5168 | 5168 | 1900-05-09 | 2 | c | Local governors in China send telegram to Beijing commenting on power issues. | China | http://trove.nla.gov.au/newspaper/page/24102796 | 24102796 | |
5169 | 5169 | 1900-05-09 | 2 | d | Clashes between the bandits and government forces in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24102796 | 24102796 | |
5177 | 5177 | 1900-05-09 | 2 | f | The Society of Righteousness in Shanghai is directed by Wang Kangnian. Members include Wen Tingshi, Wang Kangnian, Tang Caichang, Ding Hui, Di Ping, Shen Gucheng, Ye Han, Zhang Binglin, Zhang Tongdian, Zhou Shanpei, Shen Shisun, and others. | China | http://trove.nla.gov.au/newspaper/page/24102796 | 24102796 | |
5180 | 5180 | 1900-05-09 | 2 | f | An old man in Guangzhou tries to marry. His partner of choice was a stone. | China | http://trove.nla.gov.au/newspaper/page/24102796 | 24102796 |
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]);