This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52215 | 52215 | 1932-11-19 | 5 | a | Fourth and final part of abstract of the report prepared by delegation of the League of Nations on the future of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091026 | 24091026 | |
52216 | 52216 | 1932-11-19 | 5 | d | The Chinese communities in the United States of America organise memorial gathering for the martyrs killed during the resistance to Japanese invasion of Shanghai and selection of the couplets. | America | http://trove.nla.gov.au/newspaper/page/24091026 | 24091026 | |
52217 | 52217 | 1932-11-19 | 5 | e | Notice issued by the Chinese consulate in New Zealand on the ban for Chinese from employing white women employees, responses of the Chinese communities on the ban, and negotiations between Chinese representatives and New Zealand authorities. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091026 | 24091026 |
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]);