This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23856 | 23856 | 1910-11-26 | 2 | a-b | Second part of editorial on navy and its relation with national defence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802850 | 26802850 | |
23862 | 23862 | 1910-11-26 | 3 | a-b | Guangdong news/ Provincial government to borrow foreign loans in order to stabilise the market. Guangdong repays indemnity to foreign government. Opium import decrease year by year. American industrial delegation arrives Guangzhou and the welcome. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802849 | 26802849 | |
23886 | 23886 | 1910-11-26 | 7 | a-b | A Sydney woman drowns herself in Manly. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802853 | 26802853 | |
23897 | 23897 | 1910-11-26 | 8 | a-b | Fourth part of the report submitted by Deng Xiaoke. | China | http://trove.nla.gov.au/newspaper/page/26802856 | 26802856 |
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]);