This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26063 | 26063 | 1912-04-27 | 3 | a | British ship sunk | World largest British ship sunk in the Atlantic. | Britain | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26064 | 26064 | 1912-04-27 | 3 | a | Italy-Turkey war still going | Italy-Turkey war still going in Dillepolli (ppp). | Other... | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26065 | 26065 | 1912-04-27 | 3 | a | Soldier rebels in Morocco | Morocco soldier rebels rob French barracks, killing several French soldiers. | Other... | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26066 | 26066 | 1912-04-27 | 3 | b | Fire opens in Tibet | Tibet militiamen open fire on Chinese soldiers in Tibet. Both sides have heavy casualties. | Other... | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26067 | 26067 | 1912-04-27 | 3 | b | Russian princess's marriage | Russian princess' intention to marry Barujia (nnn) prince failed. | Russia | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26068 | 26068 | 1912-04-27 | 3 | b | Current situation in Mexico | American government intends to send a warship to Mexico as their soldiers often attacked by Mexican militiamen. Factional fights between parties for presidency in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26069 | 26069 | 1912-04-27 | 3 | b | Taiwan is to have international agricultural fair | Taiwan is to have international agricultural fair next year. | Japan | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26070 | 26070 | 1912-04-27 | 3 | b | Chen Chunxuan is to be appointed governor of Wuchang | Chen Chunxuan is to be appointed governor of Wuchang as President Yuan calls Li Yuanhong back to Beijing to be chief of army general staff. | China | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26071 | 26071 | 1912-04-27 | 3 | b | Beijing city walls said to be demolished | Beijing city walls said to be demolished. Foreign companies try to involve in demolishment project. | China | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26072 | 26072 | 1912-04-27 | 3 | b-c | Beijing news | Temporary President Yuan issues notice about his inauguration. President Yuan orders to follow old law and regulations unless against republic. President Yuan orders to abolish some taxes on farmers. Vice president Li's trip to Nanjing cancelled. Member of United Party Chen Xuelou at the moment does not intend to engage in politics. Anti-governor movement in Jiangxi. Structure of new cabinet. Germany installs several canons at the gate of its embassy to Beijing. Japan intends to protect Chinese imperial family. Empress Dowager is not happy with his royalists in Shaanxi against republic. | Other... | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
26073 | 26073 | 1912-04-27 | 3 | c-d | Guangdong news | Guangdong government discusses haddling of soldier rebels' aftermath. Foreigners in Guangdong have meeting about how to cope with chaos development in Guangdong. Nanjing garrison commander said to be appointed governor of Guangdong and Guangxi. Huang Xing said to come to Guangdong. Guangdong-Wuhan railway is to start construction soon. Soldier is robbed on street. Gangsters active in Deqing county. | Other... | http://trove.nla.gov.au/newspaper/page/24092215 | 24092215 |
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]);