This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33980 | 33980 | 1919-01-11 | 2 | c | Xu Shichang sends telegram to Tang Shaoyi which urges him to come out for peace, and Tang Shaoyi's reply. | China | http://trove.nla.gov.au/newspaper/page/24097567 | 24097567 | |
33985 | 33985 | 1919-01-11 | 3 | c | The election in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24097566 | 24097566 | |
33996 | 33996 | 1919-01-11 | 7 | c | Leaders from the south and the north in China are all ready for peace talks. Russian employ Chinese for looting. Chinese government deports German nationals. Japanese suggest an alliance with China. | Britain | http://trove.nla.gov.au/newspaper/page/24097570 | 24097570 | |
33997 | 33997 | 1919-01-11 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097570 | 24097570 | |
33998 | 33998 | 1919-01-11 | 7 | c | A Chinese gardener in Tamworth, New South Wales, offers rewards in the capture of the arsonist. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097570 | 24097570 |
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]);