This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13139 | 13139 | 1904-05-07 | 2 | a | Third part of the article, selected from a Hong Kong newspaper, commenting on China's history and cultural tradition. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800430 | 26800430 | |
13166 | 13166 | 1904-05-07 | 3 | a | List of Japanese army commanders in the Russo-Japanese War. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800429 | 26800429 | |
13167 | 13167 | 1904-05-07 | 3 | a | Number of donations to Japanese army from Yokohama, Honolulu, San Francisco, New York, Beijing, and other cities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800429 | 26800429 | |
13169 | 13169 | 1904-05-07 | Suppl't | a | Report on different nationalities, religions and regions in Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800431 | 26800431 | |
13170 | 13170 | 1904-05-07 | Suppl't | a | Report on overseas Chinese students. Chinese students Luo Chang in Oxford University, London. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800431 | 26800431 | |
13171 | 13171 | 1904-05-07 | Suppl't | a | Report on Chinese students in San Francisco. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800431 | 26800431 | |
13172 | 13172 | 1904-05-07 | Suppl't | a | Report on the temple in Sydney built by fellows coming from Gaoyao county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800431 | 26800431 |
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]);