This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19093 | 19093 | 1908-03-28 | 2 | d | Chinese students in Japan and the revolutionary movement. | Japan | http://trove.nla.gov.au/newspaper/page/26801678 | 26801678 | |
19103 | 19103 | 1908-03-28 | 3 | d | Russians prepare for possible Japanese invasion to Sakhalin island, Heilongjiang and Songhuajiang Rivers area. | Australia | http://trove.nla.gov.au/newspaper/page/26801677 | 26801677 | |
19104 | 19104 | 1908-03-28 | 3 | d | American naval fleet to visit Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801677 | 26801677 | |
19105 | 19105 | 1908-03-28 | 3 | d | Russian treasurer submits a financial report to the parliament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801677 | 26801677 | |
19106 | 19106 | 1908-03-28 | 3 | d | Miscellaneous notes/ Number of troops in Europe. Dockyard in Clayton of Britain. Servants in the imperial palace in Germany. Tea export from China to Britain from June 1907 to January 1908. Railway around the world. A comparison of British and German naval forces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801677 | 26801677 | |
19121 | 19121 | 1908-03-28 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801681 | 26801681 | |
19122 | 19122 | 1908-03-28 | 7 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801681 | 26801681 | |
19126 | 19126 | 1908-03-28 | 8 | d | Jokes. Dining, wining, whoring and gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801684 | 26801684 |
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]);