This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15500 | 15500 | 1906-03-24 | 5 | a-b | Travel diary of the three Chinese officials, Zai Ze, Li Shengduo and Shang Qiheng, who are on an overseas tour, investigating other systems of government to determine the best means of political reform. Their report to Empress Dowager in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800937 | 26800937 | |
15501 | 15501 | 1906-03-24 | 5 | b | Chinese communities in Sydney purchase shares of the Hankou-Guangzhou railway. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800937 | 26800937 | |
15502 | 15502 | 1906-03-24 | 5 | b | Two pieces of doggerel portray the image of male and female Chinese students overseas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800937 | 26800937 |
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]);