This data as json, CSV (advanced)
Link | rowid | date | page ▼ | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8806 | 8806 | 1901-10-12 | 2 | e | American government prohibits Chinese going to other countries via the United States. | America | http://trove.nla.gov.au/newspaper/page/24100193 | 24100193 | |
8831 | 8831 | 1901-10-16 | 2 | d | A racist organisation, White Boxers, hold a gathering in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8833 | 8833 | 1901-10-16 | 2 | e | Residents of Boston donated to the fund of ransom money needed to secure the freedom of a female American missionary. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8835 | 8835 | 1901-10-16 | 2 | e | A bridge in New York collapsed. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8924 | 8924 | 1901-10-26 | 2 | f | Total population on earth and in each continent. | America | http://trove.nla.gov.au/newspaper/page/24100209 | 24100209 | |
8983 | 8983 | 1901-11-02 | 2 | e | A preidiction published in a Washington newspaper about the future of East Asia. | America | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
9014 | 9014 | 1901-11-06 | 2 | e | A love story in San Francisco, America. | America | http://trove.nla.gov.au/newspaper/page/24100221 | 24100221 | |
9048 | 9048 | 1901-11-09 | 2 | e | Some sharks near the coast of America have been marked for study purpose. | America | http://trove.nla.gov.au/newspaper/page/24100225 | 24100225 | |
9080 | 9080 | 1901-11-13 | 2 | f | A smart girl with a disability in America. | America | http://trove.nla.gov.au/newspaper/page/24100229 | 24100229 | |
9104 | 9104 | 1901-11-16 | 2 | f | Japanese in Hawaii and Washington protest discriminatory immigration checks that the American government imposed. | America | http://trove.nla.gov.au/newspaper/page/24100233 | 24100233 | |
9105 | 9105 | 1901-11-16 | 2 | f | Several American customs officers were arrested for helping Chinese illegally enter America from Mexico. | America | http://trove.nla.gov.au/newspaper/page/24100233 | 24100233 | |
9161 | 9161 | 1901-11-23 | 2 | e | An American man seeks a partner through a newspaper. | America | http://trove.nla.gov.au/newspaper/page/24100241 | 24100241 | |
9235 | 9235 | 1901-12-04 | 2 | e | Russia's motives in Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24100253 | 24100253 | |
9240 | 9240 | 1901-12-04 | 2 | f | Chinese in Hawaii and San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24100253 | 24100253 | |
9355 | 9355 | 1901-12-18 | 2 | e | A German gentleman was beaten in an American pub for his comments on President McKinley. | America | http://trove.nla.gov.au/newspaper/page/24100269 | 24100269 | |
9396 | 9396 | 1901-12-21 | 2 | f | Chinese students in America, including Chen Jintao, Yan Jinrong, Xue Xianzhou, Wang Chonghui, Zhang Yujin, Wu Guiling, Hu Dongchao, and Wang Chongyou. | America | http://trove.nla.gov.au/newspaper/page/24100273 | 24100273 | |
9478 | 9478 | 1902-01-04 | 2 | e | Population of the United States of America, and numbers of Blacks, Chinese, Japanese, etc. | America | http://trove.nla.gov.au/newspaper/page/24100287 | 24100287 | |
9571 | 9571 | 1902-01-15 | 2 | e | Colombia University of America invited retired Chinese ambassador Wu Zhiyong to teach Chinese there. | America | http://trove.nla.gov.au/newspaper/page/24100299 | 24100299 | |
9575 | 9575 | 1902-01-15 | 2 | f | The amount of national debt in the world. | America | http://trove.nla.gov.au/newspaper/page/24100299 | 24100299 | |
9612 | 9612 | 1902-01-18 | 2 | e | Some Chinese in Honolulu are now still homeless as their houses were burned to ashes during the epidemic period. | America | http://trove.nla.gov.au/newspaper/page/24100303 | 24100303 | |
9682 | 9682 | 1902-01-25 | 2 | f | American government imposes stricter regulations to ban Chinese entry, a plea from Chinese communities in America to Chinese government, Guangdong governor and Chinese ambassador to Washington for help. | America | http://trove.nla.gov.au/newspaper/page/24100311 | 24100311 | |
9887 | 9887 | 1902-02-26 | 2 | e | Chinese ambassador to America Wu Tingfang protests against discrimination towards Chinese. | America | http://trove.nla.gov.au/newspaper/page/24100338 | 24100338 | |
9930 | 9930 | 1902-03-01 | 2 | f | Report on a gathering in San Francisco to ban Chinese. | America | http://trove.nla.gov.au/newspaper/page/24100342 | 24100342 | |
10013 | 10013 | 1902-03-15 | 2 | e | A meeting in San Francisco discussed the proposal to increasing immigration regulations and ban the entry of Chinese into the state. | America | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
10078 | 10078 | 1902-03-22 | 2 | f | American government sent 10 children to learn Chinese in their Beijing embassy. | America | http://trove.nla.gov.au/newspaper/page/24100364 | 24100364 | |
10079 | 10079 | 1902-03-22 | 2 | f | An anarchist party praised the man who murdered President McKinley, of the United States. | America | http://trove.nla.gov.au/newspaper/page/24100364 | 24100364 | |
10260 | 10260 | 1902-04-09 | 2 | f | New Year's greetings to Emperor Guangxu from Chinese communities in New Westminster, Victoria, Portland, San Francisco, Washington, and other north American cities. The greeting came by telegram. | America | http://trove.nla.gov.au/newspaper/page/24100384 | 24100384 | |
10361 | 10361 | 1902-04-19 | 2 | f | The Chinese Empire Reform Association in America held a celebration on the return of Emperor Guangxu to Beijing. | America | http://trove.nla.gov.au/newspaper/page/24100396 | 24100396 | |
10363 | 10363 | 1902-04-19 | 2 | f | An article, selected from the New China Times in Honolulu, warns overseas Xiangshan fellows the Portuguese have attempted to take control of their home county. | America | http://trove.nla.gov.au/newspaper/page/24100396 | 24100396 | |
10588 | 10588 | 1902-05-14 | 2 | e | American government has agreed to compensate the Chinese community in Honolulu for burning their houses during the period of epidemic. The compensation will be paid in instalments. | America | http://trove.nla.gov.au/newspaper/page/24100424 | 24100424 | |
10793 | 10793 | 1902-06-04 | 2 | f | Several girls have disappeared in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24100448 | 24100448 | |
10853 | 10853 | 1902-06-14 | 2 | e | Chinese ambassador to Washington, Wu Tingfang, resigns in protest of American immigration discrimination policy. | America | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
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 | |
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 | |
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 | |
12432 | 12432 | 1903-11-14 | 2 | d | Liang Qichao's speech in the USA. | America | http://trove.nla.gov.au/newspaper/page/26800325 | 26800325 | |
12559 | 12559 | 1903-12-12 | 2 | d | Kang Tongbi arrives Chicago and starts another Chinese women's association there. | America | http://trove.nla.gov.au/newspaper/page/26800341 | 26800341 | |
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 | |
12674 | 12674 | 1904-01-09 | 2 | d | Liang Qichao's visit to San Francisco. | America | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12675 | 12675 | 1904-01-09 | 2 | d | Chinese communities (societies/ associations) in San Francisco donate to establish a Guangdong school. | America | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
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 | |
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 | |
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 | |
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 | |
12908 | 12908 | 1904-03-19 | 2 | d | A telegram from the Chinese Empire Reform Association in California to the American Secretary of State. | America | http://trove.nla.gov.au/newspaper/page/26800395 | 26800395 | |
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 | |
13052 | 13052 | 1904-04-16 | 2 | d | Advantages for Japanese to win the war against Russia. | America | http://trove.nla.gov.au/newspaper/page/26800415 | 26800415 | |
13120 | 13120 | 1904-04-30 | 2 | d | Report and statistics of Japan's progress in the past decades. | America | http://trove.nla.gov.au/newspaper/page/26800425 | 26800425 | |
13203 | 13203 | 1904-05-14 | 2 | d | Chinese community in Honolulu welcomes Lun Beizi, an imperial relative and China's envoy to the St Louis Fair. | America | http://trove.nla.gov.au/newspaper/page/26800435 | 26800435 | |
13450 | 13450 | 1904-07-02 | 2 | d | An American journalist reports and comments on morale of Japanese people and the yellow peril. | America | http://trove.nla.gov.au/newspaper/page/26800470 | 26800470 | |
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 | |
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 | |
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 | |
13884 | 13884 | 1904-10-08 | 2 | c-d | Chinese students to meet in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/26800540 | 26800540 | |
13885 | 13885 | 1904-10-08 | 2 | d | More students from Hunan province arrive in America for university study. | America | http://trove.nla.gov.au/newspaper/page/26800540 | 26800540 | |
13886 | 13886 | 1904-10-08 | 2 | d | Chinese ambassador to Washington, Liang Zhendong, comments on Chinese community in America. | America | http://trove.nla.gov.au/newspaper/page/26800540 | 26800540 | |
13887 | 13887 | 1904-10-08 | 2 | d | Report on marriage between Japanese and Chinese immigrants in America. | America | http://trove.nla.gov.au/newspaper/page/26800540 | 26800540 | |
13888 | 13888 | 1904-10-08 | 2 | d | Several Chinese immigrants have been deported from Washington district. | America | http://trove.nla.gov.au/newspaper/page/26800540 | 26800540 | |
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 | |
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 | |
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 | |
19132 | 19132 | 1908-04-04 | 2 | c-d | Correspondence from America. New Chinese ambassador to America, Mexico, Peru and Cuba, Wu Tingfang, and his protege arrive in San Francisco. A list of the protege and Chinese consuls to Mexico, Peru, Cuba, New York, and Honolulu. | America | http://trove.nla.gov.au/newspaper/page/26801686 | 26801686 | |
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 | |
19315 | 19315 | 1908-05-09 | 2 | c-d | Correspondence from Hawaii. Liang Qinggui arrives in Honolulu on his tour to America for an investigation of overseas education and Chinese students. | America | http://trove.nla.gov.au/newspaper/page/26801726 | 26801726 | |
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 | |
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 | |
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 | |
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 | |
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 | |
22515 | 22515 | 1910-03-19 | 2 | c-d | Chinese immigrants suffers in the Wood House on an island outside of San Francisco. | America | http://trove.nla.gov.au/newspaper/page/26802561 | 26802561 | |
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 | |
22898 | 22898 | 1910-06-04 | 2 | c-d | Unionists in Santa Rose, America, organise boycott to Chinese business and the response of Chinese community. | 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 | |
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 | |
23292 | 23292 | 1910-08-13 | 2 | c-d | Correspondence from America/ Chinese students in American university and their excellent performance, such as Yang Boluo, Liu Jixian, Liu Yulan, Liu Yuliu, and Cao Chuanmei. Chinese girl Huang Qiongfeng sends her painting to the National Industrial Exposition in Nanjing. | America | http://trove.nla.gov.au/newspaper/page/26802730 | 26802730 | |
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 | |
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 | |
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 |
24382 | 24382 | 1911-03-04 | 2 | d | American news | Ma Zhou invented a way of measurement. | America | http://trove.nla.gov.au/newspaper/page/24091686 | 24091686 |
25094 | 25094 | 1911-10-07 | 2 | d | A woman director for American Coin Bureau | A woman is promoted director for American Coin Bureau. | America | http://trove.nla.gov.au/newspaper/page/24091947 | 24091947 |
25128 | 25128 | 1911-10-14 | 2 | d | Internal riots of the revolutionary party | Some internal riots occurred in Ally Association of San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24091956 | 24091956 |
26913 | 26913 | 1913-01-25 | 2 | d | American women equal right committee member calls for imitation of Chinese women clothing. | America | http://trove.nla.gov.au/newspaper/page/24092553 | 24092553 | |
28593 | 28593 | 1914-03-21 | 2 | d | Chinese community and the Chinese Society (zhong hua hui guan) in San Francisco writes to the Chinese authority in Beijing on the new immigration restrictions imposed by American parliament. The Chinese Society (zhong hua hui guan) in San Francisco writes to American President Woodrow Wilson and asks to lift the immigration restriction. | America | http://trove.nla.gov.au/newspaper/page/24093046 | 24093046 | |
29212 | 29212 | 1914-09-05 | 2 | d | A New York newspaper on Sun Yatsen and China. | America | http://trove.nla.gov.au/newspaper/page/24093236 | 24093236 | |
29364 | 29364 | 1914-11-07 | 2 | d | American newspaper and its report from Beijing on the China affairs (Japanese troops in Longkou, of Shandong province, and others). | America | http://trove.nla.gov.au/newspaper/page/24093312 | 24093312 | |
29743 | 29743 | 1915-03-13 | 2 | d | Anti-Yuan parties in America decide to help Yuan Shikai fight against foreign invasion. | America | http://trove.nla.gov.au/newspaper/page/24094769 | 24094769 | |
30251 | 30251 | 1915-07-10 | 2 | c-d | The process of Sino-Japan's negotiation. | America | http://trove.nla.gov.au/newspaper/page/24094905 | 24094905 | |
32832 | 32832 | 1918-01-05 | 2 | d-e | Japanese envoy speaks in New York and his insulting words on China. | America | http://trove.nla.gov.au/newspaper/page/24097123 | 24097123 | |
32852 | 32852 | 1918-01-12 | 2 | f | American farmers meet and request the government to employ some Chinese labourers. | America | http://trove.nla.gov.au/newspaper/page/24097131 | 24097131 |
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]);