This data as json, CSV (advanced)
Suggested facets: column, title, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 4545 | 4545 | 1900-02-07 | 5 | a | The Emperor of China is going to be dethroned and will be succeeded by a boy. | Other... | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4546 | 4546 | 1900-02-07 | 5 | a | Russian newspaper says that they could carve China up if allied with Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4547 | 4547 | 1900-02-07 | 5 | a | Empress Dowager ordered zongli yamen and local governors to defy the invading foreigners. | Other... | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4548 | 4548 | 1900-02-07 | 5 | a | Sydney Chinese community has organised the Chinese Empire Reform Association and the office is in Tung Wah News. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4549 | 4549 | 1900-02-07 | 5 | b | Responses of the Chinese communities in Australia and other countries to the establishment of Chinese Empire Reform Association in Sydney: Singapore Chinese community, Adelaide, See Yip in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4550 | 4550 | 1900-02-07 | 5 | b | Report from a journalist in Hong Kong about current political situations in China, especially the succession of imperial power. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4551 | 4551 | 1900-02-07 | 5 | c-e | More reports about the war between Britain and Transvaal in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4552 | 4552 | 1900-02-07 | 5 | e | An essay, written by anonymous author, comments on the recent development of the relations between Russia and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4553 | 4553 | 1900-02-07 | 5 | f | Chinese man, Zhong Zanrong, of Zengcheng, died in an accident while travelling to Sydney by train. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4554 | 4554 | 1900-02-07 | 5 | f | Five Chinese return to China with gold. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4555 | 4555 | 1900-02-07 | 5 | f | The price of gold in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 4556 | 4556 | 1900-02-07 | 5 | f | Arrivals and departures of liners to Asian ports. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102695 | 24102695 | |
| 10924 | 10924 | 1902-08-16 | 5 | a | First part of proposed curriculum of Beijing university and book editing. | China | http://trove.nla.gov.au/newspaper/page/24100466 | 24100466 | |
| 10925 | 10925 | 1902-08-16 | 5 | a | Empress Dowager wants to remove Yuan Shikai still hesitates over the decision. | China | http://trove.nla.gov.au/newspaper/page/24100466 | 24100466 | |
| 10926 | 10926 | 1902-08-16 | 5 | a | Bandits in Guangxi province and on its border with Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100466 | 24100466 | |
| 10927 | 10927 | 1902-08-16 | 5 | a | Hairdressers in Guangzhou protest against discrimination. | China | http://trove.nla.gov.au/newspaper/page/24100466 | 24100466 | |
| 10928 | 10928 | 1902-08-16 | 5 | b | A report on foreigners in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100466 | 24100466 | |
| 10929 | 10929 | 1902-08-16 | 5 | b | Wollongong has a coal mine accident. | Australia | http://trove.nla.gov.au/newspaper/page/24100466 | 24100466 | |
| 10944 | 10944 | 1902-08-23 | 5 | a | Final part of proposed curriculum of Beijing university. | China | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10945 | 10945 | 1902-08-23 | 5 | a | The Chinese Commercial Association in Sydney, Lin Yik Tong, donated to victims of Wollongong coal mine accident. Representatives from Lin Yik Tong are Mei Guangda, Sun Junchen, Zhou Jin and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10946 | 10946 | 1902-08-23 | 5 | a | A Tasmania man died in a Sydney hospital after receiving too much anaesthesia. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10947 | 10947 | 1902-08-23 | 5 | b | Trams and passengers in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10948 | 10948 | 1902-08-23 | 5 | b | A rascal in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10949 | 10949 | 1902-08-23 | 5 | b | A Sydney businessman was punished for an inappropriate advertisement. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10950 | 10950 | 1902-08-23 | 5 | b | Tao Mo, governor of Guangdong and Guangxi provinces, suggests abolishing the imperial examination. | China | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
| 10967 | 10967 | 1902-08-30 | 5 | a | First part of an article, written by an anonymous author in Glen Innes, New South Wales, on disadvantages of the imperial martial arts examination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 | |
| 10968 | 10968 | 1902-08-30 | 5 | a | A young woman in North Carlton, Melbourne, burns her baby to death. | Australia | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 | |
| 10969 | 10969 | 1902-08-30 | 5 | a | A family of five in Brisbane were murdered. | Australia | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 | |
| 10970 | 10970 | 1902-08-30 | 5 | b | Donations from Sydney newspapers to victims of the coal mine accident in Wollongong, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 | |
| 10971 | 10971 | 1902-08-30 | 5 | b | A husband in Melbourne was murdered by his wife. | Australia | http://trove.nla.gov.au/newspaper/page/24100478 | 24100478 | |
| 10992 | 10992 | 1902-09-06 | 5 | a | A woman of Dandenong, Melbourne, murdered her husband. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 10993 | 10993 | 1902-09-06 | 5 | a | Drought in Gunnedah, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 10994 | 10994 | 1902-09-06 | 5 | a | The case between Li Bu and Xian Junhao, two Chinese businessmen in Sydney, over the payment from Tung Wah News has not been ruled on yet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 10995 | 10995 | 1902-09-06 | 5 | b | A house fire in Surry Hills, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 10996 | 10996 | 1902-09-06 | 5 | b | Two Chinese in New Castle, New South Wales, were brought to court for causing another's injury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 10997 | 10997 | 1902-09-06 | 5 | b | A Wollongong man was awarded for his bravery. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
| 11008 | 11008 | 1902-09-20 | 5 | a | Second part of the article, written by an anonymous author in Glen Innes, New South Wales, on disadvantages of the imperial martial arts examination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11009 | 11009 | 1902-09-20 | 5 | a | Zhang Zhidong has a Japanese advisor. | China | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11010 | 11010 | 1902-09-20 | 5 | a | Wang Zhichun, imperial commissioner of Guangxi, needs more new weapons in order to wipe out bandits. | China | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11011 | 11011 | 1902-09-20 | 5 | a | Number of America troops in the Philippines. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11012 | 11012 | 1902-09-20 | 5 | a | A rich man tries to purchase from American government independence of the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11013 | 11013 | 1902-09-20 | 5 | a | Tao Mo, governor of Guangdong and Guangxi province, asked to resign. | China | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11014 | 11014 | 1902-09-20 | 5 | a | A street lights company in Beijing tries to raise money. | China | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11015 | 11015 | 1902-09-20 | 5 | b | Shearers in New Zealand plan a strike. | Australia | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11016 | 11016 | 1902-09-20 | 5 | b | Somebody in Bendigo stole money from a woman's house. | Australia | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11017 | 11017 | 1902-09-20 | 5 | b | Forty-seven Western men from North Sydney were punished for gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11018 | 11018 | 1902-09-20 | 5 | b | Guangdong has heavy rain and floods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100494 | 24100494 | |
| 11034 | 11034 | 1902-09-27 | 5 | a | Kang Youwei's concubine bore him a son in India. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100500 | 24100500 | |
| 11035 | 11035 | 1902-09-27 | 5 | a | Three foreign men in Ballarat have new way to defraud money from the bank. | Australia | http://trove.nla.gov.au/newspaper/page/24100500 | 24100500 | |
| 11036 | 11036 | 1902-09-27 | 5 | a | A successful man in Sydney committed suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100500 | 24100500 | |
| 11037 | 11037 | 1902-09-27 | 5 | b | An earthquake in Adelaide, South Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100500 | 24100500 | |
| 14866 | 14866 | 1905-10-07 | 5 | a | An article written by anonymous author says that protest against American immigration policy should be combined with business prosperity to save the nation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
| 14867 | 14867 | 1905-10-07 | 5 | a-b | Total number of Jews and their distribution around the world. No divorce in Mexico. Thailand has no national debt. How rich is the Pope in Vatican. Statistics of newspaper, bank and railway in Japan. Territory of Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
| 14868 | 14868 | 1905-10-07 | 5 | b | An ammunition storehouse in Hiroshima, Japan, explodes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
| 14869 | 14869 | 1905-10-07 | 5 | b | A mother in Illinois, United States, murdered her seven children and then committed suicide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
| 14870 | 14870 | 1905-10-07 | 5 | b | Report on German business in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
| 14871 | 14871 | 1905-10-07 | 5 | b | Report on suffering of Chinese labourers in South Africa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
| 14872 | 14872 | 1905-10-07 | 5 | b | More Chinese people in Sydney have joined the Chinese Empire Reform Association. Their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
| 14900 | 14900 | 1905-10-14 | 5 | a-b | Letters from Tung Wah Times readers on American immigration policy: Deng Zhihong, Rong Linjian, Sun Yingtang and others in Rockhampton, Queensland; Huang Caifeng from New South Wales; Huang Liquan from Narrabri, New South Wales; Zhang Liang and Zhou Ruiting from Bendigo, Victoria; Yang Yi'an from Townsville, Queensland; and Yang San and Yang Lin from Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800800 | 26800800 | |
| 14901 | 14901 | 1905-10-14 | 5 | c-d | Chinese communities donate to the protest movement against American immigration policy that to ban Chinese entry. About 300 names of individuals and shops listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800800 | 26800800 | |
| 14933 | 14933 | 1905-10-21 | 5 | a | Second and final part of three songs of the Chinese Empire Reform Association, written by Kang Youwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800806 | 26800806 | |
| 14934 | 14934 | 1905-10-21 | 5 | a-c | Chinese communities in Sydney, Melbourne and other towns of Australia donate to the protest against American immigration policy that to ban Chinese entry. Names listed for individuals and shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800806 | 26800806 | |
| 14958 | 14958 | 1905-10-28 | 5 | a | Letters from Tung Wah readers from Queensland and New South Wales on the protest against American immigration policy. Names listed for individuals and shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800812 | 26800812 | |
| 14959 | 14959 | 1905-10-28 | 5 | a | Chinese communities in Geraldton of Western Australia, Newland of New South Wales, Bendigo of Victoria, Townsville of Queensland donate to the protest movement against American immigration policy that bans Chinese entry. Hundreds of names listed for individuals and shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800812 | 26800812 | |
| 14974 | 14974 | 1905-11-04 | 5 | a | Letters from Tung Wah Times readers in Queensland, Tasmania and New South Wales on American immigration policy. Names listed for individuals and their shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800821 | 26800821 | |
| 14975 | 14975 | 1905-11-04 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy. Hundreds of names listed for individuals and shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800821 | 26800821 | |
| 14976 | 14976 | 1905-11-04 | 5 | c | Report on donations to the charity in Dongguan county that collect refugees. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800821 | 26800821 | |
| 14999 | 14999 | 1905-11-11 | 5 | a | Letters from the Tung Wah readers in Queensland on American immigration policy. Their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800824 | 26800824 | |
| 15000 | 15000 | 1905-11-11 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy. Hundreds of names listed for individuals and shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800824 | 26800824 | |
| 15028 | 15028 | 1905-11-18 | 5 | a-c | Chinese communities in Australia donate to the protest movement against American immigration policy that to ban Chinese entry. Hundreds of names listed around Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800830 | 26800830 | |
| 15054 | 15054 | 1905-11-25 | 5 | a | Songs written by anonymous author in protest against American immigration policy that to ban Chinese immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800836 | 26800836 | |
| 15055 | 15055 | 1905-11-25 | 5 | a-b | Letters from the Tung Wah Times readers in Queensland protest against American immigration policy that to ban Chinese immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800836 | 26800836 | |
| 15056 | 15056 | 1905-11-25 | 5 | b-c | Chinese communities around Australia donate to the protest movement against American immigration policy that to ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800836 | 26800836 | |
| 15091 | 15091 | 1905-12-02 | 5 | a | Report on Kang Youwei's tour in the United States and the Chinese Empire Reform Association there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800845 | 26800845 | |
| 15092 | 15092 | 1905-12-02 | 5 | a-c | Chinese communities around Australia donate to support the protest movement against American immigration policy that to ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800845 | 26800845 | |
| 15121 | 15121 | 1905-12-09 | 5 | a | Ye Huibo (En) writes to Liang Zhendong, Chinese ambassador to Washington, regarding American immigration policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800851 | 26800851 | |
| 15122 | 15122 | 1905-12-09 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy that will ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800851 | 26800851 | |
| 15123 | 15123 | 1905-12-09 | 5 | c | Correction to the names listed in the Tung Wah Times of October 29 and November 6. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800851 | 26800851 | |
| 15124 | 15124 | 1905-12-09 | 5 | c | Poems written by anonymous author (probably Kang Youwei) on his way from Ceylon to Europe. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800851 | 26800851 | |
| 15151 | 15151 | 1905-12-16 | 5 | a | A letter from Tung Wah Times reader in Queensland on Chinese communities there and their attitude towards American immigration policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800857 | 26800857 | |
| 15152 | 15152 | 1905-12-16 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy that to ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800857 | 26800857 | |
| 15172 | 15172 | 1905-12-23 | 5 | a | Songs prepared by students of Jiaxing, Zhejiang province, for boycott of American goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800860 | 26800860 | |
| 15173 | 15173 | 1905-12-23 | 5 | a | Chinese Zeng Yuan, 81, of Queensland, is keen to donate and help boycott to American goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800860 | 26800860 | |
| 15174 | 15174 | 1905-12-23 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy that to ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800860 | 26800860 | |
| 15202 | 15202 | 1905-12-30 | 5 | a | Chinese and American businessmen hold a protest rally in Guangzhou against American immigration policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800866 | 26800866 | |
| 15203 | 15203 | 1905-12-30 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy that to ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800866 | 26800866 | |
| 15204 | 15204 | 1905-12-30 | 5 | c | Chinese Empire Reform Association in Victoria, Canada, has a new office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800866 | 26800866 | |
| 15205 | 15205 | 1905-12-30 | 5 | c | Australia starts to ban opium importation from January 1, 1906. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800866 | 26800866 | |
| 15227 | 15227 | 1906-01-06 | 5 | a | Elegiac couplets in memory of Feng Xiawei who committed suicide at the front door of American consulate in Shanghai in protest against American immigration policy that to ban Chinese immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800875 | 26800875 | |
| 15228 | 15228 | 1906-01-06 | 5 | a | Second part of the songs prepared by students of Jiaxing, Zhejiang province, for boycott to American goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800875 | 26800875 | |
| 15229 | 15229 | 1906-01-06 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy to ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800875 | 26800875 | |
| 15255 | 15255 | 1906-01-13 | 5 | a | Report on the second meeting of Chinese and American businessmen in Guangzhou protests against American immigration policy to ban Chinese immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800878 | 26800878 | |
| 15256 | 15256 | 1906-01-13 | 5 | a-c | Chinese communities around Australia donate to the protest movement against American immigration policy to ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800878 | 26800878 | |
| 15257 | 15257 | 1906-01-13 | 5 | c | Number of Chinese in Taiwan, Hong Kong, Macao, Japan, Thailand, North and South America, Korea, Vietnam, Australia, The Philippines, Europe and Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800878 | 26800878 | |
| 15258 | 15258 | 1906-01-13 | 5 | c | Chinese residents in Dutch colonies are seeking Japanese citizenship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800878 | 26800878 | |
| 15259 | 15259 | 1906-01-13 | 5 | c | Chinese labourers are branded with iron in Dutch colonies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800878 | 26800878 | |
| 15289 | 15289 | 1906-01-20 | 5 | a-b | President Roosevelt of the United States meets special envoys from Russia and Japan and preparation for the Treaty of Portsmouth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800886 | 26800886 | |
| 15290 | 15290 | 1906-01-20 | 5 | b-c | A petition from Chinese businessmen in Sydney and around Australia to the federal government to lift the ban on Chinese immigration. A copy of the petition. Signatures sought. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800886 | 26800886 | |
| 15291 | 15291 | 1906-01-20 | 5 | c-d | Chinese communities around Australia donate to the protest movement against American immigration policy to ban Chinese immigrants. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800886 | 26800886 | |
| 15311 | 15311 | 1906-02-03 | 5 | a | First part of the letter from Kang Youwei to President Roosevelt of the United States. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800891 | 26800891 |
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]);