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 |
---|---|---|---|---|---|---|---|---|---|
21365 | 21365 | 1909-07-24 | 3 | c | American naval fleet on the way to the Philippines. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
21366 | 21366 | 1909-07-24 | 3 | c | German cabinet reshuffled following the resignation of the Chancellor. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
21367 | 21367 | 1909-07-24 | 3 | c | A British submarine sinks in the Atlantic. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
21368 | 21368 | 1909-07-24 | 3 | c | American President Taft appoints new ambassador to China. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
21369 | 21369 | 1909-07-24 | 3 | c | Earthquake in Greece. | Britain | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
21370 | 21370 | 1909-07-24 | 3 | c | Number of university students in France. | France | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
21371 | 21371 | 1909-07-24 | 3 | c | Survey on naval forces in Britain, Germany, America, France, Japan, Italy and Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802261 | 26802261 | |
21378 | 21378 | 1909-07-24 | 6 | c | A Sichuan scholar writes bagu (eight-part essay) for Li Zhuohua, an official who was dismissed for advocating imperial examination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802268 | 26802268 | |
21391 | 21391 | 1909-07-24 | 7 | c | Chinese consul general in Melbourne Liang Lanxun visits Perth, meets governor of Western Australia, and talks to the Chinese community. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 | |
21392 | 21392 | 1909-07-24 | 7 | c | Two old Chinese men near Bendigo Kang Lai and Yah Rong, respectively 77 and 70, fight each other with knife and Yah Rong is killed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 | |
21393 | 21393 | 1909-07-24 | 7 | c | Chinese student Wu Daohong first in an American university. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802267 | 26802267 |
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]);