{"columns":[{"name":"health_system_id","type":"string"},{"name":"health_system_name","type":"string"},{"name":"location_id","type":"string"},{"name":"facility_code","type":"string"},{"name":"practice_name","type":"string"},{"name":"location_type","type":"string"},{"name":"specialty_primary","type":"string"},{"name":"specialties_secondary","type":"string"},{"name":"address_line1","type":"string"},{"name":"address_line2","type":"string"},{"name":"city","type":"string"},{"name":"state","type":"string"},{"name":"zip","type":"int64"},{"name":"phone","type":"string"},{"name":"fax","type":"string"},{"name":"scheduling_phone","type":"string"},{"name":"hours_mon_fri","type":"string"},{"name":"hours_sat","type":"string"},{"name":"hours_sun","type":"string"},{"name":"accepts_new_patients","type":"bool"},{"name":"telehealth_available","type":"bool"},{"name":"wheelchair_accessible","type":"bool"},{"name":"parking_type","type":"string"},{"name":"provider_count","type":"int64"},{"name":"ehr_vendor","type":"string"},{"name":"billing_npi_fake","type":"int64"},{"name":"tax_id_fake","type":"string"},{"name":"mode","type":"string"},{"name":"run_id","type":"int64"}],"n_rows":30,"rows_kept":30,"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":"DuckDB version v1.3.2 (build 0b83e5d2f6)","schema":{"fields":[{"name":"health_system_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"health_system_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"location_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"facility_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"practice_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"location_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"specialty_primary","type":"string","nullable":true,"metadata":null,"children":null},{"name":"specialties_secondary","type":"string","nullable":true,"metadata":null,"children":null},{"name":"address_line1","type":"string","nullable":true,"metadata":null,"children":null},{"name":"address_line2","type":"string","nullable":true,"metadata":null,"children":null},{"name":"city","type":"string","nullable":true,"metadata":null,"children":null},{"name":"state","type":"string","nullable":true,"metadata":null,"children":null},{"name":"zip","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"phone","type":"string","nullable":true,"metadata":null,"children":null},{"name":"fax","type":"string","nullable":true,"metadata":null,"children":null},{"name":"scheduling_phone","type":"string","nullable":true,"metadata":null,"children":null},{"name":"hours_mon_fri","type":"string","nullable":true,"metadata":null,"children":null},{"name":"hours_sat","type":"string","nullable":true,"metadata":null,"children":null},{"name":"hours_sun","type":"string","nullable":true,"metadata":null,"children":null},{"name":"accepts_new_patients","type":"bool","nullable":true,"metadata":null,"children":null},{"name":"telehealth_available","type":"bool","nullable":true,"metadata":null,"children":null},{"name":"wheelchair_accessible","type":"bool","nullable":true,"metadata":null,"children":null},{"name":"parking_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"provider_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"ehr_vendor","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_npi_fake","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"tax_id_fake","type":"string","nullable":true,"metadata":null,"children":null},{"name":"mode","type":"string","nullable":true,"metadata":null,"children":null},{"name":"run_id","type":"int64","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 duckdb_schema {\n  optional binary field_id=-1 health_system_id (String);\n  optional binary field_id=-1 health_system_name (String);\n  optional binary field_id=-1 location_id (String);\n  optional binary field_id=-1 facility_code (String);\n  optional binary field_id=-1 practice_name (String);\n  optional binary field_id=-1 location_type (String);\n  optional binary field_id=-1 specialty_primary (String);\n  optional binary field_id=-1 specialties_secondary (String);\n  optional binary field_id=-1 address_line1 (String);\n  optional binary field_id=-1 address_line2 (String);\n  optional binary field_id=-1 city (String);\n  optional binary field_id=-1 state (String);\n  optional int64 field_id=-1 zip (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 phone (String);\n  optional binary field_id=-1 fax (String);\n  optional binary field_id=-1 scheduling_phone (String);\n  optional binary field_id=-1 hours_mon_fri (String);\n  optional binary field_id=-1 hours_sat (String);\n  optional binary field_id=-1 hours_sun (String);\n  optional boolean field_id=-1 accepts_new_patients;\n  optional boolean field_id=-1 telehealth_available;\n  optional boolean field_id=-1 wheelchair_accessible;\n  optional binary field_id=-1 parking_type (String);\n  optional int64 field_id=-1 provider_count (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 ehr_vendor (String);\n  optional int64 field_id=-1 billing_npi_fake (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 tax_id_fake (String);\n  optional binary field_id=-1 mode (String);\n  optional int64 field_id=-1 run_id (Int(bitWidth=64, isSigned=true));\n}\n"},"kv_metadata":[]}
["FHS","Faircrest Health System","FHS-LOC-001","FHS-OP-001","Faircrest Oak Park Family Medicine","Clinic","Family Medicine","Pediatrics;Preventive Care","1200 Faircrest Blvd","Suite 100","Oak Park","IL",60302,"312-555-0101","312-555-0191","312-555-0111","Mon-Fri 8:00-17:00","Sat 9:00-13:00","Sun Closed",true,true,true,"Garage",8,"ExampleEHR",1999000001,"86-1000001","staging",0]
["FHS","Faircrest Health System","FHS-LOC-002","FHS-OP-002","Faircrest Oak Park Pediatrics","Clinic","Pediatrics","Family Medicine;Lactation Support","1220 Faircrest Blvd","Suite 220","Oak Park","IL",60302,"312-555-0102","312-555-0192","312-555-0112","Mon-Fri 8:00-17:30","Sat 9:00-12:00","Sun Closed",true,true,true,"Garage",6,"ExampleEHR",1999000002,"86-1000002","staging",0]
["FHS","Faircrest Health System","FHS-LOC-003","FHS-CH-001","Faircrest Chestnut Cardiology","Specialty Clinic","Cardiology","Electrophysiology;Preventive Cardiology","450 Chestnut Ave","Floor 3","Chicago","IL",60611,"773-555-0103","773-555-0193","773-555-0113","Mon-Fri 8:30-17:00","Sat Closed","Sun Closed",true,true,true,"Validated Lot",10,"ExampleEHR",1999000003,"86-1000003","staging",0]
["FHS","Faircrest Health System","FHS-LOC-004","FHS-CH-002","Faircrest Lakeshore Orthopedics","Specialty Clinic","Orthopedics","Sports Medicine;Physical Therapy","480 Lakeshore Dr","Suite 500","Chicago","IL",60611,"773-555-0104","773-555-0194","773-555-0114","Mon-Fri 7:30-16:30","Sat 8:00-12:00","Sun Closed",true,false,true,"Validated Lot",12,"ExampleEHR",1999000004,"86-1000004","staging",0]
["FHS","Faircrest Health System","FHS-LOC-005","FHS-CH-IMG","Faircrest Riverfront Imaging Center","Imaging Center","Radiology","MRI;CT;Ultrasound","900 Riverfront Way",null,"Chicago","IL",60607,"773-555-0105","773-555-0195","773-555-0115","Mon-Fri 7:00-19:00","Sat 8:00-14:00","Sun Closed",true,false,true,"Lot",0,"ExampleEHR",1999000005,"86-1000005","staging",0]
["FHS","Faircrest Health System","FHS-LOC-006","FHS-EL-001","Faircrest Elmwood Women’s Health","Clinic","OB/GYN","Family Planning;Urogynecology","2100 Elmwood Rd","Suite 140","Elmwood Park","IL",60707,"708-555-0106","708-555-0196","708-555-0116","Mon-Fri 8:00-17:00","Sat 9:00-12:00","Sun Closed",true,true,true,"Lot",7,"ExampleEHR",1999000006,"86-1000006","staging",0]
["FHS","Faircrest Health System","FHS-LOC-007","FHS-EL-002","Faircrest Elmwood Internal Medicine","Clinic","Internal Medicine","Endocrinology;Geriatrics","2140 Elmwood Rd","Suite 200","Elmwood Park","IL",60707,"708-555-0107","708-555-0197","708-555-0117","Mon-Fri 8:00-17:30","Sat Closed","Sun Closed",true,true,true,"Lot",9,"ExampleEHR",1999000007,"86-1000007","staging",0]
["FHS","Faircrest Health System","FHS-LOC-008","FHS-NP-001","Faircrest Northpoint Urgent Care","Urgent Care","Urgent Care","X-Ray;Labs","500 Northpoint Pkwy",null,"Naperville","IL",60563,"630-555-0108","630-555-0198","630-555-0118","Mon-Fri 8:00-20:00","Sat 9:00-18:00","Sun 9:00-16:00",true,true,true,"Lot",4,"ExampleEHR",1999000008,"86-1000008","staging",0]
["FHS","Faircrest Health System","FHS-LOC-009","FHS-NP-002","Faircrest Northpoint Family Medicine","Clinic","Family Medicine","Behavioral Health;Nutrition","520 Northpoint Pkwy","Suite 110","Naperville","IL",60563,"630-555-0109","630-555-0199","630-555-0119","Mon-Fri 8:00-17:00","Sat Closed","Sun Closed",true,true,true,"Lot",11,"ExampleEHR",1999000009,"86-1000009","staging",0]
["FHS","Faircrest Health System","FHS-LOC-010","FHS-AU-001","Faircrest Aurora Endocrinology","Specialty Clinic","Endocrinology","Diabetes Education;Thyroid","1550 Meridian St","Suite 300","Aurora","IL",60504,"630-555-0110","630-555-0200","630-555-0120","Mon-Fri 8:00-16:30","Sat Closed","Sun Closed",true,true,true,"Lot",6,"ExampleEHR",1999000010,"86-1000010","staging",0]
["FHS","Faircrest Health System","FHS-LOC-011","FHS-EC-001","Faircrest Eastgate Neurology","Specialty Clinic","Neurology","Headache;Movement Disorders","880 Eastgate Dr","Suite 250","Elgin","IL",60120,"847-555-0111","847-555-0201","847-555-0121","Mon-Fri 8:30-17:00","Sat Closed","Sun Closed",true,true,true,"Lot",5,"ExampleEHR",1999000011,"86-1000011","staging",0]
["FHS","Faircrest Health System","FHS-LOC-012","FHS-EC-IMG","Faircrest Eastgate Diagnostic Imaging","Imaging Center","Radiology","X-Ray;Ultrasound;CT","910 Eastgate Dr",null,"Elgin","IL",60120,"847-555-0112","847-555-0202","847-555-0122","Mon-Fri 7:00-18:00","Sat 8:00-13:00","Sun Closed",true,false,true,"Lot",0,"ExampleEHR",1999000012,"86-1000012","staging",0]
["FHS","Faircrest Health System","FHS-LOC-013","FHS-WG-001","Faircrest West Grove Gastroenterology","Specialty Clinic","Gastroenterology","Hepatology;Infusion","300 West Grove Ln","Suite 400","Wheaton","IL",60187,"630-555-0113","630-555-0203","630-555-0123","Mon-Fri 8:00-17:00","Sat Closed","Sun Closed",true,true,true,"Garage",8,"ExampleEHR",1999000013,"86-1000013","staging",0]
["FHS","Faircrest Health System","FHS-LOC-014","FHS-WG-002","Faircrest West Grove Pulmonology","Specialty Clinic","Pulmonology","Sleep Medicine;Asthma","320 West Grove Ln","Suite 210","Wheaton","IL",60187,"630-555-0114","630-555-0204","630-555-0124","Mon-Fri 8:00-16:30","Sat Closed","Sun Closed",true,true,true,"Garage",4,"ExampleEHR",1999000014,"86-1000014","staging",0]
["FHS","Faircrest Health System","FHS-LOC-015","FHS-RV-001","Faircrest Ridgeview Family Medicine","Clinic","Family Medicine","Sports Physicals;Preventive Care","75 Ridgeview Ct","Suite 120","Rockford","IL",61107,"815-555-0115","815-555-0205","815-555-0125","Mon-Fri 8:00-17:30","Sat 9:00-13:00","Sun Closed",true,true,true,"Lot",10,"ExampleEHR",1999000015,"86-1000015","staging",0]
["FHS","Faircrest Health System","FHS-LOC-016","FHS-RV-002","Faircrest Ridgeview Behavioral Health","Clinic","Behavioral Health","Psychiatry;Therapy","95 Ridgeview Ct","Suite 200","Rockford","IL",61107,"815-555-0116","815-555-0206","815-555-0126","Mon-Fri 9:00-18:00","Sat 9:00-14:00","Sun Closed",true,true,true,"Lot",9,"ExampleEHR",1999000016,"86-1000016","staging",0]
["FHS","Faircrest Health System","FHS-LOC-017","FHS-ML-001","Faircrest Meadowlane Dermatology","Specialty Clinic","Dermatology","Mohs Surgery;Cosmetic","610 Meadowlane Ave","Suite 310","Peoria","IL",61614,"309-555-0117","309-555-0207","309-555-0127","Mon-Fri 8:00-16:30","Sat Closed","Sun Closed",true,true,true,"Lot",6,"ExampleEHR",1999000017,"86-1000017","staging",0]
["FHS","Faircrest Health System","FHS-LOC-018","FHS-ML-002","Faircrest Meadowlane Rheumatology","Specialty Clinic","Rheumatology","Infusion;Arthritis Care","640 Meadowlane Ave","Suite 240","Peoria","IL",61614,"309-555-0118","309-555-0208","309-555-0128","Mon-Fri 8:30-17:00","Sat Closed","Sun Closed",true,true,true,"Lot",4,"ExampleEHR",1999000018,"86-1000018","staging",0]
["FHS","Faircrest Health System","FHS-LOC-019","FHS-SV-001","Faircrest Springvale Primary Care","Clinic","Primary Care","Internal Medicine;Family Medicine","101 Springvale Blvd","Suite 100","Springfield","IL",62704,"217-555-0119","217-555-0209","217-555-0129","Mon-Fri 8:00-17:00","Sat 9:00-12:00","Sun Closed",true,true,true,"Lot",12,"ExampleEHR",1999000019,"86-1000019","staging",0]
["FHS","Faircrest Health System","FHS-LOC-020","FHS-SV-UC","Faircrest Springvale Urgent Care","Urgent Care","Urgent Care","Labs;X-Ray;Stitches","140 Springvale Blvd",null,"Springfield","IL",62704,"217-555-0120","217-555-0210","217-555-0130","Mon-Fri 8:00-20:00","Sat 9:00-18:00","Sun 9:00-16:00",true,true,true,"Lot",5,"ExampleEHR",1999000020,"86-1000020","staging",0]
["FHS","Faircrest Health System","FHS-LOC-021","FHS-FP-001","Faircrest Fox Park ENT","Specialty Clinic","ENT","Allergy;Audiology","200 Fox Park Rd","Suite 260","Champaign","IL",61820,"217-555-0121","217-555-0211","217-555-0131","Mon-Fri 8:00-17:00","Sat Closed","Sun Closed",true,true,true,"Lot",5,"ExampleEHR",1999000021,"86-1000021","staging",0]
["FHS","Faircrest Health System","FHS-LOC-022","FHS-FP-002","Faircrest Fox Park Ophthalmology","Specialty Clinic","Ophthalmology","Glaucoma;Cataract","240 Fox Park Rd","Suite 180","Champaign","IL",61820,"217-555-0122","217-555-0212","217-555-0132","Mon-Fri 8:00-16:30","Sat Closed","Sun Closed",true,true,true,"Lot",7,"ExampleEHR",1999000022,"86-1000022","staging",0]
["FHS","Faircrest Health System","FHS-LOC-023","FHS-HR-001","Faircrest Harbor Ridge Cardiology","Specialty Clinic","Cardiology","Heart Failure;Imaging","88 Harbor Ridge Dr","Suite 400","Evanston","IL",60201,"847-555-0123","847-555-0213","847-555-0133","Mon-Fri 8:30-17:00","Sat Closed","Sun Closed",true,true,true,"Garage",9,"ExampleEHR",1999000023,"86-1000023","staging",0]
["FHS","Faircrest Health System","FHS-LOC-024","FHS-HR-002","Faircrest Harbor Ridge Oncology","Specialty Clinic","Oncology","Hematology;Infusion","110 Harbor Ridge Dr","Suite 120","Evanston","IL",60201,"847-555-0124","847-555-0214","847-555-0134","Mon-Fri 8:00-17:30","Sat Closed","Sun Closed",true,true,true,"Garage",11,"ExampleEHR",1999000024,"86-1000024","staging",0]
["FHS","Faircrest Health System","FHS-LOC-025","FHS-BR-001","Faircrest Brookfield Pediatrics","Clinic","Pediatrics","Adolescent Medicine;Vaccines","700 Brookfield Commons","Suite 105","Brookfield","WI",53005,"414-555-0125","414-555-0215","414-555-0135","Mon-Fri 8:00-17:00","Sat 9:00-12:00","Sun Closed",true,true,true,"Lot",6,"ExampleEHR",1999000025,"39-1000025","staging",0]
["FHS","Faircrest Health System","FHS-LOC-026","FHS-BR-002","Faircrest Brookfield Orthopedics","Specialty Clinic","Orthopedics","Hand;Spine","740 Brookfield Commons","Suite 220","Brookfield","WI",53005,"414-555-0126","414-555-0216","414-555-0136","Mon-Fri 7:30-16:30","Sat 8:00-12:00","Sun Closed",true,false,true,"Lot",10,"ExampleEHR",1999000026,"39-1000026","staging",0]
["FHS","Faircrest Health System","FHS-LOC-027","FHS-MD-001","Faircrest Maple District Family Medicine","Clinic","Family Medicine","Occupational Health;Preventive","15 Maple District Pl","Suite 100","Madison","WI",53703,"608-555-0127","608-555-0217","608-555-0137","Mon-Fri 8:00-17:30","Sat Closed","Sun Closed",true,true,true,"Street",9,"ExampleEHR",1999000027,"39-1000027","staging",0]
["FHS","Faircrest Health System","FHS-LOC-028","FHS-MD-IMG","Faircrest Maple District Imaging","Imaging Center","Radiology","MRI;CT;X-Ray","35 Maple District Pl",null,"Madison","WI",53703,"608-555-0128","608-555-0218","608-555-0138","Mon-Fri 7:00-18:30","Sat 8:00-13:00","Sun Closed",true,false,true,"Lot",0,"ExampleEHR",1999000028,"39-1000028","staging",0]
["FHS","Faircrest Health System","FHS-LOC-029","FHS-GR-001","Faircrest Greenway Neurology","Specialty Clinic","Neurology","EEG;Sleep","990 Greenway Pkwy","Suite 260","Green Bay","WI",54304,"920-555-0129","920-555-0219","920-555-0139","Mon-Fri 8:30-17:00","Sat Closed","Sun Closed",true,true,true,"Lot",4,"ExampleEHR",1999000029,"39-1000029","staging",0]
["FHS","Faircrest Health System","FHS-LOC-030","FHS-GR-UC","Faircrest Greenway Urgent Care","Urgent Care","Urgent Care","Pediatrics;Labs;X-Ray","1010 Greenway Pkwy",null,"Green Bay","WI",54304,"920-555-0130","920-555-0220","920-555-0140","Mon-Fri 8:00-20:00","Sat 9:00-18:00","Sun 9:00-16:00",true,true,true,"Lot",5,"ExampleEHR",1999000030,"39-1000030","staging",0]