This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4837 | 4837 | 1900-03-28 | 2 | a | A letter from Chinese Society in San Francisco to Liang Qichao regarding his security concerns if he wanted to visit America. | America | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
11871 | 11871 | 1903-05-23 | 2 | a | An article, written by Li Hongzhang's private doctor, on the separatist regime and the building of a new dynasty in China. | America | http://trove.nla.gov.au/newspaper/page/26800228 | 26800228 | |
12706 | 12706 | 1904-01-23 | 2 | a | First part of Liang Qichao's article on boundaries of family clans and native regions, published in a San Francisco Chinese newspaper. | America | http://trove.nla.gov.au/newspaper/page/26800365 | 26800365 | |
12761 | 12761 | 1904-02-06 | 2 | a | Third part of Liang Qichao's article on boundaries of family clans and native regions, published in a San Francisco Chinese newspaper. | America | http://trove.nla.gov.au/newspaper/page/26800372 | 26800372 | |
12786 | 12786 | 1904-02-13 | 2 | a | Fourth and final part of Liang Qichao's article on boundaries of family clans and native regions, published in a San Francisco Chinese newspaper. | America | http://trove.nla.gov.au/newspaper/page/26800377 | 26800377 | |
12893 | 12893 | 1904-03-19 | 2 | a | First part of a letter from Huang Haochen, published in a San Francisco Chinese newspaper, to the Chinese Empire Reform Association in Honolulu in regards to Chinese students in America. | America | http://trove.nla.gov.au/newspaper/page/26800395 | 26800395 | |
13513 | 13513 | 1904-07-16 | 2 | a | First part of a report on Sun Yatsen's arrival in San Francisco from Honolulu, his passport, customs inspection, his speech and advocation of revolution. Chinese consul general in San Francisco writes to Chinese newspapers there regarding Sun Yatsen. | America | http://trove.nla.gov.au/newspaper/page/26800480 | 26800480 | |
13881 | 13881 | 1904-10-08 | 2 | a | Second part of a report, published by a Chinese newspaper in San Francisco, on the Chinese exhibition on the international fair in St Louis. | America | http://trove.nla.gov.au/newspaper/page/26800540 | 26800540 | |
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 | |
55682 | 55682 | 1935-12-28 | 2 | a | American businessmen sell oil to Italy. | America | http://trove.nla.gov.au/newspaper/page/24096696 | 24096696 | |
12574 | 12574 | 1903-12-19 | 2 | a-b | Liang Qichao's visit to Los Angeles. Liang's speech there. The Chinese Empire Reform Association and its activities. | America | http://trove.nla.gov.au/newspaper/page/26800345 | 26800345 | |
12734 | 12734 | 1904-01-30 | 2 | a-b | Second part of Liang Qichao's article on boundaries of family clans and native regions, published in a San Francisco Chinese newspaper. | America | http://trove.nla.gov.au/newspaper/page/26800369 | 26800369 | |
12922 | 12922 | 1904-03-26 | 2 | a-b | Second and final part of a letter from Huang Haochen, published in a San Francisco Chinese newspaper, to the Chinese Empire Reform Association in Honolulu in regards to Chinese students in America. | America | http://trove.nla.gov.au/newspaper/page/26800400 | 26800400 | |
13540 | 13540 | 1904-07-23 | 2 | a-b | Second and final part of the report on Sun Yatsen's arrival in San Francisco from Honolulu, his passport, customs inspection, his speech and advocation of revolution. Chinese consul general in San Francisco writes to Chinese newspapers there regarding Sun Yatsen. | America | http://trove.nla.gov.au/newspaper/page/26800485 | 26800485 | |
13859 | 13859 | 1904-10-01 | 2 | a-b | First part of a report, published by a Chinese newspaper in San Francisco, on the Chinese exhibition in the international fair in St Louis. | America | http://trove.nla.gov.au/newspaper/page/26800535 | 26800535 | |
14052 | 14052 | 1904-12-10 | 2 | a-b | An editorial, selected from a Chinese newspaper in Hawaii, comments on the practice of cutting pigtails and changes to dress in China. | America | http://trove.nla.gov.au/newspaper/page/26800585 | 26800585 | |
17204 | 17204 | 1907-04-06 | 2 | a-b | Editorial. A brief history of the Chinese Empire Reform Association, selected from New China News (xin zhongguo bao) of Hawaii. | America | http://trove.nla.gov.au/newspaper/page/26801283 | 26801283 | |
19547 | 19547 | 1908-06-27 | 2 | a-b | Chinese ambassador to America Wu Tingfang speaks to the Confucianism promotion society in New York. | America | http://trove.nla.gov.au/newspaper/page/26801784 | 26801784 | |
20941 | 20941 | 1909-04-24 | 2 | a-b | Chinese community in New York organises a society to help Chinese naval rejuvenation (zhen xing hai jun she), the notice from the society, its management committee, and name list of the shareholders of zhenhua company in Guangxi province. | America | http://trove.nla.gov.au/newspaper/page/26802158 | 26802158 | |
22289 | 22289 | 1910-01-22 | 2 | a-b | First part of a petition from the Chinese Empire Reform Association in America suggests that the ban on gambling should be completed before any fundraising for naval rebuilding. | America | http://trove.nla.gov.au/newspaper/page/26802472 | 26802472 | |
22443 | 22443 | 1910-03-05 | 2 | a-b | A warning notice to Ye En from Huang Shichu and other members of the Chinese Empire Reform Association in America. | America | http://trove.nla.gov.au/newspaper/page/26802544 | 26802544 | |
22475 | 22475 | 1910-03-12 | 2 | a-b | A report prepared by Wu Hongkui and 20 other Chinese businessmen in America on the crimes committed by Ye En, Ou Jujia and Liang Shaoxian. | America | http://trove.nla.gov.au/newspaper/page/26802552 | 26802552 | |
22857 | 22857 | 1910-05-28 | 2 | a-b | First part of the open letter from the Chinese Empire Reform Association in Honolulu to Prince Zai Tao. | America | http://trove.nla.gov.au/newspaper/page/26802641 | 26802641 | |
22892 | 22892 | 1910-06-04 | 2 | a-b | Second and final part of the open letter from the Chinese Empire Reform Association in Honolulu to Prince Zai Tao. | America | http://trove.nla.gov.au/newspaper/page/26802650 | 26802650 | |
22930 | 22930 | 1910-06-11 | 2 | a-b | First part of a petition submitted by the Chinese Empire Reform Association in America via Prince Zai Tao requests to set up the national parliament as soon as possible. | America | http://trove.nla.gov.au/newspaper/page/26802658 | 26802658 | |
23093 | 23093 | 1910-07-09 | 2 | a-b | Chinese Society in New York submits a petition via visiting Prince Zai Tao which requests to organise national parliament as soon as possible. | America | http://trove.nla.gov.au/newspaper/page/26802690 | 26802690 | |
23983 | 23983 | 1910-12-17 | 2 | a-b | A petition from the Chinese Empire Reform Association in Chicago to Prince Zai Xun for the establishment of national parliament and the lift of ban on political parties. | America | http://trove.nla.gov.au/newspaper/page/26802874 | 26802874 | |
24066 | 24066 | 1910-12-31 | 2 | a-b | A petition from Chinese communities in America, Canada and Mexico to Prince Zai Xun for the establishment of national parliament. | America | http://trove.nla.gov.au/newspaper/page/26802890 | 26802890 | |
4838 | 4838 | 1900-03-28 | 2 | a-c | Liang Qichao's letter replying to the Chinese Society in San Francisco in regard to his security concern. | America | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
5142 | 5142 | 1900-05-05 | 2 | a-c | Yang Gu, China's consul to Honolulu, issues a notice advising the Chinese community to stay away from Chinese Empire Reform Association. This article, written by anonymous author, comments on this notice. | America | http://trove.nla.gov.au/newspaper/page/24102792 | 24102792 | |
5737 | 5737 | 1900-07-25 | 2 | a-c | A letter from Chinese Empire Reform Association in San Francisco, America, to Li Hongzhang, Governor of Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24102886 | 24102886 | |
22317 | 22317 | 1910-01-29 | 2 | a-c | Second and final part of the petition from the Chinese Empire Reform Association in America suggests that the ban on gambling should be completed before any fundraising for naval rebuilding. | America | http://trove.nla.gov.au/newspaper/page/26802480 | 26802480 | |
5671 | 5671 | 1900-07-14 | 2 | b | The third part of the report on Liang Qichao's visit to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102874 | 24102874 | |
11875 | 11875 | 1903-05-23 | 2 | b | Wang Chonghui, Xue Xianzhou and dozens of other Chinese students have a hard life in America as Chinese government stopped providing them financial assistance. | America | http://trove.nla.gov.au/newspaper/page/26800228 | 26800228 | |
12737 | 12737 | 1904-01-30 | 2 | b | American ambassador to Korea says Russia is the biggest threat in northeast Asia. | America | http://trove.nla.gov.au/newspaper/page/26800369 | 26800369 | |
23094 | 23094 | 1910-07-09 | 2 | b | Complimentary address by Prince Zai Tao to the Chinese community in New York. | America | http://trove.nla.gov.au/newspaper/page/26802690 | 26802690 | |
44367 | 44367 | 1926-01-30 | 2 | b | Chinese envoy Wang Zhengting in America talks to Tong Xixiang, representative of the Chinese community in San Francisco, on the autonomy of tariff in China. | America | http://trove.nla.gov.au/newspaper/page/24101439 | 24101439 | |
47377 | 47377 | 1928-09-01 | 2 | b | First part of a speech by Dr Chen Huanzhang in San Francisco on the quintessence of Confucianism. | America | http://trove.nla.gov.au/newspaper/page/24098930 | 24098930 | |
47396 | 47396 | 1928-09-08 | 2 | b | Second part of the speech by Dr Chen Huanzhang in San Francisco on the quintessence of Confucianism. | America | http://trove.nla.gov.au/newspaper/page/24098938 | 24098938 | |
47418 | 47418 | 1928-09-15 | 2 | b | Third and final part of the speech by Dr Chen Huanzhang in San Francisco on the quintessence of Confucianism. | America | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
47910 | 47910 | 1929-03-23 | 2 | b | The future prospect of industry in China, article selected from an English newspaper in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24099154 | 24099154 | |
48426 | 48426 | 1929-09-07 | 2 | b | Communist activists demonstrate at the front of the Chinese Consulate-General in San Francisco and the arrests (American, Russian, Hungarian, Greek, Italian, Japanese, and Chinese nationals). | America | http://trove.nla.gov.au/newspaper/page/24099349 | 24099349 | |
49365 | 49365 | 1930-08-02 | 2 | b | Foreword written by Ms Kuang Yukei for the monthly magazine Confucianism published in America. | America | http://trove.nla.gov.au/newspaper/page/24099723 | 24099723 | |
4985 | 4985 | 1900-04-18 | 2 | b-c | Chinese Empire Reform Association in the Chinese community of Honolulu; responses of the Chinese diplomatic mission there, including consuls Yang Gu and Bi Mai. | America | http://trove.nla.gov.au/newspaper/page/24102771 | 24102771 | |
5590 | 5590 | 1900-07-04 | 2 | b-c | The first part of a report on Liang Qichao's tour to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102862 | 24102862 | |
5613 | 5613 | 1900-07-07 | 2 | b-c | The San Francisco authority considers closing Chinatown there as they suspect epidemics have been found in the Chinese community. | America | http://trove.nla.gov.au/newspaper/page/24102866 | 24102866 | |
8387 | 8387 | 1901-08-24 | 2 | b-c | A letter from San Francisco reporting that an American scholar is trying to help the Emperor of China to resume power. | America | http://trove.nla.gov.au/newspaper/page/24100144 | 24100144 | |
17795 | 17795 | 1907-07-20 | 2 | b-c | News about Chinese Empire Reform Association. Mexico Chinese Bank draws dividends and notice from the bank management committee. | America | http://trove.nla.gov.au/newspaper/page/26801404 | 26801404 | |
23670 | 23670 | 1910-10-22 | 2 | b-c | A letter from the Chinese Empire Reform Association in America to Prince Zai Xun. | America | http://trove.nla.gov.au/newspaper/page/26802810 | 26802810 | |
23902 | 23902 | 1910-12-03 | 2 | b-c | Correspondence from America/ Wang Yitang is returning after a visit to America. Sa Zhenbing's son returns after graduation from an American university majored in railway engineering. Zhang Yuanji (Jusheng) arrives America from Europe. Five Chinese officials arrive America from Europe for a legal investigation. | America | http://trove.nla.gov.au/newspaper/page/26802858 | 26802858 | |
38090 | 38090 | 1922-01-07 | 2 | b-c | Foreign delegates to the Washington Conference want to see a unified China. | America | http://trove.nla.gov.au/newspaper/page/24093815 | 24093815 | |
40311 | 40311 | 1923-09-01 | 2 | b-c | Second and final part of a report on that the Chinese communities in California welcome education delegation from China to the world education conference (zhong hua hui guan, Chinese Chamber of Commerce, Chenzhong Chinese school, Chinese Students Association in California, Chinese Students Association in Stanford University, Chinese Youth Club, St Mary School, and other Chinese associations). | America | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
45702 | 45702 | 1927-05-14 | 2 | b-c | Current situation in China and the trade with the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
46699 | 46699 | 1928-02-04 | 2 | b-c | An article selected from Chicago Tribune says America should not maintain its privileges in China by force, and should seek friendship relations with China. | America | http://trove.nla.gov.au/newspaper/page/24098680 | 24098680 | |
8738 | 8738 | 1901-10-05 | 2 | b-d | The first part of a letter, prepared by Huang Liang, Zhong Muxian and the Chinese Empire Reform Association in Honolulu, to Tao Mo, governor of Guangdong province. | America | http://trove.nla.gov.au/newspaper/page/24100185 | 24100185 | |
38562 | 38562 | 1922-04-15 | 2 | b-e | Treaties signed at the Washington Conference. Treaty on Chinese tariff. Closing ceremony of the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093936 | 24093936 | |
4986 | 4986 | 1900-04-18 | 2 | c | The USA has significantly increased its military budget. | America | http://trove.nla.gov.au/newspaper/page/24102771 | 24102771 | |
5614 | 5614 | 1900-07-07 | 2 | c | The second part of the report on Liang Qichao's tour to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102866 | 24102866 | |
5720 | 5720 | 1900-07-21 | 2 | c | The fourth part of the report on Liang Qichao's visit to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102882 | 24102882 | |
6016 | 6016 | 1900-09-08 | 2 | c | Russian ambassador to Washington talks to American Secretary of State about withdrawing troops from China. | America | http://trove.nla.gov.au/newspaper/page/24102939 | 24102939 | |
6280 | 6280 | 1900-10-13 | 2 | c | Honolulu issues a new regulation which prohibits young girls going on the streets during night. | America | http://trove.nla.gov.au/newspaper/page/24102983 | 24102983 | |
8452 | 8452 | 1901-08-31 | 2 | c | Japanese government and Japanese residents in Honolulu protest medical examination before their landing. | America | http://trove.nla.gov.au/newspaper/page/24100152 | 24100152 | |
8766 | 8766 | 1901-10-09 | 2 | c | The second part of a letter, prepared by Huang Liang, Zhong Muxian and the Chinese Empire Reform Association in Honolulu, to Tao Mo, governor of Guangdong province. | America | http://trove.nla.gov.au/newspaper/page/24100189 | 24100189 | |
11618 | 11618 | 1903-03-14 | 2 | c | American engineer comments on the railway building from Hankou to Guangzhou. | America | http://trove.nla.gov.au/newspaper/page/26800187 | 26800187 | |
18605 | 18605 | 1907-12-14 | 2 | c | Correspondence from America. Newly arrived Chinese students in the United States and their supervisors, including Song sisters (Song Meiling). Chinese students in America publish academic bulletin. Chinese students in west America are fighting for sovereignty of China. | America | http://trove.nla.gov.au/newspaper/page/26801572 | 26801572 | |
18781 | 18781 | 1908-01-18 | 2 | c | Chinese consul in Honolulu is detained for involvement in gambling. | America | http://trove.nla.gov.au/newspaper/page/26801612 | 26801612 | |
19314 | 19314 | 1908-05-09 | 2 | c | Correspondence from America. Wu Caiji, a native of Xinning county and now medical practitioner in the United States, donates all his savings to help China. | America | http://trove.nla.gov.au/newspaper/page/26801726 | 26801726 | |
21762 | 21762 | 1909-10-09 | 2 | c | Body of a white woman is found upstairs of a Chinese restaurant in New York; nine Chinese migrants in America have been murdered since the discovery. | America | http://trove.nla.gov.au/newspaper/page/26802352 | 26802352 | |
24147 | 24147 | 1911-01-14 | 2 | c | Please look at how badly huaqiao (overseas Chinese) are treated in America | Chinese now enter San Fransico are forced to go through a humiliated medical check to see if they have any hookworm-related disease. The committed of the Chinese Masonic Association, including Xu Bienfen, Li Baoshen, Huang Shanghu, Tang Rui sent a cable to ask Chinese commissioner to protect their welfare. | America | http://trove.nla.gov.au/newspaper/page/24091597 | 24091597 |
36825 | 36825 | 1921-04-09 | 2 | c | An American senator proposed that the government should help transport grain donations to the famine region in north China. | America | http://trove.nla.gov.au/newspaper/page/24093501 | 24093501 | |
36992 | 36992 | 1921-05-21 | 2 | c | China and the League of Nations, a further report. | America | http://trove.nla.gov.au/newspaper/page/24093549 | 24093549 | |
37696 | 37696 | 1921-10-15 | 2 | c | American newspaper comments on the Washington Conference and its possible influence upon China. | America | http://trove.nla.gov.au/newspaper/page/24093719 | 24093719 | |
37958 | 37958 | 1921-12-10 | 2 | c | Former American ambassador to Beijing comments on the Far Eastern issues. | America | http://trove.nla.gov.au/newspaper/page/24093783 | 24093783 | |
45655 | 45655 | 1927-04-30 | 2 | c | American government and the international disarmament conference. | America | http://trove.nla.gov.au/newspaper/page/24101964 | 24101964 | |
45656 | 45656 | 1927-04-30 | 2 | c | American people on their government's China policy. | America | http://trove.nla.gov.au/newspaper/page/24101964 | 24101964 | |
46061 | 46061 | 1927-08-20 | 2 | c | Chinese students in America and their nationalism. | America | http://trove.nla.gov.au/newspaper/page/24098496 | 24098496 | |
46975 | 46975 | 1928-04-28 | 2 | c | Zhen Yuguang, a native of Taishan and doctor in San Francisco, is deported for his love with an actress. | America | http://trove.nla.gov.au/newspaper/page/24098776 | 24098776 | |
47035 | 47035 | 1928-05-19 | 2 | c | American authority denies the entry of Song Qingling. | America | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47331 | 47331 | 1928-08-18 | 2 | c | Dr Chen Huanzhang arrives America and will tour Europe. | America | http://trove.nla.gov.au/newspaper/page/24098781 | 24098781 | |
47354 | 47354 | 1928-08-25 | 2 | c | Development of the aviation industry in America. | America | http://trove.nla.gov.au/newspaper/page/24098922 | 24098922 | |
47478 | 47478 | 1928-10-13 | 2 | c | American doctor on the control of population growth. | America | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
47527 | 47527 | 1928-10-27 | 2 | c | A case of kidnap in Hawaii and the ransom. | America | http://trove.nla.gov.au/newspaper/page/24098994 | 24098994 | |
47752 | 47752 | 1929-01-19 | 2 | c | Chinese communities in Hawaii participate in the government and political affairs and the performance of dentist Zheng Di'en. | America | http://trove.nla.gov.au/newspaper/page/24099090 | 24099090 | |
47883 | 47883 | 1929-03-16 | 2 | c | The Chinese Constitutionalist Party in the United States of America and their constitution. | America | http://trove.nla.gov.au/newspaper/page/24099146 | 24099146 | |
47988 | 47988 | 1929-04-13 | 2 | c | The Canada Morning, a Chinese newspaper owned by leftist Nationalist Party members in Canada, is closed down. | America | http://trove.nla.gov.au/newspaper/page/24099178 | 24099178 | |
48212 | 48212 | 1929-06-22 | 2 | c | Wheat crop failure in Soviet Russia. | America | http://trove.nla.gov.au/newspaper/page/24099256 | 24099256 | |
48313 | 48313 | 1929-07-27 | 2 | c | The Nationalist government in Nanjing bans import of Chinese newspapers from America. | America | http://trove.nla.gov.au/newspaper/page/24099296 | 24099296 | |
48406 | 48406 | 1929-08-31 | 2 | c | Further report on the arrest of Chinese deputy-consul's wife in San Francisco for opium smuggling. | America | http://trove.nla.gov.au/newspaper/page/24099341 | 24099341 | |
48456 | 48456 | 1929-09-14 | 2 | c | Fighting of the Chinese societies in the east of America. | America | http://trove.nla.gov.au/newspaper/page/24099357 | 24099357 | |
48475 | 48475 | 1929-09-21 | 2 | c | Chinese deputy-consul in San Francisco is returning to China with his wife who is charged with opium smuggling. | America | http://trove.nla.gov.au/newspaper/page/24099365 | 24099365 | |
48675 | 48675 | 1929-11-30 | 2 | c | Commemorations in America for the invention of electricity bulbs. | America | http://trove.nla.gov.au/newspaper/page/24099447 | 24099447 | |
49266 | 49266 | 1930-06-28 | 2 | c | A black man rape white woman in America and the aftermath. | America | http://trove.nla.gov.au/newspaper/page/24099683 | 24099683 | |
49325 | 49325 | 1930-07-19 | 2 | c | Fighting of the Chinese societies in the east of America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24099707 | 24099707 | |
49450 | 49450 | 1930-08-30 | 2 | c | Chinese antiquities on exhibition in the New York museum. | America | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49451 | 49451 | 1930-08-30 | 2 | c | More fighting between the Chinese societies in the east of America. | America | http://trove.nla.gov.au/newspaper/page/24099755 | 24099755 | |
49512 | 49512 | 1930-09-20 | 2 | c | Detailed report on the fighting of the Chinese societies in the east of America. | America | http://trove.nla.gov.au/newspaper/page/24099782 | 24099782 | |
49550 | 49550 | 1930-10-04 | 2 | c | Further report on the fighting between Chinese societies in the east of America. | America | http://trove.nla.gov.au/newspaper/page/24099798 | 24099798 | |
49572 | 49572 | 1930-10-11 | 2 | c | Further report on the fighting of Chinese societies in the east of America. | America | http://trove.nla.gov.au/newspaper/page/24099806 | 24099806 | |
49592 | 49592 | 1930-10-18 | 2 | c | Peace agreement signed by the Chinese societies in the east of America after a long fighting. | America | http://trove.nla.gov.au/newspaper/page/24099814 | 24099814 | |
49760 | 49760 | 1930-12-06 | 2 | c | Confucian Society set up in America and report on the ceremony. Presents for the Confucian Society. | America | http://trove.nla.gov.au/newspaper/page/24099870 | 24099870 |
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]);