{"count":50,"carriers":[{"dot_number":"8032","legal_name":"JOHN WILLIAMS TULLIS JR","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"GENERAL DELIVER","phy_city":"BOONEVILLE","phy_state":"MS","phy_zip":"38829","phy_country":"US","phone":"","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"19740601","officer_1":"","officer_2":"","fleet_size_class":"0","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:35:37","updated_at":"2026-05-16 01:35:37"},{"dot_number":"218035","legal_name":"JOHN WILLIAMS","dba_name":"CEDAR VALLEY LIMITED","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"R R  2","phy_city":"CEDAR RAPIDS","phy_state":"IA","phy_zip":"52401","phy_country":"US","phone":"3198487418","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"19820719","officer_1":"","officer_2":"","fleet_size_class":"A","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:36:40","updated_at":"2026-05-16 01:36:40"},{"dot_number":"442375","legal_name":"JOHN WILLIAMS","dba_name":"J W TRUCKING","entity_type":"OTHER-APPLYING FOR MC","operating_status":"OTHER-APPLYING FOR MC","phy_street":"100 ARKANSAS ST LOT #17","phy_city":"LAWRENCE","phy_state":"KS","phy_zip":"66044","phy_country":"US","phone":"7857491944","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20010620 0000","add_date":"19910410","officer_1":"","officer_2":"","fleet_size_class":"A","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:38:17","updated_at":"2026-05-16 01:38:17"},{"dot_number":"508399","legal_name":"JOHN WILLIAMS TRUCKING INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"537 NORTH HAMILTON","phy_city":"INDIANAPOLIS","phy_state":"IN","phy_zip":"46201","phy_country":"US","phone":"3172239079","mc_number":"MC-257737","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":3,"total_drivers":1,"total_cdl":1,"mcs150_mileage":75200,"mcs150_mileage_year":"2025","mcs150_date":"20260313 0000","add_date":"19921230","officer_1":"CHARLES WILLIAMS","officer_2":"","fleet_size_class":"B","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:38:42","updated_at":"2026-05-16 01:38:42"},{"dot_number":"522275","legal_name":"JOHN WILLIAMS TRUCKING CO INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"123 FOSTER BALL ROAD","phy_city":"DESOTO","phy_state":"GA","phy_zip":"31743-0123","phy_country":"US","phone":"2298741573","mc_number":"MC-413274","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":10,"mcs150_mileage_year":"2015","mcs150_date":"20170313 1849","add_date":"19930506","officer_1":"JOHN L WILLIAMS","officer_2":"LAVERNE WILLIAMS","fleet_size_class":"A","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"Y","prior_revoke_dot":"522275","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:39:06","updated_at":"2026-05-16 01:39:06"},{"dot_number":"551409","legal_name":"JOHN WILLIAMS","dba_name":"SHAWNEE FARMS","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"1222 NORTHWEST 201","phy_city":"CHILHOWEE","phy_state":"MO","phy_zip":"64733-9512","phy_country":"US","phone":"8168858411","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":5,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"19940223","officer_1":"","officer_2":"","fleet_size_class":"C","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:39:07","updated_at":"2026-05-16 01:39:07"},{"dot_number":"585223","legal_name":"JOHN B WILLIAMS SR","dba_name":"JOHN WILLIAMS TRUCKING","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"89 PENN ST","phy_city":"BRIDGETON","phy_state":"NJ","phy_zip":"08302","phy_country":"US","phone":"6094513943","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":2,"total_drivers":2,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20090409 0000","add_date":"19941227","officer_1":"","officer_2":"","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:39:18","updated_at":"2026-05-16 01:39:18"},{"dot_number":"644143","legal_name":"JOHN WILLIAMS","dba_name":"J & J TRUCKING","entity_type":"OTHER-UNKNOWN","operating_status":"OTHER-UNKNOWN","phy_street":"702 OLD HAM AVE","phy_city":"RICHMOND","phy_state":"KY","phy_zip":"40475","phy_country":"US","phone":"6066251636","mc_number":"MC-300152","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20040510 0000","add_date":"19960606","officer_1":"","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:39:52","updated_at":"2026-05-16 01:39:52"},{"dot_number":"789302","legal_name":"JOHN WILLIAMS","dba_name":"JW CATTLE COMPANY","entity_type":"EXEMPT FOR HIRE","operating_status":"EXEMPT FOR HIRE","phy_street":"706 CEDAR","phy_city":"LOVING","phy_state":"NM","phy_zip":"88256","phy_country":"US","phone":"5053632647","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2012","mcs150_date":"20131023 0000","add_date":"19990113","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:40:54","updated_at":"2026-05-16 01:40:54"},{"dot_number":"805939","legal_name":"JIMS PRODUCE","dba_name":"JOHN WILLIAMS FRESH FRUIT & PRODUCE","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"129 GULL PORT WAY","phy_city":"SEELEY LAKE","phy_state":"MT","phy_zip":"59868","phy_country":"US","phone":"4066774129","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20050827 0000","add_date":"19990415","officer_1":"","officer_2":"","fleet_size_class":"A","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:40:54","updated_at":"2026-05-16 01:40:54"},{"dot_number":"819796","legal_name":"JOHN WILLIAMS","dba_name":"T&J SANITATION","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"67 NORTHERN DR","phy_city":"MOOSUP","phy_state":"CT","phy_zip":"06354","phy_country":"US","phone":"8605641576","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20010622 0000","add_date":"19990720","officer_1":"","officer_2":"","fleet_size_class":"A","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:40:55","updated_at":"2026-05-16 01:40:55"},{"dot_number":"827929","legal_name":"JOHN WILLIAMS ENT INC","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"49 STONE DR","phy_city":"CAMDENTON","phy_state":"MO","phy_zip":"65020","phy_country":"US","phone":"5732161177","mc_number":"MC-425087","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"Y","power_units":4,"total_drivers":4,"total_cdl":4,"mcs150_mileage":1,"mcs150_mileage_year":"2019","mcs150_date":"20200813 0000","add_date":"19990915","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"C","business_type":"CORPORATION","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:41:23","updated_at":"2026-05-16 01:41:23"},{"dot_number":"873705","legal_name":"JOHN WILLIAMSON","dba_name":"WILLIAMSON TRUCKING","entity_type":"OTHER-UNKNOWN","operating_status":"OTHER-UNKNOWN","phy_street":"504 E PLANTERS","phy_city":"SAN AUGUTINE","phy_state":"TX","phy_zip":"75972","phy_country":"US","phone":"9366746829","mc_number":"MC-382869","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20060427 0000","add_date":"20000418","officer_1":"","officer_2":"","fleet_size_class":"A","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:41:24","updated_at":"2026-05-16 01:41:24"},{"dot_number":"900462","legal_name":"JOHN WILLIAMS","dba_name":"J & D WELDING","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","phy_street":"11664 FM 114","phy_city":"AVERY","phy_state":"TX","phy_zip":"75554","phy_country":"US","phone":"9036843525","mc_number":"MC-686051","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":2,"total_drivers":2,"total_cdl":2,"mcs150_mileage":7489,"mcs150_mileage_year":"2020","mcs150_date":"20210129 0105","add_date":"20000821","officer_1":"JOHN O WILLIAMS","officer_2":"DONNA WILLIAMS","fleet_size_class":"B","business_type":"INDIVIDUAL","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:41:39","updated_at":"2026-05-16 01:41:39"},{"dot_number":"1049571","legal_name":"JOHN WILLIAMS & ASSOC INC","dba_name":"FISHY BUSINESS MARINE TRANSPORTATION","entity_type":"OTHER-APPLYING FOR MC;AUTHORIZED FOR HIRE","operating_status":"OTHER-APPLYING FOR MC;AUTHORIZED FOR HIRE","phy_street":"5215 BARRACUDA ST","phy_city":"ORANGE BEACH","phy_state":"AL","phy_zip":"36561","phy_country":"US","phone":"2519745913","mc_number":"MC-441322","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":0,"mcs150_mileage":46000,"mcs150_mileage_year":"2005","mcs150_date":"20061221 1135","add_date":"20020820","officer_1":"JOHN T.WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:43:10","updated_at":"2026-05-16 01:43:10"},{"dot_number":"1203740","legal_name":"JOHN WILLIAMS","dba_name":"","entity_type":"","operating_status":"I","phy_street":"33 BATES AVE","phy_city":"ATLANTA","phy_state":"GA","phy_zip":"30317","phy_country":"US","phone":"4043731510","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20040123 0000","add_date":"20040123","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"R","source":"census","ingested_at":"2026-05-16 01:44:01","updated_at":"2026-05-16 01:44:01"},{"dot_number":"1241105","legal_name":"JOHN WILLIAMS","dba_name":"WILLIAMS TRUCKING","entity_type":"OTHER-APPLYING FOR MC #","operating_status":"OTHER-APPLYING FOR MC #","phy_street":"3114 Y WALLACE AVE NE","phy_city":"FORT PAYNE","phy_state":"AL","phy_zip":"35967","phy_country":"US","phone":"2568459128","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":3,"total_drivers":3,"total_cdl":3,"mcs150_mileage":70000,"mcs150_mileage_year":"2006","mcs150_date":"20070426 0000","add_date":"20040427","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:44:11","updated_at":"2026-05-16 01:44:11"},{"dot_number":"1291831","legal_name":"JOHN WILLIAMS","dba_name":"ONE PARADISE INVESTMENT","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"2178 N  ARROWHEAD","phy_city":"RIALTO","phy_state":"CA","phy_zip":"92377","phy_country":"US","phone":"9098749331","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20041004 1503","add_date":"20041004","officer_1":"JOWN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:44:24","updated_at":"2026-05-16 01:44:24"},{"dot_number":"1293030","legal_name":"JOHN WILLIAMS","dba_name":"","entity_type":"U. S. MAIL","operating_status":"U. S. MAIL","phy_street":"221 N STEPHENS AVENUE","phy_city":"SPRINGFIELD","phy_state":"IL","phy_zip":"62702-5928","phy_country":"US","phone":"2175449404","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":88000,"mcs150_mileage_year":"2004","mcs150_date":"20051007 0000","add_date":"20041007","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:44:25","updated_at":"2026-05-16 01:44:25"},{"dot_number":"1339414","legal_name":"RICHARD JOHN WILLIAMS","dba_name":"","entity_type":"","operating_status":"I","phy_street":"4546 AVE D","phy_city":"ZACHARY","phy_state":"LA","phy_zip":"70791","phy_country":"US","phone":"2256549940","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20060301 0000","add_date":"20050301","officer_1":"RICHARD JOHN WILLIAMS","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"R","source":"census","ingested_at":"2026-05-16 01:44:33","updated_at":"2026-05-16 01:44:33"},{"dot_number":"1379631","legal_name":"JOHN WILLIAMS","dba_name":"HANDYMAN HOME SERVICES","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"8735 MYERSVILLE RD","phy_city":"MIDDLETOWN","phy_state":"MD","phy_zip":"21769","phy_country":"US","phone":"3013713388","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20080229 1055","add_date":"20050602","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:44:34","updated_at":"2026-05-16 01:44:34"},{"dot_number":"1414584","legal_name":"JOHN WILLIAMS TRUCKING INC","dba_name":"JOHN WILLIAMS TRUCKING","entity_type":"AUTHORIZED FOR HIRE;EXEMPT FOR HIRE","operating_status":"AUTHORIZED FOR HIRE;EXEMPT FOR HIRE","phy_street":"2306 N 49TH STREET","phy_city":"FORT PIERCE","phy_state":"FL","phy_zip":"34946","phy_country":"US","phone":"7722160683","mc_number":"MC-535492","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":2,"mcs150_mileage":31952,"mcs150_mileage_year":"2010","mcs150_date":"20131016 0000","add_date":"20050911","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:45:11","updated_at":"2026-05-16 01:45:11"},{"dot_number":"1416996","legal_name":"JOHN WILLIAMS ADAMS III","dba_name":"AUTO TRANSPORT SERVICES","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"3132 WILLOW","phy_city":"GRANITE CITY","phy_state":"IL","phy_zip":"62040","phy_country":"US","phone":"6182237847","mc_number":"MC-536219","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"Y","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20100118 0000","add_date":"20050919","officer_1":"JOHN W ADAMS III","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:45:11","updated_at":"2026-05-16 01:45:11"},{"dot_number":"1476219","legal_name":"JOHN WILLIAMS CONSTRUCTION","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"18611 LAWRENCE 2230","phy_city":"AURORA","phy_state":"MO","phy_zip":"65605","phy_country":"US","phone":"4172291527","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":10000,"mcs150_mileage_year":"2009","mcs150_date":"20101111 0000","add_date":"20060321","officer_1":"JOHN WILLIAMS","officer_2":"RUSSELL WILLIAMS","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:45:44","updated_at":"2026-05-16 01:45:44"},{"dot_number":"1486146","legal_name":"JOHN WILLIAMS CONSTRUCTION INC","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"50 SWEETS HILL RD","phy_city":"EDDINGTON","phy_state":"ME","phy_zip":"04428","phy_country":"US","phone":"2079491652","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":2,"total_drivers":2,"total_cdl":2,"mcs150_mileage":8915,"mcs150_mileage_year":"2026","mcs150_date":"20260511 2136","add_date":"20060410","officer_1":"JOHN WILLIAMS","officer_2":"EILEEN WILLIAMS","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:45:45","updated_at":"2026-05-16 01:45:45"},{"dot_number":"1497341","legal_name":"JOHN WILLIAMS","dba_name":"ACTION MOVING CO","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"95 SACKMAN STREET","phy_city":"BROOKLYN","phy_state":"NY","phy_zip":"11233","phy_country":"US","phone":"7184855817","mc_number":"MC-223780","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2020","mcs150_date":"20211213 0000","add_date":"20060504","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:46:17","updated_at":"2026-05-16 01:46:17"},{"dot_number":"1523203","legal_name":"JOHN WILLIAMS CONSTRUCTION","dba_name":"","entity_type":"","operating_status":"I","phy_street":"26647 PETTUSVILLE ROAD","phy_city":"ELKMONT","phy_state":"AL","phy_zip":"35620","phy_country":"US","phone":"2567323043","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20060628 2328","add_date":"20060628","officer_1":"JOHN A.WILLIAMS JR.","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"R","source":"census","ingested_at":"2026-05-16 01:46:17","updated_at":"2026-05-16 01:46:17"},{"dot_number":"1560517","legal_name":"JOHN WILLIAMS","dba_name":"WILLIAMS FARMS HOME WELCOME","entity_type":"EXEMPT FOR HIRE","operating_status":"EXEMPT FOR HIRE","phy_street":"10359 OLD STATE RD","phy_city":"CARTHAGE","phy_state":"NY","phy_zip":"13619","phy_country":"US","phone":"3154939151","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":2,"total_drivers":2,"total_cdl":2,"mcs150_mileage":10000,"mcs150_mileage_year":"2005","mcs150_date":"20061002 0000","add_date":"20061002","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:46:29","updated_at":"2026-05-16 01:46:29"},{"dot_number":"1644164","legal_name":"ANTHONY JOHN WILLIAMS","dba_name":"FLAT RATE MOVING -COURIER","entity_type":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","operating_status":"PRIVATE PROPERTY;AUTHORIZED FOR HIRE","phy_street":"4167 ARAPAHO DRIVE","phy_city":"POWDER SPRINGS","phy_state":"GA","phy_zip":"30127-5020","phy_country":"US","phone":"7703691918","mc_number":"MC-600953","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":168000,"mcs150_mileage_year":"2014","mcs150_date":"20140107 0958","add_date":"20070514","officer_1":"ANTHONY WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:47:05","updated_at":"2026-05-16 01:47:05"},{"dot_number":"1656326","legal_name":"JOHN WILLIAMS TRUCKING","dba_name":"","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"ROUTE 1 BOX 68A","phy_city":"GLENWOOD","phy_state":"GA","phy_zip":"30428","phy_country":"US","phone":"9125851410","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20070615 1052","add_date":"20070615","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:47:05","updated_at":"2026-05-16 01:47:05"},{"dot_number":"1723520","legal_name":"STEVEN JOHN WILLIAMS","dba_name":"SJW HOME IMPROVEMENT","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"98 ONTARIO DRIVE","phy_city":"CHEEKTOWAGA","phy_state":"NY","phy_zip":"14225","phy_country":"US","phone":"7166982846","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":0,"total_drivers":1,"total_cdl":0,"mcs150_mileage":1,"mcs150_mileage_year":"2024","mcs150_date":"20250131 0000","add_date":"20080105","officer_1":"STEVEN WILLIAMS","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:47:18","updated_at":"2026-05-16 01:47:18"},{"dot_number":"1810365","legal_name":"JEFFREY JOHN WILLIAMS","dba_name":"PRIVATE","entity_type":"","operating_status":"I","phy_street":"437 S LAKESIDE DR","phy_city":"MICHIGAN CENTER","phy_state":"MI","phy_zip":"49254","phy_country":"US","phone":"5177641624","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20080911 1522","add_date":"20080911","officer_1":"JEFFREY WILLIMS","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"R","source":"census","ingested_at":"2026-05-16 01:48:25","updated_at":"2026-05-16 01:48:25"},{"dot_number":"1842103","legal_name":"JOHN WILLIAMS","dba_name":"WILLIAMS FARM TRUCKING","entity_type":"EXEMPT FOR HIRE","operating_status":"EXEMPT FOR HIRE","phy_street":"11680 OLD HWY 61 SOUTH","phy_city":"DUNDEE","phy_state":"MS","phy_zip":"38626-0013","phy_country":"US","phone":"6623578203","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":5000,"mcs150_mileage_year":"2009","mcs150_date":"20100308 0000","add_date":"20090105","officer_1":"JOHN WILLIAMS","officer_2":"ROSIE WILLIAMS","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:48:42","updated_at":"2026-05-16 01:48:42"},{"dot_number":"1853273","legal_name":"JOHN WILLIAMS","dba_name":"JOHN AUTO HOOK UP","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"442 PATTERSON AVE","phy_city":"ATLANTA","phy_state":"GA","phy_zip":"30316","phy_country":"US","phone":"4049140069","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20090210 0000","add_date":"20090210","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:48:43","updated_at":"2026-05-16 01:48:43"},{"dot_number":"1915049","legal_name":"JOHN WILLIAMS SNAPON","dba_name":"","entity_type":"PRIVATE PROPERTY;EXEMPT FOR HIRE","operating_status":"PRIVATE PROPERTY;EXEMPT FOR HIRE","phy_street":"92 EARTH AVE","phy_city":"CHEBOYGAN","phy_state":"MI","phy_zip":"49721","phy_country":"US","phone":"2318181523","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":35000,"mcs150_mileage_year":"2008","mcs150_date":"20090715 2239","add_date":"20090715","officer_1":"JOHN E WILLIAMS JR","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:48:59","updated_at":"2026-05-16 01:48:59"},{"dot_number":"1973673","legal_name":"CLIFTON JOHN WILLIAMS JR","dba_name":"","entity_type":"","operating_status":"I","phy_street":"541173 US HWY 1","phy_city":"CALLAHAN","phy_state":"FL","phy_zip":"32011","phy_country":"US","phone":"9044240317","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20091208 1310","add_date":"20091208","officer_1":"CLIFTON JOHN WILLIAMS JR","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"R","source":"census","ingested_at":"2026-05-16 01:49:25","updated_at":"2026-05-16 01:49:25"},{"dot_number":"2052112","legal_name":"JOHN WILLIAMS","dba_name":"JOHN WILLIAMS CONTRUCTION","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"57167 HARLOCKER HILL RD","phy_city":"COQUILLE","phy_state":"OR","phy_zip":"97423","phy_country":"US","phone":"5412908338","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":2,"total_drivers":3,"total_cdl":3,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20100702 1227","add_date":"20100702","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:49:52","updated_at":"2026-05-16 01:49:52"},{"dot_number":"2081760","legal_name":"JET W WHEELS INC","dba_name":"JOHN WILLIAMS","entity_type":"LOCAL GOVERNMENT;STATE GOVERNMENT;FEDERAL GOVERNMENT;U. S. MAIL","operating_status":"LOCAL GOVERNMENT;STATE GOVERNMENT;FEDERAL GOVERNMENT;U. S. MAIL","phy_street":"11210 SNOWDEN POND RD","phy_city":"LAUREL","phy_state":"MD","phy_zip":"20708","phy_country":"US","phone":"2026524577","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":2,"total_cdl":0,"mcs150_mileage":35000,"mcs150_mileage_year":"2010","mcs150_date":"20100930 2247","add_date":"20100930","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:49:53","updated_at":"2026-05-16 01:49:53"},{"dot_number":"2093389","legal_name":"JOHN WILLIAMS","dba_name":"J&S TRUCKING","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"1400 PETE DR","phy_city":"ALEDO","phy_state":"TX","phy_zip":"76008","phy_country":"US","phone":"8172431089","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20140321 1149","add_date":"20101108","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:50:26","updated_at":"2026-05-16 01:50:26"},{"dot_number":"2180459","legal_name":"JOHN WILLIAMS","dba_name":"","entity_type":"","operating_status":"I","phy_street":"45 STATE STREET","phy_city":"ALBANY","phy_state":"NY","phy_zip":"12203","phy_country":"US","phone":"5182538659","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20110808 1722","add_date":"20110808","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"R","source":"census","ingested_at":"2026-05-16 01:50:51","updated_at":"2026-05-16 01:50:51"},{"dot_number":"2218805","legal_name":"JOHN WILLIAMS AND HARRIET WILLIAMS A PARTNERSHIP","dba_name":"H & D BROKERAGE","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"612 PELICAN DRIVE","phy_city":"FT. WALTON BEACH","phy_state":"FL","phy_zip":"32548","phy_country":"US","phone":"2092514790","mc_number":"MC-165118","mc_number_2":"","mc_number_3":"","carrier_operation":"","hm_indicator":"N","power_units":0,"total_drivers":0,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"","add_date":"20111119","officer_1":"","officer_2":"","fleet_size_class":"0","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"B","source":"census","ingested_at":"2026-05-16 01:51:02","updated_at":"2026-05-16 01:51:02"},{"dot_number":"2265099","legal_name":"JOHN WILLIAMS","dba_name":"JOHN WILLIAMS TRUCKING","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"9365 BRIGHTRIDGE DRIVE","phy_city":"RENO","phy_state":"NV","phy_zip":"89506","phy_country":"US","phone":"7758152334","mc_number":"MC-773195","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":1,"mcs150_mileage_year":"2012","mcs150_date":"20130219 1838","add_date":"20120119","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:51:15","updated_at":"2026-05-16 01:51:15"},{"dot_number":"2271378","legal_name":"JOHN WILLIAMS","dba_name":"ALOHA SERVICES","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"1736 E SHASTA ST","phy_city":"CASA GRANDE","phy_state":"AZ","phy_zip":"85122","phy_country":"US","phone":"5202083939","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20120208 1844","add_date":"20120208","officer_1":"LUISA ANN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:51:15","updated_at":"2026-05-16 01:51:15"},{"dot_number":"2272350","legal_name":"JOHN WILLIAMS","dba_name":"WILLIAMS HAULING","entity_type":"AUTHORIZED FOR HIRE","operating_status":"AUTHORIZED FOR HIRE","phy_street":"1849 LIBERTY CHURCH ROAD","phy_city":"HEPHIZABAH","phy_state":"GA","phy_zip":"30815","phy_country":"US","phone":"7065922612","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":36000,"mcs150_mileage_year":"2014","mcs150_date":"20150311 1440","add_date":"20120211","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:51:15","updated_at":"2026-05-16 01:51:15"},{"dot_number":"2339252","legal_name":"JOHN WILLIAMSON","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"989 FAIRVIEW AVE","phy_city":"WEST CHESTER","phy_state":"PA","phy_zip":"19380","phy_country":"US","phone":"6103240632","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":2000,"mcs150_mileage_year":"2011","mcs150_date":"20121002 1644","add_date":"20120903","officer_1":"JOHN WILLIAMSON","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:51:48","updated_at":"2026-05-16 01:51:48"},{"dot_number":"2424663","legal_name":"JOHN WILLIAMSON","dba_name":"WRUBBERSEAL","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"325 WASHINGTON AVE S","phy_city":"KENT","phy_state":"WA","phy_zip":"98032","phy_country":"US","phone":"2066604656","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":0,"mcs150_mileage_year":"","mcs150_date":"20130725 1845","add_date":"20130725","officer_1":"JOHN WILLIAMSON","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:31","updated_at":"2026-05-16 01:52:31"},{"dot_number":"2455918","legal_name":"JOHN WILLIAMS WELDING INC","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"4503 US81","phy_city":"EL RENO","phy_state":"OK","phy_zip":"73036","phy_country":"US","phone":"4052060153","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":0,"mcs150_mileage":50000,"mcs150_mileage_year":"2012","mcs150_date":"20131121 1912","add_date":"20131121","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:47","updated_at":"2026-05-16 01:52:47"},{"dot_number":"2472029","legal_name":"JOHN WILLIAMS PLUMBING INC","dba_name":"JWP","entity_type":"OTHER-DIRT, SLAG, MILLINGS, LIME ROCK, CRUSH CREAT SEPTI;AUTHORIZED FOR HIRE","operating_status":"OTHER-DIRT, SLAG, MILLINGS, LIME ROCK, CRUSH CREAT SEPTI;AUTHORIZED FOR HIRE","phy_street":"109 SOUTH COLLEGE ST","phy_city":"MACCLENNY","phy_state":"FL","phy_zip":"32063","phy_country":"US","phone":"9042594580","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":20800,"mcs150_mileage_year":"2023","mcs150_date":"20240911 1122","add_date":"20140131","officer_1":"JOHN D WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:47","updated_at":"2026-05-16 01:52:47"},{"dot_number":"2473380","legal_name":"JOHN WILLIAMS","dba_name":"T&J FARMS","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"3056 MAXWELL RD","phy_city":"AUTRYVILLE","phy_state":"NC","phy_zip":"28318","phy_country":"US","phone":"9109901718","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"A","hm_indicator":"N","power_units":2,"total_drivers":1,"total_cdl":1,"mcs150_mileage":4000,"mcs150_mileage_year":"2023","mcs150_date":"20241031 0000","add_date":"20140205","officer_1":"JOHN NELSON WILLIAMS","officer_2":"","fleet_size_class":"B","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"N","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:52:47","updated_at":"2026-05-16 01:52:47"},{"dot_number":"2646906","legal_name":"JOHN WILLIAMS BACKHOE INC","dba_name":"","entity_type":"PRIVATE PROPERTY","operating_status":"PRIVATE PROPERTY","phy_street":"11662 PICKETT LANE","phy_city":"GARDEN GROVE","phy_state":"CA","phy_zip":"92840","phy_country":"US","phone":"7147436262","mc_number":"","mc_number_2":"","mc_number_3":"","carrier_operation":"C","hm_indicator":"N","power_units":1,"total_drivers":1,"total_cdl":1,"mcs150_mileage":10000,"mcs150_mileage_year":"2022","mcs150_date":"20220504 1634","add_date":"20150612","officer_1":"JOHN WILLIAMS","officer_2":"","fleet_size_class":"A","business_type":"","duns_number":"","crash_rate":0,"prior_revoke_flag":"","prior_revoke_dot":"","cargo_types":"C","source":"census","ingested_at":"2026-05-16 01:54:02","updated_at":"2026-05-16 01:54:02"}]}