saturn

/home/coolhand/html/datavis/data_trove/cache/wild/nyc_311_sample_20260121.json 1,000 rows sample n=1,000 seed 42 2026-05-01T18:06:43+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/cache/wild/nyc_311_sample_20260121.json
Total rows1,000
Profiled sample1,000
Columns47
Generated2026-05-01T18:06:43+00:00

Insights opt-in

Model-generated narrative. These are opinions, not facts — the stats below are what saturn measured. Generated by: anthropic:claude-opus-4-7.

Errors during insight pass (48)
  • dataset:__global__:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzVFiieZBDeBRSAeMU'}
  • column:unique_key:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzVkjTUbEz722EPcaf'}
  • column:created_date:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzWHjQQ6K3DKA5iMmf'}
  • column:agency:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzWmkpKLqtC1TJAUVu'}
  • column:agency_name:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzXGGeP6DiBCF8Ju8s'}
  • column:complaint_type:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzXo1zu1X8KdFJaxGe'}
  • column:descriptor:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzYK2GsSsAZHDpJkRW'}
  • column:location_type:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzYuVRoQg5dFambDvP'}
  • column:incident_zip:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzZRFNzw5AtoR9hwCT'}
  • column:incident_address:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzZv1uZy9fFDNyrepX'}
  • column:street_name:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzaR2QvwieiGtozrFu'}
  • column:cross_street_1:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzawXnGhj8ypUxcPgd'}
  • column:cross_street_2:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzbWm5Y3v1HZp3HJsA'}
  • column:intersection_street_1:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzc31mmsX4ubq8hBL2'}
  • column:intersection_street_2:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzcYGhdGdbWaFVRyon'}
  • column:address_type:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzd7W94eKYVYbmDtmp'}
  • column:city:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzdaHQPFD7b3McC9YH'}
  • column:landmark:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzeHT1Bt7CMZz2KD3N'}
  • column:status:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzf2bWYmWzBKSesoxK'}
  • column:community_board:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzfbpeg5W6tPQLWeZT'}
  • column:council_district:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzg6LeHXkDNvzXU6mG'}
  • column:police_precinct:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzgpFE3b5wUPdFqNqg'}
  • column:bbl:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzhLFaxYUsmSXYZCZq'}
  • column:borough:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzhwiGzjbWhyqUBqaR'}
  • column:x_coordinate_state_plane:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHziQFNNZqArDpvU7Ca'}
  • column:y_coordinate_state_plane:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzjDcHF8HAWL9AeQfS'}
  • column:open_data_channel_type:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzjjry2uYTFjyRk5x3'}
  • column:park_facility_name:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzkEdSkaktLAHg7XH9'}
  • column:park_borough:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzkmNqg5TGjLTuV7Gw'}
  • column:latitude:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzmH8j4gimBepCGCg7'}
  • column:longitude:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzmoPJDLXmg2piaZ8W'}
  • column:location:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHznGfKhqvxfKo1UYYs'}
  • column::@computed_region_f5dn_yrer:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHznoAUtZsB3vyStVwv'}
  • column::@computed_region_yeji_bk3q:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzoMeSGsKJsR3s8A5d'}
  • column::@computed_region_sbqj_enih:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzorQwhZCEbBnmqnP9'}
  • column::@computed_region_92fq_4b7q:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzpPQs79M1egKhcTLo'}
  • column:descriptor_2:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzpvA32qQwKh5NGzcC'}
  • column:resolution_description:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzqPwDDB6NVeZxpPi7'}
  • column:resolution_action_updated_date:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzqtwZPGgfBp82ZWwW'}
  • column:taxi_pick_up_location:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzrTRmLuwoP6U9RUp2'}
  • column:vehicle_type:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzrvTQy4pkGLaNAPSg'}
  • column:closed_date:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzsQEGM3knVjuHRTXG'}
  • column:bridge_highway_name:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzsqn3uUz7CCGLd4Py'}
  • column:bridge_highway_segment:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHztSEyrZWZBb7Syrnc'}
  • column:facility_type:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzuPY9PgMiZUWhHcKH'}
  • column:bridge_highway_direction:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzvDQ6QcAxPzNpVPu3'}
  • column:road_ramp:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzvmPKsghBQZtkPZ6w'}
  • column:taxi_company_borough:anthropic:claude-opus-4-7: BadRequestError — Error code: 400 - {'type': 'error', 'error': {'type': 'invalid_request_error', 'message': 'Your credit balance is too low to access the Anthropic API. Please go to Plans & Billing to upgrade or purchase credits.'}, 'request_id': 'req_011CacHzwN7G3a8FPy9duoJ4'}

unique_key categorical

1000 singleton categories
rows1,000
null0 (0.0%)
unique1,000
top_value67534607
top_rate1.00e-03
cardinality1,000
entropy9.966
entropy_ratio1.000
Top values (rank 1–20)
  1. 67534607 — 1
  2. 67540784 — 1
  3. 67540752 — 1
  4. 67537071 — 1
  5. 67535886 — 1
  6. 67543458 — 1
  7. 67541950 — 1
  8. 67537003 — 1
  9. 67538353 — 1
  10. 67543223 — 1
  11. 67534550 — 1
  12. 67537050 — 1
  13. 67540783 — 1
  14. 67535884 — 1
  15. 67541981 — 1
  16. 67540793 — 1
  17. 67539537 — 1
  18. 67534594 — 1
  19. 67543236 — 1
  20. 67535866 — 1

