This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15273 | 15273 | 1906-01-20 | 2 | b | Photograph of Miss Marie Campbell, a start of "Sinbad the Sailor". | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800883 | 26800883 | |
15278 | 15278 | 1906-01-20 | 3 | b | Germany has been preparing for war since the Morocco negotiation failed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15279 | 15279 | 1906-01-20 | 3 | b | A secret treaty between China and Japan on the railway in Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15280 | 15280 | 1906-01-20 | 3 | b | Jinan, capital of Shandong province, has been opened for international trade. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15281 | 15281 | 1906-01-20 | 3 | b | Japan is building an ironclad warship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15282 | 15282 | 1906-01-20 | 3 | b | Britain sends special envoy to congratulate Japan for their victory of the Russo-Japanese War. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15283 | 15283 | 1906-01-20 | 3 | b | Japan welcomes its hero returning from Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15284 | 15284 | 1906-01-20 | 3 | b | Gold production in Taiwan and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15285 | 15285 | 1906-01-20 | 3 | b | Salary of the Emperor of Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15286 | 15286 | 1906-01-20 | 3 | b | American government to build house for new Chinese arrivals. Number of Chinese in the United States in 1900 and 1890. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15287 | 15287 | 1906-01-20 | 3 | b | Navy of the United States has new warship for China and the Philippines. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15288 | 15288 | 1906-01-20 | 3 | b | Number of Chinese in the international concessions of Shanghai and their original provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800882 | 26800882 | |
15294 | 15294 | 1906-01-20 | 6 | b | Liang Cheng, a Chinese carpenter on a Hong Kong liner, is charged with murdering another Chinese fellow and throwing his body into ocean near Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800884 | 26800884 | |
15295 | 15295 | 1906-01-20 | 6 | b | Tung Wah Times thanks readers who have paid their subscription fees. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800884 | 26800884 | |
15296 | 15296 | 1906-01-20 | 6 | b | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800884 | 26800884 |
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]);