This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47619 | 47619 | 1928-12-01 | 2 | b | Editorial by Tung Wah Times claims that politicians should behave in a moral way. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
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 | |
47624 | 47624 | 1928-12-01 | 2 | d | First cabinet meeting of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47625 | 47625 | 1928-12-01 | 2 | e | He Jian in Hunan province executes key communist figures and the report. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47626 | 47626 | 1928-12-01 | 2 | f | Zhang Xueliang is reluctant to give up Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 |
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]);