created_date categorical

850 singleton categories
rows1,000
null0 (0.0%)
unique910
top_value2026-01-19T22:01:09.000
top_rate9.00e-03
cardinality910
entropy9.746
entropy_ratio0.992
Top values (rank 1–20)
  1. 2026-01-19T22:01:09.000 — 9
  2. 2026-01-19T22:38:46.000 — 7
  3. 2026-01-19T23:17:18.000 — 6
  4. 2026-01-19T23:57:16.000 — 5
  5. 2026-01-19T22:05:00.000 — 5
  6. 2026-01-19T23:31:38.000 — 4
  7. 2026-01-19T23:10:44.000 — 3
  8. 2026-01-19T23:07:39.000 — 3
  9. 2026-01-19T23:04:06.000 — 3
  10. 2026-01-19T23:01:05.000 — 3
  11. 2026-01-19T22:48:53.000 — 3
  12. 2026-01-19T22:15:33.000 — 3
  13. 2026-01-20T02:00:04.000 — 2
  14. 2026-01-20T01:04:29.000 — 2
  15. 2026-01-20T00:41:14.000 — 2
  16. 2026-01-20T00:12:00.000 — 2
  17. 2026-01-19T23:58:19.000 — 2
  18. 2026-01-19T23:57:12.000 — 2
  19. 2026-01-19T23:43:00.000 — 2
  20. 2026-01-19T23:41:00.000 — 2

agency categorical

rows1,000
null0 (0.0%)
unique10
top_valueNYPD
top_rate0.594
cardinality10
entropy1.750
entropy_ratio0.527
Top values (rank 1–20)
  1. NYPD — 594
  2. HPD — 232
  3. DSNY — 82
  4. DOT — 34
  5. DEP — 24
  6. DOHMH — 16
  7. TLC — 12
  8. DPR — 4
  9. DCWP — 1
  10. OOS — 1

agency_name categorical

rows1,000
null0 (0.0%)
unique10
top_valueNew York City Police Department
top_rate0.594
cardinality10
entropy1.750
entropy_ratio0.527
Top values (rank 1–20)
  1. New York City Police Department — 594
  2. Department of Housing Preservation and Development — 232
  3. Department of Sanitation — 82
  4. Department of Transportation — 34
  5. Department of Environmental Protection — 24
  6. Department of Health and Mental Hygiene — 16
  7. Taxi and Limousine Commission — 12
  8. Department of Parks and Recreation — 4
  9. Department of Consumer and Worker Protection — 1
  10. Office of the Sheriff — 1

complaint_type categorical

rows1,000
null0 (0.0%)
unique61
top_valueNoise - Residential
top_rate0.234
cardinality61
entropy3.776
entropy_ratio0.637
Top values (rank 1–20)
  1. Noise - Residential — 234
  2. Illegal Parking — 187
  3. HEAT/HOT WATER — 170
  4. Snow or Ice — 69
  5. Blocked Driveway — 64
  6. Noise - Commercial — 38
  7. Noise - Vehicle — 22
  8. UNSANITARY CONDITION — 21
  9. Noise - Street/Sidewalk — 20
  10. Street Condition — 14
  11. Noise — 14
  12. Traffic Signal Condition — 9
  13. Abandoned Vehicle — 8
  14. Taxi Complaint — 8
  15. DOOR/WINDOW — 8
  16. Dirty Condition — 7
  17. PLUMBING — 7
  18. Non-Emergency Police Matter — 6
  19. FLOORING/STAIRS — 6
  20. Indoor Air Quality — 5

descriptor categorical

rows1,000
null0 (0.0%)
unique105
top_valueBanging/Pounding
top_rate0.133
cardinality105
entropy4.739
entropy_ratio0.706
Top values (rank 1–20)
  1. Banging/Pounding — 133
  2. Loud Music/Party — 127
  3. ENTIRE BUILDING — 112
  4. Blocked Hydrant — 98
  5. Sidewalk — 69
  6. APARTMENT ONLY — 58
  7. No Access — 50
  8. Loud Talking — 31
  9. Commercial Overnight Parking — 26
  10. Posted Parking Sign Violation — 21
  11. Partial Access — 14
  12. Engine Idling — 12
  13. Pothole — 11
  14. PESTS — 11
  15. Double Parked Blocking Traffic — 10
  16. Driver Complaint - Passenger — 9
  17. Blocked Sidewalk — 9
  18. With License Plate — 8
  19. Trash — 7
  20. Blocked Crosswalk — 7

location_type categorical

rows1,000
null48 (4.8%)
unique19
top_valueStreet/Sidewalk
top_rate0.321
cardinality19
entropy2.437
entropy_ratio0.574
Top values (rank 1–20)
  1. Street/Sidewalk — 306
  2. Residential Building/House — 245
  3. RESIDENTIAL BUILDING — 232
  4. Sidewalk — 80
  5. Club/Bar/Restaurant — 23
  6. Street — 20
  7. Store/Commercial — 15
  8. 3+ Family Apartment Building — 6
  9. Residential Building — 5
  10. 3+ Family Apt. Building — 4
  11. Taxi — 3
  12. Highway — 3
  13. Yard — 2
  14. Restaurant/Bar/Deli/Bakery — 2
  15. Park/Playground — 2
  16. Subway — 1
  17. Business — 1
  18. Subway Station — 1
  19. Park — 1

