This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36985 | 36985 | 1921-05-14 | 7 | b | Opposition to President Sun Yatsen in Guangzhou (from educational, agricultural and commercial associations in Hunan province, newspapers in Beijing and Shanghai, Hunan provincial governor Zhao Hengti, army in Hunan province, and old parliamentarians in Shanghai). | Other... | http://trove.nla.gov.au/newspaper/page/24093544 | 24093544 |
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]);