This data as json, CSV (advanced)
date (date) >30 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34166 | 34166 | 1919-02-08 | 17 | aa | Advertisement for Tattersall's Consultations, George Adams, Hobart, Tasmania. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34167 | 34167 | 1919-02-08 | 17 | a | Advertisement for Lewis & Whitty, 158 Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34168 | 34168 | 1919-02-08 | 17 | b | Advertisement for the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34169 | 34169 | 1919-02-08 | 17 | b | Advertisement for Yow Sang & Co, Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34170 | 34170 | 1919-02-08 | 17 | b | Advertisement for Chinese herbalist Zhong Dewan, a native of Xinhui in Sydney, by Guan Xiquan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34171 | 34171 | 1919-02-08 | 17 | b | Advertisement for Shanghai Cafe, Chinese chop suey house, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34172 | 34172 | 1919-02-08 | 17 | b | Advertisement for Rowan's Bond, York Street North, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34173 | 34173 | 1919-02-08 | 17 | b | Advertisement for W. Kerr, watchmaker & jeweller, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34174 | 34174 | 1919-02-08 | 17 | c | Advertisement for The Biff Manufacturing Co. Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34175 | 34175 | 1919-02-08 | 18 | a-b | Advertisement for The Wing On Co (Canton) Ltd, The Bund, Canton. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097615 | 24097615 | |
34176 | 34176 | 1919-02-08 | 19 | a | Advertisement for Mort's Dock & Engineering Company Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097614 | 24097614 | |
34177 | 34177 | 1919-02-08 | 19 | b | Advertisement for W. Gardiner & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097614 | 24097614 | |
34178 | 34178 | 1919-02-08 | 20 | a | Advertisement for Australian Oriental Line, G. S. Yuill & Co Ltd, Sydney (Australia to Hong Kong, via Queensland ports, Thursday Island, Sandakan and Manila). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097616 | 24097616 | |
34179 | 34179 | 1919-02-08 | supplement | one page | Chinese and English almanac, a supplement to the Chinese New Year special edition of the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097617 | 24097617 | |
34180 | 34180 | 1919-02-22 | 2 | a-c | Editorial by Tung Wah Times says China should stop internal fighting in order to deal with the outside threats. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097620 | 24097620 | |
34181 | 34181 | 1919-02-22 | 2 | c-d | Liang Qichao on China's declaration of war with Germany, the fourth part of the retrospect. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097620 | 24097620 | |
34182 | 34182 | 1919-02-22 | 2 | e | Chinese President Xu Shichang gives dinner to the Chinese delegation to the Paris Conference and his speech. | China | http://trove.nla.gov.au/newspaper/page/24097620 | 24097620 | |
34183 | 34183 | 1919-02-22 | 2 | e-f | Cai Yuanpei, Wang Chonghui and others to organise an association for constitutional reform in Beijing and the report. | China | http://trove.nla.gov.au/newspaper/page/24097620 | 24097620 | |
34184 | 34184 | 1919-02-22 | 2 | f | Obstacles to the peace talks in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097620 | 24097620 | |
34185 | 34185 | 1919-02-22 | 3 | a | China's motions to the Paris Peace Conference. | China | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34186 | 34186 | 1919-02-22 | 3 | a | Dutch ambassador in China leaves Beijing and why. | China | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34187 | 34187 | 1919-02-22 | 3 | b | Li Yuanhong suggests that China should dispatch some well-known people to lobby at the Paris Conference. | China | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34188 | 34188 | 1919-02-22 | 3 | b-c | Liang Qichao talks to French journalist before leaving Beijing for Paris. | China | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34189 | 34189 | 1919-02-22 | 3 | c | Japanese newspaper reports that Chinese delegation to the Paris conference and the reason. | Japan | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34190 | 34190 | 1919-02-22 | 3 | d | An association set up in Shanghai for the study of international peace. | China | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34191 | 34191 | 1919-02-22 | 3 | d | The whereabouts of Lu Zhengxiang and Wang Zhengting. | China | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34192 | 34192 | 1919-02-22 | 3 | e | China to set up an institute of history and to revise the treaty with Holland on the overseas Chinese affairs. | China | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34193 | 34193 | 1919-02-22 | 3 | e-f | War clouds over China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34194 | 34194 | 1919-02-22 | 3 | f | Territorial conflicts at the Paris Conference and China demands the return of Qingdao. | Britain | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34195 | 34195 | 1919-02-22 | 3 | f | Germany has new chancellor. | Other... | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34196 | 34196 | 1919-02-22 | 6 | a-c | A circular telegram issued by Qian Nengxun on the troops in Shaanxi and Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24097626 | 24097626 | |
34197 | 34197 | 1919-02-22 | 6 | c | Peace talks in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097626 | 24097626 | |
34198 | 34198 | 1919-02-22 | 7 | b | Australia news/ Chinese in Australia send protest telegram to Lu Zhengxiang, Chinese delegate to the Paris Conference, on the treaty with Japan and signed by Ye Bingnan, Chen Zhuchen, Zheng Fanchang, Yu Rong, Huang Laiwang, Liu Guangfu, Ye Tonggui, Kuang Xiuqiong, Chen Zanhua, Lin Dasan, Li Chu, Guo Jiexiu, Zhang Linsheng, Wu Zhaoquan, Wu Elou and Guo Shun. Chinese Chamber of Commerce in Sydney sends by protest telegram to the peace association in Nanjing on the treaty with Japan, and signed by Ye Bingnan and Zheng Fanchang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097625 | 24097625 | |
34199 | 34199 | 1919-02-22 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097625 | 24097625 | |
34200 | 34200 | 1919-02-22 | 8 | a-b | Names listed for donations to the Chinese Christian church on Goulburn Street, Sydney, where Rev. Liu Junchen is the priest. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097628 | 24097628 | |
34201 | 34201 | 1919-02-22 | 8 | b-c | Beijing news/ Chinese government engages Japanese adviser for the reform of currency system and the protest. Chinese government drafts a law for business income. China continues to deport German nationals. George Morrison, adviser of Chinese government, is on the way to Europe with secret diplomatic mission. Peace talks in China and the report from Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24097628 | 24097628 | |
34202 | 34202 | 1919-02-22 | 8 | c | Guangdong news/ French authority in the Guangzhou Bay imposes poll tax and the negotiation by the provincial governor. Provincial government appoints Tang Shaoyi representative to the peace talks. Police headquarters in Guangzhou on fire. Long Yuguang hides in Shanghai. Members of the third board of the Xinning railway and the bulletin. | China | http://trove.nla.gov.au/newspaper/page/24097628 | 24097628 | |
34203 | 34203 | 1919-03-01 | 2 | a-b | Editorial by Tung Wah Times comments on the appointment of Yuan Dai military adviser by the Chinese President Xu Shichang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34204 | 34204 | 1919-03-01 | 2 | b-c | Liang Qichao on China's declaration of war with Germany, the fifth part of the retrospect. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34205 | 34205 | 1919-03-01 | 2 | c-d | Foreign missions in Beijing meet for the peace in China and their advice. | China | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34206 | 34206 | 1919-03-01 | 2 | d | Bandits in Fujian province and the government's effort to suppress them. | China | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34207 | 34207 | 1919-03-01 | 2 | d-e | Lu Zhengxang on Chinese attitudes at the Paris peace conference. | Japan | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34208 | 34208 | 1919-03-01 | 2 | e | The difference between the old and the new parliament in China. | China | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34209 | 34209 | 1919-03-01 | 2 | e-f | Chinese government delivers instructions to Lu Zhengxiang, its delegate to the Paris peace conference. | China | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
34210 | 34210 | 1919-03-01 | 3 | a | Japanese cabinet may reconsider its China policy. Western newspaper says that Japan should give up the twenty-one demands to China, part I. | Japan | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34211 | 34211 | 1919-03-01 | 3 | b | Foreign newspaper reports the peace talks in China between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34212 | 34212 | 1919-03-01 | 3 | b-c | Chinese educational authority to standardise the pronunciation of the Chinese characters. | China | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34213 | 34213 | 1919-03-01 | 3 | c-e | Chinese government to reform its tariff policy and the report. | China | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34214 | 34214 | 1919-03-01 | 3 | e | Fujian governor Li Houji asks for help from the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34215 | 34215 | 1919-03-01 | 3 | f | Report from the Paris peace conference. | France | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34216 | 34216 | 1919-03-01 | 3 | e | Epidemic in Japan and the casualties. | Japan | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34217 | 34217 | 1919-03-01 | 3 | f | Number of French people die in the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34218 | 34218 | 1919-03-01 | 3 | f | French prime minister is injured in an assassination. | Britain | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34219 | 34219 | 1919-03-01 | 3 | f | Prosperity of shipping industry in Japan. | America | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34220 | 34220 | 1919-03-01 | 3 | f | Speedy plane in America (from New York to Washington). | America | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34221 | 34221 | 1919-03-01 | 3 | f | The Bolshevik Party in Russia dispatches activists to China and India. | Britain | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34222 | 34222 | 1919-03-01 | 3 | f | Peace talks starts in China between the south and the north. | Britain | http://trove.nla.gov.au/newspaper/page/24097629 | 24097629 | |
34223 | 34223 | 1919-03-01 | 6 | a-b | First part of an appeal issued by Kang Youwei for peace talks in China between the south and the north in correspondence with the world peace effort. | China | http://trove.nla.gov.au/newspaper/page/24097634 | 24097634 | |
34224 | 34224 | 1919-03-01 | 6 | c | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24097634 | 24097634 | |
34225 | 34225 | 1919-03-01 | 7 | a-b | Australia news/ The New South Wales Chinese Chamber of Commerce to elect new committee members. Flu in Sydney and the casualties. School teachers in Sydney request earlier return of their students. Chinese businessman in Sydney Yang Meicheng dies from flu. Gibbs Bright & Co to resume its liner service from Australia to Hong Kong. Flu in Victoria and the casualties. Flu in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097633 | 24097633 | |
34226 | 34226 | 1919-03-01 | 7 | c | A passenger plane service from London to Paris. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097633 | 24097633 | |
34227 | 34227 | 1919-03-01 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. Mails for pickup at the Tung Wah Times. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097633 | 24097633 | |
34228 | 34228 | 1919-03-01 | 7 | c | Farewell message by He Chengfang on his returning to China. | China | http://trove.nla.gov.au/newspaper/page/24097633 | 24097633 | |
34229 | 34229 | 1919-03-01 | 8 | a-b | Beijing news/ Zhang Qian issues a circular telegram for public security in Fujian and Shaanxi province. China to set up consulate-general in France. Zhang Shuyuan is determined to wipe out all bandits in Shandong province. Japanese consul in Jiujiang, Jiangxi province, dies. Chinese ambassador to France Hu Weide reports that American President offers help to China. Chinese army rush to make a Tibet map. | China | http://trove.nla.gov.au/newspaper/page/24097636 | 24097636 | |
34230 | 34230 | 1919-03-01 | 8 | b-c | Guangdong news/ President Xu Shichang on the war expenses. Famine victims in Guangzhou. Gentry and businessmen in Zengcheng welcome new magistrate. Railway from Dongguan to Kowloon to start. Charities in Guangzhou and the contributions from gentry and businessmen. Military government in Guangdong notifies Beijing of the peace representatives (Tang Shaoyi, Zhang Shizhao, Hu Hanmin, and others). Police authority on the local security and the public notice. Investigation on the export of silver dollars. | China | http://trove.nla.gov.au/newspaper/page/24097636 | 24097636 | |
34231 | 34231 | 1919-03-08 | 2 | a-b | An article from Hong Kong on the provincial parliament in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097638 | 24097638 | |
34232 | 34232 | 1919-03-08 | 2 | c-d | Liang Qichao on China's declaration of war with Germany, the sixth and final part of the retrospect. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097638 | 24097638 | |
34233 | 34233 | 1919-03-08 | 2 | d-e | A circular telegram issued by Tong Yanqiu call for a national conference for peace talks. | China | http://trove.nla.gov.au/newspaper/page/24097638 | 24097638 | |
34234 | 34234 | 1919-03-08 | 2 | e | Wang Zhengting (?) (actually Huang Ding) is assassinated and the report. | China | http://trove.nla.gov.au/newspaper/page/24097638 | 24097638 | |
34235 | 34235 | 1919-03-08 | 2 | f | Guangdong authority sells the mining rights to foreign company and the report. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24097638 | 24097638 | |
34236 | 34236 | 1919-03-08 | 3 | a | Huang Xiquan and others suggest that China should stop repayment of the Boxer Indemnity. | China | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34237 | 34237 | 1919-03-08 | 3 | b | Chinese delegates to the Paris peace conference. | France | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34238 | 34238 | 1919-03-08 | 3 | b | Beijing authority on the debts to German and Austrian companies. | China | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34239 | 34239 | 1919-03-08 | 3 | c | Western newspaper says that Japan should give up the twenty-one demands to China, part II. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34240 | 34240 | 1919-03-08 | 3 | d | First part of a report on China at the international peace conference in Paris. | China | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34241 | 34241 | 1919-03-08 | 3 | e | American President Wilson on the international peace. | America | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34242 | 34242 | 1919-03-08 | 3 | e | The Allies countries will discuss how to deal with the German warships. | Britain | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34243 | 34243 | 1919-03-08 | 3 | f | The war loss of France in the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34244 | 34244 | 1919-03-08 | 3 | f | The secret treaty between China and Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34245 | 34245 | 1919-03-08 | 3 | f | China seeks to borrow more loans from Japan. | America | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34246 | 34246 | 1919-03-08 | 3 | f | German oppose to the deportation of German nationals to Australia by the Chinese government. | France | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34247 | 34247 | 1919-03-08 | 3 | f | Japan issues ultimate to the Chinese government (on the transfer of German privileges to Japan). | America | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34248 | 34248 | 1919-03-08 | 3 | f | Korean people fight for independence. | China | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34249 | 34249 | 1919-03-08 | 3 | f | German nationals are leaving China. | Britain | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
34250 | 34250 | 1919-03-08 | 6 | a-b | Second and final part of the appeal issued by Kang Youwei for peace talks in China between the south and the north in correspondence with the world peace effort. | China | http://trove.nla.gov.au/newspaper/page/24097642 | 24097642 | |
34251 | 34251 | 1919-03-08 | 6 | b-c | Japan is not satisfied with the international peace treaty submitted to the Paris peace conference. | America | http://trove.nla.gov.au/newspaper/page/24097642 | 24097642 | |
34252 | 34252 | 1919-03-08 | 6 | c | The peace treaty to be signed by German delegates at the Paris conference. | America | http://trove.nla.gov.au/newspaper/page/24097642 | 24097642 | |
34253 | 34253 | 1919-03-08 | 6 | c | Total number of casualties in the World War I. | America | http://trove.nla.gov.au/newspaper/page/24097642 | 24097642 | |
34254 | 34254 | 1919-03-08 | 7 | a-c | Australia news/ Election of the committee members of the New South Wales Chinese Chamber of Commerce (Guo Shun, Chen Zhuchen, Ye Bingnan and others). Chinese Chamber of Commerce in Sydney sends telegrams to Beijing and Nanjing on Japan's motives in China at the Paris conference. Immunisation in Sydney following the epidemic disease. Epidemic in Honolulu. Chinese vegetable pedlar in Sydney is robbed. Storm in Melbourne. Japan purchases horses in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097641 | 24097641 | |
34255 | 34255 | 1919-03-08 | 7 | c | Japan to return Qingdao to China. | Japan | http://trove.nla.gov.au/newspaper/page/24097641 | 24097641 | |
34256 | 34256 | 1919-03-08 | 7 | c | Japan demands to relax the restriction on immigration at the Paris Peace Conference. | Japan | http://trove.nla.gov.au/newspaper/page/24097641 | 24097641 | |
34257 | 34257 | 1919-03-08 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097641 | 24097641 | |
34258 | 34258 | 1919-03-08 | 8 | a | Chinese in Tasmania donate to the Australian Chinese Association against Discrimination (hua qiao wei chi jin li hui). Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097644 | 24097644 | |
34259 | 34259 | 1919-03-08 | 8 | a-b | Beijing news/ Peace talks between the south and the north. Zhang Jingyao is converted to Buddhism. Liang Qichao leaves China for Europe and his message. Foreign businessmen in Zhenjiang, of Jiangsu province, to build the road. Anhui people in Shanghai protest against the increase of land tax. Whereabouts of Li Dingxin. | China | http://trove.nla.gov.au/newspaper/page/24097644 | 24097644 | |
34260 | 34260 | 1919-03-08 | 8 | b-c | Guangdong news/ Acting provincial governor Zhai Wang on the rice price. French president awards medal to Tang Jiyao. Shen Peizheng and Wei Zhaowen divorce. Chamber of Commerce in Luoding county complains the Commissioner for stamp duty. | China | http://trove.nla.gov.au/newspaper/page/24097644 | 24097644 | |
34261 | 34261 | 1919-03-15 | 2 | a-c | First part of the speech by Chinese President Xu Shichang to the industrial representatives. | China | http://trove.nla.gov.au/newspaper/page/24097646 | 24097646 | |
34262 | 34262 | 1919-03-15 | 2 | c-d | First part of an article by Liang Qichao on the League of Nations and its relations to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097646 | 24097646 | |
34263 | 34263 | 1919-03-15 | 2 | d-e | Second part of the report on China at the international peace conference in Paris. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097646 | 24097646 | |
34264 | 34264 | 1919-03-15 | 2 | e-f | Japanese cabinet and their China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24097646 | 24097646 | |
34265 | 34265 | 1919-03-15 | 3 | a | A circular telegram issued by Wang Zhanyuan, governor of Hubei, on the peace in the Southwest. | China | http://trove.nla.gov.au/newspaper/page/24097645 | 24097645 |
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]);