saturn·

data trove nyc 311 service requests

saturn notebook · generated 2026-06-21 Report Notebook

Overview

Source: /home/coolhand/html/datavis/data_trove/cache/wild/nyc_311_sample.json

Saturn profiled 1,000 rows across 47 columns. The stats below are deterministic and machine-readable; the prose is a language-model interpretation of those stats (opt-in, added after the fact, never sees raw rows).

[2]:
!pip install saturn-dissect
import subprocess
subprocess.run([
    "saturn", "analyze", "/home/coolhand/html/datavis/data_trove/cache/wild/nyc_311_sample.json",
    "--findings", "data-trove-nyc-311-service-requests.json",
    "--llm", "anthropic:default",
])

Summary confidence: high

This dataset is a sample of 1,000 NYC 311 service requests, capturing complaints logged across the five boroughs with details on complaint type, location, agency, and resolution status. The dominant signal is complaint type: 'Noise - Residential' alone accounts for 39.3% of records, followed by 'Illegal Parking' (19.7%) and 'Noise - Commercial' (14.8%), pointing to a dataset heavily skewed toward NYPD-handled quality-of-life complaints (NYPD handles 88% of cases). A second area worth examining is resolution status — 61% of complaints are closed, 30.5% are still in progress, and 8.5% remain open, which raises questions about agency workload and response time. Many specialty columns (road_ramp, taxi_company_borough, bridge_highway fields) are nearly entirely null (99%+), indicating they apply only to rare complaint subtypes and can largely be ignored.

citing: complaint_type.top_value · complaint_type.top_rate · agency.top_value · agency.top_rate · status.top_values · borough.top_values · open_data_channel_type.top_values · descriptor.top_value · road_ramp.null_rate · taxi_company_borough.null_rate

Out[4]:

saturn.schema() · 47 columns

column kind n null% unique alerts
unique_key categorical 1,000 0.0% 1,000 long_tail
created_date categorical 1,000 0.0% 939 long_tail
agency categorical 1,000 0.0% 11
agency_name categorical 1,000 0.0% 11
complaint_type categorical 1,000 0.0% 45
descriptor categorical 1,000 0.0% 71
location_type categorical 1,000 1.4% 20
incident_zip categorical 1,000 0.3% 146
incident_address categorical 1,000 0.5% 776 long_tail
street_name categorical 1,000 0.5% 569 long_tail
cross_street_1 categorical 1,000 8.0% 511 long_tail
cross_street_2 categorical 1,000 7.9% 504 long_tail
intersection_street_1 categorical 1,000 8.5% 506 long_tail
intersection_street_2 categorical 1,000 8.4% 499 long_tail
address_type categorical 1,000 0.2% 4 imbalance
city categorical 1,000 2.1% 36
landmark categorical 1,000 10.5% 515 long_tail
status categorical 1,000 0.0% 3
community_board categorical 1,000 0.0% 65
council_district categorical 1,000 0.9% 51
police_precinct categorical 1,000 0.0% 76
bbl categorical 1,000 5.5% 719 long_tail
borough categorical 1,000 0.0% 5
x_coordinate_state_plane categorical 1,000 0.7% 763 long_tail
y_coordinate_state_plane categorical 1,000 0.7% 768 long_tail
open_data_channel_type categorical 1,000 0.0% 4
park_facility_name categorical 1,000 0.0% 2 imbalance
park_borough categorical 1,000 0.0% 5
latitude categorical 1,000 0.7% 770 long_tail
longitude categorical 1,000 0.7% 770 long_tail
location unknown 1,000 0.0% skipped
:@computed_region_f5dn_yrer categorical 1,000 0.7% 62
:@computed_region_yeji_bk3q categorical 1,000 0.7% 5
:@computed_region_sbqj_enih categorical 1,000 0.7% 75
:@computed_region_92fq_4b7q categorical 1,000 0.7% 51
descriptor_2 categorical 1,000 88.2% 43 long_tail null_rate
resolution_description categorical 1,000 30.7% 16 null_rate
resolution_action_updated_date categorical 1,000 30.6% 585 long_tail null_rate
closed_date categorical 1,000 39.0% 585 long_tail null_rate
taxi_pick_up_location categorical 1,000 99.4% 6 long_tail null_rate
vehicle_type categorical 1,000 96.5% 4 null_rate
facility_type categorical 1,000 99.0% 1 null_rate imbalance
taxi_company_borough categorical 1,000 99.9% 1 long_tail null_rate imbalance
bridge_highway_name categorical 1,000 99.7% 2 null_rate
bridge_highway_direction categorical 1,000 99.7% 2 null_rate
road_ramp categorical 1,000 99.9% 1 long_tail null_rate imbalance
bridge_highway_segment categorical 1,000 99.7% 2 null_rate
Fig 1.
complaint_type · Look for the steep drop-off after 'Noise - Residential' (39.3%) and 'Illegal Parking' (19.7%) — a small number of complaint types dominate the dataset.
Show data table
Top values for complaint_type (20 unique shown, of 45 total).
valuecountshare
Noise - Residential39339.3%
Illegal Parking19719.7%
Noise - Commercial14814.8%
Blocked Driveway555.5%
HEAT/HOT WATER494.9%
Noise - Street/Sidewalk444.4%
Noise - Vehicle171.7%
UNSANITARY CONDITION121.2%
Street Condition70.7%
Non-Emergency Police Matter70.7%
Smoking or Vaping50.5%
Abandoned Vehicle50.5%
Animal-Abuse50.5%
Rodent40.4%
Encampment40.4%
Taxi Complaint30.3%
Dirty Condition30.3%
PAINT/PLASTER30.3%
GENERAL30.3%
Drinking20.2%
Fig 2.
status · With 61% closed, 30.5% in progress, and 8.5% open, check whether specific agencies or complaint types are driving the backlog.
Show data table
Top values for status (3 unique shown, of 3 total).
valuecountshare
Closed61061.0%
In Progress30530.5%
Open858.5%
Fig 3.
borough · Queens, Manhattan, and Brooklyn each account for roughly a quarter of complaints, while Staten Island is a clear outlier at just 1.1%.
Show data table
Top values for borough (5 unique shown, of 5 total).
valuecountshare
QUEENS27427.4%
MANHATTAN25825.8%
BROOKLYN25425.4%
BRONX20320.3%
STATEN ISLAND111.1%
Fig 4.
open_data_channel_type · Online (46.6%) and Mobile (28.8%) together dominate submission channels — look at whether channel type correlates with complaint category.
Show data table
Top values for open_data_channel_type (4 unique shown, of 4 total).
valuecountshare
ONLINE46646.6%
MOBILE28828.8%
PHONE23623.6%
UNKNOWN101.0%
Fig 5.
descriptor · 'Loud Music/Party' at 42.7% dwarfs all other descriptors — confirm whether this single descriptor is inflating the noise complaint count.
Show data table
Top values for descriptor (20 unique shown, of 71 total).
valuecountshare
Loud Music/Party42742.7%
Banging/Pounding11411.4%
Blocked Hydrant797.9%
No Access454.5%
Posted Parking Sign Violation424.2%
Loud Talking363.6%
ENTIRE BUILDING353.5%
Blocked Sidewalk212.1%
Commercial Overnight Parking202.0%
APARTMENT ONLY141.4%
Car/Truck Music131.3%
Double Parked Blocking Traffic131.3%
Loud Television101.0%
Partial Access101.0%
PESTS101.0%
Blocked Crosswalk90.9%
Pothole60.6%
Allowed in Smoke Free Area50.5%
With License Plate50.5%
No Shelter50.5%
Fig 6.
Per-column null rate across the corpus. Columns are ordered by input position.
Show data table
Per-column null rate across the corpus.
columnkindnull %
unique_keycategorical0.0%
created_datecategorical0.0%
agencycategorical0.0%
agency_namecategorical0.0%
complaint_typecategorical0.0%
descriptorcategorical0.0%
location_typecategorical1.4%
incident_zipcategorical0.3%
incident_addresscategorical0.5%
street_namecategorical0.5%
cross_street_1categorical8.0%
cross_street_2categorical7.9%
intersection_street_1categorical8.5%
intersection_street_2categorical8.4%
address_typecategorical0.2%
citycategorical2.1%
landmarkcategorical10.5%
statuscategorical0.0%
community_boardcategorical0.0%
council_districtcategorical0.9%
police_precinctcategorical0.0%
bblcategorical5.5%
boroughcategorical0.0%
x_coordinate_state_planecategorical0.7%
y_coordinate_state_planecategorical0.7%
open_data_channel_typecategorical0.0%
park_facility_namecategorical0.0%
park_boroughcategorical0.0%
latitudecategorical0.7%
longitudecategorical0.7%
locationunknown0.0%
:@computed_region_f5dn_yrercategorical0.7%
:@computed_region_yeji_bk3qcategorical0.7%
:@computed_region_sbqj_enihcategorical0.7%
:@computed_region_92fq_4b7qcategorical0.7%
descriptor_2categorical88.2%
resolution_descriptioncategorical30.7%
resolution_action_updated_datecategorical30.6%
closed_datecategorical39.0%
taxi_pick_up_locationcategorical99.4%
vehicle_typecategorical96.5%
facility_typecategorical99.0%
taxi_company_boroughcategorical99.9%
bridge_highway_namecategorical99.7%
bridge_highway_directioncategorical99.7%
road_rampcategorical99.9%
bridge_highway_segmentcategorical99.7%

