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 |
|---|---|---|---|---|---|---|---|---|---|
| 941 | 941 | 1898-10-15 | 3 | a-b-c | Russia increases threats towards China, possible response from China. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 942 | 942 | 1898-10-15 | 3 | c | New Castle woman jumps into ocean. Her husband died days before. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 943 | 943 | 1898-10-15 | 3 | c | Chinese in Windorah, Queensland, fined for kicking patrol officer; White man in Queensland sentenced for raping 12-year-old girl. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 944 | 944 | 1898-10-15 | 3 | c-d | Adelaide man dies during tour of Victoria. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 945 | 945 | 1898-10-15 | 3 | d-e | Ferryboat in Dongguan, Guangdong province, sinks on journey to Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 946 | 946 | 1898-10-15 | 3 | f | Troops from Russia, Britain and Germany arrive in Beijing in response to Chinese residents insulting foreigners. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 947 | 947 | 1898-10-15 | 3 | f | His Majesty ill after taking strange red pill. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 948 | 948 | 1898-10-15 | 3-2 | f-a | Three royal family members hurt by a diamond in Spain. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 949 | 949 | 1898-10-15 | 2 | a | Japanese man in Queensland charged for murdering another Japanese man. Brother of American First Lady killed on street. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 950 | 950 | 1898-10-15 | 2 | a-b | Girl sustains burns after her clothes caught fire. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 951 | 951 | 1898-10-15 | 2 | b | Sydney builds new tramway to be completed next March. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 952 | 952 | 1898-10-15 | 2 | b-c | Man's confession about visits to prostitutes. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 953 | 953 | 1898-10-15 | 2 | c | Two men detained for stealing a cow in NSW. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 954 | 954 | 1898-10-15 | 2 | c-d | Three women drown in South Australia. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 955 | 955 | 1898-10-15 | 2 | d-e | Female criminal in San Francisco. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 956 | 956 | 1898-10-15 | 2 | e-f | Advantages and disadvantages of new ferry service from Foshan to Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 957 | 957 | 1898-10-15 | 2 | f | Nightmare involving prostitute frightens away thief in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102163 | 24102163 | ||
| 958 | 958 | 1898-10-15 | 4 | a | Empress Dowager controls everything while Emperor stands aside; Empress prohibits publication of newspapers; Chinese Ambassador to Japan under custody for advocating political reform; Japan and Italy send troops to protect their citizens in Beijing; Zongli Yamen complains that Russia sent too many officers to Beijing. | http://trove.nla.gov.au/newspaper/page/24102161 | 24102161 | ||
| 959 | 959 | 1898-10-15 | 4 | a-b | Chinese kills Maori in Auckland; man was drowna in Toowoomba, NSW; train accident in NSW. | http://trove.nla.gov.au/newspaper/page/24102161 | 24102161 | ||
| 960 | 960 | 1898-10-15 | 4 | b | Queen of England comments on America-Spain War, China issues, African issues, epidemic in India, and performance of British government. | http://trove.nla.gov.au/newspaper/page/24102161 | 24102161 | ||
| 961 | 961 | 1898-10-15 | 4 | b | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102161 | 24102161 |
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]);