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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 |
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]);