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 |
|---|---|---|---|---|---|---|---|---|---|
| 849 | 849 | 1898-10-01 | 4 | a | Newspaper editorial encouraging people to celebrate the Mid-Autumn Festival. | http://trove.nla.gov.au/newspaper/page/24102145 | 24102145 | ||
| 850 | 850 | 1898-10-01 | 4 | a | Governor of Queensland passes away. | http://trove.nla.gov.au/newspaper/page/24102145 | 24102145 | ||
| 851 | 851 | 1898-10-01 | 4 | a-b | Empress Dowager outraged at Kang Youwei's collaboration with His Majesty; she controlls court politics completely. | http://trove.nla.gov.au/newspaper/page/24102145 | 24102145 | ||
| 852 | 852 | 1898-10-01 | 4 | b | Taiwanese people refuse to cooperate with invading Japanese troops. | http://trove.nla.gov.au/newspaper/page/24102145 | 24102145 | ||
| 853 | 853 | 1898-10-01 | 4 | b | Price list of products on Sydney market. | http://trove.nla.gov.au/newspaper/page/24102145 | 24102145 | ||
| 854 | 854 | 1898-10-01 | 4 | c | Notice alerting directors of newspaper to upcoming meeting. | http://trove.nla.gov.au/newspaper/page/24102145 | 24102145 | ||
| 855 | 855 | 1898-10-01 | 3 | a-b-c | Report to His Majesty from Sheng Xuanhuai and Board of Revenue (hu bu) on establishment of Bank of China. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 856 | 856 | 1898-10-01 | 3 | c | Man in Ararat was sentenced to 10 years' imprisonment for bank robbery. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 857 | 857 | 1898-10-01 | 3 | c-d | Retired police officer in NSW killed his wife and child. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 858 | 858 | 1898-10-01 | 3 | d | Priest in Melbourne crushed to death in horse-riding accident. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 859 | 859 | 1898-10-01 | 3 | d-e | Man in Sydney kills five family members because he was not able to feed them. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 860 | 860 | 1898-10-01 | 3 | e | Melbourne man kills his lover. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 861 | 861 | 1898-10-01 | 3 | e | Man robbed on Sydney street while returning home at night. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 862 | 862 | 1898-10-01 | 3 | e-f | Man in Zhaoqing dies young. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 863 | 863 | 1898-10-01 | 3 | f | Melbourne man travels long distance on bicycle. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 864 | 864 | 1898-10-01 | 3 | f | Britain builds six more torpedo boats. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
| 865 | 865 | 1898-10-01 | 2 | a-b | Poems written by eight famous poets in Guangdong. | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 | ||
| 866 | 866 | 1898-10-01 | 2 | b | Good couple in Dongguan suspected of murder. | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 | ||
| 867 | 867 | 1898-10-01 | 2 | b | Passenger boat sinks due to tornado near Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 | ||
| 868 | 868 | 1898-10-01 | 2 | b-c-d | First part of article on the strength of China, and need for reform. | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 | ||
| 869 | 869 | 1898-10-01 | 2 | d-e | Empress Dowager takes over Li Hongzhang's prime ministership; Zhang Yinyuan removed for harbouring Kang Youwei | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 | ||
| 870 | 870 | 1898-10-01 | 2 | e | Registrar of births, deaths and marriage in Sydney commits suicide. | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 | ||
| 871 | 871 | 1898-10-01 | 2 | e-f | Disabled woman in Switzerland paints with her feet. | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 | ||
| 872 | 872 | 1898-10-01 | 2 | f | Strange rainbow appears in sky near Yantai, Shandong province. | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 | ||
| 873 | 873 | 1898-10-01 | 2 | f | Ship for San Francisco carries gold. | http://trove.nla.gov.au/newspaper/page/24102147 | 24102147 |
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]);