text: INSERT INTO `r_areas` (`area_code`, `region`) VALUES
  ('201', 'NJ'),
  ('202', 'DC'),
  ('203', 'CT'),
  ('204', 'MB'),
  ('205', 'AL'),
  ('206', 'WA'),
  ('207', 'ME'),
  ('208', 'ID'),
  ('209', 'CA'),
  ('210', 'TX'),
  ('212', 'NY'),
  ('213', 'CA'),
  ('214', 'TX'),
  ('215', 'PA'),
  ('216', 'OH'),
  ('217', 'IL'),
  ('218', 'MN'),
  ('219', 'IN'),
  ('224', 'IL'),
  ('225', 'LA'),
  ('226', 'ON'),
  ('228', 'MS'),
  ('229', 'GA'),
  ('231', 'MI'),
  ('234', 'OH'),
  ('239', 'FL'),
  ('240', 'MD'),
  ('242', 'Bahamas'),
  ('246', 'Barbados'),
  ('248', 'MI'),
  ('250', 'BC'),
  ('251', 'AL'),
  ('252', 'NC'),
  ('253', 'WA'),
  ('254', 'TX'),
  ('256', 'AL'),
  ('260', 'IN'),
  ('262', 'WI'),
  ('264', 'Anguilla'),
  ('267', 'PA'),
  ('268', 'Antigua and Barbuda'),
  ('269', 'MI'),
  ('270', 'KY'),
  ('276', 'VA'),
  ('281', 'TX'),
  ('284', 'British Virgin Islands'),
  ('289', 'ON'),
  ('301', 'MD'),
  ('302', 'DE'),
  ('303', 'CO'),
  ('304', 'WV'),
  ('305', 'FL'),
  ('306', 'SK'),
  ('307', 'WY'),
  ('308', 'NE'),
  ('309', 'IL'),
  ('310', 'CA'),
  ('312', 'IL'),
  ('313', 'MI'),
  ('314', 'MO'),
  ('315', 'NY'),
  ('316', 'KS'),
  ('317', 'IN'),
  ('318', 'LA'),
  ('319', 'IA'),
  ('320', 'MN'),
  ('321', 'FL'),
  ('323', 'CA'),
  ('325', 'TX'),
  ('330', 'OH'),
  ('334', 'AL'),
  ('336', 'NC'),
  ('337', 'LA'),
  ('339', 'MA'),
  ('340', 'USVI'),
  ('345', 'Cayman Islands'),
  ('347', 'NY'),
  ('351', 'MA'),
  ('352', 'FL'),
  ('360', 'WA'),
  ('361', 'TX'),
  ('386', 'FL'),
  ('401', 'RI'),
  ('402', 'NE'),
  ('403', 'AB'),
  ('404', 'GA'),
  ('405', 'OK'),
  ('406', 'MT'),
  ('407', 'FL'),
  ('408', 'CA'),
  ('409', 'TX'),
  ('410', 'MD'),
  ('412', 'PA'),
  ('413', 'MA'),
  ('414', 'WI'),
  ('415', 'CA'),
  ('416', 'ON'),
  ('417', 'MO'),
  ('418', 'QC'),
  ('419', 'OH'),
  ('423', 'TN'),
  ('424', 'CA'),
  ('425', 'WA'),
  ('430', 'TX'),
  ('432', 'TX'),
  ('434', 'VA'),
  ('435', 'UT'),
  ('438', 'QC'),
  ('440', 'OH'),
  ('441', 'Bermuda'),
  ('443', 'MD'),
  ('450', 'QC'),
  ('456', 'Reserved'),
  ('469', 'TX'),
  ('473', 'Grenada'),
  ('478', 'GA'),
  ('479', 'AR'),
  ('480', 'AZ'),
  ('484', 'PA'),
  ('500', 'Reserved'),
  ('501', 'AR'),
  ('502', 'KY'),
  ('503', 'OR'),
  ('504', 'LA'),
  ('505', 'NM'),
  ('506', 'NB'),
  ('507', 'MN'),
  ('508', 'MA'),
  ('509', 'WA'),
  ('510', 'CA'),
  ('512', 'TX'),
  ('513', 'OH'),
  ('514', 'QC'),
  ('515', 'IA'),
  ('516', 'NY'),
  ('517', 'MI'),
  ('518', 'NY'),
  ('519', 'ON'),
  ('520', 'AZ'),
  ('530', 'CA'),
  ('540', 'VA'),
  ('541', 'OR'),
  ('551', 'NJ'),
  ('559', 'CA'),
  ('561', 'FL'),
  ('562', 'CA'),
  ('563', 'IA'),
  ('567', 'OH'),
  ('570', 'PA'),
  ('571', 'VA'),
  ('573', 'MO'),
  ('574', 'IN'),
  ('580', 'OK'),
  ('585', 'NY'),
  ('586', 'MI'),
  ('600', 'Reserved'),
  ('601', 'MS'),
  ('602', 'AZ'),
  ('603', 'NH'),
  ('604', 'BC'),
  ('605', 'SD'),
  ('606', 'KY'),
  ('607', 'NY'),
  ('608', 'WI'),
  ('609', 'NJ'),
  ('610', 'PA'),
  ('612', 'MN'),
  ('613', 'ON'),
  ('614', 'OH'),
  ('615', 'TN'),
  ('616', 'MI'),
  ('617', 'MA'),
  ('618', 'IL'),
  ('619', 'CA'),
  ('620', 'KS'),
  ('623', 'AZ'),
  ('626', 'CA'),
  ('630', 'IL'),
  ('631', 'NY'),
  ('636', 'MO'),
  ('641', 'IA'),
  ('646', 'NY'),
  ('647', 'ON'),
  ('649', 'Turks & Caicos Islands'),
  ('650', 'CA'),
  ('651', 'MN'),
  ('660', 'MO'),
  ('661', 'CA'),
  ('662', 'MS'),
  ('664', 'Montserrat'),
  ('670', 'MP'),
  ('671', 'GU'),
  ('678', 'GA'),
  ('682', 'TX'),
  ('684', 'AS'),
  ('700', 'Reserved'),
  ('701', 'ND'),
  ('702', 'NV'),
  ('703', 'VA'),
  ('704', 'NC'),
  ('705', 'ON'),
  ('706', 'GA'),
  ('707', 'CA'),
  ('708', 'IL'),
  ('709', 'NL'),
  ('710', 'US Government'),
  ('712', 'IA'),
  ('713', 'TX'),
  ('714', 'CA'),
  ('715', 'WI'),
  ('716', 'NY'),
  ('717', 'PA'),
  ('718', 'NY'),
  ('719', 'CO'),
  ('720', 'CO'),
  ('724', 'PA'),
  ('727', 'FL'),
  ('731', 'TN'),
  ('732', 'NJ'),
  ('734', 'MI'),
  ('740', 'OH'),
  ('754', 'FL'),
  ('757', 'VA'),
  ('758', 'St. Lucia'),
  ('760', 'CA'),
  ('762', 'GA'),
  ('763', 'MN'),
  ('765', 'IN'),
  ('767', 'Dominica'),
  ('769', 'MS'),
  ('770', 'GA'),
  ('772', 'FL'),
  ('773', 'IL'),
  ('774', 'MA'),
  ('775', 'NV'),
  ('778', 'BC'),
  ('780', 'AB'),
  ('781', 'MA'),
  ('784', 'St. Vincent & Grenadines'),
  ('785', 'KS'),
  ('786', 'FL'),
  ('787', 'PR'),
  ('800', 'Toll Free'),
  ('801', 'UT'),
  ('802', 'VT'),
  ('803', 'SC'),
  ('804', 'VA'),
  ('805', 'CA'),
  ('806', 'TX'),
  ('807', 'ON'),
  ('808', 'HI'),
  ('809', 'Dominican Republic'),
  ('810', 'MI'),
  ('812', 'IN'),
  ('813', 'FL'),
  ('814', 'PA'),
  ('815', 'IL'),
  ('816', 'MO'),
  ('817', 'TX'),
  ('818', 'CA'),
  ('819', 'QC'),
  ('828', 'NC'),
  ('829', 'Dominican Republic'),
  ('830', 'TX'),
  ('831', 'CA'),
  ('832', 'TX'),
  ('843', 'SC'),
  ('845', 'NY'),
  ('847', 'IL'),
  ('848', 'NJ'),
  ('850', 'FL'),
  ('856', 'NJ'),
  ('857', 'MA'),
  ('858', 'CA'),
  ('859', 'KY'),
  ('860', 'CT'),
  ('862', 'NJ'),
  ('863', 'FL'),
  ('864', 'SC'),
  ('865', 'TN'),
  ('866', 'Toll Free'),
  ('867', 'YT'),
  ('868', 'Trinidad & Tobago'),
  ('869', 'St. Kitts & Nevis'),
  ('870', 'AR'),
  ('876', 'Jamaica'),
  ('877', 'Toll Free'),
  ('878', 'PA'),
  ('888', 'Toll Free'),
  ('900', 'Toll Calls'),
  ('901', 'TN'),
  ('902', 'NS'),
  ('903', 'TX'),
  ('904', 'FL'),
  ('905', 'ON'),
  ('906', 'MI'),
  ('907', 'AK'),
  ('908', 'NJ'),
  ('909', 'CA'),
  ('910', 'NC'),
  ('912', 'GA'),
  ('913', 'KS'),
  ('914', 'NY'),
  ('915', 'TX'),
  ('916', 'CA'),
  ('917', 'NY'),
  ('918', 'OK'),
  ('919', 'NC'),
  ('920', 'WI'),
  ('925', 'CA'),
  ('928', 'AZ'),
  ('931', 'TN'),
  ('936', 'TX'),
  ('937', 'OH'),
  ('939', 'PR'),
  ('940', 'TX'),
  ('941', 'FL'),
  ('947', 'MI'),
  ('949', 'CA'),
  ('951', 'CA'),
  ('952', 'MN'),
  ('954', 'FL'),
  ('956', 'TX'),
  ('970', 'CO'),
  ('971', 'OR'),
  ('972', 'TX'),
  ('973', 'NJ'),
  ('978', 'MA'),
  ('979', 'TX'),
  ('980', 'NC'),
  ('985', 'LA'),
  ('989', 'MI');
  