This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56489 | 56489 | 1936-12-12 | 8 | b | American President Roosevelt speaks at a conference in South America. | America | http://trove.nla.gov.au/newspaper/page/24097099 | 24097099 | |
56477 | 56477 | 1936-12-05 | 8 | b | American authority destroy drugs. | America | http://trove.nla.gov.au/newspaper/page/24097091 | 24097091 | |
56444 | 56444 | 1936-11-21 | 8 | e | The bridge project in San Francisco is completed. | America | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
56443 | 56443 | 1936-11-21 | 8 | d | Japanese troops along the Yangtze River. | America | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
56428 | 56428 | 1936-11-14 | 8 | d | Number of population of the world. | America | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56424 | 56424 | 1936-11-14 | 8 | b | Presidential election in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
56398 | 56398 | 1936-11-07 | 8 | d | Population increase in America. | America | http://trove.nla.gov.au/newspaper/page/24097058 | 24097058 | |
56224 | 56224 | 1936-08-29 | 8 | e | A naked parade in New York. | America | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56221 | 56221 | 1936-08-29 | 8 | c | Mexico helps Spanish government. | America | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56199 | 56199 | 1936-08-22 | 8 | d | Bush fire in America. | America | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
56168 | 56168 | 1936-08-15 | 8 | e | Chinese woman detained in San Francisco for drug smuggling. | America | http://trove.nla.gov.au/newspaper/page/24096960 | 24096960 | |
56107 | 56107 | 1936-07-25 | 8 | a | Military expense of the American government. | America | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
56106 | 56106 | 1936-07-25 | 8 | a | A prediction on the war in the Pacific region. | America | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
55945 | 55945 | 1936-04-04 | 8 | a | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/24096806 | 24096806 | |
55908 | 55908 | 1936-03-21 | 8 | b | American government seeks to expand its airforce troops. | America | http://trove.nla.gov.au/newspaper/page/24096790 | 24096790 | |
55840 | 55840 | 1936-02-29 | 8 | d | Cold weather in North America. | America | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55626 | 55626 | 1935-11-30 | 8 | a | American government has approved the independence of the Philippines. | America | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
55578 | 55578 | 1935-11-09 | 8 | d | Earthquake in America and Canada. | America | http://trove.nla.gov.au/newspaper/page/24096641 | 24096641 | |
55491 | 55491 | 1935-10-05 | 8 | a | Coal miners on strike in America. | America | http://trove.nla.gov.au/newspaper/page/24096601 | 24096601 | |
55456 | 55456 | 1935-09-21 | 8 | a | American customs imposes heavy tax on German products. | America | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
55376 | 55376 | 1935-08-24 | 8 | a | American people look down upon the Emperor of Japan. | America | http://trove.nla.gov.au/newspaper/page/24096551 | 24096551 | |
55341 | 55341 | 1935-08-10 | 8 | d | A cartoon picture published in an American newspaper. | America | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55334 | 55334 | 1935-08-10 | 8 | a | A robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55302 | 55302 | 1935-07-27 | 8 | e | Trade disputes between Japan and Canada. | America | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55260 | 55260 | 1935-07-13 | 8 | a | Independence celebration in America. | America | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55220 | 55220 | 1935-06-22 | 8 | e | America to expand its naval forces. | America | http://trove.nla.gov.au/newspaper/page/24096479 | 24096479 | |
55146 | 55146 | 1935-05-25 | 8 | a | Freight service between China and America. | America | http://trove.nla.gov.au/newspaper/page/24096447 | 24096447 | |
55058 | 55058 | 1935-04-27 | 8 | b | Test of mail planes in America. | America | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55057 | 55057 | 1935-04-27 | 8 | a | Sandstorm in America. | America | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55017 | 55017 | 1935-04-13 | 8 | a | The life of Soviet Russian people. | America | http://trove.nla.gov.au/newspaper/page/24096397 | 24096397 | |
52473 | 52473 | 1933-01-28 | 8 | a | American President Roosevelt and his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
52220 | 52220 | 1932-11-19 | 8 | a | Result of the election in America. | America | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52161 | 52161 | 1932-11-05 | 8 | c | American government refuse to send delegate to the conference of League of Nations. | America | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52117 | 52117 | 1932-10-29 | 8 | e | Korean people in Manchuria join to fight Japanese invaders. | America | http://trove.nla.gov.au/newspaper/page/24091006 | 24091006 | |
52111 | 52111 | 1932-10-29 | 8 | c | Japanese government to quit the nine-county-treaty. | America | http://trove.nla.gov.au/newspaper/page/24091006 | 24091006 | |
51951 | 51951 | 1932-09-24 | 8 | d | Chinese government asks for justice from American authority. | America | http://trove.nla.gov.au/newspaper/page/24090964 | 24090964 | |
51901 | 51901 | 1932-09-10 | 8 | c | American government comments on Japan's recognition of the Manchurian state. | America | http://trove.nla.gov.au/newspaper/page/24090944 | 24090944 | |
51870 | 51870 | 1932-09-03 | 8 | b | Attitude of the American government towards Japan. | America | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
51835 | 51835 | 1932-08-20 | 8 | d | A declaration issued by the American government and response of Japanese foreign ministry. | America | http://trove.nla.gov.au/newspaper/page/24090920 | 24090920 | |
51780 | 51780 | 1932-08-06 | 8 | a | Martial law proclaimed in Washington. | America | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
51737 | 51737 | 1932-07-23 | 8 | a | Retired servicemen on demonstration in America. | America | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
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 | |
51674 | 51674 | 1932-07-02 | 8 | c | American President Hoover opposes to Japan's China policy. | America | http://trove.nla.gov.au/newspaper/page/24090862 | 24090862 | |
51669 | 51669 | 1932-07-02 | 8 | a | More banks bankrupt in America. | America | http://trove.nla.gov.au/newspaper/page/24090862 | 24090862 | |
51606 | 51606 | 1932-06-11 | 8 | a | American government increase tax rates. | America | http://trove.nla.gov.au/newspaper/page/24090838 | 24090838 | |
51569 | 51569 | 1932-05-28 | 8 | b | Earthquake in central America. | America | http://trove.nla.gov.au/newspaper/page/24090822 | 24090822 | |
51527 | 51527 | 1932-05-14 | 8 | c | Clash between workers and police in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090805 | 24090805 | |
51481 | 51481 | 1932-04-30 | 8 | b | American parliamentarian suggests to resume diplomatic relations with Russia. | America | http://trove.nla.gov.au/newspaper/page/24090790 | 24090790 | |
51403 | 51403 | 1932-04-09 | 8 | b | The Philippines may become independent soon. | America | http://trove.nla.gov.au/newspaper/page/24090766 | 24090766 | |
51368 | 51368 | 1932-04-02 | 8 | b | Anti-Japanese movement in America. | America | http://trove.nla.gov.au/newspaper/page/24090758 | 24090758 | |
51314 | 51314 | 1932-03-19 | 8 | c | American government refuses to recognise the Manchurian government. | America | http://trove.nla.gov.au/newspaper/page/24090742 | 24090742 | |
51308 | 51308 | 1932-03-19 | 8 | a | Anti-Japanese demonstration in America. | America | http://trove.nla.gov.au/newspaper/page/24090742 | 24090742 | |
51290 | 51290 | 1932-03-12 | 8 | b | American government to assist the League of Nations. | America | http://trove.nla.gov.au/newspaper/page/24090734 | 24090734 | |
51240 | 51240 | 1932-02-27 | 8 | e | American naval fleet in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24090718 | 24090718 | |
51193 | 51193 | 1932-02-13 | 8 | e | American president on the Japanese invasion of Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24090702 | 24090702 | |
51172 | 51172 | 1932-02-06 | 8 | e | American naval forces have an exercise in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24090694 | 24090694 | |
51142 | 51142 | 1932-01-30 | 8 | c | American government to expand their naval forces. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51138 | 51138 | 1932-01-30 | 8 | c | Prisoners in America try to escape but fail. | 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 | |
51134 | 51134 | 1932-01-30 | 8 | a | Presidential election in America. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51109 | 51109 | 1932-01-23 | 8 | b | Another bank collapses in America. | America | http://trove.nla.gov.au/newspaper/page/24090676 | 24090676 | |
51106 | 51106 | 1932-01-23 | 8 | b | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/24090676 | 24090676 | |
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 | |
51059 | 51059 | 1932-01-09 | 8 | d | Japanese in Shenyang beat American consul. | America | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51027 | 51027 | 1931-12-16 | 8 | c | Four more banks are closed down in America. | America | |||
51023 | 51023 | 1931-12-16 | 8 | b | American government delivers its notes to Japan. | America | |||
50941 | 50941 | 1931-12-05 | 8 | c | Communists are attacked in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090627 | 24090627 | |
50870 | 50870 | 1931-11-07 | 8 | b | American government in financial shortage. | America | http://trove.nla.gov.au/newspaper/page/24090589 | 24090589 | |
50867 | 50867 | 1931-11-07 | 8 | b | Another bank collapses in America. | America | http://trove.nla.gov.au/newspaper/page/24090589 | 24090589 | |
50838 | 50838 | 1931-10-24 | 8 | d | A bank robbery in America. | America | http://trove.nla.gov.au/newspaper/page/24090573 | 24090573 | |
50837 | 50837 | 1931-10-24 | 8 | c | Thomas Edison dies. | America | http://trove.nla.gov.au/newspaper/page/24090573 | 24090573 | |
50818 | 50818 | 1931-10-17 | 8 | b | American to comment on the Manchuria issues. | America | http://trove.nla.gov.au/newspaper/page/24090565 | 24090565 | |
50765 | 50765 | 1931-10-03 | 8 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
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 | |
50706 | 50706 | 1931-09-12 | 8 | b | The Chinese Nationalist government purchases wheat from America for disasters relief. | America | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50661 | 50661 | 1931-08-29 | 8 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50660 | 50660 | 1931-08-29 | 8 | b | American Red Cross donates to the flooding victims in Hankou, China. | America | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50643 | 50643 | 1931-08-22 | 8 | c | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24090501 | 24090501 | |
50638 | 50638 | 1931-08-22 | 8 | b | Revolution in Cuba. | America | http://trove.nla.gov.au/newspaper/page/24090501 | 24090501 | |
50617 | 50617 | 1931-08-15 | 8 | b | Cuba authority destroys enemy's office. | America | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50616 | 50616 | 1931-08-15 | 8 | b | Foreign immigrants are leaving America. | America | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
50580 | 50580 | 1931-08-01 | 8 | c | The longest road in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50528 | 50528 | 1931-07-18 | 8 | b | American navy to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24090459 | 24090459 | |
50502 | 50502 | 1931-07-11 | 8 | b | Plea for help to the unemployed people in America. | America | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50499 | 50499 | 1931-07-11 | 8 | b | Hot weather in America. | America | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50476 | 50476 | 1931-07-04 | 8 | b | Heat wave in America. | America | http://trove.nla.gov.au/newspaper/page/24090443 | 24090443 | |
50453 | 50453 | 1931-06-27 | 8 | b | American president on the debts of war. | America | http://trove.nla.gov.au/newspaper/page/24090435 | 24090435 | |
50436 | 50436 | 1931-06-20 | 8 | d | Three more banks are closed down in America. | America | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
50431 | 50431 | 1931-06-20 | 8 | c | Proposals by the members of American House of Representatives to solve the economic crisis. | America | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
50424 | 50424 | 1931-06-20 | 8 | b | Banks closed in America. | America | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
50409 | 50409 | 1931-06-13 | 8 | b | Amalgamation of six major banks in America. | America | http://trove.nla.gov.au/newspaper/page/24090419 | 24090419 | |
50385 | 50385 | 1931-06-06 | 8 | c | Chinese man murdered in New York and the investigation. | America | http://trove.nla.gov.au/newspaper/page/24090411 | 24090411 | |
50384 | 50384 | 1931-06-06 | 8 | c | Naked men and women on a Chicago beach. | America | http://trove.nla.gov.au/newspaper/page/24090411 | 24090411 | |
50380 | 50380 | 1931-06-06 | 8 | b | American government in financial difficulty. | America | http://trove.nla.gov.au/newspaper/page/24090411 | 24090411 | |
50363 | 50363 | 1931-05-30 | 8 | d | A report prepared by the agricultural department of American government. | America | http://trove.nla.gov.au/newspaper/page/24090402 | 24090402 | |
50361 | 50361 | 1931-05-30 | 8 | c | Government of the Newfoundland and their debts. | America | http://trove.nla.gov.au/newspaper/page/24090402 | 24090402 | |
50359 | 50359 | 1931-05-30 | 8 | c | Workers in America destroy city office. | America | http://trove.nla.gov.au/newspaper/page/24090402 | 24090402 | |
50267 | 50267 | 1931-05-02 | 8 | b | American government increases charges of some services including air mail. | America | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
50265 | 50265 | 1931-05-02 | 8 | b | America recognises new government of Spain. | America | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
50242 | 50242 | 1931-04-25 | 8 | b | King of Thailand arrives America from Canada. | America | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 |
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]);