This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24541 | 24541 | 1911-05-20 | 3 | a | Drug-smoking ban treaty extended | The drug-smoking ban treaty is extended for another seven years. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24542 | 24542 | 1911-05-20 | 3 | a | Fire in Jiling | A big fire disaster happened in Jiling. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24543 | 24543 | 1911-05-20 | 3 | a | Call for revising entry ban on Chinese | Chinese business association call for American government to revise its entry ban on Chinese. | America | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24544 | 24544 | 1911-05-20 | 3 | a | Foreign loans for building railways | Chinese government proposes more loans for building its railways. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24545 | 24545 | 1911-05-20 | 3 | a | Revolutionary party in action | Sun Wen prepares several revolutionary actions around Yangtze river area. | Japan | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24546 | 24546 | 1911-05-20 | 3 | a | Theatre burned down | A theatre in London was burned down. | Britain | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24547 | 24547 | 1911-05-20 | 3 | a | Canada allows a railway in China | Canadian government has approved to build a railway in North China. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24548 | 24548 | 1911-05-20 | 3 | a | Riots in Mexico | Riots happen in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24549 | 24549 | 1911-05-20 | 3 | a | A huge ship will be built | A huge ship will be built. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24550 | 24550 | 1911-05-20 | 3 | a-b | American donations to China | American Red Cross donates more than thousand pounds to China for its famines. | Britain | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24551 | 24551 | 1911-05-20 | 3 | b | Statement of Persian Regent | The Persian regent issued his statement for stopping factional fights. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24552 | 24552 | 1911-05-20 | 3 | b | Japan-German relations | Japan has recovered its relations with Germany. | Japan | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24553 | 24553 | 1911-05-20 | 3 | b | Big changes in diplomacy in Europe | Big changes in diplomacy have taken in Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24554 | 24554 | 1911-05-20 | 3 | b | China's acting consul general to Australia | The appointment of China's acting consul general to Australia is approved. | Other... | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24555 | 24555 | 1911-05-20 | 3 | d | Beijing news | Li Jingman has been promoted. The transition from old cabinet to new cabinet. Government asks for military reserve funds. Zhen Beizi and his delegation set for British coronation. Hu Xinwu may be promoted. Commander-in-chief of three provinces of north China proposes a new appointment of army chairman for the three provinces. Governor of north China asks for actions to deal with Russia and Japan. A senior official still smokes drugs. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24556 | 24556 | 1911-05-20 | 3 | c-d | Guangdong news | Governor inspects Nanqiang School. Guangdong government asks for Beijing's approval to turn Yulin Island into a military base. Dealing with Yishanyuan bank. New policy for passports. Governor approved for air craft flying experiment. A rich family's house has been rent for gambling. Xiangshan has set up a workers' union. | China | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
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]);