from tokenize import String
ABRIDGED_COLUMNS = {
'roid': {
'cast': 'VARCHAR',
'coalesce': False,
'clickhouse_type': 'String'
},
'state': {
'default': "'Unknown State'",
'clickhouse_type': 'LowCardinality(String)'
},
'county': {
'default': "'Unknown County'",
'clickhouse_type': 'LowCardinality(String)'
},
'zip_code': {
'default': "'Unknown Zip'",
'clickhouse_type': 'LowCardinality(String)'
},
'cbsa': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'cbsa_name': {
'default': "'All Other Localities'",
'clickhouse_type': 'LowCardinality(String)'
},
'city': {
'default': "'Unknown City'",
'clickhouse_type': 'LowCardinality(String)'
},
'hq_latitude': {
'clickhouse_type': 'Nullable(String)'
},
'hq_longitude': {
'clickhouse_type': 'Nullable(String)'
},
'payer_name': {
'default': "'Unknown Payer'",
'clickhouse_type': 'LowCardinality(String)'
},
'network_id': {
'cast': 'VARCHAR',
'coalesce': False,
'clickhouse_type': 'String'
},
'network_name': {
'default': "'Unknown Network'",
'clickhouse_type': 'LowCardinality(String)'
},
'payer_network_name': {
'default': "'Unknown Payer-Network'",
'clickhouse_type': 'LowCardinality(String)'
},
'generic_search': {
'default': "'Unknown'",
'clickhouse_type': 'String'
},
'network_type': {
'default': "'Unknown Network Type'",
'clickhouse_type': 'LowCardinality(String)'
},
'network_class': {
'default': "'Unknown Network Class'",
'clickhouse_type': 'LowCardinality(String)'
},
'health_system_id': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'health_system_name': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'provider_id': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'provider_name': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'taxonomy_grouping': {
'default': "'Unknown Taxonomy'",
'clickhouse_type': 'LowCardinality(String)'
},
'provider_type': {
'default': "'Unknown Provider Type'",
'clickhouse_type': 'LowCardinality(String)'
},
'cmi': {
'default': 'CAST(0 AS DECIMAL(5,4))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'npi': {
'default': 'CAST(ARRAY[] AS ARRAY(VARCHAR))',
'clickhouse_type': 'Array(Nullable(String))'
},
'ein': {
'default': 'CAST(ARRAY[] AS ARRAY(VARCHAR))',
'clickhouse_type': 'Array(Nullable(String))'
},
'total_beds': {
'default': '0',
'clickhouse_type': 'Int64'
},
'bill_type': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'facility': {
'default': 'FALSE',
'clickhouse_type': 'Bool'
},
'billing_code_type': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'billing_code': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'billing_code_full': {
'default': "billing_code_type || ' ' || billing_code",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_rate_original_billing_codes': {
'default': "CAST(ARRAY[''] AS ARRAY(VARCHAR))",
'clickhouse_type': 'Array(Nullable(String))'
},
'canonical_rate_original_billing_code_type': {
'clickhouse_type': 'Nullable(String)'
},
'service_description': {
'default': "'Unknown Description'",
'clickhouse_type': 'LowCardinality(String)',
'codec': 'ZSTD(1)'
},
'drug_name_array': {
'default': 'CAST(ARRAY[] AS ARRAY(VARCHAR))',
'clickhouse_type': 'Array(Nullable(String))'
},
'service_line': {
'default': "'No Service Line'",
'clickhouse_type': 'LowCardinality(String)'
},
'therapeutic_area': {
'default': "'No Therapeutic Area'",
'clickhouse_type': 'LowCardinality(String)'
},
'is_drug_code': {
'default': 'FALSE',
'clickhouse_type': 'Bool'
},
'is_surg_code': {
'default': 'FALSE',
'clickhouse_type': 'Bool'
},
'asp_payment_limit': {
'default': '-1.0',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'medicare_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'medicare_pricing_type': {
'default': "'No Medicare Pricing'",
'clickhouse_type': 'LowCardinality(String)'
},
'medicare_reference_source': {
'default': "'No Medicare Source'",
'clickhouse_type': 'LowCardinality(String)'
},
'anesthesia_base_units': {
'coalesce': False,
'clickhouse_type': 'Nullable(Int32)'
},
'state_avg_medicare_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'national_avg_medicare_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'cbsa_avg_medicare_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'asc_avg_medicare_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'lab_avg_medicare_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'discounted_cash_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_gross_charge': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_gross_charge_type': {
'default': "'No Gross Charge'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_gross_charge_source': {
'default': "'No Gross Charge'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_rate_gross_charge_original_billing_codes': {
'default': "CAST(ARRAY[''] AS ARRAY(VARCHAR))",
'clickhouse_type': 'Array(Nullable(String))'
},
'canonical_rate_gross_charge_original_billing_code_type': {
'clickhouse_type': 'Nullable(String)'
},
'canonical_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
'codec': 'Delta(8), ZSTD(1)'
},
'canonical_rate_source': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_rate_type': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_contract_methodology': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_rate_category': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_rate_class': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_imputation_method': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_transformation_method': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_crosswalk_method': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_rate_percent_of_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_rate_percent_of_cbsa_avg_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_rate_percent_of_state_avg_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_rate_percent_of_national_avg_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_rate_percent_of_asc_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_rate_percent_of_lab_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_rate_percent_of_list': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'canonical_rate_validation_method': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'canonical_rate_score': {
'default': '0',
'clickhouse_type': 'Int32'
},
'canonical_rate_subversion': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'best_payer_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'best_payer_rate_score': {
'default': '-1',
'clickhouse_type': 'Int32'
},
'best_payer_rate_validation_score': {
'default': '-1',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'best_payer_rate_type': {
'default': "'No Payer Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'best_hospital_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'best_hospital_rate_score': {
'default': '-1',
'clickhouse_type': 'Int32'
},
'best_hospital_rate_validation_score': {
'default': '-1',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'best_hospital_rate_type': {
'default': "'No Hospital Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'komodo_gross_charge_provider': {
'default': 'CAST(-1 AS DECIMAL(18,2))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'mrf_gross_charge_provider': {
'default': 'CAST(-1 AS DECIMAL(18,2))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'komodo_gross_charge_cbsa_median': {
'default': 'CAST(-1 AS DECIMAL(38,12))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'mrf_gross_charge_cbsa_median': {
'default': '-1.0',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'mrf_gross_charge_state_median': {
'default': '-1.0',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'gross_charge_cbsa_provider_adjustment': {
'default': 'CAST(-1 AS DECIMAL(20,10))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'clear_market_utilization_commercial': {
'default': 'CAST(1 AS DECIMAL(38,11))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'clear_market_utilization_medicare': {
'default': 'CAST(1 AS DECIMAL(38,11))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'clear_market_utilization_medicaid': {
'default': 'CAST(1 AS DECIMAL(38,11))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'payer_location_data_source_name': {
'clickhouse_type': 'Array(Nullable(String))'
},
'payer_file_hash': {
'clickhouse_type': 'Nullable(String)'
},
'payer_last_updated_on': {
'clickhouse_type': 'Nullable(Date32)'
},
'hospital_filename': {
'clickhouse_type': 'Nullable(String)'
},
'hospital_ingested_on': {
'clickhouse_type': 'Nullable(Date32)'
},
'canonical_method_params': {
'clickhouse_type': 'Nullable(String)'
},
'canonical_method_formula': {
'clickhouse_type': 'Nullable(String)'
},
'national_payer_covered_lives': {
'default': 'CAST(-1 AS DECIMAL(18,2))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'provider_net_patient_revenue_national_rank': {
'default': '-1',
'clickhouse_type': 'Int64'
},
'provider_leapfrog_score': {
'default': '-1.0',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'provider_leapfrog_grade': {
'default': "''",
'clickhouse_type': 'LowCardinality(String)'
},
'provider_is_340b_hospital': {
'default': 'FALSE',
'clickhouse_type': 'Bool'
},
'provider_network_msdrg_base_rate': {
'default': '-1.0',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'within_provider_payer_pct_of_total_claims': {
'default': '-1.0',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'within_provider_payer_pct_of_total_charges': {
'default': '-1.0',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'within_provider_payer_payer_rank': {
'default': '-1',
'clickhouse_type': 'Int64'
},
'cbsa_payer_covered_lives_market_share': {
'default': 'CAST(-1 AS DECIMAL(38,2))',
'cast': 'DOUBLE',
'clickhouse_type': 'Float64'
},
'rank_code_within_provider_over_revenue': {
'default': '-1',
'clickhouse_type': 'Int64'
},
'rank_code_within_provider_over_claims': {
'default': '-1',
'clickhouse_type': 'Int64'
},
'lag_6m_canonical_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
},
'lag_6m_canonical_rate_delta': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
},
'lag_6m_canonical_rate_type': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'lag_6m_canonical_method_params': {
'clickhouse_type': 'Nullable(String)'
},
'lag_6m_canonical_rate_source': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'lag_6m_canonical_rate_percent_of_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'lag_6m_canonical_rate_percent_of_medicare_delta': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
},
'lag_6m_canonical_rate_percent_of_state_avg_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'lag_6m_canonical_rate_percent_of_state_avg_medicare_delta': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
},
'lag_6m_canonical_rate_score': {
'default': '0',
'clickhouse_type': 'Int32'
},
'lag_12m_canonical_rate': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
},
'lag_12m_canonical_rate_delta': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
},
'lag_12m_canonical_rate_type': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'lag_12m_canonical_method_params': {
'clickhouse_type': 'Nullable(String)'
},
'lag_12m_canonical_rate_source': {
'default': "'No Canonical Rate'",
'clickhouse_type': 'LowCardinality(String)'
},
'lag_12m_canonical_rate_percent_of_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'lag_12m_canonical_rate_percent_of_medicare_delta': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
},
'lag_12m_canonical_rate_percent_of_state_avg_medicare': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)'
},
'lag_12m_canonical_rate_percent_of_state_avg_medicare_delta': {
'coalesce': False,
'cast': 'DOUBLE',
'clickhouse_type': 'Nullable(Float64)',
},
'lag_12m_canonical_rate_score': {
'default': '0',
'clickhouse_type': 'Int32'
},
'payer_id': {
'coalesce': False,
'clickhouse_type': 'LowCardinality(String)'
}
}