This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47368 | 47368 | 1928-08-25 | 8 | a | American government on the recent negotiation between China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47369 | 47369 | 1928-08-25 | 8 | a | Treasures stolen from the Forbidden City are detained in Tianjin before transported overseas. | China | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47370 | 47370 | 1928-08-25 | 8 | a | White Russian soldiers under Zhang Zongchang become POWs of the Nationalist troops. | China | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47371 | 47371 | 1928-08-25 | 8 | b | Jiang Jieshi on the development of naval forces. | China | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47372 | 47372 | 1928-08-25 | 8 | b | A group of American archaeologists return to Beiping after a field research in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47373 | 47373 | 1928-08-25 | 8 | b | Fengtian forces under Zhang Xueliang may seek cooperation with the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47374 | 47374 | 1928-08-25 | 8 | b | Riots in Manchuria in protest against Japan | Japan | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47375 | 47375 | 1928-08-25 | 8 | c | Australia news/ Storm in Tahiti. Chinese Consul-General Wei Zijing is returning for holiday and the new consul Wu Qinfen takes office. The Pacific women's conference in Hawaii and women's rights. Pensions increases for families to the servicemen who died in the Europe war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47376 | 47376 | 1928-08-25 | 8 | d | A notice by the Chinese Chamber of Commerce in New South Wales soliciting contributions on the National Day of October 10 and the birthday celebration for Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 |
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]);