{"release_id":"identity-graph-v1-6e76588616c0","data":{"rows":[{"map_id":"dataset:nypd_members","granularity":"dataset","dataset":"nypd_members","record_id":"","official_source":"https://nypdonline.org/","record_grain":"current active officer profile","coverage_dates":"1984-2026","native_identifiers":"PROFILE_ID","officer_fields":"PROFILE_ID","identity_layer_required":"true","join_method":"direct PROFILE_ID joins within NYPD Officer Profile tables","coverage":"33591 rows; 33591 distinct PROFILE_IDs","joinability_class":"already_usable","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"low"},{"map_id":"dataset:nypd_title_history","granularity":"dataset","dataset":"nypd_title_history","record_id":"","official_source":"https://nypdonline.org/","record_grain":"historical officer title/shield state","coverage_dates":"1984-2026","native_identifiers":"PROFILE_ID","officer_fields":"PROFILE_ID","identity_layer_required":"true","join_method":"PROFILE_ID plus effective-date interval reconstruction","coverage":"53438 rows; 33560 distinct PROFILE_IDs","joinability_class":"already_usable","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"low"},{"map_id":"dataset:nypd_discipline_summary","granularity":"dataset","dataset":"nypd_discipline_summary","record_id":"","official_source":"https://nypdonline.org/","record_grain":"officer disciplinary summary by date","coverage_dates":"2010-2026","native_identifiers":"PROFILE_ID","officer_fields":"PROFILE_ID","identity_layer_required":"true","join_method":"direct PROFILE_ID join to current roster and title history","coverage":"1512 rows; 1360 distinct PROFILE_IDs","joinability_class":"already_usable","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"low"},{"map_id":"dataset:nypd_discipline_charges","granularity":"dataset","dataset":"nypd_discipline_charges","record_id":"","official_source":"https://nypdonline.org/","record_grain":"individual NYPD disciplinary charge","coverage_dates":"2010-2026","native_identifiers":"CASE_NUMBER","officer_fields":"PROFILE_ID","identity_layer_required":"true","join_method":"PROFILE_ID and CASE_NUMBER; case-to-charge rows are directly linkable inside NYPD","coverage":"3849 rows; 1360 distinct PROFILE_IDs","joinability_class":"already_usable","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"low"},{"map_id":"dataset:nypd_training","granularity":"dataset","dataset":"nypd_training","record_id":"","official_source":"https://data.cityofnewyork.us/api/views/n3mp-t5uj","record_grain":"officer training record","coverage_dates":"current source snapshot","native_identifiers":"PROFILE_ID","officer_fields":"PROFILE_ID","identity_layer_required":"true","join_method":"direct PROFILE_ID join to NYPD members and title history","coverage":"official row-level source; not ingested locally","joinability_class":"already_usable","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"low"},{"map_id":"dataset:nypd_recognition","granularity":"dataset","dataset":"nypd_recognition","record_id":"","official_source":"https://data.cityofnewyork.us/api/views/i9n8-a8ed","record_grain":"officer department recognition record","coverage_dates":"current source snapshot","native_identifiers":"PROFILE_ID","officer_fields":"PROFILE_ID","identity_layer_required":"true","join_method":"direct PROFILE_ID join to NYPD members and title history","coverage":"official row-level source; not ingested locally","joinability_class":"already_usable","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"low"},{"map_id":"dataset:ccrb_officers","granularity":"dataset","dataset":"ccrb_officers","record_id":"","official_source":"https://nypdonline.org/","record_grain":"current/last-reported CCRB officer profile","coverage_dates":"current snapshot","native_identifiers":"Tax ID","officer_fields":"Tax ID","identity_layer_required":"true","join_method":"direct within CCRB; cross-system candidate through exact name+shield evidence and Tax ID","coverage":"97553 rows; 0 distinct PROFILE_IDs (PROFILE_ID field absent; count is not used as officer key)","joinability_class":"newly_usable_through_identity_layer","evidence_class":"corroborated_inference","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"dataset:ccrb_allegations","granularity":"dataset","dataset":"ccrb_allegations","record_id":"","official_source":"https://nypdonline.org/","record_grain":"allegation record within a CCRB complaint","coverage_dates":"current snapshot; incidents span historical years","native_identifiers":"Complaint Id + Allegation Record Identity","officer_fields":"Tax ID when populated; Complaint Officer Number is not assumed to be NYPD shield","identity_layer_required":"true","join_method":"Complaint Id joins to CCRB complaints and penalties; Tax ID joins to CCRB officers when present","coverage":"430556 rows","joinability_class":"newly_usable_through_identity_layer","evidence_class":"corroborated_inference","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:1251386:2","granularity":"record","dataset":"ccrb_allegations","record_id":"1251386","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"1251386","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:1272841:5","granularity":"record","dataset":"ccrb_allegations","record_id":"1272841","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"1272841","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:1058556:6","granularity":"record","dataset":"ccrb_allegations","record_id":"1058556","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"1058556","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:556456:7","granularity":"record","dataset":"ccrb_allegations","record_id":"556456","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"556456","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:917148:8","granularity":"record","dataset":"ccrb_allegations","record_id":"917148","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"917148","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:595528:11","granularity":"record","dataset":"ccrb_allegations","record_id":"595528","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"595528","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:1224861:12","granularity":"record","dataset":"ccrb_allegations","record_id":"1224861","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"1224861","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:1263090:13","granularity":"record","dataset":"ccrb_allegations","record_id":"1263090","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"1263090","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:958103:15","granularity":"record","dataset":"ccrb_allegations","record_id":"958103","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"958103","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:815170:17","granularity":"record","dataset":"ccrb_allegations","record_id":"815170","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"815170","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:913221:18","granularity":"record","dataset":"ccrb_allegations","record_id":"913221","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"913221","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:1237163:20","granularity":"record","dataset":"ccrb_allegations","record_id":"1237163","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"1237163","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:809970:22","granularity":"record","dataset":"ccrb_allegations","record_id":"809970","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"809970","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:721790:23","granularity":"record","dataset":"ccrb_allegations","record_id":"721790","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"721790","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:773395:26","granularity":"record","dataset":"ccrb_allegations","record_id":"773395","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"773395","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:652215:28","granularity":"record","dataset":"ccrb_allegations","record_id":"652215","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"652215","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"},{"map_id":"record:ccrb_allegations:917424:29","granularity":"record","dataset":"ccrb_allegations","record_id":"917424","official_source":"https://nypdonline.org/","record_grain":"source row","coverage_dates":"08/09/2026","native_identifiers":"917424","officer_fields":"tax_id","identity_layer_required":"true","join_method":"tax_id_to_opaque_officer_entity","coverage":"tax_id_present","joinability_class":"newly_usable_through_identity_layer","evidence_class":"direct_source_key","failure_reason":"","minimum_missing_government_key":"","uncertainty_status":"medium"}],"offset":0,"limit":25,"total":445673},"provenance":{"release_manifest":"/v1/releases/identity-graph-v1-6e76588616c0"}}