This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51769 | 51769 | 1932-08-06 | 2 | f | Japanese seek recognition from American government of the Manchuria state. | America | http://trove.nla.gov.au/newspaper/page/24090896 | 24090896 | |
51791 | 51791 | 1932-08-06 | 8 | f | Australia news/ China man in Sydney hangs himself. Police in Sydney arrest the communists. Visitor talks about China in Sydney after his return from Hong Kong. Chinese man on trial in Sydney for the death of a white man. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 |
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]);