This data as json, CSV (advanced)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39848 | 39848 | 1923-05-12 | 7 | a | Bandits in Lincheng, Shandong province, hijack a train and kidnap some foreign passengers. | America | http://trove.nla.gov.au/newspaper/page/24094403 | 24094403 | |
43603 | 43603 | 1925-08-08 | 5 | a | American president Calvin Coolidge proposes further disarmament. | America | http://trove.nla.gov.au/newspaper/page/24101235 | 24101235 | |
43852 | 43852 | 1925-09-19 | 6 | a | American president Calvin Coolidge orders to set up an air navigation bureau. | America | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 | |
43891 | 43891 | 1925-09-26 | 6 | a | New American ambassador to Japan. | America | http://trove.nla.gov.au/newspaper/page/24101294 | 24101294 | |
43892 | 43892 | 1925-09-26 | 6 | a | More fighting among the Chinese communities in America. | America | http://trove.nla.gov.au/newspaper/page/24101294 | 24101294 | |
43958 | 43958 | 1925-10-10 | 5 | a | Chinese consul in New York mediates the fighting among Chinese communities. Australian trade commissioner to Washington talks about business. | America | http://trove.nla.gov.au/newspaper/page/24101307 | 24101307 | |
44083 | 44083 | 1925-11-07 | 5 | a | A passenger train derails in America. | America | http://trove.nla.gov.au/newspaper/page/24101341 | 24101341 | |
44084 | 44084 | 1925-11-07 | 5 | a | A bank robbery in America. | America | http://trove.nla.gov.au/newspaper/page/24101341 | 24101341 | |
44115 | 44115 | 1925-11-14 | 5 | a | Disaccord between America and Italy over the debt repayment. | America | http://trove.nla.gov.au/newspaper/page/24101350 | 24101350 | |
44145 | 44145 | 1925-11-21 | 5 | a | British immigrants to America. | America | http://trove.nla.gov.au/newspaper/page/24101358 | 24101358 | |
44147 | 44147 | 1925-11-21 | 5 | a | Two trains collide in heavy fog in New York and 13 passengers died. | America | http://trove.nla.gov.au/newspaper/page/24101358 | 24101358 | |
44178 | 44178 | 1925-11-28 | 5 | a | A dockyard in New Orlean, United States of America, is set alight. | America | http://trove.nla.gov.au/newspaper/page/24101366 | 24101366 | |
44180 | 44180 | 1925-11-28 | 5 | a | Italian government seeks for loans from America to deal with internal financial crisis. | America | http://trove.nla.gov.au/newspaper/page/24101366 | 24101366 | |
44205 | 44205 | 1925-12-05 | 5 | a | Robberies in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24101374 | 24101374 | |
44238 | 44238 | 1925-12-12 | 5 | a | Robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24101384 | 24101384 | |
44268 | 44268 | 1925-12-19 | 5 | a | Homicide case in Pittsburgh, United States. | America | http://trove.nla.gov.au/newspaper/page/24101392 | 24101392 | |
44549 | 44549 | 1926-03-27 | 5 | a | American naval fleet on the way to China. | America | http://trove.nla.gov.au/newspaper/page/24101503 | 24101503 | |
44671 | 44671 | 1926-05-01 | 5 | a | New immigration regulations in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24101543 | 24101543 | |
45002 | 45002 | 1926-07-31 | 5 | a | Heat waves in America. | America | http://trove.nla.gov.au/newspaper/page/24101649 | 24101649 | |
45101 | 45101 | 1926-08-28 | 5 | a | Revolution in Nicaragua. | America | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
46074 | 46074 | 1927-08-20 | 5 | a | Riots in Bolivia, South America. | America | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46216 | 46216 | 1927-09-24 | 5 | a | Heat waves in America. | America | http://trove.nla.gov.au/newspaper/page/24098537 | 24098537 | |
46244 | 46244 | 1927-10-01 | 5 | a | Bandits in Nicaragua. | America | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46665 | 46665 | 1928-01-14 | 5 | a | Cold winter in America. | America | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46731 | 46731 | 1928-02-11 | 5 | a | Suicides in New York and the report. | America | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
46797 | 46797 | 1928-03-03 | 7 | a | Number of unemployed workers in America. | America | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46801 | 46801 | 1928-03-03 | 7 | a | Bandits in Chicago hijack train. | America | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
47012 | 47012 | 1928-05-05 | 7 | a | Typhoon in American and the damages. | America | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 | |
47104 | 47104 | 1928-06-02 | 8 | a | Gas explosion in America and the tragedy. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47173 | 47173 | 1928-06-23 | 8 | a | Export of gold coins from the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
47305 | 47305 | 1928-08-04 | 8 | a | Bandits rob shops in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
47368 | 47368 | 1928-08-25 | 8 | a | American government on the recent negotiation between China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47391 | 47391 | 1928-09-01 | 8 | a | Traffic accident in a tunnel in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 | |
47465 | 47465 | 1928-09-29 | 8 | a | Bandits in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24098968 | 24098968 | |
47474 | 47474 | 1928-10-06 | 8 | a | American scholar on the current situations in Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24098976 | 24098976 | |
47494 | 47494 | 1928-10-13 | 8 | a | New York customs officers seize opium from a ship. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47575 | 47575 | 1928-11-10 | 8 | a | Presidential election in America and the betting. | America | http://trove.nla.gov.au/newspaper/page/24099016 | 24099016 | |
47593 | 47593 | 1928-11-17 | 8 | a | A ship sinks near New York. | America | http://trove.nla.gov.au/newspaper/page/24099024 | 24099024 | |
47612 | 47612 | 1928-11-24 | 8 | a | American authority detains Communist activists and the report. | America | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47614 | 47614 | 1928-11-24 | 8 | a | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47659 | 47659 | 1928-12-08 | 8 | a | Earthquake in Chile. | America | http://trove.nla.gov.au/newspaper/page/24099048 | 24099048 | |
47694 | 47694 | 1928-12-22 | 8 | a | Chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47697 | 47697 | 1928-12-22 | 8 | a | Tobacco import of China and the competition. | America | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47747 | 47747 | 1929-01-12 | 8 | a | Epidemic disease in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24099088 | 24099088 | |
47879 | 47879 | 1929-03-09 | 8 | a | Bandits and robberies in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099144 | 24099144 | |
47903 | 47903 | 1929-03-16 | 8 | a | More chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47929 | 47929 | 1929-03-23 | 8 | a | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/24099160 | 24099160 | |
48009 | 48009 | 1929-04-13 | 8 | a | American businessmen on the development of aviation industry in China. | America | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48269 | 48269 | 1929-07-06 | 8 | a | Amount of loans from America. | America | http://trove.nla.gov.au/newspaper/page/24099278 | 24099278 | |
49951 | 49951 | 1931-01-31 | 8 | a | Many poor people in America need help. | America | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
50023 | 50023 | 1931-02-21 | 8 | a | Unemployed people have demonstrations in America. | America | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50043 | 50043 | 1931-02-28 | 8 | a | American senate on the economic recession. | America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50044 | 50044 | 1931-02-28 | 8 | a | Chinese communities in American on the loans to the Chinese government. | America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50715 | 50715 | 1931-09-19 | 3 | a | Jiang Jieshi transfers his money to New York. | America | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 | |
50763 | 50763 | 1931-10-03 | 8 | a | Japanese ambassador in Washington denies any invasion of Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50881 | 50881 | 1931-11-14 | 5 | a | The Chinese Society (zhong hua hui guan) in San Francisco issues a circular telegram which requests to abolish the Party control of administration. | America | http://trove.nla.gov.au/newspaper/page/24090592 | 24090592 | |
51010 | 51010 | 1931-12-16 | 7 | a | The Confucian School in San Francisco donates to Ma Zhanshan's army in Heilongjiang province. | America | |||
51011 | 51011 | 1931-12-16 | 7 | a | The Chinese Society in San Francisco donates to Ma Zhanshan's army in Heilongjiang. | America | |||
51082 | 51082 | 1932-01-16 | 8 | a | American president on the international treaties and Japanese invasion of Manchuria. American government on the Japanese invasion of China. | America | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
51134 | 51134 | 1932-01-30 | 8 | a | Presidential election in America. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51135 | 51135 | 1932-01-30 | 8 | a | America will not stop Japanese invasion of China. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51155 | 51155 | 1932-02-06 | 5 | a | American government closely watching Japanese in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51156 | 51156 | 1932-02-06 | 5 | a | American parliamentarians suggest to break off economic relations with Japan. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51308 | 51308 | 1932-03-19 | 8 | a | Anti-Japanese demonstration in America. | America | http://trove.nla.gov.au/newspaper/page/24090742 | 24090742 | |
51358 | 51358 | 1932-04-02 | 5 | a | American Secretary of State on the war in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24090753 | 24090753 | |
51606 | 51606 | 1932-06-11 | 8 | a | American government increase tax rates. | America | http://trove.nla.gov.au/newspaper/page/24090838 | 24090838 | |
51669 | 51669 | 1932-07-02 | 8 | a | More banks bankrupt in America. | America | http://trove.nla.gov.au/newspaper/page/24090862 | 24090862 | |
51694 | 51694 | 1932-07-09 | 8 | a | Britain, France and Japan disagree to the disarmament proposal put forward by the American president. | America | http://trove.nla.gov.au/newspaper/page/24090870 | 24090870 | |
51737 | 51737 | 1932-07-23 | 8 | a | Retired servicemen on demonstration in America. | America | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
51780 | 51780 | 1932-08-06 | 8 | a | Martial law proclaimed in Washington. | America | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
52220 | 52220 | 1932-11-19 | 8 | a | Result of the election in America. | America | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52473 | 52473 | 1933-01-28 | 8 | a | American President Roosevelt and his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
52704 | 52704 | 1933-03-25 | 6 | a | American government agrees to cooperate with the League of Nations. | America | http://trove.nla.gov.au/newspaper/page/24091168 | 24091168 | |
52760 | 52760 | 1933-04-15 | 6 | a | American warplane crushes. | America | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52761 | 52761 | 1933-04-15 | 6 | a | A secret telegram from Japanese ambassador in Washington to his government. | America | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52983 | 52983 | 1933-06-17 | 3 | a | Pessimism on the international disarmament. Britain, France and America to jointly boycott Germany. | America | http://trove.nla.gov.au/newspaper/page/24091261 | 24091261 | |
53031 | 53031 | 1933-07-01 | 5 | a | First part of a report on the territories China has ceded in the past 50 years. | America | http://trove.nla.gov.au/newspaper/page/24091279 | 24091279 | |
53035 | 53035 | 1933-07-01 | 6 | a | A man arrested in New York for attempting to assassinate American President. | America | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53155 | 53155 | 1933-08-05 | 6 | a | American government approves gold export. | America | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53402 | 53402 | 1933-10-14 | 6 | a | Bush fire in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
53422 | 53422 | 1933-10-21 | 5 | a | Medical progress in Soviet Russia. | America | http://trove.nla.gov.au/newspaper/page/24091407 | 24091407 | |
53843 | 53843 | 1934-02-10 | 6 | a | Earthquake in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53888 | 53888 | 1934-02-24 | 5 | a | Prose by Liang Chaojie on the birthday of his mother. | America | http://trove.nla.gov.au/newspaper/page/24091542 | 24091542 | |
53918 | 53918 | 1934-03-03 | 6 | a | Heavy snow block traffic in America. | America | http://trove.nla.gov.au/newspaper/page/24091553 | 24091553 | |
54298 | 54298 | 1934-07-07 | 6 | a | America on the possible alliance of Japan and Britain. | America | http://trove.nla.gov.au/newspaper/page/24096080 | 24096080 | |
54321 | 54321 | 1934-07-14 | 6 | a | Revolution in Chile. | America | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54407 | 54407 | 1934-08-04 | 6 | a | Hot weather in America. | America | http://trove.nla.gov.au/newspaper/page/24096112 | 24096112 | |
54437 | 54437 | 1934-08-18 | 6 | a | Drought in America. | America | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54469 | 54469 | 1934-09-01 | 3 | a | American President Roosevelt arrives Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
54478 | 54478 | 1934-09-01 | 6 | a | Kidnap in New York. | America | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
54517 | 54517 | 1934-09-15 | 6 | a | Volcano erupts in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54519 | 54519 | 1934-09-15 | 6 | a | Strike in the south of America. | America | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54574 | 54574 | 1934-10-06 | 3 | a | American warships gather in the Pacific region. | America | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54582 | 54582 | 1934-10-06 | 6 | a | American scholar on the coming war between Russia and Japan. | America | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
54610 | 54610 | 1934-10-20 | 3 | a | Chinese communities in New York welcome General Cai Tingkai. | America | http://trove.nla.gov.au/newspaper/page/24096197 | 24096197 | |
54637 | 54637 | 1934-11-03 | 2 | a | Comments selected from an American newspaper on General Cai Tingkai. | America | http://trove.nla.gov.au/newspaper/page/24096216 | 24096216 | |
54651 | 54651 | 1934-11-10 | 3 | a | Chinese communities in Boston welcome General Cai Tingkai. | America | http://trove.nla.gov.au/newspaper/page/24096223 | 24096223 | |
54666 | 54666 | 1934-11-17 | 3 | a | Speech of General Cai Tingkai at the welcome ceremony of the Chinese communities in Boston. | America | http://trove.nla.gov.au/newspaper/page/24096231 | 24096231 | |
54717 | 54717 | 1934-12-08 | 3 | a | American naval commander on the warship building. | America | http://trove.nla.gov.au/newspaper/page/24096254 | 24096254 | |
54741 | 54741 | 1934-12-15 | 6 | a | Earthquake in central America. | America | http://trove.nla.gov.au/newspaper/page/24096267 | 24096267 |
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]);