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 |
---|---|---|---|---|---|---|---|---|---|
10935 | 10935 | 1902-08-23 | 2 | a | An editorial from the editor on the benefits of newspapers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100473 | 24100473 | |
10937 | 10937 | 1902-08-23 | 2 | b | Wang Wenshao to be re-appointed governor of Zhili province; Yuan Shikai supports a Japanese Society in Beijing; electric lights in the Summer Palace; Britain and France to mine in Yunnan province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100473 | 24100473 | |
10939 | 10939 | 1902-08-23 | 2 | b | The Leaning Tower of Pisa is in danger. A picture of the tower. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100473 | 24100473 | |
10941 | 10941 | 1902-08-23 | 3 | a | Chinese businessman in Sydney, Mei Guangda, was robbed in his office and seriously injured. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100474 | 24100474 | |
10945 | 10945 | 1902-08-23 | 5 | a | The Chinese Commercial Association in Sydney, Lin Yik Tong, donated to victims of Wollongong coal mine accident. Representatives from Lin Yik Tong are Mei Guangda, Sun Junchen, Zhou Jin and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
10951 | 10951 | 1902-08-23 | 6 | a | Two pictures of gunboats, in the past and currently. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100475 | 24100475 | |
10954 | 10954 | 1902-08-23 | 6 | b | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100475 | 24100475 | |
10955 | 10955 | 1902-08-23 | 6 | b | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100475 | 24100475 |
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]);