This data as json, CSV (advanced)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54742 | 54742 | 1934-12-15 | 6 | a | Australian planes disappears while flying across the Pacific. | America | http://trove.nla.gov.au/newspaper/page/24096267 | 24096267 | |
54741 | 54741 | 1934-12-15 | 6 | a | Earthquake in central America. | America | http://trove.nla.gov.au/newspaper/page/24096267 | 24096267 | |
54727 | 54727 | 1934-12-08 | 6 | c | Bolivian government collapses. | America | http://trove.nla.gov.au/newspaper/page/24096259 | 24096259 | |
54717 | 54717 | 1934-12-08 | 3 | a | American naval commander on the warship building. | America | http://trove.nla.gov.au/newspaper/page/24096254 | 24096254 | |
54699 | 54699 | 1934-12-01 | 2 | d | America purchases more silver from overseas. | America | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
54667 | 54667 | 1934-11-17 | 3 | c | German prophet predicts the second world war will break out next summer. | America | http://trove.nla.gov.au/newspaper/page/24096231 | 24096231 | |
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 | |
54662 | 54662 | 1934-11-10 | 6 | d | Chinese labourers smuggled into New York. | America | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
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 | |
54643 | 54643 | 1934-11-03 | 3 | e | America purchase silvers from overseas. | America | http://trove.nla.gov.au/newspaper/page/24096215 | 24096215 | |
54641 | 54641 | 1934-11-03 | 3 | d | Chinese communities in Washington welcome General Cai Tingkai. | America | http://trove.nla.gov.au/newspaper/page/24096215 | 24096215 | |
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 | |
54634 | 54634 | 1934-10-27 | 6 | b | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
54630 | 54630 | 1934-10-27 | 3 | b | American newspaper condemns Japan. | America | http://trove.nla.gov.au/newspaper/page/24096205 | 24096205 | |
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 | |
54597 | 54597 | 1934-10-13 | 3 | e | Arms dealers in America. | America | http://trove.nla.gov.au/newspaper/page/24096189 | 24096189 | |
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 | |
54574 | 54574 | 1934-10-06 | 3 | a | American warships gather in the Pacific region. | America | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54554 | 54554 | 1934-09-29 | 3 | c | America dispatches more warships to the Pacific region. | America | http://trove.nla.gov.au/newspaper/page/24096173 | 24096173 | |
54552 | 54552 | 1934-09-29 | 3 | b | Cai Tingkai arrives New York. | America | http://trove.nla.gov.au/newspaper/page/24096173 | 24096173 | |
54532 | 54532 | 1934-09-22 | 3 | f | Japan may give up its naval agreement signed with America. | America | http://trove.nla.gov.au/newspaper/page/24096165 | 24096165 | |
54531 | 54531 | 1934-09-22 | 3 | e | American navy and its war planes. | America | http://trove.nla.gov.au/newspaper/page/24096165 | 24096165 | |
54523 | 54523 | 1934-09-15 | 6 | d | Tourist ferry on fire in New York. | 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 | |
54517 | 54517 | 1934-09-15 | 6 | a | Volcano erupts in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54514 | 54514 | 1934-09-15 | 3 | f | Republican Party in America criticises the policy of President Roosevelt. | America | http://trove.nla.gov.au/newspaper/page/24096157 | 24096157 | |
54491 | 54491 | 1934-09-08 | 3 | d | Both Britain and Germany are preparing for the coming war. | America | http://trove.nla.gov.au/newspaper/page/24096149 | 24096149 | |
54479 | 54479 | 1934-09-01 | 6 | b | American farmers request to deport Japanese immigrants. | America | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
54478 | 54478 | 1934-09-01 | 6 | a | Kidnap in New York. | America | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
54469 | 54469 | 1934-09-01 | 3 | a | American President Roosevelt arrives Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24096141 | 24096141 | |
54456 | 54456 | 1934-08-25 | 3 | e | American new plan for the naval growth. | America | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
54455 | 54455 | 1934-08-25 | 3 | c | Chinese ambassador in Washington Shi Zhaoji criticises American policy in the Far East. | America | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
54437 | 54437 | 1934-08-18 | 6 | a | Drought in America. | America | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54423 | 54423 | 1934-08-11 | 6 | e | American President escapes from an assassination. | America | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
54407 | 54407 | 1934-08-04 | 6 | a | Hot weather in America. | America | http://trove.nla.gov.au/newspaper/page/24096112 | 24096112 | |
54380 | 54380 | 1934-07-28 | 6 | b | Failed strike in San Francisco and a further report. | America | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54373 | 54373 | 1934-07-28 | 3 | f | American weapon export to China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54368 | 54368 | 1934-07-28 | 3 | d | American fleet to return to its Pacific base. | America | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54349 | 54349 | 1934-07-21 | 6 | c | Strike in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54324 | 54324 | 1934-07-14 | 6 | c | American celebrates their independence. | America | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54321 | 54321 | 1934-07-14 | 6 | a | Revolution in Chile. | America | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54316 | 54316 | 1934-07-14 | 3 | e | America to restrict import of Japanese goods. | America | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
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 | |
54287 | 54287 | 1934-07-07 | 3 | d | American military forces in the Pacific. | America | http://trove.nla.gov.au/newspaper/page/24096075 | 24096075 | |
54272 | 54272 | 1934-06-30 | 6 | d | Racial discrimination in America. | America | http://trove.nla.gov.au/newspaper/page/24096072 | 24096072 | |
54255 | 54255 | 1934-06-23 | 6 | b | Earthquake in Argentina. | America | http://trove.nla.gov.au/newspaper/page/24096064 | 24096064 | |
54219 | 54219 | 1934-06-09 | 3 | f | Repayment of war loans to America. | America | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54214 | 54214 | 1934-06-09 | 3 | b | Relations between America and Japan. | America | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54195 | 54195 | 1934-06-02 | 3 | e | American troops on the way to seize the Panama Canal. | America | http://trove.nla.gov.au/newspaper/page/24096033 | 24096033 | |
54135 | 54135 | 1934-05-12 | 3 | e | The independence of the Philippines from America. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
54134 | 54134 | 1934-05-12 | 3 | d | The communist activists in American navy. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
54133 | 54133 | 1934-05-12 | 3 | d | Russian ambassador in Washington on the war between Japan and Russia. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
54060 | 54060 | 1934-04-14 | 3 | d | American parliament approves the new budget for navy. | America | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54059 | 54059 | 1934-04-14 | 3 | c | Unemployment in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24095971 | 24095971 | |
54048 | 54048 | 1934-04-07 | 6 | d | Japanese purchase army provisions from America. | America | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54037 | 54037 | 1934-04-07 | 3 | e | France disagrees with Britain on the international disarmament. | America | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54025 | 54025 | 1934-03-31 | 6 | e | The Philippines to become independent. | America | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
53996 | 53996 | 1934-03-24 | 3 | f | American government maintain the silver price. | America | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53991 | 53991 | 1934-03-24 | 3 | d | American navy and airforce troops have joint exercise. | America | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53967 | 53967 | 1934-03-17 | 3 | e | American report on the secret treaty between Germany and Japan. | America | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53918 | 53918 | 1934-03-03 | 6 | a | Heavy snow block traffic in America. | America | http://trove.nla.gov.au/newspaper/page/24091553 | 24091553 | |
53908 | 53908 | 1934-03-03 | 3 | e | American government explains its Pacific policy. | America | http://trove.nla.gov.au/newspaper/page/24091548 | 24091548 | |
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 | |
53867 | 53867 | 1934-02-17 | 6 | b | Cold weather in America. | America | |||
53849 | 53849 | 1934-02-10 | 6 | d | America is afraid of that Japan and Russia may start a war soon. | America | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53843 | 53843 | 1934-02-10 | 6 | a | Earthquake in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24091531 | 24091531 | |
53837 | 53837 | 1934-02-10 | 3 | e | American President Roosevelt increases price of silver. | America | http://trove.nla.gov.au/newspaper/page/24091526 | 24091526 | |
53812 | 53812 | 1934-01-27 | 6 | d | Japanese seek to colonise Chile. | America | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
53724 | 53724 | 1934-01-06 | 3 | d | South American countries including Brazil and Argentina set up diplomatic relations with Soviet Russia. | America | http://trove.nla.gov.au/newspaper/page/24091486 | 24091486 | |
53695 | 53695 | 1933-12-23 | 3 | e | Trade between America and Russia will increase. | America | http://trove.nla.gov.au/newspaper/page/24091478 | 24091478 | |
53680 | 53680 | 1933-12-16 | 6 | c | Chinese government increases tariff on imported wheat flour. | America | http://trove.nla.gov.au/newspaper/page/24091475 | 24091475 | |
53668 | 53668 | 1933-12-16 | 3 | c | American financial authority reshuffled. | America | http://trove.nla.gov.au/newspaper/page/24091470 | 24091470 | |
53590 | 53590 | 1933-11-25 | 6 | d | America recognises the Soviet Russian government. | America | http://trove.nla.gov.au/newspaper/page/24091450 | 24091450 | |
53578 | 53578 | 1933-11-25 | 3 | e | America will not attend any disarmament conference in Europe. | America | http://trove.nla.gov.au/newspaper/page/24091445 | 24091445 | |
53498 | 53498 | 1933-11-04 | 6 | d | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24091426 | 24091426 | |
53469 | 53469 | 1933-10-28 | 6 | c | America and Russia resume their trade. | America | http://trove.nla.gov.au/newspaper/page/24091418 | 24091418 | |
53453 | 53453 | 1933-10-28 | 3 | d | American government plans to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53450 | 53450 | 1933-10-28 | 3 | b | American government to recognise the Soviet Russian government. | America | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53422 | 53422 | 1933-10-21 | 5 | a | Medical progress in Soviet Russia. | America | http://trove.nla.gov.au/newspaper/page/24091407 | 24091407 | |
53402 | 53402 | 1933-10-14 | 6 | a | Bush fire in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
53396 | 53396 | 1933-10-14 | 3 | e | Economic recovery in America. | America | http://trove.nla.gov.au/newspaper/page/24091397 | 24091397 | |
53299 | 53299 | 1933-09-16 | 6 | d | Competition between America, Japan and Britain in the building of warships. | America | http://trove.nla.gov.au/newspaper/page/24091370 | 24091370 | |
53226 | 53226 | 1933-08-26 | 6 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
53180 | 53180 | 1933-08-12 | 6 | b | Competition of Japanese and American navies. | America | http://trove.nla.gov.au/newspaper/page/24091330 | 24091330 | |
53157 | 53157 | 1933-08-05 | 6 | b | Sale of American wheat in China. | America | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53155 | 53155 | 1933-08-05 | 6 | a | American government approves gold export. | America | http://trove.nla.gov.au/newspaper/page/24091322 | 24091322 | |
53135 | 53135 | 1933-07-29 | 6 | c | Dramatic fall of stock prices in Wall Street, New York. | America | http://trove.nla.gov.au/newspaper/page/24091314 | 24091314 | |
53121 | 53121 | 1933-07-29 | 3 | d | Arms race between Japanese and American navies. | America | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53097 | 53097 | 1933-07-22 | 3 | d | American government accepts silver from Britain for debt repayment. | America | http://trove.nla.gov.au/newspaper/page/24091301 | 24091301 | |
53074 | 53074 | 1933-07-15 | 3 | b | Chinese government secures loans from America. | America | http://trove.nla.gov.au/newspaper/page/24091293 | 24091293 | |
53063 | 53063 | 1933-07-08 | 6 | c | American navy to build more basis. | America | http://trove.nla.gov.au/newspaper/page/24091290 | 24091290 | |
53058 | 53058 | 1933-07-08 | 5 | d | Wine bath in New York. | America | http://trove.nla.gov.au/newspaper/page/24091287 | 24091287 | |
53057 | 53057 | 1933-07-08 | 5 | b | Second part of a report on the territories China has ceded in the past 50 years. | America | http://trove.nla.gov.au/newspaper/page/24091287 | 24091287 | |
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 | |
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 | |
52993 | 52993 | 1933-06-17 | 6 | d | Hot weather in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
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 | |
52977 | 52977 | 1933-06-10 | 6 | e | American government lends loans to China. | America | http://trove.nla.gov.au/newspaper/page/24091258 | 24091258 | |
52965 | 52965 | 1933-06-10 | 3 | c | American senate authorise President Roosevelt to accept silver repayment of war loans. | America | http://trove.nla.gov.au/newspaper/page/24091253 | 24091253 | |
52964 | 52964 | 1933-06-10 | 3 | b | American government and its plan for naval development. | America | http://trove.nla.gov.au/newspaper/page/24091253 | 24091253 |
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]);