This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 1957 | 1957 | 1899-03-15 | 3 | a | An ammunition warehouse in France exploded recently. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1958 | 1958 | 1899-03-15 | 3 | a | A young hairdresser in Sydney was punished for stealing butter from a shop. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1959 | 1959 | 1899-03-15 | 3 | b | An Anglican missionary from Britain is now touring Australia. His speeches attract many people. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1960 | 1960 | 1899-03-15 | 3 | b-c | Even the Queen of the England is placed under many restrictions. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1961 | 1961 | 1899-03-15 | 3 | c-d | Deng Ru, a native of Fujian province, murdered in Hawthorn, Melbourne, at the age of 73. No clues as to the identity of the murder. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1962 | 1962 | 1899-03-15 | 3 | d | Sydney girl killed by new machine she went to see. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1963 | 1963 | 1899-03-15 | 3 | e | Some advice on ways to export fruit. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1964 | 1964 | 1899-03-15 | 3 | e-f | Britain approves a loan to China for the building of a railway from Shanhaiguan to Niuzhuang; Russia and Britain disagree over railway issues in China; Russia forces China to withdraw its loan application to Britain; Germany plans to negotiate with Russia about their privilege in China; Zongli Yamen explaines to Italian ambassador in Beijing why China refused their request for land near Ningbo. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1965 | 1965 | 1899-03-15 | 3 | f | Russia and Britain in dispute over railway development in China. The two nations have conflicting motives. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1966 | 1966 | 1899-03-15 | 3 | g | Heavy snow fall creates problems in US. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1967 | 1967 | 1899-03-15 | 3 | g-h | Statistics on Japan's imports and exports. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1968 | 1968 | 1899-03-15 | 3 | h-i | Hundreds of people in danger due to strong winds near Brisbane. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1969 | 1969 | 1899-03-15 | 3 | i | Dockers in Fremantle strike, demand pay rise. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1970 | 1970 | 1899-03-15 | 3 | i-j | Britain, US and Germany obstruct expansion plan for Shanghai. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1971 | 1971 | 1899-03-15 | 3 | j | Thieves rob business in Xiangshan, take money meant to pay worker's salary. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1972 | 1972 | 1899-03-15 | 3 | j | A hen in Foshan changes into a cock. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1973 | 1973 | 1899-03-15 | 3 | j-k | Woman in Foshan raped by thieves. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1974 | 1974 | 1899-03-15 | 3 | k | Nanhai, Panyu and several other counties regulate cattle-whipping practices in Spring. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1975 | 1975 | 1899-03-15 | 3 | l | Bandits in Xinhui rob passenger boat. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
| 1976 | 1976 | 1899-03-15 | 3 | l | Nanhai, Panyu and Shunde plan reforms to stop bad habits of locals. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 |
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]);