business category sql

CREATE TABLE `business_category` (
  `ID` int(11) NOT NULL,
  `patent_business_category_ID` int(11) NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='business or industry category';


INSERT INTO `business_category` (`ID`, `patent_business_category_ID`, `title`) VALUES
(11, 0, 'Agriculture, Forestry, Fishing & Hunting'),
(21, 0, 'Mining'),
(22, 0, 'Utilities'),
(52, 0, 'Finance and Insurance'),
(23, 0, 'Construction'),
(31, 0, 'Manufacturing'),
(42, 0, 'Wholesale Trade'),
(44, 0, 'Retail Trade'),
(48, 0, 'Transportation and Warehousing'),
(51, 0, 'Information'),
(53, 0, ' Real Estate and Rental and Leasing'),
(54, 0, 'Professional, Scientific and Technical Services'),
(55, 0, ' Management of Companies and Enterprises'),
(56, 0, 'Administrative and Support and Waste Management'),
(61, 0, ' Educational Services'),
(99, 0, ' Central Administrative Office Activity'),
(81, 0, ' Other Services (except Public Administration)'),
(72, 0, 'Accomodation and Food Services'),
(71, 0, 'Arts, Entertainment and Recreation'),
(62, 0, 'Health Care and Social Assistance'),
(1110, 11, 'Crop and Animal Production'),
(1130, 11, 'Forestry, Logging, Fishing, Hunting, Trapping and Agricultural Support Activities'),
(2110, 21, 'Oil and Gas Extraction'),
(2121, 21, 'Coal Mining'),
(2122, 21, 'Metal Ore Mining'),
(2123, 21, 'Nonmetallic Mineral Mining and Quarrying'),
(2130, 21, 'Support Activities for Oil and Gas Operations'),
(2131, 21, 'Support Activities for Solid Mineral Operations'),
(2211, 22, 'Electric Power Generation, Transmission and Distribution'),
(2212, 22, 'Natural Gas Distribution'),
(2213, 22, 'Water, Sewage and Other Systems'),
(2360, 23, 'Construction of Buildings'),
(2370, 23, 'Heavy and Civil Engineering Construction'),
(2380, 23, 'Specialty Trade Contractors'),
(3121, 31, 'Beverage Manufacturing'),
(3122, 31, 'Tobacco Manufacturing'),
(3130, 31, 'Textile Mills and Textile Product Mills'),
(3150, 31, 'Apparel Manufacturing'),
(3160, 31, 'Leather and Allied Product Manufacturing'),
(3210, 31, 'Wood Product Manufacturing'),
(3220, 31, 'Paper Manufacturing'),
(3230, 21, 'Printing and Related Support Activities'),
(3240, 31, 'Petroleum and Coal Products Manufacturing'),
(3251, 31, 'Basic Chemical, Resin, Synthetic Rubber and Fiber Manufactuing'),
(3253, 31, 'Pesticide, Fertilizer and Other Agricultural Chemical Manufacturing'),
(3254, 31, 'Pharmaceutical and Medicine Manufacturing'),
(3259, 31, 'Paint, Adhesive, Soap and Other Chemical Manufacturing'),
(3260, 31, 'Plastics and Rubber Products Manufacturing (except inflatable boats)'),
(3271, 31, 'Clay and Glass Products Manufacturing'),
(3279, 31, 'Cement, Concrete, Lime, Gypsum and Other Nonmetallic Mineral Product Manufacturing'),
(3311, 31, 'Iron and Steel Mills, Ferroalloy Manufacturing and Steel Product Manufacturing from Purchased Steel'),
(3313, 31, 'Nonferrous Metals Production and Processing'),
(3315, 31, 'Ferrous and Nonferrous Foundries'),
(3320, 31, 'Fabricated Metal Product Manufacturing'),
(3331, 31, 'Agriculture, Construction and Mining Machinery Manufacturing'),
(3332, 31, 'Industrial, Metalworking and General Purpose Machinery Manufacturing (Including Laboratory Apparatus)'),
(3333, 31, 'Commercial, Service Industry, Temperature Control and Air-Flow Control Machinery Manufacturing'),
(3336, 31, 'Engine, Turbine and Power Transmission Equipment Manufacturing'),
(3341, 31, 'Computer and Peripheral Equipment Manufacturing'),
(3342, 31, 'Communications, Audio and Video Equipment Manufacturing'),
(3344, 31, 'Semiconductor and Other Electronic Component Manufacturing'),
(3345, 31, 'Navigational, Measuring, Electromedical, and Control Instruments Manufacturing, Radio/Television Broadcasting and Wireless Communications Equipment Manufacturing, Communications Signal Testing and Evaluation Equipment'),
(3346, 31, 'Manufacturing and Reproducing Magnetic and Optical Media'),
(3350, 31, 'Electrical Equipment, Appliance and Component Manufacturing'),
(3361, 31, 'Motor Vehicle, Body, Trailer and Parts Manufacturing'),
(3364, 31, 'Aerospace Product and Parts Manufacturing'),
(3369, 31, 'Other Transportation Equipment Manufacturing (Including inflatable boats)'),
(3370, 31, 'Furniture and Related Product Manufacturing (Including Laboratory Furniture)'),
(3391, 31, 'Medical Equipment and Supplies Manufacturing'),
(3399, 31, 'Other Miscellaneous Manufacturing'),
(4230, 42, 'Merchant Wholesalers, Durable Goods'),
(4240, 42, 'Merchant Wholesalers, Nondurable Goods'),
(4250, 42, 'Wholesale Electronic Markets and Agents and Brokers'),
(4410, 44, 'Motor Vehicles and Parts Dealers'),
(4430, 44, 'Electronics and Appliance Stores'),
(4450, 44, 'Food and Beverage Stores'),
(4480, 44, 'Clothing and Clothing Accessories Stores'),
(4520, 44, 'General Merchandise Stores'),
(4540, 44, 'Nonstore Retailers'),
(4599, 44, 'Other Retail Trade Stores, including Gasoline Stations'),
(4810, 48, 'Air Transportation'),
(4820, 48, 'Rail Transportation'),
(4830, 48, 'Water Transportation'),
(4840, 48, 'Truck Transportation'),
(4850, 48, 'Transit and Ground Passenger Transportation'),
(4861, 48, 'Pipeline Transportation of Crude Oil, Refined Petroleum and Miscellaneous Products, except Natural Gas'),
(4862, 48, 'Pipeline Transportation of Natural Gas'),
(4870, 48, 'Scenic and Sightseeing Transportation'),
(4880, 48, 'Support Activities for Transportation'),
(4920, 48, 'Couriers and Messengers'),
(4930, 48, 'Warehousing and Storage'),
(5111, 51, 'Newspaper, Periodical, Book and Directory Publishers (except Internet)'),
(5112, 51, 'Software Publishers (except Internet)'),
(5151, 51, 'Radio and Television Broadcasting (except Internet)'),
(5152, 51, 'Cable and Other Subscription Programming (except Internet)'),
(5171, 51, 'Wired Telecommunications Carriers, Cable and Other Program Distribution, Broadband Internet Service Providers (e.g., cable, DSL)'),
(5172, 51, 'Wireless Telecommunications Carriers (except Satellite)'),
(5179, 51, 'Telecommunications Resellers, Satellite and Other Telecommunications(Including Internet Service Providers providing services via client supplied telecommunication connection)'),
(5182, 51, 'Data Processing, Hosting and Related Services'),
(5190, 51, 'Other Information Services'),
(5210, 52, 'Monetary Authorities-Central Bank'),
(5221, 52, 'Depository Credit Intermediation'),
(5222, 52, 'Nondepository Credit Intermediation'),
(5223, 52, 'Activities Related to Credit Intermediation'),
(5230, 52, 'Securities, Commodity Contracts and Other Financial Investments and Related Activities'),
(5241, 52, 'Insurance Carriers'),
(5242, 52, 'Agencies, Brokerages and Other Insurance Related Activities'),
(5251, 52, 'Funds, Trusts and Other Financial Vehicles (including Mortgage REITS)'),
(5310, 53, 'Real Estate (including Equity REITS)'),
(5321, 53, 'Automotive Equipment Rental and Leasing'),
(5322, 53, 'Consumer Goods and General Rental Centers'),
(5324, 53, 'Commercial and Industrial Machinery and Equipment Rental and Leasing'),
(5330, 53, 'Lessors of Nonfinancial Intangible Assets'),
(5411, 54, 'Legal Services'),
(5412, 54, 'Accounting, Tax Preparation, Bookkeeping and Payroll Services'),
(5413, 54, 'Architectural, Engineering and Related Services'),
(5414, 54, 'Specialized Design Services'),
(5415, 54, 'Computer Systems Design and Related Service'),
(5416, 54, 'Management, Scientific and Technical Consulting Services'),
(5417, 54, 'Scientific Research and Development Services'),
(5418, 54, 'Advertising and Related Services'),
(5419, 54, 'Other Professional, Scientific and Technical Services'),
(5510, 55, 'Management of Companies and Enterprises'),
(5614, 56, 'Business Support Services'),
(5615, 56, 'Travel Arrangement and Reservation Services'),
(5616, 56, 'Investigation, Security and Services to Buildings and Dwellings'),
(5619, 56, 'Office Administrative, Facilities, Employment and Other Support Services'),
(5621, 56, 'Waste Collection, Treatment and Disposal'),
(5629, 56, 'Remediation and Other Waste Management Services'),
(6110, 61, 'Educational Services'),
(6211, 62, 'Offices of Physicians'),
(6212, 62, 'Offices of Dentists and Other Health Practitioners'),
(6215, 62, 'Medical and Diagnostics Laboratories'),
(6216, 62, 'Home Health Care Services'),
(6219, 62, 'Outpatient Care Centers and Other Ambulatory Health Care Services'),
(6221, 62, 'General Medical and Surgical Hospitals'),
(6222, 62, 'Psychiatric, Substance Abuse and Specialty Hospitals'),
(6230, 62, 'Nursing and Residential Care Facilities'),
(6240, 62, 'Social Assistance (except Child Day Care Services)'),
(6244, 62, 'Child Day Care Services'),
(7110, 71, 'Performing Arts, Spectator Sports and Related Industries'),
(7120, 71, 'Museums, Historical Sites and Similar Institutions'),
(7130, 71, 'Amusement, Gambling and Recreation Industries'),
(7210, 72, 'Traveler Accomodation Services'),
(7220, 72, 'Food Services and Drinking Places'),
(8111, 81, 'Automotive Repair and Maintenance'),
(8119, 81, 'Other Repair and Maintenance'),
(8120, 81, 'Personal Care, Death Care, Laundry and Other Personal Services'),
(8131, 81, 'Religious, Grantmaking, Social Advocacy, Civic and Social Organizations'),
(8139, 81, 'Business, Professional, Labor, Political and Similar Organizations'),
(9900, 99, 'Central Administrative Office Activity Unallocated to Other Industry Categories');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `business_category`
--
ALTER TABLE `business_category`
  ADD UNIQUE KEY `ID` (`ID`);
COMMIT;