This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 15610 | 15610 | 1906-04-28 | 2 | a | San Francisco and its history, business, gold mining, education, and many others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 | |
| 15611 | 15611 | 1906-04-28 | 2 | a-b | Chronology of earthquakes (and statistics of casualties) in the world from 742 to 1899. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 | |
| 15612 | 15612 | 1906-04-28 | 2 | b | Tour of the three Chinese officials in the United States for an investigation on political reform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 | |
| 15613 | 15613 | 1906-04-28 | 2 | b-d | Police headquarters in Beijing suggests setting up medical study association. German navy commander tells the parliament that fortifications in Jiaozhou, Shandong province, need reinforced for possible future chaos in China. Army training office in Beijing is considering to set up military band. An employee of the Board of Commerce reports forestation in Zhili province and business in Fengtian. Foreign media comments removal of Li Lianying from the imperial court. Board of Commerce had drafted a new law for newspaper publishing. British consul and the negotiation over with Chinese authorities for the missionary case in Nanchang county, Jiangxi province. A French missionary in Yunnan province kills ordinary people in broad daylight and bullies others. | China | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 | |
| 15614 | 15614 | 1906-04-28 | 2-3 | d-a | Detailed report on the earthquake in San Francisco and the casualties. | Other... | http://trove.nla.gov.au/newspaper/page/26800963 | 26800963 | |
| 15615 | 15615 | 1906-04-28 | 3 | b | Earthquake in San Francisco and casualties of the Chinese community. Sydney Chinese community sends telegram to their Chinese fellows in San Francisco to inquire about casualties in the earthquake. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800962 | 26800962 | |
| 15616 | 15616 | 1906-04-28 | 3 | b | Germany seeks to set up a base in the far east. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800962 | 26800962 | |
| 15617 | 15617 | 1906-04-28 | 3 | b | Imperial commissioner of Jiangxi province Hu Tinggan has been removed from his post for mismanagement of the missionary case in Nanchang county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800962 | 26800962 | |
| 15618 | 15618 | 1906-04-28 | 3 | b | A Russian newspaper says Britain and Russia should have good relationship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800962 | 26800962 | |
| 15619 | 15619 | 1906-04-28 | 3 | b | British colony in South Africa sees another rebellion and response from British authority. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800962 | 26800962 | |
| 15620 | 15620 | 1906-04-28 | 3 | b | Coal miners in France are still on strike. Response from the government authorities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800962 | 26800962 | |
| 15621 | 15621 | 1906-04-28 | 3 | b | British government decides to send more troops to Egypt. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800962 | 26800962 | |
| 15622 | 15622 | 1906-04-28 | 3 | b | Boycott does not influence America's trade with China, and statistics of the Sino-American trade from 1904 to 1905. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800962 | 26800962 | |
| 15623 | 15623 | 1906-04-28 | 5 | a | Third part of the report on Chinese consul to Mexico Liang Xun who is keen to win promotion and get rich, his comments on Kang Youwei and others, and his relationship with local Chinese communities there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800967 | 26800967 | |
| 15624 | 15624 | 1906-04-28 | 5 | b | Chinese communities in Australia purchase, with enthusiasm, shares of the Hankou-Guangzhou railway. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800967 | 26800967 | |
| 15625 | 15625 | 1906-04-28 | 5 | b | A call from Lin's clan in Xiangshan county, Guangdong, for donations to a clan/community school in their home town. Names of the Lin's family clan in Sydney listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800967 | 26800967 | |
| 15626 | 15626 | 1906-04-28 | 6 | a | Lu Huayue writes to the Tung Wah Times suggesting necessary precautions to prevent opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800964 | 26800964 | |
| 15627 | 15627 | 1906-04-28 | 6 | a | First part of a novel about a concubine with cruel fate. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800964 | 26800964 | |
| 15628 | 15628 | 1906-04-28 | 6 | b | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800964 | 26800964 | |
| 15629 | 15629 | 1906-04-28 | 6 | b | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800964 | 26800964 |
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]);