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 |
---|---|---|---|---|---|---|---|---|---|
46541 | 46541 | 1927-12-10 | 5 | a | Yang Yuting is against the loans for the railway construction in south Manchuria. Foreigners in Shanghai request to wipe out the Communists. | China | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
46542 | 46542 | 1927-12-10 | 5 | a | Floods in Algeria. | Britain | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
46543 | 46543 | 1927-12-10 | 5 | a | Tram stops in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
46552 | 46552 | 1927-12-10 | 7 | a | Australia news/ New telephone to be used in Sydney. Potato price going up in Sydney. Burglary in the Sydney post office. Dwarf workers on strike in Sydney and the impacts. Dongqiao (Overseas Zengcheng natives) School to be opened in Kowloon, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098627 | 24098627 |
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]);