incident_zip categorical

rows1,000
null3 (0.3%)
unique156
top_value10461
top_rate0.029
cardinality156
entropy6.826
entropy_ratio0.937
Top values (rank 1–20)
  1. 10461 — 29
  2. 10462 — 25
  3. 11226 — 23
  4. 11214 — 20
  5. 10034 — 19
  6. 11373 — 19
  7. 11385 — 18
  8. 10473 — 17
  9. 10029 — 16
  10. 11103 — 16
  11. 11230 — 16
  12. 11225 — 16
  13. 11204 — 15
  14. 10040 — 15
  15. 11366 — 14
  16. 10468 — 14
  17. 11212 — 13
  18. 11208 — 13
  19. 10457 — 13
  20. 11233 — 13

incident_address categorical

681 singleton categories
rows1,000
null16 (1.6%)
unique787
top_value31 HARRISON AVENUE
top_rate9.15e-03
cardinality787
entropy9.431
entropy_ratio0.980
Top values (rank 1–20)
  1. 31 HARRISON AVENUE — 9
  2. 64 SOUTH 11 STREET — 8
  3. 41-72 JUDGE STREET — 7
  4. 170 VERMILYEA AVENUE — 7
  5. JOHN F KENNEDY AIRPORT — 6
  6. 42-01 LAYTON STREET — 6
  7. 21 TRUXTON STREET — 6
  8. LA GUARDIA AIRPORT — 5
  9. ROCKAWAY BOULEVARD — 5
  10. 1790 STORY AVENUE — 5
  11. 9 EAST 193 STREET — 5
  12. 147-40 ARCHER AVENUE — 5
  13. 108-26 159 STREET — 4
  14. 239 OCEAN AVENUE — 4
  15. 66 WELDON STREET — 4
  16. 1365 5 AVENUE — 4
  17. 538 EAST 21 STREET — 4
  18. 2854 KINGSBRIDGE TERRACE — 4
  19. 67 DRIVE — 4
  20. 3990 BRONX BOULEVARD — 4

street_name categorical

401 singleton categories
rows1,000
null16 (1.6%)
unique592
top_valueOCEAN AVENUE
top_rate0.010
cardinality592
entropy8.886
entropy_ratio0.965
Top values (rank 1–20)
  1. OCEAN AVENUE — 10
  2. EAST 21 STREET — 9
  3. HARRISON AVENUE — 9
  4. SOUTH 11 STREET — 8
  5. 66 STREET — 8
  6. BROADWAY — 8
  7. JUDGE STREET — 8
  8. WASHINGTON AVENUE — 7
  9. BAY PARKWAY — 7
  10. VERMILYEA AVENUE — 7
  11. RANDALL AVENUE — 6
  12. JOHN F KENNEDY AIRPORT — 6
  13. 30 AVENUE — 6
  14. WOODYCREST AVENUE — 6
  15. RYER AVENUE — 6
  16. ROCKAWAY BOULEVARD — 6
  17. HERING AVENUE — 6
  18. LAYTON STREET — 6
  19. TRUXTON STREET — 6
  20. LA GUARDIA AIRPORT — 5

cross_street_1 categorical

309 singleton categories 25.0% null
rows1,000
null250 (25.0%)
unique457
top_valueBEND
top_rate0.013
cardinality457
entropy8.534
entropy_ratio0.966
Top values (rank 1–20)
  1. BEND — 10
  2. WYTHE AVENUE — 8
  3. DORCHESTER ROAD — 8
  4. 75 AVENUE — 8
  5. 99 STREET — 7
  6. ADAM CLAYTON POWELL JR BOULEVARD — 7
  7. 5 AVENUE — 7
  8. 3 AVENUE — 6
  9. 18 AVENUE — 6
  10. DEAD END — 6
  11. 19 AVENUE — 6
  12. 94 STREET — 6
  13. WEST 162 STREET — 6
  14. 36 STREET — 5
  15. 8 AVENUE — 5
  16. EAST BURNSIDE AVENUE — 5
  17. ST NICHOLAS AVENUE — 5
  18. MYRTLE AVENUE — 5
  19. ROSEDALE AVENUE — 5
  20. 108 AVENUE — 4

cross_street_2 categorical

313 singleton categories 25.0% null
rows1,000
null250 (25.0%)
unique458
top_valueBERRY STREET
top_rate0.011
cardinality458
entropy8.536
entropy_ratio0.966
Top values (rank 1–20)
  1. BERRY STREET — 8
  2. FREDERICK DOUGLASS BOULEVARD — 8
  3. DITMAS AVENUE — 8
  4. BOOTH STREET — 7
  5. UNION TURNPIKE — 7
  6. 109 AVENUE — 6
  7. AIRTRAIN-HOWARD BCH/JAMAICA LINE — 6
  8. 20 AVENUE — 6
  9. DEAD END — 6
  10. WEST 163 STREET — 6
  11. BROADWAY — 6
  12. 102 STREET — 6
  13. 3 AVENUE — 6
  14. 10 AVENUE — 6
  15. BEND — 5
  16. 19 AVENUE — 5
  17. 37 STREET — 5
  18. 18 AVENUE — 5
  19. EAST 115 STREET — 5
  20. GRAND CENTRAL PARKWAY ET 7 EB — 5

