Skip to content

Instantly share code, notes, and snippets.

View prachow's full-sized avatar

Prathima Chowdary Sudalagunta prachow

0 followers · 1 following
View GitHub Profile
@prachow
prachow / crimes.csv
Created April 27, 2023 03:39
report_year rapes homicides assaults violence shots crimes
2023 4 2 5 1 5 8
2022 4 2 2 3 4 5
2021 5 3 2 5 3 1
2020 6 5 2 6 1 3
2019 8 4 3 6 1 6
@prachow
prachow / Indiacities.csv
Created April 24, 2023 03:05
city lat lng country iso2 admin_name capital population population_proper
Delhi 28.66 77.23 India IN Delhi admin 29617000 16753235
Mumbai 18.9667 72.8333 India IN Mahārāshtra admin 23355000 12478447
Kolkāta 22.5411 88.3378 India IN West Bengal admin 17560000 4496694
Bangalore 12.9699 77.598 India IN Karnātaka admin 13707000 8443675
Chennai 13.0825 80.275 India IN Tamil Nādu admin 11324000 6727000
Hyderābād 17.3667 78.4667 India IN Telangana admin 9746000 6993262
Pune 18.5196 73.8553 India IN Mahārāshtra 7764000 3124458
Ahmadābād 23.03 72.58 India IN Gujarāt minor 7410000 5570585
Sūrat 21.17 72.83 India IN Gujarāt 5807000 4466826
@prachow
prachow / Indiacities.csv
Created April 24, 2023 00:58
city lat lng country iso2 admin_name capital population population_proper
Delhi 28.6600 77.2300 India IN Delhi admin 29617000 16753235
Mumbai 18.9667 72.8333 India IN Mahārāshtra admin 23355000 12478447
Kolkāta 22.5411 88.3378 India IN West Bengal admin 17560000 4496694
Bangalore 12.9699 77.5980 India IN Karnātaka admin 13707000 8443675
Chennai 13.0825 80.2750 India IN Tamil Nādu admin 11324000 6727000
Hyderābād 17.3667 78.4667 India IN Telangana admin 9746000 6993262
Pune 18.5196 73.8553 India IN Mahārāshtra 7764000 3124458
Ahmadābād 23.0300 72.5800 India IN Gujarāt minor 7410000 5570585
Sūrat 21.1700 72.8300 India IN Gujarāt 5807000 4466826
@prachow
prachow / suicide.csv
Created April 17, 2023 02:23
We can't make this file beautiful and searchable because it's too large.
State,Year,Type_code,Type,Gender,Age_group,Total
A & N ISLANDS,2001,Causes,Cancer,Male,15-29,0
A & N ISLANDS,2001,Causes,Divorce,Male,60+,0
A & N ISLANDS,2001,Causes,Dowry Dispute,Female,60+,0
A & N ISLANDS,2001,Causes,Ideological Causes/Hero Worshipping,Female,60+,0
A & N ISLANDS,2001,Causes,Illness (Aids/STD),Female,0-14,0
A & N ISLANDS,2001,Causes,Paralysis,Male,45-59,0
A & N ISLANDS,2001,Causes,Property Dispute,Male,0-14,0
A & N ISLANDS,2001,Causes,Suspected/Illicit Relation,Female,15-29,0
A & N ISLANDS,2001,Means_adopted,By Consuming Insecticides,Female,0-14,0
@prachow
prachow / report.csv
Created April 5, 2023 22:42
report_year agency_code agency_jurisdiction violent_crimes homicides rapes assaults robberies crimes_percapita homicides_percapita rapes_percapita assaults_percapita robberies_percapita population
1975 NM00101 Albuquerque 2383 30 181 1353 819 832.52 10.48 63.23 472.68 286.13 286238
1975 TX22001 Arlington 278 5 28 132 113 247.16 4.45 24.89 117.36 100.46 112478
1975 GAAPD00 Atlanta 8033 185 443 3518 3887 1637.44 37.71 90.3 717.1 792.32 490584
1975 CO00101 Aurora 611 7 44 389 171 523.76 6 37.72 333.46 146.58 116656
1975 TX22701 Austin 1215 33 190 463 529 404.46 10.99 63.25 154.13 176.1 300400
1975 MD00301 Baltimore County 1259 25 137 347 750 196.06 3.89 21.33 54.04 116.79 642154
1975 MDBPD00 Baltimore 16086 259 463 6309 9055 1861.59 29.97 53.58 730.12 1047.91 864100
1975 MA01301 Boston 11386 119 453 3036 7778 1848.02 19.31 73.52 492.76 1262.42 616120
1975 NY01401 Buffalo 3350 63 192 755 2340 793.32 14.92 45.47 178.79 554.14 422276
@prachow
prachow / report.csv
Created April 5, 2023 22:36
report_year agency_code agency_jurisdiction violent_crimes homicides rapes assaults robberies crimes_percapita homicides_percapita rapes_percapita assaults_percapita robberies_percapita
1975 NM00101 Albuquerque 2383 30 181 1353 819 832.52 10.48 63.23 472.68 286.13
1975 TX22001 Arlington 278 5 28 132 113 247.16 4.45 24.89 117.36 100.46
1975 GAAPD00 Atlanta 8033 185 443 3518 3887 1637.44 37.71 90.3 717.1 792.32
1975 CO00101 Aurora 611 7 44 389 171 523.76 6 37.72 333.46 146.58
1975 TX22701 Austin 1215 33 190 463 529 404.46 10.99 63.25 154.13 176.1
1975 MD00301 Baltimore County 1259 25 137 347 750 196.06 3.89 21.33 54.04 116.79
1975 MDBPD00 Baltimore 16086 259 463 6309 9055 1861.59 29.97 53.58 730.12 1047.91
1975 MA01301 Boston 11386 119 453 3036 7778 1848.02 19.31 73.52 492.76 1262.42
1975 NY01401 Buffalo 3350 63 192 755 2340 793.32 14.92 45.47 178.79 554.14
@prachow
prachow / report.csv
Created April 5, 2023 20:14
report_year agency_code agency_jurisdiction population violent_crimes homicides rapes assaults robberies crimes_percapita homicides_percapita rapes_percapita assaults_percapita robberies_percapita
1975 NM00101 Albuquerque, NM 286238 2383 30 181 1353 819 832.52 10.48 63.23 472.68 286.13
1975 TX22001 Arlington, TX 112478 278 5 28 132 113 247.16 4.45 24.89 117.36 100.46
1975 GAAPD00 Atlanta, GA 490584 8033 185 443 3518 3887 1637.44 37.71 90.3 717.1 792.32
1975 CO00101 Aurora, CO 116656 611 7 44 389 171 523.76 6 37.72 333.46 146.58
1975 TX22701 Austin, TX 300400 1215 33 190 463 529 404.46 10.99 63.25 154.13 176.1
1975 MD00301 Baltimore County, MD 642154 1259 25 137 347 750 196.06 3.89 21.33 54.04 116.79
1975 MDBPD00 Baltimore, MD 864100 16086 259 463 6309 9055 1861.59 29.97 53.58 730.12 1047.91
1975 MA01301 Boston, MA 616120 11386 119 453 3036 7778 1848.02 19.31 73.52 492.76 1262.42
1975 NY01401 Buffalo, NY 422276 3350 63 192 755 2340 793.32 14.92 45.47 178.79 554.14
@prachow
prachow / crime.csv
Created April 3, 2023 02:18
1975 NM00101 Albuquerque, NM 286238 2383 30 181 1353 819 832.52 10.48 63.23 472.68 286.13
1975 TX22001 Arlington, TX 112478 278 5 28 132 113 247.16 4.45 24.89 117.36 100.46
1975 GAAPD00 Atlanta, GA 490584 8033 185 443 3518 3887 1637.44 37.71 90.3 717.1 792.32
1975 CO00101 Aurora, CO 116656 611 7 44 389 171 523.76 6 37.72 333.46 146.58
1975 TX22701 Austin, TX 300400 1215 33 190 463 529 404.46 10.99 63.25 154.13 176.1
1975 MD00301 Baltimore County, MD 642154 1259 25 137 347 750 196.06 3.89 21.33 54.04 116.79
1975 MDBPD00 Baltimore, MD 864100 16086 259 463 6309 9055 1861.59 29.97 53.58 730.12 1047.91
1975 MA01301 Boston, MA 616120 11386 119 453 3036 7778 1848.02 19.31 73.52 492.76 1262.42
1975 NY01401 Buffalo, NY 422276 3350 63 192 755 2340 793.32 14.92 45.47 178.79 554.14
@prachow
prachow / suicide.csv
Created April 2, 2023 22:38
We can't make this file beautiful and searchable because it's too large.
country,year,sex,age,suicides_no,population,suicides/100k pop,country-year,HDI for year, gdp_for_year ($) ,gdp_per_capita ($),generation
Albania,1995,male,25-34 years,13,232900,5.58,Albania1995,0.619,"2,424,499,009",835,Generation X
Albania,1995,male,55-74 years,9,178000,5.06,Albania1995,0.619,"2,424,499,009",835,Silent
Albania,1995,female,75+ years,2,40800,4.9,Albania1995,0.619,"2,424,499,009",835,G.I. Generation
Albania,1995,female,15-24 years,13,283500,4.59,Albania1995,0.619,"2,424,499,009",835,Generation X
Albania,1995,male,15-24 years,11,241200,4.56,Albania1995,0.619,"2,424,499,009",835,Generation X
Albania,1995,male,75+ years,1,25100,3.98,Albania1995,0.619,"2,424,499,009",835,G.I. Generation
Albania,1995,male,35-54 years,14,375900,3.72,Albania1995,0.619,"2,424,499,009",835,Boomers
Albania,1995,female,25-34 years,7,264000,2.65,Albania1995,0.619,"2,424,499,009",835,Generation X
Albania,1995,female,35-54 years,8,356400,2.24,Albania1995,0.619,"2,424,499,009",835,Boomers
@prachow
prachow / population.csv
Created April 2, 2023 22:07
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 14 columns, instead of 11 in line 9.
Year,Country,Population,Yearly % Change,Yearly Change,Migrants (net),Median Age,Fertility Rate,Density (P/Km²),Urban Pop %,Urban Population,Country's Share of World Pop %,World Population,Country Global Rank
2020,China,1439323776,0.39 ,5540090,-348399,38.4,1.69,153,60.8 ,875075919,18.47 ,7794798739,1
2019,China,1433783686,0.43 ,6135900,-348399,37.0,1.65,153,59.7 ,856409297,18.59 ,7713468100,1
2018,China,1427647786,0.47 ,6625995,-348399,37.0,1.65,152,58.6 ,837022095,18.71 ,7631091040,1
2017,China,1421021791,0.49 ,6972440,-348399,37.0,1.65,151,57.5 ,816957613,18.83 ,7547858925,1
2016,China,1414049351,0.51 ,7201481,-348399,37.0,1.65,151,56.3 ,796289491,18.94 ,7464022049,1
2015,China,1406847870,0.55 ,7607451,-310442,36.7,1.64,150,55.1 ,775352918,19.06 ,7379797139,1
2010,China,1368810615,0.57 ,7606847,-435677,35.0,1.62,146,48.9 ,669353557,19.68 ,6956823603,1
2005,China,1330776380,0.62 ,8045123,-393116,32.6,1.61,142,42.2 ,561983323,20.34 ,6541907027,1
2000,China,1290550765,0.79 ,9926046,-76600,30.0,1.62,137,35.7 ,4