This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39026 | 39026 | 1922-11-18 | 3 | f | A theatre in Switzerland is burned to ashes. | Other... | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39039 | 39039 | 1922-11-18 | 7 | c | News in brief/ Zhao Hengti urges Li Yuanhong to draft the state constitution. Hanyang ammunition factory provides weapons to Sa Zhenbing. Wu Peifu tries to wipe out Zhang Wensheng. Du Xigui dispatches gunboats to Fujian. Wu Jinglian, Cao Rui and Li Yuanhong. | Other... | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 |
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]);