This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29298 | 29298 | 1914-10-10 | 6 | a-b | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093282 | 24093282 | |
29300 | 29300 | 1914-10-10 | 7 | a-b | Australia news/ Federal treasurer confirms to issue more money. Two merchant ships collide outside of Sydney. Examination and the result at the Sydney Chinese School. Chinese community in Sydney prepares to celebrate the National Day and the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093281 | 24093281 |
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]);