This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
3531 | 3531 | 1899-09-13 | 2 | a-b | A report from Yu Chang, Governor of Henan province. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3532 | 3532 | 1899-09-13 | 2 | b | A report from Yu Xiang, military commander in Chengdu, Sichuan province. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3533 | 3533 | 1899-09-13 | 2 | b-c | A report from Shou Yi, commander in Guangzhou, Tan Zhonglin, Governor of Guangdong and Guangxi, and Lu Chuanlin, Governor of Guangdong province. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3534 | 3534 | 1899-09-13 | 2 | c | A report from Tan Zhonglin, Governor of Guangdong and Guangxi. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3535 | 3535 | 1899-09-13 | 2 | c-e | Records of Kang Youwei's interview with The Times in London. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3536 | 3536 | 1899-09-13 | 2 | e | An Adelaide woman working in post office charged with embezzlement. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3537 | 3537 | 1899-09-13 | 2 | e-f | A Chinese man who returning to Australia from China was penalised for smuggling opium into Melbourne. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3538 | 3538 | 1899-09-13 | 2 | f | A murder case in Brisbane. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3539 | 3539 | 1899-09-13 | 2 | f | Another fund-raising fete to establish a new hospital in Sydney. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 | ||
3540 | 3540 | 1899-09-13 | 2 | f | A Chinese in Adelaide was injured in a mugging, but was saved. | http://trove.nla.gov.au/newspaper/page/24102530 | 24102530 |
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]);