This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54465 | 54465 | 1934-09-01 | 2 | a | Editorial on the relations between Guangzhou and Nanjing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096142 | 24096142 | |
54481 | 54481 | 1934-09-01 | 6 | e | Australia news/ Visitor to the East talks about the business there. Chinese man detained in Darwin for opium smuggling. Foreign lotteries are not permitted to sell in Sydney. St Mary Church is burgled in Sydney. Chinese magician Huang Caixin and his performance in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 |
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]);