Largest cities in the US SQL Database Dump for MySQL, Microsoft Access and Oracle

Preview
-- 
-- Create table `largest_cities_in_usa`
-- 

CREATE TABLE `largest_cities_in_usa` (
  `id` int(11) NOT NULL auto_increment,
  `city` varchar(200) NOT NULL,
  `state` varchar(200) NOT NULL,
  `population` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=62 ;

-- 
-- Dumping data for table `largest_cities_in_usa`
-- 

INSERT INTO `largest_cities_in_usa` ( `id` , `city` , `state` , `population` ) VALUES
(1, 'New York', 'New York', '8,084,316'),
(2, 'Los Angeles', 'California', '3,798,981'),
(3, 'Chicago', 'Illinois', '2,886,251'),
(4, 'Houston', 'Texas', '2,009,834'),
(5, 'Philadelphia', 'Pennsylvania', '1,492,231'),
(6, 'Phoenix', 'Arizona', '1,371,960'),
(7, 'San Diego', 'California', '1,259,532'),
(8, 'Dallas', 'Texas', '1,211,467'),
(9, 'San Antonio', 'Texas', '1,194,222'),
(10, 'Detroit', 'Michigan', '925,051'),
(11, 'San Jose', 'California', '900,443'),
(12, 'Indianapolis', 'Indiana', '783,612'),
(13, 'San Francisco', 'California', '764,049'),
(14, 'Columbus', 'Ohio', '725,228'),
(15, 'Austin', 'Texas', '671,873'),
(16, 'Baltimore', 'Maryland', '638,614'),
(17, 'Milwaukee', 'Wisconsin', '590,895'),
(18, 'Boston', 'Massachusetts', '589,281'),
(19, 'Washington', 'District of Columbia', '570,898'),
(20, 'El Paso', 'Texas', '577,415'),
(21, 'Seattle', 'Washington', '570,426'),
(22, 'Denver', 'Colorado', '560,415'),
(23, 'Charlotte', 'North Carolina', '580,597'),
(24, 'Fort Worth', 'Texas', '567,516'),
(25, 'Portland', 'Oregon', '539,438'),
(26, 'Oklahoma City', 'Oklahoma', '519,034'),
(27, 'Tucson', 'Arizona', '503,151'),
(28, 'New Orleans', 'Louisiana', '473,681'),
(29, 'Las Vegas', 'Nevada', '508,604'),
(30, 'Cleveland', 'Ohio', '467,851'),
(31, 'Long Beach', 'California', '472,412'),
(32, 'Albuquerque', 'New Mexico', '463,874'),
(33, 'Kansas City', 'Missouri', '443,471'),
(34, 'Fresno', 'California', '445,227'),
(35, 'Virginia Beach', 'Virginia', '433,934'),
(36, 'Atlanta', 'Georgia', '424,868'),
(37, 'Sacramento', 'California', '435,245'),
(38, 'Oakland', 'California', '402,777'),
(39, 'Mesa', 'Arizona', '426,841'),
(40, 'Tulsa', 'Oklahoma', '391,908'),
(41, 'Omaha', 'Nebraska', '399,357'),
(42, 'Minneapolis', 'Minnesota', '375,635'),
(43, 'Honolulu', 'Hawaii', '378,155'),
(44, 'Colorado Springs', 'Colorado', '371,182'),
(45, 'St. Louis', 'Missouri', '338,353'),
(46, 'Wichita', 'Kansas', '355,126'),
(47, 'Santa Ana', 'California', '343,41
To view the full dump, please login
SQL database dumps

Largest cities in the US

Navigation

Popular databases
