This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46676 | 46676 | 1928-01-21 | 2 | b | Editorial by Tung Wah Times on opium and the war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098672 | 24098672 | |
46696 | 46696 | 1928-01-21 | 7 | a | Australia news/ Chinese man detained in Darwin for opium smuggling. Peanut production increases in Queensland. Burglary of a jewellery shop in Sydney. Chinese gardens in Sydney and their loss of profit. Fire in Sydney destroys shops. Illegal Chinese immigrant detained in Sydney. Hails in Inverell. Photograph of the Sydney Chinese Sports Club's soccer team, 1927. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098675 | 24098675 | |
46697 | 46697 | 1928-01-21 | 7 | c | Truth of the officialdom in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098675 | 24098675 |
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]);