This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15816 | 15816 | 1906-06-23 | 3 | a | British navy to have an exercise soon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15817 | 15817 | 1906-06-23 | 3 | a | A huge shipyard in Baltimore of the United States burned to ashes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15818 | 15818 | 1906-06-23 | 3 | a | Austrian foreign minister hopes that friendship between Germany, Italy and Austria will last forever. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15819 | 15819 | 1906-06-23 | 3 | a | British parliament urges the Prime Minister to send Chinese labourers home from south African mines. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15820 | 15820 | 1906-06-23 | 3 | a | Five British soldiers and officers are beaten in an Egyptian village after looting the area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15821 | 15821 | 1906-06-23 | 3 | b | Farmers are on strike in central Russia and the Black Sea area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15822 | 15822 | 1906-06-23 | 3 | b | Case report on Jew-baiting and anti-semitism in Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15823 | 15823 | 1906-06-23 | 3 | b | Russian dictatorship in crisis. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15824 | 15824 | 1906-06-23 | 3 | b | Many rich men in the United States are generous in donating to charities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15825 | 15825 | 1906-06-23 | 3 | b | Japanese government issues the budget for next financial year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 | |
15826 | 15826 | 1906-06-23 | 3 | b | A special notice from Tung Wah Times to the readers in Mexico and United States on the issue of subscription fee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801010 | 26801010 |
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]);