This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19188 | 19188 | 1908-04-11 | 8 | a-b | American secretary of industry and commerce reports to the parliament. The report covers issues such as Chinese immigration, trade statistics between China and America, and number of Chinese immigrants in the United States. | America | http://trove.nla.gov.au/newspaper/page/26801700 | 26801700 | |
19189 | 19189 | 1908-04-11 | 8 | b-c | Reader of Tung Wah Times Zhang Yihua suggests that Chinese community in Australia should set up a Chinese school. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801700 | 26801700 | |
19190 | 19190 | 1908-04-11 | 8 | c-d | Second and final part of an article on the Sino-Japan dispute over the capture of a smuggling Japanese cargo ship near Macao, and its impact on East Asian security. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801700 | 26801700 | |
19191 | 19191 | 1908-04-11 | 8 | d | A strange disease found in Germany. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801700 | 26801700 | |
19192 | 19192 | 1908-04-11 | 8 | d | Measures Chinese government uses to control. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801700 | 26801700 |
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]);