This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18258 | 18258 | 1907-10-12 | 3 | a | American defence secretary visits Japan. American newspapers advocate a war with Japan. American defence secretary comments on the anti-Japanese movement in San Francisco. | Britain | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18259 | 18259 | 1907-10-12 | 3 | a | Russian navy to build very big warship in its Baltic shipyard. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18260 | 18260 | 1907-10-12 | 3 | a | The treaty between Russia and Britain and the comments by Japanese government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18261 | 18261 | 1907-10-12 | 3 | a | Canadian government agrees to compensate Japanese residents in Vancouver on damager to their property during the anti-Japanese movement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18262 | 18262 | 1907-10-12 | 3 | a | Japanese troops in Korea suppress all protest movement and report on the casualties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18263 | 18263 | 1907-10-12 | 3 | a | 70,000 railway workers in Austria strike for more pay. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18264 | 18264 | 1907-10-12 | 3 | a | Likin office in Kaishou, Yunnan province, has been removed due to protest from businessmen. | Britain | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18265 | 18265 | 1907-10-12 | 3 | a | South African authority introduces strict new regulations against Asian immigrations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18277 | 18277 | 1907-10-12 | 7 | a | Postal service in New South Wales in 1906. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801503 | 26801503 | |
18278 | 18278 | 1907-10-12 | 7 | a | Australian capital cities and their international trade (Sydney, Melbourne, Fremantle, Adelaide, Brisbane, New Castle, Geelong, Hobart, and Rockhampton). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801503 | 26801503 | |
18279 | 18279 | 1907-10-12 | 7 | a | Chinese gardeners in Sydney are reminded not to work on Sundays. Otherwise penalty will apply. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801503 | 26801503 | |
18280 | 18280 | 1907-10-12 | 7 | a | Liu Ruxing departs from Sydney for his tour to Shanghai and Japan. Report on the farewell on the harbour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801503 | 26801503 | |
18281 | 18281 | 1907-10-12 | 7 | a | Coal production in New Castle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801503 | 26801503 | |
18282 | 18282 | 1907-10-12 | 7 | a | Police in Sydney seize smuggled opium and arrest a white man. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801503 | 26801503 |
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]);