unique_key categorical identifier

This column is a unique row identifier, likely a primary key or transaction/record ID — every one of the 1000 rows has a distinct value, giving it perfect cardinality and a maximum entropy ratio of 1.0. Values appear to be numeric strings in a narrow range (~67519046–67525266), suggesting sequential or near-sequential ID assignment. There is nothing analytically surprising here beyond the expected long-tail alert, which is a trivial consequence of full uniqueness. The null rate is 0.0.

Treatment: Drop before modelling; retain only for row tracing or joins.

anthropic:default · confidence high
Out[12]:

saturn.columns["unique_key"].stats

statvalue
n1,000
nulls0 (0.0%)
unique1,000
top_value 67519092
top_rate 0.001
cardinality 1,000
entropy 9.966
entropy_ratio 1
alert: long_tail1000 singleton categories
Fig 7.
Top values for unique_key.
Show data table
Top values for unique_key (20 unique shown, of 1000 total).
valuecountshare
6751909210.1%
6752526610.1%
6752523910.1%
6752109410.1%
6751904610.1%
6751906010.1%
6752421810.1%
6752422110.1%
6752025310.1%
6751907810.1%
6752215710.1%
6752109810.1%
6752423410.1%
6752318310.1%
6751909110.1%
6752423110.1%
6752010410.1%
6752109510.1%
6752212710.1%
6752318610.1%

created_date categorical timestamp

This column is a creation timestamp, stored as a categorical string in ISO-8601 millisecond format (e.g., '2026-01-17T23:49:56.000'). With 939 unique values out of 1000 rows and an entropy ratio of 0.995, it behaves almost like a unique identifier. The long-tail alert and the fact that the most frequent value appears only 9 times (0.9% of rows) suggest occasional duplicate timestamps — likely batch inserts or rapid successive record creation within the same second.

Treatment: Parse to datetime, then engineer time-based features (hour, day-of-week, recency); do not use raw string for modelling.

anthropic:default · confidence high
Out[15]:

saturn.columns["created_date"].stats

statvalue
n1,000
nulls0 (0.0%)
unique939
top_value 2026-01-17T23:49:56.000
top_rate 0.009
cardinality 939
entropy 9.828
entropy_ratio 0.9952
alert: long_tail889 singleton categories
Fig 8.
Top values for created_date.
Show data table
Top values for created_date (20 unique shown, of 939 total).
valuecountshare
2026-01-17T23:49:56.00090.9%
2026-01-17T23:43:55.00040.4%
2026-01-18T01:11:10.00030.3%
2026-01-17T23:04:06.00030.3%
2026-01-18T01:25:57.00020.2%
2026-01-18T01:25:16.00020.2%
2026-01-18T01:18:23.00020.2%
2026-01-18T01:12:27.00020.2%
2026-01-18T01:08:57.00020.2%
2026-01-18T01:07:55.00020.2%
2026-01-18T01:04:36.00020.2%
2026-01-18T01:02:54.00020.2%
2026-01-18T00:53:20.00020.2%
2026-01-18T00:47:20.00020.2%
2026-01-18T00:38:56.00020.2%
2026-01-18T00:35:43.00020.2%
2026-01-18T00:35:09.00020.2%
2026-01-18T00:31:54.00020.2%
2026-01-18T00:28:06.00020.2%
2026-01-18T00:26:25.00020.2%

agency categorical label

This column identifies the New York City municipal agency associated with each record, with 11 distinct agency codes and no nulls across 1,000 rows. The distribution is severely skewed: NYPD alone accounts for 88% of all records (880 of 1,000), while the remaining 10 agencies collectively cover only 120 rows — several (DHS, OOS, DCWP, DPR) appear just twice each. The low entropy ratio of 0.223 confirms this near-monolithic concentration, which could bias any agency-level analysis or model trained on this sample.

Treatment: One-hot encode for modelling, but note severe class imbalance — consider oversampling or stratified splitting to ensure minority agencies are represented.

anthropic:default · confidence high
Out[18]:

saturn.columns["agency"].stats

statvalue
n1,000
nulls0 (0.0%)
unique11
top_value NYPD
top_rate 0.88
cardinality 11
entropy 0.7715
entropy_ratio 0.223
Fig 9.
Top values for agency.
Show data table
Top values for agency (11 unique shown, of 11 total).
valuecountshare
NYPD88088.0%
HPD747.4%
DOHMH131.3%
DOT111.1%
TLC60.6%
DSNY60.6%
DHS20.2%
OOS20.2%
DCWP20.2%
DPR20.2%
DEP20.2%

agency_name categorical label

This column identifies the New York City municipal agency responsible for each record, with 11 distinct agencies across 1,000 rows and no nulls. It is severely dominated by the New York City Police Department, which accounts for 88% of all records (880 of 1,000), producing a very low entropy ratio of 0.223. The remaining 10 agencies collectively cover only 120 records, with several (e.g., Department of Homeless Services, Office of the Sheriff) appearing just twice. This extreme class imbalance will distort any agency-level aggregation or model that uses this column as a feature.

Treatment: One-hot encode with caution given severe class imbalance; consider grouping rare agencies (≤6 occurrences) into an 'Other' category before modelling.

anthropic:default · confidence high
Out[21]:

saturn.columns["agency_name"].stats

statvalue
n1,000
nulls0 (0.0%)
unique11
top_value New York City Police Department
top_rate 0.88
cardinality 11
entropy 0.7715
entropy_ratio 0.223
Fig 10.
Top values for agency_name.
Show data table
Top values for agency_name (11 unique shown, of 11 total).
valuecountshare
New York City Police Department88088.0%
Department of Housing Preservation and Development747.4%
Department of Health and Mental Hygiene131.3%
Department of Transportation111.1%
Taxi and Limousine Commission60.6%
Department of Sanitation60.6%
Department of Homeless Services20.2%
Office of the Sheriff20.2%
Department of Consumer and Worker Protection20.2%
Department of Parks and Recreation20.2%
Department of Environmental Protection20.2%

complaint_type categorical label

This column contains the categorized type of civic complaint (likely NYC 311 service requests), with 45 distinct complaint categories across 1,000 records and zero nulls. The distribution is heavily skewed: 'Noise - Residential' alone accounts for 39.3% of all records, and the top three noise-related categories together represent roughly 60% of the dataset. The entropy ratio of 0.53 indicates moderate concentration — far from uniform — with a long tail of rare complaint types below the top 10.

Treatment: One-hot encode or target-encode for modelling; consider grouping rare categories (below ~7 occurrences) into an 'Other' bucket to reduce noise.

anthropic:default · confidence high
Out[24]:

saturn.columns["complaint_type"].stats

statvalue
n1,000
nulls0 (0.0%)
unique45
top_value Noise - Residential
top_rate 0.393
cardinality 45
entropy 2.935
entropy_ratio 0.5345
Fig 11.
Top values for complaint_type.
Show data table
Top values for complaint_type (20 unique shown, of 45 total).
valuecountshare
Noise - Residential39339.3%
Illegal Parking19719.7%
Noise - Commercial14814.8%
Blocked Driveway555.5%
HEAT/HOT WATER494.9%
Noise - Street/Sidewalk444.4%
Noise - Vehicle171.7%
UNSANITARY CONDITION121.2%
Street Condition70.7%
Non-Emergency Police Matter70.7%
Smoking or Vaping50.5%
Abandoned Vehicle50.5%
Animal-Abuse50.5%
Rodent40.4%
Encampment40.4%
Taxi Complaint30.3%
Dirty Condition30.3%
PAINT/PLASTER30.3%
GENERAL30.3%
Drinking20.2%

descriptor categorical label

This column contains descriptive sub-type labels for service requests or complaints — likely from a system such as NYC 311 — further specifying the nature of each complaint beyond a top-level category. 'Loud Music/Party' dominates with 42.7% of all 1,000 records, creating notable class imbalance; the top two values alone account for 54.1% of rows. With 71 unique values, entropy ratio of 0.576, and zero nulls, the column is moderately concentrated but still covers a meaningful range of complaint types including noise, parking, and building issues.

Treatment: One-hot encode for modelling, but consider grouping rare categories (below ~1% frequency) into an 'Other' bucket to manage the 71-level cardinality.

anthropic:default · confidence high
Out[27]:

saturn.columns["descriptor"].stats

statvalue
n1,000
nulls0 (0.0%)
unique71
top_value Loud Music/Party
top_rate 0.427
cardinality 71
entropy 3.54
entropy_ratio 0.5756
Fig 12.
Top values for descriptor.
Show data table
Top values for descriptor (20 unique shown, of 71 total).
valuecountshare
Loud Music/Party42742.7%
Banging/Pounding11411.4%
Blocked Hydrant797.9%
No Access454.5%
Posted Parking Sign Violation424.2%
Loud Talking363.6%
ENTIRE BUILDING353.5%
Blocked Sidewalk212.1%
Commercial Overnight Parking202.0%
APARTMENT ONLY141.4%
Car/Truck Music131.3%
Double Parked Blocking Traffic131.3%
Loud Television101.0%
Partial Access101.0%
PESTS101.0%
Blocked Crosswalk90.9%
Pothole60.6%
Allowed in Smoke Free Area50.5%
With License Plate50.5%
No Shelter50.5%

location_type categorical label

