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 |
|---|---|---|---|---|---|---|---|---|---|
| 1035 | 1035 | 1898-10-29 | 3 | a-b-c | Strengthening China is like to curing an illness, only fundamental solutions will work. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1036 | 1036 | 1898-10-29 | 3 | c | Chinese men fight with Western youths in graveyard in West Wyalong, NSW when Chinese visit ancestors' graves. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1037 | 1037 | 1898-10-29 | 3 | c-d | Woman, daughter of tenant taken away when he could not pay rent. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1038 | 1038 | 1898-10-29 | 3 | d | His Majesty welcomes comments on state affairs. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1039 | 1039 | 1898-10-29 | 3 | d-e | Girl in Xinhui faced and overcame threat of ghost who harassed her. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1040 | 1040 | 1898-10-29 | 3 | e | Counterfeit money found in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1041 | 1041 | 1898-10-29 | 3 | e-f | Poor girl in Sydney commits suicide due to poverty. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1042 | 1042 | 1898-10-29 | 3 | f | Injuries occur as people in Shunde gather together to celebrate the Mid-Autumn Festival. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1043 | 1043 | 1898-10-29 | 3 | f | Newspapers accessible to more and more people in Guangdong, who now learn more about outside world. | http://trove.nla.gov.au/newspaper/page/24102180 | 24102180 | ||
| 1044 | 1044 | 1898-10-29 | 2 | a | Two prostitutes spy in Hong Kong for criminal group. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1045 | 1045 | 1898-10-29 | 2 | a-b | Emperor's effort to implement reform blocked by Empress; government security searchs Nanhai Society in south Beijing, attempting to find Kang Youwei. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1046 | 1046 | 1898-10-29 | 2 | b-c | Temples in Guangzhou harassed as officials try to turn them into modern schools. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1047 | 1047 | 1898-10-29 | 2 | c | Academy of classical learning in Guangzhou, shuyuan, has become a modern Chinese and Western school, xuetang. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1048 | 1048 | 1898-10-29 | 2 | c-d | Adulterers caught in bed in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1049 | 1049 | 1898-10-29 | 2 | d | 11-year-old girl drowns in NSW. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1050 | 1050 | 1898-10-29 | 2 | d | His Majesty recovering; British business representative talks with Chinese officials; British company to build railway from Beijing to Hankou. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1051 | 1051 | 1898-10-29 | 2 | e | Crops from Zhangjiakou to Huaihua, Hebei province, damaged due to strange weather. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1052 | 1052 | 1898-10-29 | 2 | e-f | Loyal and filial man in Guangxi. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1053 | 1053 | 1898-10-29 | 2 | f | Xiangshan man penalised for harbouring escaped convict. | http://trove.nla.gov.au/newspaper/page/24102179 | 24102179 | ||
| 1054 | 1054 | 1898-10-29 | 4 | a | Position of Guangdong Governor eliminated under redundancy plan. | http://trove.nla.gov.au/newspaper/page/24102177 | 24102177 | ||
| 1055 | 1055 | 1898-10-29 | 4 | a-b | Chinese killed while working in his garden. | http://trove.nla.gov.au/newspaper/page/24102177 | 24102177 | ||
| 1056 | 1056 | 1898-10-29 | 4 | b-c | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102177 | 24102177 |
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]);