This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13653 | 13653 | 1904-08-13 | 2 | b | Sydney Chinese community sends a telegram to Beijing on the birthday of Emperor Guangxu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13654 | 13654 | 1904-08-13 | 2 | b | Chinese community in Sydney on holiday in order to celebrate the birthday of Emperor Guangxu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13655 | 13655 | 1904-08-13 | 2 | b | Report on the coordination and training of the army in China. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13656 | 13656 | 1904-08-13 | 2 | b | Two barbarous teachers in Beijing beat their students. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13657 | 13657 | 1904-08-13 | 2 | b | Imperial scholar Xie Xiquan provides advice for army training in China. | China | http://trove.nla.gov.au/newspaper/page/26800500 | 26800500 | |
13673 | 13673 | 1904-08-13 | Suppl't | b | Secrets of a long life, selected from an English book. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800501 | 26800501 | |
13674 | 13674 | 1904-08-13 | Suppl't | b | Report on the trial of a bandit in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800501 | 26800501 | |
13675 | 13675 | 1904-08-13 | Suppl't | b | Qin Chunxuan, governor of Guangdong, orders his officials to quit smoking. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800501 | 26800501 | |
13676 | 13676 | 1904-08-13 | Suppl't | b | America's view on what China would be like after the Russo-Japanese War. | America | http://trove.nla.gov.au/newspaper/page/26800501 | 26800501 |
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]);