This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13022 | 13022 | 1904-04-09 | Suppl't | b | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/26800411 | 26800411 | |
13131 | 13131 | 1904-04-30 | Suppl't | a-b | An article, selected from a New York newspaper, respectively analyses advantages and disadvantages of Russia and Japan | America | http://trove.nla.gov.au/newspaper/page/26800426 | 26800426 | |
13273 | 13273 | 1904-05-28 | Suppl't | a | Second and final part of a report from the Chinese community in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/26800446 | 26800446 | |
13275 | 13275 | 1904-05-28 | Suppl't | b | Senate of the United States of America has failed to pass a law banning Chinese immigrants. | America | http://trove.nla.gov.au/newspaper/page/26800446 | 26800446 | |
13276 | 13276 | 1904-05-28 | Suppl't | b | Bei Lunzi, Chinese representative to St Louise Fair, met President Roosevelt of the United States. | America | http://trove.nla.gov.au/newspaper/page/26800446 | 26800446 | |
13279 | 13279 | 1904-05-28 | Suppl't | c | Patriotic Chinese youth in San Francisco cut their pigtails. | America | http://trove.nla.gov.au/newspaper/page/26800446 | 26800446 | |
13380 | 13380 | 1904-06-18 | Suppl't | b | Chinese student Yan Yizhen has excellent school performance in Columbia University. | America | http://trove.nla.gov.au/newspaper/page/26800461 | 26800461 | |
13421 | 13421 | 1904-06-25 | Suppl't | b | Chinese envoy Bei Zi in St Louise, United States. | America | http://trove.nla.gov.au/newspaper/page/26800466 | 26800466 | |
13671 | 13671 | 1904-08-13 | Suppl't | a | An article, selected from an American newspaper, discusses the Yellow Peril. | America | http://trove.nla.gov.au/newspaper/page/26800501 | 26800501 | |
13676 | 13676 | 1904-08-13 | Suppl't | b | America's view on what China would be like after the Russo-Japanese War. | America | http://trove.nla.gov.au/newspaper/page/26800501 | 26800501 | |
13791 | 13791 | 1904-09-10 | Suppl't | b | A priest in Chicago, USA, was attacked for advocating interracial marriage between black and white people. | America | http://trove.nla.gov.au/newspaper/page/26800521 | 26800521 | |
14001 | 14001 | 1904-11-19 | Suppl't | a | President Roosevelt of the Untied States has won another term. | America | http://trove.nla.gov.au/newspaper/page/26800571 | 26800571 | |
14005 | 14005 | 1904-11-19 | Suppl't | b | American navy is expanding. | America | http://trove.nla.gov.au/newspaper/page/26800571 | 26800571 | |
14131 | 14131 | 1904-12-31 | Suppl't | c | Kang Youwei arrives in Vancouver. He will travel to the United States. | America | http://trove.nla.gov.au/newspaper/page/26800601 | 26800601 | |
14148 | 14148 | 1905-01-07 | Suppl't | a | Farmers in Southern America have started to destroy some cotton in order to retain a reasonable price. | America | http://trove.nla.gov.au/newspaper/page/26800606 | 26800606 | |
14489 | 14489 | 1905-05-20 | Suppl't | b | Japan puts forward their conditions for truce with Russia. | America | http://trove.nla.gov.au/newspaper/page/26800697 | 26800697 | |
14793 | 14793 | 1905-09-16 | Suppl't | a | Japanese Prime Minister Katsura Taro is keen to teach China and Korea on reform and new politics. | America | http://trove.nla.gov.au/newspaper/page/26800778 | 26800778 |
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]);