This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31180 | 31180 | 1916-04-29 | 6 | c | Poems by Tang Jiyao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095248 | 24095248 | |
31182 | 31182 | 1916-04-29 | 7 | c | News about China/ A Chinese cruiser collides with an army ship in the East Sea. The new Chinese cabinet in Beijing under Duan Qirui (Sun Baoqi, Liu Guanxiong and Wang Shizhen). | China | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 | |
31183 | 31183 | 1916-04-29 | 7 | c | More report on the World War I (arms smuggling in Ireland. Chaos in Ireland. Population in Russia and its components). | Other... | http://trove.nla.gov.au/newspaper/page/24095247 | 24095247 |
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]);