CatTrinket
/ hyphenated-pokemon.txt
Last active
August 29, 2015 14:18
all the Pokémon, hyphenated using TeX's algorithm
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Bul-basaur | |
| Ivysaur | |
| Venusaur | |
| Char-man-der | |
| Charmeleon | |
| Charizard | |
| Squir-tle | |
| Wartor-tle | |
| Blas-toise | |
| Cater-pie |
CatTrinket
/ weather-chumps.txt
Created
April 3, 2015 04:36
Pokémon with at most one weather move in ASB
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| pokemon | move | |
| ---------------------+------------ | |
| bulbasaur | sunny-day | |
| ivysaur | sunny-day | |
| venusaur | sunny-day | |
| venusaur-mega | sunny-day | |
| charmander | sunny-day | |
| charmeleon | sunny-day | |
| caterpie | | |
| metapod | |
CatTrinket
/ census-by-family.txt
Last active
March 10, 2019 02:58
ASB Pokémon tallies by family, updated 2019-03-10 02:58Z
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root stage | count | |
| ------------+------- | |
| eevee | 50 | |
| ralts | 43 | |
| luvdisc | 36 | |
| meowth | 30 | |
| charmander | 26 | |
| shinx | 26 | |
| gastly | 25 | |
| magikarp | 25 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| pokemon | moves | |
| -----------------------+------- | |
| mew | 242 | |
| clefable | 144 | |
| clefairy | 141 | |
| mewtwo | 134 | |
| mewtwo-mega-x | 134 | |
| mewtwo-mega-y | 134 | |
| gallade | 131 | |
| gallade-mega | 131 |
CatTrinket
/ happiness-evos.txt
Last active
August 29, 2015 14:15
Base happiness of pre- and post-evolution happiness evos
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| identifier | base_happiness | |
| ------------+---------------- | |
| pichu | 70 | |
| pikachu | 70 | |
| cleffa | 140 | |
| clefairy | 140 | |
| igglybuff | 70 | |
| jigglypuff | 70 | |
| golbat | 70 | |
| crobat | 70 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| attacking | defending | result | |
| -----------+-----------+-------------------- | |
| normal | normal | neutral | |
| normal | fire | neutral | |
| normal | water | neutral | |
| normal | grass | neutral | |
| normal | electric | neutral | |
| normal | ice | neutral | |
| normal | fighting | neutral | |
| normal | poison | neutral |
CatTrinket
/ wonder-losers.txt
Last active
March 10, 2019 03:02
stuff that can't hit Shedinja in ASB
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| asb_test=> select identifier from pokemon_forms pf where not exists (select 1 from pokemon_form_moves pfm join moves m on pfm.move_id=m.id join types t on m.type_id=t.id where pfm.pokemon_form_id=pf.id and m.damage_class_id != 3 and t.identifier in ('dark', 'fire', 'flying', 'ghost', 'rock')) order by "order"; | |
| identifier | |
| ------------------- | |
| caterpie | |
| metapod | |
| weedle | |
| kakuna | |
| oddish | |
| ditto | |
| sunkern |
CatTrinket
/ catch-rate.txt
Last active
August 29, 2015 14:09
all distinct Pokémon catch rates (in X/Y)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| rate | count | example | |
| ------+-------+------------ | |
| 3 | 45 | articuno | |
| 5 | 2 | kyogre | |
| 15 | 1 | volcarona | |
| 25 | 10 | clefable | |
| 30 | 21 | chansey | |
| 35 | 1 | ditto | |
| 45 | 224 | bulbasaur | |
| 50 | 7 | wigglytuff |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [zhorken@yagouaroundi:~/Music] » ls -1 * | |
| Alanis Morissette: | |
| 1995 - Jagged Little Pill | |
| 2002 - Under Rug Swept | |
| 2005 - Jagget Little Pill Acoustic | |
| Alan Menken: | |
| 2010 - Tangled | |
| Belly: |
CatTrinket
/ long_pokemon.txt
Last active
August 29, 2015 14:05
Pokémon names that are at least eleven characters (actual game languages that don't reuse English names)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| pokedex=> select l.identifier lang, ps.identifier pokemon, psn.name from pokemon_species_names psn join pokemon_species ps on psn.pokemon_species_id=ps.id join languages l on psn.local_language_id=l.id where length(name) >= 11 and l.identifier not in ('roomaji', 'es', 'it') order by l.order, ps.order; | |
| lang | pokemon | name | |
| ------+-------------+-------------- | |
| en | fletchinder | Fletchinder | |
| fr | chesnaught | Blindépique | |
| fr | diggersby | Excavarenne | |
| fr | scatterbug | Lépidonille | |
| fr | skiddo | Cabriolaine | |
| fr | pancham | Pandespiègle | |
| fr | slurpuff | Cupcanaille |