This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24220 | 24220 | 1911-01-28 | 3 | a | A special memorial to the Emperor | Zi Zheng Yuan (State Council) prepared a special memorial to the Emperor about the responsible cabinet and the Emperor's office. | China | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24221 | 24221 | 1911-01-28 | 3 | a | The population of Austria | The population of Austria has increased to more than 2 million, and become one of the then large cities with a population over 2 million. | Other... | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24222 | 24222 | 1911-01-28 | 3 | a | The number of warships in Britain | The number of warships has gone up in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24223 | 24223 | 1911-01-28 | 3 | a | German import and export | The value of German import and export. | Other... | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24224 | 24224 | 1911-01-28 | 3 | a-b | Sentence of the premeditated murderer of the Japanese King | The premeditated murderers of the Japanese King, who were leaders of the Japanese Anarchic Party have been sentenced to death. Details of the Party's history is also revealed. | Japan | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24225 | 24225 | 1911-01-28 | 3 | b | The number of British migrants to other countries | The number of British migrants to other countries such as Canada, South Africa and America has increased. | Britain | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24226 | 24226 | 1911-01-28 | 3 | b | Canadian-Chinese drug smugglers still active | Canadian-Chinese drug smugglers are still active in Vancuvour, Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24227 | 24227 | 1911-01-28 | 3 | b | Various Japanese parties show concern to its navy | Various Japanese parties show concern to its navy and invited a top navy officer to give speeches. | Japan | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24228 | 24228 | 1911-01-28 | 3 | b-c | Beijing News | The acting emperor worried with tears about the fate of the three northeastern provinces of China; Shangdong province is suffering with heavy debts; China is negotiating with foreign delegates from six countries about China's borrowing their capital to build a navy shipyard; No chinese businessmen in Yi country; China's army is planning to have its regulations about cavalry; The army resend its students to study in Japan; Conflicts between the Min (Fujian) and Yue (Guangdong) navies; Unsucessful assassin of Chinese ambassador Zhang Yintang to America due to his appeal to the Emperor for preparing a constitution and his attending the century anniversary in Melbourne. | China | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
24229 | 24229 | 1911-01-28 | 3 | c-d | Guangdong News | Guangdong's finance is deficit; An imperial educational inspector visited several schools and praised Nanqiang Public School; a person from Fanyu county, Fujian province bought back his land from the public; provincial governor offices send people to check China's board with other nations; Defence arrangement for Macao; fights between two families; people in Fanyu county actively involved in cutting their braids. | China | http://trove.nla.gov.au/newspaper/page/24091612 | 24091612 |
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]);