This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34351 | 34351 | 1919-04-05 | 3 | e | Report from London on the Paris peace conference. | Britain | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 | |
34352 | 34352 | 1919-04-05 | 3 | e | Report from the Paris Peace Conference/ League of the Nations. George Morrison at the conference and the Qingdao issues. Canadian and American governments report their loss. Amount of indemnity that Germany required to repay. Hungarian delegation at the conference. Australian delegation at the conference. | France | http://trove.nla.gov.au/newspaper/page/24097669 | 24097669 |
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]);