This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16446 | 16446 | 1906-11-17 | 3 | a | Japanese government seeks to increase its military budget. | Britain | http://trove.nla.gov.au/newspaper/page/26801136 | 26801136 | |
16447 | 16447 | 1906-11-17 | 3 | a | Survey of American goods imported into Hong Kong market. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801136 | 26801136 | |
16448 | 16448 | 1906-11-17 | 3 | a | Chinese youth sports team wins a competition in Honolulu, Hawaii. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801136 | 26801136 | |
16449 | 16449 | 1906-11-17 | 3 | a | An item on display on a Paris exhibition shows a Chinese village and Yunnan province, which probably reveals French ambition to take over the province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801136 | 26801136 | |
16450 | 16450 | 1906-11-17 | 3 | b | A survey of mineral products in Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801136 | 26801136 | |
16451 | 16451 | 1906-11-17 | 3 | b | Miscellaneous news. Russian troops leave north Manchuria. Britain tries to keep an independent Persia. Expense of street lights in London. Chinese emperor is seeking to start political, especially local self-government reform. Nearly 500 houses are reduced to ashes in a fire in Guangzhou. Celebration around the world on the birthday of King of Britain. Special communication channel set up between the Tsar of Russia and the Emperor of Germany. Russian soldiers are prohibits to liaison with any political parties. Railway to be built from Guangzhou to Kowloon. | Other... | http://trove.nla.gov.au/newspaper/page/26801136 | 26801136 |
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]);