This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27473 | 27473 | 1913-05-24 | 2 | a-b | Full text of China's foreign loan contract. | Other... | http://trove.nla.gov.au/newspaper/page/24092689 | 24092689 | |
27501 | 27501 | 1913-05-24 | 6 | a-b | Message from Shanghai about Song Jiaoren's case and China's foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/24092693 | 24092693 | |
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 | |
27507 | 27507 | 1913-05-24 | 8 | a-b | China National Railway Company's regulations. | Other... | http://trove.nla.gov.au/newspaper/page/24092695 | 24092695 |
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]);