This column encodes the type of location where an incident or event occurred, with 20 distinct values across 1,000 rows. The dominant category is 'Residential Building/House' at 40.2% (396 occurrences), followed by 'Street/Sidewalk' at 324. A significant data quality issue is immediately apparent: the same real-world concept appears under multiple inconsistent labels — 'Residential Building/House' (396), 'RESIDENTIAL BUILDING' (74), and 'Residential Building' (7) are clearly duplicates, as are 'Street/Sidewalk' (324), 'Street' (8), and 'Sidewalk' (5) — meaning true cardinality is substantially lower than 20 and category frequencies are understated.

Treatment: Normalize case and consolidate synonymous labels (e.g. merge 'RESIDENTIAL BUILDING', 'Residential Building', 'Residential Building/House') before encoding as a categorical feature.

anthropic:default · confidence high
Out[30]:

saturn.columns["location_type"].stats

statvalue
n1,000
nulls14 (1.4%)
unique20
top_value Residential Building/House
top_rate 0.4016
cardinality 20
entropy 2.237
entropy_ratio 0.5177
Fig 13.
Top values for location_type.
Show data table
Top values for location_type (20 unique shown, of 20 total).
valuecountshare
Residential Building/House39639.6%
Street/Sidewalk32432.4%
Club/Bar/Restaurant919.1%
RESIDENTIAL BUILDING747.4%
Store/Commercial606.0%
Street80.8%
Residential Building70.7%
Sidewalk50.5%
3+ Family Apartment Building30.3%
House and Store30.3%
3+ Family Apt. Building20.2%
Business20.2%
Subway20.2%
Other20.2%
Park/Playground20.2%
1-2 Family Mixed Use Building10.1%
Restaurant/Bar/Deli/Bakery10.1%
Bridge10.1%
Taxi10.1%
1-2 Family Dwelling10.1%

incident_zip categorical feature

This column contains US ZIP codes associated with incidents, all values appearing to be New York City ZIP codes (10xxx and 11xxx series, consistent with Manhattan, Queens, and the Bronx). With 146 unique values across 1,000 rows and a high entropy ratio of 0.931, the distribution is remarkably spread — the most frequent ZIP '10011' appears only 42 times (4.2%), indicating incidents are distributed broadly across many neighbourhoods rather than concentrated in a few. Null rate is negligible at 0.3%.

Treatment: Encode as geographic feature; consider grouping by borough or joining to a ZIP-code reference table for lat/lon or demographic enrichment.

anthropic:default · confidence high
Out[33]:

saturn.columns["incident_zip"].stats

statvalue
n1,000
nulls3 (0.3%)
unique146
top_value 10011
top_rate 0.04213
cardinality 146
entropy 6.696
entropy_ratio 0.9313
Fig 14.
Top values for incident_zip.
Show data table
Top values for incident_zip (20 unique shown, of 146 total).
valuecountshare
10011424.2%
11421353.5%
11385292.9%
10463222.2%
10031222.2%
11368212.1%
10456202.0%
10009191.9%
10462171.7%
10002161.6%
11206151.5%
11212151.5%
11226141.4%
11375141.4%
10012141.4%
11373141.4%
10461131.3%
10452121.2%
10468121.2%
10034121.2%

incident_address categorical feature

This column contains free-text street addresses of incident locations, likely from a New York City incident or complaints dataset given recognizable street names (Lenox Avenue, Avenue of the Americas, Bruckner Boulevard). With 776 unique values across 1,000 rows and an entropy ratio of 0.97, the distribution is highly dispersed — a classic long-tail pattern. Notably, '126 WEST 13 STREET' appears 31 times (3.1% of rows), a disproportionate spike that may indicate a shelter, institution, or high-incident venue worth investigating. Inconsistent spacing in values like '60 EAST 93 STREET' suggests formatting irregularities that will need normalization.

Treatment: Normalize whitespace and casing, then geocode or extract street/borough components for spatial modelling.

anthropic:default · confidence high
Out[36]:

saturn.columns["incident_address"].stats

statvalue
n1,000
nulls5 (0.5%)
unique776
top_value 126 WEST 13 STREET
top_rate 0.03116
cardinality 776
entropy 9.321
entropy_ratio 0.9709
alert: long_tail664 singleton categories
Fig 15.
Top values for incident_address.
Show data table
Top values for incident_address (20 unique shown, of 776 total).
valuecountshare
126 WEST 13 STREET313.1%
60 EAST 93 STREET131.3%
71 LENOX AVENUE80.8%
105 MACDOUGAL STREET80.8%
1465 WASHINGTON AVENUE80.8%
2918 BRUCKNER BOULEVARD70.7%
190 AVENUE OF THE AMERICAS50.5%
235 COURT STREET50.5%
74-03 85 DRIVE50.5%
85 TOMPKINS AVENUE50.5%
1365 5 AVENUE40.4%
112-17 NORTHERN BOULEVARD40.4%
182 NAGLE AVENUE40.4%
108-26 159 STREET40.4%
402 ONDERDONK AVENUE40.4%
465 SENECA AVENUE30.3%
2140 MATTHEWS AVENUE30.3%
28-10 JACKSON AVENUE30.3%
62-11 108 STREET30.3%
499 MYRTLE AVENUE30.3%

street_name categorical feature

This column contains street names, almost certainly from a New York City dataset given entries like 'WEST 13 STREET', 'LENOX AVENUE', 'BRUCKNER BOULEVARD', and 'JAMAICA AVENUE'. With 569 unique values across 1,000 rows and an entropy ratio of 0.955, the distribution is highly spread — the top value 'WEST 13 STREET' appears only 31 times (3.1% of rows), confirming the long-tail alert. The near-zero null rate (0.5%) is clean, but the high cardinality and long tail mean most street names are rare, which limits direct one-hot encoding utility.

Treatment: Frequency-encode or embed as a categorical feature; avoid one-hot encoding due to 569-level cardinality and long-tail distribution.

anthropic:default · confidence high
Out[39]:

saturn.columns["street_name"].stats

statvalue
n1,000
nulls5 (0.5%)
unique569
top_value WEST 13 STREET
top_rate 0.03116
cardinality 569
entropy 8.742
entropy_ratio 0.9551
alert: long_tail371 singleton categories
Fig 16.
Top values for street_name.
Show data table
Top values for street_name (20 unique shown, of 569 total).
valuecountshare
WEST 13 STREET313.1%
EAST 93 STREET131.3%
JAMAICA AVENUE111.1%
WASHINGTON AVENUE111.1%
LENOX AVENUE101.0%
MACDOUGAL STREET101.0%
BROADWAY90.9%
BRUCKNER BOULEVARD80.8%
BROOKLYN AVENUE70.7%
NORTHERN BOULEVARD70.7%
76 STREET70.7%
COURT STREET60.6%
EAST 74 STREET60.6%
GRAND STREET50.5%
BUSHWICK AVENUE50.5%
EAST 3 STREET50.5%
SENECA AVENUE50.5%
111 AVENUE50.5%
AVENUE OF THE AMERICAS50.5%
AMSTERDAM AVENUE50.5%

cross_street_1 categorical feature

This column captures the first cross street in a NYC street-address intersection, most likely from a traffic incident, 311, or similar geospatial events dataset. With 511 unique values across 1,000 rows and an entropy ratio of 0.953, the distribution is nearly flat — a strong long-tail signal — meaning the vast majority of street names appear only once or twice. The top value 'AVENUE OF THE AMERICAS' appears just 35 times (3.8% of rows), and the 8% null rate suggests some records lack cross-street data entirely.

Treatment: Normalize street name strings (abbreviations, casing), then use as a categorical geographic feature or join to a street reference table; high cardinality warrants frequency encoding or embedding rather than one-hot encoding.

anthropic:default · confidence high
Out[42]:

saturn.columns["cross_street_1"].stats

statvalue
n1,000
nulls80 (8.0%)
unique511
top_value AVENUE OF THE AMERICAS
top_rate 0.03804
cardinality 511
entropy 8.574
entropy_ratio 0.953
alert: long_tail324 singleton categories
Fig 17.
Top values for cross_street_1.
Show data table
Top values for cross_street_1 (20 unique shown, of 511 total).
valuecountshare
AVENUE OF THE AMERICAS353.5%
BLEECKER STREET111.1%
AMSTERDAM AVENUE111.1%
WEST 113 STREET80.8%
HIMROD STREET80.8%
112 STREET80.8%
ST PAULS PLACE80.8%
DEXTER COURT80.8%
EAST TREMONT AVENUE70.7%
BROADWAY70.7%
BEND60.6%
107 AVENUE60.6%
80 STREET60.6%
AVENUE B60.6%
3 AVENUE60.6%
EAST 182 STREET50.5%
5 AVENUE50.5%
4 AVENUE50.5%
VANDAM STREET50.5%
DEAD END50.5%

cross_street_2 categorical feature

This column contains the secondary cross-street name associated with a location record, likely from a NYC incident or address dataset. With 504 unique values across 1,000 rows and an entropy ratio of 0.948, the distribution is nearly flat — a strong long-tail signal where most street names appear very rarely. The top value '7 AVENUE' appears only 36 times (3.9% of non-null rows), and 'DEAD END' appearing 10 times is a notable data-quality flag indicating unresolved or terminus locations.

Treatment: Standardize street name abbreviations, flag 'DEAD END' as a sentinel value, and consider encoding via frequency bucketing or embedding rather than one-hot due to high cardinality.

anthropic:default · confidence high
Out[45]:

