This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47025 | 47025 | 1928-05-12 | 5 | a | Hong Kong news/ Another private bank collapses. Prince of Japan might visit Guangzhou. Report on English newspaper on the arrival of Japanese warships. Special police forces are being trained in order to eliminate the Communist members. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098803 | 24098803 |
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]);