This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27503 | 27503 | 1913-05-24 | 7 | a-b | Australian news/ Heavy rain in New South Wales. Chinese summoned to court for using false certificate entry into Australia. Chinese saiors not allowed to leave ship when arriving in Australia. Chinese shop owner attacked by robbers. Chinese knife wounds several people over dispute. Furniture shop robbed. Correction for Mai Xixiang's previous article. | Other... | http://trove.nla.gov.au/newspaper/page/24092692 | 24092692 | |
27504 | 27504 | 1913-05-24 | 7 | b | Beijing government strengthens its army force against south's intention of independence. | Britain | http://trove.nla.gov.au/newspaper/page/24092692 | 24092692 | |
27505 | 27505 | 1913-05-24 | 7 | b | Government intends to send ship overseas to show appreciation to overseas Chinese abroad. | Other... | http://trove.nla.gov.au/newspaper/page/24092692 | 24092692 |
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]);