saturn.columns["cross_street_2"].stats

statvalue
n1,000
nulls79 (7.9%)
unique504
top_value 7 AVENUE
top_rate 0.03909
cardinality 504
entropy 8.511
entropy_ratio 0.9481
alert: long_tail321 singleton categories
Fig 18.
Top values for cross_street_2.
Show data table
Top values for cross_street_2 (20 unique shown, of 504 total).
valuecountshare
7 AVENUE363.6%
BROADWAY191.9%
MINETTA LANE101.0%
DEAD END101.0%
109 AVENUE90.9%
EAST 171 STREET90.9%
WEST 114 STREET80.8%
HARMAN STREET80.8%
75 STREET80.8%
EDISON AVENUE70.7%
112 PLACE70.7%
BEND70.7%
AVENUE D60.6%
DITMAS AVENUE60.6%
EAST 174 STREET60.6%
10 AVENUE60.6%
3 AVENUE60.6%
1 AVENUE60.6%
EAST 170 STREET60.6%
BALTIC STREET60.6%

intersection_street_1 categorical feature

This column captures the name of the first cross-street at an intersection, consistent with NYC street-incident or infrastructure data. With 506 unique values across 1,000 rows (entropy ratio 0.95), the distribution is nearly flat — a long-tail alert confirms that the vast majority of street names appear only once or twice, while even the top value ('AVENUE OF THE AMERICAS') accounts for just 3.8% of non-null records. An 8.5% null rate suggests intersections are not always fully recorded, which may indicate missing location data rather than true absence of a street.

Treatment: Standardize street name strings (abbreviations, spacing), then encode as a high-cardinality categorical using target encoding or embedding before modelling; impute or flag nulls separately.

anthropic:default · confidence high
Out[48]:

saturn.columns["intersection_street_1"].stats

statvalue
n1,000
nulls85 (8.5%)
unique506
top_value AVENUE OF THE AMERICAS
top_rate 0.03825
cardinality 506
entropy 8.558
entropy_ratio 0.9527
alert: long_tail319 singleton categories
Fig 19.
Top values for intersection_street_1.
Show data table
Top values for intersection_street_1 (20 unique shown, of 506 total).
valuecountshare
AVENUE OF THE AMERICAS353.5%
BLEECKER STREET111.1%
AMSTERDAM AVENUE111.1%
WEST 113 STREET80.8%
HIMROD STREET80.8%
112 STREET80.8%
ST PAULS PLACE80.8%
DEXTER COURT80.8%
EAST TREMONT AVENUE70.7%
BROADWAY70.7%
BEND60.6%
5 AVENUE60.6%
107 AVENUE60.6%
80 STREET60.6%
AVENUE B60.6%
3 AVENUE60.6%
EAST 182 STREET50.5%
4 AVENUE50.5%
VANDAM STREET50.5%
DEAD END50.5%

intersection_street_2 categorical feature

This column captures the secondary (cross) street name at an intersection, likely from a New York City incident or traffic dataset. With 499 unique values across 1,000 rows and an entropy ratio of 0.948, the distribution is nearly flat — a strong long-tail pattern where '7 AVENUE' is the modal value at only 3.9% frequency. The presence of 'DEAD END' (10 occurrences) as a top value is notable, indicating it is used as a literal street descriptor rather than a true street name, which may require cleaning. An 8.4% null rate suggests some incidents occurred at non-intersection locations (e.g., mid-block).

Treatment: Standardize 'DEAD END' and similar non-street tokens, impute or flag nulls, then encode as a categorical feature or use for geospatial joining.

anthropic:default · confidence high
Out[51]:

saturn.columns["intersection_street_2"].stats

statvalue
n1,000
nulls84 (8.4%)
unique499
top_value 7 AVENUE
top_rate 0.0393
cardinality 499
entropy 8.495
entropy_ratio 0.9478
alert: long_tail316 singleton categories
Fig 20.
Top values for intersection_street_2.
Show data table
Top values for intersection_street_2 (20 unique shown, of 499 total).
valuecountshare
7 AVENUE363.6%
BROADWAY191.9%
MINETTA LANE101.0%
DEAD END101.0%
109 AVENUE90.9%
EAST 171 STREET90.9%
WEST 114 STREET80.8%
HARMAN STREET80.8%
75 STREET80.8%
EDISON AVENUE70.7%
112 PLACE70.7%
BEND70.7%
AVENUE D60.6%
DITMAS AVENUE60.6%
EAST 174 STREET60.6%
10 AVENUE60.6%
3 AVENUE60.6%
1 AVENUE60.6%
EAST 170 STREET60.6%
BALTIC STREET60.6%

address_type categorical label

This column classifies the type of geographic address entry, with four categories: ADDRESS, INTERSECTION, BLOCKFACE, and PLACE. It is severely imbalanced — 'ADDRESS' dominates at 97.2% of valid records (970/1000), while the remaining three types collectively account for only 28 records. The entropy ratio of 0.108 confirms near-minimal informational diversity, meaning this field will contribute little discriminative power in most models without special handling.

Treatment: One-hot encode with caution; minority classes (INTERSECTION=19, BLOCKFACE=7, PLACE=2) may need oversampling or collapsing into an 'OTHER' bucket before modelling.

anthropic:default · confidence high
Out[54]:

saturn.columns["address_type"].stats

statvalue
n1,000
nulls2 (0.2%)
unique4
top_value ADDRESS
top_rate 0.9719
cardinality 4
entropy 0.2169
entropy_ratio 0.1084
alert: imbalancetop value is 97.2% of rows
Fig 21.
Top values for address_type.
Show data table
Top values for address_type (4 unique shown, of 4 total).
valuecountshare
ADDRESS97097.0%
INTERSECTION191.9%
BLOCKFACE70.7%
PLACE20.2%

city categorical feature

This column contains NYC neighborhood and borough city names, almost certainly a mailing-address city field from a dataset heavily concentrated in New York City. The top three values alone — BROOKLYN (250), NEW YORK (249), and BRONX (198) — account for roughly 70% of the 1,000 rows, while the remaining 33 values (e.g., WOODHAVEN, JAMAICA, RIDGEWOOD) are clearly Queens and Brooklyn sub-neighborhoods used as postal city names. The distribution is notably skewed (top_rate 0.255) but the entropy_ratio of 0.635 across 36 unique values suggests moderate spread beyond the top cluster; the 2.1% null rate is minor.

Treatment: One-hot encode or target-encode for modelling; consider grouping sub-neighbourhood postal cities (e.g., WOODHAVEN, JAMAICA) into borough-level categories to reduce sparsity.

anthropic:default · confidence high
Out[57]:

saturn.columns["city"].stats

statvalue
n1,000
nulls21 (2.1%)
unique36
top_value BROOKLYN
top_rate 0.2554
cardinality 36
entropy 3.282
entropy_ratio 0.6349
Fig 22.
Top values for city.
Show data table
Top values for city (20 unique shown, of 36 total).
valuecountshare
BROOKLYN25025.0%
NEW YORK24924.9%
BRONX19819.8%
WOODHAVEN353.5%
JAMAICA292.9%
RIDGEWOOD292.9%
CORONA202.0%
ASTORIA141.4%
ELMHURST141.4%
FOREST HILLS111.1%
STATEN ISLAND111.1%
SOUTH OZONE PARK111.1%
OZONE PARK90.9%
SOUTH RICHMOND HILL90.9%
REGO PARK90.9%
JACKSON HEIGHTS90.9%
RICHMOND HILL70.7%
COLLEGE POINT60.6%
QUEENS60.6%
WOODSIDE60.6%

landmark categorical label

This column contains street or landmark names, likely representing the nearest notable street or geographic reference point for each record in a New York City–area dataset. With 515 unique values across 1,000 rows (51.5% uniqueness) and a 10.5% null rate, coverage is incomplete. The distribution is heavily long-tailed: the top value 'WEST 13 STREET' appears only 31 times (3.46%), and the entropy ratio of 0.955 indicates near-maximum disorder, meaning most landmark names are rare or unique — making this column unsuitable as a reliable grouping key without significant consolidation.

Treatment: Impute or flag nulls (10.5%), then either group by street type/prefix for coarser features or embed as a high-cardinality categorical; avoid one-hot encoding given 515 levels.

anthropic:default · confidence high
Out[60]:

saturn.columns["landmark"].stats

statvalue
n1,000
nulls105 (10.5%)
unique515
top_value WEST 13 STREET
top_rate 0.03464
cardinality 515
entropy 8.603
entropy_ratio 0.955
alert: long_tail335 singleton categories
Fig 23.
Top values for landmark.
Show data table
Top values for landmark (20 unique shown, of 515 total).
valuecountshare
WEST 13 STREET313.1%
JAMAICA AVENUE111.1%
WASHINGTON AVENUE111.1%
LENOX AVENUE101.0%
MAC DOUGAL STREET101.0%
BRUCKNER BOULEVARD80.8%
BROADWAY80.8%
BROOKLYN AVENUE70.7%
NORTHERN BOULEVARD70.7%
76 STREET70.7%
COURT STREET60.6%
EAST 74 STREET60.6%
GRAND STREET50.5%
BUSHWICK AVENUE50.5%
EAST 3 STREET50.5%
SENECA AVENUE50.5%
111 AVENUE50.5%
AVENUE OF THE AMERICAS50.5%
MYRTLE AVENUE50.5%
90 STREET50.5%

status categorical label

