This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53126 | 53126 | 1933-07-29 | 5 | a | Poems by Yang Xingfo who is assassinated in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091311 | 24091311 | |
53127 | 53127 | 1933-07-29 | 5 | c | Poems on the freedom of love. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091311 | 24091311 | |
53128 | 53128 | 1933-07-29 | 5 | d | Ministry of Education in Nanjing has agreed to register the Chinese School in Melbourne. And a notice by Liu Puyun, principal of the Melbourne Chinese School. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091311 | 24091311 | |
53129 | 53129 | 1933-07-29 | 5 | e | Sydney Chinese Saving China Association writes respectively to the authorities in Nanjing and the Guangdong. Donations from the Chinese communities in Auckland and Melbourne to the war of resistance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091311 | 24091311 |
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]);