Skip to content

Instantly share code, notes, and snippets.

@dannguyen

dannguyen/sample-wapo-homicide-db.csv

Created June 6, 2018 20:55
Show Gist options
  • Save dannguyen/305186a52ab5514ada897078d8e2a800 to your computer and use it in GitHub Desktop.
Save dannguyen/305186a52ab5514ada897078d8e2a800 to your computer and use it in GitHub Desktop.
Download ZIP
Via the WaPo's June 2018 homicide investigation https://github.com/washingtonpost/data-homicides
Raw
sample-wapo-homicide-db.csv
uid reported_date victim_last victim_first victim_race victim_age victim_sex city state lat lon disposition
Alb-000001 20100504 GARCIA JUAN Hispanic 78 Male Albuquerque NM 35.0957885 -106.5385549 Closed without arrest
Alb-000002 20100216 MONTOYA CAMERON Hispanic 17 Male Albuquerque NM 35.0568104 -106.715321 Closed by arrest
Alb-000003 20100601 SATTERFIELD VIVIANA White 15 Female Albuquerque NM 35.086092 -106.695568 Closed without arrest
Alb-000004 20100101 MENDIOLA CARLOS Hispanic 32 Male Albuquerque NM 35.0784929 -106.5560938 Closed by arrest
Alb-000005 20100102 MULA VIVIAN White 72 Female Albuquerque NM 35.1303568 -106.5809862 Closed without arrest
Alb-000006 20100126 BOOK GERALDINE White 91 Female Albuquerque NM 35.15111 -106.537797 Open/No arrest
Alb-000007 20100127 MALDONADO DAVID Hispanic 52 Male Albuquerque NM 35.1117847 -106.7126144 Closed by arrest
Alb-000008 20100127 MALDONADO CONNIE Hispanic 52 Female Albuquerque NM 35.1117847 -106.7126144 Closed by arrest
Alb-000009 20100130 MARTIN-LEYVA GUSTAVO White 56 Male Albuquerque NM 35.0753799 -106.5534583 Open/No arrest
Alb-000010 20100210 HERRERA ISRAEL Hispanic 43 Male Albuquerque NM 35.0659296 -106.5722875 Open/No arrest
Alb-000011 20100212 BARRIUS-CAMPANIONI HECTOR Hispanic 20 Male Albuquerque NM 35.0773747 -106.5605695 Closed by arrest
Alb-000012 20100218 LUJAN KEVIN White Unknown Male Albuquerque NM 35.077011 -106.56491 Closed without arrest
Alb-000013 20100222 COLLAMORE JOHN Hispanic 46 Male Albuquerque NM 35.0640762 -106.6082814 Open/No arrest
Alb-000014 20100306 CHIQUITO CORIN Other 16 Male Albuquerque NM 35.0414912 -106.7421466 Closed by arrest
Alb-000015 20100308 TORRES HECTOR Hispanic 54 Male Albuquerque NM 35.0706565 -106.6158449 Closed by arrest
Alb-000016 20100308 GRAY STEFANIA White 43 Female Albuquerque NM 35.0706565 -106.6158449 Closed by arrest
Alb-000017 20100322 LEYVA JOEL Hispanic 52 Male Albuquerque NM 35.0790821 -106.4959493 Closed by arrest
Alb-000018 20100323 DAVID LARRY White 52 Male Albuquerque NM Closed by arrest
Alb-000019 20100402 BRITO ELIZABETH White 22 Female Albuquerque NM 35.1104043 -106.5236679 Closed by arrest
Alb-000020 20100420 CHAVEZ GREG SR. Hispanic 49 Male Albuquerque NM 35.0895725 -106.5700776 Closed by arrest
Alb-000021 20100423 KING TEVION Black 15 Male Albuquerque NM 35.0958872 -106.6380811 Closed by arrest
Alb-000022 20100423 BOYKIN CEDRIC Black 25 Male Albuquerque NM 35.0958872 -106.6380811 Closed by arrest
Alb-000023 20100518 BARRAGAN MIGUEL White 20 Male Albuquerque NM 35.0834013 -106.6329406 Closed by arrest
Alb-000024 20100602 FORD LUTHER Other 47 Male Albuquerque NM 35.1024226 -106.5676745 Closed by arrest
Alb-000025 20100602 WRONSKI VIOLA White 88 Female Albuquerque NM 35.0959563 -106.5611352 Closed without arrest
Alb-000026 20100603 ASHFORD GUADALUPE Hispanic 27 Female Albuquerque NM 35.0784617 -106.551755 Closed by arrest
Alb-000027 20100712 TURNER MICHELLE White 36 Female Albuquerque NM 35.0537478 -106.5317998 Closed without arrest
Alb-000028 20100712 CUNNINGHAM SHARON White 47 Female Albuquerque NM 35.0537478 -106.5317998 Closed without arrest
Alb-000029 20100726 NGUYEN SELENAVI Asian 1 Female Albuquerque NM 35.0644563 -106.5244581 Closed without arrest
Alb-000030 20100728 VALDEZ BILL Hispanic 58 Male Albuquerque NM 35.0618273 -106.749104 Open/No arrest
Alb-000031 20100728 GOMEZ-HERNANDEZ ANGEL Hispanic 42 Male Albuquerque NM 35.0740251 -106.5617179 Closed without arrest
Alb-000032 20100818 MARTINEZ LAWRENCE Hispanic 50 Male Albuquerque NM 35.0766724 -106.5840562 Closed by arrest
Alb-000033 20100820 CORIZ EMMA Other 3 Female Albuquerque NM 35.0722449 -106.5704919 Closed by arrest
Alb-000034 20100822 MONTOYA-SANTANA JULIAN Hispanic 1 Male Albuquerque NM 35.0733998 -106.695892 Closed by arrest
Alb-000035 20100822 SANTANA-HERNANDEZ YURIKO Hispanic 21 Female Albuquerque NM 35.0733998 -106.695892 Closed by arrest
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment