This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, 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 | ||
| 2400 | 2400 | 1899-05-06 | 3 | a-b | The third part of an article about the life of Chinese in Australia. Written by Zheng Lu. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2401 | 2401 | 1899-05-06 | 3 | b | Heavy rain in Lismore, New South Wales. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2402 | 2402 | 1899-05-06 | 3 | b | Comments from USA military officer arouses anger in Germany. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2403 | 2403 | 1899-05-06 | 3 | b | Russia is building a railway through Siberia. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2404 | 2404 | 1899-05-06 | 3 | b-c | Mr Huang, of Nanhai, cut meat from his leg to feed his mother. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2405 | 2405 | 1899-05-06 | 3 | c | British Foreign Secretary comments on the international peace conference suggested by Tsar of Russia. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2406 | 2406 | 1899-05-06 | 3 | c | A big company in USA. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2407 | 2407 | 1899-05-06 | 3 | c | Local people return home. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2408 | 2408 | 1899-05-06 | 3 | c-d | A man in Germany has many common points with the King. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2409 | 2409 | 1899-05-06 | 3 | d | Russia is going to use new calendar. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2410 | 2410 | 1899-05-06 | 3 | d | A black man punished for harassing White woman, burnt to death. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2411 | 2411 | 1899-05-06 | 3 | d | States in Australia have refused the wine tax proposal from Britain. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2412 | 2412 | 1899-05-06 | 3 | d | Government and the people in Guangzhou are praying for rain. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2413 | 2413 | 1899-05-06 | 3 | e | Religious belief of Russian people. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2414 | 2414 | 1899-05-06 | 3 | e | A volcano in Zhaoqing, Guangdong province. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 2415 | 2415 | 1899-05-06 | 3 | e | Russia and Britain compete each other over their interest in China. | http://trove.nla.gov.au/newspaper/page/24102387 | 24102387 | ||
| 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 | ||
| 2422 | 2422 | 1899-05-06 | 4 | a | Zhan Yaodian is back home enjoying his wealthy after many years away. | http://trove.nla.gov.au/newspaper/page/24102390 | 24102390 |
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]);