-- Top 100 Convention Centers
-- Import via phpMyAdmin: select nettrans database, click Import, choose this file

USE nettrans;

INSERT INTO locations (location_name, company_name, address, city, state, zip, country, location_type) VALUES
('Las Vegas Convention Center', 'Las Vegas Convention Center', '3150 Paradise Rd', 'Las Vegas', 'NV', '89109', 'USA', 'convention_center'),
('McCormick Place', 'McCormick Place', '2301 S King Dr', 'Chicago', 'IL', '60616', 'USA', 'convention_center'),
('Orange County Convention Center', 'Orange County Convention Center', '9800 International Dr', 'Orlando', 'FL', '32819', 'USA', 'convention_center'),
('Georgia World Congress Center', 'Georgia World Congress Center', '285 Andrew Young International Blvd NW', 'Atlanta', 'GA', '30313', 'USA', 'convention_center'),
('Javits Center', 'Jacob K. Javits Convention Center', '429 11th Ave', 'New York', 'NY', '10001', 'USA', 'convention_center'),
('Moscone Center', 'Moscone Center', '747 Howard St', 'San Francisco', 'CA', '94103', 'USA', 'convention_center'),
('Kay Bailey Hutchison Convention Center', 'Kay Bailey Hutchison Convention Center', '650 S Griffin St', 'Dallas', 'TX', '75202', 'USA', 'convention_center'),
('Houston Convention Center', 'George R. Brown Convention Center', '1001 Avenida De Las Americas', 'Houston', 'TX', '77010', 'USA', 'convention_center'),
('Phoenix Convention Center', 'Phoenix Convention Center', '100 N 3rd St', 'Phoenix', 'AZ', '85004', 'USA', 'convention_center'),
('San Diego Convention Center', 'San Diego Convention Center', '111 W Harbor Dr', 'San Diego', 'CA', '92101', 'USA', 'convention_center'),
('Boston Convention & Exhibition Center', 'Boston Convention & Exhibition Center', '415 Summer St', 'Boston', 'MA', '02210', 'USA', 'convention_center'),
('Colorado Convention Center', 'Colorado Convention Center', '700 14th St', 'Denver', 'CO', '80202', 'USA', 'convention_center'),
('Cobo Center', 'Huntington Place', '1 Washington Blvd', 'Detroit', 'MI', '48226', 'USA', 'convention_center'),
('Mandalay Bay Convention Center', 'Mandalay Bay Convention Center', '3950 S Las Vegas Blvd', 'Las Vegas', 'NV', '89119', 'USA', 'convention_center'),
('Venetian Expo', 'Venetian Expo & Convention Center', '201 Sands Ave', 'Las Vegas', 'NV', '89169', 'USA', 'convention_center'),
('Caesars Forum', 'Caesars Forum Conference Center', '3911 Koval Ln', 'Las Vegas', 'NV', '89109', 'USA', 'convention_center'),
('Wynn Las Vegas Convention Center', 'Wynn Las Vegas Convention Center', '3131 S Las Vegas Blvd', 'Las Vegas', 'NV', '89109', 'USA', 'convention_center'),
('Walter E. Washington Convention Center', 'Walter E. Washington Convention Center', '801 Mount Vernon Place NW', 'Washington', 'DC', '20001', 'USA', 'convention_center'),
('America\'s Center', 'America\'s Center Convention Complex', '701 Convention Plaza', 'St. Louis', 'MO', '63101', 'USA', 'convention_center'),
('Minneapolis Convention Center', 'Minneapolis Convention Center', '1301 2nd Ave S', 'Minneapolis', 'MN', '55403', 'USA', 'convention_center'),
('Music City Center', 'Music City Center', '201 5th Ave S', 'Nashville', 'TN', '37203', 'USA', 'convention_center'),
('Ernest N. Morial Convention Center', 'Ernest N. Morial Convention Center', '900 Convention Center Blvd', 'New Orleans', 'LA', '70130', 'USA', 'convention_center'),
('Baltimore Convention Center', 'Baltimore Convention Center', '1 W Pratt St', 'Baltimore', 'MD', '21201', 'USA', 'convention_center'),
('David L. Lawrence Convention Center', 'David L. Lawrence Convention Center', '1000 Fort Duquesne Blvd', 'Pittsburgh', 'PA', '15222', 'USA', 'convention_center'),
('Pennsylvania Convention Center', 'Pennsylvania Convention Center', '1101 Arch St', 'Philadelphia', 'PA', '19107', 'USA', 'convention_center'),
('Greater Columbus Convention Center', 'Greater Columbus Convention Center', '400 N High St', 'Columbus', 'OH', '43215', 'USA', 'convention_center'),
('Duke Energy Convention Center', 'Duke Energy Convention Center', '525 Elm St', 'Cincinnati', 'OH', '45202', 'USA', 'convention_center'),
('Cleveland Convention Center', 'Huntington Convention Center of Cleveland', '300 Lakeside Ave E', 'Cleveland', 'OH', '44114', 'USA', 'convention_center'),
('Kentucky International Convention Center', 'Kentucky International Convention Center', '221 S 4th St', 'Louisville', 'KY', '40202', 'USA', 'convention_center'),
('Indiana Convention Center', 'Indiana Convention Center', '100 S Capitol Ave', 'Indianapolis', 'IN', '46225', 'USA', 'convention_center'),
('Cobo Center Detroit', 'Huntington Place Detroit', '1 Washington Blvd', 'Detroit', 'MI', '48226', 'USA', 'convention_center'),
('DeVos Place Convention Center', 'DeVos Place Convention Center', '303 Monroe Ave NW', 'Grand Rapids', 'MI', '49503', 'USA', 'convention_center'),
('Midwest Airlines Center', 'Baird Center', '400 W Wisconsin Ave', 'Milwaukee', 'WI', '53203', 'USA', 'convention_center'),
('Kansas City Convention Center', 'Kansas City Convention Center', '301 W 13th St', 'Kansas City', 'MO', '64105', 'USA', 'convention_center'),
('Cox Convention Center', 'Cox Convention Center', '1 Myriad Gardens', 'Oklahoma City', 'OK', '73102', 'USA', 'convention_center'),
('Tulsa Convention Center', 'Tulsa Convention Center', '100 Civic Center', 'Tulsa', 'OK', '74103', 'USA', 'convention_center'),
('Henry B. Gonzalez Convention Center', 'Henry B. Gonzalez Convention Center', '900 E Market St', 'San Antonio', 'TX', '78205', 'USA', 'convention_center'),
('Austin Convention Center', 'Austin Convention Center', '500 E Cesar Chavez St', 'Austin', 'TX', '78701', 'USA', 'convention_center'),
('Fort Worth Convention Center', 'Fort Worth Convention Center', '1201 Houston St', 'Fort Worth', 'TX', '76102', 'USA', 'convention_center'),
('New Orleans Morial Convention Center', 'New Orleans Morial Convention Center', '900 Convention Center Blvd', 'New Orleans', 'LA', '70130', 'USA', 'convention_center'),
('Broward County Convention Center', 'Broward County Convention Center', '1950 Eisenhower Blvd', 'Fort Lauderdale', 'FL', '33316', 'USA', 'convention_center'),
('Miami Beach Convention Center', 'Miami Beach Convention Center', '1901 Convention Center Dr', 'Miami Beach', 'FL', '33139', 'USA', 'convention_center'),
('Tampa Convention Center', 'Tampa Convention Center', '333 S Franklin St', 'Tampa', 'FL', '33602', 'USA', 'convention_center'),
('Gaylord Opryland Convention Center', 'Gaylord Opryland Resort & Convention Center', '2800 Opryland Dr', 'Nashville', 'TN', '37214', 'USA', 'convention_center'),
('Gaylord Texan Convention Center', 'Gaylord Texan Resort & Convention Center', '1501 Gaylord Trail', 'Grapevine', 'TX', '76051', 'USA', 'convention_center'),
('Gaylord National Convention Center', 'Gaylord National Resort & Convention Center', '201 Waterfront St', 'National Harbor', 'MD', '20745', 'USA', 'convention_center'),
('Gaylord Rockies Convention Center', 'Gaylord Rockies Resort & Convention Center', '6700 N Gaylord Rockies Blvd', 'Aurora', 'CO', '80019', 'USA', 'convention_center'),
('Gaylord Palms Convention Center', 'Gaylord Palms Resort & Convention Center', '6000 W Osceola Pkwy', 'Kissimmee', 'FL', '34746', 'USA', 'convention_center'),
('Salt Lake City Convention Center', 'Salt Palace Convention Center', '90 S West Temple', 'Salt Lake City', 'UT', '84101', 'USA', 'convention_center'),
('Portland Convention Center', 'Oregon Convention Center', '777 NE Martin Luther King Jr Blvd', 'Portland', 'OR', '97232', 'USA', 'convention_center'),
('Washington State Convention Center', 'Seattle Convention Center', '705 Pike St', 'Seattle', 'WA', '98101', 'USA', 'convention_center'),
('Spokane Convention Center', 'Spokane Convention Center', '334 W Spokane Falls Blvd', 'Spokane', 'WA', '99201', 'USA', 'convention_center'),
('Reno-Sparks Convention Center', 'Reno-Sparks Convention Center', '4590 S Virginia St', 'Reno', 'NV', '89502', 'USA', 'convention_center'),
('Sacramento Convention Center', 'Sacramento Convention Center', '1400 J St', 'Sacramento', 'CA', '95814', 'USA', 'convention_center'),
('Long Beach Convention Center', 'Long Beach Convention & Entertainment Center', '300 E Ocean Blvd', 'Long Beach', 'CA', '90802', 'USA', 'convention_center'),
('Anaheim Convention Center', 'Anaheim Convention Center', '800 W Katella Ave', 'Anaheim', 'CA', '92802', 'USA', 'convention_center'),
('Los Angeles Convention Center', 'Los Angeles Convention Center', '1201 S Figueroa St', 'Los Angeles', 'CA', '90015', 'USA', 'convention_center'),
('San Jose Convention Center', 'San Jose Convention Center', '150 W San Carlos St', 'San Jose', 'CA', '95113', 'USA', 'convention_center'),
('Albuquerque Convention Center', 'Albuquerque Convention Center', '401 2nd St NW', 'Albuquerque', 'NM', '87102', 'USA', 'convention_center'),
('El Paso Convention Center', 'El Paso Convention Center', '1 Civic Center Plaza', 'El Paso', 'TX', '79901', 'USA', 'convention_center'),
('Tucson Convention Center', 'Tucson Convention Center', '260 S Church Ave', 'Tucson', 'AZ', '85701', 'USA', 'convention_center'),
('Raleigh Convention Center', 'Raleigh Convention Center', '500 S Salisbury St', 'Raleigh', 'NC', '27601', 'USA', 'convention_center'),
('Charlotte Convention Center', 'Charlotte Convention Center', '501 S College St', 'Charlotte', 'NC', '28202', 'USA', 'convention_center'),
('Greensboro Convention Center', 'Greensboro Convention Center', '300 N Elm St', 'Greensboro', 'NC', '27401', 'USA', 'convention_center'),
('Columbia Convention Center', 'Columbia Metropolitan Convention Center', '1101 Lincoln St', 'Columbia', 'SC', '29201', 'USA', 'convention_center'),
('Charleston Convention Center', 'Charleston Area Convention Center', '5001 Coliseum Dr', 'Charleston', 'WV', '25306', 'USA', 'convention_center'),
('Richmond Convention Center', 'Greater Richmond Convention Center', '403 N 3rd St', 'Richmond', 'VA', '23219', 'USA', 'convention_center'),
('Virginia Beach Convention Center', 'Virginia Beach Convention Center', '1000 19th St', 'Virginia Beach', 'VA', '23451', 'USA', 'convention_center'),
('Hartford Convention Center', 'Connecticut Convention Center', '100 Columbus Blvd', 'Hartford', 'CT', '06103', 'USA', 'convention_center'),
('Providence Convention Center', 'Rhode Island Convention Center', '1 Sabin St', 'Providence', 'RI', '02903', 'USA', 'convention_center'),
('Buffalo Convention Center', 'Buffalo Niagara Convention Center', '153 Franklin St', 'Buffalo', 'NY', '14202', 'USA', 'convention_center'),
('Albany Convention Center', 'Albany Capital Center', '55 Eagle St', 'Albany', 'NY', '12207', 'USA', 'convention_center'),
('Atlantic City Convention Center', 'Atlantic City Convention Center', '1 Convention Blvd', 'Atlantic City', 'NJ', '08401', 'USA', 'convention_center'),
('Meadowlands Exposition Center', 'Meadowlands Exposition Center', '355 Plaza Dr', 'Secaucus', 'NJ', '07094', 'USA', 'convention_center'),
('Omaha Convention Center', 'CHI Health Center Omaha', '455 N 10th St', 'Omaha', 'NE', '68102', 'USA', 'convention_center'),
('Des Moines Convention Center', 'Iowa Events Center', '730 3rd St', 'Des Moines', 'IA', '50309', 'USA', 'convention_center'),
('Sioux Falls Convention Center', 'Sioux Falls Convention Center', '1201 N West Ave', 'Sioux Falls', 'SD', '57104', 'USA', 'convention_center'),
('Fargo Convention Center', 'Fargo Civic Center', '207 4th St N', 'Fargo', 'ND', '58102', 'USA', 'convention_center'),
('Billings Convention Center', 'Billings Convention Center', '1223 3rd Ave N', 'Billings', 'MT', '59101', 'USA', 'convention_center'),
('Boise Convention Center', 'Boise Centre', '850 W Front St', 'Boise', 'ID', '83702', 'USA', 'convention_center'),
('Anchorage Convention Center', 'Dena\'ina Civic & Convention Center', '600 W 7th Ave', 'Anchorage', 'AK', '99501', 'USA', 'convention_center'),
('Honolulu Convention Center', 'Hawaii Convention Center', '1801 Kalakaua Ave', 'Honolulu', 'HI', '96815', 'USA', 'convention_center'),
('Jackson Convention Center', 'Jackson Convention Complex', '105 E Pascagoula St', 'Jackson', 'MS', '39201', 'USA', 'convention_center'),
('Memphis Convention Center', 'Memphis Cook Convention Center', '255 N Main St', 'Memphis', 'TN', '38103', 'USA', 'convention_center'),
('Knoxville Convention Center', 'Knoxville Convention Center', '701 Henley St', 'Knoxville', 'TN', '37902', 'USA', 'convention_center'),
('Birmingham Convention Center', 'BJCC Convention Center', '2100 Richard Arrington Jr Blvd N', 'Birmingham', 'AL', '35203', 'USA', 'convention_center'),
('Montgomery Convention Center', 'Renaissance Montgomery Hotel & Spa at the Convention Center', '201 Tallapoosa St', 'Montgomery', 'AL', '36104', 'USA', 'convention_center'),
('Little Rock Convention Center', 'Statehouse Convention Center', '101 E Markham St', 'Little Rock', 'AR', '72201', 'USA', 'convention_center'),
('Shreveport Convention Center', 'Shreveport Convention Center', '400 Caddo St', 'Shreveport', 'LA', '71101', 'USA', 'convention_center'),
('Corpus Christi Convention Center', 'American Bank Center', '1901 N Shoreline Blvd', 'Corpus Christi', 'TX', '78401', 'USA', 'convention_center'),
('Lubbock Convention Center', 'Lubbock Memorial Civic Center', '1501 Mac Davis Ln', 'Lubbock', 'TX', '79401', 'USA', 'convention_center'),
('Amarillo Convention Center', 'Amarillo Civic Center Complex', '401 S Buchanan St', 'Amarillo', 'TX', '79101', 'USA', 'convention_center'),
('Wichita Convention Center', 'Century II Convention Center', '225 W Douglas Ave', 'Wichita', 'KS', '67202', 'USA', 'convention_center'),
('Overland Park Convention Center', 'Overland Park Convention Center', '6000 College Blvd', 'Overland Park', 'KS', '66211', 'USA', 'convention_center'),
('Springfield Convention Center', 'Springfield Expo Center', '635 St Louis St', 'Springfield', 'MO', '65806', 'USA', 'convention_center'),
('Lexington Convention Center', 'Lexington Convention Center', '430 W Vine St', 'Lexington', 'KY', '40507', 'USA', 'convention_center'),
('Chattanooga Convention Center', 'Chattanooga Convention Center', '1150 Carter St', 'Chattanooga', 'TN', '37402', 'USA', 'convention_center'),
('Savannah Convention Center', 'Savannah Convention Center', '1 International Dr', 'Savannah', 'GA', '31401', 'USA', 'convention_center'),
('Jacksonville Convention Center', 'Prime Osborn Convention Center', '1000 Water St', 'Jacksonville', 'FL', '32204', 'USA', 'convention_center'),
('Daytona Beach Convention Center', 'Ocean Center', '101 N Atlantic Ave', 'Daytona Beach', 'FL', '32118', 'USA', 'convention_center');

SELECT CONCAT('Inserted ', COUNT(*), ' convention centers') AS result FROM locations WHERE location_type = 'convention_center';