This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47396 | 47396 | 1928-09-08 | 2 | b | Second part of the speech by Dr Chen Huanzhang in San Francisco on the quintessence of Confucianism. | America | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47397 | 47397 | 1928-09-08 | 2 | c | Song Ziwen in Beijing and the British inspector general of the Chinese Maritime Customs Bureau. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47398 | 47398 | 1928-09-08 | 2 | c | Li Zongren, Wu Zhihui, Dai Jitao and others attack foreign minister Wang Zhengting. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47399 | 47399 | 1928-09-08 | 2 | c | On behalf of the Nanjing government, Song Ziwen signs tariff agreement with American government. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47400 | 47400 | 1928-09-08 | 2 | d | Resolutions passed by the Central Executive Committee meeting of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47401 | 47401 | 1928-09-08 | 2 | d | American government sends ultimate to the Nanjing authority. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47402 | 47402 | 1928-09-08 | 2 | e | Zhang Zongchang leads his troops to dig graves of the Qing Dynasty for treasures. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47403 | 47403 | 1928-09-08 | 2 | e | Delegates from Sichuan and Tibet on the local administration. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47404 | 47404 | 1928-09-08 | 2 | e | The assassination of Yang Zengxin. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47405 | 47405 | 1928-09-08 | 2 | f | The Nanjing authority on the revision of treaties with Japan. | China | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 |
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]);