This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 |
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]);