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 |
---|---|---|---|---|---|---|---|---|---|
46214 | 46214 | 1927-09-24 | 5 | a | Japanese ambitions in Manchuria and Mongolia, and protest in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24098537 | 24098537 | |
46215 | 46215 | 1927-09-24 | 5 | a | Hurricane in Japan and the tragedy. | Japan | http://trove.nla.gov.au/newspaper/page/24098537 | 24098537 | |
46216 | 46216 | 1927-09-24 | 5 | a | Heat waves in America. | America | http://trove.nla.gov.au/newspaper/page/24098537 | 24098537 | |
46226 | 46226 | 1927-09-24 | 7 | a | Meeting notice by the Chinese Chamber of Commerce in Sydney on the birthday celebration for Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098539 | 24098539 | |
46227 | 46227 | 1927-09-24 | 7 | a | Australia news/ A white man is sentenced to three years' imprisonment for sexual harassment. Many Italian immigrants arrive Australia. Girl in Sydney suicides for love. Chinese sailor dies while working. Picnic for the birthday celebration of Confucius. Well-known play writer dies in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098539 | 24098539 |
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]);