This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4545 | 4545 | 1900-02-07 | 5 | a | The Emperor of China is going to be dethroned and will be succeeded by a boy. | Other... | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
4546 | 4546 | 1900-02-07 | 5 | a | Russian newspaper says that they could carve China up if allied with Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
4547 | 4547 | 1900-02-07 | 5 | a | Empress Dowager ordered zongli yamen and local governors to defy the invading foreigners. | Other... | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
4551 | 4551 | 1900-02-07 | 5 | c-e | More reports about the war between Britain and Transvaal in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
11012 | 11012 | 1902-09-20 | 5 | a | A rich man tries to purchase from American government independence of the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
25773 | 25773 | 1912-02-24 | 5 | a-b | Current situation of Chinese railways | Chinese railways have been developing for many years but are far from sufficient to develop national economy. Statistics included. | Other... | http://trove.nla.gov.au/newspaper/page/24092119 | 24092119 |
25774 | 25774 | 1912-02-24 | 5 | b | Miscellany | Satires: A general is illiterate and blames a secretary for asking names of his ancestors. A thrift official often entertains his guests with half piece of fish. | Other... | http://trove.nla.gov.au/newspaper/page/24092119 | 24092119 |
42981 | 42981 | 1925-04-11 | 5 | b | Leader of Russian Bolshevik is assassinated by a Polish policeman. | Other... | http://trove.nla.gov.au/newspaper/page/24101095 | 24101095 | |
42984 | 42984 | 1925-04-11 | 5 | b | A tailor in Rome kills his sick daughter. | Other... | http://trove.nla.gov.au/newspaper/page/24101095 | 24101095 | |
43027 | 43027 | 1925-04-18 | 5 | c | An Italian warship explodes. | Other... | http://trove.nla.gov.au/newspaper/page/24101103 | 24101103 | |
43101 | 43101 | 1925-05-02 | 5 | b | A cargo ship is on fire on its way from London to Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24101119 | 24101119 | |
43140 | 43140 | 1925-05-09 | 5 | b | Riots in Bulgaria are suppressed. | Other... | http://trove.nla.gov.au/newspaper/page/24101127 | 24101127 | |
43148 | 43148 | 1925-05-09 | 5 | c | Workers on parade on May 1 in Japan, America, Cuba and Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24101127 | 24101127 | |
43185 | 43185 | 1925-05-16 | 5 | c | A boy in Warsaw shoots his fellow students in the school and the casualties. | Other... | http://trove.nla.gov.au/newspaper/page/24101135 | 24101135 | |
43224 | 43224 | 1925-05-23 | 5 | b | Further report on the earthquake in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24101143 | 24101143 | |
43230 | 43230 | 1925-05-23 | 5 | c | Opening of the Far Eastern sports games in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24101143 | 24101143 | |
43264 | 43264 | 1925-05-30 | 5 | b | Japanese swimmers win medal at the Far Eastern Sport Games. | Other... | http://trove.nla.gov.au/newspaper/page/24101151 | 24101151 | |
43266 | 43266 | 1925-05-30 | 5 | c | A Turkish ship sinks after collision with another ship. | Other... | http://trove.nla.gov.au/newspaper/page/24101151 | 24101151 | |
43301 | 43301 | 1925-06-06 | 5 | b | A Catholic church is bombed in Sofia, Bulgaria and the suspects are arrested. | Other... | http://trove.nla.gov.au/newspaper/page/24101159 | 24101159 | |
43336 | 43336 | 1925-06-13 | 5 | a-c | Further report on the May 30 demonstration, the aftermath, and foreign reports on the protest. Japan's attitude towards the demonstrations in Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24101167 | 24101167 | |
43369 | 43369 | 1925-06-20 | 5 | b-c | Miscellaneous report on the May 30 demonstration and chaos in Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24101175 | 24101175 | |
43450 | 43450 | 1925-07-11 | 5 | a | British-Indian troops will not go to China. | Other... | http://trove.nla.gov.au/newspaper/page/24101201 | 24101201 | |
43453 | 43453 | 1925-07-11 | 5 | b-c | Miscellaneous report on the strike and demonstration in Shanghai, Beijing, Guangzhou, and other cities. Response of foreign countries. | Other... | http://trove.nla.gov.au/newspaper/page/24101201 | 24101201 | |
43612 | 43612 | 1925-08-08 | 5 | c | Revolutionary movement in Tibet. | Other... | http://trove.nla.gov.au/newspaper/page/24101235 | 24101235 | |
43650 | 43650 | 1925-08-15 | 5 | c | Earthquake in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24101243 | 24101243 | |
43652 | 43652 | 1925-08-15 | 5 | c | Communists are arrested and sentenced in Bulgaria. | Other... | http://trove.nla.gov.au/newspaper/page/24101243 | 24101243 | |
43653 | 43653 | 1925-08-15 | 5 | c | Three adventurers arrives Manila from Hong Kong by small boat. | Other... | http://trove.nla.gov.au/newspaper/page/24101243 | 24101243 | |
43848 | 43848 | 1925-09-19 | 5 | c | King of Belgium tours India. | Other... | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43888 | 43888 | 1925-09-26 | 5 | c | A Spanish woman gives birth to 29 sons. | Other... | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43923 | 43923 | 1925-10-03 | 5 | b | Cholera in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24101299 | 24101299 | |
43961 | 43961 | 1925-10-10 | 5 | b | Cholera in Manila. | Other... | http://trove.nla.gov.au/newspaper/page/24101307 | 24101307 | |
43964 | 43964 | 1925-10-10 | 5 | b | South African authority takes precaution against communist activity. | Other... | http://trove.nla.gov.au/newspaper/page/24101307 | 24101307 | |
44056 | 44056 | 1925-10-31 | 5 | b | The war between Bulgaria and Greece, mediation effort by the League of Nations, and warning from French foreign minister. | Other... | http://trove.nla.gov.au/newspaper/page/24101331 | 24101331 | |
44088 | 44088 | 1925-11-07 | 5 | b-c | Anti-Chinese movement in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24101341 | 24101341 | |
44121 | 44121 | 1925-11-14 | 5 | b | Arab states will jointly resist France. | Other... | http://trove.nla.gov.au/newspaper/page/24101350 | 24101350 | |
44204 | 44204 | 1925-12-05 | 5 | a | Flood in Athens, capital of Greece. | Other... | http://trove.nla.gov.au/newspaper/page/24101374 | 24101374 | |
44237 | 44237 | 1925-12-12 | 5 | a | American warship leave Manila for Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24101384 | 24101384 | |
44241 | 44241 | 1925-12-12 | 5 | b | Conflict between Bulgaria and Greece. | Other... | http://trove.nla.gov.au/newspaper/page/24101384 | 24101384 | |
44269 | 44269 | 1925-12-19 | 5 | a | Riots in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24101392 | 24101392 | |
44296 | 44296 | 1925-12-26 | 5 | a | French troops attack Damascus. | Other... | http://trove.nla.gov.au/newspaper/page/24101400 | 24101400 | |
44298 | 44298 | 1925-12-26 | 5 | a | Queen of Italy is ill. | Other... | http://trove.nla.gov.au/newspaper/page/24101400 | 24101400 | |
44395 | 44395 | 1926-02-06 | 5 | c | Huang Dawei is on the way to Shanghai to meet the Nationalist Party. | Other... | http://trove.nla.gov.au/newspaper/page/24101448 | 24101448 | |
44416 | 44416 | 1926-02-13 | 5 | b | Communists attempt to assassinate Greek president. | Other... | http://trove.nla.gov.au/newspaper/page/24101456 | 24101456 | |
44478 | 44478 | 1926-03-06 | 5 | a | Conference of the League of Nations in Norway and China. | Other... | http://trove.nla.gov.au/newspaper/page/24101479 | 24101479 | |
44548 | 44548 | 1926-03-27 | 5 | a | Official documents are stolen from the Japanese Embassy in Mexico city. | Other... | http://trove.nla.gov.au/newspaper/page/24101503 | 24101503 | |
44556 | 44556 | 1926-03-27 | 5 | c | Queen of Denmark dies. | Other... | http://trove.nla.gov.au/newspaper/page/24101503 | 24101503 | |
44620 | 44620 | 1926-04-17 | 5 | a | Italian Prime Minister Benito Mussolini. | Other... | http://trove.nla.gov.au/newspaper/page/24101527 | 24101527 | |
44677 | 44677 | 1926-05-01 | 5 | c | Mohandas Karamchand Gandhi is to visit Finland. | Other... | http://trove.nla.gov.au/newspaper/page/24101543 | 24101543 | |
44703 | 44703 | 1926-05-08 | 5 | c | Seven Chinese die in a fire in Manila. | Other... | http://trove.nla.gov.au/newspaper/page/24101551 | 24101551 | |
44727 | 44727 | 1926-05-15 | 5 | a | Trade union and the labour movement in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24101559 | 24101559 | |
44756 | 44756 | 1926-05-22 | 5 | b | Revolution in Poland. | Other... | http://trove.nla.gov.au/newspaper/page/24101567 | 24101567 | |
44784 | 44784 | 1926-05-29 | 5 | b | Argentina government increases naval budget. | Other... | http://trove.nla.gov.au/newspaper/page/24101575 | 24101575 | |
44911 | 44911 | 1926-07-03 | 5 | c | The anti-Chinese movement in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
44925 | 44925 | 1926-07-10 | 5 | a | Italian government and the economic development. | Other... | http://trove.nla.gov.au/newspaper/page/24101625 | 24101625 | |
44958 | 44958 | 1926-07-17 | 5 | c | Envoy of American president to make an investigation in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24101633 | 24101633 | |
44978 | 44978 | 1926-07-24 | 5 | b | Religious conflict in India. | Other... | http://trove.nla.gov.au/newspaper/page/24101641 | 24101641 | |
45003 | 45003 | 1926-07-31 | 5 | a | Riots in Calcutta, India. | Other... | http://trove.nla.gov.au/newspaper/page/24101649 | 24101649 | |
45010 | 45010 | 1926-07-31 | 5 | c | Earthquake in Manila. | Other... | http://trove.nla.gov.au/newspaper/page/24101649 | 24101649 | |
45027 | 45027 | 1926-08-07 | 5 | a | Austrian government increases tariff. | Other... | http://trove.nla.gov.au/newspaper/page/24101657 | 24101657 | |
45049 | 45049 | 1926-08-14 | 5 | b | War clouds over the Balkan peninsula. | Other... | http://trove.nla.gov.au/newspaper/page/24101665 | 24101665 | |
45054 | 45054 | 1926-08-14 | 5 | c | Chinese people and their anticommunist sentiment. | Other... | http://trove.nla.gov.au/newspaper/page/24101665 | 24101665 | |
45102 | 45102 | 1926-08-28 | 5 | b | Coup in Greece. | Other... | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
45105 | 45105 | 1926-08-28 | 5 | c | Pirates near Macao. | Other... | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
45128 | 45128 | 1926-09-04 | 5 | b | The American investigator in the Philippines and the conflicts. | Other... | http://trove.nla.gov.au/newspaper/page/24101701 | 24101701 | |
45244 | 45244 | 1926-10-23 | 5 | c | Friendship agreement between China and Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24101753 | 24101753 | |
45281 | 45281 | 1926-11-06 | 5 | c | Italian Prime Minister Benito Mussolini escapes an assassination. | Other... | http://trove.nla.gov.au/newspaper/page/24101769 | 24101769 | |
45544 | 45544 | 1927-03-12 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101909 | 24101909 | |
45578 | 45578 | 1927-03-26 | 5 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101925 | 24101925 | |
45610 | 45610 | 1927-04-09 | 5 | a-c | Foreign reports on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101941 | 24101941 | |
45628 | 45628 | 1927-04-16 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101949 | 24101949 | |
45672 | 45672 | 1927-04-30 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101965 | 24101965 | |
45695 | 45695 | 1927-05-07 | 5 | a | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101975 | 24101975 | |
45720 | 45720 | 1927-05-14 | 5 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101985 | 24101985 | |
45738 | 45738 | 1927-05-21 | 5 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101993 | 24101993 | |
45758 | 45758 | 1927-05-28 | 5 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102003 | 24102003 | |
45778 | 45778 | 1927-06-04 | 5 | b-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102010 | 24102010 | |
45802 | 45802 | 1927-06-11 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102019 | 24102019 | |
45822 | 45822 | 1927-06-18 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102028 | 24102028 | |
45850 | 45850 | 1927-06-25 | 5 | a-b | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102037 | 24102037 | |
45877 | 45877 | 1927-07-02 | 5 | c | Ninety Chinese labourers are arrested in Dutch colony East Timor. | Other... | http://trove.nla.gov.au/newspaper/page/24098441 | 24098441 | |
45952 | 45952 | 1927-07-23 | 5 | b | Earthquake in Egypt. | Other... | http://trove.nla.gov.au/newspaper/page/24098465 | 24098465 | |
45974 | 45974 | 1927-07-30 | 5 | a | Foreign report on the Chinese situations. | Other... | http://trove.nla.gov.au/newspaper/page/24098473 | 24098473 | |
46005 | 46005 | 1927-08-06 | 5 | a | Cholera in Persia. | Other... | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
46007 | 46007 | 1927-08-06 | 5 | b | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
46008 | 46008 | 1927-08-06 | 5 | b | Storm in Holland. | Other... | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
46014 | 46014 | 1927-08-06 | 5 | c | Earthquake in Persia. | Other... | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
46017 | 46017 | 1927-08-06 | 5 | c | Economic recession in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
46040 | 46040 | 1927-08-13 | 5 | a | Cholera in Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24098489 | 24098489 | |
46072 | 46072 | 1927-08-20 | 5 | a | Epidemic disease in Soviet Russia. Soviet advisers are leaving China. | Other... | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46073 | 46073 | 1927-08-20 | 5 | a | Railway workers on strike in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46075 | 46075 | 1927-08-20 | 5 | b | Political chaos in Portugal. | Other... | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46102 | 46102 | 1927-08-27 | 5 | a | Local provincial governments in Italy present planes to the Prime Minister Benito Mussolini. | Other... | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
46247 | 46247 | 1927-10-01 | 5 | b | Portuguese authority banishes political criminals. | Other... | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46249 | 46249 | 1927-10-01 | 5 | b | Students in Holland and the communist propaganda. | Other... | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46251 | 46251 | 1927-10-01 | 5 | c | Arms smuggling into India. | Other... | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46282 | 46282 | 1927-10-08 | 5 | a | Catholics in Mexico make trouble. | Other... | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46308 | 46308 | 1927-10-15 | 5 | b | Danish warship sinks in the North Sea. | Other... | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
46370 | 46370 | 1927-10-29 | 5 | c | Bandits in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46394 | 46394 | 1927-11-05 | 5 | a | Famine refugees in Turkey and their riots. | Other... | http://trove.nla.gov.au/newspaper/page/24098585 | 24098585 | |
46397 | 46397 | 1927-11-05 | 5 | c | Discussions of Ghandi and the Governor-General of India. | Other... | http://trove.nla.gov.au/newspaper/page/24098585 | 24098585 |
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]);