This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5767 | 5767 | 1900-07-28 | 3 | a | Li Duanfen, former minister of the Board of Rites, passed away. | China | http://trove.nla.gov.au/newspaper/page/24102889 | 24102889 | |
5768 | 5768 | 1900-07-28 | 3 | a | Chinese troops defeated by British army; foreign countries, after taking over Tianjin, appointed an official to local administration; Li Hongzhang left Shanghai for governorship in Zhili province, no foreigners saw him off. | China | http://trove.nla.gov.au/newspaper/page/24102889 | 24102889 | |
5769 | 5769 | 1900-07-28 | 3 | a | Many houses in the Chinese community of Honolulu were burned to ashes in order to prevent epidemics. Now American government has agreed to make compensation but delayed. | America | http://trove.nla.gov.au/newspaper/page/24102889 | 24102889 | |
5770 | 5770 | 1900-07-28 | 3 | a | Several Chinese in Honolulu were murdered by a group of Japanese. The murderers are still on the run. | America | http://trove.nla.gov.au/newspaper/page/24102889 | 24102889 | |
5771 | 5771 | 1900-07-28 | 3 | b | Chinese shopping district closed for a week in order to prevent the spread of epidemic. | America | http://trove.nla.gov.au/newspaper/page/24102889 | 24102889 | |
5772 | 5772 | 1900-07-28 | 3 | b | Bangladesh depends upon gambling for national revenue. | Other... | http://trove.nla.gov.au/newspaper/page/24102889 | 24102889 | |
5773 | 5773 | 1900-07-28 | 3 | c | Effects of famine in Fujian province relieved following donations from Chinese communities in Nanyang. The management committee of the donations manage official business according to official principles. | China | http://trove.nla.gov.au/newspaper/page/24102889 | 24102889 |
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]);