This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28455 | 28455 | 1914-01-24 | 7 | a | A notice issued by the Chines Chamber of Commerce to elect its directors, committee members and other positions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092972 | 24092972 | |
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 | |
28457 | 28457 | 1914-01-24 | 7 | b | Tung Wah Times comments on the calendar change in China and the celebration on the New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092972 | 24092972 | |
28458 | 28458 | 1914-01-24 | 7 | b-c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | 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]);