This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13540 | 13540 | 1904-07-23 | 2 | a-b | Second and final part of the report on Sun Yatsen's arrival in San Francisco from Honolulu, his passport, customs inspection, his speech and advocation of revolution. Chinese consul general in San Francisco writes to Chinese newspapers there regarding Sun Yatsen. | America | http://trove.nla.gov.au/newspaper/page/26800485 | 26800485 | |
13554 | 13554 | 1904-07-23 | 3 | a-b | Miscellaneous report on the war between Russia and Japan in Manchuria. | Other... | http://trove.nla.gov.au/newspaper/page/26800484 | 26800484 |
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]);