This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26076 | 26076 | 1912-04-27 | 7 | a-b | Australian news | Australia's first aircraft invented. Chinese beaten by racial white Australians as he married Australian woman. Two Chinese in South Australia arrested for fraud and possession of drugs. Australian woman nearly raped on train. A seventy-four year old man charged with rape of a young girl. Gamblers caught by police in New South Wales. Heavy rain and wind make a big damage in New South Wales. | Other... | http://trove.nla.gov.au/newspaper/page/24092219 | 24092219 |
26077 | 26077 | 1912-04-27 | 7 | b-c | Factional fights in Chaozhou and Shantou | Details about factional fights in Chaozhou and Shantou, Fujian. | Other... | http://trove.nla.gov.au/newspaper/page/24092219 | 24092219 |
26078 | 26078 | 1912-04-27 | 7 | c | Chitchat | France has most professional women. Three governments in Paraguay. | Other... | http://trove.nla.gov.au/newspaper/page/24092219 | 24092219 |
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]);