This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
3030 | 3030 | 1899-07-12 | 2 | a-c | The first part of a report submitted by Pu Liang. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3031 | 3031 | 1899-07-12 | 2 | c-d | An essay on the restructuring and reorganisation of China's bureaucracy. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3032 | 3032 | 1899-07-12 | 2 | d-e | Storm in London; chaos in the Parliament of Italy; a baby boy was abandoned in Albury; fight between Aboriginal groups in Queensland; metal exports from Tasmania; cold weather influences agricultural production in Australia. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3033 | 3033 | 1899-07-12 | 2 | e | A worker dies in an accident at a sawmill in Sydney. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3034 | 3034 | 1899-07-12 | 2 | e | Hobart, Tasmania passes law prohibiting anyone under the age of 13 from smoking on the street. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3035 | 3035 | 1899-07-12 | 2 | e | Epidemic in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3036 | 3036 | 1899-07-12 | 2 | f | A man in Nanhai sold his hard-working cattle to butcher immediately after it ceased being able to work. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3037 | 3037 | 1899-07-12 | 2 | f | The habit of drinking in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3038 | 3038 | 1899-07-12 | 2 | f | A man in Melbourne penalised for stealing bank notes from post office. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3039 | 3039 | 1899-07-12 | 2 | f | France's budget for its army. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
3040 | 3040 | 1899-07-12 | 2 | f | Rev. Zhou in Qingpu county, Zhejiang province, is building an astronomical observatory in a nearby mountain. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 |
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]);