This column is a workflow/lifecycle status field with exactly 3 states: Closed, In Progress, and Open. 'Closed' dominates at 61% (610/1000), while 'Open' is surprisingly rare at only 8.5% (85/1000), suggesting the dataset skews heavily toward resolved records — possibly a historical or archived snapshot rather than a live operational view. No nulls and perfect coverage across all 1000 rows.

Treatment: One-hot encode or ordinal-encode (Open→In Progress→Closed) depending on whether a natural progression is to be modelled; consider class imbalance if used as a target.

anthropic:default · confidence high
Out[63]:

saturn.columns["status"].stats

statvalue
n1,000
nulls0 (0.0%)
unique3
top_value Closed
top_rate 0.61
cardinality 3
entropy 1.26
entropy_ratio 0.7948
Fig 24.
Top values for status.
Show data table
Top values for status (3 unique shown, of 3 total).
valuecountshare
Closed61061.0%
In Progress30530.5%
Open858.5%

community_board categorical label

This column represents NYC Community Board designations, combining a numeric district ID with a borough name (e.g., '02 MANHATTAN'). With 65 unique values across 1,000 rows and zero nulls, coverage is complete. The distribution is notably flat — entropy ratio of 0.93 indicates near-uniform spread, with the most frequent value ('02 MANHATTAN') appearing only 5.6% of the time, suggesting no single board dominates the dataset. Manhattan and Queens boards appear disproportionately among the top 10, which may reflect a geographic sampling bias worth investigating.

Treatment: One-hot encode or target-encode for modelling; consider grouping by borough prefix to reduce cardinality from 65 to 5.

anthropic:default · confidence high
Out[66]:

saturn.columns["community_board"].stats

statvalue
n1,000
nulls0 (0.0%)
unique65
top_value 02 MANHATTAN
top_rate 0.056
cardinality 65
entropy 5.61
entropy_ratio 0.9316
Fig 25.
Top values for community_board.
Show data table
Top values for community_board (20 unique shown, of 65 total).
valuecountshare
02 MANHATTAN565.6%
09 QUEENS484.8%
03 MANHATTAN383.8%
05 QUEENS383.8%
12 QUEENS303.0%
03 BRONX292.9%
12 MANHATTAN292.9%
10 MANHATTAN282.8%
08 BRONX282.8%
09 MANHATTAN282.8%
17 BROOKLYN272.7%
10 QUEENS272.7%
03 QUEENS252.5%
01 BROOKLYN242.4%
06 QUEENS242.4%
11 BROOKLYN232.3%
04 BROOKLYN222.2%
09 BRONX212.1%
04 QUEENS202.0%
10 BRONX202.0%

council_district categorical label

This column represents a council district code — a zero-padded numeric string identifier (e.g., '03', '32') used to assign records to geographic administrative units. With 51 distinct values across 1,000 rows and an entropy ratio of 0.954, the distribution is remarkably flat and near-uniform, meaning no single district dominates heavily; the most frequent value '03' appears only 56 times (5.65% of rows). This near-maximum entropy is unusual for a district field and suggests either broad geographic coverage or deliberate sampling across all districts. Null rate is negligible at 0.9%.

Treatment: Use as a categorical grouping variable; one-hot or target-encode for modelling, or retain as-is for geographic aggregation and joins.

anthropic:default · confidence high
Out[69]:

saturn.columns["council_district"].stats

statvalue
n1,000
nulls9 (0.9%)
unique51
top_value 03
top_rate 0.05651
cardinality 51
entropy 5.412
entropy_ratio 0.9541
Fig 26.
Top values for council_district.
Show data table
Top values for council_district (20 unique shown, of 51 total).
valuecountshare
03565.6%
32484.8%
02393.9%
34383.8%
13363.6%
10363.6%
07333.3%
16323.2%
09323.2%
28303.0%
01282.8%
11262.6%
30252.5%
21252.5%
17242.4%
14242.4%
47242.4%
41232.3%
35222.2%
18222.2%

police_precinct categorical label

This column represents the police precinct assignment for each record, with 76 distinct precinct labels across 1,000 rows and zero nulls. The distribution is remarkably flat: the most common value, 'Precinct 6', appears only 50 times (5% of rows), and entropy ratio is 0.936 — nearly as uniform as a perfectly even distribution across all 76 precincts. No dominant precinct stands out, suggesting either a geographically broad dataset or deliberate sampling across jurisdictions.

Treatment: One-hot encode or target-encode for modelling; high cardinality (76 levels) warrants regularised encoding rather than naive dummies.

anthropic:default · confidence high
Out[72]:

saturn.columns["police_precinct"].stats

statvalue
n1,000
nulls0 (0.0%)
unique76
top_value Precinct 6
top_rate 0.05
cardinality 76
entropy 5.847
entropy_ratio 0.9358
Fig 27.
Top values for police_precinct.
Show data table
Top values for police_precinct (20 unique shown, of 76 total).
valuecountshare
Precinct 6505.0%
Precinct 102484.8%
Precinct 104383.8%
Precinct 42292.9%
Precinct 50282.8%
Precinct 67272.7%
Precinct 106272.7%
Precinct 30262.6%
Precinct 110242.4%
Precinct 112242.4%
Precinct 62232.3%
Precinct 115232.3%
Precinct 83222.2%
Precinct 43212.1%
Precinct 9202.0%
Precinct 103202.0%
Precinct 45202.0%
Precinct 49191.9%
Precinct 34191.9%
Precinct 32181.8%

bbl categorical foreign_key

This column contains New York City Borough-Block-Lot (BBL) codes, a standard 10-digit property identifier encoding borough (leading digit 1–5), block, and lot numbers. With 719 unique values across 1,000 rows and an entropy ratio of 0.97, it is near-unique, but the top value '1006080026' appears 31 times (3.3% of non-null rows), indicating repeated records tied to a single property — flagged as a long tail. The 5.5% null rate and clustering of repeats suggest this may be a foreign key referencing a property registry rather than a row-level unique identifier.

Treatment: Left-join on this BBL to enrich with property-level attributes from a NYC PLUTO or similar property reference table.

anthropic:default · confidence high
Out[75]:

saturn.columns["bbl"].stats

statvalue
n1,000
nulls55 (5.5%)
unique719
top_value 1006080026
top_rate 0.0328
cardinality 719
entropy 9.189
entropy_ratio 0.9683
alert: long_tail606 singleton categories
Fig 28.
Top values for bbl.
Show data table
Top values for bbl (20 unique shown, of 719 total).
valuecountshare
1006080026313.1%
3045950215131.3%
101823003380.8%
100542004880.8%
202902003680.8%
205419012270.7%
401706750170.7%
100504001150.5%
300396000450.5%
408838006550.5%
301740000150.5%
101618000140.4%
102217004740.4%
410146005140.4%
102170011240.4%
403427003040.4%
403430000130.3%
204323001430.3%
203943750130.3%
202409009630.3%

borough categorical label

This column represents the five New York City boroughs, functioning as a geographic label with complete coverage (null_rate 0.0) across all 1,000 rows. Four boroughs — Queens (274), Manhattan (258), Brooklyn (254), and Bronx (203) — are distributed with reasonable balance, but Staten Island is strikingly underrepresented at just 11 occurrences (~1.1%), compared to 20% expected under uniform distribution. The high entropy_ratio of 0.886 reflects the near-even spread among the four dominant boroughs, masking Staten Island's severe underrepresentation.

Treatment: One-hot encode or target-encode for modelling; note Staten Island's class imbalance (n=11) may require stratified sampling or grouping.

anthropic:default · confidence high
Out[78]:

saturn.columns["borough"].stats

statvalue
n1,000
nulls0 (0.0%)
unique5
top_value QUEENS
top_rate 0.274
cardinality 5
entropy 2.057
entropy_ratio 0.8858
Fig 29.
Top values for borough.
Show data table
Top values for borough (5 unique shown, of 5 total).
valuecountshare
QUEENS27427.4%
MANHATTAN25825.8%
BROOKLYN25425.4%
BRONX20320.3%
STATEN ISLAND111.1%

x_coordinate_state_plane categorical feature

This column contains X-coordinates in a State Plane coordinate system, stored as categorical strings rather than numerics — values like '984721' and '1004501' are typical State Plane Easting values in feet. With 763 unique values out of 1000 rows (entropy ratio 0.97) and a long-tail alert, the distribution is nearly unique per record, which is expected for spatial point coordinates. The top value '984721' appearing 31 times (3.1% of rows) is surprisingly frequent for a coordinate and may indicate a default, imputed, or snapped location worth investigating.

Treatment: Cast to numeric, pair with Y-coordinate for spatial analysis, and investigate the 31 rows sharing coordinate '984721' for potential data quality issues.

anthropic:default · confidence high
Out[81]:

saturn.columns["x_coordinate_state_plane"].stats

statvalue
n1,000
nulls7 (0.7%)
unique763
top_value 984721
top_rate 0.03122
cardinality 763
entropy 9.292
entropy_ratio 0.9704
alert: long_tail643 singleton categories
Fig 30.
Top values for x_coordinate_state_plane.
Show data table
Top values for x_coordinate_state_plane (20 unique shown, of 763 total).
valuecountshare
984721313.1%
1004501131.3%
99787080.8%
98403280.8%
101088580.8%
103196970.7%
98323850.5%
98587750.5%
102082550.5%
99907750.5%
99870340.4%
102382940.4%
100522440.4%
104146340.4%
100828540.4%
100832330.3%
99597130.3%
102217730.3%
100799230.3%
100127630.3%

