This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1185 | 1185 | 1898-11-19 | 3 | a-b | Memorial report, written by Lin Luocun and presented to His Majesty, suggests to use syncopated words. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1186 | 1186 | 1898-11-19 | 3 | b-c | New Castle boy kicked to death by horse. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1187 | 1187 | 1898-11-19 | 3 | c | Juvenile crime, two naughty boys in Melbourne kill man. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1188 | 1188 | 1898-11-19 | 3 | c-d | Fireworks in Zhaoqing, Guangdong province, nearly caused big fire. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1189 | 1189 | 1898-11-19 | 3 | d | Shark found dead near New Castle. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1190 | 1190 | 1898-11-19 | 3 | e | Governor in Guangdong extended favour to gangsters. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1191 | 1191 | 1898-11-19 | 3 | d-e | Tottoos in USA. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1192 | 1192 | 1898-11-19 | 3 | e | Western medicine's new discoveries about nature of human brain. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1193 | 1193 | 1898-11-19 | 3 | e-f | Only forty of the 250 personnel will retain their positions after changes to the Imperial Academy (han lin yuan). | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1194 | 1194 | 1898-11-19 | 3 | f | Japanese government attempts to increase loans from foreign nations. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
1195 | 1195 | 1898-11-19 | 3 | f | Li Hongzhang ordered to dredge and realign the Yellow River in order to prevent flooding. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 |
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]);