This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50452 | 50452 | 1931-06-27 | 8 | b | Bandits in Shanghai and the robbery. | China | http://trove.nla.gov.au/newspaper/page/24090435 | 24090435 | |
50453 | 50453 | 1931-06-27 | 8 | b | American president on the debts of war. | America | http://trove.nla.gov.au/newspaper/page/24090435 | 24090435 | |
50454 | 50454 | 1931-06-27 | 8 | c | Australia news/ Sydney hospitals to issue lottery to raise funds. Tax of personal income may increase. Bandits arrested for robbery of train. Fighting in Sydney between police and the communist members. Earthquake in New Zealand. Heavy rains block traffic in Sydney. Proposal to collect car levy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090435 | 24090435 | |
50455 | 50455 | 1931-06-27 | 8 | e | Notice issued by the Chinese Consulate-General in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090435 | 24090435 | |
50456 | 50456 | 1931-06-27 | 8 | f | Market price in Sydney for vegetables, fruits, meats, poultry and other local products. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090435 | 24090435 |
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]);