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 |
---|---|---|---|---|---|---|---|---|---|
5728 | 5728 | 1900-07-21 | 2 | f | The first part of a further inquiry into Jing Lianshan's case. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102882 | 24102882 | |
5729 | 5729 | 1900-07-21 | 2 | f | A report on martial arts. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102882 | 24102882 | |
5730 | 5730 | 1900-07-21 | 3 | a | Trouble comes if one does not speak cautiously. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5731 | 5731 | 1900-07-21 | 3 | b | Chinese community in Sydney prepares to celebrate birthday of the Emperor. The committee of celebration includes Li Ruxing, Ouyang Qing, Zheng Fanchang, Wu Jichuan, Chen Shou, Xian Junhao, Li Guanyi, Mei Bing, Miu Dianchen, Wu Yanfan, Ou Bin, Guan Zhuobo, Guo Biao, Chen Lianke, Liang Chuang, Xia Congzhou, He Yao, and Wu Jiaji. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5735 | 5735 | 1900-07-21 | 3 | c | Mail from China awaiting collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5736 | 5736 | 1900-07-21 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 |
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]);