This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19158 | 19158 | 1908-04-11 | 2 | a-b | Comments on the dispute between China and Japan over the capture of smuggling Japanese cargo ship near Macao. And detailed report on the case from London. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801694 | 26801694 | |
19163 | 19163 | 1908-04-11 | 3 | a-b | German naval forces and its administration. | Britain | http://trove.nla.gov.au/newspaper/page/26801693 | 26801693 | |
19180 | 19180 | 1908-04-11 | 7 | a-b | American naval fleet is on the way to visit Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801697 | 26801697 | |
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 |
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]);