This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53613 | 53613 | 1933-12-02 | 5 | a | Japanese to unify administration of the railways in Manchuria and Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24091456 | 24091456 | |
53614 | 53614 | 1933-12-02 | 5 | c | Writings by He Yingqin and Cai Yuanpei in praise of martyrs killed during the resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091456 | 24091456 | |
53615 | 53615 | 1933-12-02 | 5 | e | Bandits in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091456 | 24091456 | |
53616 | 53616 | 1933-12-02 | 5 | e | Nanchang municipal authority in Jiangxi rebuild the Confucian temple. | China | http://trove.nla.gov.au/newspaper/page/24091456 | 24091456 | |
53617 | 53617 | 1933-12-02 | 5 | f | Notice jointly issued by the Dongguan gong yi tang, Zengcheng lian fu tang, Gaoming hong fu tang, See Yip Society and other Chinese associations in praise of the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091456 | 24091456 |
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]);