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 |
|---|---|---|---|---|---|---|---|---|---|
| 2916 | 2916 | 1899-07-01 | 2 | a-c | The third part of a report submitted by Yu Liansan, Governor of Hunan province. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2917 | 2917 | 1899-07-01 | 2 | c-e | The number of married men and women in America. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2918 | 2918 | 1899-07-01 | 2 | e | A Sydney judge commits suicide. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2919 | 2919 | 1899-07-01 | 2 | e | Quantity and value of coal exported from colonies of Australia. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2920 | 2920 | 1899-07-01 | 2 | e | Situation in Luzon. Britain sends troops to the Philippines to recover two British men detained by the local forces. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2921 | 2921 | 1899-07-01 | 2 | f | A man in New South Wales found three diamonds. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2922 | 2922 | 1899-07-01 | 2 | f | A lawyer in New Zealand has been promoted. The lawyer is known for his kindness to Chinese. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2923 | 2923 | 1899-07-01 | 2 | f | An old man in New South Wales commits suicide after the federation referendum. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2924 | 2924 | 1899-07-01 | 2 | f | Total lunar eclipse in Australia. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2925 | 2925 | 1899-07-01 | 2 | f | Transvaal trains its troops in readiness for a war should one occur. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2926 | 2926 | 1899-07-01 | 2 | f | Bandits are still active in Yong'an, Haifeng, Lufeng, Huilai and Jieyang. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
| 2927 | 2927 | 1899-07-01 | 3 | a | News from the Philippines; British company builds a large ship; reports from the international peace conference; earthquake in Alexandra, Victoria; British royal family prepares to sponsor exploration of Antarctica; St Vincent Hospital in Melbourne raises funds; Melbourne radio functions explored; railway office of Queensland pays compensation. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2928 | 2928 | 1899-07-01 | 3 | a | Russia plans to build a railway through Siberia. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2929 | 2929 | 1899-07-01 | 3 | a | Transvaal prepares to fight Britain. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2930 | 2930 | 1899-07-01 | 3 | a | Smallpox outbreak in Cowra, New South Wales, claims 13 lives. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2931 | 2931 | 1899-07-01 | 3 | b | A Maori husband in New Zealand murders his wife. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2932 | 2932 | 1899-07-01 | 3 | b | British missionaries and their followers injured in Fujian, and churches destroyed in recent attacks. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2933 | 2933 | 1899-07-01 | 3 | b | A Chinese missionary in Jianyang county, Fujian province, was injured. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2934 | 2934 | 1899-07-01 | 3 | b | A fire destroys a herb shop in Guangzhou, despite rainfall at the time. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2935 | 2935 | 1899-07-01 | 3 | b | Chinese and French clash in Guangzhou Bay. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2936 | 2936 | 1899-07-01 | 3 | b | Oil shop robbed in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2937 | 2937 | 1899-07-01 | 3 | b-c | Diseases could be carried through telephones. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2938 | 2938 | 1899-07-01 | 3 | c | Number of foreign settlements in China. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2939 | 2939 | 1899-07-01 | 3 | c | Heavy rainfall in New South Wales. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2940 | 2940 | 1899-07-01 | 3 | c | German hairdresser in Auckland commits suicide. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2941 | 2941 | 1899-07-01 | 3 | c | Chinese community in Melbourne donates to hospitals. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2942 | 2942 | 1899-07-01 | 3 | c | Japanese would rather commit suicide than surrender themselves. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2943 | 2943 | 1899-07-01 | 3 | d | Japan requests a settlement in Xiamen, Fujian province, but was refused. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2944 | 2944 | 1899-07-01 | 3 | d | A Melbourne man was buried in an area where he lost his way many years ago. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2945 | 2945 | 1899-07-01 | 3 | d | A businessman in South Africa originally accused a teacher of acting improperly; he has know withdrawn his complaint. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2946 | 2946 | 1899-07-01 | 3 | d | An old man in Auckland dies at the age of 100. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2947 | 2947 | 1899-07-01 | 3 | d | Chinese government plans to build fortifications for Beijing; Russian troops build river in Lushun; local residents in Jiaozhou, Shandong province, clash with German; reports from the international peace conference; income tax in Victoria and New South Wales. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2948 | 2948 | 1899-07-01 | 3 | e | Young man in Sydney faces penalities for fishing. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2949 | 2949 | 1899-07-01 | 3 | e | A brave heroine in Dongguan. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2950 | 2950 | 1899-07-01 | 3 | e | British government demands compensation from China for murdering of an Adelaide missionary in China. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2951 | 2951 | 1899-07-01 | 3 | e | Fighting between family clans in Zengcheng; lawsuits pending. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2952 | 2952 | 1899-07-01 | 3 | f | A woman in Badong county, Hubei province, mysteriously changes into a man. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2953 | 2953 | 1899-07-01 | 3 | f | Three Chinese from Sydney return home with gold. | http://trove.nla.gov.au/newspaper/page/24102451 | 24102451 | ||
| 2954 | 2954 | 1899-07-01 | 4 | a | German man wants to build church in Rizhao county, Shandong province; German troops move in Shandong. | http://trove.nla.gov.au/newspaper/page/24102454 | 24102454 | ||
| 2955 | 2955 | 1899-07-01 | 4 | a | Russian in northeastern China detained more than ten Japanese spies. | http://trove.nla.gov.au/newspaper/page/24102454 | 24102454 |
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]);