Skip to content

Instantly share code, notes, and snippets.

@guangxinhu
guangxinhu / Global Earthquake Database
Last active October 24, 2019 06:55
Significant Earthquake Database
Year,Mo,Dy,Hr,Mn,Sec,Tsu,Name,Latitude,Longitude,FocalDepth,Mag,DeathNum,DeathDe,InjuriesNum,InjuriesDe,DamageMill,DamageDe,HouseDestroyedNum,HouseDestroyedDe,HouseDamagedNum,HouseDamagedDe
1970,1,4,17,0,40.2,No-Tsu,CHINA:YUNNANPROVINCE;VIETNAM:HANOI,24.1,102.5,31,7.8,10000,4,,,,3,,3,,3
1970,1,10,12,7,8.6,Tsunami,PHILIPPINES:MINDANAO,6.8,126.7,73,7.6,,,,,,,,,,
1970,2,5,22,5,58.3,No-Tsu,"PHILIPPINES:LUZON,ROMBLONI;TABLASI:ODIONGAN",12.6,122.1,11,7.1,3,1,,2,,2,,,,
1970,2,14,11,17,16.1,No-Tsu,"PERU:PANAO,CHACLLA,QUERO,AYLLAMARCA,LALINDA",-9.9,-75.6,35,5.4,12,1,,,,3,,3,,
1970,3,11,22,38,34.6,Tsunami,ALASKA:ANDREANOFISLANDS,57.5,-153.9,29,6,,,,,,1,,,,
1970,3,14,1,51,44.4,No-Tsu,"IRAN:BADALAN,QERIS,BATCHI,DIZEH,PESAK,HESAR",38.6,44.7,23,4.8,5,1,,,,2,,3,,
1970,3,23,1,52,59.3,No-Tsu,INDIA:BROACH,21.7,73,3,5.4,26,1,200,3,,2,,,,
1970,3,28,21,2,23.4,No-Tsu,TURKEY:GEDIZ,39.2,29.5,20,7.4,1086,4,1174,4,55.6,4,8229,4,8229,4
1970,4,7,5,34,5.6,Tsunami,PHILIPPINES:LUZON,15.78,121.71,40,7.3,15,1,200,3,,2,,,,
@guangxinhu
guangxinhu / Earthquake_year_city
Last active September 19, 2019 03:15
Earthquake count for year and city
year,city,count
1911,antalya,1
1912,canakkale,1
1912,marmara_denizi,2
1912,tekirdag,5
1913,bitlis,1
1914,adiyaman,1
1914,afyonkarahisar,15
1914,aydin,1
1914,burdur,1
@guangxinhu
guangxinhu / README.md
Last active September 19, 2019 03:24
US Population Time Series Data

This is US population data at Kaggle: Population Time Series Data. The intercensal estimates for 1990-2000 for the United States population are produced by converting the 1990-2000 postcensal estimates prepared previously for the U. S. to account for differences between the postcensal estimates in 2000 and census counts (error of closure). The postcensal estimates for 1990 to 2000 were produced by updating the resident population enumerated in the 1990 census by estimates of the components of population change between April 1, 1990 and April 1, 2000-- births to U.S. resident women, deaths to U.S. residents, net international migration (incl legal & residual foreign born), and net movement of the U.S. armed forces and civilian citizens to the United States. Intercensal population estimates for 1990 to 2000 are derived from the postcensal estimates by distributing the error of closure over the decade by month. The method used for the 1990s for distrib