y_coordinate_state_plane categorical feature

This column represents Y-coordinates in a State Plane coordinate system, likely a geographic reference for spatial data (e.g., NYC or similar municipal dataset). Despite being numeric in nature, it is stored as a categorical type, which is unexpected and likely a data pipeline issue. With 768 unique values out of 1000 rows (entropy ratio 0.97) and a long-tail alert, the distribution is highly dispersed, though the top value '207809' appears 31 times — a modest but notable cluster suggesting a frequently referenced location. The near-unique cardinality makes this unsuitable for direct use as a categorical feature.

Treatment: Cast to numeric, then use as a spatial coordinate feature or pair with x-coordinate for geospatial analysis.

anthropic:default · confidence high
Out[84]:

saturn.columns["y_coordinate_state_plane"].stats

statvalue
n1,000
nulls7 (0.7%)
unique768
top_value 207809
top_rate 0.03122
cardinality 768
entropy 9.304
entropy_ratio 0.9707
alert: long_tail651 singleton categories
Fig 31.
Top values for y_coordinate_state_plane.
Show data table
Top values for y_coordinate_state_plane (20 unique shown, of 768 total).
valuecountshare
207809313.1%
180649131.3%
23092680.8%
20511180.8%
24421280.8%
24290070.7%
20392950.5%
18920550.5%
19190150.5%
19311050.5%
23031140.4%
21551140.4%
25326740.4%
19249740.4%
19707740.4%
19652630.3%
25086230.3%
24006130.3%
21197830.3%
20764930.3%

open_data_channel_type categorical feature

This column captures the channel through which a report or request was submitted, with four distinct values: ONLINE, MOBILE, PHONE, and UNKNOWN. ONLINE dominates at 46.6% of records, followed by MOBILE (28.8%) and PHONE (23.6%), leaving only 10 records (1%) tagged as UNKNOWN. The near-uniform distribution across the three known channels is notable, and the UNKNOWN category — while small — may warrant imputation or flagging depending on downstream use.

Treatment: One-hot encode or ordinal-map the 3 known channels; consider grouping or flagging the 10 UNKNOWN values before modelling.

anthropic:default · confidence high
Out[87]:

saturn.columns["open_data_channel_type"].stats

statvalue
n1,000
nulls0 (0.0%)
unique4
top_value ONLINE
top_rate 0.466
cardinality 4
entropy 1.589
entropy_ratio 0.7943
Fig 32.
Top values for open_data_channel_type.
Show data table
Top values for open_data_channel_type (4 unique shown, of 4 total).
valuecountshare
ONLINE46646.6%
MOBILE28828.8%
PHONE23623.6%
UNKNOWN101.0%

park_facility_name categorical label

This column captures the named park facility associated with each record, but it is almost entirely uninformative: 999 of 1000 rows (99.9%) carry the placeholder value 'Unspecified', with only a single record attributed to Flushing Meadows Corona Park. The near-zero entropy (0.011) confirms the column is maximally imbalanced and conveys virtually no discriminative signal. This is likely a poorly populated administrative field rather than a reliable feature.

Treatment: Drop from modelling; if facility-level analysis is ever needed, this field requires back-filling from a source system before use.

anthropic:default · confidence high
Out[90]:

saturn.columns["park_facility_name"].stats

statvalue
n1,000
nulls0 (0.0%)
unique2
top_value Unspecified
top_rate 0.999
cardinality 2
entropy 0.01141
entropy_ratio 0.01141
alert: imbalancetop value is 99.9% of rows
Fig 33.
Top values for park_facility_name.
Show data table
Top values for park_facility_name (2 unique shown, of 2 total).
valuecountshare
Unspecified99999.9%
Flushing Meadows Corona Park10.1%

park_borough categorical label

This column encodes the five NYC borough names associated with park locations, making it a low-cardinality geographic label with zero nulls across 1,000 rows. Four boroughs (Queens, Manhattan, Brooklyn, Bronx) are nearly evenly distributed (203–274 records each), but Staten Island is severely underrepresented at just 11 occurrences (1.1%), which would surprise an analyst expecting proportional borough coverage. Entropy ratio of 0.886 reflects the near-uniform spread across four classes, masking the sharp imbalance on the fifth.

Treatment: One-hot encode for modelling; note the severe class imbalance for STATEN ISLAND (11 of 1000) and consider stratified sampling or weighting.

anthropic:default · confidence high
Out[93]:

saturn.columns["park_borough"].stats

statvalue
n1,000
nulls0 (0.0%)
unique5
top_value QUEENS
top_rate 0.274
cardinality 5
entropy 2.057
entropy_ratio 0.8858
Fig 34.
Top values for park_borough.
Show data table
Top values for park_borough (5 unique shown, of 5 total).
valuecountshare
QUEENS27427.4%
MANHATTAN25825.8%
BROOKLYN25425.4%
BRONX20320.3%
STATEN ISLAND111.1%

latitude categorical feature

This column contains geographic latitude coordinates stored as strings, with all top values clustering tightly around 40.6–40.8°N — consistent with New York City's latitude range. Despite being numeric in nature, it was ingested as categorical, yielding 770 unique values across 1,000 rows (entropy ratio 0.97), which is near-unique. The long-tail alert and the top value ('40.73706433046593') appearing 31 times (3.1% of rows) suggests either a default/fallback coordinate or a high-traffic location being logged repeatedly.

Treatment: Cast to float64, pair with a longitude column for geospatial features, and investigate the 31-row duplicate coordinate for data quality issues before modelling.

anthropic:default · confidence high
Out[96]:

saturn.columns["latitude"].stats

statvalue
n1,000
nulls7 (0.7%)
unique770
top_value 40.73706433046593
top_rate 0.03122
cardinality 770
entropy 9.308
entropy_ratio 0.9707
alert: long_tail655 singleton categories
Fig 35.
Top values for latitude.
Show data table
Top values for latitude (20 unique shown, of 770 total).
valuecountshare
40.73706433046593313.1%
40.662493333971206131.3%
40.80050400034680580.8%
40.7296589937187580.8%
40.8369406629241780.8%
40.8332508510871170.7%
40.72641463677291550.5%
40.6860006389615650.5%
40.69332511094426550.5%
40.69670669192838450.5%
40.7988146702151340.4%
40.7581158095972340.4%
40.86180921113531640.4%
40.69485163390080440.4%
40.7075749538037440.4%
40.706062486329930.3%
40.8551516595575330.3%
40.8255556164952930.3%
40.7484908168886930.3%
40.7365293563731730.3%

longitude categorical feature

This column contains geographic longitude values, stored as strings (hence the categorical classification), representing locations clustered tightly around -73.8 to -74.0 — consistent with New York City. Despite 1,000 rows, there are 770 unique values, yet the top value '-73.99830041620608' appears 31 times (3.1% of rows), which is surprisingly high given the near-continuous nature of coordinate data and flags a long-tail concentration. Entropy ratio of 0.97 confirms very high diversity overall, but the repeated exact coordinate values suggest either data binning, snapping to a fixed point, or duplicated records at specific locations.

Treatment: Parse to float, verify duplicate coordinates for data quality issues, then use directly as a numeric geospatial feature or pair with latitude for distance/clustering models.

anthropic:default · confidence high
Out[99]:

saturn.columns["longitude"].stats

statvalue
n1,000
nulls7 (0.7%)
unique770
top_value -73.99830041620608
top_rate 0.03122
cardinality 770
entropy 9.308
entropy_ratio 0.9707
alert: long_tail655 singleton categories
Fig 36.
Top values for longitude.
Show data table
Top values for longitude (20 unique shown, of 770 total).
valuecountshare
-73.99830041620608313.1%
-73.9270067970956131.3%
-73.9508059587071680.8%
-74.0007865564607880.8%
-73.9037444129810380.8%
-73.8275589387227770.7%
-74.0036511760836850.5%
-73.99413353445450.5%
-73.8681071731774950.5%
-73.9465297740722750.5%
-73.9477985726832840.4%
-73.8571356338648140.4%
-73.9241742271880940.4%
-73.7936798032137840.4%
-73.9133090617082640.4%
-73.9131739709097130.3%
-73.8628989683991530.3%
-73.9142140401405630.3%
-73.9385518485121830.3%
-73.8514372906424430.3%

location unknown other

This column is named 'location' and contains 1,000 non-null values with a null rate of 0.0, but the profiler skipped it entirely, yielding no stats, no uniqueness count, and no type inference. Without distribution, cardinality, or sample values, it is impossible to determine whether this is a structured geographic field (e.g., city, coordinates, country code) or free-text. The 'skipped' alert is the dominant signal and warrants direct inspection of raw values before any downstream use.

Treatment: Manually inspect raw values to determine structure (free-text, categorical, coordinate, etc.) before deciding on encoding or embedding strategy.

anthropic:default · confidence low
Out[102]:

saturn.columns["location"].stats

statvalue
n1,000
nulls0 (0.0%)
unique
alert: skippedno profiler for kind=unknown

:@computed_region_f5dn_yrer categorical foreign_key

This column is a Socrata-generated computed region identifier, assigning each row to one of 62 geographic zones (e.g., neighborhood, district, or census tract polygons). With an entropy ratio of 0.939 and 62 unique integer-like codes across 1,000 rows, values are distributed fairly evenly — the most frequent region ('57') accounts for only 5.6% of rows, suggesting no strong spatial concentration. The null rate is negligible at 0.7%. The numeric-looking codes are categorical labels, not ordinal or continuous values.

