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 |
---|---|---|---|---|---|---|---|---|---|
29416 | 29416 | 1914-11-21 | 8 | a-b | A terrorist group detected in Beijing for assassination. Chinese revolutionary rebels in San Francisco. | China | http://trove.nla.gov.au/newspaper/page/24093336 | 24093336 | |
29415 | 29415 | 1914-11-21 | 8 | a | American people on the arbitration treaty between China and the United States. | America | http://trove.nla.gov.au/newspaper/page/24093336 | 24093336 | |
29411 | 29411 | 1914-11-21 | 7 | a | Australia news/ Change of food prices in New South Wales and a survey. German warship that was caught by Australian navy has changed its name. Australian army invents machine gun. Australian federal government permits export of newspapers. Federal government approves increase of telephone price. State premier of New South Wales to welcome the return of Australian warship. A human body found in Darling Harbour with a lot gold. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093333 | 24093333 | |
29408 | 29408 | 1914-11-21 | 3 | d | Beijing news/ President Yuan Shikai is optimistic over the government bonds. Education Minister Tang Hualong seeks to reform education system. Relief work to the flooding victims in Shandong province. Chaos in Yunnan province and the causes. | China | http://trove.nla.gov.au/newspaper/page/24093327 | 24093327 | |
29417 | 29417 | 1914-11-21 | 8 | b | Beijing news/ Yuan Shikai worries about the aftermath of the Qingdao war. Underground religion in Shandong province and the disasters. Villages destroyed in Qingdao. | China | http://trove.nla.gov.au/newspaper/page/24093336 | 24093336 | |
29410 | 29410 | 1914-11-21 | 6 | b-c | Chen Gengru is kidnapped in Xiangshan county, Guangdong, and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24093334 | 24093334 | |
29403 | 29403 | 1914-11-21 | 2 | b | Chinese President Yuan Shikai cares about the banking system. | China | http://trove.nla.gov.au/newspaper/page/24093328 | 24093328 | |
29406 | 29406 | 1914-11-21 | 3 | a-b | Chinese ambassador to Japan Lu Zongyu on the Shandong issues. French newspaper reports Japanese army in Shandong province. | France | http://trove.nla.gov.au/newspaper/page/24093327 | 24093327 | |
29414 | 29414 | 1914-11-21 | 7 | c | Copy of new law issued by Chinese government on the prison management and prison guard. | China | http://trove.nla.gov.au/newspaper/page/24093333 | 24093333 | |
29418 | 29418 | 1914-11-21 | 8 | c | Guangdong news/ Li Guojun is enthusiastic of Confucianism. Provincial authority raises funds for the water conservancy projects. | China | http://trove.nla.gov.au/newspaper/page/24093336 | 24093336 | |
29419 | 29419 | 1914-11-21 | 8 | c | Humorous couplets written by smart pupils in Guangdong on the Second Revolution. | China | http://trove.nla.gov.au/newspaper/page/24093336 | 24093336 | |
29405 | 29405 | 1914-11-21 | 2 | c-d | Japan wants to stop China's neutrality, the protest from Chinese government and reply by Japan. | China | http://trove.nla.gov.au/newspaper/page/24093328 | 24093328 | |
29404 | 29404 | 1914-11-21 | 2 | b-c | Members of the Political Consultative Committee (can zheng yuan) question current Chinese diplomacy and the report. | China | http://trove.nla.gov.au/newspaper/page/24093328 | 24093328 | |
29409 | 29409 | 1914-11-21 | 6 | a-b | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093334 | 24093334 | |
29407 | 29407 | 1914-11-21 | 3 | b-d | Miscellaneous report on the World War I (Turkish army in the war, Germany seeks truce, report by Australian journalists on the war, Qingdao and Shandong issues, and other reports). | Other... | http://trove.nla.gov.au/newspaper/page/24093327 | 24093327 | |
29412 | 29412 | 1914-11-21 | 7 | b-c | Miscellaneous report on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24093333 | 24093333 | |
29402 | 29402 | 1914-11-21 | 2 | a-b | Third part of the editorial on the empire reform (bao huang) and revolutionary (ge ming) movements in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093328 | 24093328 | |
29413 | 29413 | 1914-11-21 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093333 | 24093333 |
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]);