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 |
---|---|---|---|---|---|---|---|---|---|
18828 | 18828 | 1908-01-25 | 3 | c | Another bomb explosion and assassination attempt in Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801619 | 26801619 | |
18829 | 18829 | 1908-01-25 | 3 | c | American government starts to collect tax on dowry in order to stop American women marrying foreign nobles. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801619 | 26801619 | |
18830 | 18830 | 1908-01-25 | 3 | c | Germany, Russia and Sweden to form an alliance to jointly protect Gulf of Bothnia and Finland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801619 | 26801619 | |
18831 | 18831 | 1908-01-25 | 3 | c | American President Roosevelt approves an increase in naval budget in order to build more warships. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801619 | 26801619 | |
18832 | 18832 | 1908-01-25 | 3 | c | Canadian and Japanese governments agree on Japanese immigrants. | Australia | http://trove.nla.gov.au/newspaper/page/26801619 | 26801619 | |
18833 | 18833 | 1908-01-25 | 3 | c | Japan blocks China's effort to build railway in south Manchuria. | Australia | http://trove.nla.gov.au/newspaper/page/26801619 | 26801619 | |
18834 | 18834 | 1908-01-25 | 3 | c | Japan is preparing for war. | Russia | http://trove.nla.gov.au/newspaper/page/26801619 | 26801619 | |
18840 | 18840 | 1908-01-25 | 6 | c | Report from Japan/ Chinese official Feng Shaotang comments on Japanese administration in Manchuria. Chrysanthemum show in Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/26801624 | 26801624 | |
18853 | 18853 | 1908-01-25 | 7 | c | Timetable of ocean liners.. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801623 | 26801623 | |
18856 | 18856 | 1908-01-25 | 8 | c | Jokes/ Chinese foreign affairs officials are wax figures. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801625 | 26801625 | |
18857 | 18857 | 1908-01-25 | 8 | c | Fable/ Debt to the nether world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801625 | 26801625 |
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]);