### UHC download list
# https://github.com/CMSgov/price-transparency-guide/discussions/534#discussioncomment-3329744
req <- httr2::request("https://transparency-in-coverage.uhc.com/api/v1/uhc/blobs/")
# Send and save response
resp <- req |> httr2::req_perform()
# Parse JSON response and save results
content <- resp |> httr2::resp_body_json(check_type = FALSE, simplifyVector = TRUE)
uhc_links <- content$blobs |> tibble::tibble()
print(uhc_links, n = 1000)
#> # A tibble: 68,072 × 3
#> name downloadUrl size
#> <chr> <chr> <dbl>
#> 1 2024-07-01_-A-1-PUMP-INC_index.json https://mr… 3160
#> 2 2024-07-01_-ANS-Machine-LLC_index.json https://mr… 1562
#> 3 2024-07-01_-Aircon-Engineering-Inc_index.json https://mr… 1565
#> 4 2024-07-01_-BAPTIST-RETIREMENT-COMMUNITIES-OF-GEORGIA_in… https://mr… 1565
#> 5 2024-07-01_-BVT-NATIONAL-CAPITAL-PARTNERS-INC_index.json https://mr… 1565
#> 6 2024-07-01_-Brown-and-Pratt-Inc_index.json https://mr… 1565
#> 7 2024-07-01_-CYPRESS-CREEK-ANIMAL-HOSPITAL-PC_index.json https://mr… 3151
#> 8 2024-07-01_-Centex-Axiscare-LLC_index.json https://mr… 2977
#> 9 2024-07-01_-DENZINGER-FAMILY-DENTISTRY-LLC_index.json https://mr… 1913
#> 10 2024-07-01_-DPM-of-Nashville-Inc_index.json https://mr… 1565
#> 11 2024-07-01_-Davis-Auto-Group-LLC_index.json https://mr… 1913
#> 12 2024-07-01_-ELEISH-VAN-BREEMS-ANTIQUES-LLC_index.json https://mr… 2833
#> 13 2024-07-01_-FARMERS-UNION-SERVICE-ASSOCIATION_United-Hea… https://mr… 185
#> 14 2024-07-01_-FARMERS-UNION-SERVICE-ASSOCIATION_index.json https://mr… 4862
#> 15 2024-07-01_-JJs-Towing_index.json https://mr… 1565
#> 16 2024-07-01_-JOINER-ANDERSON-FUNERAL-HOME-INC_index.json https://mr… 1564
#> 17 2024-07-01_-JT-Petroleum-LLC_index.json https://mr… 1565
#> 18 2024-07-01_-KC-Outdoor-Structure-LLC_index.json https://mr… 1739
#> 19 2024-07-01_-MICK-MOULS-MODERN-BUILDERS-LLC_index.json https://mr… 1565
#> 20 2024-07-01_-Mark-M-Holeman-Inc_index.json https://mr… 1565
#> 21 2024-07-01_-Midwest-Infrastructure-Coating_index.json https://mr… 1739
#> 22 2024-07-01_-National-Corn-Growers-Association_index.json https://mr… 1565
#> 23 2024-07-01_-R3-OFFICE-OF-DR-KASHI-RAI_index.json https://mr… 1565
#> 24 2024-07-01_-REAL-ESTATE-PERSONNEL-INC_index.json https://mr… 1910
#> 25 2024-07-01_-Roadhog-Inc_index.json https://mr… 1565
#> 26 2024-07-01_-Spero-Solutions-Inc_index.json https://mr… 2985
#> 27 2024-07-01_-TZP-LIMITED-LIABILITY-COMPANY_index.json https://mr… 1565
#> 28 2024-07-01_02-GLOBAL-CHAUFFEURED-SERVICE_index.json https://mr… 3163
#> 29 2024-07-01_1-800-Radiator-of-Dallas-Fort-Worth-LLC_index… https://mr… 1736
#> 30 2024-07-01_1-AB-Inc_index.json https://mr… 1910
#> 31 2024-07-01_1-BETTER-LLC_index.json https://mr… 1565
#> 32 2024-07-01_1-CARE-LLC_UHC-EPO-Gated-INN-Only---ASO_allow… https://mr… 182
#> 33 2024-07-01_1-CARE-LLC_index.json https://mr… 3238
#> 34 2024-07-01_1-IT-SOURCE-LLC_index.json https://mr… 1565
#> 35 2024-07-01_1-PASSION-TO-CARE-LLC-WELFARE-BENEFIT-PLAN_in… https://mr… 1913
#> 36 2024-07-01_1-REAL-ESTATE-MANAGEMENT-INC_index.json https://mr… 2986
#> 37 2024-07-01_10-ROADS-EXPRESS-LLC_10-ROADS-EXPRESS-LLC_all… https://mr… 166
#> 38 2024-07-01_10-ROADS-EXPRESS-LLC_index.json https://mr… 1216
#> 39 2024-07-01_10-Roads-Express-LLC_POS-CHOICE-PLUS_allowed-… https://mr… 184
#> 40 2024-07-01_10-Roads-Express-LLC_index.json https://mr… 1231
#> 41 2024-07-01_100-Percent-Chiropractic-Atlanta-Five-LLC_ind… https://mr… 2087
#> 42 2024-07-01_1000-CHURCH-STREET-INC-GROUP-HEALTH-BENEFIT-P… https://mr… 171
#> 43 2024-07-01_1000-CHURCH-STREET-INC-GROUP-HEALTH-BENEFIT-P… https://mr… 1582
#> 44 2024-07-01_101-SAFETY-LLC_index.json https://mr… 1565
#> 45 2024-07-01_1010-Metrodome-Square-LLC_index.json https://mr… 1739
#> 46 2024-07-01_104-DEGREES-WEST-PARTNERS-LLC_index.json https://mr… 1913
#> 47 2024-07-01_106-Y-LLC_index.json https://mr… 1739
#> 48 2024-07-01_1099EXPRESS-COM-INC_United-Healthcare-POS_all… https://mr… 185
#> 49 2024-07-01_1099EXPRESS-COM-INC_index.json https://mr… 1834
#> 50 2024-07-01_10th-Inning-Grill-at-Snowden-Grove-LLC_index.… https://mr… 1562
#> 51 2024-07-01_1122-Rte-115-LLC_index.json https://mr… 1562
#> 52 2024-07-01_1175-TECHNOLOGY-LLC_index.json https://mr… 1912
#> 53 2024-07-01_118-SOUTH-LLC_index.json https://mr… 1736
#> 54 2024-07-01_11TH-HOUR-BREWING-LLC_index.json https://mr… 2977
#> 55 2024-07-01_11TH-HOUR-BUSINESS-SOLUTIONS_index.json https://mr… 1736
#> 56 2024-07-01_12-POINT-LLC_index.json https://mr… 1739
#> 57 2024-07-01_121-Media-LLC_index.json https://mr… 1913
#> 58 2024-07-01_121234-LLC_index.json https://mr… 1565
#> 59 2024-07-01_121G-CONSULTING-LLC_index.json https://mr… 1739
#> 60 2024-07-01_1350-OCEAN-LLC_index.json https://mr… 1562
#> 61 2024-07-01_13TH-FLOOR-ENTERTAINMENT-GROUP_index.json https://mr… 3499
#> 62 2024-07-01_1405-HOSPITALITY-GROUP-LLC_index.json https://mr… 2084
#> 63 2024-07-01_15-LIGHTYEARS-INC_index.json https://mr… 1739
#> 64 2024-07-01_15-Yards-Holding-Co_index.json https://mr… 1565
#> 65 2024-07-01_1501-N-KINGSBURY-OPERATIONS-LLC_index.json https://mr… 1560
#> 66 2024-07-01_1520-HANNAH-LLC_index.json https://mr… 1560
#> 67 2024-07-01_15512-Consulting-LLC_index.json https://mr… 1913
#> 68 2024-07-01_15RX-LLC_index.json https://mr… 1565
#> 69 2024-07-01_1603-G_index.json https://mr… 1565
#> 70 2024-07-01_1661-Inc-dba-GOAT_SELECT-EPO-00-E_allowed-amo… https://mr… 184
#> 71 2024-07-01_1661-Inc-dba-GOAT_SELECT-PLUS-POS-00-P_allowe… https://mr… 184
#> 72 2024-07-01_1661-Inc-dba-GOAT_index.json https://mr… 4451
#> 73 2024-07-01_16TH-JUDICIAL-DISTRICT_index.json https://mr… 1565
#> 74 2024-07-01_1776-Energy-Operators-LLC_index.json https://mr… 1739
#> 75 2024-07-01_17th-Judicial-District-Indigent-Defender_inde… https://mr… 1913
#> 76 2024-07-01_183-MEDIA-LLC_index.json https://mr… 1565
#> 77 2024-07-01_1858-Haven-Private-Wealth_index.json https://mr… 1913
#> 78 2024-07-01_18TH-CENTURY-CONSULTING_index.json https://mr… 1565
#> 79 2024-07-01_1915-SOUTH-CO_1915-SOUTH-CO_allowed-amounts.j… https://mr… 166
#> 80 2024-07-01_1915-SOUTH-CO_index.json https://mr… 929
#> 81 2024-07-01_1974-KOOL-ZONE-LLC-DBA-MELLOW-MUSHROOM-ATLANT… https://mr… 1738
#> 82 2024-07-01_1990-N-McMullen-Booth-Road_index.json https://mr… 3151
#> 83 2024-07-01_1DA-1DIGITAL-AGENCY-INC_index.json https://mr… 3151
#> 84 2024-07-01_1LIFE-HEALTHCARE-INC-GROUP-HEALTH-BENEFIT-PLA… https://mr… 1092
#> 85 2024-07-01_1LIFE-HEALTHCARE-INC-GROUP-HEALTH-BENEFIT-PLA… https://mr… 3096
#> 86 2024-07-01_1PLUS1EQUAL3-INC_index.json https://mr… 1565
#> 87 2024-07-01_1ST-CHOICE-GREASE-SERVICE-LLC_index.json https://mr… 1565
#> 88 2024-07-01_1ST-CLASS-ROOFING-INC_index.json https://mr… 1736
#> 89 2024-07-01_1ST-MATE-LOGISTICS_index.json https://mr… 1565
#> 90 2024-07-01_1ST-RATE-HOME-MORTGAGE-INC_index.json https://mr… 3334
#> 91 2024-07-01_1ST-SOURCE-CORPORATION-GROUP-HEALTH-BENEFIT-P… https://mr… 171
#> 92 2024-07-01_1ST-SOURCE-CORPORATION-GROUP-HEALTH-BENEFIT-P… https://mr… 1357
#> 93 2024-07-01_1ST-UNIVERSITY-CREDIT-UNION_index.json https://mr… 1565
#> 94 2024-07-01_1Spot-AI-LLC_index.json https://mr… 1565
#> 95 2024-07-01_1st-America-Home-Medical-Equipment_index.json https://mr… 1565
#> 96 2024-07-01_1st-Choice-Group-LLC_index.json https://mr… 2087
#> 97 2024-07-01_1st-LLC_POS-CHOICE-PLUS_allowed-amounts.json.… https://mr… 541
#> 98 2024-07-01_1st-LLC_index.json https://mr… 1218
#> 99 2024-07-01_1st-Priority-Realty-and-Management-Llc_index.… https://mr… 1913
#> 100 2024-07-01_2-AND-92-TRUCK-PARTS-INC_index.json https://mr… 1565
#> 101 2024-07-01_2-Aces-Auto-Repair-and-Accessories-LLC_index.… https://mr… 1736
#> 102 2024-07-01_2-HOUNDS-DESIGN-INC_index.json https://mr… 1565
#> 103 2024-07-01_2-JS-VENTURE-FOODS-INC_index.json https://mr… 1562
#> 104 2024-07-01_2-STONE-INDUSTRIES-LLC_index.json https://mr… 4920
#> 105 2024-07-01_2-for-U-Childcare-West_index.json https://mr… 1739
#> 106 2024-07-01_20-20-Accounting_index.json https://mr… 1739
#> 107 2024-07-01_20-20-EYEGLASS-SUPERSTORE-INC_index.json https://mr… 2977
#> 108 2024-07-01_20-20-Optical-Inc_index.json https://mr… 2661
#> 109 2024-07-01_20-CLARKE-RD-LLC_index.json https://mr… 2977
#> 110 2024-07-01_200-PEACHTREE-SPECIAL-EVENTS-LLC_index.json https://mr… 1739
#> 111 2024-07-01_201-LLC_index.json https://mr… 1912
#> 112 2024-07-01_2020-Companies-Inc_POS-CHOICE-PLUS_allowed-am… https://mr… 184
#> 113 2024-07-01_2020-Companies-Inc_index.json https://mr… 2868
#> 114 2024-07-01_2060-NORTH-INC_index.json https://mr… 1560
#> 115 2024-07-01_2083-THERAPY-LLC_index.json https://mr… 1565
#> 116 2024-07-01_211-BREVARD-INC_index.json https://mr… 1562
#> 117 2024-07-01_21ST-CENTURY-BEAN-PROCESSING-L_index.json https://mr… 1565
#> 118 2024-07-01_21ST-CENTURY-EQUIPMENT-LLC-GROUP-HEALTH-BENEF… https://mr… 171
#> 119 2024-07-01_21ST-CENTURY-EQUIPMENT-LLC-GROUP-HEALTH-BENEF… https://mr… 1026
#> 120 2024-07-01_21ST-CENTURY-HEALTHCARE-INC-GROUP-HEALTH-BENE… https://mr… 171
#> 121 2024-07-01_21ST-CENTURY-HEALTHCARE-INC-GROUP-HEALTH-BENE… https://mr… 1602
#> 122 2024-07-01_21ST-CENTURY-INNOVATION-INC_index.json https://mr… 1565
#> 123 2024-07-01_221-INC_index.json https://mr… 3151
#> 124 2024-07-01_222-CLARK-LLC_index.json https://mr… 1910
#> 125 2024-07-01_222-Dutch-Lanes-Inc-_index.json https://mr… 1565
#> 126 2024-07-01_22VETS-LLC_index.json https://mr… 1565
#> 127 2024-07-01_24-7-PRO-LOCKSMITH-LLC_index.json https://mr… 5110
#> 128 2024-07-01_24-7-RESTORATION-INC_index.json https://mr… 1565
#> 129 2024-07-01_24-HOUR-FITNESS-USA-LLC_UHC-CHOICEUBH_allowed… https://mr… 182
#> 130 2024-07-01_24-HOUR-FITNESS-USA-LLC_index.json https://mr… 1458
#> 131 2024-07-01_24-HOUR-LTD_index.json https://mr… 1565
#> 132 2024-07-01_24-Hour-Fitness_POS-CHOICE-PLUS_allowed-amoun… https://mr… 184
#> 133 2024-07-01_24-Hour-Fitness_index.json https://mr… 1226
#> 134 2024-07-01_240-TUTORING-INC_index.json https://mr… 1913
#> 135 2024-07-01_2420-PIEDMONT-ROAD-LLC_index.json https://mr… 1564
#> 136 2024-07-01_2428392-INC-DBA-FYE-HEALTH-CARE-BENEFITS-PLAN… https://mr… 171
#> 137 2024-07-01_2428392-INC-DBA-FYE-HEALTH-CARE-BENEFITS-PLAN… https://mr… 1287
#> 138 2024-07-01_247-LOGISTICS_index.json https://mr… 1739
#> 139 2024-07-01_247-Metal-Laser-Inc_index.json https://mr… 1560
#> 140 2024-07-01_24Restore-Inc_index.json https://mr… 1565
#> 141 2024-07-01_2550-Ashland-LLC_index.json https://mr… 1560
#> 142 2024-07-01_25TH-STREET-PIZZA-LLC_index.json https://mr… 1736
#> 143 2024-07-01_26H-Holdings-LLC_index.json https://mr… 1739
#> 144 2024-07-01_27-GLOBAL-LLC_index.json https://mr… 1739
#> 145 2024-07-01_2BROS-RESOURCES-LLC_index.json https://mr… 1913
#> 146 2024-07-01_2BROS-SPORTS-COLLECTIBLES-LLC_index.json https://mr… 2261
#> 147 2024-07-01_2Com-Group-LLC_index.json https://mr… 2655
#> 148 2024-07-01_2FOLD-COLLECTIVE-LLC_index.json https://mr… 2986
#> 149 2024-07-01_2G1S-LLC_index.json https://mr… 1565
#> 150 2024-07-01_2J-SUPPLY-GROUP-HEALTH-BENEFIT-PLAN_2J-SUPPLY… https://mr… 171
#> 151 2024-07-01_2J-SUPPLY-GROUP-HEALTH-BENEFIT-PLAN_index.json https://mr… 1263
#> 152 2024-07-01_2J-TRANSPORTATION-LLC_index.json https://mr… 2977
#> 153 2024-07-01_2L-CONSTRUCTION-LLC_index.json https://mr… 1565
#> 154 2024-07-01_2M-Associates-LLC_index.json https://mr… 1739
#> 155 2024-07-01_2M-Electrical-Representatives-Inc_index.json https://mr… 2087
#> 156 2024-07-01_2ND-CHANCE-TREATMENT-CENTER-GROUP-HEALTH-BENE… https://mr… 171
#> 157 2024-07-01_2ND-CHANCE-TREATMENT-CENTER-GROUP-HEALTH-BENE… https://mr… 1593
#> 158 2024-07-01_2ND-CITY-REMODELING-LLC_index.json https://mr… 1565
#> 159 2024-07-01_2UMedical-Inc_index.json https://mr… 1565
#> 160 2024-07-01_2i-Nova-Inc_index.json https://mr… 1739
#> 161 2024-07-01_3-DB-NETWORKS-AND-KGT-LLC_index.json https://mr… 1739
#> 162 2024-07-01_3-KINGS-TRANSPORT-LLC_index.json https://mr… 1739
#> 163 2024-07-01_3-N-1-MEDIA-LLC_index.json https://mr… 1739
#> 164 2024-07-01_3-RIVERS-WET-WEATHER-INC_index.json https://mr… 1562
#> 165 2024-07-01_3-Rusty-Nails-Inc_index.json https://mr… 1565
#> 166 2024-07-01_3-SHEEPS-BREWING-COMPANY_index.json https://mr… 3504
#> 167 2024-07-01_3-TIER-COMMUNICATIONS-LLC_index.json https://mr… 3151
#> 168 2024-07-01_304-WEST-MAIN-LLC_index.json https://mr… 1565
#> 169 2024-07-01_305-CONSULTING-ENGINEERS-LLC_index.json https://mr… 1565
#> 170 2024-07-01_305-PIZZA-AT-MIA-LLC_index.json https://mr… 1562
#> 171 2024-07-01_310-DUST-CONTROL-LLC_index.json https://mr… 2986
#> 172 2024-07-01_31000-FT-LLC_UHC-EPO-Gated-INN-Only---ASO_all… https://mr… 185
#> 173 2024-07-01_31000-FT-LLC_United-Healthcare-EPO_allowed-am… https://mr… 185
#> 174 2024-07-01_31000-FT-LLC_index.json https://mr… 3514
#> 175 2024-07-01_321WEBMARKETING_index.json https://mr… 1565
#> 176 2024-07-01_32nd-Street-Surgery-Center-LLC_index.json https://mr… 1560
#> 177 2024-07-01_333-LIMITLESS-ROAD-INC_index.json https://mr… 1739
#> 178 2024-07-01_360-Ag-Solutions-LLC_index.json https://mr… 1565
#> 179 2024-07-01_360-COMMUNITIES_index.json https://mr… 1913
#> 180 2024-07-01_360-CONSULTING-INC_index.json https://mr… 1565
#> 181 2024-07-01_360-Degrees-LLC_index.json https://mr… 1741
#> 182 2024-07-01_360-ENGINEERING-GROUP-PLLC_index.json https://mr… 1739
#> 183 2024-07-01_360-Energy-Solutions-LLC_index.json https://mr… 1736
#> 184 2024-07-01_360-FINANCIAL-GROUP-LLC_index.json https://mr… 1565
#> 185 2024-07-01_360-INTERNET-MARKETING-DBA_index.json https://mr… 1736
#> 186 2024-07-01_360-LEGAL-INC_index.json https://mr… 1736
#> 187 2024-07-01_360-Solutions_index.json https://mr… 1565
#> 188 2024-07-01_360-Tour-Designs-and-Marketing-LLC_index.json https://mr… 1565
#> 189 2024-07-01_365-LABS-LLC_index.json https://mr… 1565
#> 190 2024-07-01_3700-MANAGEMENT-INC_index.json https://mr… 3149
#> 191 2024-07-01_37th-Street-Cooking-Inc_index.json https://mr… 1565
#> 192 2024-07-01_3A-COMPOSITES-USA-INC-GROUP-HEALTH-BENEFIT-PL… https://mr… 656
#> 193 2024-07-01_3A-COMPOSITES-USA-INC-GROUP-HEALTH-BENEFIT-PL… https://mr… 1578
#> 194 2024-07-01_3A-MARINE-SERVICES-INC_index.json https://mr… 1562
#> 195 2024-07-01_3C-DRYWALL-LLC_index.json https://mr… 1565
#> 196 2024-07-01_3C-Industrial-LLC_index.json https://mr… 1739
#> 197 2024-07-01_3C-METAL-USA-INC_index.json https://mr… 2982
#> 198 2024-07-01_3D-Graphite-and-Machining-Inc_index.json https://mr… 1565
#> 199 2024-07-01_3D-HEALTH-INC_index.json https://mr… 4570
#> 200 2024-07-01_3D-HOME-IMPROVEMENT_index.json https://mr… 1562
#> 201 2024-07-01_3D-Landscaping-LLC_index.json https://mr… 2982
#> 202 2024-07-01_3D-Molecular-Designs-LLC_index.json https://mr… 1741
#> 203 2024-07-01_3D-Storage-Systems-Incorporated_index.json https://mr… 1562
#> 204 2024-07-01_3D-VAPOR-LLC_index.json https://mr… 1565
#> 205 2024-07-01_3DMD-LLC_index.json https://mr… 1565
#> 206 2024-07-01_3G-CONSTRUCTION-INC_index.json https://mr… 1565
#> 207 2024-07-01_3G-CONSULTING-INC_index.json https://mr… 1739
#> 208 2024-07-01_3G-ELECTRICAL-SUPPLY-INC_index.json https://mr… 1565
#> 209 2024-07-01_3G-HOLDINGS-INC_index.json https://mr… 1565
#> 210 2024-07-01_3G-Wireless-LLC_index.json https://mr… 1562
#> 211 2024-07-01_3GIMBALS-LLC_index.json https://mr… 1565
#> 212 2024-07-01_3GS-LLC_index.json https://mr… 1739
#> 213 2024-07-01_3H2O-INC_index.json https://mr… 1562
#> 214 2024-07-01_3HB-INVESTMENTS-LLC_index.json https://mr… 1565
#> 215 2024-07-01_3I-PRODUCTS-INC_index.json https://mr… 1739
#> 216 2024-07-01_3L-Consulting-Inc_index.json https://mr… 1565
#> 217 2024-07-01_3LC-US-INC_index.json https://mr… 3151
#> 218 2024-07-01_3M-COMPANY-GROUP-HEALTH-BENEFIT-PLAN_3M-COMPA… https://mr… 171
#> 219 2024-07-01_3M-COMPANY-GROUP-HEALTH-BENEFIT-PLAN_index.js… https://mr… 694
#> 220 2024-07-01_3PL-WORLDWIDE-INC_index.json https://mr… 3008
#> 221 2024-07-01_3POINTE-RESTAURANT-GROUP-HOLDINGS-LLC_index.j… https://mr… 2261
#> 222 2024-07-01_3Q-INC_index.json https://mr… 2986
#> 223 2024-07-01_3R-RV-SERVICE-CENTER-LLC_index.json https://mr… 1562
#> 224 2024-07-01_3R-TECHNOLOGY-LLC_index.json https://mr… 3151
#> 225 2024-07-01_3S-AMERICAS-INC_index.json https://mr… 1739
#> 226 2024-07-01_3SAE-TECHNOLOGIES-INC_index.json https://mr… 1565
#> 227 2024-07-01_3SI-SECURITY-SYSTEMS_3SI-SECURITY-SYSTEMS_all… https://mr… 166
#> 228 2024-07-01_3SI-SECURITY-SYSTEMS_index.json https://mr… 950
#> 229 2024-07-01_3T-DRILLING-INC_index.json https://mr… 1564
#> 230 2024-07-01_3TC-DESIGN_index.json https://mr… 1565
#> 231 2024-07-01_3V-SIGMA-USA-INC-GROUP-HEALTH-BENEFIT-PLAN_3V… https://mr… 171
#> 232 2024-07-01_3V-SIGMA-USA-INC-GROUP-HEALTH-BENEFIT-PLAN_in… https://mr… 1557
#> 233 2024-07-01_3W-Energy-Services_index.json https://mr… 1738
#> 234 2024-07-01_3form-LLC_POS-CHOICE-PLUS_allowed-amounts.jso… https://mr… 184
#> 235 2024-07-01_3form-LLC_index.json https://mr… 1220
#> 236 2024-07-01_4-FAITH-TRUCKING-LLC_index.json https://mr… 1562
#> 237 2024-07-01_4-K-CONSTRUCTION-INC_index.json https://mr… 1562
#> 238 2024-07-01_4-Point-Capital-LLC_index.json https://mr… 1565
#> 239 2024-07-01_4-SEASONS-AIR-CONDITIONING-AND_index.json https://mr… 3499
#> 240 2024-07-01_4-SERV-SOLUTIONS-INC_index.json https://mr… 1913
#> 241 2024-07-01_4-Seasons-Windows-Inc_index.json https://mr… 1565
#> 242 2024-07-01_4-for-Four-LTD_index.json https://mr… 1565
#> 243 2024-07-01_40-Days-for-Life_index.json https://mr… 1739
#> 244 2024-07-01_401-MANUFACTURING-INC_index.json https://mr… 1565
#> 245 2024-07-01_41-North-Offshore-LLC_index.json https://mr… 1565
#> 246 2024-07-01_417-ENDODONTICS_index.json https://mr… 1565
#> 247 2024-07-01_417-EXPRESS-DELIVERY-LLC_index.json https://mr… 1565
#> 248 2024-07-01_417-MOTORSPORTS-LLC_index.json https://mr… 1565
#> 249 2024-07-01_42-LLC_United-Healthcare-POS_allowed-amounts.… https://mr… 185
#> 250 2024-07-01_42-LLC_index.json https://mr… 3236
#> 251 2024-07-01_420-SCIENCE_index.json https://mr… 1565
#> 252 2024-07-01_435-ROOFING-INC_index.json https://mr… 1565
#> 253 2024-07-01_44-STONE-LLC_index.json https://mr… 1908
#> 254 2024-07-01_456-Vishwas-LLC_index.json https://mr… 2661
#> 255 2024-07-01_462-PIANO-CRAFT-INC_index.json https://mr… 1739
#> 256 2024-07-01_4B-DIESEL-SERVICES-LLC_index.json https://mr… 1739
#> 257 2024-07-01_4C-Unlimited-LLC_index.json https://mr… 3151
#> 258 2024-07-01_4D-Insurance-Agency-LLC_index.json https://mr… 3151
#> 259 2024-07-01_4E-ACQUISITIONS-LLC_index.json https://mr… 1565
#> 260 2024-07-01_4ES-CORPORATION_index.json https://mr… 2977
#> 261 2024-07-01_4F-ENERGY-LLC_UHC-EPO-Gated-INN-Only---ASO_al… https://mr… 185
#> 262 2024-07-01_4F-ENERGY-LLC_index.json https://mr… 3430
#> 263 2024-07-01_4FDesign_index.json https://mr… 1565
#> 264 2024-07-01_4Front-Engineered-Solutions_POS-CHOICE-PLUS_a… https://mr… 184
#> 265 2024-07-01_4Front-Engineered-Solutions_index.json https://mr… 2635
#> 266 2024-07-01_4G-Express-Inc_index.json https://mr… 1913
#> 267 2024-07-01_4IMPRINT-INC-GROUP-BENEFIT-PLAN_4IMPRINT-INC-… https://mr… 171
#> 268 2024-07-01_4IMPRINT-INC-GROUP-BENEFIT-PLAN_index.json https://mr… 1547
#> 269 2024-07-01_4J-ENERGY-LLC_index.json https://mr… 1736
#> 270 2024-07-01_4L-OILFIELD-SERVICES-LLC_index.json https://mr… 2977
#> 271 2024-07-01_4M-BUILDING-SOLUTIONS-INC-GROUP-BENEFIT-PLAN_… https://mr… 171
#> 272 2024-07-01_4M-BUILDING-SOLUTIONS-INC-GROUP-BENEFIT-PLAN_… https://mr… 1598
#> 273 2024-07-01_4M-OF-MIAMI-INC_index.json https://mr… 1562
#> 274 2024-07-01_4M-Oil-Field-Services-LLC_index.json https://mr… 1565
#> 275 2024-07-01_4M-PROPERTIES-INC_index.json https://mr… 1739
#> 276 2024-07-01_4S-Builders-Inc_index.json https://mr… 1739
#> 277 2024-07-01_4T-DOOR-SYSTEMS-INC_index.json https://mr… 1562
#> 278 2024-07-01_4WS-LLC-DBA-4-WHEEL_index.json https://mr… 1562
#> 279 2024-07-01_4d-Construction-Services-LLC_index.json https://mr… 2087
#> 280 2024-07-01_4th-Dimension-Properties-LLC_UHC-EPO-Gated-IN… https://mr… 185
#> 281 2024-07-01_4th-Dimension-Properties-LLC_index.json https://mr… 4683
#> 282 2024-07-01_4th-Meridian-Farm-Inc_index.json https://mr… 1565
#> 283 2024-07-01_5-STAR-TIRE-AND-AUTOMOTIVE_index.json https://mr… 1565
#> 284 2024-07-01_5-Star-Food-Services-LLC_index.json https://mr… 1739
#> 285 2024-07-01_500---WISCONSIN-MASONS-HEALTH-CARE-FUND_500--… https://mr… 501
#> 286 2024-07-01_500---WISCONSIN-MASONS-HEALTH-CARE-FUND_index… https://mr… 1827
#> 287 2024-07-01_510-ARCHITECTS-LLC_index.json https://mr… 1913
#> 288 2024-07-01_510-PRINTING-LLC_index.json https://mr… 1565
#> 289 2024-07-01_512-DOGJOY-LLC_index.json https://mr… 1739
#> 290 2024-07-01_512Financial-LLC_index.json https://mr… 1739
#> 291 2024-07-01_5280-Publishing-Inc_index.json https://mr… 1913
#> 292 2024-07-01_536-Single-RE-LLC_index.json https://mr… 2977
#> 293 2024-07-01_544-Yale-LP_index.json https://mr… 2977
#> 294 2024-07-01_546869-Holdings-LLC_index.json https://mr… 1910
#> 295 2024-07-01_55-WELL-SERVICE_index.json https://mr… 1565
#> 296 2024-07-01_5B-ELECTRIC-LLC_index.json https://mr… 1565
#> 297 2024-07-01_5BY5-ENGINEERS-LLC_index.json https://mr… 1739
#> 298 2024-07-01_5H-CUSTOM-MEATS-LLC_index.json https://mr… 1565
#> 299 2024-07-01_5STAR-BANK_index.json https://mr… 1913
#> 300 2024-07-01_5TH-GENERATION-CONTRACTING-INC_index.json https://mr… 1565
#> 301 2024-07-01_5th-Street-Foods_index.json https://mr… 1565
#> 302 2024-07-01_61ST-STREET-SERVICE-CORPORATION_61ST-STREET-S… https://mr… 166
#> 303 2024-07-01_61ST-STREET-SERVICE-CORPORATION_index.json https://mr… 1267
#> 304 2024-07-01_61st-Street-Service-Corporation_POS-CHOICE-PL… https://mr… 184
#> 305 2024-07-01_61st-Street-Service-Corporation_index.json https://mr… 1531
#> 306 2024-07-01_6288-Holdings-PLLC_index.json https://mr… 1910
#> 307 2024-07-01_63-Auto-and-Truck-Parts-LLC_index.json https://mr… 1565
#> 308 2024-07-01_6DS-Inc_index.json https://mr… 2084
#> 309 2024-07-01_6S-DEVELOPMENT-LLC_index.json https://mr… 1739
#> 310 2024-07-01_6S-ENGINEERING-INC_index.json https://mr… 1565
#> 311 2024-07-01_6TH-SENSE-LURE-CO-LLC_UHC-EPO-Gated-INN-Only-… https://mr… 185
#> 312 2024-07-01_6TH-SENSE-LURE-CO-LLC_index.json https://mr… 6279
#> 313 2024-07-01_6TH-STREET-HAPPY-CHICKS-LLC_index.json https://mr… 1565
#> 314 2024-07-01_7-ELEVEN-INC_7-ELEVEN-INC_allowed-amounts.jso… https://mr… 166
#> 315 2024-07-01_7-ELEVEN-INC_index.json https://mr… 1169
#> 316 2024-07-01_7-Eleven-Inc_index.json https://mr… 1499
#> 317 2024-07-01_7080-Starlight-LLC_index.json https://mr… 1562
#> 318 2024-07-01_724-CONSULTING-INC_index.json https://mr… 1565
#> 319 2024-07-01_742-LOGISTICS-INC_index.json https://mr… 1565
#> 320 2024-07-01_755-Restaurant-Corporation_index.json https://mr… 1739
#> 321 2024-07-01_7Crew-Enterprises-LLC_index.json https://mr… 1739
#> 322 2024-07-01_7J-LLC_index.json https://mr… 2261
#> 323 2024-07-01_7S-MANAGEMENT-LLC_index.json https://mr… 1739
#> 324 2024-07-01_8020-LLC-GROUP-BENEFIT-PLAN_8020-LLC-GROUP-BE… https://mr… 171
#> 325 2024-07-01_8020-LLC-GROUP-BENEFIT-PLAN_index.json https://mr… 1226
#> 326 2024-07-01_808-N-State-St_index.json https://mr… 2981
#> 327 2024-07-01_809-MANAGEMENT_index.json https://mr… 1567
#> 328 2024-07-01_81-Bay-Brewing_index.json https://mr… 1562
#> 329 2024-07-01_84-Packing-Company_index.json https://mr… 1565
#> 330 2024-07-01_888-DIGITAL-INC_index.json https://mr… 8183
#> 331 2024-07-01_8K-INC_index.json https://mr… 1562
#> 332 2024-07-01_9-DESIGN-LLC_index.json https://mr… 1734
#> 333 2024-07-01_900LBS-OF-CREATIVE-LLC_index.json https://mr… 3340
#> 334 2024-07-01_901-VASCULAR-PLLC_index.json https://mr… 1739
#> 335 2024-07-01_903-Advisors-LLC_index.json https://mr… 1565
#> 336 2024-07-01_906-STUDIO-PLLC_index.json https://mr… 1739
#> 337 2024-07-01_908-GROUP-HOLDINGS-LLC_index.json https://mr… 1913
#> 338 2024-07-01_924-Inc_index.json https://mr… 1913
#> 339 2024-07-01_925-Partners-LLC_index.json https://mr… 3325
#> 340 2024-07-01_930VENTURES-LLC_United-Healthcare-EPO_allowed… https://mr… 182
#> 341 2024-07-01_930VENTURES-LLC_index.json https://mr… 5608
#> 342 2024-07-01_96-AGRI-SALES-INC_index.json https://mr… 1739
#> 343 2024-07-01_986-Restaurant-Corp_United-Healthcare-EPO_all… https://mr… 182
#> 344 2024-07-01_986-Restaurant-Corp_index.json https://mr… 5443
#> 345 2024-07-01_99-PROBLEMS-LLC_index.json https://mr… 1565
#> 346 2024-07-01_A--B-ELECTRIC-COMPANY-INC-GROUP-BENEFIT-PLAN_… https://mr… 171
#> 347 2024-07-01_A--B-ELECTRIC-COMPANY-INC-GROUP-BENEFIT-PLAN_… https://mr… 1595
#> 348 2024-07-01_A--M-OPERATING-CO-INC_index.json https://mr… 1562
#> 349 2024-07-01_A--M-SYSTEMS-INC_index.json https://mr… 1565
#> 350 2024-07-01_A-1-AIR-INC-GROUP-HEALTH-BENEFIT-PLAN_A-1-AIR… https://mr… 639
#> 351 2024-07-01_A-1-AIR-INC-GROUP-HEALTH-BENEFIT-PLAN_index.j… https://mr… 1539
#> 352 2024-07-01_A-1-AUTO-BODY_index.json https://mr… 1565
#> 353 2024-07-01_A-1-Appliance-Company_index.json https://mr… 1565
#> 354 2024-07-01_A-1-BLOCK-CORPORATION-GROUP-HEALTH-BENEFIT-PL… https://mr… 171
#> 355 2024-07-01_A-1-BLOCK-CORPORATION-GROUP-HEALTH-BENEFIT-PL… https://mr… 1306
#> 356 2024-07-01_A-1-CHIMNEY-SPECIALIST-LLC_index.json https://mr… 1565
#> 357 2024-07-01_A-1-Chipseal-Company_United-Healthcare-EPO_al… https://mr… 185
#> 358 2024-07-01_A-1-Chipseal-Company_index.json https://mr… 3253
#> 359 2024-07-01_A-1-EXCAVATING-LLC_index.json https://mr… 1565
#> 360 2024-07-01_A-1-Fire-and-Safety_index.json https://mr… 1562
#> 361 2024-07-01_A-1-GLASS-AND-ALUMINUM_index.json https://mr… 1910
#> 362 2024-07-01_A-1-Holding-CO_index.json https://mr… 1565
#> 363 2024-07-01_A-1-Hydraulic-Sales-and-Services-Inc_index.js… https://mr… 1565
#> 364 2024-07-01_A-1-LEASING-INC_index.json https://mr… 2983
#> 365 2024-07-01_A-1-MACHINE-INC_index.json https://mr… 1736
#> 366 2024-07-01_A-1-Tire-Service-Inc_index.json https://mr… 1739
#> 367 2024-07-01_A-A-Air-Company-Inc_index.json https://mr… 1739
#> 368 2024-07-01_A-A-Holdings-LLC_index.json https://mr… 1565
#> 369 2024-07-01_A-ACTION-AIRE-INC_index.json https://mr… 1565
#> 370 2024-07-01_A-ADVANCED-SEPTIC-SERVICES-INC_index.json https://mr… 3325
#> 371 2024-07-01_A-ALL-APPLIANCE-INC_index.json https://mr… 1565
#> 372 2024-07-01_A-ALL-PEST-TERMITE-EXTERMINATORS-INC_index.js… https://mr… 1565
#> 373 2024-07-01_A-ANASTASIO-AND-SONS-TRUCKING_United-Healthca… https://mr… 182
#> 374 2024-07-01_A-ANASTASIO-AND-SONS-TRUCKING_index.json https://mr… 5620
#> 375 2024-07-01_A-AND-A-ASPHALT-INC_index.json https://mr… 1562
#> 376 2024-07-01_A-AND-A-GONZALEZ-TRUCKING-LLC_index.json https://mr… 2983
#> 377 2024-07-01_A-AND-A-MATERIALS-INC_index.json https://mr… 1739
#> 378 2024-07-01_A-AND-B-BRAKE-AND-ALIGNMENT-INC_index.json https://mr… 1562
#> 379 2024-07-01_A-AND-B-FILLING-INC_index.json https://mr… 1565
#> 380 2024-07-01_A-AND-B-FLORIST-SUPPLY-COMPANY-INC_index.json https://mr… 1565
#> 381 2024-07-01_A-AND-B-GROUP-INC_index.json https://mr… 1565
#> 382 2024-07-01_A-AND-B-HEATING-AND-AIR-INC_index.json https://mr… 1739
#> 383 2024-07-01_A-AND-B-INGREDIENTS-INC_index.json https://mr… 2661
#> 384 2024-07-01_A-AND-C-CATALYSTS-INC_index.json https://mr… 2830
#> 385 2024-07-01_A-AND-C-METALS-SAWING-INC_index.json https://mr… 1565
#> 386 2024-07-01_A-AND-D-COLOR-GRAPHICS-INC_index.json https://mr… 1565
#> 387 2024-07-01_A-AND-D-PAINTING-INC_index.json https://mr… 1565
#> 388 2024-07-01_A-AND-D-TECHNICAL-SUPPLY-CO-INC_index.json https://mr… 1565
#> 389 2024-07-01_A-AND-E-CLASSICS-LLC_index.json https://mr… 1565
#> 390 2024-07-01_A-AND-E-SANDOVAL-LLC_index.json https://mr… 1565
#> 391 2024-07-01_A-AND-F-Mailing-LLC_index.json https://mr… 1564
#> 392 2024-07-01_A-AND-H-BUILDING-SUPPLY-INC_index.json https://mr… 1565
#> 393 2024-07-01_A-AND-J-LAND-SURVEYORS-INC_index.json https://mr… 1736
#> 394 2024-07-01_A-AND-J-MACK-ENTERPRISES-INC_index.json https://mr… 1565
#> 395 2024-07-01_A-AND-J-MARKETING-LLC_index.json https://mr… 1913
#> 396 2024-07-01_A-AND-K-KOUKLAKIS-OD-PC_index.json https://mr… 1560
#> 397 2024-07-01_A-AND-L-CONSTRUCTION-MANAGERS-LLC_index.json https://mr… 2976
#> 398 2024-07-01_A-AND-L-DELGADOS-CORPORATION_index.json https://mr… 1565
#> 399 2024-07-01_A-AND-L-GREAT-LAKES-LABS-INC_index.json https://mr… 1739
#> 400 2024-07-01_A-AND-L-LOGISTICS-INC_index.json https://mr… 1565
#> 401 2024-07-01_A-AND-L-MACHINING-INC_index.json https://mr… 4404
#> 402 2024-07-01_A-AND-L-VALVE-AND-FITTING-LP_index.json https://mr… 1739
#> 403 2024-07-01_A-AND-M-FORENSICS-INC_index.json https://mr… 1913
#> 404 2024-07-01_A-AND-M-HEATING-AND-COOLING-INC_index.json https://mr… 1565
#> 405 2024-07-01_A-AND-M-MACHINE-WORKS-INC_index.json https://mr… 1565
#> 406 2024-07-01_A-AND-M-PRODUCTS-COMPANY-INC_index.json https://mr… 1565
#> 407 2024-07-01_A-AND-P-ELECTRICAL-SERVICE-INC_index.json https://mr… 1739
#> 408 2024-07-01_A-AND-P-GREASE-TRAPPERS_United-Healthcare-EPO… https://mr… 185
#> 409 2024-07-01_A-AND-P-GREASE-TRAPPERS_index.json https://mr… 3424
#> 410 2024-07-01_A-AND-R-BULK-PAK-SC-LLC_index.json https://mr… 1565
#> 411 2024-07-01_A-AND-R-Baird-Farms-LLC_index.json https://mr… 1565
#> 412 2024-07-01_A-AND-R-CONSTRUCTION-LLC_index.json https://mr… 1739
#> 413 2024-07-01_A-AND-R-DOOR-SERVICE-INC_index.json https://mr… 1565
#> 414 2024-07-01_A-AND-R-ENERGY-SERVICES_United-Healthcare-POS… https://mr… 423
#> 415 2024-07-01_A-AND-R-ENERGY-SERVICES_index.json https://mr… 4665
#> 416 2024-07-01_A-AND-S-INVESTMENTS-GROUP-LLC_index.json https://mr… 1913
#> 417 2024-07-01_A-AND-S-UTILITY-SERVICES-LLC_index.json https://mr… 1739
#> 418 2024-07-01_A-AND-T-TRUCKING-LLC_index.json https://mr… 1562
#> 419 2024-07-01_A-AND-W-COMPRESSOR-MECHANICAL-SERVICES-INC_AS… https://mr… 185
#> 420 2024-07-01_A-AND-W-COMPRESSOR-MECHANICAL-SERVICES-INC_in… https://mr… 1847
#> 421 2024-07-01_A-AND-W-CONTRACTING-INC_index.json https://mr… 1739
#> 422 2024-07-01_A-AND-W-TOOL-INC_index.json https://mr… 1739
#> 423 2024-07-01_A-Accident-Advocacy-Associates-Law-Offices-of… https://mr… 2977
#> 424 2024-07-01_A-Air-Company-Inc_index.json https://mr… 1562
#> 425 2024-07-01_A-BETTERWAY-RENT-A-CAR-INC-GROUP-BENEFIT-PLAN… https://mr… 171
#> 426 2024-07-01_A-BETTERWAY-RENT-A-CAR-INC-GROUP-BENEFIT-PLAN… https://mr… 1293
#> 427 2024-07-01_A-BOOK-COMPANY-LLC-DBA-ECAMPUSCOM-GROUP-HEALT… https://mr… 171
#> 428 2024-07-01_A-BOOK-COMPANY-LLC-DBA-ECAMPUSCOM-GROUP-HEALT… https://mr… 1626
#> 429 2024-07-01_A-BRI-G-SALONS-INC_index.json https://mr… 1913
#> 430 2024-07-01_A-BRITE-COMPANY-INC_index.json https://mr… 1910
#> 431 2024-07-01_A-C-PLUS-INC_index.json https://mr… 1739
#> 432 2024-07-01_A-C-SYSTEMS-INC_index.json https://mr… 1565
#> 433 2024-07-01_A-CHAPPA-CONSTRUCTION-LLC_index.json https://mr… 1565
#> 434 2024-07-01_A-CLASSICAL-STUDIO-FOR-RESIDENTIAL_index.json https://mr… 1565
#> 435 2024-07-01_A-D-DAVIS-CONSTRUCTION-CORP_index.json https://mr… 1562
#> 436 2024-07-01_A-D-ENGINEERING-SERVICES-INC_index.json https://mr… 1565
#> 437 2024-07-01_A-DIFFERENT-DEFENSE-PLLC_index.json https://mr… 3151
#> 438 2024-07-01_A-Design-by-Gustavo-Arredondo_index.json https://mr… 1736
#> 439 2024-07-01_A-F-MCGERVEY_index.json https://mr… 1562
#> 440 2024-07-01_A-FASSANO-AND-COMPANY_index.json https://mr… 2830
#> 441 2024-07-01_A-FRED-HEDRICK-JR-DMD-PC_index.json https://mr… 1565
#> 442 2024-07-01_A-GOOD-NAME-LLC_index.json https://mr… 3889
#> 443 2024-07-01_A-GOOD-NEIGHBOR-LLC_index.json https://mr… 1565
#> 444 2024-07-01_A-Gagliano-Company-Inc_index.json https://mr… 1565
#> 445 2024-07-01_A-Glass-and-Tint-Shop-of-KC-Inc_index.json https://mr… 1565
#> 446 2024-07-01_A-Glewen-and-Sons-Excavating-Inc_index.json https://mr… 1562
#> 447 2024-07-01_A-H-EMERY-COMPANY_index.json https://mr… 2660
#> 448 2024-07-01_A-H-TRUCKING-LLC_index.json https://mr… 1565
#> 449 2024-07-01_A-JS-ELECTRICAL-TESTING-AND-SERVICES-LLC_inde… https://mr… 1562
#> 450 2024-07-01_A-K-Kraussel-Tool-and-Mfg-Corp_index.json https://mr… 1565
#> 451 2024-07-01_A-KELLY-DESIGN-BUILDING-LLC_index.json https://mr… 1739
#> 452 2024-07-01_A-L-BOECK-AND-COMPANY-INC_index.json https://mr… 1565
#> 453 2024-07-01_A-L-L-EQUIPMENT-INC_index.json https://mr… 1562
#> 454 2024-07-01_A-L-SCHUTZMAN-COMPANY-INC-GROUP-HEALTH-BENEFI… https://mr… 171
#> 455 2024-07-01_A-L-SCHUTZMAN-COMPANY-INC-GROUP-HEALTH-BENEFI… https://mr… 1622
#> 456 2024-07-01_A-LIGHTING-MAINTENANCE_index.json https://mr… 1562
#> 457 2024-07-01_A-Land-Electric-LLC_index.json https://mr… 1562
#> 458 2024-07-01_A-Leaf-International-Inc_index.json https://mr… 1565
#> 459 2024-07-01_A-MRAZEK-MOVING-SYSTEMS-INC_index.json https://mr… 1913
#> 460 2024-07-01_A-NAVA-AND-GLANDER-LAW-FIRM_index.json https://mr… 1739
#> 461 2024-07-01_A-Noll-Enterprises-LLC_index.json https://mr… 1565
#> 462 2024-07-01_A-O-C-LLC_index.json https://mr… 2977
#> 463 2024-07-01_A-OK-ENTERPRISES-LLC_index.json https://mr… 2087
#> 464 2024-07-01_A-P-MERKEL-INC_index.json https://mr… 1562
#> 465 2024-07-01_A-PERFECT-PROMOTION-INC_index.json https://mr… 1565
#> 466 2024-07-01_A-PETS-LIFE-LLC_index.json https://mr… 4573
#> 467 2024-07-01_A-PLUS-AUTO_index.json https://mr… 1560
#> 468 2024-07-01_A-PLUS-CONSTRUCTION-SERVICES_index.json https://mr… 1562
#> 469 2024-07-01_A-PLUS-EXTERIORS-LLC_index.json https://mr… 2661
#> 470 2024-07-01_A-PLUS-MORTGAGE-SERVICES-INC_United-Healthcar… https://mr… 185
#> 471 2024-07-01_A-PLUS-MORTGAGE-SERVICES-INC_index.json https://mr… 4677
#> 472 2024-07-01_A-PLUS-PLUMBING-INC_index.json https://mr… 1565
#> 473 2024-07-01_A-PLUS-PROFESSOR-OF-PLUMBING_index.json https://mr… 1913
#> 474 2024-07-01_A-PLUS-TIRE_index.json https://mr… 1565
#> 475 2024-07-01_A-PROLAWN-SERVICE-CORP_index.json https://mr… 1736
#> 476 2024-07-01_A-Pro-DandG-LLC_index.json https://mr… 1910
#> 477 2024-07-01_A-Professional-Image-Inc_index.json https://mr… 1565
#> 478 2024-07-01_A-R-M-MECHANICALS-INC_index.json https://mr… 1560
#> 479 2024-07-01_A-R-MACHINING-INC_index.json https://mr… 1739
#> 480 2024-07-01_A-RANDYS-ELECTRIC-_index.json https://mr… 2977
#> 481 2024-07-01_A-RAY-TEXTILES-INC_index.json https://mr… 1562
#> 482 2024-07-01_A-SPEC-COLLISION-INC_index.json https://mr… 1562
#> 483 2024-07-01_A-STEP-AHEAD-FLOORING-INC_index.json https://mr… 1570
#> 484 2024-07-01_A-STEP-FORWARD-INC-GROUP-HEALTH-BENEFIT-PLAN_… https://mr… 171
#> 485 2024-07-01_A-STEP-FORWARD-INC-GROUP-HEALTH-BENEFIT-PLAN_… https://mr… 1565
#> 486 2024-07-01_A-Second-Opinion-LLC_index.json https://mr… 3183
#> 487 2024-07-01_A-Shed-Utah-Inc_index.json https://mr… 2983
#> 488 2024-07-01_A-TEX-PEST-MANAGEMENT-INC_index.json https://mr… 2258
#> 489 2024-07-01_A-TIRE-COUNTY-SERVICE_index.json https://mr… 1560
#> 490 2024-07-01_A-TO-Z-AUTO-REPAIR-INC_index.json https://mr… 1560
#> 491 2024-07-01_A-TO-Z-LIVESTOCK_index.json https://mr… 1565
#> 492 2024-07-01_A-TO-Z-MACHINE-INC-GROUP-BENEFIT-PLAN_A-TO-Z-… https://mr… 171
#> 493 2024-07-01_A-TO-Z-MACHINE-INC-GROUP-BENEFIT-PLAN_index.j… https://mr… 1252
#> 494 2024-07-01_A-TO-Z-STATEWIDE-PLUMBING_index.json https://mr… 1736
#> 495 2024-07-01_A-Vitti-Excavators-LLC_United-Healthcare-EPO_… https://mr… 182
#> 496 2024-07-01_A-Vitti-Excavators-LLC_index.json https://mr… 2933
#> 497 2024-07-01_A-Voice-LLC_index.json https://mr… 1565
#> 498 2024-07-01_A-W-SCHULTZ-INC_index.json https://mr… 1739
#> 499 2024-07-01_A-WATER-TIGHT-PLUMBING-AND-SEWER-SERVICE-INC_… https://mr… 1567
#> 500 2024-07-01_A-WAY-OF-WELLNESS-CHIROPRACTIC-LLC_index.json https://mr… 1565
#> 501 2024-07-01_A-WILBERTS-SONS-LLC_index.json https://mr… 1565
#> 502 2024-07-01_A-Z-Ventures-Inc_index.json https://mr… 1565
#> 503 2024-07-01_A-and-A-Stoneworks_index.json https://mr… 1565
#> 504 2024-07-01_A-and-B-Pipe-and-Supply-Inc_index.json https://mr… 1562
#> 505 2024-07-01_A-and-E-Holdings-LLC_index.json https://mr… 1565
#> 506 2024-07-01_A-and-G-Electrical-Technologies-Inc_index.json https://mr… 2977
#> 507 2024-07-01_A-and-G-Heating-and-Air-Conditioning-Inc_inde… https://mr… 1562
#> 508 2024-07-01_A-and-H-Cartage-Inc_index.json https://mr… 2087
#> 509 2024-07-01_A-and-H-Metals-Inc_index.json https://mr… 1739
#> 510 2024-07-01_A-and-J-Consulting-Engineering-Services-PC-_i… https://mr… 2656
#> 511 2024-07-01_A-and-K-Family-Farm-Inc_index.json https://mr… 1565
#> 512 2024-07-01_A-and-K-Transport-Inc_index.json https://mr… 1736
#> 513 2024-07-01_A-and-M-Developers-LLC_index.json https://mr… 1565
#> 514 2024-07-01_A-and-M-Equipment-LLC_index.json https://mr… 2977
#> 515 2024-07-01_A-and-S-Farms-LLC_index.json https://mr… 1565
#> 516 2024-07-01_A1-DISPOSAL-LLC_index.json https://mr… 2970
#> 517 2024-07-01_A1-ELECTRIC-MOTOR-SERVICE-INC_index.json https://mr… 1565
#> 518 2024-07-01_A1-FIBERGLASS-INC_index.json https://mr… 3151
#> 519 2024-07-01_A1-FLOOR-COVERING-INC_index.json https://mr… 1565
#> 520 2024-07-01_A1-Heating-and-Cooling-INC_index.json https://mr… 1739
#> 521 2024-07-01_A1-MILLWRIGHT-SERVICE-LLC_index.json https://mr… 2977
#> 522 2024-07-01_A1-PLUSSOFT-INC_index.json https://mr… 1565
#> 523 2024-07-01_A1-POLISHING-AND-FINISHING-LLC_index.json https://mr… 1565
#> 524 2024-07-01_A1-RESTORATION-INC_index.json https://mr… 1565
#> 525 2024-07-01_A1-SERVICE-INC_index.json https://mr… 1736
#> 526 2024-07-01_A1-SERVICES-INC_index.json https://mr… 1913
#> 527 2024-07-01_A1-TOOL-CORPORATION-GROUP-HEALTH-BENEFIT-PLAN… https://mr… 171
#> 528 2024-07-01_A1-TOOL-CORPORATION-GROUP-HEALTH-BENEFIT-PLAN… https://mr… 1005
#> 529 2024-07-01_A1exia-Inc_index.json https://mr… 1913
#> 530 2024-07-01_A2-Holdings-Inc_index.json https://mr… 1565
#> 531 2024-07-01_A2B-CARGO-INC_index.json https://mr… 1560
#> 532 2024-07-01_A2K-Logistics_index.json https://mr… 1739
#> 533 2024-07-01_A2N-INC_index.json https://mr… 1565
#> 534 2024-07-01_A4-CORPORATE-SERVICES-LLC-GROUP-HEALTH-BENEFI… https://mr… 171
#> 535 2024-07-01_A4-CORPORATE-SERVICES-LLC-GROUP-HEALTH-BENEFI… https://mr… 1598
#> 536 2024-07-01_A9-TRUCKING-ENTERPRISES-INC_index.json https://mr… 1562
#> 537 2024-07-01_AA-ANDERSON--CO-INC-GROUP-HEALTH-BENEFIT-PLAN… https://mr… 171
#> 538 2024-07-01_AA-ANDERSON--CO-INC-GROUP-HEALTH-BENEFIT-PLAN… https://mr… 1309
#> 539 2024-07-01_AA-ELECTRIC_index.json https://mr… 1565
#> 540 2024-07-01_AA-PORTER-LIGHTING-FIXTURE-CO-INC_index.json https://mr… 1913
#> 541 2024-07-01_AA-PRECISION-MACHINE-CO-INC_index.json https://mr… 1562
#> 542 2024-07-01_AA-RAYNER--SONS_index.json https://mr… 3323
#> 543 2024-07-01_AA-TEMPERATURE-CONTROLLED-LLC-GROUP-HEALTH-BE… https://mr… 171
#> 544 2024-07-01_AA-TEMPERATURE-CONTROLLED-LLC-GROUP-HEALTH-BE… https://mr… 1654
#> 545 2024-07-01_AAA-CLUB-ALLIANCE-INC-GROUP-BENEFIT-HEALTH-PL… https://mr… 666
#> 546 2024-07-01_AAA-CLUB-ALLIANCE-INC-GROUP-BENEFIT-HEALTH-PL… https://mr… 1603
#> 547 2024-07-01_AAA-CONCRETE-PRODUCTS-INC_index.json https://mr… 1565
#> 548 2024-07-01_AAA-Commercial-and-Residential_index.json https://mr… 1565
#> 549 2024-07-01_AAA-DISPOSAL-SERVICE-INC_index.json https://mr… 1739
#> 550 2024-07-01_AAA-DISTRIBUTION-SERVICES-INC_index.json https://mr… 2656
#> 551 2024-07-01_AAA-DISTRIBUTOR-LLC_index.json https://mr… 1739
#> 552 2024-07-01_AAA-DRILLING-FOUNDATION-INC_index.json https://mr… 1565
#> 553 2024-07-01_AAA-EVENT-SERVICES-LLC_index.json https://mr… 1910
#> 554 2024-07-01_AAA-FIRE-PROTECTION-INC_UHC-EPO-Gated-INN-Onl… https://mr… 185
#> 555 2024-07-01_AAA-FIRE-PROTECTION-INC_index.json https://mr… 4858
#> 556 2024-07-01_AAA-GREENE-BROTHERS-WELL-DRILL_index.json https://mr… 2977
#> 557 2024-07-01_AAA-NEWS-INC_index.json https://mr… 1739
#> 558 2024-07-01_AAA-NORTHGATE-HEATING-AND-AIR-LLC_index.json https://mr… 1565
#> 559 2024-07-01_AAA-Northeast_HARVARD-PILGRIM-CHOICE-PLUS-POS… https://mr… 184
#> 560 2024-07-01_AAA-Northeast_POS-CHOICE-PLUS_allowed-amounts… https://mr… 513
#> 561 2024-07-01_AAA-Northeast_index.json https://mr… 2608
#> 562 2024-07-01_AAA-QUALITY-APPLIANCE-CARE_index.json https://mr… 1739
#> 563 2024-07-01_AAA-SIGN-COMPANY-INC_index.json https://mr… 1735
#> 564 2024-07-01_AAA-SIGNS-LLC_index.json https://mr… 1913
#> 565 2024-07-01_AAA-TERMITE-AND-PEST-CONTROL-LLC_index.json https://mr… 2977
#> 566 2024-07-01_AAA-TREE-SERVICE-AND-LANDSCAPE_index.json https://mr… 4563
#> 567 2024-07-01_AAA-TRUCK-AGENCY-CORP_index.json https://mr… 1565
#> 568 2024-07-01_AAA-Virginia-Consulting_index.json https://mr… 1739
#> 569 2024-07-01_AAAG-HOLDINGS-INC-GROUP-HEALTH-BENEFIT-PLAN_A… https://mr… 639
#> 570 2024-07-01_AAAG-HOLDINGS-INC-GROUP-HEALTH-BENEFIT-PLAN_i… https://mr… 1585
#> 571 2024-07-01_AAAS-GROUP-HEALTH-BENEFIT-PLAN_AAAS-GROUP-HEA… https://mr… 171
#> 572 2024-07-01_AAAS-GROUP-HEALTH-BENEFIT-PLAN_index.json https://mr… 1245
#> 573 2024-07-01_AAC-AIR-AMBULANCE-CARIBBEAN_index.json https://mr… 1912
#> 574 2024-07-01_AACRON-INCORPORATED_index.json https://mr… 1739
#> 575 2024-07-01_AAI-Corporation_NATIONAL-PPO_allowed-amounts.… https://mr… 184
#> 576 2024-07-01_AAI-Corporation_POS-CHOICE-PLUS_allowed-amoun… https://mr… 184
#> 577 2024-07-01_AAI-Corporation_index.json https://mr… 4128
#> 578 2024-07-01_AAIA-Tampa-Bay-LLC_index.json https://mr… 1562
#> 579 2024-07-01_AAIM-Management-Services_index.json https://mr… 1565
#> 580 2024-07-01_AAL-Land-Surveying-Services_index.json https://mr… 1736
#> 581 2024-07-01_AALBERTS-HYDRONIC-FLOW-CONTROL-INC_index.json https://mr… 1739
#> 582 2024-07-01_AALCO-ATHLETIC-EQUIPMENT-AND_index.json https://mr… 1565
#> 583 2024-07-01_AAMSTRAND-ROPES-AND-TWINES-INC_index.json https://mr… 1734
#> 584 2024-07-01_AAN-RENTOOLS-INC_index.json https://mr… 1562
#> 585 2024-07-01_AAP-Inc_index.json https://mr… 1562
#> 586 2024-07-01_AARC-360_index.json https://mr… 1565
#> 587 2024-07-01_AARKAY-TECHNOLOGIES-INC_index.json https://mr… 1565
#> 588 2024-07-01_AARP-Employees-Welfare-Plan_NATIONAL-PPO_allo… https://mr… 184
#> 589 2024-07-01_AARP-Employees-Welfare-Plan_POS-CHOICE-PLUS_a… https://mr… 1621
#> 590 2024-07-01_AARP-Employees-Welfare-Plan_index.json https://mr… 2320
#> 591 2024-07-01_AARVIN-INSURANCE-SERVICES-LLC_index.json https://mr… 3465
#> 592 2024-07-01_AASAP-CONSTRUCTION-CO-INC_index.json https://mr… 1565
#> 593 2024-07-01_AAXION-INC_index.json https://mr… 2977
#> 594 2024-07-01_AB-BEVERAGE-CO-INC_AB-BEVERAGE-CO-INC_allowed… https://mr… 166
#> 595 2024-07-01_AB-BEVERAGE-CO-INC_index.json https://mr… 1213
#> 596 2024-07-01_AB-COASTER-LLC_index.json https://mr… 1562
#> 597 2024-07-01_AB-DATA-LTD-GROUP-HEALTH-BENEFIT-PLAN_AB-DATA… https://mr… 171
#> 598 2024-07-01_AB-DATA-LTD-GROUP-HEALTH-BENEFIT-PLAN_index.j… https://mr… 1540
#> 599 2024-07-01_AB-ROBERTS-CONSTRUCTION_index.json https://mr… 1565
#> 600 2024-07-01_AB-ROCK-CO_index.json https://mr… 1739
#> 601 2024-07-01_AB-Wealth_index.json https://mr… 1560
#> 602 2024-07-01_AB7-AMERICA-INC_index.json https://mr… 1562
#> 603 2024-07-01_ABA-CENTER-FOR-EXCELLENCE_United-Healthcare-E… https://mr… 185
#> 604 2024-07-01_ABA-CENTER-FOR-EXCELLENCE_index.json https://mr… 3423
#> 605 2024-07-01_ABA-Effects_index.json https://mr… 1909
#> 606 2024-07-01_ABA-MORIAH-CORPORATION_index.json https://mr… 1562
#> 607 2024-07-01_ABA-THERAPY-CENTER-LLC_index.json https://mr… 1565
#> 608 2024-07-01_ABACO-OPERATING-LLC_index.json https://mr… 1565
#> 609 2024-07-01_ABACUS-ARCHITECTS-INC_index.json https://mr… 2434
#> 610 2024-07-01_ABACUS-HARDWARE-LLC_index.json https://mr… 1913
#> 611 2024-07-01_ABACUS-THERAPIES-LLC_index.json https://mr… 1910
#> 612 2024-07-01_ABANTO-FORWARDING-INC_index.json https://mr… 3151
#> 613 2024-07-01_ABARE-KRESGE-AND-ASSOCIATES_index.json https://mr… 1910
#> 614 2024-07-01_ABATIX-CORPORATION-GROUP-BENEFIT-PLAN_ABATIX-… https://mr… 171
#> 615 2024-07-01_ABATIX-CORPORATION-GROUP-BENEFIT-PLAN_index.j… https://mr… 1592
#> 616 2024-07-01_ABB-CONCISE-OPTICAL-GROUP-LLC-GROUP-BENEFIT-P… https://mr… 651
#> 617 2024-07-01_ABB-CONCISE-OPTICAL-GROUP-LLC-GROUP-BENEFIT-P… https://mr… 1589
#> 618 2024-07-01_ABB-OPTICAL-GROUP-LLC-GROUP-HEALTH-BENEFIT-PL… https://mr… 651
#> 619 2024-07-01_ABB-OPTICAL-GROUP-LLC-GROUP-HEALTH-BENEFIT-PL… https://mr… 727
#> 620 2024-07-01_ABBA-TECHNOLOGIES-INC_index.json https://mr… 1565
#> 621 2024-07-01_ABBERIOR-INSTRUMENTS-AMERICA_index.json https://mr… 1913
#> 622 2024-07-01_ABBEY-ADAMS-BYELICK--MUELLER_index.json https://mr… 3150
#> 623 2024-07-01_ABBOTT-CLINIC-PA_index.json https://mr… 1562
#> 624 2024-07-01_ABBOTT-ENTERPRISES-LLC_index.json https://mr… 1913
#> 625 2024-07-01_ABBOTT-LABORATORIES-ABBOTT-GROUP-BENEFIT-PLAN… https://mr… 2472
#> 626 2024-07-01_ABBOTT-LABORATORIES-ABBOTT-GROUP-BENEFIT-PLAN… https://mr… 1609
#> 627 2024-07-01_ABBOTT-MINUTE-PRINTINGINC_index.json https://mr… 1560
#> 628 2024-07-01_ABBOTT-TELECOM-AND-SECURITY_index.json https://mr… 2082
#> 629 2024-07-01_ABBOTT-TOOL-AND-DIE-INC_index.json https://mr… 1565
#> 630 2024-07-01_ABBOTTS-PLUMBING-INC_index.json https://mr… 1562
#> 631 2024-07-01_ABC-AUTOS_index.json https://mr… 3151
#> 632 2024-07-01_ABC-BOX-CO-INC_index.json https://mr… 1565
#> 633 2024-07-01_ABC-CLEANING-INC_index.json https://mr… 1562
#> 634 2024-07-01_ABC-COMMERCIAL-GROUP-LLC_index.json https://mr… 1736
#> 635 2024-07-01_ABC-Fastener-Group-Inc_index.json https://mr… 1562
#> 636 2024-07-01_ABC-Fitness-Solutions-LLC_POS-CHOICE-PLUS_all… https://mr… 184
#> 637 2024-07-01_ABC-Fitness-Solutions-LLC_index.json https://mr… 1236
#> 638 2024-07-01_ABC-INDUSTRIES-INC_ABC-INDUSTRIES-INC_allowed… https://mr… 486
#> 639 2024-07-01_ABC-INDUSTRIES-INC_index.json https://mr… 1194
#> 640 2024-07-01_ABC-PLUMBING-LLC_index.json https://mr… 1562
#> 641 2024-07-01_ABC-Pest-Control-of-Pinellas-Inc_index.json https://mr… 1736
#> 642 2024-07-01_ABC-SAND-AND-ROCK-CO-INC_index.json https://mr… 1565
#> 643 2024-07-01_ABC-SOLUTIONS-LLC_index.json https://mr… 1562
#> 644 2024-07-01_ABC-TERMITE-AND-PEST-CONTROL_index.json https://mr… 1739
#> 645 2024-07-01_ABC-TOWING-AND--AUTO-WRECKING-LLC_index.json https://mr… 1565
#> 646 2024-07-01_ABD-DEVELOPMENT-CO_United-Healthcare-POS_allo… https://mr… 185
#> 647 2024-07-01_ABD-DEVELOPMENT-CO_index.json https://mr… 4834
#> 648 2024-07-01_ABDUL-W-KHAN-MD_United-Healthcare-POS_allowed… https://mr… 185
#> 649 2024-07-01_ABDUL-W-KHAN-MD_index.json https://mr… 1825
#> 650 2024-07-01_ABE-S-PLACE-LLC_index.json https://mr… 1565
#> 651 2024-07-01_ABEL-BROTHERS-TOWING-AND-AUTOMOTIVE_index.json https://mr… 1562
#> 652 2024-07-01_ABEL-MACHINE-LLC_index.json https://mr… 1565
#> 653 2024-07-01_ABEL-SCHILLINGER-LLP_index.json https://mr… 1913
#> 654 2024-07-01_ABEL-UNLIMITED-INC_index.json https://mr… 1739
#> 655 2024-07-01_ABELES-AND-HOFFMAN_index.json https://mr… 1913
#> 656 2024-07-01_ABELL-LLC-GROUP-HEALTH-BENEFIT-PLAN_ABELL-LLC… https://mr… 171
#> 657 2024-07-01_ABELL-LLC-GROUP-HEALTH-BENEFIT-PLAN_index.json https://mr… 1241
#> 658 2024-07-01_ABEO-SOLUTIONS-INC_index.json https://mr… 1913
#> 659 2024-07-01_ABERCROMBIE-P-A_United-Healthcare-POS_allowed… https://mr… 185
#> 660 2024-07-01_ABERCROMBIE-P-A_index.json https://mr… 3245
#> 661 2024-07-01_ABERCROMBIE-UNDERGROUND-SOLUTIONS-LLC_index.j… https://mr… 1565
#> 662 2024-07-01_ABERDEEN-ADVISORS-LLC_index.json https://mr… 1565
#> 663 2024-07-01_ABERDEEN-PATE-WATER-CO-INC_index.json https://mr… 1565
#> 664 2024-07-01_ABERNETHY-AND-COMPANY-PC_index.json https://mr… 1739
#> 665 2024-07-01_ABF--ROMCare-Health-Services_index.json https://mr… 1562
#> 666 2024-07-01_ABH-HOLDINGS-LLC_index.json https://mr… 1565
#> 667 2024-07-01_ABI-ARBOR-INC_index.json https://mr… 2258
#> 668 2024-07-01_ABIDE-TRUCKING-INC_index.json https://mr… 1565
#> 669 2024-07-01_ABILITY-PLUS-DRAINAGE-CO_index.json https://mr… 1913
#> 670 2024-07-01_ABL-Brands-Inc_index.json https://mr… 3673
#> 671 2024-07-01_ABL-Decorating-and-Remodeling_index.json https://mr… 3149
#> 672 2024-07-01_ABLE-CITY-LLC_index.json https://mr… 2087
#> 673 2024-07-01_ABLE-GLASS-AND-MIRROR-CO-INC_index.json https://mr… 4568
#> 674 2024-07-01_ABLELIGHT-GROUP-BENEFIT-PLAN_ABLELIGHT-GROUP-… https://mr… 171
#> 675 2024-07-01_ABLELIGHT-GROUP-BENEFIT-PLAN_index.json https://mr… 1298
#> 676 2024-07-01_ABLES-MECHANICAL-LLC_index.json https://mr… 2983
#> 677 2024-07-01_ABM-BY-PRODEX-LLC_index.json https://mr… 1913
#> 678 2024-07-01_ABM-INDUSTRIES-INCORPORATED_ABM-INDUSTRIES-IN… https://mr… 166
#> 679 2024-07-01_ABM-INDUSTRIES-INCORPORATED_index.json https://mr… 1255
#> 680 2024-07-01_ABM-INSURANCE--BENEFIT-SERVICES-INC_index.json https://mr… 3330
#> 681 2024-07-01_ABM-Industries-Incorporated_NATIONAL-PPO_allo… https://mr… 184
#> 682 2024-07-01_ABM-Industries-Incorporated_POS-CHOICE-PLUS_a… https://mr… 566
#> 683 2024-07-01_ABM-Industries-Incorporated_index.json https://mr… 3542
#> 684 2024-07-01_ABM_index.json https://mr… 1676
#> 685 2024-07-01_ABNS-GROUP-LLC_index.json https://mr… 1562
#> 686 2024-07-01_ABODE-INC_index.json https://mr… 3498
#> 687 2024-07-01_ABOUND-FEDERAL-CREDIT-UNION-GROUP-HEALTH-BENE… https://mr… 171
#> 688 2024-07-01_ABOUND-FEDERAL-CREDIT-UNION-GROUP-HEALTH-BENE… https://mr… 1317
#> 689 2024-07-01_ABOUT-PLUMBING-INC_index.json https://mr… 1560
#> 690 2024-07-01_ABOVE-ALL-CAULKING-AND-WATERPROOFING-INC_inde… https://mr… 3151
#> 691 2024-07-01_ABOVE-AND-BELOW-CONTRACTING_index.json https://mr… 1739
#> 692 2024-07-01_ABOVE-AND-BEYOND-COMPLETE-GROUNDS-MAINTENANCE… https://mr… 1561
#> 693 2024-07-01_ABOVE-AND-BEYOND-DELIVERY_index.json https://mr… 1913
#> 694 2024-07-01_ABOVE-AND-BEYOND-ELECTRIC_index.json https://mr… 1739
#> 695 2024-07-01_ABOVE-AND-BEYOND-SERVICES-LLC_index.json https://mr… 3325
#> 696 2024-07-01_ABOVE-GROUP-INC_index.json https://mr… 1562
#> 697 2024-07-01_ABRACON-LLC_ABRACON-LLC_allowed-amounts.json.… https://mr… 166
#> 698 2024-07-01_ABRACON-LLC_index.json https://mr… 923
#> 699 2024-07-01_ABRAHAM-WATKINS-NICHOLS_index.json https://mr… 1565
#> 700 2024-07-01_ABRAHAMSE-AND-COMPANY-BUILDERS-INC_index.json https://mr… 1736
#> 701 2024-07-01_ABRAHAMSON-LLC_United-Healthcare-POS_allowed-… https://mr… 182
#> 702 2024-07-01_ABRAHAMSON-LLC_index.json https://mr… 5709
#> 703 2024-07-01_ABRAMS-PHARMACY-INC_index.json https://mr… 1565
#> 704 2024-07-01_ABRASIVE-TECHNOLOGY-INC-GROUP-HEALTH-BENEFIT-… https://mr… 171
#> 705 2024-07-01_ABRASIVE-TECHNOLOGY-INC-GROUP-HEALTH-BENEFIT-… https://mr… 1586
#> 706 2024-07-01_ABRASIVES-SOUTH-INC_index.json https://mr… 1565
#> 707 2024-07-01_ABS-Healthcare-Services-LLC_index.json https://mr… 3151
#> 708 2024-07-01_ABSOLUTE-CAULKING-AND-WATERPROOFING-INC_index… https://mr… 2977
#> 709 2024-07-01_ABSOLUTE-CONSTRUCTION_index.json https://mr… 1913
#> 710 2024-07-01_ABSOLUTE-GRINDING_United-Healthcare-POS_allow… https://mr… 520
#> 711 2024-07-01_ABSOLUTE-GRINDING_index.json https://mr… 3247
#> 712 2024-07-01_ABSOLUTE-PHARMACY-LLC_index.json https://mr… 3151
#> 713 2024-07-01_ABSOLUTE-POS-LLC_index.json https://mr… 1913
#> 714 2024-07-01_ABSOLUTE-PS-INC_index.json https://mr… 1565
#> 715 2024-07-01_ABSOLUTE-STORAGE-LLC_index.json https://mr… 1562
#> 716 2024-07-01_ABSOLUTE-SYSTEMS-ENGINEERING_index.json https://mr… 1562
#> 717 2024-07-01_ABSOLUTE-TURN-INC_index.json https://mr… 3146
#> 718 2024-07-01_ABSOLUTE-WASTE-MANAGEMENT-LLC_index.json https://mr… 1739
#> 719 2024-07-01_ABSOLUTE-WELLNESS-CENTER-LLC_index.json https://mr… 2258
#> 720 2024-07-01_ABSOLUTE-WINDOW-LLC_United-Healthcare-EPO_all… https://mr… 185
#> 721 2024-07-01_ABSOLUTE-WINDOW-LLC_index.json https://mr… 3417
#> 722 2024-07-01_ABSOLUTELY-AMAZING-REFINISHING_index.json https://mr… 1910
#> 723 2024-07-01_ABSOLUTELY-DRY-LLC_index.json https://mr… 1560
#> 724 2024-07-01_ABSOLUTELY-FISH-INC_index.json https://mr… 2656
#> 725 2024-07-01_ABSOLUTELY-NATURAL-INC_index.json https://mr… 1736
#> 726 2024-07-01_ABSS-TECHNOLOGIES-CORPORATION_index.json https://mr… 2656
#> 727 2024-07-01_ABSTRACT-CONSTRUCTION-COMPANY_index.json https://mr… 3151
#> 728 2024-07-01_ABSTRACT-ELECTRIC-LLC_index.json https://mr… 1562
#> 729 2024-07-01_ABSTRACT-ELECTRONICS-INC_index.json https://mr… 1913
#> 730 2024-07-01_ABUCK-Building-Systems-Inc_index.json https://mr… 1739
#> 731 2024-07-01_ABUCK-INC_index.json https://mr… 1739
#> 732 2024-07-01_ABUNDANCE-ENERGY-SERVICES-LLC_index.json https://mr… 1739
#> 733 2024-07-01_ABUNDANT-STAFFING-LLC_index.json https://mr… 2087
#> 734 2024-07-01_ABX-Air-Inc_NATIONAL-PPO_allowed-amounts.json… https://mr… 184
#> 735 2024-07-01_ABX-Air-Inc_POS-CHOICE-PLUS_allowed-amounts.j… https://mr… 184
#> 736 2024-07-01_ABX-Air-Inc_index.json https://mr… 2288
#> 737 2024-07-01_AC-AND-DESIGN-PROFESSIONALS_index.json https://mr… 1562
#> 738 2024-07-01_AC-BEVERAGE-INC_index.json https://mr… 1562
#> 739 2024-07-01_AC-Bell-Mar-LLC_index.json https://mr… 1565
#> 740 2024-07-01_AC-CONTROLS-COMPANY-INC-GROUP-HEALTH-BENEFIT-… https://mr… 171
#> 741 2024-07-01_AC-CONTROLS-COMPANY-INC-GROUP-HEALTH-BENEFIT-… https://mr… 1586
#> 742 2024-07-01_AC-DC-SYNERGY-GROUP-INC_index.json https://mr… 1562
#> 743 2024-07-01_AC-DISTRIBUTION-INC_index.json https://mr… 3151
#> 744 2024-07-01_AC-ELECTRICAL-SYSTEMS-INC_index.json https://mr… 1913
#> 745 2024-07-01_AC-EQUIPMENT-RENTAL-INC_index.json https://mr… 1910
#> 746 2024-07-01_AC-EQUIPMENT-REPRESENTATIVES_index.json https://mr… 1562
#> 747 2024-07-01_AC-HEAT-EXPERTS-LLC_index.json https://mr… 3334
#> 748 2024-07-01_AC-MANAGEMENT-GROUP-LLC_index.json https://mr… 3334
#> 749 2024-07-01_AC-NELSEN-ENTERPRISES-INC_AC-NELSEN-ENTERPRIS… https://mr… 166
#> 750 2024-07-01_AC-NELSEN-ENTERPRISES-INC_index.json https://mr… 1222
#> 751 2024-07-01_AC-SYSTEMS-OF-JACKSONVILLE-INC_index.json https://mr… 1565
#> 752 2024-07-01_AC-TOOL-AND-MACHINE-CO-INC_index.json https://mr… 1736
#> 753 2024-07-01_AC-Trucking-INC_index.json https://mr… 2971
#> 754 2024-07-01_ACACIA--LLC_index.json https://mr… 1736
#> 755 2024-07-01_ACADEMIC-ANSWERS-LLC_index.json https://mr… 1565
#> 756 2024-07-01_ACADEMIC-DEVELOPMENT-INSTITUTE_index.json https://mr… 2261
#> 757 2024-07-01_ACADEMY-INC_index.json https://mr… 1734
#> 758 2024-07-01_ACADEMY-MORTGAGE-CORPORATION_ACADEMY-MORTGAGE… https://mr… 544
#> 759 2024-07-01_ACADEMY-MORTGAGE-CORPORATION_index.json https://mr… 1259
#> 760 2024-07-01_ACADEMY-OF-TRUCK-ACCIDENT-ATTORNEYS_index.json https://mr… 1565
#> 761 2024-07-01_ACADEMY-ROOFING-INC_United-Healthcare-EPO_all… https://mr… 185
#> 762 2024-07-01_ACADEMY-ROOFING-INC_index.json https://mr… 3252
#> 763 2024-07-01_ACADIA-PARISH-SHERIFFS-OFFICE-GROUP-HEALTH-BE… https://mr… 171
#> 764 2024-07-01_ACADIA-PARISH-SHERIFFS-OFFICE-GROUP-HEALTH-BE… https://mr… 1615
#> 765 2024-07-01_ACADIAN-CYPRESS-AND-HARDWOODS_index.json https://mr… 1565
#> 766 2024-07-01_ACADIAN-GROUP_index.json https://mr… 3151
#> 767 2024-07-01_ACADIAN-WINDOWS-AND-SIDING-LLC_UHC-POS-Non-Ga… https://mr… 185
#> 768 2024-07-01_ACADIAN-WINDOWS-AND-SIDING-LLC_index.json https://mr… 3913
#> 769 2024-07-01_ACADIANA-OILFIELD-INSTRUMENTS_index.json https://mr… 1739
#> 770 2024-07-01_ACARIA-INC_index.json https://mr… 3151
#> 771 2024-07-01_ACC10-INC_United-Healthcare-EPO_allowed-amoun… https://mr… 185
#> 772 2024-07-01_ACC10-INC_index.json https://mr… 1821
#> 773 2024-07-01_ACCEL-COMPRESSION-INC_index.json https://mr… 1565
#> 774 2024-07-01_ACCEL-CONSTRUCTION-SERVICES-GR_index.json https://mr… 3334
#> 775 2024-07-01_ACCEL-CONSULTING-LLC_index.json https://mr… 1565
#> 776 2024-07-01_ACCEL-FUSION-LLC_index.json https://mr… 1565
#> 777 2024-07-01_ACCEL-PHYSICAL-THERAPY_index.json https://mr… 1913
#> 778 2024-07-01_ACCELERATED-ANALYTICAL-LABORATORIES_index.json https://mr… 1741
#> 779 2024-07-01_ACCELERATED-CLINICAL-TRIALS-LL_index.json https://mr… 1565
#> 780 2024-07-01_ACCELERATED-CONSTRUCTION_index.json https://mr… 1562
#> 781 2024-07-01_ACCELERATED-RECOVERY-CENTERS-LLC_index.json https://mr… 1565
#> 782 2024-07-01_ACCELERATION-LABORATORY-SERVICES-INC_index.js… https://mr… 1739
#> 783 2024-07-01_ACCELERON-INC_index.json https://mr… 3182
#> 784 2024-07-01_ACCELERX-LTD_index.json https://mr… 1913
#> 785 2024-07-01_ACCENT-BUSINESS-PRODUCTS-OF_index.json https://mr… 3151
#> 786 2024-07-01_ACCENT-COATINGS-LLC_index.json https://mr… 1565
#> 787 2024-07-01_ACCENT-CREATIVE-GROUP-LLC_index.json https://mr… 1562
#> 788 2024-07-01_ACCENT-HOME-SERVICES_index.json https://mr… 1912
#> 789 2024-07-01_ACCENT-TECHNOLOGIES_index.json https://mr… 3325
#> 790 2024-07-01_ACCENTCARE-INC_ACCENTCARE-INC_allowed-amounts… https://mr… 595
#> 791 2024-07-01_ACCENTCARE-INC_index.json https://mr… 1193
#> 792 2024-07-01_ACCENTURE-LLP_ACCENTURE-LLP_allowed-amounts.j… https://mr… 1276
#> 793 2024-07-01_ACCENTURE-LLP_index.json https://mr… 1213
#> 794 2024-07-01_ACCEPTANCE-HOME-MORTGAGE-LLC_index.json https://mr… 1736
#> 795 2024-07-01_ACCESS-COMBUSTION-LLC_index.json https://mr… 1739
#> 796 2024-07-01_ACCESS-ELEVATOR-INC_index.json https://mr… 1741
#> 797 2024-07-01_ACCESS-FIRE-AND-SECURITY_index.json https://mr… 1909
#> 798 2024-07-01_ACCESS-HEALTH-LOUISIANA-GROUP-HEALTH-BENEFIT-… https://mr… 171
#> 799 2024-07-01_ACCESS-HEALTH-LOUISIANA-GROUP-HEALTH-BENEFIT-… https://mr… 1305
#> 800 2024-07-01_ACCESS-HOME-HEALTH-INC_index.json https://mr… 1565
#> 801 2024-07-01_ACCESS-MD-_index.json https://mr… 1913
#> 802 2024-07-01_ACCESS-MOBILITY-INC_index.json https://mr… 1736
#> 803 2024-07-01_ACCESS-RECEIVABLES_index.json https://mr… 3151
#> 804 2024-07-01_ACCESS-TELECOM-GROUP-INC_index.json https://mr… 1562
#> 805 2024-07-01_ACCESSIBILITY-SERVICES-INC_United-Healthcare-… https://mr… 185
#> 806 2024-07-01_ACCESSIBILITY-SERVICES-INC_index.json https://mr… 3424
#> 807 2024-07-01_ACCESSO-LLC-GROUP-HEALTH-BENEFIT-PLAN_ACCESSO… https://mr… 738
#> 808 2024-07-01_ACCESSO-LLC-GROUP-HEALTH-BENEFIT-PLAN_index.j… https://mr… 1285
#> 809 2024-07-01_ACCESSORIES-DISTRIBUTION_index.json https://mr… 3325
#> 810 2024-07-01_ACCESSORIES-UNLIMITED-INC_index.json https://mr… 1736
#> 811 2024-07-01_ACCION-REHABILITATION-INC_index.json https://mr… 1565
#> 812 2024-07-01_ACCLIVITY-HEALTH-SOLUTIONS-INC_index.json https://mr… 1739
#> 813 2024-07-01_ACCORDIA-GROUP-LLC_index.json https://mr… 2661
#> 814 2024-07-01_ACCOUNT-CONSULTING-LLC_index.json https://mr… 1739
#> 815 2024-07-01_ACCOUNTFULLY-LLC_index.json https://mr… 1739
#> 816 2024-07-01_ACCOUNTING-ADVISORS-LTD_index.json https://mr… 1565
#> 817 2024-07-01_ACCOUNTING-SEED_index.json https://mr… 1739
#> 818 2024-07-01_ACCOUNTS-RECEIVABLE-MANAGEMENT_index.json https://mr… 1562
#> 819 2024-07-01_ACCRA-FAB-INC-GROUP-HEALTH-BENEFIT-PLAN_ACCRA… https://mr… 171
#> 820 2024-07-01_ACCRA-FAB-INC-GROUP-HEALTH-BENEFIT-PLAN_index… https://mr… 1562
#> 821 2024-07-01_ACCREDITED-DATA-CENTERS-INC_index.json https://mr… 2980
#> 822 2024-07-01_ACCRETE-CONSTRUCTION-LLC_index.json https://mr… 1562
#> 823 2024-07-01_ACCRON-LP_index.json https://mr… 1565
#> 824 2024-07-01_ACCU-BRAND-LLC_index.json https://mr… 1739
#> 825 2024-07-01_ACCU-LABS-INC_index.json https://mr… 4914
#> 826 2024-07-01_ACCU-STAMPING-AND_index.json https://mr… 1567
#> 827 2024-07-01_ACCUBILT-AUTOMATED-SYSTEMS-LLC_index.json https://mr… 1562
#> 828 2024-07-01_ACCUCARE-HOME-HEALTH-CARE-OF-S_index.json https://mr… 1739
#> 829 2024-07-01_ACCUCHEM-COMMERCIAL-RESOURCES_index.json https://mr… 1739
#> 830 2024-07-01_ACCUCOM-CONSULTING-INC_index.json https://mr… 2834
#> 831 2024-07-01_ACCUCOM-GROUP-LLC_index.json https://mr… 1565
#> 832 2024-07-01_ACCUDYNAMICS-LLC_index.json https://mr… 2983
#> 833 2024-07-01_ACCUFAB-INC_index.json https://mr… 3151
#> 834 2024-07-01_ACCUMAX-AUTO-PARTS_index.json https://mr… 1565
#> 835 2024-07-01_ACCUMED-BILLING-INC_ACCUMED-BILLING-INC_allow… https://mr… 166
#> 836 2024-07-01_ACCUMED-BILLING-INC_index.json https://mr… 1198
#> 837 2024-07-01_ACCURA-ENGINEERING-AND-CONSULTING-SERVICES-IN… https://mr… 1739
#> 838 2024-07-01_ACCURATE-ALARM-SYSTEMS-CORP_index.json https://mr… 3213
#> 839 2024-07-01_ACCURATE-ELECTRICAL-CONNECTION_index.json https://mr… 1562
#> 840 2024-07-01_ACCURATE-ENVIRONMENTAL-LLC_index.json https://mr… 1736
#> 841 2024-07-01_ACCURATE-EQUIPMENT-SALES-INC_index.json https://mr… 1565
#> 842 2024-07-01_ACCURATE-EYE-CARE-LLC_index.json https://mr… 1565
#> 843 2024-07-01_ACCURATE-LAND-TITLE-CO-LLC_index.json https://mr… 1565
#> 844 2024-07-01_ACCURATE-LASER-SYSTEMS_index.json https://mr… 1736
#> 845 2024-07-01_ACCURATE-MANAGEMENT_index.json https://mr… 1736
#> 846 2024-07-01_ACCURATE-MEASUREMENT-CONTROLS_index.json https://mr… 1913
#> 847 2024-07-01_ACCURATE-MECHANICAL-LLC_index.json https://mr… 1565
#> 848 2024-07-01_ACCURATE-PATTERN-INC_index.json https://mr… 1736
#> 849 2024-07-01_ACCURATE-PEST-CONTROL-COMPANY_index.json https://mr… 1736
#> 850 2024-07-01_ACCURATE-PLUMBING-SOLUTIONS-INC_index.json https://mr… 1562
#> 851 2024-07-01_ACCURATE-PRINTING-INC_index.json https://mr… 1739
#> 852 2024-07-01_ACCURATE-SEPTIC-SERVICES-INC_index.json https://mr… 1565
#> 853 2024-07-01_ACCURATE-SUPERIOR-SCALE_index.json https://mr… 1847
#> 854 2024-07-01_ACCURITE-MACHINE-AND-MANUFACTURING-INC_index.… https://mr… 1565
#> 855 2024-07-01_ACCUSEARCH-INC_index.json https://mr… 2086
#> 856 2024-07-01_ACCUSENTRY-INC_index.json https://mr… 1565
#> 857 2024-07-01_ACCUSOURCE-ELECTRONICS-INC_index.json https://mr… 1565
#> 858 2024-07-01_ACCUTRENCH-CONTRACTING-LLC_index.json https://mr… 1909
#> 859 2024-07-01_ACE-ANODIZING-LLC_index.json https://mr… 1565
#> 860 2024-07-01_ACE-CONSULTING-LLC_index.json https://mr… 1565
#> 861 2024-07-01_ACE-CORPORATE-SUPPORT-INC-EMPLOYEE-BENEFIT-PL… https://mr… 171
#> 862 2024-07-01_ACE-CORPORATE-SUPPORT-INC-EMPLOYEE-BENEFIT-PL… https://mr… 1294
#> 863 2024-07-01_ACE-ELECTRIC-INC-GROUP-HEALTH-BENEFIT-PLAN_AC… https://mr… 171
#> 864 2024-07-01_ACE-ELECTRIC-INC-GROUP-HEALTH-BENEFIT-PLAN_in… https://mr… 1583
#> 865 2024-07-01_ACE-HARDWARE-NO-152-CORP_index.json https://mr… 1562
#> 866 2024-07-01_ACE-PATTERN-AND-FOUNDRY-OF-KANSAS-INC_index.j… https://mr… 1565
#> 867 2024-07-01_ACE-REFRIGERATION-HEATING-AND-COOLING-LLC_ind… https://mr… 1565
#> 868 2024-07-01_ACE-RELOCATION-SYSTEMS-INC_ACE-RELOCATION-SYS… https://mr… 166
#> 869 2024-07-01_ACE-RELOCATION-SYSTEMS-INC_index.json https://mr… 1510
#> 870 2024-07-01_ACE-RENT-A-CAR-RESERVATIONS_index.json https://mr… 1565
#> 871 2024-07-01_ACE-SIGN-DISPLAYS-INC-DBA_index.json https://mr… 1565
#> 872 2024-07-01_ACE-TECH-COMPUTERS_index.json https://mr… 1910
#> 873 2024-07-01_ACE-TRUCK-OF-WV_index.json https://mr… 2977
#> 874 2024-07-01_ACE-UNIFORM-VIRGINIA-INC_index.json https://mr… 1562
#> 875 2024-07-01_ACEAVANT-CONCRETE-CONSTRUCTION-COMPANY-INC-GR… https://mr… 171
#> 876 2024-07-01_ACEAVANT-CONCRETE-CONSTRUCTION-COMPANY-INC-GR… https://mr… 1662
#> 877 2024-07-01_ACEINNA-INC_index.json https://mr… 1565
#> 878 2024-07-01_ACEJAN-CAPITAL-LLC_index.json https://mr… 2834
#> 879 2024-07-01_ACELERO-INC-GROUP-HEALTH-BENEFIT-PLAN_ACELERO… https://mr… 171
#> 880 2024-07-01_ACELERO-INC-GROUP-HEALTH-BENEFIT-PLAN_index.j… https://mr… 1252
#> 881 2024-07-01_ACERO-BELLA-INC_index.json https://mr… 1565
#> 882 2024-07-01_ACEROS-AMERICA-PORT-MANATEE-LLC_index.json https://mr… 1565
#> 883 2024-07-01_ACF-001-LLC_index.json https://mr… 2021
#> 884 2024-07-01_ACG-Professionals-Inc_index.json https://mr… 1913
#> 885 2024-07-01_ACHIEVA-CREDIT-UNION-GROUP-HEALTH-BENEFIT-PLA… https://mr… 171
#> 886 2024-07-01_ACHIEVA-CREDIT-UNION-GROUP-HEALTH-BENEFIT-PLA… https://mr… 1627
#> 887 2024-07-01_ACHIEVE-WELLNESS-LLC_index.json https://mr… 2977
#> 888 2024-07-01_ACHIEVING-YOUR-BEST_index.json https://mr… 1565
#> 889 2024-07-01_ACI-Worldwide_POS-CHOICE-PLUS_allowed-amounts… https://mr… 184
#> 890 2024-07-01_ACI-Worldwide_PREFERRED-PROVIDER_allowed-amou… https://mr… 184
#> 891 2024-07-01_ACI-Worldwide_index.json https://mr… 3958
#> 892 2024-07-01_ACID-AND-CEMENTING-SERVICES-IN_index.json https://mr… 1565
#> 893 2024-07-01_ACIERNO-AND-COMPANY_index.json https://mr… 1910
#> 894 2024-07-01_ACJK-CORPORATION_index.json https://mr… 2975
#> 895 2024-07-01_ACKERMAN-OIL_ACKERMAN-OIL_allowed-amounts.jso… https://mr… 171
#> 896 2024-07-01_ACKERMAN-OIL_index.json https://mr… 1194
#> 897 2024-07-01_ACKLAM-INC_index.json https://mr… 4762
#> 898 2024-07-01_ACLSA-LLC_United-Healthcare-EPO_allowed-amoun… https://mr… 185
#> 899 2024-07-01_ACLSA-LLC_index.json https://mr… 3581
#> 900 2024-07-01_ACM-Colon-and-Rectal-AssociatePLLC_index.json https://mr… 1736
#> 901 2024-07-01_ACM-ENGINEERING-AND-ENVIRONMENTAL-SERVICES-IN… https://mr… 1565
#> 902 2024-07-01_ACME-AUTO-PARTS-INC_index.json https://mr… 1560
#> 903 2024-07-01_ACME-DOCK-SPECIALISTS-INC_index.json https://mr… 1739
#> 904 2024-07-01_ACME-FLOOR-COMPANY-INC_index.json https://mr… 1565
#> 905 2024-07-01_ACME-GLASS-COMPANY-INC_index.json https://mr… 1565
#> 906 2024-07-01_ACME-GLOBAL-INDUSTRIES-INC_index.json https://mr… 1565
#> 907 2024-07-01_ACME-GRINDING-AND-MANUFACTURING-INC_index.json https://mr… 1562
#> 908 2024-07-01_ACME-MECHANICAL-CONTRACTORS-OF-VIRGINIA-INC-G… https://mr… 171
#> 909 2024-07-01_ACME-MECHANICAL-CONTRACTORS-OF-VIRGINIA-INC-G… https://mr… 1666
#> 910 2024-07-01_ACME-Machine-Works-Inc_index.json https://mr… 1739
#> 911 2024-07-01_ACME-TRUCK-LINE-INC-GROUP-HEALTH-BENEFIT-PLAN… https://mr… 171
#> 912 2024-07-01_ACME-TRUCK-LINE-INC-GROUP-HEALTH-BENEFIT-PLAN… https://mr… 1282
#> 913 2024-07-01_ACME-WIRE-PRODUCTS-COMPANY-INC_index.json https://mr… 2660
#> 914 2024-07-01_ACO-Insurance-Group_index.json https://mr… 3151
#> 915 2024-07-01_ACORN-NILES-CORPORATION_index.json https://mr… 3845
#> 916 2024-07-01_ACORN-STAIRLIFTS-INC-GROUP-HEALTH-BENEFIT-PLA… https://mr… 171
#> 917 2024-07-01_ACORN-STAIRLIFTS-INC-GROUP-HEALTH-BENEFIT-PLA… https://mr… 1574
#> 918 2024-07-01_ACOUSTIC-DESIGNS-INC_index.json https://mr… 6000
#> 919 2024-07-01_ACOUSTICS-INC_index.json https://mr… 1565
#> 920 2024-07-01_ACP-Realty-Services-LLC_index.json https://mr… 1739
#> 921 2024-07-01_ACPDO-MANAGEMENT-INC_index.json https://mr… 1912
#> 922 2024-07-01_ACQUEON-TECHNOLOGIES-INC_index.json https://mr… 2835
#> 923 2024-07-01_ACQUEST-PROPERTY-GROUP-LLC_index.json https://mr… 1562
#> 924 2024-07-01_ACQUIRED-DATA-SOLUTIONS-INC_index.json https://mr… 1739
#> 925 2024-07-01_ACQUISITION-MANAGEMENT-LLC_index.json https://mr… 1565
#> 926 2024-07-01_ACR-Homes-Inc_POS-CHOICE-PLUS_allowed-amounts… https://mr… 184
#> 927 2024-07-01_ACR-Homes-Inc_index.json https://mr… 1224
#> 928 2024-07-01_ACR-SALES-AND-SERVICE-INC_index.json https://mr… 2084
#> 929 2024-07-01_ACR-of-Sedalia-Inc_index.json https://mr… 1739
#> 930 2024-07-01_ACRA-ELECTRIC-INC_index.json https://mr… 1913
#> 931 2024-07-01_ACRE-Development-Partners-LLC_index.json https://mr… 1565
#> 932 2024-07-01_ACRO-METAL-STAMPING_index.json https://mr… 1567
#> 933 2024-07-01_ACROSS-THE-BOARD-THERAPY-GROUP_index.json https://mr… 2083
#> 934 2024-07-01_ACROTECH-INC_index.json https://mr… 1565
#> 935 2024-07-01_ACS-AUTO-PARTS-OF-GEORGIA-LLCMARK-PTOLOMEY_in… https://mr… 1910
#> 936 2024-07-01_ACS-Architectural-Construction-Service-Inc_in… https://mr… 1565
#> 937 2024-07-01_ACS-DOCUMENT-IMAGING-INC_index.json https://mr… 1565
#> 938 2024-07-01_ACS-Group_POS-CHOICE-PLUS_allowed-amounts.jso… https://mr… 184
#> 939 2024-07-01_ACS-Group_index.json https://mr… 1220
#> 940 2024-07-01_ACS-Industries-Inc_index.json https://mr… 3151
#> 941 2024-07-01_ACS-JSM-LLC_index.json https://mr… 1913
#> 942 2024-07-01_ACS-LLC_index.json https://mr… 1565
#> 943 2024-07-01_ACS-LOGISTICS-HOLDINGS-LLC_index.json https://mr… 1913
#> 944 2024-07-01_ACS-TESTING-INC_index.json https://mr… 1913
#> 945 2024-07-01_ACSBLDR-INC_index.json https://mr… 1739
#> 946 2024-07-01_ACSM-INC_index.json https://mr… 4082
#> 947 2024-07-01_ACT-Dental-Practice-Coaching-Corporation_inde… https://mr… 1739
#> 948 2024-07-01_ACT-FOR-HEALTH-DBA-PROFESSIONAL-CASE-MANAGEME… https://mr… 166
#> 949 2024-07-01_ACT-FOR-HEALTH-DBA-PROFESSIONAL-CASE-MANAGEME… https://mr… 1031
#> 950 2024-07-01_ACT-PIPE--SUPPLY-INC_ACT-PIPE--SUPPLY-INC_all… https://mr… 166
#> 951 2024-07-01_ACT-PIPE--SUPPLY-INC_index.json https://mr… 1203
#> 952 2024-07-01_ACT-UNDERGROUND-LLC_United-Healthcare-EPO_all… https://mr… 185
#> 953 2024-07-01_ACT-UNDERGROUND-LLC_index.json https://mr… 3426
#> 954 2024-07-01_ACT-WEALTH-MANAGEMENT-LLC_index.json https://mr… 1565
#> 955 2024-07-01_ACTION-AIR-INC_index.json https://mr… 1562
#> 956 2024-07-01_ACTION-AMBULANCE-SERVICE-INC_ACTION-AMBULANCE… https://mr… 185
#> 957 2024-07-01_ACTION-AMBULANCE-SERVICE-INC_index.json https://mr… 683
#> 958 2024-07-01_ACTION-DEVELOPMENT-CORPORATION_index.json https://mr… 1565
#> 959 2024-07-01_ACTION-ELECTRICAL-SERVICES-INC_index.json https://mr… 1562
#> 960 2024-07-01_ACTION-ELECTRIC_index.json https://mr… 1562
#> 961 2024-07-01_ACTION-FIRE-AND-ALARM-INC_index.json https://mr… 1565
#> 962 2024-07-01_ACTION-GLASS-INC_index.json https://mr… 1562
#> 963 2024-07-01_ACTION-INTEGRATED-MARKETING_index.json https://mr… 1565
#> 964 2024-07-01_ACTION-LIFT-INC_index.json https://mr… 1736
#> 965 2024-07-01_ACTION-MACHINE-INC_index.json https://mr… 1562
#> 966 2024-07-01_ACTION-MENS-HEALTH_index.json https://mr… 3151
#> 967 2024-07-01_ACTION-PIG-CO_index.json https://mr… 1565
#> 968 2024-07-01_ACTION-PLATING-CORP_index.json https://mr… 1562
#> 969 2024-07-01_ACTION-PROPANE_index.json https://mr… 1565
#> 970 2024-07-01_ACTION-SEATING--MOBILITY_ACTION-SEATING--MOBI… https://mr… 166
#> 971 2024-07-01_ACTION-SEATING--MOBILITY_index.json https://mr… 1217
#> 972 2024-07-01_ACTIVATE-FOOD-ARIZONA_index.json https://mr… 1739
#> 973 2024-07-01_ACTIVE-DEPLOYMENT-SYSTEMS_index.json https://mr… 2977
#> 974 2024-07-01_ACTIVE-DEVELOPMENT-CO_index.json https://mr… 1565
#> 975 2024-07-01_ACTIVE-DISPOSAL-SERVICE-INC_index.json https://mr… 5173
#> 976 2024-07-01_ACTIVE-INTEREST-MEDIA-HOLDCO-INC-GROUP-HEALTH… https://mr… 171
#> 977 2024-07-01_ACTIVE-INTEREST-MEDIA-HOLDCO-INC-GROUP-HEALTH… https://mr… 1622
#> 978 2024-07-01_ACTIVE-PHYSICAL-THERAPY_index.json https://mr… 1562
#> 979 2024-07-01_ACTON-LINCOLN-MERCURY-INC_index.json https://mr… 1565
#> 980 2024-07-01_ACTS-FLEET-MAINTENANCE-SERVICE-INC_index.json https://mr… 1739
#> 981 2024-07-01_ACTUARIAL-RESOURCES-CORPORATION-OF-GEORGIA_in… https://mr… 1565
#> 982 2024-07-01_ACTUARIAL-RISK-MANAGEMENT-LTD_index.json https://mr… 1565
#> 983 2024-07-01_ACUDERM-INC_index.json https://mr… 2977
#> 984 2024-07-01_ACUITY-BRANDS-INC_ACUITY-BRANDS-INC_allowed-a… https://mr… 166
#> 985 2024-07-01_ACUITY-BRANDS-INC_NATIONAL-PPO_allowed-amount… https://mr… 184
#> 986 2024-07-01_ACUITY-BRANDS-INC_POS-CHOICE-PLUS_allowed-amo… https://mr… 184
#> 987 2024-07-01_ACUITY-BRANDS-INC_index.json https://mr… 4132
#> 988 2024-07-01_ACUMEN-CONSULTING-I-CORP_index.json https://mr… 1565
#> 989 2024-07-01_ACUMEN-ENTERPRISES-INC_index.json https://mr… 1910
#> 990 2024-07-01_ACUMEN-INTERNATIONAL-INC_index.json https://mr… 1912
#> 991 2024-07-01_ACUMEN-LEARNING-LLC_index.json https://mr… 3847
#> 992 2024-07-01_ACUMEN-TECHNOLOGY_index.json https://mr… 1565
#> 993 2024-07-01_ACUMEN-WEALTH-ADVISORS-LLCP_United-Healthcare… https://mr… 185
#> 994 2024-07-01_ACUMEN-WEALTH-ADVISORS-LLCP_index.json https://mr… 1842
#> 995 2024-07-01_ACUTE-CARE-INC_index.json https://mr… 1565
#> 996 2024-07-01_ACV-COMMUNITY-SERVICES-LLC_ACV-COMMUNITY-SERV… https://mr… 166
#> 997 2024-07-01_ACV-COMMUNITY-SERVICES-LLC_index.json https://mr… 1225
#> 998 2024-07-01_ACV-CORPORATE-PLLC_index.json https://mr… 1913
#> 999 2024-07-01_ACW-Holdings-LLC_index.json https://mr… 1913
#> 1000 2024-07-01_AD-ASTRA-SELECTIONS-LLC_index.json https://mr… 1739
#> # ℹ 67,072 more rows
The path to analyzing a health insurance company’s Transparency in Coverage (TiC) files begins at their public TiC site. Centene Corporation’s is located here. To begin, you simply have to right-click and copy one of the links’ URL addresses, then assign it to an object in R:
centene_url_june <- "https://www.centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_ambetter_index.json" # June
centene_url_sept <- "https://www.centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-09-30_ambetter_index.json" # Sept
centene_url_dec <- "https://www.centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-12-29_ambetter_index.json" # Dec
It’s important to note that this is a Table of Contents (TOC) file. TOC files are what you’ll start with as they contain top-level information such as each plan’s name, id, market (individual or group), and the URL address of each plan’s in-network negotiated rates and out-of-network allowable amounts.
You can retrieve and parse a TOC file with the
defog_toc()
function:
This returns a data frame containing 2,598 rows, so, for simplicity’s sake, I’ve limited it to the first 10 rows:
#> Error in dimnames(x) <- dn: length of 'dimnames' [2] not equal to array extent
Out-of-Network Files
Next we’ll download one of the out-of-network (OON) files,
also known as “allowed amounts” files. From the results above, we can
filter the rate_type
column to out_of_network
and make sure to remove duplicate URLs with {dplyr}’s
distinct()
function:
centene_oon_CA <- centene_toc |>
dplyr::filter(rate_type == "out_of_network") |>
dplyr::select(location) |>
dplyr::distinct() |>
tibble::deframe()
#> [1] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ca_allowed-amounts.json"
#> [2] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-la_allowed-amounts.json"
#> [3] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ky_allowed-amounts.json"
#> [4] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ga_allowed-amounts.json"
#> [5] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-in_allowed-amounts.json"
#> [6] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-il_allowed-amounts.json"
#> [7] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ar_allowed-amounts.json"
#> [8] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-az_allowed-amounts.json"
#> [9] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-fl_allowed-amounts.json"
#> [10] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ks_allowed-amounts.json"
#> [11] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-tx_allowed-amounts.json"
#> [12] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-oh_allowed-amounts.json"
#> [13] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-mi_allowed-amounts.json"
#> [14] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ms_allowed-amounts.json"
#> [15] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ok_allowed-amounts.json"
#> [16] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-pa_allowed-amounts.json"
#> [17] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nc-wellcare_allowed-amounts.json"
#> [18] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-wa_allowed-amounts.json"
#> [19] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-tn_allowed-amounts.json"
#> [20] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nc_allowed-amounts.json"
#> [21] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nh_allowed-amounts.json"
#> [22] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-sc_allowed-amounts.json"
#> [23] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ne_allowed-amounts.json"
#> [24] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-mo_allowed-amounts.json"
#> [25] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nv_allowed-amounts.json"
#> [26] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nj_allowed-amounts.json"
#> [27] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nm_allowed-amounts.json"
Next, plug the URL object into the defog_oon()
function
and retrieve the file:
centene_oon_CA_file <- defog_oon(centene_oon_CA) |>
dplyr::slice_head(n = 10)
#> Error in if (is_url(af[[1]])) {: the condition has length > 1
#> Error in eval(expr, envir, enclos): object 'centene_oon_CA_file' not found
Again, I’ve limited the output to the first ten rows for demonstration purposes, but this gives you a good idea of what an OON file contains. Next, we’ll retrieve an in-network file.
In-Network Files
The workflow for an in-network (INN) file is much the same,
though the output is different, thus the need for a different function.
This time, we filter the rate_type
column to
in_network
, again making sure to remove duplicate URLs:
centene_inn_CA <- centene_toc |>
dplyr::filter(rate_type == "in_network") |>
dplyr::select(location) |>
dplyr::distinct() |>
tibble::deframe()
#> [1] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ca_in-network.json"
#> [2] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-la_in-network.json"
#> [3] "https://tic2.hothprod.magellanhealth.com/CTLHC/INN/CTLHC_in-network-file-1"
#> [4] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ky_in-network.json"
#> [5] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ga_in-network.json"
#> [6] "https://tic2.hothprod.magellanhealth.com/CTPCH/INN/CTPCH_in-network-file-1"
#> [7] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-in_in-network.json"
#> [8] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-il_in-network.json"
#> [9] "https://tic2.hothprod.magellanhealth.com/CTMER/INN/CTMER_in-network-file-1"
#> [10] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ar_in-network.json"
#> [11] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-az_in-network.json"
#> [12] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-fl_in-network.json"
#> [13] "https://tic2.hothprod.magellanhealth.com/CTSUN/INN/CTSUN_in-network-file-1"
#> [14] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ks_in-network.json"
#> [15] "https://tic2.hothprod.magellanhealth.com/CTKSF/INN/CTKSF_in-network-file-1"
#> [16] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-tx_in-network.json"
#> [17] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-oh_in-network.json"
#> [18] "https://tic2.hothprod.magellanhealth.com/CTBUK/INN/CTBUK_in-network-file-1"
#> [19] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-mi_in-network.json"
#> [20] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ms_in-network.json"
#> [21] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ok_in-network.json"
#> [22] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-pa_in-network.json"
#> [23] "https://tic2.hothprod.magellanhealth.com/CTPEN/INN/CTPEN_in-network-file-1"
#> [24] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nc-wellcare_in-network.json"
#> [25] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-wa_in-network.json"
#> [26] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-tn_in-network.json"
#> [27] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nc_in-network.json"
#> [28] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nh_in-network.json"
#> [29] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-sc_in-network.json"
#> [30] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-ne_in-network.json"
#> [31] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-mo_in-network.json"
#> [32] "https://tic2.hothprod.magellanhealth.com/CTHOM/INN/CTHOM_in-network-file-1"
#> [33] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nv_in-network.json"
#> [34] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nj_in-network.json"
#> [35] "http://centene.com/content/dam/centene/Centene%20Corporate/json/DOCUMENT/2022-06-29_centene-management-company-llc_ambetter-nm_in-network.json"
And plug the URL object into the defog_inn()
function:
centene_inn_CA_file <- defog_inn(centene_inn_CA) |>
dplyr::slice_head(n = 10)
#> Error in if (is_url(af[[1]])) {: the condition has length > 1
#> Error in eval(expr, envir, enclos): object 'centene_inn_CA_file' not found
The output shows the first ten rows out of 141,580 total.
This is, without a doubt, an embarassment of riches for those of us in healthcare data analytics. However, there are some absent data points that would enable us to expand our analysis even further. This is where the NPPES NPI Registry API comes in handy.
Provider Data & the NPPES
Using the NPPES Registry Search, we can retrieve data such as a provider’s taxonomy, credentials, gender, NPI type, payer-specific identifiers, etc. First, we need to isolate the distinct NPIs from both the OON and INN results above. We have five distinct NPIs from the out-of-network file:
# OON file
centene_oon_npi <- centene_oon_CA_file |>
dplyr::distinct(npi) |>
unlist(use.names = FALSE)
#> Error in eval(expr, envir, enclos): object 'centene_oon_CA_file' not found
#> Error in eval(expr, envir, enclos): object 'centene_oon_npi' not found
And 10 distinct NPIs from the in-network file:
# INN file
centene_inn_npi <- centene_inn_CA_file |>
dplyr::distinct(npi) |>
unlist(use.names = FALSE)
#> Error in eval(expr, envir, enclos): object 'centene_inn_CA_file' not found
#> Error in eval(expr, envir, enclos): object 'centene_inn_npi' not found
Next, we pipe them both into {defogger}’s NPPES search function,
defog_npi()
, via {purrr}’s map_dfr()
:
# OON file NPIs
centene_oon_npi_resp <- centene_oon_npi |>
purrr::map_dfr(defog_npi)
#> Error in eval(expr, envir, enclos): object 'centene_oon_npi' not found
#> Error in eval(expr, envir, enclos): object 'centene_oon_npi_resp' not found
# INN file NPIs
centene_inn_npi_resp <- centene_inn_npi |>
purrr::map_dfr(defog_npi)
#> Error in eval(expr, envir, enclos): object 'centene_inn_npi' not found
#> Error in eval(expr, envir, enclos): object 'centene_inn_npi_resp' not found
This gives us two responses from the NPPES API, which we can unpack
with the defog_npi_wide()
function:
# OON file response
centene_oon_npi_result <- centene_oon_npi_resp |>
dplyr::group_split(search) |>
purrr::map_dfr(defog_npi_wide)
#> Error in eval(expr, envir, enclos): object 'centene_oon_npi_resp' not found
#> Error in eval(expr, envir, enclos): object 'centene_oon_npi_result' not found
# INN file response
centene_inn_npi_result <- centene_inn_npi_resp |>
dplyr::group_split(search) |>
purrr::map_dfr(defog_npi_wide)
#> Error in eval(expr, envir, enclos): object 'centene_inn_npi_resp' not found
#> Error in eval(expr, envir, enclos): object 'centene_inn_npi_result' not found
We can then join the two pairs of data frames for further analysis:
# OON join
centene_oon_npi_join <- dplyr::full_join(centene_oon_CA_file,
centene_oon_npi_result,
by = "npi")
#> Error in eval(expr, envir, enclos): object 'centene_oon_CA_file' not found
#> Error in eval(expr, envir, enclos): object 'centene_oon_npi_join' not found
# INN join
centene_inn_npi_join <- dplyr::full_join(centene_inn_CA_file,
centene_inn_npi_result,
by = "npi")
#> Error in eval(expr, envir, enclos): object 'centene_inn_CA_file' not found
#> Error in eval(expr, envir, enclos): object 'centene_inn_npi_join' not found
These joins give us data frames with the following 68 columns:
names(centene_oon_npi_join)
#> Error in eval(expr, envir, enclos): object 'centene_oon_npi_join' not found
Please see the Big Data: dm, arrow & duckdb vignette for an example of a much more in-depth analysis.