Skip to content

Instantly share code, notes, and snippets.

View emanueles's full-sized avatar

Emanuele Santos emanueles

74 followers · 6 following
View GitHub Profile
@emanueles
emanueles / chicago_crimes_april_2020.csv
Created May 21, 2020 12:10
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 22 columns, instead of 11 in line 4.
ID,Case Number,Date,Block,IUCR,Primary Type,Description,Location Description,Arrest,Domestic,Beat,District,Ward,Community Area,FBI Code,X Coordinate,Y Coordinate,Year,Updated On,Latitude,Longitude,Location
12037033,JD216608,04/25/2020 02:10:00 AM,051XX W IRVING PARK RD,0610,BURGLARY,FORCIBLE ENTRY,OTHER (SPECIFY),true,false,1634,016,45,15,05,1141226,1926105,2020,05/20/2020 03:50:34 PM,41.953311263,-87.756240817,"(41.953311263, -87.756240817)"
12025205,JD203589,04/06/2020 09:49:00 PM,038XX W ROOSEVELT RD,031A,ROBBERY,ARMED - HANDGUN,GAS STATION,false,false,1011,010,24,29,03,1151170,1894442,2020,05/20/2020 03:50:34 PM,41.866235446,-87.720517147,"(41.866235446, -87.720517147)"
12051236,JD232928,04/15/2020 09:00:00 AM,026XX N WILTON AVE,0610,BURGLARY,FORCIBLE ENTRY,APARTMENT,false,false,1935,019,43,7,05,1169501,1917770,2020,05/20/2020 03:50:34 PM,41.92987016,-87.652543029,"(41.92987016, -87.652543029)"
12051207,JD226576,04/22/2020 03:00:00 PM,023XX N KEDVALE AVE,031A,ROBBERY,ARMED - HANDGUN,SIDEWALK,false,false,2
@emanueles
emanueles / chicago_crimes_april_2020.csv
Created May 21, 2020 10:43
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 22 columns, instead of 7 in line 4.
ID,Case Number,Date,Block,IUCR,Primary Type,Description,Location Description,Arrest,Domestic,Beat,District,Ward,Community Area,FBI Code,X Coordinate,Y Coordinate,Year,Updated On,Latitude,Longitude,Location
12036612,JD216292,04/24/2020 08:29:00 AM,077XX S ASHLAND AVE,0610,BURGLARY,FORCIBLE ENTRY,OTHER COMMERCIAL TRANSPORTATION,true,false,0612,006,17,71,05,1167021,1853303,2020,05/19/2020 03:49:26 PM,41.753020202,-87.663503874,"(41.753020202, -87.663503874)"
12035890,JD215487,04/23/2020 04:31:00 PM,042XX W POTOMAC AVE,0312,ROBBERY,ARMED - KNIFE / CUTTING INSTRUMENT,ALLEY,true,false,2534,025,37,23,03,1147975,1908323,2020,05/19/2020 03:49:26 PM,41.904388451,-87.731889224,"(41.904388451, -87.731889224)"
12029897,JD208660,04/14/2020 07:00:00 AM,004XX S RACINE AVE,0320,ROBBERY,STRONG ARM - NO WEAPON,CTA TRAIN,true,false,1231,012,28,28,03,1168451,1897951,2020,05/19/2020 03:49:26 PM,41.875508384,-87.656975687,"(41.875508384, -87.656975687)"
25097,JD219229,04/29/2020 06:09:00 AM,012XX W CARMEN AVE,0110,HOMICIDE,FIRST DE
@emanueles
emanueles / earthquakes.csv
Created May 12, 2020 17:35
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 21 columns, instead of 9 in line 4.
publicid,eventtype,origintime,modificationtime,longitude,latitude,magnitude,depth,magnitudetype,depthtype,evaluationmethod,evaluationstatus,evaluationmode,earthmodel,usedphasecount,usedstationcount,magnitudestationcount,minimumdistance,azimuthalgap,originerror,magnitudeuncertainty
2020p358691,earthquake,2020-05-12T17:11:06.047Z,2020-05-12T17:19:40.969Z,172.3584442,-41.26879501,2.435869517,5,M,operator assigned,LOCSAT,confirmed,manual,iasp91,22,17,5,0.1834658533,99.22260761,0.7286479924,0
2020p358554,earthquake,2020-05-12T15:57:50.645Z,2020-05-12T16:33:07.738Z,172.6057129,-41.20110703,2.408755894,112.5875549,M,,LOCSAT,confirmed,manual,iasp91,18,14,11,0.2284960449,88.80883789,0.3043284155,0
2020p358453,earthquake,2020-05-12T15:04:03.977Z,2020-05-12T16:41:44.798Z,176.1501465,-38.28736115,1.434866584,138.9638062,M,,LOCSAT,confirmed,manual,iasp91,19,13,2,0.4834079444,183.340683,0.3907514825,0
2020p358390,earthquake,2020-05-12T14:30:16.919Z,2020-05-12T14:34:26.494Z,176.6711426,-40.15535355,1.210343308,13.74729156,M
@emanueles
emanueles / nyc_weather_data.json
Created May 10, 2020 13:16
[{"time": 1514782800, "summary": "Clear throughout the day.", "icon": "clear-day", "sunriseTime": 1514809280, "sunsetTime": 1514842810, "moonPhase": 0.48, "precipIntensity": 0, "precipIntensityMax": 0, "precipProbability": 0, "temperatureHigh": 18.39, "temperatureHighTime": 1514836800, "temperatureLow": 12.23, "temperatureLowTime": 1514894400, "apparentTemperatureHigh": 17.29, "apparentTemperatureHighTime": 1514844000, "apparentTemperatureLow": 4.51, "apparentTemperatureLowTime": 1514887200, "dewPoint": -1.67, "humidity": 0.54, "pressure": 1028.26, "windSpeed": 4.16, "windGust": 13.98, "windGustTime": 1514829600, "windBearing": 309, "cloudCover": 0.02, "uvIndex": 2, "uvIndexTime": 1514822400, "visibility": 10, "temperatureMin": 6.17, "temperatureMinTime": 1514808000, "temperatureMax": 18.39, "temperatureMaxTime": 1514836800, "apparentTemperatureMin": -2.19, "apparentTemperatureMinTime": 1514808000, "apparentTemperatureMax": 17.29, "apparentTemperatureMaxTime": 1514844000, "date": "2018-01-01"}, {"time": 15148
@emanueles
emanueles / county_names.csv
Created October 22, 2019 14:35
id name state
01001 Autauga County AL
01003 Baldwin County AL
01005 Barbour County AL
01007 Bibb County AL
01009 Blount County AL
01011 Bullock County AL
01013 Butler County AL
01015 Calhoun County AL
01017 Chambers County AL
@emanueles
emanueles / fortaleza_crimes_populacao.csv
Created October 16, 2019 19:35
Bairro Homicidios Populacao
AEROLANDIA 17 11360
AEROPORTO 2 8618
JOSE DE ALENCAR 20 16003
ALDEOTA 8 42361
ALTO DA BALANCA 10 12814
ALVARO WEYNE 21 23690
AMADEU FURTADO 0 11703
ANCURI 18 20070
ANTONIO BEZERRA 16 25846
@emanueles
emanueles / homicidios_2012.csv
Created October 16, 2019 17:14
Bairro,Homicidios
AEROLANDIA,17
AEROPORTO,2
JOSE DE ALENCAR,20
ALDEOTA,8
ALTO DA BALANCA,10
ALVARO WEYNE,21
AMADEU FURTADO,0
ANCURI,18
ANTONIO BEZERRA,16
@emanueles
emanueles / FortalezaBairros.geojson
Created October 16, 2019 00:31
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@emanueles
emanueles / unemployment.tsv
Created October 15, 2019 23:38
id rate
01001 5.1
01003 4.9
01005 8.6
01007 6.2
01009 5.1
01011 7.1
01013 6.7
01015 6.1
01017 5.0
@emanueles
emanueles / us.json
Created October 15, 2019 23:36
{"type":"Topology","bbox":[-56.77775821661018,12.469025989284091,942.7924311762474,596.9298966319916],"transform":{"scale":[0.009995801851947097,0.005844667153098606],"translate":[-56.77775821661018,12.469025989284091]},"objects":{"counties":{"type":"GeometryCollection","geometries":[{"type":"Polygon","arcs":[[0,1,2,3,4]],"id":"05089"},{"type":"Polygon","arcs":[[5,6,7,8,9]],"id":"06079"},{"type":"Polygon","arcs":[[10,11,12,13,14,15,16]],"id":"17111"},{"type":"Polygon","arcs":[[17,18,19,20,21,22]],"id":"20131"},{"type":"Polygon","arcs":[[23,24,25,26,27,28,29]],"id":"28141"},{"type":"Polygon","arcs":[[30,31,32,33,34,35,36]],"id":"39009"},{"type":"Polygon","arcs":[[37,38,39,40,41]],"id":"48369"},{"type":"Polygon","arcs":[[42,43,44,45,46]],"id":"48211"},{"type":"Polygon","arcs":[[47,48,49,50,51,52]],"id":"01007"},{"type":"Polygon","arcs":[[53,54,55,56,57]],"id":"05111"},{"type":"Polygon","arcs":[[58,59,60,61,62,63]],"id":"19105"},{"type":"Polygon","arcs":[[64,65,66,67,68,69]],"id":"20111"},{"type":"Polygon","arcs