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 |
---|---|---|---|---|---|---|---|---|---|
47620 | 47620 | 1928-12-01 | 2 | c | Jilin may declare independence. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47621 | 47621 | 1928-12-01 | 2 | c | The Nanjing government to borrow foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47622 | 47622 | 1928-12-01 | 2 | c | Bandits and thieves in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47623 | 47623 | 1928-12-01 | 2 | c | Zhang Xueliang to return some vehicles to the south. Zhang Xueliang escapes an assassination. Press censorship in Shanghai. Situation changes suddenly in Shandong. Talks halt between China and Portugal on the treaty review. Others news from China. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47628 | 47628 | 1928-12-01 | 3 | c | Taixu Master of the Law delivers Buddhist speeches in France and the report. | France | http://trove.nla.gov.au/newspaper/page/24099033 | 24099033 |
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]);