This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34251 | 34251 | 1919-03-08 | 6 | b-c | Japan is not satisfied with the international peace treaty submitted to the Paris peace conference. | America | http://trove.nla.gov.au/newspaper/page/24097642 | 24097642 | |
34260 | 34260 | 1919-03-08 | 8 | b-c | Guangdong news/ Acting provincial governor Zhai Wang on the rice price. French president awards medal to Tang Jiyao. Shen Peizheng and Wei Zhaowen divorce. Chamber of Commerce in Luoding county complains the Commissioner for stamp duty. | China | http://trove.nla.gov.au/newspaper/page/24097644 | 24097644 |
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]);