This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50888 | 50888 | 1931-11-21 | 2 | b | Comments selected from a Shanghai newspaper on the unity of the whole nation to fight Japanese invader. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090605 | 24090605 | |
50894 | 50894 | 1931-11-21 | 5 | e | Chinese communities in Sydney gather and mourn the countrymen killed by Japanese troops in Manchuria. Chinese Chamber of Commerce and the zhi gong tang in Sydney farewell former Chinese consul-general Guizhi, Liu Guangfu and his wife on their departure for China, and speakers include Zhu Songqing, Huang Zhu, Ye Bingnan, Wu Gen, Ma Xinsi, Huang Guangzhao, Liang Bai, Guo Jianying, Zhang Fuxiang, Liu Guangfu and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090606 | 24090606 | |
50895 | 50895 | 1931-11-21 | 6 | b | Names listed for donations to the Sydney Chinese Association to Fight Japan and to Save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090609 | 24090609 | |
50897 | 50897 | 1931-11-21 | 7 | a | Chinese communities in America, Canada and Mexico issued condemnation on Japanese invasion of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090608 | 24090608 | |
50898 | 50898 | 1931-11-21 | 7 | d | Chinese communities in Melbourne donate to the Saving China Military Funds and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090608 | 24090608 |
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]);