This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29136 | 29136 | 1914-08-01 | 8 | b | A Chinese businessman is detained in the United States of America and wins his case in the court. | America | http://trove.nla.gov.au/newspaper/page/24093202 | 24093202 | |
50838 | 50838 | 1931-10-24 | 8 | d | A bank robbery in America. | America | http://trove.nla.gov.au/newspaper/page/24090573 | 24090573 | |
49208 | 49208 | 1930-05-31 | 8 | d | A cargo ship on fire in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 | |
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 | |
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 | |
56224 | 56224 | 1936-08-29 | 8 | e | A naked parade in New York. | America | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
49338 | 49338 | 1930-07-19 | 8 | c | A plane crashes in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24099713 | 24099713 | |
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 | |
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 | |
23251 | 23251 | 1910-07-30 | 8 | a-b | A report submitted by the Chinese Empire Reform Association in Chicago via Prince Zai Tao. | America | http://trove.nla.gov.au/newspaper/page/26802720 | 26802720 | |
55334 | 55334 | 1935-08-10 | 8 | a | A robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
47783 | 47783 | 1929-01-26 | 8 | b | A robbery in broad daylight in New York. | America | http://trove.nla.gov.au/newspaper/page/24099104 | 24099104 | |
47593 | 47593 | 1928-11-17 | 8 | a | A ship sinks near New York. | America | http://trove.nla.gov.au/newspaper/page/24099024 | 24099024 | |
48635 | 48635 | 1929-11-09 | 8 | e | A survey on rich men and women in America. | America | http://trove.nla.gov.au/newspaper/page/24099427 | 24099427 | |
50409 | 50409 | 1931-06-13 | 8 | b | Amalgamation of six major banks in America. | America | http://trove.nla.gov.au/newspaper/page/24090419 | 24090419 | |
50661 | 50661 | 1931-08-29 | 8 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50765 | 50765 | 1931-10-03 | 8 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50143 | 50143 | 1931-03-28 | 8 | b | America has more storage of gold than any other countries. | America | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
30007 | 30007 | 1915-05-01 | 8 | c | America is to send a business delegation to China. | America | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 | |
50265 | 50265 | 1931-05-02 | 8 | b | America recognises new government of Spain. | America | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
55220 | 55220 | 1935-06-22 | 8 | e | America to expand its naval forces. | America | http://trove.nla.gov.au/newspaper/page/24096479 | 24096479 | |
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 | |
30112 | 30112 | 1915-05-29 | 8 | b | American Airship Company is to send Chen Xuda to China to open a pilot training school. | America | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
49913 | 49913 | 1931-01-17 | 8 | c | American House of Representatives on the China policy. | America | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
49647 | 49647 | 1930-11-01 | 8 | c | American President Hoover bans weapon sales to rebellions in Brazil. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
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 | |
52473 | 52473 | 1933-01-28 | 8 | a | American President Roosevelt and his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
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 | |
49910 | 49910 | 1931-01-17 | 8 | b | American President is optimistic for the future of employment. | America | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
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 | |
56477 | 56477 | 1936-12-05 | 8 | b | American authority destroy drugs. | America | http://trove.nla.gov.au/newspaper/page/24097091 | 24097091 | |
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 | |
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 | |
48508 | 48508 | 1929-09-28 | 8 | d | American coast guards detain British ship for illegal wines. | America | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
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 | |
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 | |
51023 | 51023 | 1931-12-16 | 8 | b | American government delivers its notes to Japan. | America | |||
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 | |
49934 | 49934 | 1931-01-24 | 8 | b | American government has new policy against the communist movement. | America | http://trove.nla.gov.au/newspaper/page/24090254 | 24090254 | |
49650 | 49650 | 1930-11-01 | 8 | c | American government helps the unemployed. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
50148 | 50148 | 1931-03-28 | 8 | c | American government in deficit. | America | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50380 | 50380 | 1931-06-06 | 8 | b | American government in financial difficulty. | America | http://trove.nla.gov.au/newspaper/page/24090411 | 24090411 | |
50870 | 50870 | 1931-11-07 | 8 | b | American government in financial shortage. | America | http://trove.nla.gov.au/newspaper/page/24090589 | 24090589 | |
51606 | 51606 | 1932-06-11 | 8 | a | American government increase tax rates. | America | http://trove.nla.gov.au/newspaper/page/24090838 | 24090838 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
51142 | 51142 | 1932-01-30 | 8 | c | American government to expand their naval forces. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
29222 | 29222 | 1914-09-05 | 8 | a | American immigration authority maltreats Chinese delegation who are on their way to the Panama Exhibition, and the report. | America | http://trove.nla.gov.au/newspaper/page/24093242 | 24093242 | |
51240 | 51240 | 1932-02-27 | 8 | e | American naval fleet in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24090718 | 24090718 | |
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 | |
49648 | 49648 | 1930-11-01 | 8 | c | American navy to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
50528 | 50528 | 1931-07-18 | 8 | b | American navy to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24090459 | 24090459 | |
49843 | 49843 | 1930-12-27 | 8 | c | American parliament appropriates funds for disaster relief. | America | http://trove.nla.gov.au/newspaper/page/24099899 | 24099899 | |
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 | |
50122 | 50122 | 1931-03-21 | 8 | b | American people and their income. | America | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
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 | |
29415 | 29415 | 1914-11-21 | 8 | a | American people on the arbitration treaty between China and the United States. | America | http://trove.nla.gov.au/newspaper/page/24093336 | 24093336 | |
29532 | 29532 | 1915-01-02 | 8 | c | American president goes to Panama Canal for a sport contest for celebrating the canal's starting service. | America | http://trove.nla.gov.au/newspaper/page/24094677 | 24094677 | |
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 | |
50453 | 50453 | 1931-06-27 | 8 | b | American president on the debts of war. | America | http://trove.nla.gov.au/newspaper/page/24090435 | 24090435 | |
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 | |
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 | |
19188 | 19188 | 1908-04-11 | 8 | a-b | American secretary of industry and commerce reports to the parliament. The report covers issues such as Chinese immigration, trade statistics between China and America, and number of Chinese immigrants in the United States. | America | http://trove.nla.gov.au/newspaper/page/26801700 | 26801700 | |
50043 | 50043 | 1931-02-28 | 8 | a | American senate on the economic recession. | America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50818 | 50818 | 1931-10-17 | 8 | b | American to comment on the Manchuria issues. | America | http://trove.nla.gov.au/newspaper/page/24090565 | 24090565 | |
48526 | 48526 | 1929-10-05 | 8 | c | American woman is imprisoned for driving without licence. | America | http://trove.nla.gov.au/newspaper/page/24099387 | 24099387 | |
48269 | 48269 | 1929-07-06 | 8 | a | Amount of loans from America. | America | http://trove.nla.gov.au/newspaper/page/24099278 | 24099278 | |
50150 | 50150 | 1931-03-28 | 8 | c | An American woman and her donations to the missionary work in China. | America | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
22581 | 22581 | 1910-03-26 | 8 | a | An open letter from Chinese Empire Reform Association in St Louise, America, regarding Zhenhua company and the murder of Liu Shiji. | America | http://trove.nla.gov.au/newspaper/page/26802575 | 26802575 | |
22584 | 22584 | 1910-03-26 | 8 | c-d | An open letter from the Chinese Empire Reform Association in Washington and Boston regarding the Zhenhua company and other relevant issues. | America | http://trove.nla.gov.au/newspaper/page/26802575 | 26802575 | |
50867 | 50867 | 1931-11-07 | 8 | b | Another bank collapses in America. | America | http://trove.nla.gov.au/newspaper/page/24090589 | 24090589 | |
51109 | 51109 | 1932-01-23 | 8 | b | Another bank collapses in America. | America | http://trove.nla.gov.au/newspaper/page/24090676 | 24090676 | |
49821 | 49821 | 1930-12-20 | 8 | b | Another big bank in America goes bankruptcy. | America | http://trove.nla.gov.au/newspaper/page/24099892 | 24099892 | |
51308 | 51308 | 1932-03-19 | 8 | a | Anti-Japanese demonstration in America. | America | http://trove.nla.gov.au/newspaper/page/24090742 | 24090742 | |
51368 | 51368 | 1932-04-02 | 8 | b | Anti-Japanese movement in America. | America | http://trove.nla.gov.au/newspaper/page/24090758 | 24090758 | |
51870 | 51870 | 1932-09-03 | 8 | b | Attitude of the American government towards Japan. | America | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
49103 | 49103 | 1930-04-26 | 8 | c | Banditry in America. | America | http://trove.nla.gov.au/newspaper/page/24099617 | 24099617 | |
48870 | 48870 | 1930-02-08 | 8 | c | Banditry in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099525 | 24099525 | |
47879 | 47879 | 1929-03-09 | 8 | a | Bandits and robberies in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099144 | 24099144 | |
50189 | 50189 | 1931-04-11 | 8 | b | Bandits and robberies in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
48896 | 48896 | 1930-02-15 | 8 | d | Bandits arrested in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099533 | 24099533 | |
48013 | 48013 | 1929-04-13 | 8 | b | Bandits in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
47465 | 47465 | 1928-09-29 | 8 | a | Bandits in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24098968 | 24098968 | |
47500 | 47500 | 1928-10-13 | 8 | b | Bandits in New York. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47305 | 47305 | 1928-08-04 | 8 | a | Bandits rob shops in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
50424 | 50424 | 1931-06-20 | 8 | b | Banks closed in America. | America | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
48728 | 48728 | 1929-12-14 | 8 | d | Bomb explosion in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099469 | 24099469 | |
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 | |
49754 | 49754 | 1930-11-29 | 8 | b | British ambassador requests Peruvian government to protect foreigners during the chaos. | America | http://trove.nla.gov.au/newspaper/page/24099868 | 24099868 | |
50208 | 50208 | 1931-04-18 | 8 | b | Brother of Emperor of Japan escapes from an attack on his arrival in New York. | America | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
56199 | 56199 | 1936-08-22 | 8 | d | Bush fire in America. | America | http://trove.nla.gov.au/newspaper/page/24096968 | 24096968 | |
27781 | 27781 | 1913-08-23 | 8 | b | Chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24092799 | 24092799 | |
47694 | 47694 | 1928-12-22 | 8 | a | Chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
29629 | 29629 | 1915-01-23 | 8 | b | China Associations in America are against Chinese government's plan of making loans from American capitalists. | America | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 | |
23940 | 23940 | 1910-12-03 | 8 | c | Chinese Empire Reform Association in the east of America welcomes Zai Xun. | America | http://trove.nla.gov.au/newspaper/page/26802864 | 26802864 | |
29289 | 29289 | 1914-10-03 | 8 | a-b | Chinese Masonic Society (hong men) in San Francisco refuses to cooperate with Sun Yatsen for his Third Revolution. American expert on the revolutionary movement in China. | America | http://trove.nla.gov.au/newspaper/page/24093276 | 24093276 |
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]);