IAB Categories, written down in SQL based on https://gist.github.com/crowdmatt/5040911. Probably helpful to someone ;)

IAB-Categories.sql

CREATE TABLE `iab_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) NOT NULL,
  `description` varchar(300) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `iab_categories` (`id`, `name`, `description`)
VALUES
	(1,'IAB1','Arts & Entertainment'),
	(2,'IAB1-1','Books & Literature'),
	(3,'IAB1-2','Celebrity Fan/Gossip'),
	(4,'IAB1-3','Fine Art'),
	(5,'IAB1-4','Humor'),
	(6,'IAB1-5','Movies'),
	(7,'IAB1-6','Music'),
	(8,'IAB1-7','Television'),
	(9,'IAB2','Automotive'),
	(10,'IAB2-1','Auto Parts'),
	(11,'IAB2-2','Auto Repair'),
	(12,'IAB2-3','Buying/Selling Cars'),
	(13,'IAB2-4','Car Culture'),
	(14,'IAB2-5','Certified Pre-Owned'),
	(15,'IAB2-6','Convertible'),
	(16,'IAB2-7','Coupe'),
	(17,'IAB2-8','Crossover'),
	(18,'IAB2-9','Diesel'),
	(19,'IAB2-10','Electric Vehicle'),
	(20,'IAB2-11','Hatchback'),
	(21,'IAB2-12','Hybrid'),
	(22,'IAB2-13','Luxury'),
	(23,'IAB2-14','MiniVan'),
	(24,'IAB2-15','Mororcycles'),
	(25,'IAB2-16','Off-Road Vehicles'),
	(26,'IAB2-17','Performance Vehicles'),
	(27,'IAB2-18','Pickup'),
	(28,'IAB2-19','Road-Side Assistance'),
	(29,'IAB2-20','Sedan'),
	(30,'IAB2-21','Trucks & Accessories'),
	(31,'IAB2-22','Vintage Cars'),
	(32,'IAB2-23','Wagon'),
	(33,'IAB3','Business'),
	(34,'IAB3-1','Advertising'),
	(35,'IAB3-2','Agriculture'),
	(36,'IAB3-3','Biotech/Biomedical'),
	(37,'IAB3-4','Business Software'),
	(38,'IAB3-5','Construction'),
	(39,'IAB3-6','Forestry'),
	(40,'IAB3-7','Government'),
	(41,'IAB3-8','Green Solutions'),
	(42,'IAB3-9','Human Resources'),
	(43,'IAB3-10','Logistics'),
	(44,'IAB3-11','Marketing'),
	(45,'IAB3-12','Metals'),
	(46,'IAB4','Careers'),
	(47,'IAB4-1','Career Planning'),
	(48,'IAB4-2','College'),
	(49,'IAB4-3','Financial Aid'),
	(50,'IAB4-4','Job Fairs'),
	(51,'IAB4-5','Job Search'),
	(52,'IAB4-6','Resume Writing/Advice'),
	(53,'IAB4-7','Nursing'),
	(54,'IAB4-8','Scholarships'),
	(55,'IAB4-9','Telecommuting'),
	(56,'IAB4-10','U.S. Military'),
	(57,'IAB4-11','Career Advice'),
	(58,'IAB5','Education'),
	(59,'IAB5-1','7-12 Education'),
	(60,'IAB5-2','Adult Education'),
	(61,'IAB5-3','Art History'),
	(62,'IAB5-4','Colledge Administration'),
	(63,'IAB5-5','College Life'),
	(64,'IAB5-6','Distance Learning'),
	(65,'IAB5-7','English as a 2nd Language'),
	(66,'IAB5-8','Language Learning'),
	(67,'IAB5-9','Graduate School'),
	(68,'IAB5-10','Homeschooling'),
	(69,'IAB5-11','Homework/Study Tips'),
	(70,'IAB5-12','K-6 Educators'),
	(71,'IAB5-13','Private School'),
	(72,'IAB5-14','Special Education'),
	(73,'IAB5-15','Studying Business'),
	(74,'IAB6','Family & Parenting'),
	(75,'IAB6-1','Adoption'),
	(76,'IAB6-2','Babies & Toddlers'),
	(77,'IAB6-3','Daycare/Pre School'),
	(78,'IAB6-4','Family Internet'),
	(79,'IAB6-5','Parenting - K-6 Kids'),
	(80,'IAB6-6','Parenting teens'),
	(81,'IAB6-7','Pregnancy'),
	(82,'IAB6-8','Special Needs Kids'),
	(83,'IAB6-9','Eldercare'),
	(84,'IAB7','Health & Fitness'),
	(85,'IAB7-1','Exercise'),
	(86,'IAB7-2','A.D.D.'),
	(87,'IAB7-3','AIDS/HIV'),
	(88,'IAB7-4','Allergies'),
	(89,'IAB7-5','Alternative Medicine'),
	(90,'IAB7-6','Arthritis'),
	(91,'IAB7-7','Asthma'),
	(92,'IAB7-8','Autism/PDD'),
	(93,'IAB7-9','Bipolar Disorder'),
	(94,'IAB7-10','Brain Tumor'),
	(95,'IAB7-11','Cancer'),
	(96,'IAB7-12','Cholesterol'),
	(97,'IAB7-13','Chronic Fatigue Syndrome'),
	(98,'IAB7-14','Chronic Pain'),
	(99,'IAB7-15','Cold & Flu'),
	(100,'IAB7-16','Deafness'),
	(101,'IAB7-17','Dental Care'),
	(102,'IAB7-18','Depression'),
	(103,'IAB7-19','Dermatology'),
	(104,'IAB7-20','Diabetes'),
	(105,'IAB7-21','Epilepsy'),
	(106,'IAB7-22','GERD/Acid Reflux'),
	(107,'IAB7-23','Headaches/Migraines'),
	(108,'IAB7-24','Heart Disease'),
	(109,'IAB7-25','Herbs for Health'),
	(110,'IAB7-26','Holistic Healing'),
	(111,'IAB7-27','IBS/Crohn\'s Disease'),
	(112,'IAB7-28','Incest/Abuse Support'),
	(113,'IAB7-29','Incontinence'),
	(114,'IAB7-30','Infertility'),
	(115,'IAB7-31','Men\'s Health'),
	(116,'IAB7-32','Nutrition'),
	(117,'IAB7-33','Orthopedics'),
	(118,'IAB7-34','Panic/Anxiety Disorders'),
	(119,'IAB7-35','Pediatrics'),
	(120,'IAB7-36','Physical Therapy'),
	(121,'IAB7-37','Psychology/Psychiatry'),
	(122,'IAB7-38','Senor Health'),
	(123,'IAB7-39','Sexuality'),
	(124,'IAB7-40','Sleep Disorders'),
	(125,'IAB7-41','Smoking Cessation'),
	(126,'IAB7-42','Substance Abuse'),
	(127,'IAB7-43','Thyroid Disease'),
	(128,'IAB7-44','Weight Loss'),
	(129,'IAB7-45','Women\'s Health'),
	(130,'IAB8','Food & Drink'),
	(131,'IAB8-1','American Cuisine'),
	(132,'IAB8-2','Barbecues & Grilling'),
	(133,'IAB8-3','Cajun/Creole'),
	(134,'IAB8-4','Chinese Cuisine'),
	(135,'IAB8-5','Cocktails/Beer'),
	(136,'IAB8-6','Coffee/Tea'),
	(137,'IAB8-7','Cuisine-Specific'),
	(138,'IAB8-8','Desserts & Baking'),
	(139,'IAB8-9','Dining Out'),
	(140,'IAB8-10','Food Allergies'),
	(141,'IAB8-11','French Cuisine'),
	(142,'IAB8-12','Health/Lowfat Cooking'),
	(143,'IAB8-13','Italian Cuisine'),
	(144,'IAB8-14','Japanese Cuisine'),
	(145,'IAB8-15','Mexican Cuisine'),
	(146,'IAB8-16','Vegan'),
	(147,'IAB8-17','Vegetarian'),
	(148,'IAB8-18','Wine'),
	(149,'IAB9','Hobbies & Interests'),
	(150,'IAB9-1','Art/Technology'),
	(151,'IAB9-2','Arts & Crafts'),
	(152,'IAB9-3','Beadwork'),
	(153,'IAB9-4','Birdwatching'),
	(154,'IAB9-5','Board Games/Puzzles'),
	(155,'IAB9-6','Candle & Soap Making'),
	(156,'IAB9-7','Card Games'),
	(157,'IAB9-8','Chess'),
	(158,'IAB9-9','Cigars'),
	(159,'IAB9-10','Collecting'),
	(160,'IAB9-11','Comic Books'),
	(161,'IAB9-12','Drawing/Sketching'),
	(162,'IAB9-13','Freelance Writing'),
	(163,'IAB9-14','Genealogy'),
	(164,'IAB9-15','Getting Published'),
	(165,'IAB9-16','Guitar'),
	(166,'IAB9-17','Home Recording'),
	(167,'IAB9-18','Investors & Patents'),
	(168,'IAB9-19','Jewelry Making'),
	(169,'IAB9-20','Magic & Illusion'),
	(170,'IAB9-21','Needlework'),
	(171,'IAB9-22','Painting'),
	(172,'IAB9-23','Photography'),
	(173,'IAB9-24','Radio'),
	(174,'IAB9-25','Roleplaying Games'),
	(175,'IAB9-26','Sci-Fi & Fantasy'),
	(176,'IAB9-27','Scrapbooking'),
	(177,'IAB9-28','Screenwriting'),
	(178,'IAB9-29','Stamps & Coins'),
	(179,'IAB9-30','Video & Computer Games'),
	(180,'IAB9-31','Woodworking'),
	(181,'IAB10','Home & Garden'),
	(182,'IAB10-1','Appliances'),
	(183,'IAB10-2','Entertaining'),
	(184,'IAB10-3','Environmental Safety'),
	(185,'IAB10-4','Gardening'),
	(186,'IAB10-5','Home Repair'),
	(187,'IAB10-6','Home Theater'),
	(188,'IAB10-7','Interior Decorating'),
	(189,'IAB10-8','Landscaping'),
	(190,'IAB10-9','Remodeling & Construction'),
	(191,'IAB11','Law, Gov\'t & Politics'),
	(192,'IAB11-1','Immigration'),
	(193,'IAB11-2','Legal Issues'),
	(194,'IAB11-3','U.S. Government Resources'),
	(195,'IAB11-4','Politics'),
	(196,'IAB11-5','Commentary'),
	(197,'IAB12','News'),
	(198,'IAB12-1','International News'),
	(199,'IAB12-2','National News'),
	(200,'IAB12-3','Local News'),
	(201,'IAB13','Personal Finance'),
	(202,'IAB13-1','Beginning Investing'),
	(203,'IAB13-2','Credit/Debt & Loans'),
	(204,'IAB13-3','Financial News'),
	(205,'IAB13-4','Financial Planning'),
	(206,'IAB13-5','Hedge Fund'),
	(207,'IAB13-6','Insurance'),
	(208,'IAB13-7','Investing'),
	(209,'IAB13-8','Mutual Funds'),
	(210,'IAB13-9','Options'),
	(211,'IAB13-10','Retirement Planning'),
	(212,'IAB13-11','Stocks'),
	(213,'IAB13-12','Tax Planning'),
	(214,'IAB14','Society'),
	(215,'IAB14-1','Dating'),
	(216,'IAB14-2','Divorce Support'),
	(217,'IAB14-3','Gay Life'),
	(218,'IAB14-4','Marriage'),
	(219,'IAB14-5','Senior Living'),
	(220,'IAB14-6','Teens'),
	(221,'IAB14-7','Weddings'),
	(222,'IAB14-8','Ethnic Specific'),
	(223,'IAB15','Science'),
	(224,'IAB15-1','Astrology'),
	(225,'IAB15-2','Biology'),
	(226,'IAB15-3','Chemistry'),
	(227,'IAB15-4','Geology'),
	(228,'IAB15-5','Paranormal Phenomena'),
	(229,'IAB15-6','Physics'),
	(230,'IAB15-7','Space/Astronomy'),
	(231,'IAB15-8','Geography'),
	(232,'IAB15-9','Botany'),
	(233,'IAB15-10','Weather'),
	(234,'IAB16','Pets'),
	(235,'IAB16-1','Aquariums'),
	(236,'IAB16-2','Birds'),
	(237,'IAB16-3','Cats'),
	(238,'IAB16-4','Dogs'),
	(239,'IAB16-5','Large Animals'),
	(240,'IAB16-6','Reptiles'),
	(241,'IAB16-7','Veterinary Medicine'),
	(242,'IAB17','Sports'),
	(243,'IAB17-1','Auto Racing'),
	(244,'IAB17-2','Baseball'),
	(245,'IAB17-3','Bicycling'),
	(246,'IAB17-4','Bodybuilding'),
	(247,'IAB17-5','Boxing'),
	(248,'IAB17-6','Canoeing/Kayaking'),
	(249,'IAB17-7','Cheerleading'),
	(250,'IAB17-8','Climbing'),
	(251,'IAB17-9','Cricket'),
	(252,'IAB17-10','Figure Skating'),
	(253,'IAB17-11','Fly Fishing'),
	(254,'IAB17-12','Football'),
	(255,'IAB17-13','Freshwater Fishing'),
	(256,'IAB17-14','Game & Fish'),
	(257,'IAB17-15','Golf'),
	(258,'IAB17-16','Horse Racing'),
	(259,'IAB17-17','Horses'),
	(260,'IAB17-18','Hunting/Shooting'),
	(261,'IAB17-19','Inline Skating'),
	(262,'IAB17-20','Martial Arts'),
	(263,'IAB17-21','Mountain Biking'),
	(264,'IAB17-22','NASCAR Racing'),
	(265,'IAB17-23','Olympics'),
	(266,'IAB17-24','Paintball'),
	(267,'IAB17-25','Power & Motorcycles'),
	(268,'IAB17-26','Pro Basketball'),
	(269,'IAB17-27','Pro Ice Hockey'),
	(270,'IAB17-28','Rodeo'),
	(271,'IAB17-29','Rugby'),
	(272,'IAB17-30','Running/Jogging'),
	(273,'IAB17-31','Sailing'),
	(274,'IAB17-32','Saltwater Fishing'),
	(275,'IAB17-33','Scuba Diving'),
	(276,'IAB17-34','Skateboarding'),
	(277,'IAB17-35','Skiing'),
	(278,'IAB17-36','Snowboarding'),
	(279,'IAB17-37','Surfing/Bodyboarding'),
	(280,'IAB17-38','Swimming'),
	(281,'IAB17-39','Table Tennis/Ping-Pong'),
	(282,'IAB17-40','Tennis'),
	(283,'IAB17-41','Volleyball'),
	(284,'IAB17-42','Walking'),
	(285,'IAB17-43','Waterski/Wakeboard'),
	(286,'IAB17-44','World Soccer'),
	(287,'IAB18','Style & Fashion'),
	(288,'IAB18-1','Beauty'),
	(289,'IAB18-2','Body Art'),
	(290,'IAB18-3','Fashion'),
	(291,'IAB18-4','Jewelry'),
	(292,'IAB18-5','Clothing'),
	(293,'IAB18-6','Accessories'),
	(294,'IAB19','Technology & Computing'),
	(295,'IAB19-1','3-D Graphics'),
	(296,'IAB19-2','Animation'),
	(297,'IAB19-3','Antivirus Software'),
	(298,'IAB19-4','C/C++'),
	(299,'IAB19-5','Cameras & Camcorders'),
	(300,'IAB19-6','Cell Phones'),
	(301,'IAB19-7','Computer Certification'),
	(302,'IAB19-8','Computer Networking'),
	(303,'IAB19-9','Computer Peripherals'),
	(304,'IAB19-10','Computer Reviews'),
	(305,'IAB19-11','Data Centers'),
	(306,'IAB19-12','Databases'),
	(307,'IAB19-13','Desktop Publishing'),
	(308,'IAB19-14','Desktop Video'),
	(309,'IAB19-15','Email'),
	(310,'IAB19-16','Graphics Software'),
	(311,'IAB19-17','Home Video/DVD'),
	(312,'IAB19-18','Internet Technology'),
	(313,'IAB19-19','Java'),
	(314,'IAB19-20','JavaScript'),
	(315,'IAB19-21','Mac Support'),
	(316,'IAB19-22','MP3/MIDI'),
	(317,'IAB19-23','Net Conferencing'),
	(318,'IAB19-24','Net for Beginners'),
	(319,'IAB19-25','Network Security'),
	(320,'IAB19-26','Palmtops/PDAs'),
	(321,'IAB19-27','PC Support'),
	(322,'IAB19-28','Portable'),
	(323,'IAB19-29','Entertainment'),
	(324,'IAB19-30','Shareware/Freeware'),
	(325,'IAB19-31','Unix'),
	(326,'IAB19-32','Visual Basic'),
	(327,'IAB19-33','Web Clip Art'),
	(328,'IAB19-34','Web Design/HTML'),
	(329,'IAB19-35','Web Search'),
	(330,'IAB19-36','Windows'),
	(331,'IAB20','Travel'),
	(332,'IAB20-1','Adventure Travel'),
	(333,'IAB20-2','Africa'),
	(334,'IAB20-3','Air Travel'),
	(335,'IAB20-4','Australia & New Zealand'),
	(336,'IAB20-5','Bed & Breakfasts'),
	(337,'IAB20-6','Budget Travel'),
	(338,'IAB20-7','Business Travel'),
	(339,'IAB20-8','By US Locale'),
	(340,'IAB20-9','Camping'),
	(341,'IAB20-10','Canada'),
	(342,'IAB20-11','Caribbean'),
	(343,'IAB20-12','Cruises'),
	(344,'IAB20-13','Eastern Europe'),
	(345,'IAB20-14','Europe'),
	(346,'IAB20-15','France'),
	(347,'IAB20-16','Greece'),
	(348,'IAB20-17','Honeymoons/Getaways'),
	(349,'IAB20-18','Hotels'),
	(350,'IAB20-19','Italy'),
	(351,'IAB20-20','Japan'),
	(352,'IAB20-21','Mexico & Central America'),
	(353,'IAB20-22','National Parks'),
	(354,'IAB20-23','South America'),
	(355,'IAB20-24','Spas'),
	(356,'IAB20-25','Theme Parks'),
	(357,'IAB20-26','Traveling with Kids'),
	(358,'IAB20-27','United Kingdom'),
	(359,'IAB21','Real Estate'),
	(360,'IAB21-1','Apartments'),
	(361,'IAB21-2','Architects'),
	(362,'IAB21-3','Buying/Selling Homes'),
	(363,'IAB22','Shopping'),
	(364,'IAB22-1','Contests & Freebies'),
	(365,'IAB22-2','Couponing'),
	(366,'IAB22-3','Comparison'),
	(367,'IAB22-4','Engines'),
	(368,'IAB23','Religion & Spirituality'),
	(369,'IAB23-1','Alternative Religions'),
	(370,'IAB23-2','Atheism/Agnosticism'),
	(371,'IAB23-3','Buddhism'),
	(372,'IAB23-4','Catholicism'),
	(373,'IAB23-5','Christianity'),
	(374,'IAB23-6','Hinduism'),
	(375,'IAB23-7','Islam'),
	(376,'IAB23-8','Judaism'),
	(377,'IAB23-9','Latter-Day Saints'),
	(378,'IAB23-10','Pagan/Wiccan'),
	(379,'IAB24','Uncategorized'),
	(380,'IAB25','Non-Standard Content'),
	(381,'IAB25-1','Unmoderated UGC'),
	(382,'IAB25-2','Extreme Graphic/Explicit Violence'),
	(383,'IAB25-3','Pornography'),
	(384,'IAB25-4','Profane Content'),
	(385,'IAB25-5','Hate Content'),
	(386,'IAB25-6','Under Construction'),
	(387,'IAB25-7','Incentivized'),
	(388,'IAB26','Illegal Content'),
	(389,'IAB26-1','Illegal Content'),
	(390,'IAB26-2','Warez'),
	(391,'IAB26-3','Spyware/Malware'),
	(392,'IAB26-4','CopyrightInfringement');
	

Indeed helpful 👍

Sometimes all you need is a ready to run SQL script, thanks!

The NAME column is a perfect Candide for a key, why the need for ID?