intersection_street_1 categorical

286 singleton categories 26.7% null
rows1,000
null267 (26.7%)
unique436
top_valueBEND
top_rate0.012
cardinality436
entropy8.465
entropy_ratio0.965
Top values (rank 1–20)
  1. BEND — 9
  2. WYTHE AVENUE — 8
  3. DORCHESTER ROAD — 8
  4. 75 AVENUE — 8
  5. 99 STREET — 7
  6. ADAM CLAYTON POWELL JR BOULEVARD — 7
  7. 5 AVENUE — 7
  8. 3 AVENUE — 6
  9. 18 AVENUE — 6
  10. DEAD END — 6
  11. 19 AVENUE — 6
  12. 94 STREET — 6
  13. WEST 162 STREET — 6
  14. 36 STREET — 5
  15. 8 AVENUE — 5
  16. EAST BURNSIDE AVENUE — 5
  17. ST NICHOLAS AVENUE — 5
  18. AVENUE N — 5
  19. MYRTLE AVENUE — 5
  20. ROSEDALE AVENUE — 5

intersection_street_2 categorical

298 singleton categories 26.7% null
rows1,000
null267 (26.7%)
unique443
top_valueBERRY STREET
top_rate0.011
cardinality443
entropy8.489
entropy_ratio0.966
Top values (rank 1–20)
  1. BERRY STREET — 8
  2. FREDERICK DOUGLASS BOULEVARD — 8
  3. DITMAS AVENUE — 8
  4. BOOTH STREET — 7
  5. UNION TURNPIKE — 7
  6. AIRTRAIN-HOWARD BCH/JAMAICA LINE — 6
  7. 20 AVENUE — 6
  8. DEAD END — 6
  9. WEST 163 STREET — 6
  10. BROADWAY — 6
  11. 102 STREET — 6
  12. 3 AVENUE — 6
  13. 10 AVENUE — 6
  14. 109 AVENUE — 5
  15. 19 AVENUE — 5
  16. 37 STREET — 5
  17. 18 AVENUE — 5
  18. EAST 115 STREET — 5
  19. GRAND CENTRAL PARKWAY ET 7 EB — 5
  20. EAST 180 STREET — 5

address_type categorical

rows1,000
null3 (0.3%)
unique4
top_valueADDRESS
top_rate0.942
cardinality4
entropy0.398
entropy_ratio0.199
Top values (rank 1–20)
  1. ADDRESS — 939
  2. INTERSECTION — 36
  3. PLACE — 12
  4. BLOCKFACE — 10

city categorical

rows1,000
null29 (2.9%)
unique40
top_valueBROOKLYN
top_rate0.316
cardinality40
entropy3.234
entropy_ratio0.608
Top values (rank 1–20)
  1. BROOKLYN — 307
  2. BRONX — 227
  3. NEW YORK — 170
  4. JAMAICA — 34
  5. ASTORIA — 23
  6. STATEN ISLAND — 21
  7. ELMHURST — 19
  8. RIDGEWOOD — 15
  9. FRESH MEADOWS — 15
  10. QUEENS — 13
  11. FLUSHING — 12
  12. WOODSIDE — 10
  13. FAR ROCKAWAY — 9
  14. REGO PARK — 9
  15. CORONA — 8
  16. EAST ELMHURST — 7
  17. MIDDLE VILLAGE — 7
  18. JACKSON HEIGHTS — 5
  19. SOUTH OZONE PARK — 5
  20. FOREST HILLS — 5

landmark categorical

312 singleton categories 30.8% null
rows1,000
null308 (30.8%)
unique445
top_valueEAST 21 STREET
top_rate0.013
cardinality445
entropy8.522
entropy_ratio0.969
Top values (rank 1–20)
  1. EAST 21 STREET — 9
  2. SOUTH 11 STREET — 8
  3. OCEAN AVENUE — 8
  4. WASHINGTON AVENUE — 7
  5. RANDALL AVENUE — 6
  6. JOHN F KENNEDY AIRPORT — 6
  7. 30 AVENUE — 6
  8. WOODYCREST AVENUE — 6
  9. BROADWAY — 6
  10. RYER AVENUE — 6
  11. HERING AVENUE — 6
  12. 66 STREET — 5
  13. LA GUARDIA AIRPORT — 5
  14. YATES AVENUE — 5
  15. KINGSBRIDGE TERRACE — 5
  16. STORY AVENUE — 5
  17. 159 STREET — 4
  18. BAY PARKWAY — 4
  19. WELDON STREET — 4
  20. 5 AVENUE — 4

status categorical

rows1,000
null0 (0.0%)
unique3
top_valueIn Progress
top_rate0.388
cardinality3
entropy1.571
entropy_ratio0.991
Top values (rank 1–20)
  1. In Progress — 388
  2. Closed — 336
  3. Open — 276

community_board categorical

