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 |
---|---|---|---|---|---|---|---|---|---|
6465 | 6465 | 1900-11-21 | 2 | a | Imperial edicts on Boxer rebellions, the retreat to Shanxi, appointment of officials, and others. | China | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 | |
6479 | 6479 | 1900-11-21 | 3 | a | Letter from Guangdong about the current situation there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6480 | 6480 | 1900-11-21 | 3 | a | Horse racing in Melbourne is very profitable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6481 | 6481 | 1900-11-21 | 3 | a | A list of Chinese who donated to a Sydney charity. Names of the people are Zheng Rongzhi, Liu Pei, Liang Tong, Chen Weiman, Chen Jin, Chen Ping, Dong Cheng, Bao Xiang, Li Xiang, Chen Hei, Chen Meiwang, Ding Zao, Chen Lian, Zhong Dai, Ye Fa, Zhang Qi, Zhong Kuan, Zhong Shengyou, He Pei, Liu Gong, Hua Bao, and some shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 | |
6482 | 6482 | 1900-11-21 | 3 | a | American Medical Association in Washington collects bones. The monetary value of the bones differ. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 |
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]);