This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21110 | 21110 | 1909-06-05 | 6 | a-b | First part of a report on education (and schooling) in Britain, France and Germany. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802210 | 26802210 | |
21111 | 21111 | 1909-06-05 | 6 | b | Survey. Number of foreigners in China (Japanese, British, German, French, Portuguese, Italian, Russian, Belgian, Korean, and others). China has 64 trade ports at the moment. Statistics on import and export of China in the past five years (1903-1907). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802210 | 26802210 | |
21112 | 21112 | 1909-06-05 | 6 | b-c | Further report on the opening of Xiangzhou, new business town in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802210 | 26802210 | |
21113 | 21113 | 1909-06-05 | 6 | c | The wealth of Korea (territory, personal property, library, railway, mining resources, and others). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802210 | 26802210 |
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]);