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 |
---|---|---|---|---|---|---|---|---|---|
14592 | 14592 | 1905-07-15 | 2 | b | Protest rally of Shanghai businessmen and their request to boycott American goods. Report on protest rallies of Guangdong businessmen in Shanghai, Chinese businessmen in America, Fujian businessmen in Shanghai, Hong Kong businessmen, Governor Qin Chunxuan of Guangdong and Guangxi, and Qingxin college in Shanghai. Response from Chinese department of foreign affairs, Chinese students in America, Suzhou businessmen in Jiangsu province, and Chinese communities in Los Angeles. Schools in Guangdong boycott American goods while Guangdong businessmen refuse to use American flour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800732 | 26800732 | |
14598 | 14598 | 1905-07-15 | 3 | b | The United States of America has a new Secretary of State. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800731 | 26800731 | |
14599 | 14599 | 1905-07-15 | 3 | b | Labourers to be recruited in Italy, Japan and China for the building of Panama Canal. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800731 | 26800731 | |
14600 | 14600 | 1905-07-15 | 3 | b | Mayor of Moscow was assassinated. | Australia | http://trove.nla.gov.au/newspaper/page/26800731 | 26800731 | |
14601 | 14601 | 1905-07-15 | 3 | b | Miscellaneous report on the war between Russia and Japan in Manchuria. | Other... | http://trove.nla.gov.au/newspaper/page/26800731 | 26800731 | |
14602 | 14602 | 1905-07-15 | 3 | b | Chinese community in Sydney to celebrate the birthday of Emperor Guangxu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800731 | 26800731 | |
14605 | 14605 | 1905-07-15 | Suppl't | b | Liu Ruxing talks about sugarcane growers in north Queensland and racial relations there. Australia to have new restriction on Chinese residents and protest from Sydney Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800733 | 26800733 | |
14606 | 14606 | 1905-07-15 | Suppl't | b | Sydney Quit Opium-smoking Association is seeking signatures to support their petition to ban opium importation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800733 | 26800733 | |
14607 | 14607 | 1905-07-15 | Suppl't | b | China asserts its sovereignty in Manchuria after the Russo-Japanese War. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800733 | 26800733 |
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]);