This data as json, CSV (advanced)
Suggested facets: page, column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1159 | 1159 | 1898-11-16 | 3 | a-b | Proposal written by Hong Ruchong to move capital of China. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1160 | 1160 | 1898-11-16 | 3 | b-c | Four Chinese men in Gilgandra, New South Wales, arrested for gambling. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1161 | 1161 | 1898-11-16 | 3 | c | Bridegroom in Gaoyao robbed. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1162 | 1162 | 1898-11-16 | 3 | c-d | Man in Dongguan kills himself after stabbing dog to death. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1163 | 1163 | 1898-11-16 | 3 | d | Chinese fellow in Goulburn, NSW, burned to death. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1164 | 1164 | 1898-11-16 | 3 | d | Diamonds from mountain in Shandong province is famous. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1165 | 1165 | 1898-11-16 | 3 | d-e | Fireworks kill five people in Shunde, Guangdong province. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1166 | 1166 | 1898-11-16 | 3 | e | Statistics from census in Wuchang, Hubei province. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1167 | 1167 | 1898-11-16 | 3 | e-f | Chinese gardener stabbed to death in garden in Wagga Wagga, New South Wales. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1168 | 1168 | 1898-11-16 | 3 | f | Yellow River burst its banks, flooding large area; twenty American soldiers arrive in Beijing to protect diplomats. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
1169 | 1169 | 1898-11-16 | 3-2 | f-a-b | Current political situation and developments in China. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 |
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]);