This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47302 | 47302 | 1928-08-04 | 8 | a | Riots in Yantai, of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
47303 | 47303 | 1928-08-04 | 8 | a | Marine insurance companies in Britain refuse to Chinese clients. | Britain | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
47304 | 47304 | 1928-08-04 | 8 | a | Strike in India and the report. | Other... | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
47305 | 47305 | 1928-08-04 | 8 | a | Bandits rob shops in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
47306 | 47306 | 1928-08-04 | 8 | a | Dog racing in Shanghai. American government may recognise the Chinese tariff autonomy. | China | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
47307 | 47307 | 1928-08-04 | 8 | b | Australia news/ Japanese purchase iron resources from Australia. Drunken men and women are detained in Sydney. Train derails in Queensland. A letter from the Chinese Chamber of Commerce in New South Wales to the Sydney city council on the vegetable booths, and the letter is signed by Liu Guangfu and Charlie Deng. Unemployment in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 |
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]);