This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2386 | 2386 | 1899-05-06 | 2 | a-b | The second part of a report submitted by Yu Liansan, Governor of Hunan. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2387 | 2387 | 1899-05-06 | 2 | b | Lu Chuanlin, Governor of Guangdong, strengthens the bureaucracy of Guangdong. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2388 | 2388 | 1899-05-06 | 2 | c-e | The second part of a biography of Kang Guangren, brother of Kang Youwei and one of the six martyrs. Written by Liang Qichao. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2389 | 2389 | 1899-05-06 | 2 | e | Russia encourages business activities; British businessmen travel to Russia to investiage business potential. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2390 | 2390 | 1899-05-06 | 2 | e | A businessman in England was penalised for passing off local lamb as imported Welsh lamb. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2391 | 2391 | 1899-05-06 | 2 | e | War in the Philippines, USA involvement. More fighting in Luzon. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2392 | 2392 | 1899-05-06 | 2 | e | A mad man in Germany murders his wife and children. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2393 | 2393 | 1899-05-06 | 2 | e | Austria discovers powerful gunpowder. | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
2394 | 2394 | 1899-05-06 | 2 | e | Queen of Britain named a bridge of France as "Victoria". | http://trove.nla.gov.au/newspaper/page/24102388 | 24102388 | ||
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 |
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]);