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 |
---|---|---|---|---|---|---|---|---|---|
8387 | 8387 | 1901-08-24 | 2 | b-c | A letter from San Francisco reporting that an American scholar is trying to help the Emperor of China to resume power. | America | http://trove.nla.gov.au/newspaper/page/24100144 | 24100144 | |
8393 | 8393 | 1901-08-24 | 2 | d | Former British ambassador to Beijing comments on China issues while in America. | America | http://trove.nla.gov.au/newspaper/page/24100144 | 24100144 | |
8394 | 8394 | 1901-08-24 | 2 | d-e | Three Chinese, Xu Shiqin, Xue Zhongying and Lu Jin'en, were detained on their arrival in San Francisco. The arrest was recommended by Chinese consul He You and Chinese ambassador Wu Tingfang. | America | http://trove.nla.gov.au/newspaper/page/24100144 | 24100144 | |
8400 | 8400 | 1901-08-24 | 3 | b | Situation of Chinese in America and feeling of a little American girl. | America | http://trove.nla.gov.au/newspaper/page/24100143 | 24100143 | |
8403 | 8403 | 1901-08-24 | 3 | c | Tornado and the following disasters in America. | America | http://trove.nla.gov.au/newspaper/page/24100143 | 24100143 | |
8404 | 8404 | 1901-08-24 | 3 | c | Population of the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24100143 | 24100143 |
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]);