This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23983 | 23983 | 1910-12-17 | 2 | a-b | A petition from the Chinese Empire Reform Association in Chicago to Prince Zai Xun for the establishment of national parliament and the lift of ban on political parties. | America | http://trove.nla.gov.au/newspaper/page/26802874 | 26802874 | |
23988 | 23988 | 1910-12-17 | 3 | a-b | Guangdong news/ Progress of the Guangzhou-Kowloon and Guangzhou-Hankou railways. Zhan Tianyou is on the way to Guangzhou. Rehabilitation department to be reformed. Military supply in Guangdong. Guangdong purchases equipment for telegraph communication. Bandits in Dongguan county kidnap Xiao Weinan but the hostage dies before ransom paid. A gentleman from Fujian province harasses a school girl in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802873 | 26802873 | |
24002 | 24002 | 1910-12-17 | 6 | a-b | Pessimistic future of Yanji, of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/26802878 | 26802878 | |
24010 | 24010 | 1910-12-17 | 7 | a-b | Transportation workers in South Australia on strike for more pay. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802877 | 26802877 | |
24019 | 24019 | 1910-12-17 | 8 | a-b | The dispute over Kaiping coal mine and the solution. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802880 | 26802880 |
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]);