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 |
|---|---|---|---|---|---|---|---|---|---|
| 14172 | 14172 | 1905-01-21 | 2 | a | Japanese scholar comments on Japan's policies towards China. | Japan | http://trove.nla.gov.au/newspaper/page/26800615 | 26800615 | |
| 14173 | 14173 | 1905-01-21 | 2 | b-c | China to re-organise its navy. China launches new warship in Kobe, Japan. Beiyang navy; navy equipment. Tang Shaoyi is on the way to India for negotiation of Tibet problem. Gentry in Hunan province require to close some public schools. Hunan students in Japan and their involvement of revolutionary activities. Hubei authorities investigate revolutionaries in schools. French ambassador likes to help China raise funds. A young girl in Jiangxi province was kidnapped by a government official for marriage. Railway building in Jiangxi province. Sichuan students in Japan are fighting for ownership of Sichuan railways. Gentry in Fujian province are fighting for ownership of the railways. Zhang Zhidong's proposal for aftermath of the Russo-Japanese War in Manchuria. How Zhang Zhidong celebrates the birthday of Empress Dowager? | China | http://trove.nla.gov.au/newspaper/page/26800615 | 26800615 | |
| 14174 | 14174 | 1905-01-21 | 2 | c-d | Correspondence between Hubei and Guangdong governors on issue of railway lottery. American government comments on the building contract of the Hankou-Guangzhou railway. Some Guangdong students have graduated from Japanese army school and returned. Long Jiguang and his army chase bandits in Guangxi province. Reform of drama performance in Guangdong. Shatou school set up in Guangzhou. Governor Qin Chunxuan refuses suggestion from French ambassador to send troops to Guangxi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800615 | 26800615 | |
| 14175 | 14175 | 1905-01-21 | 3 | a | Recent diplomatic relations between Britain and Germany. | Britain | http://trove.nla.gov.au/newspaper/page/26800614 | 26800614 | |
| 14176 | 14176 | 1905-01-21 | 3 | a | French navy commander declined to help Russia in their war with Japan in Manchurian. | Britain | http://trove.nla.gov.au/newspaper/page/26800614 | 26800614 | |
| 14177 | 14177 | 1905-01-21 | 3 | a | It is faster travelling by train from Tokyo to Seoul. | China | http://trove.nla.gov.au/newspaper/page/26800614 | 26800614 | |
| 14178 | 14178 | 1905-01-21 | 3 | a | French newspaper comments on the war between Russia and Japan in Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/26800614 | 26800614 | |
| 14179 | 14179 | 1905-01-21 | 3 | a | Emperor of Germany awards medal to Russian general for his bravery. | Britain | http://trove.nla.gov.au/newspaper/page/26800614 | 26800614 | |
| 14180 | 14180 | 1905-01-21 | 3 | a-b | Miscellaneous report on the war between Russia and Japan in Manchuria. | Other... | http://trove.nla.gov.au/newspaper/page/26800614 | 26800614 | |
| 14181 | 14181 | 1905-01-21 | Suppl't | a | Short story of a Taoist teacher, Mr Zhang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800616 | 26800616 | |
| 14182 | 14182 | 1905-01-21 | Suppl't | b | Newspaper publishing around the world and number of newspapers in China, Japan and Hong Kong. Coal production in Japan. Navy in different countries. Luxurious imperial palaces around the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800616 | 26800616 | |
| 14183 | 14183 | 1905-01-21 | Suppl't | b | Further report on birthday celebrations in the Sydney Chinese communities for Tang Caizhi's parents and grandparent. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800616 | 26800616 | |
| 14184 | 14184 | 1905-01-21 | Suppl't | b | Japanese envoy to London comments on the "White Australia" policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800616 | 26800616 | |
| 14185 | 14185 | 1905-01-21 | Suppl't | c | Clashes between Russian and Japanese troops in Lushun. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800616 | 26800616 | |
| 14186 | 14186 | 1905-01-21 | Suppl't | c | Tung Wah Times thanks readers who have paid their subscription fee.?Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800616 | 26800616 | |
| 14187 | 14187 | 1905-01-21 | Suppl't | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800616 | 26800616 |
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]);