saturn

/home/coolhand/html/datavis/data_trove/data/urban/parking_violations_sample.csv 10,000 rows sample n=10,000 seed 42 2026-05-01T18:05:35+00:00

Overview

Source/home/coolhand/html/datavis/data_trove/data/urban/parking_violations_sample.csv
Total rows10,000
Profiled sample10,000
Columns9
Generated2026-05-01T18:05:35+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 (10)
  • 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_011CacHuWCt8ho4og9ziDySk'}
  • column:summons_number: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_011CacHuWksgY6q3j1tENvpw'}
  • column:issue_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_011CacHuXQKGoFQVgeathqk2'}
  • column:violation_code: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_011CacHuXr72ht73WvKX5hnr'}
  • column:violation_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_011CacHuYPMGZKQA3zEgWFRK'}
  • 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_011CacHuYu72u3uLvX983X4H'}
  • column:vehicle_make: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_011CacHuZNsvoGTsFsjK7YPa'}
  • column:vehicle_color: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_011CacHuZsQ9Xtp1bYqAPqoH'}
  • column:violation_time: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_011CacHuaVrEx7ipEF3FDm6e'}
  • column:issuing_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_011CacHubE1NHsJpJzzrTavg'}

Numeric correlation

Languages detected

Per-string language detection across text columns (sampled).

summons_number numeric

rows10,000
null0 (0.0%)
unique10,000
min1,124,851,148
max9,255,295,810
mean4,778,744,250
median4,976,262,516
std2,705,973,235
q12,028,177,479
q34,976,287,749
iqr2,948,110,270
skew0.468
kurtosis-0.913
n_outliers0
outlier_rate0.000
zero_rate0.000

issue_date categorical

368 singleton categories
rows10,000
null0 (0.0%)
unique687
top_value2025-12-28T00:00:00.000
top_rate0.654
cardinality687
entropy2.765
entropy_ratio0.293
Top values (rank 1–20)
  1. 2025-12-28T00:00:00.000 — 6,542
  2. 2025-12-30T00:00:00.000 — 1,594
  3. 2025-12-29T00:00:00.000 — 356
  4. 2026-06-26T00:00:00.000 — 14
  5. 2026-09-27T00:00:00.000 — 13
  6. 2026-09-25T00:00:00.000 — 12
  7. 2025-12-31T00:00:00.000 — 12
  8. 2026-06-27T00:00:00.000 — 11
  9. 2026-10-25T00:00:00.000 — 10
  10. 2026-08-31T00:00:00.000 — 10
  11. 2026-08-27T00:00:00.000 — 10
  12. 2026-07-26T00:00:00.000 — 10
  13. 2026-06-30T00:00:00.000 — 10
  14. 2026-08-25T00:00:00.000 — 9
  15. 2026-10-29T00:00:00.000 — 8
  16. 2026-10-17T00:00:00.000 — 8
  17. 2026-10-05T00:00:00.000 — 8
  18. 2026-09-23T00:00:00.000 — 8
  19. 2026-07-27T00:00:00.000 — 8
  20. 2026-07-24T00:00:00.000 — 8

violation_code numeric

10.1% rows beyond 1.5 IQR
rows10,000
null0 (0.0%)
unique62
min4.000
max99.000
mean35.852
median36.000
std17.549
q121.000
q336.000
iqr15.000
skew1.514
kurtosis2.986
n_outliers1,007
outlier_rate0.101
zero_rate0.000

violation_description categorical

rows10,000
null1,513 (15.1%)
unique74
top_valuePHTO SCHOOL ZN SPEED VIOLATION
top_rate0.520
cardinality74
entropy2.808
entropy_ratio0.452
Top values (rank 1–20)
  1. PHTO SCHOOL ZN SPEED VIOLATION — 4,416
  2. No Parking Street Cleaning — 1,428
  3. 14-No Standing — 598
  4. 40-Fire Hydrant — 463
  5. 20A-No Parking (Non-COM) — 131
  6. 19-No Stand (bus stop) — 123
  7. 16A-No Std (Com Veh) Non-COM — 117
  8. 46A-Double Parking (Non-COM) — 106
  9. Detached Trailer — 105
  10. Fire Hydrant — 94
  11. 71A-Insp Sticker Expired (NYS) — 77
  12. 70A-Reg. Sticker Expired (NYS) — 66
  13. No Standing — 61
  14. Missing Equipment — 56
  15. 50-Crosswalk — 53
  16. 74-Missing Display Plate — 39
  17. 13-No Stand (taxi stand) — 38
  18. 17-No Stand (exc auth veh) — 38
  19. Double Parking — 32
  20. 98-Obstructing Driveway — 31

