This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24838 | 24838 | 1911-08-12 | 7 | a-b | Australia news | Chinese woman is unreasonably forbidden to immigrate to Australia, Chinese man was beaten in Sydney. Australian man tells his experience in Japan. Chinese in Melbourne have short memory of shame. Current census in West Australia, An European was found selling opium. An European divorced his wife for a new woman. The highest man Pat O'Connor is arriving in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24091878 | 24091878 |
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]);