This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23010 | 23010 | 1910-06-25 | 2 | a-b | First part of editorial calls to save and preserve national sovereignty of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802674 | 26802674 | |
23011 | 23011 | 1910-06-25 | 2 | b | Imperial edict on April 1 on the establishment of legislature assembly as the future Lower House. | China | http://trove.nla.gov.au/newspaper/page/26802674 | 26802674 | |
23012 | 23012 | 1910-06-25 | 2-3 | b-a | Miscellaneous report on Prince Zai Tao's visit to America. Photograph of the delegation in San Francisco with local officials, Welcome by the Chinese communities in San Francisco, New York and other cities. | America | http://trove.nla.gov.au/newspaper/page/26802674 | 26802674 |
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]);