@guangxinhu
guangxinhu / Earthquakes
Last active September 19, 2019 03:18
Earthquakes in Turkey
id,date,time,lat,long,country,city,area,direction,dist,depth,xm,md,richter,mw,ms,mb
2.00E+13,2003.05.20,12:17:44 AM,39.04,40.38,turkey,bingol,baliklicay,west,0.1,10,4.1,4.1,0,,0,0
2.01E+13,2007.08.01,12:03:08 AM,40.79,30.09,turkey,kocaeli,bayraktar_izmit,west,0.1,5.2,4,3.8,4,,0,0
1.98E+13,1978.05.07,12:41:37 AM,38.58,27.61,turkey,manisa,hamzabeyli,south_west,0.1,0,3.7,0,0,,0,3.7
2.00E+13,1997.03.22,12:31:45 AM,39.47,36.44,turkey,sivas,kahvepinar_sarkisla,south_west,0.1,10,3.5,3.5,0,,0,0
2.00E+13,2000.04.02,12:57:38 AM,40.8,30.24,turkey,sakarya,meseli_serdivan,south_west,0.1,7,4.3,4.3,0,,0,0
2.01E+13,2005.01.21,12:04:03 AM,37.11,27.75,turkey,mugla,demirciler_milas,south_west,0.1,32.8,3.5,3.5,0,,0,0
2.01E+13,2012.06.24,12:07:22 AM,38.75,43.61,turkey,van,ilikaynak,south_west,0.1,9.4,4.5,0,4.5,,0,0
1.99E+13,1987.12.31,12:49:54 AM,39.43,27.98,turkey,balikesir,dikkonak_bigadic,south_east,0.1,26,3.8,3.8,0,,0,0
2.00E+13,2000.02.07,12:11:45 AM,40.05,34.07,turkey,kirikkale,kocabas_delice,south_east,0.1,1,3.8,3.8,0,,0,0
@guangxinhu
guangxinhu / EmployeeReimbursements.csv
Last active September 19, 2019 03:29
Chicago Employee Reimbursements
We can't make this file beautiful and searchable because it's too large.
VOUCHER NUMBER,AMOUNT,PAYMENT DATE,VENDOR NAME,DESCRIPTION,DEPARTMENT
PV50195031199,250.63,2019-08-29T00:00:00.000,"MOY, CERIDWEN","Employee travel reimbursement to New York, NY on June 16, 2019 to June 19, 2019.",DEPT OF FAMILY AND SUPPORT SERVICES
PV48194800043,38.5,2019-08-29T00:00:00.000,"AVALOS, JOSELUIS",Reimburse for Public Trans Fees,OFFICE FOR PEOPLE WITH DISABILITIES
PV35193500063,1394.51,2019-08-29T00:00:00.000,"LANGREHR, JULIE K",Employee Reimbursement for Conference Attendance,DEPT OF PROCUREMENT SERVICES
PV45194500065,495,2019-08-28T00:00:00.000,"GUNN, KENNETH A",Employee's August Conference Fee Reimbursement,COMMISSION ON HUMAN RELATIONS
PV84198408118,1855.87,2019-08-28T00:00:00.000,"CITY LIGHTS, LIMITED/ZSL ELECTRIC",REFUND OF DEPOST WORK ORDER 11515069,CHICAGO DEPARTMENT OF TRANSPORTATION
PV57195795294,90,2019-08-28T00:00:00.000,"BRYANT, SANDRA G","REIMBURSEMENT/COOK COUNTY RETAIL ORGANIZED CRIME TASK FORCE TRAINING/OAKBROOK, IL/4-5 SEP 2019",DEPARTMENT OF POLICE
PV57195795295,11722.8,2019-08
@guangxinhu
guangxinhu / Pizza.csv
Last active September 19, 2019 03:33
Pizza Restaurants and the Pizza They Sell
We can't make this file beautiful and searchable because it's too large.
id,dateAdded,dateUpdated,address,categories,primaryCategories,city,country,keys,latitude,longitude,menuPageURL,menus.amountMax,menus.amountMin,menus.currency,menus.dateSeen,menus.description,menus.name,name,postalCode,priceRangeCurrency,priceRangeMin,priceRangeMax,province
AVz3Y-7h3D1zeR_xDAqm,2017-06-30T05:05:40Z,2019-05-01T15:43:09Z,4203 E Kiehl Ave,"Pizza,Restaurant,American restaurants,Pizza Place,Restaurants",Accommodation & Food Services,Sherwood,US,us/ar/sherwood/4203ekiehlave/-1051391616,34.8323,-92.1838,http://www.citysearch.com/profile/menu/1550074?singlePlatformId=shotgun-dans-pizza,7.98,7.98,USD,"2018-05-01T04:25:37.197Z,2018-04-16T04:36:02.356Z,2018-02-15T19:58:01.612Z,2018-04-02T23:29:46.353Z,2018-06-28T11:37:25.942Z",,Cheese Pizza,Shotgun Dans Pizza,72120,USD,0,25,AR
AVweGPFF_7pvs4fzAAzQ,2016-04-02T04:02:49Z,2019-05-01T15:27:50Z,25 E Camelback Rd,"Pizza,Pizza Place,Restaurants",Accommodation & Food Services,Phoenix,US,us/az/phoenix/25ecamelbackrd/-727422936,33.509266,-112.073044,,6,6,USD,"2018-
@guangxinhu
guangxinhu / HousePrice.csv
Last active September 19, 2019 03:36
House Price in Ames, Iowa
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 81 columns, instead of 37. in line 1.
Id,MSSubClass,MSZoning,LotFrontage,LotArea,Street,Alley,LotShape,LandContour,Utilities,LotConfig,LandSlope,Neighborhood,Condition1,Condition2,BldgType,HouseStyle,OverallQual,OverallCond,YearBuilt,YearRemodAdd,RoofStyle,RoofMatl,Exterior1st,Exterior2nd,MasVnrType,MasVnrArea,ExterQual,ExterCond,Foundation,BsmtQual,BsmtCond,BsmtExposure,BsmtFinType1,BsmtFinSF1,BsmtFinType2,BsmtFinSF2,BsmtUnfSF,TotalBsmtSF,Heating,HeatingQC,CentralAir,Electrical,1stFlrSF,2ndFlrSF,LowQualFinSF,GrLivArea,BsmtFullBath,BsmtHalfBath,FullBath,HalfBath,BedroomAbvGr,KitchenAbvGr,KitchenQual,TotRmsAbvGrd,Functional,Fireplaces,FireplaceQu,GarageType,GarageYrBlt,GarageFinish,GarageCars,GarageArea,GarageQual,GarageCond,PavedDrive,WoodDeckSF,OpenPorchSF,EnclosedPorch,3SsnPorch,ScreenPorch,PoolArea,PoolQC,Fence,MiscFeature,MiscVal,MoSold,YrSold,SaleType,SaleCondition,SalePrice
1,60,RL,65,8450,Pave,NA,Reg,Lvl,AllPub,Inside,Gtl,CollgCr,Norm,Norm,1Fam,2Story,7,5,2003,2003,Gable,CompShg,VinylSd,VinylSd,BrkFace,196,Gd,TA,PConc,Gd,TA,No,GLQ,706,Unf,