This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54983 | 54983 | 1935-03-30 | 6 | b | China and America start flight service. | America | http://trove.nla.gov.au/newspaper/page/24096379 | 24096379 | |
54955 | 54955 | 1935-03-16 | 6 | a | Chinese national hero General Cai Tingkai visit Hawaii and the report. | America | http://trove.nla.gov.au/newspaper/page/24096363 | 24096363 | |
54869 | 54869 | 1935-02-09 | 6 | e | Diplomatic relations between America and Russia may break off. | America | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54865 | 54865 | 1935-02-09 | 6 | b | American government opposes to the establishment of an international court. | America | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54804 | 54804 | 1935-01-19 | 6 | a | National debt of the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 | |
54758 | 54758 | 1934-12-22 | 6 | c | American businessmen secure huge profit during the World War I. | America | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54755 | 54755 | 1934-12-22 | 6 | a | Japanese ambassador in Washington and his talks. | America | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
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 | |
54662 | 54662 | 1934-11-10 | 6 | d | Chinese labourers smuggled into New York. | America | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54634 | 54634 | 1934-10-27 | 6 | b | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24096212 | 24096212 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
54048 | 54048 | 1934-04-07 | 6 | d | Japanese purchase army provisions from America. | America | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54025 | 54025 | 1934-03-31 | 6 | e | The Philippines to become independent. | America | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
53918 | 53918 | 1934-03-03 | 6 | a | Heavy snow block traffic in America. | America | http://trove.nla.gov.au/newspaper/page/24091553 | 24091553 | |
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 | |
53812 | 53812 | 1934-01-27 | 6 | d | Japanese seek to colonise Chile. | America | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 | |
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 | |
53590 | 53590 | 1933-11-25 | 6 | d | America recognises the Soviet Russian government. | America | http://trove.nla.gov.au/newspaper/page/24091450 | 24091450 | |
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 | |
53402 | 53402 | 1933-10-14 | 6 | a | Bush fire in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24091402 | 24091402 | |
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 | |
53063 | 53063 | 1933-07-08 | 6 | c | American navy to build more basis. | America | http://trove.nla.gov.au/newspaper/page/24091290 | 24091290 | |
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 | |
52993 | 52993 | 1933-06-17 | 6 | d | Hot weather in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24091266 | 24091266 | |
52977 | 52977 | 1933-06-10 | 6 | e | American government lends loans to China. | America | http://trove.nla.gov.au/newspaper/page/24091258 | 24091258 | |
52869 | 52869 | 1933-05-13 | 6 | b | Russia and its open-door policy. | America | http://trove.nla.gov.au/newspaper/page/24091224 | 24091224 | |
52764 | 52764 | 1933-04-15 | 6 | c | American to convene an international conference on economic development. | 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 | |
52760 | 52760 | 1933-04-15 | 6 | a | American warplane crushes. | America | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
52733 | 52733 | 1933-04-01 | 6 | c | Japanese delegation arrives New York. | America | http://trove.nla.gov.au/newspaper/page/24091176 | 24091176 | |
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 | |
52677 | 52677 | 1933-03-18 | 6 | c | Earthquake in America. | America | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52675 | 52675 | 1933-03-18 | 6 | b | American President Roosevelt helps to save banks from bankruptcy. | America | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
52450 | 52450 | 1933-01-21 | 6 | d | American government reissues its Manchuria policy. | America | http://trove.nla.gov.au/newspaper/page/24091094 | 24091094 | |
45110 | 45110 | 1926-08-28 | 6 | c | A case of murder in the Chinese community of Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24101684 | 24101684 | |
45058 | 45058 | 1926-08-14 | 6 | b-c | Beautiful woman has a bath in wine in New York. | America | http://trove.nla.gov.au/newspaper/page/24101668 | 24101668 | |
44962 | 44962 | 1926-07-17 | 6 | c | Many Chinese are arrested in the United States of America and the report. | America | http://trove.nla.gov.au/newspaper/page/24101636 | 24101636 | |
44931 | 44931 | 1926-07-10 | 6 | d | Chinese communist activists are deported from Hungary. | America | http://trove.nla.gov.au/newspaper/page/24101628 | 24101628 | |
44560 | 44560 | 1926-03-27 | 6 | c-d | An exhibition in Philadelphia. | America | http://trove.nla.gov.au/newspaper/page/24101506 | 24101506 | |
44125 | 44125 | 1925-11-14 | 6 | a-c | American and Chinese Association (mei guo yuan hua hui) in San Francisco issues a declaration on the China affairs. | America | http://trove.nla.gov.au/newspaper/page/24101353 | 24101353 | |
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 | |
43891 | 43891 | 1925-09-26 | 6 | a | New American ambassador to Japan. | America | http://trove.nla.gov.au/newspaper/page/24101294 | 24101294 | |
43854 | 43854 | 1925-09-19 | 6 | b | More feud and fighting among Chinese communities in New York. | America | http://trove.nla.gov.au/newspaper/page/24101286 | 24101286 | |
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 | |
43766 | 43766 | 1925-09-05 | 6 | a-b | Feud and fierce fighting among the Chinese communities in New York, Chicago, Pittsburgh, Boston, St Louis and many other cities in America. | America | http://trove.nla.gov.au/newspaper/page/24101270 | 24101270 | |
42602 | 42602 | 1925-01-17 | 6 | b-c | Chinese community in America lists crimes committed by Sun Yatsen. | America | http://trove.nla.gov.au/newspaper/page/24101007 | 24101007 | |
41991 | 41991 | 1924-08-23 | 6 | c | Chinese students are barred from entry into America. | America | http://trove.nla.gov.au/newspaper/page/24100837 | 24100837 | |
41990 | 41990 | 1924-08-23 | 6 | b | American government issues new restriction on Chinese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100837 | 24100837 | |
41809 | 41809 | 1924-07-12 | 6 | b-d | The new restriction issued by American authority to the Chinese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
41504 | 41504 | 1924-05-03 | 6 | c-d | Head of Chinese secret society in Nevada, United States, is sentenced to death and executed in gas chamber, the first such case in America. | America | http://trove.nla.gov.au/newspaper/page/24100709 | 24100709 | |
41268 | 41268 | 1924-03-15 | 6 | d-e | The Philippines island and the obvious influence of Chinese culture, observed by American professor. | America | http://trove.nla.gov.au/newspaper/page/24100652 | 24100652 | |
40467 | 40467 | 1923-09-29 | 6 | b-c | The sale of public property in Guangdong, an article published in the World News (shi jie ri bao) in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24094564 | 24094564 | |
40436 | 40436 | 1923-09-22 | 6 | c-d | A Chinese newspaper in San Francisco, shi jie ri bao (World Daily), claims that Sun Yatsen is making trouble in Guangdong, murdering Guangdong people, and opening the door to robbers. | America | http://trove.nla.gov.au/newspaper/page/24094556 | 24094556 | |
40435 | 40435 | 1923-09-22 | 6 | b-c | A Chinese newspaper in New York, zhong guo wei xin bao, comments on the criticism about Sun Yatsen published in American English newspapers. | America | http://trove.nla.gov.au/newspaper/page/24094556 | 24094556 | |
40399 | 40399 | 1923-09-15 | 6 | c-d | An article published in a Honolulu Chinese newspaper claims that Sun Yatsen is trying to sell Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24094548 | 24094548 | |
40291 | 40291 | 1923-08-25 | 6 | a-b | Hawaiian authority bans for foreign language schools (Japanese, Chinese, Korean and Russian) and response of the ethnic communities. | America | http://trove.nla.gov.au/newspaper/page/24094524 | 24094524 | |
40163 | 40163 | 1923-07-28 | 6 | b-c | The China Mail Line Company Ltd, established by Chinese businessmen in America, is bankrupt, and its liner Nile has been auctioned. | America | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
40136 | 40136 | 1923-07-21 | 6 | d | American donation to the famine research in China. | America | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40048 | 40048 | 1923-06-30 | 6 | b | Chinese business communities protest against foreign intervention with Chinese internal politics. | America | http://trove.nla.gov.au/newspaper/page/24094460 | 24094460 | |
39334 | 39334 | 1923-01-27 | 6 | d | Hawaiian authority seeks to employ some Chinese labourers and the motives. | America | http://trove.nla.gov.au/newspaper/page/24094272 | 24094272 | |
38686 | 38686 | 1922-05-06 | 6 | c-d | War between Zhixi and Fengxi. Both Britain and Japan remain neutral. More report on the war. | America | http://trove.nla.gov.au/newspaper/page/24093966 | 24093966 | |
38685 | 38685 | 1922-05-06 | 6 | c | Japan withdraws its troops from the Qingdao-Jinan railway. | America | http://trove.nla.gov.au/newspaper/page/24093966 | 24093966 | |
38411 | 38411 | 1922-03-11 | 6 | c | A big fire in America and the damages. | America | http://trove.nla.gov.au/newspaper/page/24093900 | 24093900 | |
38335 | 38335 | 1922-02-25 | 6 | a-b | Second and final part of a translation on race and colour of the human beings. | America | http://trove.nla.gov.au/newspaper/page/24093884 | 24093884 | |
38300 | 38300 | 1922-02-18 | 6 | a | First part of a translation on race and colour of the human beings. | America | http://trove.nla.gov.au/newspaper/page/24093876 | 24093876 | |
38175 | 38175 | 1922-01-21 | 6 | c | Recent relation between China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24093835 | 24093835 | |
38106 | 38106 | 1922-01-07 | 6 | b | Flooding in Shandong province. | America | http://trove.nla.gov.au/newspaper/page/24093819 | 24093819 | |
38072 | 38072 | 1921-12-31 | 6 | c | Rebellion in Egypt. | America | http://trove.nla.gov.au/newspaper/page/24093811 | 24093811 | |
38071 | 38071 | 1921-12-31 | 6 | c | Miscellaneous report on Chinese problem from the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093811 | 24093811 | |
38009 | 38009 | 1921-12-17 | 6 | a | The United States, Great Britain, Japan, and France sign Four-Power Pact on Pacific question. | America | http://trove.nla.gov.au/newspaper/page/24093795 | 24093795 | |
37976 | 37976 | 1921-12-10 | 6 | b | The Washington Conference sees different opinions on the return of international concessions to Chinese government. | America | http://trove.nla.gov.au/newspaper/page/24093787 | 24093787 | |
37975 | 37975 | 1921-12-10 | 6 | a | Japanese want to invade Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24093787 | 24093787 | |
37974 | 37974 | 1921-12-10 | 6 | a | The Far Eastern affairs at the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093787 | 24093787 | |
37815 | 37815 | 1921-11-05 | 6 | c | Chinese government publishes its proposals on the Shandong problem. | America | http://trove.nla.gov.au/newspaper/page/24093747 | 24093747 | |
35696 | 35696 | 1920-05-15 | 6 | c | Air mail service starts between Tianjin and Beijing. | America | http://trove.nla.gov.au/newspaper/page/24098165 | 24098165 |
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]);