This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
969 | 969 | 1898-10-19 | 2 | a | Foreign newspapers rumour that Empress Dowager would like new emperor under her total control. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
970 | 970 | 1898-10-19 | 2 | a-b | New railway project connecting Guangzhou to Hankou. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
971 | 971 | 1898-10-19 | 2 | b | Sydney Townhall receives compensation from government. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
972 | 972 | 1898-10-19 | 2 | b-c | Article about mosquitoes. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
973 | 973 | 1898-10-19 | 2 | c | Italian troops arrived in Beijing; Emperor Guangxu is now under house arrest; Zhang Yinyuan has been banished. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
974 | 974 | 1898-10-19 | 2 | c-d | Strange snake found in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
975 | 975 | 1898-10-19 | 2 | d | Woman in Parkes hangs herself when unable to feed her four children. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
976 | 976 | 1898-10-19 | 2 | d-e | Man disappears when swimming in NSW. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
977 | 977 | 1898-10-19 | 2 | f | Chinese in Queensland killed by his roommate. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 | ||
978 | 978 | 1898-10-19 | 2 | f | American man gains fame for his skill in gold hunting. | http://trove.nla.gov.au/newspaper/page/24102167 | 24102167 |
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]);