rows1,000
null0 (0.0%)
unique64
top_value12 MANHATTAN
top_rate0.044
cardinality64
entropy5.730
entropy_ratio0.955
Top values (rank 1–20)
  1. 12 MANHATTAN — 44
  2. 11 BROOKLYN — 40
  3. 09 BRONX — 38
  4. 14 BROOKLYN — 33
  5. 11 BRONX — 33
  6. 12 QUEENS — 31
  7. 10 BRONX — 26
  8. 05 QUEENS — 26
  9. 01 QUEENS — 25
  10. 10 MANHATTAN — 25
  11. 05 BROOKLYN — 24
  12. 12 BRONX — 23
  13. 04 QUEENS — 23
  14. 01 BROOKLYN — 22
  15. 08 QUEENS — 22
  16. 12 BROOKLYN — 22
  17. 16 BROOKLYN — 22
  18. 17 BROOKLYN — 19
  19. 03 BRONX — 19
  20. 10 QUEENS — 19

council_district categorical

rows1,000
null13 (1.3%)
unique51
top_value13
top_rate0.047
cardinality51
entropy5.492
entropy_ratio0.968
Top values (rank 1–20)
  1. 13 — 46
  2. 10 — 44
  3. 18 — 43
  4. 40 — 38
  5. 34 — 29
  6. 37 — 29
  7. 09 — 29
  8. 35 — 28
  9. 15 — 28
  10. 43 — 27
  11. 17 — 26
  12. 28 — 25
  13. 14 — 24
  14. 25 — 23
  15. 08 — 23
  16. 11 — 23
  17. 22 — 23
  18. 24 — 23
  19. 42 — 22
  20. 30 — 22

police_precinct categorical

rows1,000
null0 (0.0%)
unique76
top_valuePrecinct 62
top_rate0.040
cardinality76
entropy5.883
entropy_ratio0.942
Top values (rank 1–20)
  1. Precinct 62 — 40
  2. Precinct 43 — 38
  3. Precinct 34 — 36
  4. Precinct 70 — 33
  5. Precinct 49 — 33
  6. Precinct 104 — 29
  7. Precinct 114 — 28
  8. Precinct 45 — 26
  9. Precinct 75 — 24
  10. Precinct 47 — 23
  11. Precinct 110 — 23
  12. Precinct 107 — 22
  13. Precinct 66 — 22
  14. Precinct 73 — 22
  15. Precinct 67 — 19
  16. Precinct 113 — 19
  17. Precinct 42 — 19
  18. Precinct 106 — 19
  19. Precinct 71 — 19
  20. Precinct 90 — 18

bbl categorical

636 singleton categories
rows1,000
null59 (5.9%)
unique744
top_value5010780006
top_rate9.56e-03
cardinality744
entropy9.342
entropy_ratio0.979
Top values (rank 1–20)
  1. 5010780006 — 9
  2. 3021600005 — 8
  3. 4015070054 — 7
  4. 1022280007 — 7
  5. 4142600001 — 6
  6. 2025110068 — 6
  7. 4015080001 — 6
  8. 3015420044 — 6
  9. 4009260001 — 5
  10. 2036370001 — 5
  11. 2031910054 — 5
  12. 4099987501 — 5
  13. 4101460051 — 4
  14. 3050260344 — 4
  15. 2039730005 — 4
  16. 3041640018 — 4
  17. 1016180001 — 4
  18. 3051840025 — 4
  19. 2032530133 — 4
  20. 2048200042 — 4

borough categorical

rows1,000
null0 (0.0%)
unique5
top_valueBROOKLYN
top_rate0.312
cardinality5
entropy2.079
entropy_ratio0.895
Top values (rank 1–20)
  1. BROOKLYN — 312
  2. QUEENS — 261
  3. BRONX — 230
  4. MANHATTAN — 175
  5. STATEN ISLAND — 22

x_coordinate_state_plane categorical

679 singleton categories
rows1,000
null12 (1.2%)
unique788
top_value946638
top_rate9.11e-03
cardinality788
entropy9.433
entropy_ratio0.980
Top values (rank 1–20)
  1. 946638 — 9
  2. 993540 — 8
  3. 1016981 — 7
  4. 1006636 — 7
  5. 1043001 — 6
  6. 1016259 — 6
  7. 1009589 — 6
  8. 1018236 — 5
  9. 1021634 — 5
  10. 1012556 — 5
  11. 1037889 — 5
  12. 1041463 — 4
  13. 994731 — 4
  14. 1019629 — 4
  15. 998703 — 4
  16. 1025645 — 4
  17. 995841 — 4
  18. 1011173 — 4
  19. 1025158 — 4
  20. 1021852 — 4

y_coordinate_state_plane categorical

675 singleton categories
rows1,000
null12 (1.2%)
unique788
top_value171301
top_rate9.11e-03
cardinality788
entropy9.437
entropy_ratio0.981
Top values (rank 1–20)
  1. 171301 — 9
  2. 197050 — 8
  3. 210691 — 7
  4. 255285 — 7
  5. 175548 — 6
  6. 210546 — 6
  7. 186419 — 6
  8. 221443 — 5
  9. 239284 — 5
  10. 255017 — 5
  11. 194669 — 5
  12. 192497 — 4
  13. 178635 — 4
  14. 187056 — 4
  15. 230311 — 4
  16. 172790 — 4
  17. 257790 — 4
  18. 203433 — 4
  19. 263320 — 4
  20. 241935 — 4

open_data_channel_type categorical

rows1,000
null0 (0.0%)
unique4
top_valueONLINE
top_rate0.527
cardinality4
entropy1.586
entropy_ratio0.793
Top values (rank 1–20)
  1. ONLINE — 527
  2. MOBILE — 234
  3. PHONE — 214
  4. UNKNOWN — 25

