This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13121 | 13121 | 1904-04-30 | 3 | a | Miscellaneous report on the Russo-Japanese War. | Other... | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 | |
13122 | 13122 | 1904-04-30 | 3 | a | Report on the suffering of Polish people. | Australia | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 | |
13123 | 13123 | 1904-04-30 | 3 | a | Mines in south Africa will employ around 200,000 Chinese labourers. | Britain | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 | |
13124 | 13124 | 1904-04-30 | 3 | b | China decides to move an arsenal from Shanghai to Wuhu in Anhui province. | Britain | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 | |
13125 | 13125 | 1904-04-30 | 3 | b | Chinese community in Townsville donates to Japanese servicemen and their families. A letter from the Chinese community there to the Tung Wah Times. About 50 names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 | |
13126 | 13126 | 1904-04-30 | 3 | b | Chinese community in Perth, Western Australia, donates to Japanese servicemen and their families. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 | |
13127 | 13127 | 1904-04-30 | 3 | b | Donations to the Longdu School in Xiangshan county, Guangdong. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 | |
13128 | 13128 | 1904-04-30 | 3 | b | Raffle tickets now on sale in Melbourne and the money will be used to help hospitals. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 | |
13129 | 13129 | 1904-04-30 | 3 | b | A reformist newspaper has been established in New York. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800424 | 26800424 |
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]);