street_name text

28 languages detected in sample 77.3% rows are all-caps 68.8% duplicate strings
rows10,000
null4 (0.0%)
unique3,115
len_min2
len_max20
len_mean14.872
len_median16.000
len_p9520.000
word_mean3.513
word_median3.000
n_empty0
n_duplicates6,881
duplicate_rate0.688
vocab_size1,760
readability_flesch_mean62.546
emoji_rate0.000
url_rate0.000
one_word_rate0.014
allcaps_rate0.773
boilerplate_rate0.000
Sample values (first 10)
  1. BEACH 145 ST
  2. WB HYLAN BLVD @ LUTE
  3. NB KNAPP ST @ ALLEN
  4. EB NORTHERN BLVD @ A
  5. E 45th St
  6. EB FOREST AVE @ CRYS
  7. 10th Ave
  8. SB WATERS PL @ BRONX
  9. WB SEAGIRT BLVD @ B
  10. S/W C/O 173 ST

vehicle_make categorical

rows10,000
null78 (0.8%)
unique126
top_valueHONDA
top_rate0.134
cardinality126
entropy4.661
entropy_ratio0.668
Top values (rank 1–20)
  1. HONDA — 1,331
  2. TOYOT — 1,302
  3. NISSA — 770
  4. FORD — 603
  5. BMW — 559
  6. ME/BE — 521
  7. JEEP — 450
  8. CHEVR — 449
  9. HYUND — 365
  10. SUBAR — 273
  11. KIA — 268
  12. LEXUS — 268
  13. MAZDA — 257
  14. AUDI — 242
  15. ACURA — 221
  16. VOLKS — 199
  17. DODGE — 175
  18. TESLA — 152
  19. INFIN — 151
  20. GMC — 134

vehicle_color categorical

rows10,000
null943 (9.4%)
unique99
top_valueGY
top_rate0.230
cardinality99
entropy3.676
entropy_ratio0.554
Top values (rank 1–20)
  1. GY — 2,079
  2. BK — 1,784
  3. WH — 1,579
  4. BL — 631
  5. RD — 348
  6. WHITE — 347
  7. BLK — 275
  8. BLACK — 273
  9. GREY — 239
  10. GRY — 167
  11. GR — 148
  12. BLUE — 131
  13. RED — 124
  14. GRAY — 113
  15. SILVE — 99
  16. WHT — 65
  17. YW — 62
  18. BR — 60
  19. WHI — 57
  20. BLU — 46

violation_time text

100.0% rows are a single word 100.0% rows are all-caps 95th-percentile length under 20 chars 85.7% duplicate strings
rows10,000
null4 (0.0%)
unique1,432
len_min5
len_max5
len_mean5.000
len_median5.000
len_p955.000
word_mean1.000
word_median1.000
n_empty0
n_duplicates8,564
duplicate_rate0.857
vocab_size1,433
readability_flesch_mean121.220
emoji_rate0.000
url_rate0.000
one_word_rate1.000
allcaps_rate1.000
boilerplate_rate0.000
Sample values (first 10)
  1. 0840P
  2. 0259P
  3. 1127A
  4. 1135A
  5. 0622P
  6. 0725A
  7. 0453P
  8. 0939A
  9. 1139A
  10. 1230P

issuing_agency categorical

rows10,000
null0 (0.0%)
unique20
top_valueV
top_rate0.442
cardinality20
entropy2.007
entropy_ratio0.464
Top values (rank 1–20)
  1. V — 4,416
  2. T — 2,131
  3. S — 1,946
  4. P — 1,325
  5. K — 41
  6. N — 38
  7. A — 23
  8. Y — 17
  9. M — 13
  10. O — 9
  11. C — 9
  12. 8 — 8
  13. 3 — 6
  14. X — 5
  15. 9 — 3
  16. W — 3
  17. L — 2
  18. R — 2
  19. F — 2
  20. U — 1