This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18608 | 18608 | 1907-12-14 | 3 | a-b | A student in Guangzhou is drowned to death while visiting a prostitute. Hu Xianglin might be appointed imperial commissioner of Guangxi province. Local unscrupulous merchant in Panyu county collaborate with French businessman to exploit mining resources. Chinese central government in Beijing urges Guangdong and other local authorities to capture all revolutionaries. Guangdong agricultural authority encourages development following local conditions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18609 | 18609 | 1907-12-14 | 3 | b | More than 20 Russian officers and soldiers are executed for leading a revolt in Hunchun, on the border with China. | Britain | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18610 | 18610 | 1907-12-14 | 3 | b | Report on the anti-German riots in Poland. | Australia | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18611 | 18611 | 1907-12-14 | 3 | b | Royal Navy of Britain will build a big naval port in Lybster, Scotland. | Australia | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18612 | 18612 | 1907-12-14 | 3 | b | President Roosevelt of the United States delivers a long speech to the parliament. | Australia | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18613 | 18613 | 1907-12-14 | 3 | b | Japanese ambassador to Washington returns to discuss with his government immigration issue. | Australia | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18614 | 18614 | 1907-12-14 | 3 | b-c | A woman in Moscow tries to assassinate governor of the city. Comments by Tung Wah Times. | Australia | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18615 | 18615 | 1907-12-14 | 3 | c | German colonies in Africa and the railway building. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18616 | 18616 | 1907-12-14 | 3 | c | Fruit grower in California asks American government to relax its restrictions upon Chinese and Japanese immigrants. | America | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18617 | 18617 | 1907-12-14 | 3 | c | King of Sweden, Oscar II, dies. His son Gustav V is now king. | Australia | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18618 | 18618 | 1907-12-14 | 3 | c-d | Travel notes on the Netherlands. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
18619 | 18619 | 1907-12-14 | 3 | d | Around the world. Facts about India (territory, cities, villages, housing, and population). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 |
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]);