This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25868 | 25868 | 1912-03-16 | 3 | a | Beijing mutiny | Riot in Beijing results from mutiny. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25869 | 25869 | 1912-03-16 | 3 | a | Italian navy chief dies | Italian navy chief dies. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25870 | 25870 | 1912-03-16 | 3 | a | Italian excellent weapons | Italian excellent weapons of aircraft bombs. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25871 | 25871 | 1912-03-16 | 3 | a | Riot in Mexico | Revolutionaries vows riot and killing of foreigners in Mexico if America intervenes Mexico affairs. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25872 | 25872 | 1912-03-16 | 3 | b | British women's riot | British women still making troubles on street for their elction right. | Britain | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25873 | 25873 | 1912-03-16 | 3 | b | British miners on strike | British miners have another strike. | Britain | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25874 | 25874 | 1912-03-16 | 3 | b | Norwegian team reaches the south pole | Norwegian expeditionary team reaches the south pole. | Britain | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25875 | 25875 | 1912-03-16 | 3 | b | Recent world happenings | Norwegian women win their election right. Italy illegally detain red cross members. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25876 | 25876 | 1912-03-16 | 3 | b-c | Beijing news | Republic upper house holds meeting. President Sun willing to hand over presidency to Yuan Shikai for peaceful transition. Manchu aristocrats once secretly discussed about getting rid of Yuan Shikai. President Sun tries to win foreign countries's recognition of his republic. Number of army in the north recognising republic. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25877 | 25877 | 1912-03-16 | 3 | c-d | Guangdong news | Various organisations recommend Sun Mei as Guangdong governor. Drug smoking ban bureau still no pratical ways to stop drug smoking. Zhaoqing county security committee set up. Guangdong and Guangxi jointly control Xijiang River. Missionary shot down by gangsters. Blood appeal for overthrow of Qing government. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
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]);