Treatment: Treat as a categorical geographic key; left-join to a region lookup table or one-hot encode for spatial feature engineering.

anthropic:default · confidence high
Out[104]:

saturn.columns[":@computed_region_f5dn_yrer"].stats

statvalue
n1,000
nulls7 (0.7%)
unique62
top_value 57
top_rate 0.05639
cardinality 62
entropy 5.591
entropy_ratio 0.9389
Fig 37.
Top values for :@computed_region_f5dn_yrer.
Show data table
Top values for :@computed_region_f5dn_yrer (20 unique shown, of 62 total).
valuecountshare
57565.6%
46484.8%
70383.8%
54373.7%
41303.0%
34292.9%
47292.9%
18282.8%
48282.8%
37282.8%
61272.7%
62272.7%
65252.5%
36242.4%
1232.3%
42222.2%
58212.1%
40212.1%
66202.0%
43202.0%

:@computed_region_yeji_bk3q categorical foreign_key

This column is a Socrata-generated computed region identifier (geo-zone lookup key), indicated by the ':@computed_region_' prefix — it maps each row to one of 5 predefined geographic regions. Values are nearly uniformly distributed across zones 2–4 (~254–269 rows each), but zone '1' is a stark outlier with only 11 occurrences (~1.1% of rows), which may signal a very small or edge-case geographic area. Null rate is negligible at 0.7%.

Treatment: Use as a categorical grouping key or left-join to a region lookup table; investigate zone '1' underrepresentation before using as a stratification variable.

anthropic:default · confidence high
Out[107]:

saturn.columns[":@computed_region_yeji_bk3q"].stats

statvalue
n1,000
nulls7 (0.7%)
unique5
top_value 3
top_rate 0.2709
cardinality 5
entropy 2.054
entropy_ratio 0.8846
Fig 38.
Top values for :@computed_region_yeji_bk3q.
Show data table
Top values for :@computed_region_yeji_bk3q (5 unique shown, of 5 total).
valuecountshare
326926.9%
426626.6%
225425.4%
519319.3%
1111.1%

:@computed_region_sbqj_enih categorical foreign_key

This column is a Socrata computed region identifier, automatically generated by the platform to assign rows to pre-defined geographic boundary zones (e.g., neighbourhoods, council districts, or census tracts). With 75 distinct integer-like codes across 1,000 rows and an entropy ratio of 0.94, the distribution is remarkably flat — no single zone dominates, with even the top value '3' appearing in only 5% of rows. The near-uniform spread across 75 regions and very low null rate (0.7%) suggest broad geographic coverage with no strong spatial concentration.

Treatment: Left-join on this region code to a geographic boundaries table to enrich with spatial attributes; do not treat as a numeric feature.

anthropic:default · confidence high
Out[110]:

saturn.columns[":@computed_region_sbqj_enih"].stats

statvalue
n1,000
nulls7 (0.7%)
unique75
top_value 3
top_rate 0.05035
cardinality 75
entropy 5.846
entropy_ratio 0.9385
Fig 39.
Top values for :@computed_region_sbqj_enih.
Show data table
Top values for :@computed_region_sbqj_enih (20 unique shown, of 75 total).
valuecountshare
3505.0%
60484.8%
62373.7%
25292.9%
33282.8%
40272.7%
64272.7%
19262.6%
68232.3%
37232.3%
73232.3%
53222.2%
26212.1%
70212.1%
61202.0%
28202.0%
32191.9%
5191.9%
22191.9%
20181.8%

:@computed_region_92fq_4b7q categorical foreign_key

This column is a Socrata-generated computed region identifier, typically encoding a geographic zone or district (e.g., census tract, neighbourhood, or administrative boundary) as an opaque integer-like label. With 51 unique values across 1,000 rows and an entropy ratio of 0.948, the distribution is near-uniform — no single region dominates heavily, though region '10' leads with 6.4% of records (64 occurrences). The null rate of 0.7% is negligible, suggesting reliable spatial assignment.

Treatment: Left-join on this computed region ID to a Socrata boundary dataset to retrieve human-readable geographic names; do not treat the numeric strings as ordinal or cardinal values.

anthropic:default · confidence high
Out[113]:

saturn.columns[":@computed_region_92fq_4b7q"].stats

statvalue
n1,000
nulls7 (0.7%)
unique51
top_value 10
top_rate 0.06445
cardinality 51
entropy 5.376
entropy_ratio 0.9477
Fig 40.
Top values for :@computed_region_92fq_4b7q.
Show data table
Top values for :@computed_region_92fq_4b7q (20 unique shown, of 51 total).
valuecountshare
10646.4%
34545.4%
30404.0%
36363.6%
32363.6%
12353.5%
39353.5%
46343.4%
23333.3%
42282.8%
50272.7%
21272.7%
43272.7%
40252.5%
28252.5%
48242.4%
45232.3%
29222.2%
17222.2%
35212.1%

descriptor_2 categorical label

This column is a secondary complaint descriptor, likely a sub-category or detail field attached to a service request or complaint record (consistent with NYC 311-style data). It is almost entirely empty — null_rate is 0.882, meaning only 118 of 1,000 rows carry a value. Among the 43 unique non-null values, 'NO HEAT' dominates at 27.97% of non-null entries (33 occurrences), but the spread across housing, noise, sanitation, and transportation categories (e.g., 'Cannabis Smoking or Vaping', 'Unsafe Driving - Non-Passenger') signals this field is populated inconsistently across complaint types, not a uniform taxonomy. The high entropy_ratio of 0.807 confirms the long-tail alert: values are broadly dispersed despite the sparse fill rate.

Treatment: Filter to non-null rows before use; group rare categories (below a frequency threshold) into 'OTHER' and one-hot encode or target-encode the remainder.

anthropic:default · confidence high
Out[116]:

saturn.columns["descriptor_2"].stats

statvalue
n1,000
nulls882 (88.2%)
unique43
top_value NO HEAT
top_rate 0.2797
cardinality 43
entropy 4.376
entropy_ratio 0.8065
alert: long_tail27 singleton categories
alert: null_rate88.2% null
Fig 41.
Top values for descriptor_2.
Show data table
Top values for descriptor_2 (20 unique shown, of 43 total).
valuecountshare
NO HEAT333.3%
NO HEAT AND NO HOT WATER101.0%
N/A90.9%
NO HOT WATER70.7%
Cannabis Smoking or Vaping50.5%
ROACHES40.4%
Unsafe Driving - Non-Passenger30.3%
Dog30.3%
OTHER30.3%
Not Cleaned by Property Owner20.2%
Parked In Front Of Fire Hydrant20.2%
Operating Improperly20.2%
AT WALL OR CEILING20.2%
FLIES20.2%
BROKEN OR MISSING20.2%
MISSING OR INADEQUATE CANS/LID20.2%
Loose or Improperly Stored Garbage or Food10.1%
Droppings10.1%
Fare/Tip Complaint10.1%
Waste10.1%

resolution_description categorical label

This column contains standardized resolution outcome descriptions from NYC 311 service requests, drawn from a fixed vocabulary of only 16 distinct boilerplate phrases. Despite being a text column, it behaves as a low-cardinality categorical: the top value (NYPD 'no criminal violation, condition corrected') accounts for 35.4% of non-null rows. A 30.7% null rate is flagged as an alert, likely reflecting complaints that have not yet been resolved or closed.

Treatment: Encode as ordinal or one-hot categorical (16 levels); treat nulls as a distinct 'unresolved' category rather than imputing.

anthropic:default · confidence high
Out[119]:

saturn.columns["resolution_description"].stats

statvalue
n1,000
nulls307 (30.7%)
unique16
top_value 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.
top_rate 0.3535
cardinality 16
entropy 2.777
entropy_ratio 0.6943
alert: null_rate30.7% null
Fig 42.
Top values for resolution_description.
Show data table
Top values for resolution_description (16 unique shown, of 16 total).
valuecountshare
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.24524.5%
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.16116.1%
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.686.8%
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.505.0%
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.444.4%
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.404.0%
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.313.1%
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 a292.9%
The Department of Transportation referred this complaint to the appropriate Maintenance Unit for repair.60.6%
Your complaint has been received but does not fall under the jurisdiction of the New York City Police Department. Please contact your local precinct for more information, including which City agency your request was referred to. 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.50.5%
The Police Department reviewed your complaint and provided additional information below.40.4%
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.30.3%
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.30.3%
The New York City Police Department responded to the complaint and observed an encampment at the noted location. The complaint has been referred to the Department of Homeless Services (DHS) for further action. DHS will inspect the condition and update your service request with more information. 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.20.2%
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.10.1%
The New York City Police Department responded to the complaint and their investigation determined another specific tow is required. Please contact the local precinct for more information. 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.10.1%

resolution_action_updated_date categorical timestamp

This column is a timestamp recording when a resolution action was last updated, stored as a categorical string in ISO 8601 format. The 30.6% null rate is a significant concern, indicating roughly one-third of records have no update date logged. Strikingly, one value — '2026-01-17T00:00:00.000' — accounts for 10.7% of all non-null records (74 occurrences) with a midnight-exactly timestamp, suggesting a bulk update or default-date assignment rather than genuine event timestamps. All remaining top values appear only twice, confirming a severe long-tail distribution (entropy ratio 0.94) consistent with mostly unique timestamps.

