From Pools and Crime

JOIN on Denver's public swimming pools against 240,000 crime records for about the past 8 years; addresses corrected via USPS API where possible.

Sorted by pool name Alpha, then Crime Date newest to oldest within each pool.

Notice how 'Hiawatha Davis Jr Recreation Center' didn't show up? The place exists, but has no crimes to JOIN with. We'll take that subject up later. You can do a JOIN on table A against table B and get all results from table A even if there's no commonality with table B.

Their dates are a bit messed up on years - probably a structure change or a data entry issue that depended on structure. Also, every crime happened before noon. Again, perhaps a structure or data design problem. I really doubt Eisenhower Pool had an 'other-crimes-against-persons' at 5:30am because the place would not have been open for business.

POOL_NAMEcategoryz4_ addressz4_cityz4_stz4_zipcrimedate
Ashland Indoor Poollarceny2475 W DUNKELD PLDENVERCO80211-37372017 -02-02 04:00
Ashland Indoor Poolpublic-disorder2475 W DUNKELD PLDENVERCO80211-37372014 -09-30 11:00
Ashland Indoor Poolpublic-disorder2475 W DUNKELD PLDENVERCO80211-37372013 -06-07 07:30
Ashland Indoor Poollarceny2475 W DUNKELD PLDENVERCO80211-37372013 -03-30 10:30
Ashland Indoor Poollarceny2475 W DUNKELD PLDENVERCO80211-37372013 -03-30 09:20
Athmar Recreation Centerauto-theft2680 W MEXICO AVEDENVERCO80219-4829201 8-04-10 03:30
Athmar Recreation Centerauto-theft2680 W MEXICO AVEDENVERCO80219-4829201 6-07-23 09:00
Athmar Recreation Centerlarceny2680 W MEXICO AVEDENVERCO80219-4829201 6-03-24 07:20
Athmar Recreation Centerall-other-crimes2680 W MEXICO AVEDENVERCO80219-4829201 6-01-28 10:45
Athmar Recreation Centerpublic-disorder2680 W MEXICO AVEDENVERCO80219-4829201 4-12-30 10:00
Carla Madison Recreation Center (Lap Pool)traffic-accident2401 E COLFAX AVEDENVERCO80206-1404201 8-07-09 05:45
Carla Madison Recreation Center (Lap Pool)public-disorder2401 E COLFAX AVEDENVERCO80206-1404201 6-05-02 05:00
Carla Madison Recreation Center (Lap Pool)public-disorder2401 E COLFAX AVEDENVERCO80206-1404201 6-02-05 05:00
Carla Madison Recreation Center (Leisure Pool)traffic-accident2401 E COLFAX AVEDENVERCO80206-1404201 8-07-09 05:45
Carla Madison Recreation Center (Leisure Pool)public-disorder2401 E COLFAX AVEDENVERCO80206-1404201 6-05-02 05:00
Carla Madison Recreation Center (Leisure Pool)public-disorder2401 E COLFAX AVEDENVERCO80206-1404201 6-02-05 05:00
Eisenhower Poolother-crimes-against-persons4300 E DARTMOUTH AVEDENVERCO80222-6759201 3-07-27 05:30
Glenarm Recreation Centerlarceny2800 GLENARM PLDENVERCO80205-30122018 -04-27 03:00
Glenarm Recreation Centerlarceny2800 GLENARM PLDENVERCO80205-30122017 -11-08 12:38
Harvard Gulch Poolpublic-disorder550 E ILIFF AVEDENVERCO80210-5081201 7-10-19 10:00
Harvard Gulch Poollarceny550 E ILIFF AVEDENVERCO80210-5081201 5-04-24 06:30
La Familia Recreation Centerauto-theft65 S ELATI STDENVERCO80223-16392016 -02-25 12:30
La Familia Recreation Centerpublic-disorder65 S ELATI STDENVERCO80223-16392015 -04-07 02:35
La Familia Recreation Centertraffic-accident65 S ELATI STDENVERCO80223-16392013 -01-29 07:45
Mestizo-Curtis Poollarceny3181 Champa StDenverCO2016-08-10 11:00
Montbello Recreation Centertraffic-accident15555 E 53RD AVEDENVERCO80239-5614201 8-07-27 07:15
Montbello Recreation Centerdrug-alcohol15555 E 53RD AVEDENVERCO80239-5614201 8-07-25 07:21
Montbello Recreation Centertraffic-accident15555 E 53RD AVEDENVERCO80239-5614201 8-07-13 07:45
Montbello Recreation Centerdrug-alcohol15555 E 53RD AVEDENVERCO80239-5614201 8-06-26 08:37
Montbello Recreation Centerall-other-crimes15555 E 53RD AVEDENVERCO80239-5614201 8-04-26 07:00
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 8-03-17 04:55
Montbello Recreation Centerall-other-crimes15555 E 53RD AVEDENVERCO80239-5614201 8-03-13 02:40
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 8-03-02 08:30
Montbello Recreation Centerlarceny15555 E 53RD AVEDENVERCO80239-5614201 7-09-16 02:56
Montbello Recreation Centerlarceny15555 E 53RD AVEDENVERCO80239-5614201 7-08-12 02:00
Montbello Recreation Centerlarceny15555 E 53RD AVEDENVERCO80239-5614201 7-08-12 01:00
Montbello Recreation Centerall-other-crimes15555 E 53RD AVEDENVERCO80239-5614201 7-08-09 07:35
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 7-06-07 02:00
Montbello Recreation Centerlarceny15555 E 53RD AVEDENVERCO80239-5614201 7-03-17 02:05
Montbello Recreation Centeraggravated-assault15555 E 53RD AVEDENVERCO80239-5614201 6-10-01 07:35
Montbello Recreation Centertraffic-accident15555 E 53RD AVEDENVERCO80239-5614201 6-05-22 10:40
Montbello Recreation Centerlarceny15555 E 53RD AVEDENVERCO80239-5614201 6-05-19 09:30
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 6-03-16 09:00
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 6-02-11 09:00
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 5-11-10 04:00
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 5-09-22 07:00
Montbello Recreation Centerall-other-crimes15555 E 53RD AVEDENVERCO80239-5614201 5-09-04 08:27
Montbello Recreation Centerauto-theft15555 E 53RD AVEDENVERCO80239-5614201 5-08-06 05:40
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 4-05-31 01:45
Montbello Recreation Centerpublic-disorder15555 E 53RD AVEDENVERCO80239-5614201 3-12-12 07:40
Montbello Recreation Centerother-crimes-against-persons15555 E 53RD AVEDENVERCO80239-5614201 3-10-30 05:00
Montbello Recreation Centertraffic-accident15555 E 53RD AVEDENVERCO80239-5614201 3-10-27 12:43
Rude Recreation Centerall-other-crimes2855 W HOLDEN PLDENVERCO80204-33522018 -07-08 01:14
Rude Recreation Centerburglary2855 W HOLDEN PLDENVERCO80204-33522018 -04-18 01:00
Rude Recreation Centerpublic-disorder2855 W HOLDEN PLDENVERCO80204-33522017 -08-01 08:30
Rude Recreation Centerlarceny2855 W HOLDEN PLDENVERCO80204-33522016 -09-08 09:50
Rude Recreation Centerother-crimes-against-persons2855 W HOLDEN PLDENVERCO80204-33522016 -07-11 11:55
Rude Recreation Centerdrug-alcohol2855 W HOLDEN PLDENVERCO80204-33522016 -07-11 11:55
Rude Recreation Centerburglary2855 W HOLDEN PLDENVERCO80204-33522016 -07-11 11:55
Rude Recreation Centerlarceny2855 W HOLDEN PLDENVERCO80204-33522015 -12-29 08:05
Rude Recreation Centerlarceny2855 W HOLDEN PLDENVERCO80204-33522014 -06-11 01:30
Rude Recreation Centerpublic-disorder2855 W HOLDEN PLDENVERCO80204-33522013 -08-20 11:30
Scheitler Recreation Centertheft-from-motor-vehicle5031 W 46TH AVEDENVERCO80212-2555201 8-07-15 09:00
Scheitler Recreation Centertheft-from-motor-vehicle5031 W 46TH AVEDENVERCO80212-2555201 8-05-10 03:40
Scheitler Recreation Centertraffic-accident5031 W 46TH AVEDENVERCO80212-2555201 6-05-31 05:20
Scheitler Recreation Centertheft-from-motor-vehicle5031 W 46TH AVEDENVERCO80212-2555201 4-10-25 12:45
Scheitler Recreation Centertheft-from-motor-vehicle5031 W 46TH AVEDENVERCO80212-2555201 4-01-30 09:15
Scheitler Recreation Centerother-crimes-against-persons5031 W 46TH AVEDENVERCO80212-2555201 3-09-29 03:30
Swansea Pooltheft-from-motor-vehicle2650 E 49TH AVEDENVERCO80216-2946201 5-06-24 01:30
Swansea Poolall-other-crimes2650 E 49TH AVEDENVERCO80216-2946201 5-06-08 11:06
Swansea Poolburglary2650 E 49TH AVEDENVERCO80216-2946201 5-02-07 02:30
Swansea Pooltraffic-accident2650 E 49TH AVEDENVERCO80216-2946201 5-01-13 06:00
Swansea Poolburglary2650 E 49TH AVEDENVERCO80216-2946201 3-07-22 03:15
Twentieth Street Recreation Centerlarceny1011 20TH STDENVERCO80202-18102018 -06-25 04:30
Twentieth Street Recreation Centerpublic-disorder1011 20TH STDENVERCO80202-18102018 -01-19 12:34
Twentieth Street Recreation Centerother-crimes-against-persons1011 20TH STDENVERCO80202-18102018 -01-19 06:30
Twentieth Street Recreation Centeraggravated-assault1011 20TH STDENVERCO80202-18102017 -02-28 05:25
Twentieth Street Recreation Centerlarceny1011 20TH STDENVERCO80202-18102017 -02-24 01:00
Twentieth Street Recreation Centerlarceny1011 20TH STDENVERCO80202-18102013 -07-22 07:30
Washington Park Recreation Centertheft-from-motor-vehicle701 S FRANKLIN STDENVERCO80209-45042018 -02-09 04:40
Washington Park Recreation Centertheft-from-motor-vehicle701 S FRANKLIN STDENVERCO80209-45042017 -07-07 03:30
Washington Park Recreation Centertheft-from-motor-vehicle701 S FRANKLIN STDENVERCO80209-45042017 -01-22 04:00
Washington Park Recreation Centerburglary701 S FRANKLIN STDENVERCO80209-45042014 -11-13 12:30
Washington Park Recreation Centerlarceny701 S FRANKLIN STDENVERCO80209-45042014 -03-10 11:10