This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52660 | 52660 | 1933-03-18 | 2 | e | Luo Wengan and his foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24091156 | 24091156 | |
52667 | 52667 | 1933-03-18 | 5 | e | A woman in Belgium buys insurance for her beautiful breasts. Wu Peifu's poems. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091157 | 24091157 | |
52679 | 52679 | 1933-03-18 | 6 | e | Australia news/ Federal government to reform the tax system. German warships come to visit Australia. The Chinese Society (zhong hua gong hui) sends telegram to the Chinese army in the Rehe front. Chinese man in Sydney arrested for smuggled opium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 |
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]);