This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52452 | 52452 | 1933-01-28 | 2 | b | Editorial by the Tung Wah Times on the Rehe issues and the motive of Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
52471 | 52471 | 1933-01-28 | 5 | e | Amorous poems found in the government offices in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
52482 | 52482 | 1933-01-28 | 8 | e | Australia news/ Young Chinese man is arrested in Sydney for using counterfeit bank notes. China purchase Australian flour. Australian export to China increase dramatically. Young man in Sydney is charged with murder. A declaration issued by the Sydney Chinese Saving China Association on the anniversary of the 1.28 Incident of Shanghai. Smallpox discovered on aboard of the passenger liner Taiping. Australian naval officer talks in Melbourne about Japanese aggressive policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 |
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]);