This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49633 | 49633 | 1930-11-01 | 2 | d | Miscellaneous report on China on the war of warlords. | China | http://trove.nla.gov.au/newspaper/page/24099830 | 24099830 | |
49638 | 49638 | 1930-11-01 | 3 | d | Disasters of war and floods in east Henan and west Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24099829 | 24099829 | |
49653 | 49653 | 1930-11-01 | 8 | d | Floods in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49654 | 49654 | 1930-11-01 | 8 | d | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49655 | 49655 | 1930-11-01 | 8 | d | Australia news/ Police in Melbourne raid communist offices. Restaurant in King Street, Sydney, is sealed off. Gamblers arrested in Sydney. Earthquake in Sydney. Result of the state election in NSW. Coal miners celebrate the victory of Labour Party. Prices of long distance call between Australia and America. Article written by Ruan Yongchang advises Chinese to live a thrift life. Man on trial in Sydney for murder of his daughter. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 |
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]);