Skip to contents
### 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:

centene_toc <- defog_toc(centene_url_june)
nrow(centene_toc)
#> [1] 2598
ncol(centene_toc)
#> [1] 9


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.