This data as json, CSV (advanced)
date (date) 9 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1862 | 1862 | 1899-03-01 | 2 | j-k | Britain and France disagree over a series of issues. | http://trove.nla.gov.au/newspaper/page/24102310 | 24102310 | ||
1886 | 1886 | 1899-03-04 | 2 | j-k | Butcher in Foshan, Guangdong, destined to lose. | http://trove.nla.gov.au/newspaper/page/24102313 | 24102313 | ||
1914 | 1914 | 1899-03-08 | 2 | j-k | The new Governor of Guangdong, Lu Chuanlin, takes up his position. | http://trove.nla.gov.au/newspaper/page/24102318 | 24102318 | ||
1926 | 1926 | 1899-03-08 | 3 | j-k | Hen in Zengcheng laid an egg with foreign characters on it. | http://trove.nla.gov.au/newspaper/page/24102317 | 24102317 | ||
1954 | 1954 | 1899-03-15 | 2 | j-k | Report submitted by Kang Youwei recommending the estalishment of agricultural schools and geological departments. | http://trove.nla.gov.au/newspaper/page/24102326 | 24102326 | ||
1973 | 1973 | 1899-03-15 | 3 | j-k | Woman in Foshan raped by thieves. | http://trove.nla.gov.au/newspaper/page/24102325 | 24102325 | ||
1984 | 1984 | 1899-03-18 | 2 | j-k | Casualties of war between US and Spain in Luzon, the Philippines. | http://trove.nla.gov.au/newspaper/page/24102330 | 24102330 | ||
2037 | 2037 | 1899-03-25 | 2 | j-k | Encouraging social morality. | http://trove.nla.gov.au/newspaper/page/24102338 | 24102338 | ||
2067 | 2067 | 1899-03-29 | 2 | j-k | A cargo boat detained in Guangzhou for suspected smuggling. | http://trove.nla.gov.au/newspaper/page/24102342 | 24102342 | ||
2080 | 2080 | 1899-03-29 | 3 | j-k | Two Chinese in New South Wales were diagnosed with leprosy. | http://trove.nla.gov.au/newspaper/page/24102341 | 24102341 | ||
2129 | 2129 | 1899-04-05 | 2 | j-k | Samoa new hot spot for US, France and Germany. | http://trove.nla.gov.au/newspaper/page/24102350 | 24102350 | ||
2168 | 2168 | 1899-04-08 | 2 | j-k | Britain, USA and Germany will jointly investigate riots in Samoa, American government accepts suggestions from Germany; New Zealand ready to send some soldier to Samoa. | http://trove.nla.gov.au/newspaper/page/24102354 | 24102354 |
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]);