Pivot Table Maps
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Pivot Table Map from DC Crime Data
http://www.benlcollins.com/
2
Feel free to make your own copy so you have editing rights.
File > Make a copy...
3
4
Article
https://www.benlcollins.com/spreadsheets/pivot-table-map/
5
Data Source:
http://opendata.dc.gov/
6
Also available here:
https://data.world/dcopendata/washington-dc-crime-incidents
7
8
OrderLongitudeLatitudeSHIFTOFFENSEMETHODRlon2Rlat2Rlon3Rlat3
9
1-76.9469775238.89335387MIDNIGHTROBBERYGUN-76.9538.89-76.94738.893
10
2-77.0385202838.90425067MIDNIGHTHOMICIDEKNIFE-77.0438.9-77.03938.904
11
3-77.0265280438.8983175MIDNIGHT
ASSAULT W/DANGEROUS WEAPON
OTHERS-77.0338.9-77.02738.898
12
4-77.0279158638.93921499MIDNIGHT
THEFT F/AUTO
OTHERS-77.0338.94-77.02838.939
13
5-76.9704227738.86777833MIDNIGHT
THEFT F/AUTO
OTHERS-76.9738.87-76.9738.868
14
6-76.9152960838.89748806MIDNIGHTROBBERYGUN-76.9238.9-76.91538.897
15
7-77.0090303438.82067656MIDNIGHT
ASSAULT W/DANGEROUS WEAPON
GUN-77.0138.82-77.00938.821
16
8-77.0309312138.92376498MIDNIGHTROBBERYOTHERS-77.0338.92-77.03138.924
17
9-76.9549571738.88878998MIDNIGHTBURGLARYOTHERS-76.9538.89-76.95538.889
18
10-77.0250989638.96495226MIDNIGHT
ASSAULT W/DANGEROUS WEAPON
OTHERS-77.0338.96-77.02538.965
19
11-77.0327957438.90253056MIDNIGHT
THEFT/OTHER
OTHERS-77.0338.9-77.03338.903
20
12-77.0425792938.90565456MIDNIGHT
THEFT/OTHER
OTHERS-77.0438.91-77.04338.906
21
13-76.9949771738.88323137MIDNIGHTROBBERYGUN-76.9938.88-76.99538.883
22
14-76.9549571738.88878998MIDNIGHTBURGLARYOTHERS-76.9538.89-76.95538.889
23
15-76.9229555838.90348392MIDNIGHT
THEFT/OTHER
OTHERS-76.9238.9-76.92338.903
24
16-76.9542544638.88817713MIDNIGHT
THEFT F/AUTO
OTHERS-76.9538.89-76.95438.888
25
17-76.9306652638.90664167MIDNIGHT
THEFT/OTHER
OTHERS-76.9338.91-76.93138.907
26
18-77.0448988138.9091129MIDNIGHT
THEFT F/AUTO
OTHERS-77.0438.91-77.04538.909
27
19-77.034898938.97226444DAYROBBERYKNIFE-77.0338.97-77.03538.972
28
20-77.0400916638.91039383DAY
THEFT/OTHER
OTHERS-77.0438.91-77.0438.91
29
21-77.0169262738.90252619DAY
THEFT F/AUTO
OTHERS-77.0238.9-77.01738.903
30
22-77.0345776238.90469331DAYBURGLARYOTHERS-77.0338.9-77.03538.905
31
23-76.999967738.9069325DAYROBBERYGUN-7738.91-7738.907
32
24-77.0374993938.91409712DAY
THEFT/OTHER
OTHERS-77.0438.91-77.03738.914
33
25-76.9702793738.85240092DAYROBBERYGUN-76.9738.85-76.9738.852
34
26-76.9757913838.90499319DAY
THEFT F/AUTO
OTHERS-76.9838.9-76.97638.905
35
27-76.9864489238.94072192DAY
THEFT F/AUTO
OTHERS-76.9938.94-76.98638.941
36
28-76.9332368138.90607565DAY
THEFT F/AUTO
OTHERS-76.9338.91-76.93338.906
37
29-77.0466397938.90910321DAYBURGLARYOTHERS-77.0538.91-77.04738.909
38
30-77.0083944838.89720317DAY
THEFT/OTHER
OTHERS-77.0138.9-77.00838.897
39
31-77.0466397938.90910321DAYBURGLARYOTHERS-77.0538.91-77.04738.909
40
32-76.9785265838.85730331DAY
THEFT/OTHER
OTHERS-76.9838.86-76.97938.857
41
33-77.0853349938.91046864DAY
ASSAULT W/DANGEROUS WEAPON
OTHERS-77.0938.91-77.08538.91
42
34-77.0448971438.90645544DAY
THEFT F/AUTO
OTHERS-77.0438.91-77.04538.906
43
35-76.9911213438.9340202DAY
THEFT/OTHER
OTHERS-76.9938.93-76.99138.934
44
36-76.982467938.89997673DAY
THEFT F/AUTO
OTHERS-76.9838.9-76.98238.9
45
37-76.9542544638.88817713DAY
THEFT/OTHER
OTHERS-76.9538.89-76.95438.888
46
38-76.9414013338.88978389DAY
MOTOR VEHICLE THEFT
OTHERS-76.9438.89-76.94138.89
47
39-76.993152438.92221944DAY
THEFT/OTHER
OTHERS-76.9938.92-76.99338.922
48
40-76.9785265838.85730331DAYBURGLARYOTHERS-76.9838.86-76.97938.857
49
41-77.0013165238.90132929DAY
THEFT/OTHER
OTHERS-7738.9-77.00138.901
50
42-77.028088338.89674517DAYBURGLARYOTHERS-77.0338.9-77.02838.897
51
43-76.9495656238.8848421DAYROBBERYGUN-76.9538.88-76.9538.885
52
44-77.0639999338.90515834DAY
THEFT/OTHER
OTHERS-77.0638.91-77.06438.905
53
45-76.9527811438.88508667DAY
ASSAULT W/DANGEROUS WEAPON
KNIFE-76.9538.89-76.95338.885
54
46-77.0463095238.91540918DAY
THEFT/OTHER
OTHERS-77.0538.92-77.04638.915
55
47-77.0616982138.90988896DAY
THEFT F/AUTO
OTHERS-77.0638.91-77.06238.91
56
48-77.0406156138.91935695DAYROBBERYOTHERS-77.0438.92-77.04138.919
57
49-77.0319649238.91446811DAY
THEFT/OTHER
OTHERS-77.0338.91-77.03238.914
58
50-77.0171023638.96377363DAY
MOTOR VEHICLE THEFT
OTHERS-77.0238.96-77.01738.964
59
51-76.9869184938.89612174DAY
ASSAULT W/DANGEROUS WEAPON
KNIFE-76.9938.9-76.98738.896
60
52-76.9826458938.8791584EVENING
THEFT/OTHER
OTHERS-76.9838.88-76.98338.879
61
53-77.0523657838.90330841EVENING
THEFT/OTHER
OTHERS-77.0538.9-77.05238.903
62
54-77.027959438.96197889EVENING
THEFT/OTHER
OTHERS-77.0338.96-77.02838.962
63
55-77.0381183438.92877148EVENING
THEFT/OTHER
OTHERS-77.0438.93-77.03838.929
64
56-76.937767338.88019709EVENING
THEFT/OTHER
OTHERS-76.9438.88-76.93838.88
65
57-77.0296288438.8978303EVENING
THEFT/OTHER
OTHERS-77.0338.9-77.0338.898
66
58-76.9949741238.9265075EVENING
THEFT/OTHER
OTHERS-76.9938.93-76.99538.927
67
59-77.0216036938.93002786EVENING
THEFT F/AUTO
OTHERS-77.0238.93-77.02238.93
68
60-76.9857298638.90259861EVENING
THEFT/OTHER
OTHERS-76.9938.9-76.98638.903
69
61-76.9955754438.90020317EVENING
THEFT/OTHER
OTHERS-7738.9-76.99638.9
70
62-76.9961874138.88199727EVENING
THEFT F/AUTO
OTHERS-7738.88-76.99638.882
71
63-77.0319547838.91755797EVENING
MOTOR VEHICLE THEFT
OTHERS-77.0338.92-77.03238.918
72
64-77.0193936338.94580177EVENING
MOTOR VEHICLE THEFT
OTHERS-77.0238.95-77.01938.946
73
65-77.0193936338.94580177EVENING
MOTOR VEHICLE THEFT
OTHERS-77.0238.95-77.01938.946
74
66-76.9421100738.8828568EVENINGROBBERYGUN-76.9438.88-76.94238.883
75
67-76.9606429638.88283749EVENING
THEFT/OTHER
OTHERS-76.9638.88-76.96138.883
76
68-77.0101710138.82519873EVENING
THEFT/OTHER
OTHERS-77.0138.83-77.0138.825
77
69-76.9129857238.89197324EVENING
THEFT/OTHER
OTHERS-76.9138.89-76.91338.892
78
70-77.0193936338.94580177EVENING
MOTOR VEHICLE THEFT
OTHERS-77.0238.95-77.01938.946
79
71-77.0224460438.89479608EVENING
THEFT F/AUTO
OTHERS-77.0238.89-77.02238.895
80
72-76.9751184138.91728944EVENING
ASSAULT W/DANGEROUS WEAPON
KNIFE-76.9838.92-76.97538.917
81
73-77.027959438.96197889EVENING
THEFT/OTHER
OTHERS-77.0338.96-77.02838.962
82
74-76.9799427938.90155279EVENING
THEFT/OTHER
OTHERS-76.9838.9-76.9838.902
83
75-76.9937636438.9215889EVENING
THEFT/OTHER
OTHERS-76.9938.92-76.99438.922
84
76-77.0628596838.90643814EVENING
THEFT/OTHER
OTHERS-77.0638.91-77.06338.906
85
77-77.0160893438.87204194EVENINGROBBERYOTHERS-77.0238.87-77.01638.872
86
78-77.00167438.9056533EVENING
THEFT F/AUTO
OTHERS-7738.91-77.00238.906
87
79-77.0302885538.93113395EVENING
THEFT F/AUTO
OTHERS-77.0338.93-77.0338.931
88
80-77.0175606438.90373321EVENING
THEFT F/AUTO
OTHERS-77.0238.9-77.01838.904
89
81-77.045781438.90101405EVENING
THEFT/OTHER
OTHERS-77.0538.9-77.04638.901
90
82-77.0326176238.90453172EVENING
THEFT/OTHER
OTHERS-77.0338.9-77.03338.905
91
83-77.0219209938.91172288EVENING
THEFT/OTHER
OTHERS-77.0238.91-77.02238.912
92
84-77.0355488938.91038629EVENING
THEFT F/AUTO
OTHERS-77.0438.91-77.03638.91
93
85-77.0116567638.89673445EVENING
THEFT/OTHER
OTHERS-77.0138.9-77.01238.897
94
86-77.0261954838.93448603EVENING
THEFT F/AUTO
OTHERS-77.0338.93-77.02638.934
95
87-76.9326306638.87648278EVENINGBURGLARYOTHERS-76.9338.88-76.93338.876
96
88-77.0035765838.91112132EVENING
THEFT/OTHER
OTHERS-7738.91-77.00438.911
97
89-76.9869217438.87840225EVENING
THEFT/OTHER
OTHERS-76.9938.88-76.98738.878
98
90-77.0116567638.89673445EVENING
THEFT/OTHER
OTHERS-77.0138.9-77.01238.897
99
91-76.9248101738.90494448EVENING
THEFT F/AUTO
OTHERS-76.9238.9-76.92538.905
100
92-77.0194272438.89981428EVENINGROBBERYOTHERS-77.0238.9-77.01938.9
Loading...
Main menu