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 |
---|---|---|---|---|---|---|---|---|---|
19013 | 19013 | 1908-03-14 | 2 | c | Imperial edict. Imperial edicts on December 21, 26, 27 and January 1 appoint & remove officials. | China | http://trove.nla.gov.au/newspaper/page/26801662 | 26801662 | |
19021 | 19021 | 1908-03-14 | 3 | c | A British military officer comments on Chinese army in New York after an investigation in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801661 | 26801661 | |
19022 | 19022 | 1908-03-14 | 3 | c | Miscellaneous news/ Development of postal service in China in the past 10 years. Number of coal miners around the world. Chicago to have the biggest hotel. The biggest restaurant in New York. Panama Canal and the budget. Import and export of Britain, Germany, America and France. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801661 | 26801661 | |
19029 | 19029 | 1908-03-14 | 6 | c | Brief chronicle of events in 1907. | China | http://trove.nla.gov.au/newspaper/page/26801666 | 26801666 | |
19030 | 19030 | 1908-03-14 | 6 | c | Column/ Zenist. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801666 | 26801666 | |
19042 | 19042 | 1908-03-14 | 7 | c | Railway building in China and its foreign contractors including Russia, Britain, Germany, France and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801665 | 26801665 | |
19043 | 19043 | 1908-03-14 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801665 | 26801665 | |
19044 | 19044 | 1908-03-14 | 7 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801665 | 26801665 |
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]);