This data as json, CSV (advanced)
Suggested facets: column, source, 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 | |
18266 | 18266 | 1907-10-12 | 3 | b | Indian people in Calcutta gather to seek gain independence from Britain. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18267 | 18267 | 1907-10-12 | 3 | b | Report on anti-Asian movement in British Columbia, Canada. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18268 | 18268 | 1907-10-12 | 3 | b | Population growth and taxation in Canada. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18269 | 18269 | 1907-10-12 | 3 | b-c | Liu Ruxing talks about the relationship between Australia and China at the dinner party in his honour held by Western businessmen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18270 | 18270 | 1907-10-12 | 3 | c-d | Miscellaneous notes. A maid is arrested as a revolutionary. A mad man in Beijing frightens Tie Liang. Duan Fang is frightened by Chen Botao. Xu Shichang's photo is selling well, like Yang Cuixi's. Wang Wenshao marries again. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18271 | 18271 | 1907-10-12 | 3 | d | A report from Lu Shou suggests revising the newspaper publishing law. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 | |
18272 | 18272 | 1907-10-12 | 3 | d | The shortest route for travelling around the world. Wine consumption in South Africa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801499 | 26801499 |
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]);