park_facility_name categorical

2 singleton categories top value is 99.8% of rows
rows1,000
null0 (0.0%)
unique3
top_valueUnspecified
top_rate0.998
cardinality3
entropy0.023
entropy_ratio0.014
Top values (rank 1–20)
  1. Unspecified — 998
  2. Marcus Garvey Park — 1
  3. Forest Park — 1

park_borough categorical

rows1,000
null0 (0.0%)
unique5
top_valueBROOKLYN
top_rate0.312
cardinality5
entropy2.079
entropy_ratio0.895
Top values (rank 1–20)
  1. BROOKLYN — 312
  2. QUEENS — 261
  3. BRONX — 230
  4. MANHATTAN — 175
  5. STATEN ISLAND — 22

latitude categorical

687 singleton categories
rows1,000
null12 (1.2%)
unique794
top_value40.63677840515416
top_rate9.11e-03
cardinality794
entropy9.449
entropy_ratio0.981
Top values (rank 1–20)
  1. 40.63677840515416 — 9
  2. 40.7075286122006 — 8
  3. 40.744914143624996 — 7
  4. 40.86734453983834 — 7
  5. 40.64832048620134 — 6
  6. 40.74451879806252 — 6
  7. 40.67831758601989 — 6
  8. 40.77442086598845 — 5
  9. 40.82337577056312 — 5
  10. 40.866591963493335 — 5
  11. 40.700835637070725 — 5
  12. 40.694851633900804 — 4
  13. 40.65698230332589 — 4
  14. 40.680031571772965 — 4
  15. 40.79881467021513 — 4
  16. 40.64093766389099 — 4
  17. 40.874207322276355 — 4
  18. 40.72495870564602 — 4
  19. 40.88934639713765 — 4
  20. 40.83066324047387 — 4

longitude categorical

687 singleton categories
rows1,000
null12 (1.2%)
unique794
top_value-74.13551741527912
top_rate9.11e-03
cardinality794
entropy9.449
entropy_ratio0.981
Top values (rank 1–20)
  1. -74.13551741527912 — 9
  2. -73.96649227605458 — 8
  3. -73.88187760396336 — 7
  4. -73.91906278851496 — 7
  5. -73.78828125130184 — 6
  6. -73.88448390553113 — 6
  7. -73.90864580709884 — 6
  8. -73.87729410513894 — 5
  9. -73.86492637415863 — 5
  10. -73.89766001179035 — 5
  11. -73.80655093855829 — 5
  12. -73.79367980321378 — 4
  13. -73.96222514965272 — 4
  14. -73.8724454944903 — 4
  15. -73.94779857268328 — 4
  16. -73.95823461385314 — 4
  17. -73.9026490846547 — 4
  18. -73.85241193799187 — 4
  19. -73.86400388206638 — 4
  20. -73.87487410501063 — 4

location unknown

no profiler for kind=unknown
rows1,000
null0 (0.0%)

:@computed_region_f5dn_yrer categorical

rows1,000
null12 (1.2%)
unique62
top_value47
top_rate0.045
cardinality62
entropy5.698
entropy_ratio0.957
Top values (rank 1–20)
  1. 47 — 44
  2. 1 — 40
  3. 58 — 38
  4. 60 — 33
  5. 59 — 33
  6. 41 — 31
  7. 43 — 26
  8. 54 — 26
  9. 18 — 26
  10. 39 — 25
  11. 45 — 24
  12. 29 — 23
  13. 66 — 23
  14. 36 — 22
  15. 25 — 22
  16. 2 — 22
  17. 55 — 22
  18. 61 — 19
  19. 70 — 19
  20. 34 — 19

:@computed_region_yeji_bk3q categorical

rows1,000
null12 (1.2%)
unique5
top_value2
top_rate0.316
cardinality5
entropy2.080
entropy_ratio0.896
Top values (rank 1–20)
  1. 2 — 312
  2. 3 — 250
  3. 5 — 229
  4. 4 — 175
  5. 1 — 22

:@computed_region_sbqj_enih categorical

rows1,000
null12 (1.2%)
unique75
top_value37
top_rate0.040
cardinality75
entropy5.867
entropy_ratio0.942
Top values (rank 1–20)
  1. 37 — 40
  2. 26 — 38
  3. 22 — 36
  4. 43 — 33
  5. 32 — 33
  6. 72 — 27
  7. 28 — 26
  8. 62 — 26
  9. 47 — 24
  10. 30 — 23
  11. 68 — 23
  12. 65 — 22
  13. 39 — 22
  14. 46 — 22
  15. 40 — 19
  16. 71 — 19
  17. 25 — 19
  18. 44 — 19
  19. 56 — 18
  20. 61 — 18

:@computed_region_92fq_4b7q categorical

rows1,000
null12 (1.2%)
unique51
top_value12
top_rate0.047
cardinality51
entropy5.497
entropy_ratio0.969
Top values (rank 1–20)
  1. 12 — 46
  2. 31 — 45
  3. 39 — 41
  4. 11 — 34
  5. 36 — 32
  6. 46 — 30
  7. 22 — 29
  8. 37 — 28
  9. 35 — 27
  10. 45 — 27
  11. 48 — 27
  12. 34 — 25
  13. 28 — 24
  14. 44 — 23
  15. 5 — 23
  16. 29 — 23
  17. 4 — 22
  18. 43 — 22
  19. 24 — 22
  20. 30 — 22

