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 |
---|---|---|---|---|---|---|---|---|---|
46665 | 46665 | 1928-01-14 | 5 | a | Cold winter in America. | America | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46666 | 46666 | 1928-01-14 | 5 | a | Jiang Jieshi is back to office. Feng Yuxiang's army besiege Weihui, of Henan province. Chinese government to renew treaties with Italy and Portugal. Bandits killed by police in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46667 | 46667 | 1928-01-14 | 5 | a | Floods in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46673 | 46673 | 1928-01-14 | 7 | a | The sign of Red Cross in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098667 | 24098667 | |
46674 | 46674 | 1928-01-14 | 7 | a | Australia news/ British woman is deported from Sydney because she comes from China. Western visitor on the Communist disaster in China. Chinese businessman Lei Peng exports Australian dry fruits into China. Grain supply to the British troops in China. The Webster's Company in Brisbane on blaze. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098667 | 24098667 |
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]);