{"columns":[{"name":"ingested_at","type":"timestamp[us, tz=America/Chicago]"},{"name":"ingested_file_name","type":"string"},{"name":"message_code","type":"string"},{"name":"message_variant","type":"string"},{"name":"implementation_reference","type":"string"},{"name":"transaction_set_control_number","type":"string"},{"name":"st_transaction_set_identifier_code","type":"string"},{"name":"st_transaction_set_control_number","type":"string"},{"name":"st_implementation_convention_reference","type":"string"},{"name":"bht_hierarchical_structure_code","type":"string"},{"name":"bht_transaction_set_purpose_code","type":"string"},{"name":"bht_reference_identification","type":"string"},{"name":"bht_date","type":"string"},{"name":"bht_time","type":"string"},{"name":"bht_transaction_type_code","type":"string"},{"name":"submitter_name","type":"string"},{"name":"submitter_id","type":"string"},{"name":"receiver_name","type":"string"},{"name":"receiver_id","type":"string"},{"name":"billing_provider_hl_id","type":"string"},{"name":"billing_provider_hl_level_code","type":"string"},{"name":"billing_provider_taxonomy_code","type":"string"},{"name":"billing_provider_name","type":"string"},{"name":"billing_provider_npi","type":"string"},{"name":"billing_provider_tax_id","type":"string"},{"name":"subscriber_hl_id","type":"string"},{"name":"subscriber_parent_hl_id","type":"string"},{"name":"payer_responsibility_sequence_number_code","type":"string"},{"name":"subscriber_relationship_code","type":"string"},{"name":"claim_filing_indicator_code","type":"string"},{"name":"subscriber_last_name","type":"string"},{"name":"subscriber_first_name","type":"string"},{"name":"subscriber_id","type":"string"},{"name":"payer_name","type":"string"},{"name":"payer_id","type":"string"},{"name":"claim_patient_control_number","type":"string"},{"name":"claim_total_charge_amount","type":"string"},{"name":"claim_facility_type_code","type":"string"},{"name":"claim_facility_code_qualifier","type":"string"},{"name":"claim_frequency_type_code","type":"string"},{"name":"provider_signature_indicator","type":"string"},{"name":"assignment_or_plan_participation_code","type":"string"},{"name":"benefits_assignment_certification_indicator","type":"string"},{"name":"release_of_information_code","type":"string"},{"name":"statement_from_date","type":"string"},{"name":"statement_to_date","type":"string"},{"name":"claim_service_date","type":"string"},{"name":"primary_diagnosis_qualifier","type":"string"},{"name":"primary_diagnosis_code","type":"string"},{"name":"secondary_diagnosis_raw","type":"string"},{"name":"tertiary_diagnosis_raw","type":"string"}],"n_rows":3,"rows_kept":3,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"parquet-cpp-arrow version 20.0.0","schema":{"fields":[{"name":"ingested_at","type":"timestamp[us, tz=America/Chicago]","nullable":true,"metadata":null,"children":null},{"name":"ingested_file_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_variant","type":"string","nullable":true,"metadata":null,"children":null},{"name":"implementation_reference","type":"string","nullable":true,"metadata":null,"children":null},{"name":"transaction_set_control_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"st_transaction_set_identifier_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"st_transaction_set_control_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"st_implementation_convention_reference","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_hierarchical_structure_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_transaction_set_purpose_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_reference_identification","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_date","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_time","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_transaction_type_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"submitter_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"submitter_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"receiver_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"receiver_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_hl_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_hl_level_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_taxonomy_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_npi","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_tax_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_hl_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_parent_hl_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payer_responsibility_sequence_number_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_relationship_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_filing_indicator_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_last_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_first_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payer_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payer_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_patient_control_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_total_charge_amount","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_facility_type_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_facility_code_qualifier","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_frequency_type_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"provider_signature_indicator","type":"string","nullable":true,"metadata":null,"children":null},{"name":"assignment_or_plan_participation_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"benefits_assignment_certification_indicator","type":"string","nullable":true,"metadata":null,"children":null},{"name":"release_of_information_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"statement_from_date","type":"string","nullable":true,"metadata":null,"children":null},{"name":"statement_to_date","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_service_date","type":"string","nullable":true,"metadata":null,"children":null},{"name":"primary_diagnosis_qualifier","type":"string","nullable":true,"metadata":null,"children":null},{"name":"primary_diagnosis_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"secondary_diagnosis_raw","type":"string","nullable":true,"metadata":null,"children":null},{"name":"tertiary_diagnosis_raw","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional int64 field_id=-1 ingested_at (Timestamp(isAdjustedToUTC=true, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional binary field_id=-1 ingested_file_name (String);\n  optional binary field_id=-1 message_code (String);\n  optional binary field_id=-1 message_variant (String);\n  optional binary field_id=-1 implementation_reference (String);\n  optional binary field_id=-1 transaction_set_control_number (String);\n  optional binary field_id=-1 st_transaction_set_identifier_code (String);\n  optional binary field_id=-1 st_transaction_set_control_number (String);\n  optional binary field_id=-1 st_implementation_convention_reference (String);\n  optional binary field_id=-1 bht_hierarchical_structure_code (String);\n  optional binary field_id=-1 bht_transaction_set_purpose_code (String);\n  optional binary field_id=-1 bht_reference_identification (String);\n  optional binary field_id=-1 bht_date (String);\n  optional binary field_id=-1 bht_time (String);\n  optional binary field_id=-1 bht_transaction_type_code (String);\n  optional binary field_id=-1 submitter_name (String);\n  optional binary field_id=-1 submitter_id (String);\n  optional binary field_id=-1 receiver_name (String);\n  optional binary field_id=-1 receiver_id (String);\n  optional binary field_id=-1 billing_provider_hl_id (String);\n  optional binary field_id=-1 billing_provider_hl_level_code (String);\n  optional binary field_id=-1 billing_provider_taxonomy_code (String);\n  optional binary field_id=-1 billing_provider_name (String);\n  optional binary field_id=-1 billing_provider_npi (String);\n  optional binary field_id=-1 billing_provider_tax_id (String);\n  optional binary field_id=-1 subscriber_hl_id (String);\n  optional binary field_id=-1 subscriber_parent_hl_id (String);\n  optional binary field_id=-1 payer_responsibility_sequence_number_code (String);\n  optional binary field_id=-1 subscriber_relationship_code (String);\n  optional binary field_id=-1 claim_filing_indicator_code (String);\n  optional binary field_id=-1 subscriber_last_name (String);\n  optional binary field_id=-1 subscriber_first_name (String);\n  optional binary field_id=-1 subscriber_id (String);\n  optional binary field_id=-1 payer_name (String);\n  optional binary field_id=-1 payer_id (String);\n  optional binary field_id=-1 claim_patient_control_number (String);\n  optional binary field_id=-1 claim_total_charge_amount (String);\n  optional binary field_id=-1 claim_facility_type_code (String);\n  optional binary field_id=-1 claim_facility_code_qualifier (String);\n  optional binary field_id=-1 claim_frequency_type_code (String);\n  optional binary field_id=-1 provider_signature_indicator (String);\n  optional binary field_id=-1 assignment_or_plan_participation_code (String);\n  optional binary field_id=-1 benefits_assignment_certification_indicator (String);\n  optional binary field_id=-1 release_of_information_code (String);\n  optional binary field_id=-1 statement_from_date (String);\n  optional binary field_id=-1 statement_to_date (String);\n  optional binary field_id=-1 claim_service_date (String);\n  optional binary field_id=-1 primary_diagnosis_qualifier (String);\n  optional binary field_id=-1 primary_diagnosis_code (String);\n  optional binary field_id=-1 secondary_diagnosis_raw (String);\n  optional binary field_id=-1 tertiary_diagnosis_raw (String);\n}\n"},"kv_metadata":[["ARROW:schema",{"$cut":{"chars":4832,"head":""}}],["desisiv:query_meta","{\"persist_path\": null, \"persist_file\": null, \"persist_glob_pattern\": null, \"persist_file_type\": null, \"persist_file_quoting\": null, \"persist_file_delimiter\": null, \"persist_step_type\": null, \"persist_step_sub_type\": null, \"persist_step_name\": null, \"persist_incremental_loading\": null, \"persist_merge_keys\": null}"]]}
["2026-04-15T22:32:01.316044Z","837-institutional-sample-multiple-claims.x12","837","INSTITUTIONAL","005010X223A2","0201","837","0201","005010X223A2","0019","00","INST0001","20260406","1215","CH","NEXUS REVENUE CYCLE","SUBMITTER02","ACME HEALTH PLAN","RECEIVER02","1","20","282N00000X","NEXUS COMMUNITY HOSPITAL","1098765432","560987654","2","1","P","18","CI","SMITH","JOHN","MEM000002","ACME HEALTH PLAN","842610001","ICLAIM001","375","22","A","1","Y","C","Y","Y","20260404-20260405","20260405",null,"BK","S0101XA","BF:W540XXA",null]
["2026-04-15T22:32:01.316044Z","837-institutional-sample-multiple-claims.x12","837","INSTITUTIONAL","005010X223A2","0201","837","0201","005010X223A2","0019","00","INST0001","20260406","1215","CH","NEXUS REVENUE CYCLE","SUBMITTER02","ACME HEALTH PLAN","RECEIVER02","1","20","282N00000X","NEXUS COMMUNITY HOSPITAL","1098765432","560987654","2","1","P","18","CI","SMITH","JOHN","MEM000002","ACME HEALTH PLAN","842610001","ICLAIM002","640","22","A","1","Y","C","Y","Y","20260406-20260408","20260408",null,"BK","J189","BF:R079",null]
["2026-04-15T22:32:01.316044Z","837-institutional-sample-multiple-claims.x12","837","INSTITUTIONAL","005010X223A2","0201","837","0201","005010X223A2","0019","00","INST0001","20260406","1215","CH","NEXUS REVENUE CYCLE","SUBMITTER02","ACME HEALTH PLAN","RECEIVER02","1","20","282N00000X","NEXUS COMMUNITY HOSPITAL","1098765432","560987654","3","1","P","18","CI","JONES","MARY","MEM000003","ACME HEALTH PLAN","842610001","ICLAIM003","890","22","A","1","Y","C","Y","Y","20260409-20260411","20260411",null,"BK","I639","BF:E119",null]