descriptor_2 categorical

42 singleton categories 59.6% null
rows1,000
null596 (59.6%)
unique75
top_valueNO HEAT
top_rate0.290
cardinality75
entropy3.995
entropy_ratio0.641
Top values (rank 1–20)
  1. NO HEAT — 117
  2. N/A — 98
  3. NO HEAT AND NO HOT WATER — 36
  4. NO HOT WATER — 19
  5. NM1 — 6
  6. BROKEN OR MISSING — 6
  7. ROACHES — 6
  8. Operating Improperly — 5
  9. NR5 — 5
  10. AT WALL OR CEILING — 5
  11. Littering — 4
  12. Fare/Tip Complaint - Credit Card — 4
  13. Dog — 4
  14. L10 — 4
  15. Blocking Driveway — 3
  16. Not Cleaned by Property Owner — 3
  17. Out — 3
  18. MISSING OR INADEQUATE CANS/LID — 3
  19. SAGGING OR SLOPING — 3
  20. Other — 2

resolution_description categorical

41.2% null
rows1,000
null412 (41.2%)
unique19
top_valueThe following complaint conditions are still open. HPD has already attempted to notify the property owner that the condition exists; the tenant should provide access for the owner to make the repair. HPD may attempt to contact the tenant by phone to verify the correction of the condition or an HPD Inspector may attempt to conduct an inspection.
top_rate0.241
cardinality19
entropy3.071
entropy_ratio0.723
Top values (rank 1–20)
  1. The following complaint conditions are still open. HPD has already attempted to notify the property owner that the condition exists; the tenant should provide access for the owner to make the repair. HPD may attempt to contact the tenant by phone to verify the correction of the condition or an HPD Inspector may attempt to conduct an inspection. — 142
  2. The New York City Police Department responded to the complaint and with the information available observed no evidence of a criminal violation at that time. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. If necessary, your complaint may be referred to your local precinct's special operations units (Quality of Life, etc.). We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 120
  3. This complaint is a duplicate of a building-wide condition already reported by another tenant. The original complaint is still open, and HPD may only need to confirm that the condition exists by inspecting one apartment. If we cannot contact the tenant from the original complaint or get access to that apartment, HPD may attempt to contact the person who filed this complaint to verify the correction of the condition or may conduct an inspection of your unit. You can check HPDONLINE to see if a — 89
  4. The New York City Police Department responded to the complaint and their investigation determined that no criminal violation existed. The condition was corrected without the need to issue a summons or effect an arrest. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. If necessary, your complaint may be referred to your local precinct's special operations units (Quality of Life, etc.). Thank you for your attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 67
  5. The New York City Police Department responded to the complaint and their investigation determined that a violation of law occurred. Police issued a summons in response to the complaint. Thank you for attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 41
  6. The New York City Police Department responded to the complaint but officers were unable to gain entry into the premises. If the problem persists, please contact 311 to create another complaint and ensure that contact information (e.g., buzzer number, phone number, etc.) is available to assist the responding officers in gaining entry to properly investigate the complaint. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 37
  7. The New York City Police Department responded to the complaint and their investigation determined that police action was not necessary. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 34
  8. The New York City Police Department responded to the complaint and observed no criminal violation upon their arrival. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 27
  9. The Department of Transportation referred this complaint to the appropriate Maintenance Unit for repair. — 9
  10. Your complaint has been received by the New York City Police Department and assigned to a unit at your local precinct. The responding officers will conduct an assessment of the complaint and may contact you for further information, if you left contact information. Our team is committed to resolving this matter promptly, and we appreciate your contribution to maintaining the well-being of our community. — 8
  11. The New York City Police Department responded to the complaint and observed no encampment at the noted location. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 3
  12. The Department of Transportation determined that this complaint is a duplicate of a previously filed complaint. The original complaint is being addressed. — 2
  13. The Police Department reviewed your complaint and provided additional information below. — 2
  14. The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. — 2
  15. The Department of Health and Mental Hygiene has received and processed your complaint. All restaurants and mobile food vendors are inspected annually. Restaurant inspection results can be found on WWW.NYC.GOV or a copy of the inspection can be requested from 311. — 1
  16. The New York City Police Department responded to the complaint and their investigation determined that a violation of law occurred. Police made an arrest in response to the complaint. Thank you for attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 1
  17. Service Request status for this request is available on the Department of Transportation’s website. Please click the “Learn More” link below. — 1
  18. This request required re-assignment to a new DOT unit. — 1
  19. The New York City Police Department responded to the complaint and a report was prepared as part of their investigation. Thank you for attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention. — 1

resolution_action_updated_date categorical

