This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53603 | 53603 | 1933-12-02 | 2 | f | Kong Xianrong returns to Jilin. | China | http://trove.nla.gov.au/newspaper/page/24091455 | 24091455 | |
53604 | 53604 | 1933-12-02 | 2 | f | Lin Sen returns to Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091455 | 24091455 | |
53605 | 53605 | 1933-12-02 | 2 | f | Ma Hongkui resigns. | China | http://trove.nla.gov.au/newspaper/page/24091455 | 24091455 | |
53606 | 53606 | 1933-12-02 | 2 | f | Li Zeyi arrives Nagasaki. | China | http://trove.nla.gov.au/newspaper/page/24091455 | 24091455 | |
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 | |
53627 | 53627 | 1933-12-02 | 6 | f | Australia news/ New regulations of wage taxes. Australian women permitted to marry foreigners and remain Australian citizens. Liner Taiping changes its timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091459 | 24091459 | |
53628 | 53628 | 1933-12-02 | 6 | f | A notice issued by the Chinese Chamber of Commerce in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091459 | 24091459 |
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]);