This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2395 | 2395 | 1899-05-06 | 2 | f | The major motive of Western countries is to carve up Chinese territory. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2396 | 2396 | 1899-05-06 | 2 | f | Portugal wants a port between Fuzhou and Xiamen in Fujian province. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2397 | 2397 | 1899-05-06 | 2 | f | The price of silver increases in London. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2398 | 2398 | 1899-05-06 | 2 | f | An unfilial son in Xiangshan beats his father. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2399 | 2399 | 1899-05-06 | 2 | f | No rain in Xiangshan for a few months. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2416 | 2416 | 1899-05-06 | 3 | f | Zhang Yinyuan arrives in Urumqi, Xinjiang. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
2417 | 2417 | 1899-05-06 | 3 | f | More reports on the suggested tri-alliance of Russia, France and Germany. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
2418 | 2418 | 1899-05-06 | 3 | f | The function and usage of radio for ocean travelling. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
2419 | 2419 | 1899-05-06 | 3 | f | Qing Yi Bao is banned from business in Hankou. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
2420 | 2420 | 1899-05-06 | 3 | f | Tornado in the USA claims casualties. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
2421 | 2421 | 1899-05-06 | 3 | f | Epidemic in South Africa claims many lives. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 |
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]);