This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21049 | 21049 | 1909-05-22 | 6 | a | Background of Rong Jintong, son of Rong Hong and chief engineer of the Zhenhu company in Guangxi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21050 | 21050 | 1909-05-22 | 6 | b | Savings left by Empress Dowager and Emperor Guangxu to be used for naval building. | China | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21051 | 21051 | 1909-05-22 | 6 | b | Li Jingfang reports that British authority starts to collect poll tax from Chinese immigrant. | China | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21052 | 21052 | 1909-05-22 | 6 | b | Germany is building new warship. | Britain | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21053 | 21053 | 1909-05-22 | 6 | b | Post office workers on strike in France. | Britain | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21054 | 21054 | 1909-05-22 | 6 | b | Canadian government to organise naval fleet in the Pacific area. | Britain | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21055 | 21055 | 1909-05-22 | 6 | c | Britain, France and Germany compete with each other to lend China for railway construction. | Britain | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21056 | 21056 | 1909-05-22 | 6 | c | Spanish government to rebuild its navy. | Other... | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21057 | 21057 | 1909-05-22 | 6 | c | Britain and Russia compete each other for trade in Asia. | Britain | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 | |
21058 | 21058 | 1909-05-22 | 6 | c | Opium ban in Thailand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802194 | 26802194 |
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]);