Treatment: Parse to datetime, flag the 74 midnight '2026-01-17' records as probable synthetic/default dates, and impute or exclude nulls (30.6%) before any time-based feature engineering.

anthropic:default · confidence high
Out[122]:

saturn.columns["resolution_action_updated_date"].stats

statvalue
n1,000
nulls306 (30.6%)
unique585
top_value 2026-01-17T00:00:00.000
top_rate 0.1066
cardinality 585
entropy 8.673
entropy_ratio 0.9435
alert: long_tail548 singleton categories
alert: null_rate30.6% null
Fig 43.
Top values for resolution_action_updated_date.
Show data table
Top values for resolution_action_updated_date (20 unique shown, of 585 total).
valuecountshare
2026-01-17T00:00:00.000747.4%
2026-01-18T02:03:44.00020.2%
2026-01-18T02:04:03.00020.2%
2026-01-18T02:01:54.00020.2%
2026-01-18T01:35:08.00020.2%
2026-01-18T01:41:49.00020.2%
2026-01-18T01:26:35.00020.2%
2026-01-18T01:32:28.00020.2%
2026-01-18T01:25:53.00020.2%
2026-01-18T01:54:39.00020.2%
2026-01-18T01:19:59.00020.2%
2026-01-18T01:09:47.00020.2%
2026-01-18T01:00:57.00020.2%
2026-01-18T01:04:36.00020.2%
2026-01-18T00:58:56.00020.2%
2026-01-18T01:07:50.00020.2%
2026-01-18T01:27:34.00020.2%
2026-01-18T00:46:07.00020.2%
2026-01-18T00:55:02.00020.2%
2026-01-18T00:40:32.00020.2%

closed_date categorical timestamp

This column is a ticket or record closure timestamp, stored as a string rather than a parsed datetime type, with second-level precision. Two signals demand attention: 39% of rows are null, indicating a large share of records that have not yet been closed (open items); and with 585 unique values across 1,000 rows and an entropy ratio of 0.998, timestamps are nearly all distinct, which is expected for event times but confirms the column carries no categorical signal. All top values cluster on 2026-01-18, suggesting the snapshot or batch was captured on that single date.

Treatment: Parse to datetime, use nulls as an 'is_open' binary flag, and engineer elapsed-time features (e.g. days-to-close) rather than using raw values.

anthropic:default · confidence high
Out[125]:

saturn.columns["closed_date"].stats

statvalue
n1,000
nulls390 (39.0%)
unique585
top_value 2026-01-18T00:41:26.000
top_rate 0.004918
cardinality 585
entropy 9.169
entropy_ratio 0.9975
alert: long_tail561 singleton categories
alert: null_rate39.0% null
Fig 44.
Top values for closed_date.
Show data table
Top values for closed_date (20 unique shown, of 585 total).
valuecountshare
2026-01-18T00:41:26.00030.3%
2026-01-18T02:02:35.00020.2%
2026-01-18T02:03:41.00020.2%
2026-01-18T01:41:47.00020.2%
2026-01-18T01:26:28.00020.2%
2026-01-18T01:45:29.00020.2%
2026-01-18T01:54:33.00020.2%
2026-01-18T01:07:46.00020.2%
2026-01-18T01:27:29.00020.2%
2026-01-18T00:46:04.00020.2%
2026-01-18T00:40:28.00020.2%
2026-01-18T00:55:27.00020.2%
2026-01-18T00:41:08.00020.2%
2026-01-18T00:20:14.00020.2%
2026-01-18T00:37:27.00020.2%
2026-01-18T00:22:36.00020.2%
2026-01-18T00:36:52.00020.2%
2026-01-18T00:17:49.00020.2%
2026-01-18T00:28:52.00020.2%
2026-01-18T00:20:55.00020.2%

taxi_pick_up_location categorical

Out[128]:

saturn.columns["taxi_pick_up_location"].stats

statvalue
n1,000
nulls994 (99.4%)
unique6
top_value 55 LITTLE WEST 12 STREET, MANHATTAN (NEW YORK), NY, 10014
top_rate 0.1667
cardinality 6
entropy 2.585
entropy_ratio 1
alert: long_tail6 singleton categories
alert: null_rate99.4% null
Fig 45.
Top values for taxi_pick_up_location.
Show data table
Top values for taxi_pick_up_location (6 unique shown, of 6 total).
valuecountshare
55 LITTLE WEST 12 STREET, MANHATTAN (NEW YORK), NY, 1001410.1%
JOHN F KENNEDY AIRPORT, QUEENS (JAMAICA) ,NY, 1143010.1%
11 WATER STREET, BROOKLYN, NY, 1120110.1%
9 AVENUE AND WEST 43 STREET, MANHATTAN, NY, 1003610.1%
30 AVENUE AND 33 STREET, QUEENS, NY, 1110210.1%
30-08 33 STREET, QUEENS (ASTORIA), NY, 1110210.1%

vehicle_type categorical

Out[131]:

saturn.columns["vehicle_type"].stats

statvalue
n1,000
nulls965 (96.5%)
unique4
top_value Car
top_rate 0.7714
cardinality 4
entropy 1.097
entropy_ratio 0.5484
alert: null_rate96.5% null
Fig 46.
Top values for vehicle_type.
Show data table
Top values for vehicle_type (4 unique shown, of 4 total).
valuecountshare
Car272.7%
Other40.4%
SUV30.3%
Van10.1%

facility_type categorical

Out[134]:

saturn.columns["facility_type"].stats

statvalue
n1,000
nulls990 (99.0%)
unique1
top_value N/A
top_rate 1
cardinality 1
entropy 0
entropy_ratio 0
alert: null_rate99.0% null
alert: imbalancetop value is 100.0% of rows
Fig 47.
Top values for facility_type.
Show data table
Top values for facility_type (1 unique shown, of 1 total).
valuecountshare
N/A101.0%

taxi_company_borough categorical

Out[137]:

saturn.columns["taxi_company_borough"].stats

statvalue
n1,000
nulls999 (99.9%)
unique1
top_value BROOKLYN
top_rate 1
cardinality 1
entropy 0
entropy_ratio 0
alert: long_tail1 singleton categories
alert: null_rate99.9% null
alert: imbalancetop value is 100.0% of rows
Fig 48.
Top values for taxi_company_borough.
Show data table
Top values for taxi_company_borough (1 unique shown, of 1 total).
valuecountshare
BROOKLYN10.1%

bridge_highway_name categorical

Out[140]:

saturn.columns["bridge_highway_name"].stats

statvalue
n1,000
nulls997 (99.7%)
unique2
top_value E
top_rate 0.6667
cardinality 2
entropy 0.9183
entropy_ratio 0.9183
alert: null_rate99.7% null
Fig 49.
Top values for bridge_highway_name.
Show data table
Top values for bridge_highway_name (2 unique shown, of 2 total).
valuecountshare
E20.2%
Kosciuszko Br - BQE10.1%

bridge_highway_direction categorical

Out[143]:

saturn.columns["bridge_highway_direction"].stats

statvalue
n1,000
nulls997 (99.7%)
unique2
top_value C E Local Downtown & Brooklyn
top_rate 0.6667
cardinality 2
entropy 0.9183
entropy_ratio 0.9183
alert: null_rate99.7% null
Fig 50.
Top values for bridge_highway_direction.
Show data table
Top values for bridge_highway_direction (2 unique shown, of 2 total).
valuecountshare
C E Local Downtown & Brooklyn20.2%
Queens Bound10.1%

road_ramp categorical

Out[146]:

saturn.columns["road_ramp"].stats

statvalue
n1,000
nulls999 (99.9%)
unique1
top_value Ramp
top_rate 1
cardinality 1
entropy 0
entropy_ratio 0
alert: long_tail1 singleton categories
alert: null_rate99.9% null
alert: imbalancetop value is 100.0% of rows
Fig 51.
Top values for road_ramp.
Show data table
Top values for road_ramp (1 unique shown, of 1 total).
valuecountshare
Ramp10.1%

bridge_highway_segment categorical

Out[149]:

saturn.columns["bridge_highway_segment"].stats

statvalue
n1,000
nulls997 (99.7%)
unique2
top_value Platform
top_rate 0.6667
cardinality 2
entropy 0.9183
entropy_ratio 0.9183
alert: null_rate99.7% null
Fig 52.
Top values for bridge_highway_segment.
Show data table
Top values for bridge_highway_segment (2 unique shown, of 2 total).
valuecountshare
Platform20.2%
Ramp10.1%

How to cite

click to copy

BibTeX
@misc{saturn-data-trove-nyc-311-service-requests-2026,
  author       = {Steuber, Luke},
  title        = {Saturn reading: data trove nyc 311 service requests},
  year         ={2026},
  howpublished = {\url{https://dr.eamer.dev/saturn/view/data-trove-nyc-311-service-requests}},
  note         = {Profiled with saturn-dissect v0.2.0, prompt saturn-insight-v2, model anthropic:default},
}
APA
Steuber, L. (2026). Saturn reading: data trove nyc 311 service requests. Source: /home/coolhand/html/datavis/data_trove/cache/wild/nyc_311_sample.json. Profiled with saturn-dissect v0.2.0 (saturn-insight-v2, anthropic:default). Retrieved from https://dr.eamer.dev/saturn/view/data-trove-nyc-311-service-requests