Path: blob/master/lessons/lesson_18/carmen_sandiego_excercise/carmen.sqlite
1904 views
SQLite format 3 @ 9 -�� z t z � ++�wtablecountrylanguagecountrylanguage2CREATE TABLE "countrylanguage" ( "countrycode" TEXT, "language" TEXT, "isofficial" INTEGER, "percentage" REAL )�T�tablecountrycountry)CREATE TABLE "country" ( "code" TEXT, "name" TEXT, "continent" TEXT, "region" TEXT, "surfacearea" REAL, "indepyear" REAL, "population" INTEGER, "lifeexpectancy" REAL, "gnp" REAL, "gnpold" REAL, "localname" TEXT, "governmentform" TEXT, "headofstate" TEXT, "capital" REAL, "code2" TEXT )� �utablecitycityCREATE TABLE "city" ( "id" INTEGER, "name" TEXT, "countrycode" TEXT, "district" TEXT, "population" INTEGER ) %# (���������������������}wqke_YSMGA;5/)# � � � � _ 0 � � � ~ U , ����sT9�����dK ����e;���vD+ ���mB���|Y4���hH*���[2 � nnFormosaARGFormosa@�%m%%mSan FernandoARGBuenos AiresU�'l)%lItuzaing�ARGBuenos Airesi�%k%%kNeuqu�nARGNeuqu�n��#j!%jHurlinghamARGBuenos Aires�,'i7iSan Salvador de JujuyARGJujuy�<3h33hSantiago del EsteroARGSantiago del Estero��#g+gGuaymall�nARGMendoza�ffPosadasARGMisiones9e!eGodoy CruzARGMendoza(�"d#!dParan�ARGEntre Rios(�)c-%cJos� C. PazARGBuenos Airesb:b#bResistenciaARGChaco\0a;%aEsteban Echeverr�aARGBuenos Aires��*`/%`Bah�a BlancaARGBuenos Aires��#_!%_San MiguelARGBuenos Aires�|!^!!^CorrientesARGCorrientes�7$]#%]BerazateguiARGBuenos Aires9�+\1%\Vicente L�pezARGBuenos AiresfU,[3%[Malvinas ArgentinasARGBuenos AiresnZ%ZTigreARGBuenos Aires�"#Y!%YSan IsidroARGBuenos Aires��)X-%XFlorencio VarelaARGBuenos Aires�(#W!%WMor�nARGBuenos AiresT>(V+%VTres de FebreroARGBuenos Aires`7#U!%UAvellanedaARGBuenos Airesc'T''TSanta F�ARGSanta F�c'S%SMorenoARGBuenos Airesr�RRSaltaARGSalta��0Q;%QGeneral San Mart�nARGBuenos Airesr�P%PMerloARGBuenos Aires�#O!%OLan�sARGBuenos Aires*�3NA%NSan Miguel de Tucum�nARGTucum�n/&M'%MMar del PlataARGBuenos Aires�p!L%LLa PlataARGBuenos Aires��(K+%KAlmirante BrownARGBuenos Aires9& J%JQuilmesARGBuenos Aires��(I+%ILomas de ZamoraARGBuenos Aires }�!H'HRosarioARGSanta F� ��%G%%GC�rdobaARGC�rdoba��#F!%FLa MatanzaARGBuenos AiresS)E%-EBuenos AiresARGDistrito Federal-�DDAjmanAREAjman��CCal-AynAREAbu Dhabir�BBSharjaARESharja�_AAAbu DhabiAREAbu Dhabig@@DubaiAREDubai 5�$?/?Saint John�sATGSt John]�>!>The ValleyAIA�S=!=South HillAIA��<<NamibeAGONamibe;;BenguelaAGOBenguela�,::LobitoAGOBenguela��99HuamboAGOHuambo}88LuandaAGOLuanda�p,7--7Andorra la VellaANDAndorra la VellaR�66FagatogoASMTutuila 55TafunaASMTutuilaP'4''4Gharda�aDZAGharda�a]G'373Ech-Chleff (el-Asnam)DZAChlefz22TiaretDZATiaret�#1##1B�charDZAB�char�/&010Tlemcen (Tilimsen)DZATlemcen��%/%%/T�bessaDZAT�bessa��!.!!.MostaganemDZAMostaganem�-----B�ja�aDZAB�ja�aɪ%,3,Blida (el-Boulaida)DZABlida�4++BiskraDZABiskra�**SkikdaDZASkikda��3)33)Sidi Bel Abb�sDZASidi Bel Abb�sV!(!!(S�tifDZAS�tif�o''BatnaDZABatna�Q&&AnnabaDZAAnnabae6#%##%ConstantineDZAConstantine�O$$OranDZAOran N##AlgerDZAAlger!�""TiranaALBTirana�"!!%!WillemstadANTCura�ao )! ' AlkmaarNLDNoord-Hollandj)HeerlenNLDLimburgsL%DelftNLDZuid-Hollandt$!EdeNLDGelderland��!ZwolleNLDOverijssel�[EmmenNLDDrenthe�}#!%ZoetermeerNLDZuid-Holland��()'HaarlemmermeerNLDNoord-Holland��%LeidenNLDZuid-Holland��"%DordrechtNLDZuid-Holland�!MaastrichtNLDLimburg��!AmersfoortNLDUtrecht�>/7'�s-HertogenboschNLDNoord-Brabant��"'ZaanstadNLDNoord-Holland�!ArnhemNLDGelderland$AlmereNLDFlevoland,�!'HaarlemNLDNoord-HollandE$!EnschedeNLDOverijsselH(!NijmegenNLDGelderlandS� ! ApeldoornNLDGelderlandW�'BredaNLDNoord-Brabantr�GroningenNLDGroningen��! ' TilburgNLDNoord-Brabant��# ' EindhovenNLDNoord-BrabantsUtrechtNLDUtrecht '�&