Version:
ogc_fid
case_number
vehicle_sequence_number
person_sequence_number
apparent_factor_sequence_number
case_year
crash_type
crash_date
crash_time
crash_time_formatted
injury_severity
number_of_fatalities
number_of_injuries
number_of_other_injuries
number_of_serious_injuries
number_of_vehicles
posted_speed_limit
vehicle_type
vehicle_body_type
registered_weight
cargo_body_type
vehicle_configuration
total_number_of_axles
weight_rating
total_tractor_weight
total_trailer_weight
closest_cross_street
county
direction_from_intersection
distance_from_intersection
master_intersection_id
muni_fips
on_street
reference_marker
utm_easting
utm_northing
contributing_factor
lat_cpcs
long_cpcs
1370612811null12018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM134112/30/1899, 1:41:00 PMA - SERIOUS INJURY02113nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullWilson LnRensselaer454null3608310275STATE HWY 77 14092037614924.22214184735472.85930815UNSAFE SPEED42.7631714747342-73.5954249215023
2370612812null12018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM134112/30/1899, 1:41:00 PMA - SERIOUS INJURY02113nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullWilson LnRensselaer454null3608310275STATE HWY 77 14092037614924.22214184735472.85930815NOT APPLICABLE42.7631714747342-73.5954249215023
3370612813null12018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM134112/30/1899, 1:41:00 PMA - SERIOUS INJURY02113nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullWilson LnRensselaer454null3608310275STATE HWY 77 14092037614924.22214184735472.85930815NOT APPLICABLE42.7631714747342-73.5954249215023
4370612813null22018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM134112/30/1899, 1:41:00 PMA - SERIOUS INJURY02113nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullWilson LnRensselaer454null3608310275STATE HWY 77 14092037614924.22214184735472.85930815NOT APPLICABLE42.7631714747342-73.5954249215023
5370612812null22018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM134112/30/1899, 1:41:00 PMA - SERIOUS INJURY02113nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullWilson LnRensselaer454null3608310275STATE HWY 77 14092037614924.22214184735472.85930815NOT APPLICABLE42.7631714747342-73.5954249215023
6370612811null22018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM134112/30/1899, 1:41:00 PMA - SERIOUS INJURY02113nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullWilson LnRensselaer454null3608310275STATE HWY 77 14092037614924.22214184735472.85930815FOLLOWING TOO CLOSELY42.7631714747342-73.5954249215023
7370634211null12018OVERTURNED1/1/2018, 12:00:00 AM160012/30/1899, 4:00:00 PMB - INJURY01101nullTRUCKSTAKE TRUCK16000FLATBEDSINGLE UNIT TRUCK 2 AXLES 6 TIRESnullBetween 10001 and 26000nullnullDUTCHER RDTompkins4090273333610920962NORTH RDnull393263.730000734709246.25000096REACTION TO OTHER UNINVOLVED VEHICL42.5282293805549-76.2996049852207
8370634211null22018OVERTURNED1/1/2018, 12:00:00 AM160012/30/1899, 4:00:00 PMB - INJURY01101nullTRUCKSTAKE TRUCK16000FLATBEDSINGLE UNIT TRUCK 2 AXLES 6 TIRESnullBetween 10001 and 26000nullnullDUTCHER RDTompkins4090273333610920962NORTH RDnull393263.730000734709246.25000096PAVEMENT SLIPPERY42.5282293805549-76.2996049852207
9370639181null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM162212/30/1899, 4:22:00 PMC - POSSIBLE INJURY01102nullTRUCKTANK TRUCK33000CARGO TANKLIGHT TRUCK W/HAZMAT PLACARD2Greater then 26000nullnullRedwood LnSuffolk82150302393610368000W MAIN STnull651805.287906684524256.80888067NOT APPLICABLE40.855304608423-73.1989520993421
10370639182null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM162212/30/1899, 4:22:00 PMC - POSSIBLE INJURY01102nullTRUCKTANK TRUCK33000CARGO TANKLIGHT TRUCK W/HAZMAT PLACARD2Greater then 26000nullnullRedwood LnSuffolk82150302393610368000W MAIN STnull651805.287906684524256.80888067FAILURE TO YIELD RIGHT OF WAY40.855304608423-73.1989520993421
11370639182null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM162212/30/1899, 4:22:00 PMC - POSSIBLE INJURY01102nullTRUCKTANK TRUCK33000CARGO TANKLIGHT TRUCK W/HAZMAT PLACARD2Greater then 26000nullnullRedwood LnSuffolk82150302393610368000W MAIN STnull651805.287906684524256.80888067NOT APPLICABLE40.855304608423-73.1989520993421
12370639181null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM162212/30/1899, 4:22:00 PMC - POSSIBLE INJURY01102nullTRUCKTANK TRUCK33000CARGO TANKLIGHT TRUCK W/HAZMAT PLACARD2Greater then 26000nullnullRedwood LnSuffolk82150302393610368000W MAIN STnull651805.287906684524256.80888067NOT APPLICABLE40.855304608423-73.1989520993421
13370639392null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM124512/30/1899, 12:45:00 PMnull00002nullTRUCKUTILITY TRUCK44800MED/HEAVY TRUCK OR BUSnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
14370639391null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM124512/30/1899, 12:45:00 PMnull00002nullTRUCKUTILITY TRUCK44800MED/HEAVY TRUCK OR BUSnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
15370639391null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM124512/30/1899, 12:45:00 PMnull00002nullTRUCKUTILITY TRUCK44800MED/HEAVY TRUCK OR BUSnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
16370639392null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM124512/30/1899, 12:45:00 PMnull00002nullTRUCKUTILITY TRUCK44800MED/HEAVY TRUCK OR BUSnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
17370642172null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM131512/30/1899, 1:15:00 PMnull00002nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)nullGreater then 26000nullnullDUTCH BROADWAYNassau8080660903605934000FRANKLIN AVEnull611057.739999894504597.25000096NOT APPLICABLE40.6847882598587-73.6857389638287
18370642171null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM131512/30/1899, 1:15:00 PMnull00002nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)nullGreater then 26000nullnullDUTCH BROADWAYNassau8080660903605934000FRANKLIN AVEnull611057.739999894504597.25000096FAILURE TO YIELD RIGHT OF WAY40.6847882598587-73.6857389638287
19370642171null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM131512/30/1899, 1:15:00 PMnull00002nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)nullGreater then 26000nullnullDUTCH BROADWAYNassau8080660903605934000FRANKLIN AVEnull611057.739999894504597.25000096NOT APPLICABLE40.6847882598587-73.6857389638287
20370642172null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM131512/30/1899, 1:15:00 PMnull00002nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)nullGreater then 26000nullnullDUTCH BROADWAYNassau8080660903605934000FRANKLIN AVEnull611057.739999894504597.25000096NOT APPLICABLE40.6847882598587-73.6857389638287
21370642791null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM72512/30/1899, 7:25:00 AMC - POSSIBLE INJURY01102nullTRUCKTRACTORnullVAN/ENCLOSED BOXSINGLE UNIT TRUCK 2 AXLES 6 TIRES2Between 10001 and 26000nullnullnullNassaunull0null3605956000I 495495 03021141629081.115973534517236.2757016FOLLOWING TOO CLOSELY40.7959813448669-73.469910442368
22370642792null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM72512/30/1899, 7:25:00 AMC - POSSIBLE INJURY01102nullTRUCKTRACTORnullVAN/ENCLOSED BOXSINGLE UNIT TRUCK 2 AXLES 6 TIRES2Between 10001 and 26000nullnullnullNassaunull0null3605956000I 495495 03021141629081.115973534517236.2757016NOT APPLICABLE40.7959813448669-73.469910442368
23370642792null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM72512/30/1899, 7:25:00 AMC - POSSIBLE INJURY01102nullTRUCKTRACTORnullVAN/ENCLOSED BOXSINGLE UNIT TRUCK 2 AXLES 6 TIRES2Between 10001 and 26000nullnullnullNassaunull0null3605956000I 495495 03021141629081.115973534517236.2757016NOT APPLICABLE40.7959813448669-73.469910442368
24370642791null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM72512/30/1899, 7:25:00 AMC - POSSIBLE INJURY01102nullTRUCKTRACTORnullVAN/ENCLOSED BOXSINGLE UNIT TRUCK 2 AXLES 6 TIRES2Between 10001 and 26000nullnullnullNassaunull0null3605956000I 495495 03021141629081.115973534517236.2757016GLARE40.7959813448669-73.469910442368
25370644332null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM195512/30/1899, 7:55:00 PMnull00002nullTRUCKDUMP TRUCK66000DUMPUNKNOWN HEAVY TRUCK2Greater then 26000nullnullRampErie8292null3602980918STATE HWY 400400 53011125197182.083235824749467.15386823NOT APPLICABLE42.8376462156849-78.7052475024321
26370644331null12018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM195512/30/1899, 7:55:00 PMnull00002nullTRUCKDUMP TRUCK66000DUMPUNKNOWN HEAVY TRUCK2Greater then 26000nullnullRampErie8292null3602980918STATE HWY 400400 53011125197182.083235824749467.15386823DRIVER INATTENTION42.8376462156849-78.7052475024321
27370644331null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM195512/30/1899, 7:55:00 PMnull00002nullTRUCKDUMP TRUCK66000DUMPUNKNOWN HEAVY TRUCK2Greater then 26000nullnullRampErie8292null3602980918STATE HWY 400400 53011125197182.083235824749467.15386823FOLLOWING TOO CLOSELY42.8376462156849-78.7052475024321
28370644332null22018COLLISION WITH MOTOR VEHICLE1/2/2018, 12:00:00 AM195512/30/1899, 7:55:00 PMnull00002nullTRUCKDUMP TRUCK66000DUMPUNKNOWN HEAVY TRUCK2Greater then 26000nullnullRampErie8292null3602980918STATE HWY 400400 53011125197182.083235824749467.15386823NOT APPLICABLE42.8376462156849-78.7052475024321
29370651351null12018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM115212/30/1899, 11:52:00 AMA - SERIOUS INJURY02022nullTRUCKDUMP TRUCKnullDUMPSINGLE AXLE TRUCK 3> AXLESnullGreater then 26000nullnullDrivewayOtsego1160null3607754892[Route] 20523 94021190491564.495492024701417.31129925DRIVER INATTENTION42.4650492621061-75.1026068783875
30370651352null12018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM115212/30/1899, 11:52:00 AMA - SERIOUS INJURY02022nullTRUCKDUMP TRUCKnullDUMPSINGLE AXLE TRUCK 3> AXLESnullGreater then 26000nullnullDrivewayOtsego1160null3607754892[Route] 20523 94021190491564.495492024701417.31129925NOT APPLICABLE42.4650492621061-75.1026068783875
31370651352null22018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM115212/30/1899, 11:52:00 AMA - SERIOUS INJURY02022nullTRUCKDUMP TRUCKnullDUMPSINGLE AXLE TRUCK 3> AXLESnullGreater then 26000nullnullDrivewayOtsego1160null3607754892[Route] 20523 94021190491564.495492024701417.31129925UNKNOWN42.4650492621061-75.1026068783875
32370651351null22018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM115212/30/1899, 11:52:00 AMA - SERIOUS INJURY02022nullTRUCKDUMP TRUCKnullDUMPSINGLE AXLE TRUCK 3> AXLESnullGreater then 26000nullnullDrivewayOtsego1160null3607754892[Route] 20523 94021190491564.495492024701417.31129925FAILURE TO YIELD RIGHT OF WAY42.4650492621061-75.1026068783875
33370652021null12018COLLISION WITH OTHER FIXED OBJECT1/2/2018, 12:00:00 AM161712/30/1899, 4:17:00 PMnull00001nullTRUCKUTILITY TRUCK16000MED/HEAVY TRUCK OR BUSnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
34370652021null22018COLLISION WITH OTHER FIXED OBJECT1/2/2018, 12:00:00 AM161712/30/1899, 4:17:00 PMnull00001nullTRUCKUTILITY TRUCK16000MED/HEAVY TRUCK OR BUSnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
35370657552null12018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM144412/30/1899, 2:44:00 PMnull00002nullTRUCKDUMP TRUCK51000DUMPSINGLE AXLE TRUCK 3> AXLESnullGreater then 26000nullnullS 5th StOswego7240047923607527815E BROADWAY3 34012016385774.097224014797318.01841028NOT APPLICABLE43.3200258551335-76.4087259212698
36370657551null12018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM144412/30/1899, 2:44:00 PMnull00002nullTRUCKDUMP TRUCK51000DUMPSINGLE AXLE TRUCK 3> AXLESnullGreater then 26000nullnullS 5th StOswego7240047923607527815E BROADWAY3 34012016385774.097224014797318.01841028PAVEMENT SLIPPERY43.3200258551335-76.4087259212698
37370657551null22018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM144412/30/1899, 2:44:00 PMnull00002nullTRUCKDUMP TRUCK51000DUMPSINGLE AXLE TRUCK 3> AXLESnullGreater then 26000nullnullS 5th StOswego7240047923607527815E BROADWAY3 34012016385774.097224014797318.01841028VIEW OBSTRUCTED/LIMITED43.3200258551335-76.4087259212698
38370657552null22018COLLISION WITH MOTOR VEHICLE1/1/2018, 12:00:00 AM144412/30/1899, 2:44:00 PMnull00002nullTRUCKDUMP TRUCK51000DUMPSINGLE AXLE TRUCK 3> AXLESnullGreater then 26000nullnullS 5th StOswego7240047923607527815E BROADWAY3 34012016385774.097224014797318.01841028NOT APPLICABLE43.3200258551335-76.4087259212698
39370663691null12018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM121812/30/1899, 12:18:00 PMnull00002nullTRUCKTRACTORnullFLATBEDTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullRocklandnull0null3608715968I 87null586344.00204974550486.13172665FOLLOWING TOO CLOSELY41.1010680081071-73.9717714655556
40370663692null12018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM121812/30/1899, 12:18:00 PMnull00002nullTRUCKTRACTORnullFLATBEDTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullRocklandnull0null3608715968I 87null586344.00204974550486.13172665NOT APPLICABLE41.1010680081071-73.9717714655556
41370663692null22018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM121812/30/1899, 12:18:00 PMnull00002nullTRUCKTRACTORnullFLATBEDTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullRocklandnull0null3608715968I 87null586344.00204974550486.13172665NOT APPLICABLE41.1010680081071-73.9717714655556
42370663691null22018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM121812/30/1899, 12:18:00 PMnull00002nullTRUCKTRACTORnullFLATBEDTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullRocklandnull0null3608715968I 87null586344.00204974550486.13172665UNSAFE SPEED41.1010680081071-73.9717714655556
43370664271null12018COLL. W/EARTH ELE./ROCK CUT/DITCH1/2/2018, 12:00:00 AM222512/30/1899, 10:25:00 PMnull00001nullTRUCKTRACTORnullMED/HEAVY TRUCK OR BUSnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
44370664271null22018COLL. W/EARTH ELE./ROCK CUT/DITCH1/2/2018, 12:00:00 AM222512/30/1899, 10:25:00 PMnull00001nullTRUCKTRACTORnullMED/HEAVY TRUCK OR BUSnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
45370670931null12018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM174112/30/1899, 5:41:00 PMC - POSSIBLE INJURY01104nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullSuffolknull0null3610338000[Route] 495null00NOT APPLICABLE0-79.4887438971652
46370670932null12018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM174112/30/1899, 5:41:00 PMC - POSSIBLE INJURY01104nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullSuffolknull0null3610338000[Route] 495null00NOT APPLICABLE0-79.4887438971652
47370670934null12018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM174112/30/1899, 5:41:00 PMC - POSSIBLE INJURY01104nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullSuffolknull0null3610338000[Route] 495null00FOLLOWING TOO CLOSELY0-79.4887438971652
48370670933null12018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM174112/30/1899, 5:41:00 PMC - POSSIBLE INJURY01104nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullSuffolknull0null3610338000[Route] 495null00NOT APPLICABLE0-79.4887438971652
49370670933null22018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM174112/30/1899, 5:41:00 PMC - POSSIBLE INJURY01104nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullSuffolknull0null3610338000[Route] 495null00NOT APPLICABLE0-79.4887438971652
50370670934null22018COLLISION WITH MOTOR VEHICLE1/3/2018, 12:00:00 AM174112/30/1899, 5:41:00 PMC - POSSIBLE INJURY01104nullTRUCKTRACTORnullVAN/ENCLOSED BOXTRACTOR (SEMI-TRAILER)5Greater then 26000nullnullnullSuffolknull0null3610338000[Route] 495null00OTHER ELECTRONIC DEVICE0-79.4887438971652
Page 1 of 5
Rows 1 -50 of 250