This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10810 | 10810 | 1902-06-11 | 2 | c-d | Further comments on Cai Jun's letter. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100453 | 24100453 | |
10824 | 10824 | 1902-06-11 | 2 | f | A secular monk of Guangdong and his story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100453 | 24100453 | |
10826 | 10826 | 1902-06-11 | 3 | a | Three prisoners in Guangzhou wish to be beheaded rather than dying in the convict's cage. Their wish was granted by Li Hongzhang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10830 | 10830 | 1902-06-11 | 3 | b | Several items of report on Western customs and society. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10834 | 10834 | 1902-06-11 | 3 | d | Statistics of Chinese population in New South Wales, ratio of men and women, number born in Australia, other population details.. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10837 | 10837 | 1902-06-11 | 3 | e | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10838 | 10838 | 1902-06-11 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 |
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]);