tutorial.sf_crime_incidents_cleandate
tutorial
Updated about 4 years ago
Rows
30,400Preview
| incidnt_num | category | descript | day_of_week | date | time | pd_district | resolution | address | lon | lat | location | cleaned_date | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131025757.0 |
DRUG/NARCOTIC |
POSSESSION OF HEROIN |
Thursday |
12/05/2013 08:00:00 AM +0000 |
10:58 |
TENDERLOIN |
ARREST, BOOKED |
JONES ST / GOLDEN GATE AV |
-122.4122242 |
37.78207293 |
(37.7820729312029, -122.412224164736) |
2013-12-05T10:58:00 |
18543 |
140069920.0 |
SUSPICIOUS OCC |
SUSPICIOUS OCCURRENCE |
Friday |
01/24/2014 08:00:00 AM +0000 |
11:50 |
RICHMOND |
ARREST, BOOKED |
500 Block of JOHNFKENNEDY DR |
-122.4658382 |
37.77249655 |
(37.7724965522266, -122.465838183623) |
2014-01-24T11:50:00 |
2531 |
131065151.0 |
NON-CRIMINAL |
AIDED CASE, MENTAL DISTURBED |
Thursday |
12/19/2013 08:00:00 AM +0000 |
6:30 |
BAYVIEW |
PSYCHOPATHIC CASE |
200 Block of WILLIAMS AV |
-122.3974087 |
37.72990851 |
(37.7299085069905, -122.397408700897) |
2013-12-19T06:30:00 |
13796 |
140058804.0 |
FORGERY/COUNTERFEITING |
COUNTERFEITING, POSSESSION COINS OR NOTES |
Monday |
01/20/2014 08:00:00 AM +0000 |
19:30 |
BAYVIEW |
NONE |
1600 Block of PALOU AV |
-122.3914528 |
37.73424642 |
(37.7342464235843, -122.391452821826) |
2014-01-20T19:30:00 |
3903 |
140056892.0 |
VANDALISM |
MALICIOUS MISCHIEF, VANDALISM |
Monday |
01/20/2014 08:00:00 AM +0000 |
9:02 |
BAYVIEW |
NONE |
100 Block of KISKA RD |
-122.3767663 |
37.73006223 |
(37.7300622319132, -122.376766338772) |
2014-01-20T09:02:00 |
3776 |
140062924.0 |
NON-CRIMINAL |
LOST PROPERTY |
Friday |
01/17/2014 08:00:00 AM +0000 |
11:00 |
RICHMOND |
NONE |
5200 Block of GEARY BL |
-122.4751025 |
37.78055834 |
(37.7805583429188, -122.475102499829) |
2014-01-17T11:00:00 |
5046 |
140080136.0 |
DRUG/NARCOTIC |
SALE OF BASE/ROCK COCAINE |
Monday |
01/27/2014 08:00:00 AM +0000 |
17:12 |
TENDERLOIN |
ARREST, BOOKED |
GOLDEN GATE AV / HYDE ST |
-122.4155082 |
37.78165428 |
(37.7816542806075, -122.415508242782) |
2014-01-27T17:12:00 |
1502 |
140037767.0 |
ASSAULT |
BATTERY |
Tuesday |
01/14/2014 08:00:00 AM +0000 |
6:40 |
MISSION |
ARREST, CITED |
1000 Block of POTRERO AV |
-122.4066566 |
37.75682561 |
(37.7568256145423, -122.406656623063) |
2014-01-14T06:40:00 |
6019 |
140034597.0 |
SUSPICIOUS OCC |
SUSPICIOUS OCCURRENCE |
Monday |
01/13/2014 08:00:00 AM +0000 |
6:10 |
MISSION |
NONE |
200 Block of 13TH ST |
-122.4167555 |
37.77169755 |
(37.7716975465666, -122.416755532165) |
2014-01-13T06:10:00 |
6390 |
140041542.0 |
MISSING PERSON |
MISSING ADULT |
Wednesday |
01/15/2014 08:00:00 AM +0000 |
9:50 |
SOUTHERN |
NONE |
700 Block of MISSION ST |
-122.4038902 |
37.78462377 |
(37.784623766879, -122.403890223654) |
2014-01-15T09:50:00 |
5739 |