This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28451 | 28451 | 1914-01-24 | 6 | a-b | A political meeting in Beijing and government officials in attendance. | China | http://trove.nla.gov.au/newspaper/page/24092973 | 24092973 | |
28456 | 28456 | 1914-01-24 | 7 | a-b | Australia news/ Homeless and poor people in Sydney and the government's effort to help them. Chinese opium smoker is detained in Sydney. Fire alarm on the weekend. Chinese remains found underground near Tingha, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092972 | 24092972 |
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]);