347 singleton categories 40.9% null
rows1,000
null409 (40.9%)
unique354
top_value2026-01-19T00:00:00.000
top_rate0.393
cardinality354
entropy6.102
entropy_ratio0.721
Top values (rank 1–20)
  1. 2026-01-19T00:00:00.000 — 232
  2. 2026-01-20T01:49:13.000 — 2
  3. 2026-01-20T01:55:13.000 — 2
  4. 2026-01-20T01:12:29.000 — 2
  5. 2026-01-20T02:01:00.000 — 2
  6. 2026-01-20T01:08:29.000 — 2
  7. 2026-01-20T00:19:12.000 — 2
  8. 2026-01-20T01:59:27.000 — 1
  9. 2026-01-20T02:04:38.000 — 1
  10. 2026-01-20T01:49:45.000 — 1
  11. 2026-01-20T02:05:08.000 — 1
  12. 2026-01-20T01:43:12.000 — 1
  13. 2026-01-20T02:04:57.000 — 1
  14. 2026-01-20T01:28:28.000 — 1
  15. 2026-01-20T01:32:18.000 — 1
  16. 2025-03-31T12:11:47.000 — 1
  17. 2025-05-28T08:40:41.000 — 1
  18. 2026-01-20T01:46:37.000 — 1
  19. 2026-01-20T01:45:05.000 — 1
  20. 2026-01-20T02:04:52.000 — 1

taxi_pick_up_location categorical

98.8% null
rows1,000
null988 (98.8%)
unique3
top_valueJOHN F KENNEDY AIRPORT, QUEENS (JAMAICA) ,NY, 11430
top_rate0.500
cardinality3
entropy1.325
entropy_ratio0.836
Top values (rank 1–20)
  1. JOHN F KENNEDY AIRPORT, QUEENS (JAMAICA) ,NY, 11430 — 6
  2. LA GUARDIA AIRPORT, QUEENS (EAST ELMHURST) ,NY, 11369 — 5
  3. 141 NAGLE AVENUE, MANHATTAN (NEW YORK), NY, 10040 — 1

vehicle_type categorical

95.7% null
rows1,000
null957 (95.7%)
unique5
top_valueCar
top_rate0.651
cardinality5
entropy1.599
entropy_ratio0.689
Top values (rank 1–20)
  1. Car — 28
  2. SUV — 5
  3. Other — 5
  4. Van — 3
  5. Truck — 2

closed_date categorical

332 singleton categories 66.4% null
rows1,000
null664 (66.4%)
unique334
top_value2026-01-20T01:00:32.000
top_rate5.95e-03
cardinality334
entropy8.380
entropy_ratio1.000
Top values (rank 1–20)
  1. 2026-01-20T01:00:32.000 — 2
  2. 2026-01-20T01:08:26.000 — 2
  3. 2026-01-20T02:04:35.000 — 1
  4. 2026-01-20T02:05:03.000 — 1
  5. 2026-01-20T01:43:08.000 — 1
  6. 2026-01-20T01:55:05.000 — 1
  7. 2026-01-20T02:04:52.000 — 1
  8. 2026-01-20T01:28:25.000 — 1
  9. 2026-01-20T01:32:15.000 — 1
  10. 2026-01-20T01:46:35.000 — 1
  11. 2026-01-20T01:45:02.000 — 1
  12. 2026-01-20T02:04:49.000 — 1
  13. 2026-01-20T01:44:55.000 — 1
  14. 2026-01-20T01:52:28.000 — 1
  15. 2026-01-20T01:38:17.000 — 1
  16. 2026-01-20T01:12:33.000 — 1
  17. 2026-01-20T01:59:33.000 — 1
  18. 2026-01-20T01:16:46.000 — 1
  19. 2026-01-20T01:26:42.000 — 1
  20. 2026-01-20T01:47:42.000 — 1

bridge_highway_name categorical

4 singleton categories 99.6% null
rows1,000
null996 (99.6%)
unique4
top_valueJ
top_rate0.250
cardinality4
entropy2.000
entropy_ratio1.000
Top values (rank 1–20)
  1. J — 1
  2. Cross Island Pkwy — 1
  3. Long Island Expwy — 1
  4. Nassau Expwy — 1

bridge_highway_segment categorical

4 singleton categories 99.6% null
rows1,000
null996 (99.6%)
unique4
top_valueMezzanine
top_rate0.250
cardinality4
entropy2.000
entropy_ratio1.000
Top values (rank 1–20)
  1. Mezzanine — 1
  2. Hempstead Ave (NY 24) (Exit 26C) — 1
  3. Van Dam St (Exit 15) - Queens Midtown Tunnel — 1
  4. Belt Pkwy So Conduit Ave (Exit 2 N) — 1

facility_type categorical

95.9% null top value is 100.0% of rows
rows1,000
null959 (95.9%)
unique1
top_valueN/A
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Top values (rank 1–20)
  1. N/A — 41

bridge_highway_direction categorical

3 singleton categories 99.7% null
rows1,000
null997 (99.7%)
unique3
top_valueSouth/Long Island Bound
top_rate0.333
cardinality3
entropy1.585
entropy_ratio1.000
Top values (rank 1–20)
  1. South/Long Island Bound — 1
  2. West/Manhattan Bound — 1
  3. Eastbound — 1

road_ramp categorical

99.7% null
rows1,000
null997 (99.7%)
unique2
top_valueRamp
top_rate0.667
cardinality2
entropy0.918
entropy_ratio0.918
Top values (rank 1–20)
  1. Ramp — 2
  2. Roadway — 1

taxi_company_borough categorical

1 singleton categories 99.9% null top value is 100.0% of rows
rows1,000
null999 (99.9%)
unique1
top_valueBRONX
top_rate1.000
cardinality1
entropy-0.000
entropy_ratio0.000
Top values (rank 1–20)
  1. BRONX — 1