Comic Characters: dc-wikia-data.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
6,896 rows sorted by ALIGN
This data as json, copyable, CSV (advanced)
Suggested facets: ID, ALIGN, EYE, HAIR, SEX, GSM, ALIVE
Link | rowid | page_id | name | urlslug | ID | ALIGN ▼ | EYE | HAIR | SEX | GSM | ALIVE | APPEARANCES | FIRST APPEARANCE | YEAR |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23 | 23 | 4849 | Ted Grant (New Earth) | \/wiki\/Ted_Grant_(New_Earth) | Secret Identity | Blue Eyes | Black Hair | Male Characters | Living Characters | 605 | 1942, January | 1942 | ||
28 | 28 | 1484 | Ralph Dibny (New Earth) | \/wiki\/Ralph_Dibny_(New_Earth) | Public Identity | Blue Eyes | Red Hair | Male Characters | Deceased Characters | 558 | 1960, May | 1960 | ||
34 | 34 | 1616 | Rex Mason (New Earth) | \/wiki\/Rex_Mason_(New_Earth) | Secret Identity | Black Eyes | Male Characters | Living Characters | 470 | 1965, January | 1965 | |||
36 | 36 | 6791 | Aztar (New Earth) | \/wiki\/Aztar_(New_Earth) | Secret Identity | White Eyes | Male Characters | Living Characters | 436 | 1940, February | 1940 | |||
37 | 37 | 1481 | Theodore Kord (New Earth) | \/wiki\/Theodore_Kord_(New_Earth) | Secret Identity | Blue Eyes | Brown Hair | Male Characters | Deceased Characters | 429 | 1986, February | 1986 | ||
51 | 51 | 1684 | Charles McNider (New Earth) | \/wiki\/Charles_McNider_(New_Earth) | Secret Identity | Blue Eyes | Blond Hair | Male Characters | Deceased Characters | 361 | 1941, April | 1941 | ||
54 | 54 | 1488 | Perry White (New Earth) | \/wiki\/Perry_White_(New_Earth) | Public Identity | Blue Eyes | Brown Hair | Male Characters | Living Characters | 350 | 1986, October | 1986 | ||
58 | 58 | 1599 | Phantom Stranger (New Earth) | \/wiki\/Phantom_Stranger_(New_Earth) | Secret Identity | Black Eyes | Black Hair | Male Characters | Living Characters | 335 | 1952, September | 1952 | ||
62 | 62 | 4030 | Clifford Steele (New Earth) | \/wiki\/Clifford_Steele_(New_Earth) | Public Identity | Photocellular Eyes | Male Characters | Living Characters | 314 | 1963, June | 1963 | |||
70 | 70 | 1700 | Michael Holt (New Earth) | \/wiki\/Michael_Holt_(New_Earth) | Secret Identity | Brown Eyes | Black Hair | Male Characters | Living Characters | 300 | 1997, June | 1997 | ||
82 | 82 | 21110 | Daniel Turpin (New Earth) | \/wiki\/Daniel_Turpin_(New_Earth) | Public Identity | Brown Eyes | Brown Hair | Male Characters | Deceased Characters | 261 | 1942, June | 1942 | ||
85 | 85 | 1462 | Oswald Cobblepot (New Earth) | \/wiki\/Oswald_Cobblepot_(New_Earth) | Public Identity | Blue Eyes | Black Hair | Male Characters | Living Characters | 253 | 1941, December | 1941 | ||
104 | 104 | 12672 | Mera (New Earth) | \/wiki\/Mera_(New_Earth) | Public Identity | Blue Eyes | Red Hair | Female Characters | Living Characters | 226 | 1963, October | 1963 | ||
106 | 106 | 1522 | George Harkness (New Earth) | \/wiki\/George_Harkness_(New_Earth) | Secret Identity | Brown Eyes | Brown Hair | Male Characters | Living Characters | 224 | 1960, December | 1960 | ||
109 | 109 | 1519 | Leonard Snart (New Earth) | \/wiki\/Leonard_Snart_(New_Earth) | Secret Identity | Brown Eyes | Brown Hair | Male Characters | Living Characters | 219 | 1957, June | 1957 | ||
128 | 128 | 1579 | Kimiyo Hoshi (New Earth) | \/wiki\/Kimiyo_Hoshi_(New_Earth) | Secret Identity | Black Eyes | Black Hair | Female Characters | Living Characters | 189 | 1985, July | 1985 | ||
130 | 130 | 1620 | Vandar Adg (New Earth) | \/wiki\/Vandar_Adg_(New_Earth) | Public Identity | Brown Eyes | Black Hair | Male Characters | Living Characters | 188 | 1943, December | 1943 | ||
135 | 135 | 1658 | Margaret Sawyer (New Earth) | \/wiki\/Margaret_Sawyer_(New_Earth) | Public Identity | Blue Eyes | Female Characters | Homosexual Characters | Living Characters | 180 | 1987, April | 1987 | ||
140 | 140 | 1829 | Adam Strange (New Earth) | \/wiki\/Adam_Strange_(New_Earth) | Public Identity | Blue Eyes | Blond Hair | Male Characters | Living Characters | 177 | 1958, December | 1958 | ||
148 | 148 | 3628 | Linda Park (New Earth) | \/wiki\/Linda_Park_(New_Earth) | Public Identity | Brown Eyes | Black Hair | Female Characters | Living Characters | 174 | 1989, July | 1989 | ||
153 | 153 | 3622 | Joan Williams (New Earth) | \/wiki\/Joan_Williams_(New_Earth) | Public Identity | Blue Eyes | Grey Hair | Female Characters | Living Characters | 171 | 1940, January | 1940 | ||
157 | 157 | 7585 | Oberon (New Earth) | \/wiki\/Oberon_(New_Earth) | Public Identity | Blue Eyes | White Hair | Male Characters | Living Characters | 167 | 1971, April | 1971 | ||
169 | 169 | 1798 | Uncle Sam (New Earth) | \/wiki\/Uncle_Sam_(New_Earth) | Secret Identity | Blue Eyes | White Hair | Male Characters | Living Characters | 162 | 1940, July | 1940 | ||
173 | 173 | 1709 | Lucas Carr (New Earth) | \/wiki\/Lucas_Carr_(New_Earth) | Public Identity | Blue Eyes | Brown Hair | Male Characters | Living Characters | 161 | 1960, March | 1960 | ||
202 | 202 | 1853 | Solis (New Earth) | \/wiki\/Solis_(New_Earth) | Secret Identity | Blue Eyes | Strawberry Blond Hair | Male Characters | Living Characters | 138 | 1971, March | 1971 | ||
203 | 203 | 42572 | Alfred Twidgett (New Earth) | \/wiki\/Alfred_Twidgett_(New_Earth) | Public Identity | Male Characters | Living Characters | 137 | 1942, June | 1942 | ||||
212 | 212 | 70786 | Barbara Ann Minerva (New Earth) | \/wiki\/Barbara_Ann_Minerva_(New_Earth) | Public Identity | Brown Eyes | Female Characters | Living Characters | 131 | 1987, August | 1987 | |||
215 | 215 | 3610 | Mick Rory (New Earth) | \/wiki\/Mick_Rory_(New_Earth) | Public Identity | Blue Eyes | Male Characters | Living Characters | 131 | 1963, November | 1963 | |||
232 | 232 | 1702 | Richard Occult (New Earth) | \/wiki\/Richard_Occult_(New_Earth) | Secret Identity | Grey Eyes | Black Hair | Male Characters | Living Characters | 125 | 1935, October | 1935 | ||
245 | 245 | 11851 | Elizabeth Lawrence (New Earth) | \/wiki\/Elizabeth_Lawrence_(New_Earth) | Secret Identity | Blue Eyes | Blond Hair | Female Characters | Living Characters | 120 | 1942, December | 1942 | ||
288 | 288 | 2645 | Rip Hunter (New Earth) | \/wiki\/Rip_Hunter_(New_Earth) | Secret Identity | Blue Eyes | Blond Hair | Male Characters | Living Characters | 103 | 1959, June | 1959 | ||
294 | 294 | 10481 | Lawrence Jordan (New Earth) | \/wiki\/Lawrence_Jordan_(New_Earth) | Secret Identity | Brown Eyes | Brown Hair | Male Characters | Deceased Characters | 100 | 1942, February | 1942 | ||
336 | 336 | 1938 | David Clinton (New Earth) | \/wiki\/David_Clinton_(New_Earth) | Secret Identity | Blue Eyes | Black Hair | Male Characters | Living Characters | 88 | 1962, November | 1962 | ||
337 | 337 | 2604 | Bobo T. Chimpanzee (New Earth) | \/wiki\/Bobo_T._Chimpanzee_(New_Earth) | Black Eyes | Black Hair | Male Characters | Living Characters | 88 | 1952, August | 1952 | |||
346 | 346 | 14511 | Herakles (New Earth) | \/wiki\/Herakles_(New_Earth) | Public Identity | Brown Eyes | Brown Hair | Male Characters | Living Characters | 86 | 1941, December | 1941 | ||
347 | 347 | 16376 | Harold Thompson (New Earth) | \/wiki\/Harold_Thompson_(New_Earth) | Secret Identity | Blue Eyes | Blond Hair | Male Characters | Living Characters | 86 | 1938, June | 1938 | ||
356 | 356 | 11872 | Jonathan Law (New Earth) | \/wiki\/Jonathan_Law_(New_Earth) | Secret Identity | Blue Eyes | Blond Hair | Male Characters | Deceased Characters | 84 | 1941, October | 1941 | ||
358 | 358 | 24160 | Norda Cantrell (New Earth) | \/wiki\/Norda_Cantrell_(New_Earth) | Secret Identity | White Eyes | Brown Hair | Male Characters | Living Characters | 83 | 1983, September | 1983 | ||
387 | 387 | 1891 | Jakeem Williams (New Earth) | \/wiki\/Jakeem_Williams_(New_Earth) | Secret Identity | Brown Eyes | Male Characters | Living Characters | 79 | |||||
396 | 396 | 4903 | Joshua Clay (New Earth) | \/wiki\/Joshua_Clay_(New_Earth) | Secret Identity | Brown Eyes | Black Hair | Male Characters | Deceased Characters | 77 | 1977, September | 1977 | ||
401 | 401 | 19150 | Adrian Chase (New Earth) | \/wiki\/Adrian_Chase_(New_Earth) | Public Identity | Blue Eyes | Blond Hair | Male Characters | Deceased Characters | 76 | 1982, September | 1982 | ||
411 | 411 | 16733 | Matthew Cable (New Earth) | \/wiki\/Matthew_Cable_(New_Earth) | Secret Identity | Black Hair | Male Characters | Living Characters | 74 | 1972, November | 1972 | |||
415 | 415 | 41263 | Ultra-Humanite (New Earth) | \/wiki\/Ultra-Humanite_(New_Earth) | Secret Identity | Red Eyes | White Hair | Male Characters | Living Characters | 74 | 1939, June | 1939 | ||
442 | 442 | 69315 | Green Man (New Earth) | \/wiki\/Green_Man_(New_Earth) | Public Identity | Red Eyes | Male Characters | Deceased Characters | 68 | 1983, May | 1983 | |||
446 | 446 | 4862 | Isaac Bowin (New Earth) | \/wiki\/Isaac_Bowin_(New_Earth) | Secret Identity | Blue Eyes | Male Characters | Deceased Characters | 68 | 1948, January | 1948 | |||
458 | 458 | 1521 | Frances Kane (New Earth) | \/wiki\/Frances_Kane_(New_Earth) | Public Identity | Blue Eyes | Purple Hair | Female Characters | Living Characters | 66 | 1982, March | 1982 | ||
468 | 468 | 1529 | Albert Desmond (New Earth) | \/wiki\/Albert_Desmond_(New_Earth) | Green Eyes | Red Hair | Male Characters | Living Characters | 65 | 1958, April | 1958 | |||
491 | 491 | 11857 | Henry Heywood, Sr. (New Earth) | \/wiki\/Henry_Heywood,_Sr._(New_Earth) | Secret Identity | Blue Eyes | Black Hair | Male Characters | Deceased Characters | 61 | 1978, March | 1978 | ||
498 | 498 | 12177 | Chaselon (New Earth) | \/wiki\/Chaselon_(New_Earth) | Public Identity | White Eyes | Black Hair | Male Characters | Deceased Characters | 60 | 1961, December | 1961 | ||
506 | 506 | 4869 | Paula Brooks (New Earth) | \/wiki\/Paula_Brooks_(New_Earth) | Secret Identity | Green Eyes | Black Hair | Female Characters | Living Characters | 59 | 1947, August | 1947 | ||
514 | 514 | 1992 | Tula (New Earth) | \/wiki\/Tula_(New_Earth) | Public Identity | Blue Eyes | Brown Hair | Female Characters | Deceased Characters | 58 | 1967, June | 1967 | ||
557 | 557 | 19714 | Clifford Baker (New Earth) | \/wiki\/Clifford_Baker_(New_Earth) | Public Identity | Green Eyes | Red Hair | Male Characters | Deceased Characters | 53 | 1988, September | 1988 | ||
593 | 593 | 24463 | Jeffrey Graves (New Earth) | \/wiki\/Jeffrey_Graves_(New_Earth) | Secret Identity | Brown Hair | Male Characters | Living Characters | 49 | 2007, February | 2007 | |||
596 | 596 | 19058 | Mary Loyd (New Earth) | \/wiki\/Mary_Loyd_(New_Earth) | Public Identity | Green Eyes | Black Hair | Female Characters | Deceased Characters | 49 | 1989, August | 1989 | ||
602 | 602 | 21644 | Traci Thirteen (New Earth) | \/wiki\/Traci_Thirteen_(New_Earth) | Public Identity | Brown Eyes | Black Hair | Female Characters | Living Characters | 48 | 2003, February | 2003 | ||
604 | 604 | 29823 | Aristotle Rodor (New Earth) | \/wiki\/Aristotle_Rodor_(New_Earth) | Public Identity | Blue Eyes | White Hair | Male Characters | Living Characters | 48 | 1987, February | 1987 | ||
606 | 606 | 10484 | Harold Jordan (New Earth) | \/wiki\/Harold_Jordan_(New_Earth) | Secret Identity | Brown Eyes | Brown Hair | Male Characters | Deceased Characters | 48 | 1978, January | 1978 | ||
646 | 646 | 69859 | Lara Lor-Van (New Earth) | \/wiki\/Lara_Lor-Van_(New_Earth) | Public Identity | Blue Eyes | Black Hair | Female Characters | Deceased Characters | 44 | 1986, October | 1986 | ||
652 | 652 | 1563 | Lisa Snart (New Earth) | \/wiki\/Lisa_Snart_(New_Earth) | Blue Eyes | Blond Hair | Female Characters | Deceased Characters | 44 | 1977, June | 1977 | |||
658 | 658 | 23377 | Axel Walker (New Earth) | \/wiki\/Axel_Walker_(New_Earth) | Secret Identity | Blue Eyes | Blond Hair | Male Characters | Living Characters | 43 | 2002, April | 2002 | ||
665 | 665 | 22237 | Beverly Lewis (New Earth) | \/wiki\/Beverly_Lewis_(New_Earth) | Green Eyes | Red Hair | Female Characters | Living Characters | 43 | 1980, May | 1980 | |||
669 | 669 | 3631 | Emmaline Brady (New Earth) | \/wiki\/Emmaline_Brady_(New_Earth) | Public Identity | Brown Eyes | Brown Hair | Female Characters | Living Characters | 43 | 1962, December | 1962 | ||
686 | 686 | 27565 | Appa Ali Apsa (New Earth) | \/wiki\/Appa_Ali_Apsa_(New_Earth) | Secret Identity | Blue Eyes | White Hair | Male Characters | Deceased Characters | 42 | 1970, April | 1970 | ||
694 | 694 | 21443 | Veronica Cale (New Earth) | \/wiki\/Veronica_Cale_(New_Earth) | Public Identity | Blue Eyes | Blond Hair | Female Characters | Living Characters | 41 | 2003, November | 2003 | ||
698 | 698 | 41928 | Dana Winters (New Earth) | \/wiki\/Dana_Winters_(New_Earth) | Female Characters | Deceased Characters | 41 | 1994, December | 1994 | |||||
712 | 712 | 34278 | Serling Roquette (New Earth) | \/wiki\/Serling_Roquette_(New_Earth) | Blond Hair | Female Characters | Living Characters | 40 | 1998, October | 1998 | ||||
720 | 720 | 15332 | Jenet Klyburn (New Earth) | \/wiki\/Jenet_Klyburn_(New_Earth) | Public Identity | Blue Eyes | Red Hair | Female Characters | Living Characters | 40 | 1976, October | 1976 | ||
728 | 728 | 70400 | Fang Zhifu (New Earth) | \/wiki\/Fang_Zhifu_(New_Earth) | Secret Identity | Male Characters | Living Characters | 39 | 2006, June | 2006 | ||||
730 | 730 | 1724 | Faith (New Earth) | \/wiki\/Faith_(New_Earth) | Secret Identity | Brown Eyes | Brown Hair | Female Characters | Living Characters | 39 | 2002, October | 2002 | ||
738 | 738 | 23971 | Sydney Happersen (New Earth) | \/wiki\/Sydney_Happersen_(New_Earth) | Public Identity | Black Hair | Male Characters | Deceased Characters | 39 | 1987, February | 1987 | |||
753 | 753 | 142775 | Predator (New Earth) | \/wiki\/Predator_(New_Earth) | Deceased Characters | 38 | 1984, July | 1984 | ||||||
757 | 757 | 22310 | Solovar (New Earth) | \/wiki\/Solovar_(New_Earth) | Secret Identity | Black Hair | Male Characters | Deceased Characters | 38 | 1959, May | 1959 | |||
810 | 810 | 57932 | Myra Connelly (New Earth) | \/wiki\/Myra_Connelly_(New_Earth) | Public Identity | Blue Eyes | Female Characters | Living Characters | 35 | 1987, February | 1987 | |||
832 | 832 | 64697 | Onyx Adams (New Earth) | \/wiki\/Onyx_Adams_(New_Earth) | Public Identity | Brown Eyes | Female Characters | Living Characters | 34 | 1985, January | 1985 | |||
869 | 869 | 2728 | Chester Runk (New Earth) | \/wiki\/Chester_Runk_(New_Earth) | Public Identity | Brown Eyes | Black Hair | Male Characters | Living Characters | 32 | 1988, February | 1988 | ||
886 | 886 | 22162 | Space Cabby (New Earth) | \/wiki\/Space_Cabby_(New_Earth) | Secret Identity | Brown Eyes | Brown Hair | Male Characters | Living Characters | 32 | 1954, September | 1954 | ||
904 | 904 | 23974 | Gretchen Kelley (New Earth) | \/wiki\/Gretchen_Kelley_(New_Earth) | Public Identity | Grey Hair | Female Characters | Living Characters | 31 | 1987, February | 1987 | |||
915 | 915 | 23343 | Amon Sur (New Earth) | \/wiki\/Amon_Sur_(New_Earth) | Public Identity | White Eyes | Male Characters | Deceased Characters | 30 | 2003, June | 2003 | |||
938 | 938 | 146367 | Blinky Boylan (New Earth) | \/wiki\/Blinky_Boylan_(New_Earth) | Red Hair | Male Characters | Deceased Characters | 30 | 1942, June | 1942 | ||||
940 | 940 | 146366 | Noddy Toylan (New Earth) | \/wiki\/Noddy_Toylan_(New_Earth) | Black Hair | Male Characters | Deceased Characters | 30 | 1942, June | 1942 | ||||
941 | 941 | 146364 | Winky Moylan (New Earth) | \/wiki\/Winky_Moylan_(New_Earth) | Brown Hair | Male Characters | Deceased Characters | 30 | 1942, June | 1942 | ||||
959 | 959 | 100920 | Denise Howard (New Earth) | \/wiki\/Denise_Howard_(New_Earth) | Public Identity | Brown Hair | Female Characters | Living Characters | 29 | 1984, April | 1984 | |||
960 | 960 | 2771 | Natalia Knight (New Earth) | \/wiki\/Natalia_Knight_(New_Earth) | Secret Identity | Blue Eyes | Black Hair | Female Characters | Living Characters | 29 | 1983, August | 1983 | ||
966 | 966 | 27578 | Medphyll (New Earth) | \/wiki\/Medphyll_(New_Earth) | Secret Identity | Black Eyes | Male Characters | Deceased Characters | 29 | 1962, March | 1962 | |||
1019 | 1019 | 42755 | Shlagen (New Earth) | \/wiki\/Shlagen_(New_Earth) | Public Identity | Orange Eyes | Male Characters | Living Characters | 27 | 1983, June | 1983 | |||
1028 | 1028 | 174272 | Robert West (New Earth) | \/wiki\/Robert_West_(New_Earth) | Public Identity | Brown Eyes | Brown Hair | Male Characters | Deceased Characters | 27 | 1960, November | 1960 | ||
1043 | 1043 | 202898 | Mrs. McIlvaine (New Earth) | \/wiki\/Mrs._McIlvaine_(New_Earth) | Grey Hair | Female Characters | Living Characters | 26 | 1993, February | 1993 | ||||
1049 | 1049 | 7561 | Dufus P. Ratchet (New Earth) | \/wiki\/Dufus_P._Ratchet_(New_Earth) | Secret Identity | Blue Eyes | Male Characters | Deceased Characters | 26 | 1984, October | 1984 | |||
1052 | 1052 | 1465 | Silver St. Cloud (New Earth) | \/wiki\/Silver_St._Cloud_(New_Earth) | Public Identity | Blue Eyes | Silver Hair | Female Characters | Deceased Characters | 26 | 1977, June | 1977 | ||
1061 | 1061 | 200080 | Wonder Boy (Earth-X) | \/wiki\/Wonder_Boy_(Earth-X) | Black Hair | Male Characters | Living Characters | 26 | 1940, July | 1940 | ||||
1075 | 1075 | 11376 | Baytor (New Earth) | \/wiki\/Baytor_(New_Earth) | Public Identity | Red Eyes | Living Characters | 25 | 1994, January | 1994 | ||||
1083 | 1083 | 3618 | Jerry McGee (New Earth) | \/wiki\/Jerry_McGee_(New_Earth) | Public Identity | Brown Eyes | Black Hair | Male Characters | Living Characters | 25 | 1987, October | 1987 | ||
1097 | 1097 | 48581 | Carlo di Rienzi (New Earth) | \/wiki\/Carlo_di_Rienzi_(New_Earth) | Black Hair | Male Characters | Deceased Characters | 25 | 1968, May | 1968 | ||||
1101 | 1101 | 24246 | Bonnie King (New Earth) | \/wiki\/Bonnie_King_(New_Earth) | Secret Identity | Blue Eyes | Blond Hair | Female Characters | Living Characters | 25 | 1960, November | 1960 | ||
1105 | 1105 | 92225 | Milagro Reyes (New Earth) | \/wiki\/Milagro_Reyes_(New_Earth) | Public Identity | Brown Eyes | Black Hair | Female Characters | Living Characters | 24 | 2006, May | 2006 | ||
1121 | 1121 | 69867 | Sarah Olsen (New Earth) | \/wiki\/Sarah_Olsen_(New_Earth) | Green Eyes | White Hair | Female Characters | Living Characters | 24 | 1988, March | 1988 | |||
1124 | 1124 | 116630 | Martin Allard (New Earth) | \/wiki\/Martin_Allard_(New_Earth) | Brown Eyes | Brown Hair | Male Characters | Living Characters | 24 | 1987, March | 1987 | |||
1125 | 1125 | 46055 | Franklin Berkowitz (New Earth) | \/wiki\/Franklin_Berkowitz_(New_Earth) | Public Identity | Brown Eyes | Grey Hair | Male Characters | Deceased Characters | 24 | 1986, November | 1986 | ||
1158 | 1158 | 3633 | Mason Trollbridge (New Earth) | \/wiki\/Mason_Trollbridge_(New_Earth) | Brown Eyes | Brown Hair | Male Characters | Living Characters | 23 | 1988, August | 1988 | |||
1161 | 1161 | 125877 | Mikhail Gorbachev (New Earth) | \/wiki\/Mikhail_Gorbachev_(New_Earth) | Public Identity | Blue Eyes | Male Characters | Living Characters | 23 | 1985, November | 1985 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "comic-characters/dc-wikia-data" ( "page_id" INTEGER, "name" TEXT, "urlslug" TEXT, "ID" TEXT, "ALIGN" TEXT, "EYE" TEXT, "HAIR" TEXT, "SEX" TEXT, "GSM" TEXT, "ALIVE" TEXT, "APPEARANCES" INTEGER, "FIRST APPEARANCE" TEXT, "YEAR" INTEGER );