This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30230 | 30230 | 1915-07-03 | 3 | a-b | To buy the public loans in China is regarded as the best way for people to deposit their money. | China | http://trove.nla.gov.au/newspaper/page/24094896 | 24094896 | |
30231 | 30231 | 1915-07-03 | 3 | b | Tan Xuehen reports his investigation on water conservancy works in Guangdong and plans to go to Shanghai to discuss with other engineers. | China | http://trove.nla.gov.au/newspaper/page/24094896 | 24094896 | |
30232 | 30232 | 1915-07-03 | 3 | b-c | Battle situation in east Europe between Russian, Germany, Austrian and Turkish troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094896 | 24094896 | |
30233 | 30233 | 1915-07-03 | 3 | c | Battle situation in west Europe between French and German troops. | France | http://trove.nla.gov.au/newspaper/page/24094896 | 24094896 | |
30234 | 30234 | 1915-07-03 | 3 | c-d | Statistics of British soldiers killed and wounded in the Europe War. | Britain | http://trove.nla.gov.au/newspaper/page/24094896 | 24094896 | |
30235 | 30235 | 1915-07-03 | 3 | d | Conflicting stories of triumphs and losses between Italian and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094896 | 24094896 | |
30236 | 30236 | 1915-07-03 | 3 | d | Beijing news/Central government cables various provinces for recruiting deplomatic personnel. Treaty of Exterior Mongolia's autonomy is signed. China and Portugal are conflicting on Macau border issue. Zhang Taiyian is treated well by the government and allowed to go out of Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094896 | 24094896 |
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]);