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 |
---|---|---|---|---|---|---|---|---|---|
55293 | 55293 | 1935-07-27 | 5 | c | Comments written by Gu Dezhong on the Republic of China in the past 24 years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096514 | 24096514 | |
55294 | 55294 | 1935-07-27 | 5 | e | Chinese communities in Sydney donate to the establishment of Hanchi Hospital and its nurse school. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096514 | 24096514 | |
55304 | 55304 | 1935-07-27 | 8 | f | Australia news/ Celebrations in Sydney for the 150th anniversary of the city. Queensland may restrict banana growing. Japanese man is on trial in Sydney for drug smuggling. Bandits in Sydney rob jewellery shop. Sand storm in South Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 |
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]);