Importing spreadsheet to phpMyAdmin
I have a list of states in a column and I am wondering if there is a way to upload that file in to phpmyadmin and place them in and use auto_increment so they all wont have the same ID.
Anyway to do this? Instead of entering each one.
Here is what i have in my table:
CREATE TABLE `states` (
`state_name` char(15) default NULL,
`id` int(5) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Anyway to do this? Instead of entering each one.
Here is what i have in my table:
CREATE TABLE `states` (
`state_name` char(15) default NULL,
`id` int(5) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Alrighty, thank you, if i have my ID field set as auto incement will that work as well? Create ID's for each one?
load data local infile 'Users/ryancoughlin/Docume
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(state_name)
I created the CSV and does the above look correct?
Ryan
load data local infile 'Users/ryancoughlin/Docume
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(state_name)
I created the CSV and does the above look correct?
Ryan
load data local infile 'Users/ryancoughlin/Documents/Web/rks/clients/newspapersofamerica/include/states.csv' into table states
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(state_name)
I ran this and I it loaded only Albama
load data local infile 'Users/ryancoughlin/Documents/Web/rks/clients/newspapersofamerica/include/states.csv' into table states
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(state_name)
I opened up the CSV and it is separated by new lines I dont see any commas. Any suggestions?
Hi Ryan
Are you using excel 2007? Because i have tried this on excel 2003
You need to check how the csv is terminating the row in your csv file. because maybe in excel 2007 it does not use '\n'. If you like tu upload the fiel so i can check it
Ruben
Are you using excel 2007? Because i have tried this on excel 2003
You need to check how the csv is terminating the row in your csv file. because maybe in excel 2007 it does not use '\n'. If you like tu upload the fiel so i can check it
Ruben
Hey man, i am using 2003, do I need 2007? Here is the file: www.rksdesignstudios.com/files/states.xls
OK...try this
load data local infile 'Users/ryancoughlin/Docume
fields terminated by '\n'
enclosed by '"'
(state_name)
load data local infile 'Users/ryancoughlin/Docume
fields terminated by '\n'
enclosed by '"'
(state_name)
I ran that and it only put it Alabama with an ID of one. I wonder why.
That is strange! I downloaded the excel file and save it as csv....run the query and insert the fifty states....have you tried Mysql query Browser instaed of PhpMyAdmin.
Also i can upload you the SQL file so you can upload directly into your database
Let me know
Also i can upload you the SQL file so you can upload directly into your database
Let me know
>>have you tried Mysql query Browser instaed of PhpMyAdmin.
What do you mean by that? If all else fails could you do the SQL file, I also have another one I am wondering if you can do, i will post it.
Ryan
What do you mean by that? If all else fails could you do the SQL file, I also have another one I am wondering if you can do, i will post it.
Ryan
Do you know using the same methods after looking at this XLS file? Since its LOTS OF CONTENT as you will see, haha. Do you know why mine wont work? Should i try a comp with 07 on it?
I am on a mac with 03.
Here is that file: http://www.rksdesignstudios.com/files/papers.xls Is the format of this possible to add in with ID's as well and then attach state ids
Say ME = 5 and you have the papers with ME have a s_id (state id) of 5 saying they belong to ME.
I am on a mac with 03.
Here is that file: http://www.rksdesignstudios.com/files/papers.xls Is the format of this possible to add in with ID's as well and then attach state ids
Say ME = 5 and you have the papers with ME have a s_id (state id) of 5 saying they belong to ME.
ok ryan, let me upload the sql file
Mysql Query Browser is part of a suite of Free tools for mysql similar to phphmyadmin but with a friendly look and easier to use
You can download the suite from Mysql website
Mysql Query Browser is part of a suite of Free tools for mysql similar to phphmyadmin but with a friendly look and easier to use
You can download the suite from Mysql website
Oh nice, i will look in to that!
Thank you!
Thank you!
Also you can try this:
load data local infile 'Users/ryancoughlin/Docume
fields terminated by '\r'
lines terminated by '\n'
(state_name)
load data local infile 'Users/ryancoughlin/Docume
fields terminated by '\r'
lines terminated by '\n'
(state_name)
It still only put in the first record. Hmm... Did you see that other file I sent you is that possible in that format? Do i need to name the headers at the top the field name?
Here is my SQL for that papers table for that other spreadsheet
CREATE TABLE `papers` (
`id` INT( 10 ) NOT NULL ,
`name` VARCHAR( 40 ) NOT NULL ,
`state` VARCHAR( 40 ) NOT NULL ,
`city` VARCHAR( 40 ) NOT NULL ,
`circulation` INT( 10 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
CREATE TABLE `papers` (
`id` INT( 10 ) NOT NULL ,
`name` VARCHAR( 40 ) NOT NULL ,
`state` VARCHAR( 40 ) NOT NULL ,
`city` VARCHAR( 40 ) NOT NULL ,
`circulation` INT( 10 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;
I miss the post of the other file. Try saving you excel file as 'CSV(MSDOS)' and then run the query to insert the data...maybe is saving the csv in mac format and the mysql server is running on windows or linux
Let me know because i do not have an account tu upload the sql files
I think i can upload them her in experts-echanges but do not know how
Let me know because i do not have an account tu upload the sql files
I think i can upload them her in experts-echanges but do not know how
Alrighty, I will try that and let you know, you can post the code here in the syntax box below.
Do you know how I would go about doing that other file? Since it has more than one column? Any thoughts?
Thanks,
Ryan
Do you know how I would go about doing that other file? Since it has more than one column? Any thoughts?
Thanks,
Ryan
OK, here is the sql of the first file
INSERT INTO `states` (`state_name`,`id`) VALUES
(' Alabama',1),
(' Alaska',2),
(' Arizona',3),
(' Arkansas',4),
(' California',5),
(' Colorado',6),
(' Connecticut',7),
(' Delaware',8),
(' Florida',9),
(' Georgia',10),
(' Hawaii',11),
(' Idaho',12),
(' Illinois',13),
(' Indiana',14),
(' Iowa',15),
(' Kansas',16),
(' Kentucky',17),
(' Louisiana',18),
(' Maine',19),
(' Maryland',20),
(' Massachuset',21),
(' Michigan',22),
(' Minnesota',23),
(' Mississippi',24),
(' Missouri',25),
(' Montana',26),
(' Nebraska',27),
(' Nevada',28),
(' New Hampshi',29),
(' New Jersey',30),
(' New Mexico',31),
(' New York',32),
(' North Carol',33),
(' North Dakot',34),
(' Ohio',35),
(' Oklahoma',36),
(' Oregon',37),
(' Pennsylvani',38),
(' Rhode Islan',39),
(' South Carol',40),
(' South Dakot',41),
(' Tennessee',42),
(' Texas',43),
(' Utah',44),
(' Vermont',45);
INSERT INTO `states` (`state_name`,`id`) VALUES
(' Virginia',46),
(' Washington',47),
(' West Virgin',48),
(' Wisconsin',49),
(' Wyoming',50);
and here is the sql for the second
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1,'Ketchikan Daily News','Ketchikan','AK',4117),
(2,'Fairbanks Daily News-Miner','Fairbanks','AK',14748),
(3,'Juneau Empire','Juneau','AK',6748),
(4,'Kodiak Daily Mirror','Kodiak','AK',2849),
(5,'Anchorage Daily News','Anchorage','AK',64109),
(6,'The Peninsula Clarion','Kenai','AK',5710),
(7,'The Daily Sitka Sentinel','Sitka','AK',2875),
(8,'Press-Register','Mobile','AL',99742),
(9,'The Birmingham News','Birmingham','AL',145655),
(10,'The Decatur Daily','Decatur','AL',20615),
(11,'The Huntsville Times','Huntsville','AL',52852),
(12,'The Enterprise Ledger','Enterprise','AL',10209),
(13,'Opelika-Auburn News','Opelika','AL',15139),
(14,'The Daily Sentinel','Scottsboro','AL',5469),
(15,'The Andalusia Star-News','Andalusia','AL',3364),
(16,'The Times Journal','Fort Payne','AL',4648),
(17,'The Alexander City Outlook','Alexander City','AL',5300),
(18,'Montgomery Advertiser','Montgomery','AL',47191),
(19,'Daily Mountain Eagle','Jasper','AL',10894),
(20,'The Messenger','Troy','AL',3328);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(21,'The Anniston Star','Anniston','AL',24843),
(22,'The Tuscaloosa News','Tuscaloosa','AL',34418),
(23,'The Gadsden Times','Gadsden','AL',20476),
(24,'The Cullman Times','Cullman','AL',11086),
(25,'Demopolis Times','Demopolis','AL',2850),
(26,'Clanton Advertiser','Clanton','AL',5000),
(27,'The News-Courier','Athens','AL',6662),
(28,'The Dothan Eagle','Dothan','AL',33632),
(29,'The Valley Times-News','Lanett','AL',7149),
(30,'The Selma Times-Journal','Selma','AL',7474),
(31,'TimesDaily','Florence','AL',30239),
(32,'The Daily Home','Talladega','AL',9872),
(33,'Banner-News','Magnolia','AR',3864),
(34,'The Baxter Bulletin','Mountain Home','AR',11456),
(35,'The Daily Citizen','Searcy','AR',5686),
(36,'The Paragould Daily Press','Paragould','AR',5276),
(37,'Pine Bluff Commercial','Pine Bluff','AR',18548),
(38,'Evening Times','West Memphis','AR',7109),
(39,'The Stuttgart Daily Leader','Stuttgart','AR',2397),
(40,'The Courier','Russellville','AR',10551);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(41,'Blytheville Courier News','Blytheville','AR',4074),
(42,'Benton County Daily Record','Bentonville','AR',10865),
(43,'Daily Siftings Herald','Arkadelphia','AR',2656),
(44,'The Benton Courier','Benton','AR',7580),
(45,'The Sentinel-Record','Hot Springs','AR',17643),
(46,'Times Record','Fort Smith','AR',39531),
(47,'Camden News','Camden','AR',4342),
(48,'The Morning News','Springdale','AR',33054),
(49,'De Queen Daily Citizen','De Queen','AR',2592),
(50,'Batesville Guard','Batesville','AR',9067),
(51,'Log Cabin Democrat','Conway','AR',10234),
(52,'South Arkansas Sunday News','El Dorado','AR',0),
(53,'Hope Star','Hope','AR',3031),
(54,'Times-Herald','Forrest City','AR',4475),
(55,'El Dorado News-Times','El Dorado','AR',9632),
(56,'The Daily World','Helena','AR',2157),
(57,'Malvern Daily Record','Malvern','AR',5015),
(58,'Harrison Daily Times','Harrison','AR',9424),
(59,'Northwest Arkansas Times','Fayetteville','AR',18017),
(60,'The Jonesboro Sun','Jonesboro','AR',20869);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(61,'Arkansas Democrat-Gazette','Little Rock','AR',182789),
(62,'Today\'s News-Herald','Lake Havasu City','AZ',9143),
(63,'Tucson Citizen','Tucson','AZ',25987),
(64,'Daily News-Sun','Sun City','AZ',16579),
(65,'Sierra Vista Herald','Sierra Vista','AZ',9037),
(66,'The Daily Dispatch','Douglas','AZ',2169),
(67,'The Kingman Daily Miner','Kingman','AZ',8757),
(68,'The Daily Territorial','Tucson','AZ',753),
(69,'The Arizona Daily Sun','Flagstaff','AZ',11519),
(70,'Casa Grande Dispatch','Casa Grande','AZ',9300),
(71,'Bisbee Daily Review','Bisbee','AZ',710),
(72,'Arizona Daily Star','Tucson','AZ',116345),
(73,'Mohave Valley Daily News','Bullhead City','AZ',8973),
(74,'East Valley Tribune/Scottsdale Tribune','Mesa','AZ',99711),
(75,'The Sun','Yuma','AZ',24208),
(76,'The Arizona Republic','Phoenix','AZ',433731),
(77,'Tucson Newspapers Inc.','Tucson','AZ',0),
(78,'The Daily Courier','Prescott','AZ',18323),
(79,'Kamloops Daily News','Kamloops','BC',12679);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(80,'Cranbrook Daily Townsman','Cranbrook','BC',3750),
(81,'Times Colonist','Victoria','BC',71558),
(82,'Nelson Daily News','Nelson','BC',3295),
(83,'Nanaimo Daily News','Nanaimo','BC',7466),
(84,'Trail Daily Times','Trail','BC',5800),
(85,'The Province','Vancouver','BC',141164),
(86,'The Prince George Citizen','Prince George','BC',15098),
(87,'The Vancouver Sun','Vancouver','BC',165144),
(88,'The Penticton Herald','Penticton','BC',7885),
(89,'Alberni Valley Times','Port Alberni','BC',4876),
(90,'The Daily News','Prince Rupert','BC',3020),
(91,'Pacific Newspaper Group Inc.','Vancouver','BC',0),
(92,'The Kimberley Daily Bulletin','Kimberley','BC',1852),
(93,'The Daily Courier','Kelowna','BC',16255),
(94,'Peace River Block Daily News','Dawson Creek','BC',2004),
(95,'Alaska Highway Daily News','Fort Saint John','BC',3790),
(96,'Western Edition','Palo Alto','CA',0),
(97,'The Argus','Fremont','CA',27858),
(98,'Times-Standard','Eureka','CA',19415);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(99,'The Union','Grass Valley','CA',15900),
(100,'News-Press','Glendale','CA',22093),
(101,'Daily Press','Victorville','CA',31537),
(102,'Visalia Times-Delta','Visalia','CA',20351),
(103,'Ventura County Sunday Star','Ventura','CA',0),
(104,'Daily Breeze','Torrance','CA',67020),
(105,'Ukiah Daily Journal','Ukiah','CA',6754),
(106,'The Whittier Daily News','Whittier','CA',16115),
(107,'The Record','Stockton','CA',58670),
(108,'The Daily Democrat','Woodland','CA',9126),
(109,'Ventura County Star','Ventura','CA',84785),
(110,'Tracy Press','Tracy','CA',7743),
(111,'Tulare Advance-Register','Tulare','CA',6811),
(112,'Siskiyou Daily News','Yreka','CA',5554),
(113,'Contra Costa Times','Walnut Creek','CA',168362),
(114,'Tahoe Daily Tribune','South Lake Tahoe','CA',7723),
(115,'San Mateo Daily Journal','San Mateo','CA',14800),
(116,'The Examiner','San Francisco','CA',165163),
(117,'Lodi News-Sentinel','Lodi','CA',16395),
(118,'The Monterey County Herald','Monterey','CA',30063);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(119,'Pasadena Star-News','Pasadena','CA',30251),
(120,'Antelope Valley Press','Palmdale','CA',22326),
(121,'The Desert Sun','Palm Springs','CA',55656),
(122,'Santa Maria Times','Santa Maria','CA',20336),
(123,'Santa Cruz Sentinel','Santa Cruz','CA',24597),
(124,'Los Angeles Times','Los Angeles','CA',815723),
(125,'Daily Commerce','Los Angeles','CA',1254),
(126,'Press-Telegram','Long Beach','CA',87600),
(127,'Madera Tribune','Madera','CA',4379),
(128,'Red Bluff Daily News','Red Bluff','CA',7065),
(129,'San Ramon Valley Herald','Pleasanton','CA',0),
(130,'Tri-Valley Herald','Pleasanton','CA',33326),
(131,'The Press-Enterprise','Riverside','CA',172593),
(132,'Santa Barbara News-Press','Santa Barbara','CA',38119),
(133,'The Tribune','San Luis Obispo','CA',37406),
(134,'Merced Sun-Star','Merced','CA',15275),
(135,'Daily News','Woodland Hills','CA',145528),
(136,'San Bernardino County Sun','San Bernardino','CA',60993),
(137,'The San Diego Union-Tribune','San Diego','CA',296331);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(138,'San Mateo County Times','San Mateo','CA',25571),
(139,'Daily Pilot','Costa Mesa','CA',22023),
(140,'Inland Valley Daily Bulletin','Ontario','CA',57238),
(141,'The Signal','Santa Clarita','CA',9180),
(142,'San Francisco Chronicle','San Francisco','CA',386564),
(143,'Investor\'s Business Daily','Los Angeles','CA',166669),
(144,'The Lompoc Record','Lompoc','CA',6434),
(145,'Manteca Bulletin','Manteca','CA',7022),
(146,'Record Searchlight','Redding','CA',34340),
(147,'The Porterville Recorder','Porterville','CA',9118),
(148,'Lake County Record-Bee','Lakeport','CA',7247),
(149,'The Salinas Californian','Salinas','CA',18290),
(150,'The Sacramento Bee','Sacramento','CA',279032),
(151,'The Daily Independent','Ridgecrest','CA',7900),
(152,'La Opinion (Spanish)','Los Angeles','CA',121026),
(153,'Imperial Valley Press','El Centro','CA',12026),
(154,'North County Times','Escondido','CA',91212),
(155,'Benicia Herald','Benicia','CA',3439),
(156,'Press-Dispatch','Barstow','CA',0);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(157,'Auburn Journal','Auburn','CA',10822),
(158,'Desert Dispatch','Barstow','CA',4578),
(159,'The Daily Triplicate','Crescent City','CA',4912),
(160,'The Daily Review','Hayward','CA',31389),
(161,'Daily Republic','Fairfield','CA',17710),
(162,'Napa Valley Register','Napa','CA',16923),
(163,'The Modesto Bee','Modesto','CA',80559),
(164,'Marin Independent Journal','Novato','CA',33675),
(165,'Mountain Democrat','Placerville','CA',12544),
(166,'Appeal-Democrat','Marysville','CA',21113),
(167,'The Daily Transcript','San Diego','CA',6404),
(168,'San Jose Mercury News','San Jose','CA',230870),
(169,'San Gabriel Valley Tribune','Covina','CA',43425),
(170,'Redlands Daily Facts','Redlands','CA',6618),
(171,'Times-Herald','Vallejo','CA',18345),
(172,'The Reporter','Vacaville','CA',16944),
(173,'Register-Pajaronian','Watsonville','CA',5268),
(174,'Press-Dispatch','Victorville','CA',0),
(175,'The Union Democrat','Sonora','CA',11729),
(176,'The Press Democrat','Santa Rosa','CA',84014);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(177,'Palo Alto Daily News','Palo Alto','CA',30000),
(178,'The Orange County Register','Santa Ana','CA',284613),
(179,'The Oakland Tribune','Oakland','CA',47768),
(180,'Free Lance','Hollister','CA',3221),
(181,'The Bakersfield Californian','Bakersfield','CA',62619),
(182,'The Davis Enterprise','Davis','CA',9468),
(183,'Chico Enterprise-Record','Chico','CA',31488),
(184,'The Hanford Sentinel','Hanford','CA',13717),
(185,'The Dispatch','Gilroy','CA',4451),
(186,'The Fresno Bee','Fresno','CA',157546),
(187,'Colorado Daily','Boulder','CO',20000),
(188,'The Valley Courier','Alamosa','CO',6000),
(189,'The Pueblo Chieftain','Pueblo','CO',50502),
(190,'Sunday Camera','Boulder','CO',0),
(191,'Glenwood Springs Post Independent','Glenwood Springs','CO',5064),
(192,'The Lamar Daily News','Lamar','CO',2353),
(193,'La Junta Tribune-Democrat','La Junta','CO',3721),
(194,'Daily Times-Call','Longmont','CO',21321),
(195,'Telluride Daily Planet','Telluride','CO',3841);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(196,'Rocky Ford Daily Gazette','Rocky Ford','CO',3013),
(197,'The Montrose Daily Press','Montrose','CO',5401),
(198,'Loveland Daily Reporter-Herald','Loveland','CO',17777),
(199,'Greeley Daily Tribune','Greeley','CO',25185),
(200,'Craig Daily Press','Craig','CO',3400),
(201,'Vail Daily','Vail','CO',10525),
(202,'Saturday Morning Press','Craig','CO',0),
(203,'Journal-Advocate','Sterling','CO',4823),
(204,'Summit Daily News','Frisco','CO',9725),
(205,'Durango Herald','Durango','CO',8820),
(206,'The Gazette','Colorado Springs','CO',98069),
(207,'Daily Camera','Boulder','CO',31102),
(208,'Rocky Mountain News','Denver','CO',253834),
(209,'The Denver Post','Denver','CO',254058),
(210,'The Daily Sentinel','Grand Junction','CO',31499),
(211,'Fort Morgan Times','Fort Morgan','CO',4033),
(212,'Daily Record','Canon City','CO',7941),
(213,'Steamboat Today','Steamboat Springs','CO',9688),
(214,'Fort Collins Coloradoan','Fort Collins','CO',27320),
(215,'The Chronicle-News','Trinidad','CO',3275);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(216,'The Aspen Times','Aspen','CO',11000),
(217,'Aspen Daily News','Aspen','CO',12500),
(218,'Denver Newspaper Agency','Denver','CO',0),
(219,'The Mountain Mail','Salida','CO',3494),
(220,'The Sunday Chieftain','Pueblo','CO',0),
(221,'The News-Times','Danbury','CT',28018),
(222,'Journal Inquirer','Manchester','CT',39798),
(223,'The Chronicle','Willimantic','CT',9491),
(224,'Republican-American','Waterbury','CT',52100),
(225,'The Advocate','Stamford','CT',24253),
(226,'The Day','New London','CT',36795),
(227,'The Herald Press','New Britain','CT',0),
(228,'The Herald','New Britain','CT',10453),
(229,'The Bristol Press','Bristol','CT',8899),
(230,'Connecticut Post','Bridgeport','CT',77015),
(231,'The Register Citizen','Torrington','CT',7812),
(232,'Norwich Bulletin','Norwich','CT',22418),
(233,'New Haven Register','New Haven','CT',84778),
(234,'The Sunday Hour','Norwalk','CT',0),
(235,'The Hour','Norwalk','CT',15371),
(236,'The Middletown Press','Middletown','CT',7016);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(237,'Record-Journal','Meriden','CT',21721),
(238,'Greenwich Time','Greenwich','CT',10457),
(239,'The Hartford Courant','Hartford','CT',175759),
(240,'The Washington Post','Washington','DC',699130),
(241,'The Washington Times','Washington','DC',100258),
(242,'The News Journal','Wilmington','DE',114435),
(243,'Delaware State News','Dover','DE',15950),
(244,'Sunday News Journal','Wilmington','DE',0),
(245,'El Nuevo Herald','Miami','FL',85038),
(246,'News Chief','Winter Haven','FL',9817),
(247,'Okeechobee News','Okeechobee','FL',2583),
(248,'The Tampa Tribune and The Tampa Times','Tampa','FL',0),
(249,'Treasure Coast News/Press-Tribune','Stuart','FL',102326),
(250,'The News-Press','Fort Myers','FL',88585),
(251,'South Florida Sun-Sentinel','Fort Lauderdale','FL',235154),
(252,'Charlotte Sun','Charlotte Harbor','FL',43131),
(253,'Citrus County Chronicle','Crystal River','FL',27106),
(254,'Cape Coral Daily Breeze','Cape Coral','FL',2015),
(255,'Daytona Beach News-Journal','Daytona Beach','FL',101875);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(256,'Naples Daily News','Naples','FL',58207),
(257,'The Florida Times-Union','Jacksonville','FL',154700),
(258,'Northwest Florida Daily News','Fort Walton Beach','FL',35840),
(259,'Orlando Sentinel','Orlando','FL',221826),
(260,'Sarasota Herald-Tribune','Sarasota','FL',107755),
(261,'The News Herald','Panama City','FL',29587),
(262,'The St. Augustine Record','Saint Augustine','FL',18300),
(263,'Palm Beach Daily News','Palm Beach','FL',6270),
(264,'Palatka Daily News','Palatka','FL',12048),
(265,'The Palm Beach Post','West Palm Beach','FL',167605),
(266,'The Tampa Tribune','Tampa','FL',220277),
(267,'Tallahassee Democrat','Tallahassee','FL',48749),
(268,'St. Petersburg Times','Saint Petersburg','FL',305854),
(269,'Pensacola News Journal','Pensacola','FL',60719),
(270,'The Ledger','Lakeland','FL',70487),
(271,'The Gainesville Sun','Gainesville','FL',47149),
(272,'Boca Raton News','Boca Raton','FL',13673),
(273,'Florida Today','Melbourne','FL',81807);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(274,'Lake City Reporter','Lake City','FL',8998),
(275,'The Key West Citizen','Key West','FL',8933),
(276,'Hernando Today','Brooksville','FL',15053),
(277,'Daily Sun','The Villages','FL',27818),
(278,'Highlands Today','Sebring','FL',16609),
(279,'Observer','New Smyrna Beach','FL',1981),
(280,'The Miami Herald','Miami','FL',279878),
(281,'Diario Las Americas (Spanish)','Miami','FL',69132),
(282,'The Daily Commercial','Leesburg','FL',22874),
(283,'The Bradenton Herald','Bradenton','FL',46807),
(284,'Ocala Star-Banner','Ocala','FL',49169),
(285,'Jackson County Floridan','Marianna','FL',6547),
(286,'The Newton Citizen','Covington','GA',5892),
(287,'The Houston Home Journal','Perry','GA',10160),
(288,'Saturday Citizen','Covington','GA',0),
(289,'Sunday Citizen','Covington','GA',0),
(290,'The Courier Herald','Dublin','GA',9272),
(291,'Sunday Citizen','Conyers','GA',0),
(292,'The Albany Herald','Albany','GA',24831),
(293,'Athens Banner-Herald','Athens','GA',28518);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(294,'La Grange Daily News','LaGrange','GA',13400),
(295,'The Augusta Chronicle','Augusta','GA',74168),
(296,'Douglas County Sentinel','Douglasville','GA',4173),
(297,'The Union-Recorder','Milledgeville','GA',7416),
(298,'News Daily','Jonesboro','GA',4588),
(299,'The Times','Gainesville','GA',19428),
(300,'Cordele Dispatch','Cordele','GA',4590),
(301,'The Rockdale Citizen','Conyers','GA',16210),
(302,'The Atlanta Journal-Constitution','Atlanta','GA',357399),
(303,'Waycross Journal-Herald','Waycross','GA',9568),
(304,'Statesboro Herald','Statesboro','GA',7699),
(305,'The Tifton Gazette','Tifton','GA',9046),
(306,'Thomasville Times-Enterprise','Thomasville','GA',9431),
(307,'The Daily Tribune News','Cartersville','GA',7233),
(308,'The Valdosta Daily Times','Valdosta','GA',15939),
(309,'Columbus Ledger-Enquirer','Columbus','GA',43568),
(310,'Gwinnett Daily Post','Lawrenceville','GA',64071),
(311,'Savannah Morning News','Savannah','GA',51952),
(312,'Rome News-Tribune','Rome','GA',17784);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(313,'The Moultrie Observer','Moultrie','GA',7198),
(314,'Marietta Daily Journal','Marietta','GA',17736),
(315,'Times-Georgian','Carrollton','GA',8515),
(316,'The Brunswick News','Brunswick','GA',15683),
(317,'The Times-Herald','Newnan','GA',10990),
(318,'Americus Times-Recorder','Americus','GA',6962),
(319,'The Macon Telegraph','Macon','GA',58922),
(320,'Saturday Citizen','Conyers','GA',0),
(321,'Griffin Daily News','Griffin','GA',8672),
(322,'The Daily Citizen','Dalton','GA',12784),
(323,'Forsyth County News','Cumming','GA',14059),
(324,'Cherokee Tribune','Canton','GA',5009),
(325,'The Honolulu Advertiser','Honolulu','HI',141934),
(326,'The Maui News','Wailuku','HI',21035),
(327,'Hawaii Tribune-Herald','Hilo','HI',19224),
(328,'West Hawaii Today','Kailua-Kona','HI',13594),
(329,'Sunday Advertiser','Honolulu','HI',0),
(330,'The Garden Island','Lihue','HI',9640),
(331,'Honolulu Star-Bulletin','Honolulu','HI',64305),
(332,'The Register','Oelwein','IA',2760);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(333,'The Tribune','Ames','IA',10086),
(334,'The Washington Evening Journal','Washington','IA',3462),
(335,'Times-Republican','Marshalltown','IA',10159),
(336,'Iowa City Press-Citizen','Iowa City','IA',13621),
(337,'Estherville Daily News','Estherville','IA',2282),
(338,'The Hawk Eye','Burlington','IA',19190),
(339,'Le Mars Daily Sentinel','Le Mars','IA',3044),
(340,'Ad Express & Daily Iowegian','Centerville','IA',2806),
(341,'Oskaloosa Herald','Oskaloosa','IA',3381),
(342,'Sunday Globe','Mason City','IA',0),
(343,'Daily Gate City','Keokuk','IA',4878),
(344,'Daily Times Herald','Carroll','IA',6321),
(345,'Atlantic News-Telegraph','Atlantic','IA',3398),
(346,'The Gazette','Cedar Rapids','IA',59923),
(347,'Boone News-Republican','Boone','IA',2478),
(348,'Mt. Pleasant News','Mount Pleasant','IA',2668),
(349,'The Fairfield Ledger','Fairfield','IA',3194),
(350,'Waterloo Courier','Waterloo','IA',41127),
(351,'The Daily Democrat','Fort Madison','IA',5057);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(352,'Telegraph Herald','Dubuque','IA',27962),
(353,'Des Moines Sunday Register','Des Moines','IA',0),
(354,'The Des Moines Register','Des Moines','IA',146050),
(355,'Clinton Herald','Clinton','IA',11689),
(356,'Chronicle Times','Cherokee','IA',2389),
(357,'The Daily Reporter','Spencer','IA',4004),
(358,'The Ottumwa Courier','Ottumwa','IA',13926),
(359,'Muscatine Journal','Muscatine','IA',7438),
(360,'Charles City Press','Charles City','IA',2824),
(361,'The Daily Freeman-Journal','Webster City','IA',2768),
(362,'The Messenger','Fort Dodge','IA',16812),
(363,'Cedar Valley Daily Times','Vinton','IA',2000),
(364,'Globe-Gazette','Mason City','IA',18445),
(365,'Quad-City Times','Davenport','IA',53286),
(366,'Valley News Today','Shenandoah','IA',2432),
(367,'Newton Daily News','Newton','IA',5476),
(368,'The Daily Nonpareil','Council Bluffs','IA',14359),
(369,'Creston News Advertiser','Creston','IA',5492),
(370,'Sioux City Journal','Sioux City','IA',41092);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(371,'North Idaho Sunday','Coeur d\'Alene','ID',0),
(372,'Moscow-Pullman Daily News','Moscow','ID',5492),
(373,'The Times-News','Twin Falls','ID',21465),
(374,'South Idaho Press','Burley','ID',3388),
(375,'The Morning News','Blackfoot','ID',4800),
(376,'The Idaho Statesman','Boise','ID',63661),
(377,'North Idaho Sunday','Sandpoint','ID',0),
(378,'Shoshone News-Press','Kellogg','ID',3315),
(379,'Lewiston Morning Tribune','Lewiston','ID',21539),
(380,'North Idaho Sunday','Kellogg','ID',0),
(381,'Post Register','Idaho Falls','ID',26542),
(382,'Coeur d\'Alene Press','Coeur d\'Alene','ID',21340),
(383,'Bonner County Daily Bee','Sandpoint','ID',4537),
(384,'Idaho State Journal','Pocatello','ID',16723),
(385,'Idaho Press-Tribune','Nampa','ID',18691),
(386,'Central Edition','Chicago','IL',0),
(387,'The Journal-Standard','Freeport','IL',12763),
(388,'The Telegraph','Dixon','IL',8260),
(389,'Northwest Herald','Crystal Lake','IL',38402),
(390,'The Beacon News','Aurora','IL',27983);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(391,'Chicago Sun-Times','Chicago','IL',382796),
(392,'Daily Southtown','Tinley Park','IL',48858),
(393,'The News-Gazette','Champaign','IL',41035),
(394,'The Southern Illinoisan','Carbondale','IL',28238),
(395,'Daily Herald','Arlington Heights','IL',151190),
(396,'Morning Sentinel','Centralia','IL',14313),
(397,'Daily Union','Shelbyville','IL',4156),
(398,'The Quincy Herald-Whig','Quincy','IL',21093),
(399,'The Pantagraph','Bloomington','IL',47759),
(400,'Chicago Defender','Chicago','IL',14479),
(401,'Edwardsville Intelligencer','Edwardsville','IL',4461),
(402,'Daily Ledger','Canton','IL',5428),
(403,'The Telegraph','Alton','IL',26060),
(404,'Belleville News-Democrat','Belleville','IL',52307),
(405,'Times-Courier','Charleston','IL',7150),
(406,'Jacksonville Journal-Courier','Jacksonville','IL',14687),
(407,'The Marion Daily Republican','Marion','IL',3957),
(408,'Lake County News-Sun','Waukegan','IL',18580),
(409,'Paxton Daily Record','Paxton','IL',2150);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(410,'Olney Daily Mail','Olney','IL',4330),
(411,'The Rock Island Argus','Rock Island','IL',12558),
(412,'The Sunday Journal','Kankakee','IL',0),
(413,'The Daily Journal','Kankakee','IL',28280),
(414,'Kane County Chronicle','Geneva','IL',12781),
(415,'Daily Record','Lawrenceville','IL',3964),
(416,'News-Tribune','La Salle','IL',17348),
(417,'Daily Republican Register','Mount Carmel','IL',4085),
(418,'Daily Review Atlas','Monmouth','IL',3159),
(419,'The Dispatch','Moline','IL',31752),
(420,'Register-News','Mount Vernon','IL',10260),
(421,'The Daily American','West Frankfort','IL',3510),
(422,'Times-Republic','Watseka','IL',2373),
(423,'Sauk Valley Sunday','Sterling','IL',0),
(424,'Breeze-Courier','Taylorville','IL',5801),
(425,'The Herald News','Joliet','IL',41643),
(426,'News-Herald','Litchfield','IL',5218),
(427,'The Courier','Lincoln','IL',5674),
(428,'The Daily Register','Harrisburg','IL',4556),
(429,'Macomb Journal','Macomb','IL',7800);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(430,'Star-Courier','Kewanee','IL',4739),
(431,'Morris Daily Herald','Morris','IL',7258),
(432,'Journal-Gazette','Mattoon','IL',11278),
(433,'Pekin Daily Times','Pekin','IL',10767),
(434,'Journal Star','Peoria','IL',66216),
(435,'Daily Gazette','Sterling','IL',11623),
(436,'Daily News','Robinson','IL',5933),
(437,'Rockford Register Star','Rockford','IL',58069),
(438,'The Daily Leader','Pontiac','IL',4784),
(439,'The Paris Beacon-News','Paris','IL',5002),
(440,'The Times','Ottawa','IL',15267),
(441,'The State Journal-Register','Springfield','IL',52562),
(442,'Daily Chronicle','De Kalb','IL',9457),
(443,'Herald & Review','Decatur','IL',35832),
(444,'Commercial-News','Danville','IL',13438),
(445,'Clinton Daily Journal','Clinton','IL',2022),
(446,'Chicago Tribune','Chicago','IL',566827),
(447,'Sauk Valley Sunday','Dixon','IL',0),
(448,'Benton Evening News','Benton','IL',3472),
(449,'Carmi Times','Carmi','IL',2718),
(450,'Effingham Daily News','Effingham','IL',12105);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(451,'Eldorado Daily Journal','Eldorado','IL',1103),
(452,'The Courier News','Elgin','IL',13776),
(453,'The Register-Mail','Galesburg','IL',13696),
(454,'Du Quoin Evening Call','Du Quoin','IL',3800),
(455,'Naperville Sun','Naperville','IL',16357),
(456,'The Washington Times-Herald','Washington','IN',8768),
(457,'Tipton County Tribune','Tipton','IN',2816),
(458,'Post-Tribune','Merrillville','IN',66901),
(459,'Ledger & Tribune','New Albany','IN',0),
(460,'Greene County Daily World','Linton','IN',2979),
(461,'The Tribune','Seymour','IN',8951),
(462,'Pilot-News','Plymouth','IN',6227),
(463,'Herald-Argus','La Porte','IN',12488),
(464,'The Peru Tribune','Peru','IN',6391),
(465,'The Reporter','Lebanon','IN',5264),
(466,'The Times','Munster','IN',82709),
(467,'The Madison Courier','Madison','IN',8848),
(468,'Evansville Courier & Press','Evansville','IN',68344),
(469,'The Truth','Elkhart','IN',28945),
(470,'Journal Review','Crawfordsville','IN',9458),
(471,'Fort Wayne Newspapers Inc.','Fort Wayne','IN',0);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(472,'Connersville News-Examiner','Connersville','IN',7390),
(473,'Huntington Herald-Press','Huntington','IN',6364),
(474,'News-Times','Hartford City','IN',1473),
(475,'The Goshen News','Goshen','IN',16094),
(476,'The Times','Frankfort','IN',6136),
(477,'Herald Journal','Monticello','IN',5100),
(478,'Chronicle-Tribune','Marion','IN',17071),
(479,'The Star Press','Muncie','IN',33461),
(480,'The Reporter-Times','Martinsville','IN',5184),
(481,'Palladium-Item','Richmond','IN',16720),
(482,'The News-Sentinel','Fort Wayne','IN',26385),
(483,'Daily Journal','Franklin','IN',17132),
(484,'Pharos-Tribune','Logansport','IN',9303),
(485,'Tribune','New Albany','IN',13054),
(486,'Kokomo Tribune','Kokomo','IN',21242),
(487,'The Herald','Jasper','IN',12563),
(488,'Decatur Daily Democrat','Decatur','IN',5129),
(489,'The Journal Gazette','Fort Wayne','IN',66918),
(490,'The Call-Leader','Elwood','IN',3081),
(491,'The News Dispatch','Michigan City','IN',10702),
(492,'The Courier-Times','New Castle','IN',9166);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(493,'Journal and Courier','Lafayette','IN',36034),
(494,'The News-Sun','Kendallville','IN',8687),
(495,'The Evening News','Jeffersonville','IN',7152),
(496,'Greensburg Daily News','Greensburg','IN',5569),
(497,'Banner-Graphic','Greencastle','IN',6557),
(498,'Hoosier Times','Martinsville','IN',0),
(499,'South Bend Tribune','South Bend','IN',68901),
(500,'The Shelbyville News','Shelbyville','IN',8315),
(501,'The Rochester Sentinel','Rochester','IN',3761),
(502,'Princeton Daily Clarion','Princeton','IN',6277),
(503,'The Indianapolis Star','Indianapolis','IN',261405),
(504,'Daily Reporter','Greenfield','IN',11361),
(505,'Rushville Republican','Rushville','IN',3682),
(506,'Republican','Rensselaer','IN',2049),
(507,'The Commercial Review','Portland','IN',4813),
(508,'The Evening Star','Auburn','IN',6693),
(509,'The Herald Bulletin','Anderson','IN',21810),
(510,'The Brazil Times','Brazil','IN',4633),
(511,'News-Banner','Bluffton','IN',5055),
(512,'Hoosier Times','Bedford','IN',0);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(513,'Chesterton Tribune','Chesterton','IN',5047),
(514,'Hoosier Times','Bloomington','IN',0),
(515,'The Herald-Times','Bloomington','IN',28047),
(516,'The Republic','Columbus','IN',21234),
(517,'The Post & Mail','Columbia City','IN',4058),
(518,'The Daily Clintonian','Clinton','IN',5413),
(519,'The Times-Mail','Bedford','IN',12523),
(520,'Herald-Republican','Angola','IN',4577),
(521,'Wabash Plain Dealer','Wabash','IN',6563),
(522,'The Tribune-Star','Terre Haute','IN',24618),
(523,'Times-Union','Warsaw','IN',10535),
(524,'Spencer Evening World','Spencer','IN',3590),
(525,'The News-Gazette','Winchester','IN',3700),
(526,'The Sullivan Daily Times','Sullivan','IN',4115),
(527,'Vincennes Sun-Commercial','Vincennes','IN',9151),
(528,'Abilene Reflector-Chronicle','Abilene','KS',3935),
(529,'The Clay Center Dispatch','Clay Center','KS',3114),
(530,'The Chanute Tribune','Chanute','KS',4359),
(531,'Augusta Daily Gazette','Augusta','KS',2247),
(532,'The Emporia Gazette','Emporia','KS',7686);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(533,'Dodge City Daily Globe','Dodge City','KS',9700),
(534,'The Wichita Eagle','Wichita','KS',83903),
(535,'The El Dorado Times','El Dorado','KS',3396),
(536,'The Goodland Star-News','Goodland','KS',2004),
(537,'Parsons Sun','Parsons','KS',5420),
(538,'The Lyons Daily News','Lyons','KS',2321),
(539,'Blade-Empire','Concordia','KS',2357),
(540,'Lawrence Journal-World','Lawrence','KS',19474),
(541,'The Pratt Tribune','Pratt','KS',2139),
(542,'The Columbus Daily Advocate','Columbus','KS',2220),
(543,'Colby Free Press','Colby','KS',2069),
(544,'The Derby Reporter','Derby','KS',1500),
(545,'Wellington Daily News','Wellington','KS',3170),
(546,'The Salina Journal','Salina','KS',29272),
(547,'Winfield Daily Courier','Winfield','KS',4282),
(548,'The Topeka Capital-Journal','Topeka','KS',44955),
(549,'Kansas City Kansan','Kansas City','KS',8000),
(550,'Independence Daily Reporter','Independence','KS',6654),
(551,'Great Bend Tribune','Great Bend','KS',6195);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(552,'The Hutchinson News','Hutchinson','KS',31499),
(553,'The Manhattan Mercury','Manhattan','KS',10304),
(554,'The Ottawa Herald','Ottawa','KS',5759),
(555,'The Newton Kansan','Newton','KS',7647),
(556,'The Garden City Telegram','Garden City','KS',8000),
(557,'Council Grove Republican','Council Grove','KS',2150),
(558,'McPherson Sentinel','McPherson','KS',4227),
(559,'Southwest Daily Times','Liberal','KS',4250),
(560,'Leavenworth Times','Leavenworth','KS',5608),
(561,'The Fort Scott Tribune','Fort Scott','KS',3289),
(562,'The Olathe News','Olathe','KS',4173),
(563,'The Coffeyville Journal','Coffeyville','KS',4103),
(564,'The Morning Sun','Pittsburg','KS',10312),
(565,'The Daily Union','Junction City','KS',4313),
(566,'Iola Register','Iola','KS',3750),
(567,'The Hays Daily News','Hays','KS',12414),
(568,'Arkansas City Traveler','Arkansas City','KS',4832),
(569,'The Daily Independent','Ashland','KY',17936),
(570,'The Advocate-Messenger','Danville','KY',10485);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(571,'The Gleaner','Henderson','KY',10747),
(572,'The Harlan Daily Enterprise','Harlan','KY',6904),
(573,'The Appalachian News-Express','Pikeville','KY',11000),
(574,'Kentucky New Era','Hopkinsville','KY',10357),
(575,'The Paducah Sun','Paducah','KY',25375),
(576,'Lexington Herald-Leader','Lexington','KY',111124),
(577,'The Murray Ledger & Times','Murray','KY',7459),
(578,'The Mayfield Messenger','Mayfield','KY',6500),
(579,'The Courier-Journal','Louisville','KY',218796),
(580,'Daily News','Bowling Green','KY',20970),
(581,'The News Enterprise','Elizabethtown','KY',16415),
(582,'The State Journal','Frankfort','KY',8299),
(583,'The Kentucky Post','Covington','KY',28167),
(584,'Times-Tribune','Corbin','KY',6166),
(585,'The Winchester Sun','Winchester','KY',7209),
(586,'The Commonwealth-Journal','Somerset','KY',9460),
(587,'The Richmond Register','Richmond','KY',6119),
(588,'The Ledger Independent','Maysville','KY',9051),
(589,'Middlesboro Daily News','Middlesboro','KY',5873);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(590,'The Messenger','Madisonville','KY',7622),
(591,'Messenger-Inquirer','Owensboro','KY',28238),
(592,'The Kentucky Advocate','Danville','KY',0),
(593,'Glasgow Daily Times','Glasgow','KY',8268),
(594,'The Courier','Houma','LA',16765),
(595,'American Press','Lake Charles','LA',37393),
(596,'The Crowley Post-Signal','Crowley','LA',4476),
(597,'Sunday Advocate','Baton Rouge','LA',0),
(598,'The Daily Review','Morgan City','LA',5946),
(599,'Beauregard Daily News','De Ridder','LA',13500),
(600,'The Town Talk','Alexandria','LA',32630),
(601,'Abbeville Meridional','Abbeville','LA',5379),
(602,'The Advocate','Baton Rouge','LA',96558),
(603,'Bastrop Daily Enterprise','Bastrop','LA',4241),
(604,'The Daily Star','Hammond','LA',9867),
(605,'Daily Comet','Thibodaux','LA',10764),
(606,'Southwest Daily News','Sulphur','LA',4631),
(607,'The Times','Shreveport','LA',54798),
(608,'Natchitoches Times','Natchitoches','LA',4805),
(609,'Ruston Daily Leader','Ruston','LA',5592);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(610,'The Daily World','Opelousas','LA',9339),
(611,'The Daily Advertiser','Lafayette','LA',42560),
(612,'The Times-Picayune','New Orleans','LA',261573),
(613,'The Daily Iberian','New Iberia','LA',13547),
(614,'The Franklin Banner-Tribune','Franklin','LA',3351),
(615,'The News-Star','Monroe','LA',34677),
(616,'Minden Press-Herald','Minden','LA',5003),
(617,'Jennings Daily News','Jennings','LA',4816),
(618,'The Leesville Daily Leader','Leesville','LA',3794),
(619,'The Republican','Springfield','MA',83798),
(620,'The Southbridge Evening News','Southbridge','MA',5080),
(621,'The Salem News','Beverly','MA',30091),
(622,'The Recorder','Greenfield','MA',13864),
(623,'Sunday Herald News','Fall River','MA',0),
(624,'The Herald News','Fall River','MA',19765),
(625,'The Sunday Eagle-Tribune','North Andover','MA',0),
(626,'The Boston Globe','Boston','MA',382503),
(627,'The Christian Science Monitor','Boston','MA',58313),
(628,'Daily Hampshire Gazette','Northampton','MA',18207);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(629,'North Adams Transcript','North Adams','MA',6289),
(630,'The Standard-Times','New Bedford','MA',31893),
(631,'The Sunday Enterprise','Brockton','MA',0),
(632,'The Gardner News','Gardner','MA',5897),
(633,'Metrowest Daily News','Framingham','MA',22705),
(634,'Sentinel & Enterprise','Fitchburg','MA',16003),
(635,'The Eagle-Tribune','North Andover','MA',47072),
(636,'Gloucester Daily Times','Gloucester','MA',10020),
(637,'Westfield Evening News','Westfield','MA',5219),
(638,'Taunton Daily Gazette','Taunton','MA',9289),
(639,'The Sun','Lowell','MA',46280),
(640,'Boston Sunday Globe','Boston','MA',0),
(641,'The Berkshire Eagle','Pittsfield','MA',26719),
(642,'Daily Times Chronicle','Woburn','MA',10082),
(643,'Cape Cod Times','Hyannis','MA',44173),
(644,'Sunday Telegram','Worcester','MA',0),
(645,'Wakefield Daily Item','Wakefield','MA',3989),
(646,'The Evening News-Mercury','Malden','MA',11392),
(647,'Boston Herald','Boston','MA',201513),
(648,'Milford Daily News','Milford','MA',8628);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(649,'The Daily News','Newburyport','MA',12697),
(650,'The Daily Item','Lynn','MA',13788),
(651,'The Sun Chronicle','Attleboro','MA',17709),
(652,'The Sunday Sun','Lowell','MA',0),
(653,'Athol Daily News','Athol','MA',4661),
(654,'The Patriot Ledger','Quincy','MA',52638),
(655,'The Enterprise','Brockton','MA',31352),
(656,'Telegram & Gazette','Worcester','MA',84394),
(657,'Sunday Republican','Springfield','MA',0),
(658,'The Daily Graphic','Portage la Prairie','MB',2615),
(659,'Winnipeg Free Press','Winnipeg','MB',120984),
(660,'The Winnipeg Sun','Winnipeg','MB',38032),
(661,'The Brandon Sun','Brandon','MB',14267),
(662,'The Capital','Annapolis','MD',43411),
(663,'The Daily Mail','Hagerstown','MD',11696),
(664,'The Herald Mail','Hagerstown','MD',0),
(665,'Cecil Whig','Elkton','MD',13320),
(666,'The Cumberland Times-News','Cumberland','MD',29139),
(667,'The Star-Democrat','Easton','MD',16752),
(668,'The Sunday Star','Easton','MD',0),
(669,'The Sun','Baltimore','MD',232138);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(670,'The Sunday Sun','Baltimore','MD',0),
(671,'The Daily Banner','Cambridge','MD',3561),
(672,'The Frederick News-Post','Frederick','MD',40856),
(673,'The Morning Herald','Hagerstown','MD',23508),
(674,'Carroll County Times','Westminster','MD',24890),
(675,'The Daily Times','Salisbury','MD',24837),
(676,'Sun Journal','Lewiston','ME',34035),
(677,'Sunday Sentinel','Waterville','ME',0),
(678,'Kennebec Journal','Augusta','ME',14953),
(679,'Morning Sentinel','Waterville','ME',19702),
(680,'Bangor Daily News','Bangor','ME',57702),
(681,'Portland Press Herald','Portland','ME',67516),
(682,'Maine Sunday Telegram','Portland','ME',0),
(683,'Journal Tribune','Biddeford','ME',7319),
(684,'The Times Record','Brunswick','ME',9726),
(685,'Sunday Sun-Journal','Lewiston','ME',0),
(686,'Kennebec Journal Sunday','Augusta','ME',0),
(687,'The Grand Rapids Press','Grand Rapids','MI',133107),
(688,'The Saginaw News','Saginaw','MI',43093),
(689,'The Alpena News','Alpena','MI',10141);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(690,'Daily Press','Escanaba','MI',9254),
(691,'Manistee News-Advocate','Manistee','MI',4928),
(692,'The Lansing State Journal','Lansing','MI',64906),
(693,'The Detroit News and Free Press','Detroit','MI',0),
(694,'Dowagiac Daily News','Dowagiac','MI',1818),
(695,'The Argus-Press','Owosso','MI',11249),
(696,'Niles Daily Star','Niles','MI',2361),
(697,'The Muskegon Chronicle','Muskegon','MI',42397),
(698,'The Morning Sun','Mount Pleasant','MI',10132),
(699,'The Macomb Daily','Mount Clemens','MI',41764),
(700,'Midland Daily News','Midland','MI',16196),
(701,'Jackson Citizen Patriot','Jackson','MI',32412),
(702,'Detroit Free Press','Detroit','MI',329989),
(703,'The Daily Mining Gazette','Houghton','MI',9134),
(704,'The Daily News','Greenville','MI',8015),
(705,'The Detroit News and Free Press','Detroit','MI',0),
(706,'The Daily Globe','Ironwood','MI',6498),
(707,'The Herald-Palladium','Saint Joseph','MI',21727),
(708,'The Huron Daily Tribune','Bad Axe','MI',6622);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(709,'The Daily Telegram','Adrian','MI',14698),
(710,'The Daily Tribune','Royal Oak','MI',10133),
(711,'Petoskey News-Review','Petoskey','MI',9744),
(712,'Livingston County Daily Press & Argus','Howell','MI',13615),
(713,'Three Rivers Commercial-News','Three Rivers','MI',3043),
(714,'Sturgis Journal','Sturgis','MI',6320),
(715,'Detroit Newspapers','Detroit','MI',0),
(716,'Cheboygan Daily Tribune','Cheboygan','MI',4864),
(717,'The Monroe Sunday News','Monroe','MI',0),
(718,'The Monroe Evening News','Monroe','MI',20328),
(719,'Battle Creek Enquirer','Battle Creek','MI',22388),
(720,'Kalamazoo Gazette','Kalamazoo','MI',51883),
(721,'Times Herald','Port Huron','MI',26783),
(722,'The Oakland Press','Pontiac','MI',67571),
(723,'The Holland Sentinel','Holland','MI',18345),
(724,'The Flint Journal','Flint','MI',84718),
(725,'The Daily News','Iron Mountain','MI',9211),
(726,'Sentinel-Standard','Ionia','MI',2883),
(727,'The Hillsdale Daily News','Hillsdale','MI',7285);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(728,'The Detroit News','Detroit','MI',202029),
(729,'The Daily Reporter','Coldwater','MI',5316),
(730,'Cadillac News','Cadillac','MI',10175),
(731,'Big Rapids Pioneer','Big Rapids','MI',5221),
(732,'Traverse City Record-Eagle','Traverse City','MI',25822),
(733,'The Mining Journal','Marquette','MI',14416),
(734,'Daily News','Ludington','MI',7954),
(735,'The Ann Arbor News','Ann Arbor','MI',47864),
(736,'The Bay City Times','Bay City','MI',31779),
(737,'The Evening News','Sault Sainte Marie','MI',6772),
(738,'Grand Haven Tribune','Grand Haven','MI',9495),
(739,'The Daily Journal','International Falls','MN',3703),
(740,'Star Tribune (Newspaper of the Twin Citi','Minneapolis','MN',345252),
(741,'Post-Bulletin','Rochester','MN',44631),
(742,'Winona Daily News','Winona','MN',11423),
(743,'Albert Lea Tribune','Albert Lea','MN',6315),
(744,'Fergus Falls Daily Journal','Fergus Falls','MN',8414),
(745,'The Brainerd Dispatch','Brainerd','MN',13578),
(746,'Austin Daily Herald','Austin','MN',6536);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(747,'The Free Press','Mankato','MN',22629),
(748,'The Daily Tribune','Hibbing','MN',4900),
(749,'Crookston Daily Times','Crookston','MN',1769),
(750,'Duluth News Tribune','Duluth','MN',40305),
(751,'The Pioneer','Bemidji','MN',9465),
(752,'Saint Paul Pioneer Press','Saint Paul','MN',191591),
(753,'St. Cloud Times','Saint Cloud','MN',26961),
(754,'Republican Eagle','Red Wing','MN',6837),
(755,'West Central Tribune','Willmar','MN',16825),
(756,'Mesabi Daily News','Virginia','MN',9309),
(757,'Stillwater Gazette','Stillwater','MN',3341),
(758,'The Daily Globe','Worthington','MN',9109),
(759,'Faribault Daily News','Faribault','MN',6384),
(760,'Sentinel','Fairmont','MN',6877),
(761,'Owatonna People\'s Press','Owatonna','MN',7277),
(762,'The Journal','New Ulm','MN',8238),
(763,'Independent','Marshall','MN',7252),
(764,'The Examiner','Blue Springs','MO',4402),
(765,'Columbia Daily Tribune','Columbia','MO',18528),
(766,'Southeast Missourian','Cape Girardeau','MO',15895);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(767,'Moberly Monitor-Index & Evening Democrat','Moberly','MO',5342),
(768,'West Plains Daily Quill','West Plains','MO',9109),
(769,'Lake Sun Leader','Camdenton','MO',4370),
(770,'The Joplin Globe','Joplin','MO',30680),
(771,'Daily Capital News','Jefferson City','MO',1731),
(772,'The Sunday News Tribune','Jefferson City','MO',0),
(773,'Hannibal Courier-Post','Hannibal','MO',8171),
(774,'Daily Journal','Park Hills','MO',8089),
(775,'Columbia Missourian','Columbia','MO',7011),
(776,'The Nevada Herald','Nevada','MO',0),
(777,'The Monett Times','Monett','MO',3976),
(778,'Constitution-Tribune','Chillicothe','MO',3461),
(779,'The Carthage Press','Carthage','MO',3543),
(780,'Branson Tri-Lakes Daily News','Branson','MO',11170),
(781,'Boonville Daily News','Boonville','MO',2741),
(782,'Jefferson City Post-Tribune','Jefferson City','MO',16712),
(783,'The Examiner','Independence','MO',14022),
(784,'Neosho Daily News','Neosho','MO',3474),
(785,'Rolla Daily News','Rolla','MO',4875);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(786,'The Daily News','Richmond','MO',3016),
(787,'Standard Democrat','Sikeston','MO',6538),
(788,'The Sedalia Democrat','Sedalia','MO',11917),
(789,'Mexico Ledger','Mexico','MO',7000),
(790,'Kirksville Daily Express','Kirksville','MO',4263),
(791,'The Daily Star-Journal','Warrensburg','MO',6282),
(792,'The Kansas City Star','Kansas City','MO',260724),
(793,'The Fulton Sun','Fulton','MO',3897),
(794,'Republican-Times','Trenton','MO',3017),
(795,'The Lebanon Daily Record','Lebanon','MO',4479),
(796,'St. Joseph News-Press','Saint Joseph','MO',36092),
(797,'Springfield News-Leader','Springfield','MO',58576),
(798,'St. Louis Post-Dispatch','Saint Louis','MO',278999),
(799,'The Maryville Daily Forum','Maryville','MO',3500),
(800,'The Marshall Democrat-News','Marshall','MO',3125),
(801,'Daily American Republic','Poplar Bluff','MO',12910),
(802,'Macon Chronicle-Herald','Macon','MO',2301),
(803,'Daily Guide','Waynesville','MO',1805),
(804,'The Daily Dunklin Democrat','Kennett','MO',4985);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(805,'The Nevada Daily Mail','Nevada','MO',2744),
(806,'The Daily Statesman','Dexter','MO',2519),
(807,'The Clinton Daily Democrat','Clinton','MO',4150),
(808,'The Clarion-Ledger','Jackson','MS',90055),
(809,'Delta Democrat Times','Greenville','MS',11022),
(810,'Enterprise-Journal','McComb','MS',11704),
(811,'The Oxford Eagle','Oxford','MS',5016),
(812,'The Natchez Democrat','Natchez','MS',8428),
(813,'Daily Times Leader','West Point','MS',2889),
(814,'Northeast Mississippi Daily Journal','Tupelo','MS',36526),
(815,'Starkville Daily News','Starkville','MS',7071),
(816,'The Vicksburg Post','Vicksburg','MS',13055),
(817,'Picayune Item','Picayune','MS',4562),
(818,'DeSoto Times Today','Hernando','MS',7810),
(819,'The Hattiesburg American','Hattiesburg','MS',19022),
(820,'The Clarksdale Press Register','Clarksdale','MS',5200),
(821,'The Daily Leader','Brookhaven','MS',6546),
(822,'The Commercial Dispatch','Columbus','MS',13305),
(823,'The Bolivar Commercial','Cleveland','MS',6299);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(824,'The Sun Herald','Biloxi','MS',45374),
(825,'The Mississippi Press','Pascagoula','MS',16000),
(826,'The Meridian Star','Meridian','MS',14703),
(827,'The Greenwood Commonwealth','Greenwood','MS',7212),
(828,'Laurel Leader-Call','Laurel','MS',7738),
(829,'The Daily Star','Grenada','MS',5776),
(830,'The Daily Corinthian','Corinth','MS',6711),
(831,'Billings Gazette','Billings','MT',46295),
(832,'Ravalli Republic','Hamilton','MT',5268),
(833,'Missoulian','Missoula','MT',29321),
(834,'Independent Record','Helena','MT',14314),
(835,'Miles City Star','Miles City','MT',3110),
(836,'Daily Inter Lake','Kalispell','MT',16074),
(837,'The Livingston Enterprise','Livingston','MT',3217),
(838,'The Havre Daily News','Havre','MT',4280),
(839,'Bozeman Daily Chronicle','Bozeman','MT',16068),
(840,'Great Falls Tribune','Great Falls','MT',32121),
(841,'The Montana Standard','Butte','MT',14740),
(842,'Times & Transcript','Moncton','NB',37115),
(843,'L\'Acadie Nouvelle','Caraquet','NB',20152);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(844,'New Brunswick Telegraph-Journal','Saint John','NB',35296),
(845,'The Daily Gleaner','Fredericton','NB',22967),
(846,'News-Topic','Lenoir','NC',8648),
(847,'News & Record','Greensboro','NC',89672),
(848,'The Shelby Star','Shelby','NC',14164),
(849,'The Herald-Sun','Durham','NC',36815),
(850,'The Observer-News-Enterprise','Newton','NC',2303),
(851,'The Daily Courier','Forest City','NC',9332),
(852,'Times-News','Hendersonville','NC',18146),
(853,'Star-News','Wilmington','NC',50246),
(854,'Washington Daily News','Washington','NC',8791),
(855,'Mount Airy News','Mount Airy','NC',9263),
(856,'The Dispatch','Lexington','NC',10940),
(857,'The Tryon Daily Bulletin','Tryon','NC',5050),
(858,'The Sun Journal','New Bern','NC',15040),
(859,'The News Herald','Morganton','NC',10736),
(860,'The Daily Reflector','Greenville','NC',22291),
(861,'The Charlotte Observer','Charlotte','NC',215379),
(862,'Sunday Star-News','Wilmington','NC',0),
(863,'Winston-Salem Journal','Winston-Salem','NC',83625);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(864,'The Daily Advance','Elizabeth City','NC',10697),
(865,'The Sampson Independent','Clinton','NC',7962),
(866,'The News & Observer','Raleigh','NC',177361),
(867,'The Robesonian','Lumberton','NC',12562),
(868,'The Enquirer-Journal','Monroe','NC',7847),
(869,'The McDowell News','Marion','NC',4732),
(870,'Statesville Record & Landmark','Statesville','NC',14432),
(871,'Times-News','Burlington','NC',25390),
(872,'The Daily Southerner','Tarboro','NC',3708),
(873,'The Courier-Tribune','Asheboro','NC',13915),
(874,'The Sanford Herald','Sanford','NC',9174),
(875,'Richmond County Daily Journal','Rockingham','NC',7991),
(876,'High Point Enterprise','High Point','NC',21167),
(877,'The Gaston Gazette','Gastonia','NC',31280),
(878,'The Fayetteville Observer','Fayetteville','NC',64881),
(879,'The Daily Record','Dunn','NC',8669),
(880,'Salisbury Post','Salisbury','NC',21723),
(881,'Rocky Mount Telegram','Rocky Mount','NC',14562),
(882,'The Reidsville Review','Reidsville','NC',5195);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(883,'Independent Tribune','Concord','NC',17161),
(884,'The Free Press','Kinston','NC',11608),
(885,'The Daily News','Jacksonville','NC',20319),
(886,'The Hickory Daily Record','Hickory','NC',21155),
(887,'The Wilson Daily Times','Wilson','NC',16498),
(888,'Goldsboro News-Argus','Goldsboro','NC',19325),
(889,'The Eden Daily News','Eden','NC',3819),
(890,'The Daily Dispatch','Henderson','NC',7513),
(891,'The Asheville Citizen-Times','Asheville','NC',51512),
(892,'The Laurinburg Exchange','Laurinburg','NC',8200),
(893,'Daily Herald','Roanoke Rapids','NC',11153),
(894,'The Jamestown Sun','Jamestown','ND',6234),
(895,'The Forum','Fargo','ND',48909),
(896,'Dickinson Press','Dickinson','ND',6058),
(897,'Devils Lake Journal','Devils Lake','ND',3500),
(898,'Williston Daily Herald','Williston','ND',4562),
(899,'Minot Daily News','Minot','ND',19545),
(900,'Grand Forks Herald','Grand Forks','ND',29373),
(901,'The Bismarck Tribune','Bismarck','ND',27518),
(902,'Valley City Times-Record','Valley City','ND',2610);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(903,'The Daily News','Wahpeton','ND',2584),
(904,'Beatrice Daily Sun','Beatrice','NE',7759),
(905,'Omaha World-Herald','Omaha','NE',184150),
(906,'Kearney Hub','Kearney','NE',12324),
(907,'Lincoln Journal Star','Lincoln','NE',77646),
(908,'Hastings Tribune','Hastings','NE',12025),
(909,'Columbus Telegram','Columbus','NE',9070),
(910,'The Grand Island Independent','Grand Island','NE',21204),
(911,'Star-Herald','Scottsbluff','NE',14675),
(912,'Fremont Tribune','Fremont','NE',8397),
(913,'Sidney Sun-Telegraph','Sidney','NE',2616),
(914,'Norfolk Daily News','Norfolk','NE',16837),
(915,'McCook Daily Gazette','McCook','NE',5903),
(916,'Holdrege Daily Citizen','Holdrege','NE',2904),
(917,'The North Platte Telegraph','North Platte','NE',12160),
(918,'York News-Times','York','NE',4695),
(919,'Alliance Times-Herald','Alliance','NE',3028),
(920,'The Telegram','Saint John\'s','NF',27300),
(921,'The Western Star','Corner Brook','NF',7624),
(922,'The Conway Daily Sun','North Conway','NH',16100);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(923,'Foster\'s Sunday Citizen','Dover','NH',0),
(924,'Portsmouth Herald','Portsmouth','NH',12326),
(925,'The Keene Sentinel','Keene','NH',12710),
(926,'New Hampshire Sunday News','Manchester','NH',0),
(927,'Concord Monitor','Concord','NH',19885),
(928,'The Berlin Daily Sun','Berlin','NH',8800),
(929,'Eagle Times','Claremont','NH',8465),
(930,'New Hampshire Union Leader','Manchester','NH',55038),
(931,'Sunday Monitor','Concord','NH',0),
(932,'Citizen','Laconia','NH',7146),
(933,'Foster\'s Daily Democrat','Dover','NH',19394),
(934,'The Telegraph','Nashua','NH',25372),
(935,'Foster\'s Sunday Citizen','Laconia','NH',0),
(936,'The Press of Atlantic City','Pleasantville','NJ',67650),
(937,'The Record','Hackensack','NJ',170408),
(938,'The Gloucester County Times','Woodbury','NJ',23488),
(939,'Courier News','Bridgewater','NJ',35790),
(940,'The Times','Trenton','NJ',54578),
(941,'Herald News','West Paterson','NJ',0),
(942,'Home News Tribune','East Brunswick','NJ',51161);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(943,'Daily Record','Parsippany','NJ',38808),
(944,'The Trentonian','Trenton','NJ',40628),
(945,'The New Jersey Herald','Newton','NJ',14921),
(946,'The Jersey Journal','Jersey City','NJ',25247),
(947,'The Star-Ledger','Newark','NJ',372629),
(948,'Courier-Post','Cherry Hill','NJ',69521),
(949,'The Daily Journal','Vineland','NJ',17176),
(950,'Asbury Park Press','Neptune','NJ',145508),
(951,'Bridgeton News','Bridgeton','NJ',7508),
(952,'Today\'s Sunbeam','Salem','NJ',9722),
(953,'Burlington County Times','Willingboro','NJ',33424),
(954,'Alamogordo Daily News','Alamogordo','NM',6355),
(955,'Carlsbad Current-Argus','Carlsbad','NM',7286),
(956,'Albuquerque Publishing Co.','Albuquerque','NM',0),
(957,'The Santa Fe New Mexican','Santa Fe','NM',25450),
(958,'Silver City Daily Press & Independent','Silver City','NM',7782),
(959,'Gallup Independent','Gallup','NM',15286),
(960,'Portales News-Tribune','Portales','NM',2758),
(961,'Hobbs News-Sun','Hobbs','NM',9241);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(962,'The Daily Times','Farmington','NM',17439),
(963,'Las Vegas Optic','Las Vegas','NM',6049),
(964,'Deming Headlight','Deming','NM',3541),
(965,'Los Alamos Monitor','Los Alamos','NM',5040),
(966,'Clovis News Journal','Clovis','NM',7050),
(967,'Roswell Daily Record','Roswell','NM',13055),
(968,'Artesia Daily Press','Artesia','NM',3550),
(969,'Albuquerque Journal','Albuquerque','NM',105966),
(970,'The Sunday Journal','Albuquerque','NM',0),
(971,'The Albuquerque Tribune','Albuquerque','NM',10789),
(972,'Las Cruces Sun-News','Las Cruces','NM',21336),
(973,'The Daily News','Halifax','NS',21505),
(974,'The Citizen','Amherst','NS',0),
(975,'The News','New Glasgow','NS',7826),
(976,'Amherst Daily News','Amherst','NS',3054),
(977,'Cape Breton Post','Sydney','NS',25151),
(978,'The Sunday Herald','Halifax','NS',0),
(979,'The Chronicle Herald','Halifax','NS',107553),
(980,'Truro Daily News','Truro','NS',6704),
(981,'Elko Daily Free Press','Elko','NV',7386);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(982,'Nevada Appeal','Carson City','NV',16553),
(983,'Las Vegas Review-Journal & Las Vegas Sun','Las Vegas','NV',0),
(984,'Las Vegas Review-Journal','Las Vegas','NV',172366),
(985,'The Daily Sparks Tribune','Sparks','NV',5034),
(986,'Reno Gazette-Journal','Reno','NV',61201),
(987,'The Humboldt Sun','Winnemucca','NV',3230),
(988,'Las Vegas Review-Journal & Las Vegas Sun','Las Vegas','NV',0),
(989,'Lahontan Valley News & Fallon Eagle Stan','Fallon','NV',5339),
(990,'Las Vegas Sun','Las Vegas','NV',24154),
(991,'am New York','New York','NY',266852),
(992,'The Evening Telegram','Herkimer','NY',6657),
(993,'The Malone Telegram','Malone','NY',4721),
(994,'The Post-Standard','Syracuse','NY',113991),
(995,'Staten Island Advance','Staten Island','NY',59461),
(996,'Press-Republican','Plattsburgh','NY',19343),
(997,'Union-Sun & Journal','Lockport','NY',11388),
(998,'The Evening Times','Little Falls','NY',4015),
(999,'The Post-Journal','Jamestown','NY',18288);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1000,'The Citizen','Auburn','NY',11431),
(1001,'The Sunday Record','Middletown','NY',0),
(1002,'Daily Freeman','Kingston','NY',19185),
(1003,'Daily Sentinel','Rome','NY',13498),
(1004,'Poughkeepsie Journal','Poughkeepsie','NY',38530),
(1005,'The Times Herald','Olean','NY',13855),
(1006,'Advance-News','Ogdensburg','NY',0),
(1007,'The Daily Challenge','Brooklyn','NY',56544),
(1008,'The Journal-Register','Medina','NY',2755),
(1009,'The Spectator','Hornell','NY',0),
(1010,'Daily News','New York','NY',718174),
(1011,'El Diario La Prensa (Spanish)','New York','NY',53090),
(1012,'The Times Herald-Record','Middletown','NY',80148),
(1013,'Lockport Sunday','Lockport','NY',0),
(1014,'Tonawanda News','North Tonawanda','NY',7922),
(1015,'Niagara Gazette','Niagara Falls','NY',18033),
(1016,'The New York Times','New York','NY',1120420),
(1017,'The Sunday Record','Troy','NY',0),
(1018,'Rochester Democrat and Chronicle','Rochester','NY',154599),
(1019,'Watertown Daily Times','Watertown','NY',27766);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1020,'Wellsville Daily Reporter','Wellsville','NY',4500),
(1021,'The Journal News','White Plains','NY',122479),
(1022,'Observer-Dispatch','Utica','NY',40239),
(1023,'The Spectator','Wellsville','NY',0),
(1024,'Sunday Freeman','Kingston','NY',0),
(1025,'The Evening Tribune','Hornell','NY',6472),
(1026,'The Saratogian','Saratoga Springs','NY',9154),
(1027,'Salamanca Press','Salamanca','NY',1957),
(1028,'The Oneida Daily Dispatch','Oneida','NY',6376),
(1029,'The Journal','Ogdensburg','NY',4924),
(1030,'Courier-Observer','Ogdensburg','NY',5831),
(1031,'Newsday','Melville','NY',398231),
(1032,'The Sunday Gazette','Schenectady','NY',0),
(1033,'The Daily Gazette','Schenectady','NY',48585),
(1034,'Adirondack Daily Enterprise','Saranac Lake','NY',4118),
(1035,'The Palladium-Times','Oswego','NY',7350),
(1036,'The Daily Star','Oneonta','NY',15371),
(1037,'New York Post','New York','NY',724748),
(1038,'Observer','Dunkirk','NY',10348),
(1039,'The Leader','Corning','NY',12818);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1040,'The Leader-Herald','Gloversville','NY',10200),
(1041,'Cortland Standard','Cortland','NY',10279),
(1042,'Times Union','Albany','NY',92321),
(1043,'Daily Messenger','Canandaigua','NY',11508),
(1044,'The Buffalo News','Buffalo','NY',181540),
(1045,'Press & Sun-Bulletin','Binghamton','NY',51071),
(1046,'The New York Sun','New York','NY',45763),
(1047,'Hoy (Spanish)','New York','NY',35410),
(1048,'Register-Star','Hudson','NY',5112),
(1049,'The Ithaca Journal','Ithaca','NY',16090),
(1050,'The Evening Sun','Norwich','NY',5018),
(1051,'The Wall Street Journal','New York','NY',2043235),
(1052,'Tonawanda Sunday','North Tonawanda','NY',0),
(1053,'Niagara Sunday','Niagara Falls','NY',0),
(1054,'The Record','Troy','NY',15376),
(1055,'Eastern Edition','New York','NY',0),
(1056,'The Daily News','Batavia','NY',12499),
(1057,'The Post-Star','Glens Falls','NY',31529),
(1058,'The Daily Mail','Catskill','NY',3373),
(1059,'Finger Lakes Times','Geneva','NY',15438);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1060,'The Recorder','Amsterdam','NY',9163),
(1061,'Star-Gazette','Elmira','NY',25742),
(1062,'The Times-Reporter','New Philadelphia','OH',22986),
(1063,'Coshocton Tribune','Coshocton','OH',6155),
(1064,'The Review','Alliance','OH',11769),
(1065,'Sunday Jeffersonian','Cambridge','OH',0),
(1066,'Akron Beacon Journal','Akron','OH',122388),
(1067,'Bellefontaine Examiner','Bellefontaine','OH',8931),
(1068,'Beavercreek News-Current','Xenia','OH',3805),
(1069,'Delphos Daily Herald','Delphos','OH',3580),
(1070,'The Delaware Gazette','Delaware','OH',8443),
(1071,'The Crescent-News','Defiance','OH',17440),
(1072,'Dayton Daily News','Dayton','OH',121574),
(1073,'The Daily Jeffersonian','Cambridge','OH',12719),
(1074,'The Ironton Tribune','Ironton','OH',5228),
(1075,'The Xenia Daily Gazette','Xenia','OH',5858),
(1076,'The Lima News','Lima','OH',32875),
(1077,'Vindicator','Youngstown','OH',58290),
(1078,'The News-Herald','Willoughby','OH',42027),
(1079,'Record-Courier','Ravenna','OH',17884);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1080,'Chillicothe Gazette','Chillicothe','OH',13731),
(1081,'The Repository','Canton','OH',66401),
(1082,'Telegraph-Forum','Bucyrus','OH',6124),
(1083,'The Times-Bulletin','Van Wert','OH',6386),
(1084,'Morning Journal','Lisbon','OH',11829),
(1085,'The Blade','Toledo','OH',123095),
(1086,'Wilmington News Journal','Wilmington','OH',7358),
(1087,'The Advocate','Newark','OH',19414),
(1088,'Marysville Journal-Tribune','Marysville','OH',5982),
(1089,'The Daily Sentinel','Pomeroy','OH',3471),
(1090,'Mount Vernon News','Mount Vernon','OH',9173),
(1091,'The Independent','Massillon','OH',12155),
(1092,'Sunday Times-Sentinel','Pomeroy','OH',0),
(1093,'Piqua Daily Call','Piqua','OH',6123),
(1094,'Norwalk Reflector','Norwalk','OH',8832),
(1095,'News Journal','Mansfield','OH',29070),
(1096,'Times-Gazette','Hillsboro','OH',4937),
(1097,'Herald-Star','Steubenville','OH',13274),
(1098,'The Times Leader','Martins Ferry','OH',16373),
(1099,'The Marietta Times','Marietta','OH',10685);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1100,'The Advertiser-Tribune','Tiffin','OH',9825),
(1101,'The Morning Journal','Lorain','OH',26704),
(1102,'News-Herald','Port Clinton','OH',5217),
(1103,'Urbana Daily Citizen','Urbana','OH',5616),
(1104,'Troy Daily News','Troy','OH',9277),
(1105,'Lancaster Eagle-Gazette','Lancaster','OH',13166),
(1106,'The Kenton Times','Kenton','OH',7200),
(1107,'The Evening Leader','Saint Marys','OH',4470),
(1108,'Sandusky Register','Sandusky','OH',22168),
(1109,'The Marion Star','Marion','OH',12385),
(1110,'The Madison Press','London','OH',5500),
(1111,'Springfield News-Sun','Springfield','OH',25715),
(1112,'The Sidney Daily News','Sidney','OH',12923),
(1113,'Daily Globe','Shelby','OH',4025),
(1114,'Salem News','Salem','OH',6098),
(1115,'The Logan Daily News','Logan','OH',4183),
(1116,'JournalNews','Hamilton','OH',20317),
(1117,'The Portsmouth Daily Times','Portsmouth','OH',12447),
(1118,'Miami Valley Sunday News','Troy','OH',0),
(1119,'Times Recorder','Zanesville','OH',18021);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1120,'The Daily Chief-Union','Upper Sandusky','OH',3822),
(1121,'Northwest Signal','Napoleon','OH',5757),
(1122,'Middletown Journal','Middletown','OH',18307),
(1123,'The Medina County Gazette','Medina','OH',14419),
(1124,'The Daily Record','Wooster','OH',21637),
(1125,'The Tribune Chronicle','Warren','OH',30607),
(1126,'Record Herald','Washington Court House','OH',5235),
(1127,'Wapakoneta Daily News','Wapakoneta','OH',4928),
(1128,'Sunday Times-Sentinel','Gallipolis','OH',0),
(1129,'The Galion Inquirer','Galion','OH',3848),
(1130,'The Review Times','Fostoria','OH',4083),
(1131,'The Courier','Findlay','OH',21509),
(1132,'The Herald','Circleville','OH',6690),
(1133,'The Bryan Times','Bryan','OH',10033),
(1134,'Daily Advocate','Greenville','OH',6468),
(1135,'Star Beacon','Ashtabula','OH',17285),
(1136,'The Cincinnati Enquirer','Cincinnati','OH',206320),
(1137,'The Columbus Dispatch','Columbus','OH',218940),
(1138,'The Plain Dealer','Cleveland','OH',344704);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1139,'The Sentinel-Tribune','Bowling Green','OH',11367),
(1140,'The Daily Standard','Celina','OH',10963),
(1141,'The Cincinnati Post','Cincinnati','OH',26870),
(1142,'Gallipolis Daily Tribune','Gallipolis','OH',4466),
(1143,'The News-Messenger','Fremont','OH',11598),
(1144,'Fairborn Daily Herald','Xenia','OH',3999),
(1145,'Chronicle-Telegram','Elyria','OH',25430),
(1146,'Bellevue Gazette','Bellevue','OH',2833),
(1147,'Ashland Times-Gazette','Ashland','OH',12046),
(1148,'The Review','East Liverpool','OH',9765),
(1149,'The Athens Messenger','Athens','OH',11272),
(1150,'Ada Evening News','Ada','OK',7879),
(1151,'The Edmond Sun','Edmond','OK',4947),
(1152,'Tulsa World','Tulsa','OK',117844),
(1153,'The Shawnee News-Star','Shawnee','OK',8830),
(1154,'Muskogee Daily Phoenix & Times-Democrat','Muskogee','OK',15909),
(1155,'Durant Daily Democrat','Durant','OK',6784),
(1156,'Cushing Daily Citizen','Cushing','OK',1645),
(1157,'News Press','Stillwater','OK',8565);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1158,'Perry Daily Journal','Perry','OK',3250),
(1159,'The Norman Transcript','Norman','OK',13825),
(1160,'The Lawton Constitution','Lawton','OK',21486),
(1161,'Guymon Daily Herald','Guymon','OK',2332),
(1162,'The Daily Times','Pryor','OK',3787),
(1163,'The Express-Star','Chickasha','OK',5279),
(1164,'The Duncan Banner','Duncan','OK',7179),
(1165,'The Daily Ardmoreite','Ardmore','OK',9753),
(1166,'The Vinita Daily Journal','Vinita','OK',4331),
(1167,'The Seminole Producer','Seminole','OK',5600),
(1168,'The Oklahoman','Oklahoma City','OK',201947),
(1169,'Miami News-Record','Miami','OK',6000),
(1170,'Elk City Daily News','Elk City','OK',5740),
(1171,'The Clinton Daily News','Clinton','OK',4463),
(1172,'Sapulpa Daily Herald','Sapulpa','OK',4501),
(1173,'McAlester News-Capital','McAlester','OK',9577),
(1174,'The Claremore Daily Progress','Claremore','OK',5984),
(1175,'The Ponca City News','Ponca City','OK',8849),
(1176,'Okmulgee Daily Times','Okmulgee','OK',4483);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1177,'The Sunday Constitution','Lawton','OK',0),
(1178,'Hugo Daily News','Hugo','OK',2870),
(1179,'Examiner-Enterprise','Bartlesville','OK',10471),
(1180,'Woodward News','Woodward','OK',5000),
(1181,'Weatherford Daily News','Weatherford','OK',4464),
(1182,'Tahlequah Daily Press','Tahlequah','OK',6881),
(1183,'Poteau Daily News','Poteau','OK',3900),
(1184,'Pauls Valley Daily Democrat','Pauls Valley','OK',2474),
(1185,'McCurtain Daily Gazette','Idabel','OK',5850),
(1186,'Enid News & Eagle','Enid','OK',17804),
(1187,'The Sunday Oklahoman','Oklahoma City','OK',0),
(1188,'The Anadarko Daily News','Anadarko','OK',4312),
(1189,'Altus Times','Altus','OK',4591),
(1190,'Alva Review-Courier','Alva','OK',1600),
(1191,'The Kingston Whig-Standard','Kingston','ON',26712),
(1192,'The Daily Bulletin','Fort Frances','ON',2500),
(1193,'The Hamilton Spectator','Hamilton','ON',106530),
(1194,'The North Bay Nugget','North Bay','ON',14595),
(1195,'The Guelph Mercury','Guelph','ON',14346);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1196,'The London Free Press','London','ON',82369),
(1197,'Cobourg Daily Star','Cobourg','ON',4402),
(1198,'The Chatham Daily News','Chatham','ON',13460),
(1199,'The Recorder and Times','Brockville','ON',11694),
(1200,'Standard-Freeholder','Cornwall','ON',14545),
(1201,'The Record','Kitchener','ON',64485),
(1202,'The Packet & Times','Orillia','ON',7996),
(1203,'The Barrie Examiner','Barrie','ON',9615),
(1204,'The Expositor','Brantford','ON',21240),
(1205,'Lindsay Daily Post','Lindsay','ON',4855),
(1206,'The Sun Times','Owen Sound','ON',16817),
(1207,'The Ottawa Sun','Ottawa','ON',48891),
(1208,'The Sudbury Star','Sudbury','ON',17002),
(1209,'The Chronicle-Journal','Thunder Bay','ON',28100),
(1210,'The Ottawa Citizen','Ottawa','ON',129631),
(1211,'Port Hope Evening Guide','Port Hope','ON',2393),
(1212,'The Peterborough Examiner','Peterborough','ON',21641),
(1213,'The Stratford Beacon-Herald','Stratford','ON',9861),
(1214,'The Intelligencer','Belleville','ON',15499);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1215,'The Globe and Mail','Toronto','ON',322807),
(1216,'The Sentinel-Review','Woodstock','ON',9579),
(1217,'The Toronto Star','Toronto','ON',436694),
(1218,'The Sault Star','Sault Sainte Marie','ON',18957),
(1219,'The Windsor Star','Windsor','ON',66644),
(1220,'Le Droit','Ottawa','ON',36058),
(1221,'The Tribune','Welland','ON',14496),
(1222,'Observer','Sarnia','ON',19354),
(1223,'National Post','Don Mills','ON',203781),
(1224,'The Simcoe Reformer','Simcoe','ON',8950),
(1225,'The Toronto Sun','Toronto','ON',179004),
(1226,'The Standard','Saint Catharines','ON',30340),
(1227,'The Daily Press','Timmins','ON',9661),
(1228,'St. Thomas Times-Journal','Saint Thomas','ON',6659),
(1229,'The Daily Observer','Pembroke','ON',5830),
(1230,'Daily Miner & News','Kenora','ON',3138),
(1231,'The Review','Niagara Falls','ON',16797),
(1232,'The Daily Astorian','Astoria','OR',8263),
(1233,'The Bulletin','Bend','OR',30191),
(1234,'Baker City Herald','Baker City','OR',3151);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1235,'The World','Coos Bay','OR',12388),
(1236,'Albany Democrat-Herald','Albany','OR',17094),
(1237,'Corvallis Gazette-Times','Corvallis','OR',11584),
(1238,'Statesman Journal','Salem','OR',50206),
(1239,'Daily Journal of Commerce','Portland','OR',3622),
(1240,'The Observer','La Grande','OR',6030),
(1241,'Argus Observer','Ontario','OR',6734),
(1242,'Daily Courier','Grants Pass','OR',15834),
(1243,'Herald and News','Klamath Falls','OR',16612),
(1244,'The Oregonian','Portland','OR',310803),
(1245,'The News-Review','Roseburg','OR',18644),
(1246,'East Oregonian','Pendleton','OR',9478),
(1247,'Mail Tribune','Medford','OR',30726),
(1248,'The Dalles Daily Chronicle','The Dalles','OR',4635),
(1249,'The Ashland Daily Tidings','Ashland','OR',5010),
(1250,'The Register-Guard','Eugene','OR',68497),
(1251,'The Progress','Clearfield','PA',12223),
(1252,'The Indiana Gazette','Indiana','PA',15558),
(1253,'Altoona Mirror','Altoona','PA',31480),
(1254,'Daily Courier','Connellsville','PA',7544);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1255,'The Express-Times','Easton','PA',46887),
(1256,'The Journal','Corry','PA',3512),
(1257,'The Morning Call','Allentown','PA',108200),
(1258,'The News-Herald','Oil City','PA',7373),
(1259,'The Derrick','Oil City','PA',18314),
(1260,'Ellwood City Ledger','Ellwood City','PA',5262),
(1261,'The Courier-Express','Du Bois','PA',9744),
(1262,'The Danville News','Danville','PA',2623),
(1263,'Leader Times','Kittanning','PA',8104),
(1264,'Valley News Dispatch','Tarentum','PA',28135),
(1265,'Weekend','New Castle','PA',0),
(1266,'The Valley Independent','Monessen','PA',13211),
(1267,'The Daily Item','Sunbury','PA',24164),
(1268,'The Express','Lock Haven','PA',8731),
(1269,'The Sentinel','Lewistown','PA',12532),
(1270,'The Daily News','McKeesport','PA',19672),
(1271,'Times News','Lehighton','PA',13718),
(1272,'The Philadelphia Inquirer','Philadelphia','PA',330622),
(1273,'Williamsport Sun-Gazette','Williamsport','PA',25994),
(1274,'The Sunday Voice','Wilkes-Barre','PA',0);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1275,'Morning Times','Sayre','PA',6187),
(1276,'The Ridgway Record','Ridgway','PA',2656),
(1277,'Delaware County Daily Times','Primos','PA',44052),
(1278,'The Mercury','Pottstown','PA',22102),
(1279,'Daily American','Somerset','PA',13499),
(1280,'REPUBLICAN & Herald','Pottsville','PA',26022),
(1281,'The Record Herald','Waynesboro','PA',8005),
(1282,'The Times-Tribune','Scranton','PA',53211),
(1283,'The Daily Press','Saint Marys','PA',4891),
(1284,'The Punxsutawney Spirit','Punxsutawney','PA',5545),
(1285,'The News-Item','Shamokin','PA',10112),
(1286,'The Phoenix','Phoenixville','PA',2990),
(1287,'Lebanon Daily News','Lebanon','PA',19788),
(1288,'Pittsburgh Post-Gazette','Pittsburgh','PA',212075),
(1289,'Observer-Reporter','Washington','PA',32454),
(1290,'Pocono Record','Stroudsburg','PA',19589),
(1291,'The Citizens\' Voice','Wilkes-Barre','PA',31521),
(1292,'Centre Daily Times','State College','PA',23996),
(1293,'Reading Eagle','Reading','PA',59550);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1294,'Herald-Standard','Uniontown','PA',25224),
(1295,'Times-Observer','Warren','PA',10786),
(1296,'The Times Herald','Norristown','PA',14419),
(1297,'Bucks County Courier Times','Levittown','PA',59019),
(1298,'The York Dispatch','York','PA',32690),
(1299,'York Sunday News','York','PA',0),
(1300,'York Daily Record','York','PA',46969),
(1301,'The Sunday Review','Towanda','PA',0),
(1302,'The Titusville Herald','Titusville','PA',3508),
(1303,'The Daily Review','Towanda','PA',8990),
(1304,'Daily Local News','West Chester','PA',26994),
(1305,'The Daily Herald','Tyrone','PA',1737),
(1306,'The Herald','Sharon','PA',20089),
(1307,'Times Leader','Wilkes-Barre','PA',39246),
(1308,'York Newspaper Company','York','PA',0),
(1309,'The Meadville Tribune','Meadville','PA',13884),
(1310,'The Standard-Journal','Milton','PA',1418),
(1311,'The Philadelphia Daily News','Philadelphia','PA',112540),
(1312,'New Castle News','New Castle','PA',17422),
(1313,'Standard-Speaker Sunday','Hazleton','PA',0);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1314,'The Latrobe Bulletin','Latrobe','PA',7767),
(1315,'Lancaster New Era','Lancaster','PA',41306),
(1316,'The Tribune-Democrat','Johnstown','PA',39121),
(1317,'The Patriot-News','Harrisburg','PA',95188),
(1318,'The Evening Sun','Hanover','PA',19527),
(1319,'Erie Times-News','Erie','PA',56462),
(1320,'Public Opinion','Chambersburg','PA',17089),
(1321,'The Daily News','Huntingdon','PA',10203),
(1322,'Standard-Speaker','Hazleton','PA',19940),
(1323,'Gettysburg Times','Gettysburg','PA',11199),
(1324,'Tri-County Sunday','Du Bois','PA',0),
(1325,'Bedford Gazette','Bedford','PA',10092),
(1326,'The Kane Republican','Kane','PA',1996),
(1327,'The Bradford Era','Bradford','PA',10478),
(1328,'The Reporter','Lansdale','PA',14005),
(1329,'The Record-Argus','Greenville','PA',5295),
(1330,'The Intelligencer','Doylestown','PA',39516),
(1331,'The Sentinel','Carlisle','PA',14650),
(1332,'Press Enterprise','Bloomsburg','PA',21051),
(1333,'Beaver County Times','Beaver','PA',39638);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1334,'The Wayne Independent','Honesdale','PA',4259),
(1335,'Butler Eagle','Butler','PA',27835),
(1336,'Sunday News','Lancaster','PA',0),
(1337,'Intelligencer Journal','Lancaster','PA',45527),
(1338,'Tribune-Review','Pittsburgh','PA',100478),
(1339,'The Guardian','Charlottetown','PEI',20540),
(1340,'The Journal-Pioneer','Summerside','PEI',8950),
(1341,'Le Nouvelliste','Trois-Rivieres','QC',43626),
(1342,'La Presse','Montreal','QC',204545),
(1343,'Progres-Dimanche','Chicoutimi','QC',0),
(1344,'La Tribune','Sherbrooke','QC',34399),
(1345,'Le Devoir','Montreal','QC',27490),
(1346,'The Record','Sherbrooke','QC',4806),
(1347,'The Gazette','Montreal','QC',138832),
(1348,'Le Soleil','Quebec','QC',79136),
(1349,'Le Journal de Montreal','Montreal','QC',267404),
(1350,'La Voix de l\'Est','Granby','QC',15804),
(1351,'Le Journal de Quebec','Vanier','QC',103220),
(1352,'Le Quotidien','Chicoutimi','QC',27665),
(1353,'The Providence Journal','Providence','RI',152736);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1354,'The Providence Sunday Journal','Providence','RI',0),
(1355,'The Westerly Sun','Westerly','RI',9421),
(1356,'The Call','Woonsocket','RI',10139),
(1357,'The Kent County Daily Times','West Warwick','RI',3390),
(1358,'The Times','Pawtucket','RI',8706),
(1359,'The Newport Daily News','Newport','RI',11968),
(1360,'The Item','Sumter','SC',19157),
(1361,'Morning News','Florence','SC',30590),
(1362,'Herald-Journal','Spartanburg','SC',45390),
(1363,'Daily Journal/Messenger','Seneca','SC',8938),
(1364,'Anderson Independent-Mail','Anderson','SC',34799),
(1365,'The Index-Journal','Greenwood','SC',14021),
(1366,'The Post and Courier','Charleston','SC',95709),
(1367,'Aiken Standard','Aiken','SC',16496),
(1368,'The Beaufort Gazette','Beaufort','SC',12407),
(1369,'The Island Packet','Hilton Head','SC',19348),
(1370,'The Greenville News','Greenville','SC',82683),
(1371,'The Herald','Rock Hill','SC',30053),
(1372,'The Union Daily Times','Union','SC',6355),
(1373,'The State','Columbia','SC',104880);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1374,'The Times and Democrat','Orangeburg','SC',17112),
(1375,'The Sun News','Myrtle Beach','SC',48057),
(1376,'Huron Plainsman','Huron','SD',6053),
(1377,'The Madison Daily Leader','Madison','SD',3054),
(1378,'Brookings Register','Brookings','SD',4658),
(1379,'American News','Aberdeen','SD',15914),
(1380,'Black Hills Pioneer','Spearfish','SD',3485),
(1381,'Yankton Daily Press & Dakotan','Yankton','SD',7855),
(1382,'Argus Leader','Sioux Falls','SD',51066),
(1383,'Rapid City Journal','Rapid City','SD',29257),
(1384,'Capital Journal','Pierre','SD',3968),
(1385,'Watertown Public Opinion','Watertown','SD',12543),
(1386,'The Daily Republic','Mitchell','SD',12317),
(1387,'The Leader-Post','Regina','SK',51066),
(1388,'Prince Albert Daily Herald','Prince Albert','SK',7096),
(1389,'The Moose Jaw Times-Herald','Moose Jaw','SK',8200),
(1390,'The StarPhoenix','Saskatoon','SK',54885),
(1391,'The Lebanon Democrat','Lebanon','TN',8815),
(1392,'The Daily Times','Maryville','TN',22564);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1393,'Knoxville News Sentinel','Knoxville','TN',115608),
(1394,'Kingsport Times-News','Kingsport','TN',41781),
(1395,'The Leaf-Chronicle','Clarksville','TN',20361),
(1396,'Herald-Citizen','Cookeville','TN',11309),
(1397,'The Greeneville Sun','Greeneville','TN',14326),
(1398,'The Mountain Press','Sevierville','TN',7824),
(1399,'The Messenger','Union City','TN',8335),
(1400,'The Jackson Sun','Jackson','TN',34033),
(1401,'Chattanooga Times Free Press','Chattanooga','TN',69372),
(1402,'Daily News','Kingsport','TN',2308),
(1403,'The Daily Post-Athenian','Athens','TN',10487),
(1404,'Cleveland Daily Banner','Cleveland','TN',13302),
(1405,'State Gazette','Dyersburg','TN',6949),
(1406,'Elizabethton Star','Elizabethton','TN',9366),
(1407,'The Plain Talk','Newport','TN',6480),
(1408,'The Tennessean','Nashville','TN',165131),
(1409,'The Paris Post-Intelligencer','Paris','TN',7793),
(1410,'Citizen Tribune','Morristown','TN',18330),
(1411,'Shelbyville Times-Gazette','Shelbyville','TN',7385);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1412,'The Daily News Journal','Murfreesboro','TN',14815),
(1413,'The Oak Ridger','Oak Ridge','TN',7554),
(1414,'Columbia Daily Herald','Columbia','TN',10963),
(1415,'The Commercial Appeal','Memphis','TN',154403),
(1416,'Johnson City Press','Johnson City','TN',29578),
(1417,'Al Dia','Dallas','TX',31784),
(1418,'Gainesville Daily Register','Gainesville','TX',5650),
(1419,'Hereford Brand','Hereford','TX',2807),
(1420,'Athens Daily Review','Athens','TX',4905),
(1421,'Austin American-Statesman','Austin','TX',168569),
(1422,'Henderson Daily News','Henderson','TX',5916),
(1423,'Valley Morning Star','Harlingen','TX',20301),
(1424,'The Brownsville Herald','Brownsville','TX',16353),
(1425,'Amarillo Sunday Globe-News','Amarillo','TX',0),
(1426,'Alice Echo-News Journal','Alice','TX',3845),
(1427,'Corsicana Daily Sun','Corsicana','TX',7053),
(1428,'Lubbock Avalanche-Journal','Lubbock','TX',50949),
(1429,'The Dallas Morning News','Dallas','TX',404653),
(1430,'Jacksonville Daily Progress','Jacksonville','TX',4170);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1431,'Palestine Herald-Press','Palestine','TX',7555),
(1432,'New Braunfels Herald-Zeitung','New Braunfels','TX',8030),
(1433,'Brenham Banner-Press','Brenham','TX',5813),
(1434,'The Facts','Clute','TX',16821),
(1435,'Killeen Daily Herald','Killeen','TX',18595),
(1436,'Cleburne Times-Review','Cleburne','TX',6708),
(1437,'El Nuevo Heraldo (Spanish Edition)','Brownsville','TX',7361),
(1438,'The Eagle','Bryan','TX',22115),
(1439,'Brownwood Bulletin','Brownwood','TX',7120),
(1440,'Odessa American','Odessa','TX',24336),
(1441,'The Mexia Daily News','Mexia','TX',2313),
(1442,'The Daily Sentinel','Nacogdoches','TX',7842),
(1443,'The Monitor','McAllen','TX',38994),
(1444,'The Paris News','Paris','TX',9302),
(1445,'Pasadena Citizen','Pasadena','TX',5124),
(1446,'The Weatherford Democrat','Weatherford','TX',6140),
(1447,'Plano Star Courier','Plano','TX',8312),
(1448,'Port Arthur News','Port Arthur','TX',12447),
(1449,'Fort Bend Herald','Rosenberg','TX',7723);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1450,'Plainview Daily Herald','Plainview','TX',6481),
(1451,'The Pampa News','Pampa','TX',5240),
(1452,'The Orange Leader','Orange','TX',4968),
(1453,'Wichita Falls Times Record News','Wichita Falls','TX',29646),
(1454,'Texarkana Gazette','Texarkana','TX',29597),
(1455,'Sulphur Springs News-Telegram','Sulphur Springs','TX',5693),
(1456,'Taylor Daily Press','Taylor','TX',4658),
(1457,'Stephenville Empire-Tribune','Stephenville','TX',4142),
(1458,'San Antonio Express-News','San Antonio','TX',223846),
(1459,'Sweetwater Reporter','Sweetwater','TX',3128),
(1460,'Snyder Daily News','Snyder','TX',3565),
(1461,'Herald Democrat','Sherman','TX',23695),
(1462,'Tyler Morning Telegraph','Tyler','TX',38550),
(1463,'Victoria Advocate','Victoria','TX',33486),
(1464,'Waxahachie Daily Light','Waxahachie','TX',4745),
(1465,'The Vernon Daily Record','Vernon','TX',4284),
(1466,'The Terrell Tribune','Terrell','TX',2466),
(1467,'Waco Tribune-Herald','Waco','TX',38056);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1468,'Midland Reporter-Telegram','Midland','TX',19363),
(1469,'The Seguin Gazette-Enterprise','Seguin','TX',4790),
(1470,'Temple Daily Telegram','Temple','TX',19416),
(1471,'Marshall News Messenger','Marshall','TX',6675),
(1472,'McKinney Courier-Gazette','McKinney','TX',5215),
(1473,'Mineral Wells Index','Mineral Wells','TX',4867),
(1474,'San Marcos Daily Record','San Marcos','TX',5101),
(1475,'San Angelo Standard-Times','San Angelo','TX',25003),
(1476,'Mount Pleasant Daily Tribune','Mount Pleasant','TX',4988),
(1477,'Houston Chronicle','Houston','TX',508097),
(1478,'Corpus Christi Caller-Times','Corpus Christi','TX',50550),
(1479,'Courier','Conroe','TX',10798),
(1480,'Kerrville Daily Times','Kerrville','TX',8862),
(1481,'The Lufkin Daily News','Lufkin','TX',14362),
(1482,'Ennis Daily News','Ennis','TX',3214),
(1483,'El Paso Times','El Paso','TX',68998),
(1484,'Denton Record-Chronicle','Denton','TX',17435),
(1485,'The River Cities Tribune','Marble Falls','TX',3381);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1486,'The Baytown Sun','Baytown','TX',10763),
(1487,'Laredo Morning Times','Laredo','TX',18270),
(1488,'Big Spring Herald','Big Spring','TX',4337),
(1489,'The Beaumont Enterprise','Beaumont','TX',49938),
(1490,'Kilgore News Herald','Kilgore','TX',2685),
(1491,'Del Rio News-Herald','Del Rio','TX',5116),
(1492,'Longview News-Journal','Longview','TX',27468),
(1493,'The Huntsville Item','Huntsville','TX',5646),
(1494,'Borger News-Herald','Borger','TX',4443),
(1495,'Amarillo Globe-News','Amarillo','TX',49139),
(1496,'Fort Worth Star-Telegram','Fort Worth','TX',206991),
(1497,'The Galveston County Daily News','Galveston','TX',23978),
(1498,'Abilene Reporter-News','Abilene','TX',30101),
(1499,'Standard-Examiner','Ogden','UT',60001),
(1500,'The Deseret Morning News','Salt Lake City','UT',71382),
(1501,'The Salt Lake Tribune','Salt Lake City','UT',131361),
(1502,'Newspaper Agency Corp.','West Valley City','UT',0),
(1503,'The Herald Journal','Logan','UT',14874);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1504,'The Daily Herald','Provo','UT',31779),
(1505,'The Spectrum','Saint George','UT',22845),
(1506,'Culpeper Star-Exponent','Culpeper','VA',7291),
(1507,'The Daily Progress','Charlottesville','VA',28627),
(1508,'Danville Register & Bee','Danville','VA',20897),
(1509,'The Free Lance-Star','Fredericksburg','VA',45811),
(1510,'The News Leader','Staunton','VA',17671),
(1511,'USA TODAY','McLean','VA',2278022),
(1512,'The Washington Examiner','Springfield','VA',260950),
(1513,'The Virginian-Pilot','Norfolk','VA',183210),
(1514,'Manassas Journal Messenger','Manassas','VA',8073),
(1515,'Daily Press','Newport News','VA',86129),
(1516,'Potomac News','Woodbridge','VA',13827),
(1517,'Daily News-Record','Harrisonburg','VA',31100),
(1518,'The Roanoke Times','Roanoke','VA',88901),
(1519,'The Southwest Times','Pulaski','VA',5718),
(1520,'Martinsville Bulletin','Martinsville','VA',16523),
(1521,'The News Virginian','Waynesboro','VA',7345),
(1522,'Northern Virginia Daily','Strasburg','VA',15652);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1523,'The Winchester Star','Winchester','VA',20567),
(1524,'Potomac News & Manassas Journal','Manassas','VA',0),
(1525,'Potomac News & Manassas Journal Messenge','Woodbridge','VA',0),
(1526,'The Progress-Index','Petersburg','VA',13060),
(1527,'The News & Advance','Lynchburg','VA',35264),
(1528,'Richmond Times-Dispatch','Richmond','VA',181369),
(1529,'Bristol Herald-Courier','Bristol','VA',38179),
(1530,'Suffolk News-Herald','Suffolk','VA',4337),
(1531,'Virginian Review','Covington','VA',7406),
(1532,'Valley News','White River Junction','VT',16650),
(1533,'The Burlington Free Press','Burlington','VT',45338),
(1534,'Bennington Banner','Bennington','VT',7107),
(1535,'Sunday Valley News','White River Junction','VT',0),
(1536,'The Caledonian-Record','Saint Johnsbury','VT',10006),
(1537,'The Newport Daily Express','Newport','VT',3750),
(1538,'Rutland Herald','Rutland','VT',18157),
(1539,'St. Albans Messenger','Saint Albans','VT',5040),
(1540,'The Times Argus','Barre','VT',8749);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1541,'Brattleboro Reformer','Brattleboro','VT',9200),
(1542,'The Spokesman-Review','Spokane','WA',93089),
(1543,'Daily Sun News','Sunnyside','WA',3818),
(1544,'The Olympian','Olympia','WA',32833),
(1545,'Yakima Herald-Republic','Yakima','WA',37112),
(1546,'Walla Walla Union-Bulletin','Walla Walla','WA',13840),
(1547,'Seattle Times/Seattle Post-Intelligencer','Seattle','WA',0),
(1548,'The Seattle Times/Seattle Post-Intellige','Seattle','WA',0),
(1549,'Seattle Daily Journal of Commerce','Seattle','WA',5047),
(1550,'The Chronicle','Centralia','WA',13912),
(1551,'The Seattle Times','Seattle','WA',212691),
(1552,'Seattle Post-Intelligencer','Seattle','WA',126225),
(1553,'Daily Record','Ellensburg','WA',5497),
(1554,'The Bellingham Herald','Bellingham','WA',23175),
(1555,'Peninsula Daily News','Port Angeles','WA',16798),
(1556,'The Daily News','Longview','WA',21530),
(1557,'The Wenatchee World','Wenatchee','WA',24611),
(1558,'The Columbian','Vancouver','WA',46203);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1559,'Columbia Basin Herald','Moses Lake','WA',7780),
(1560,'The Daily Herald','Everett','WA',49035),
(1561,'The News Tribune','Tacoma','WA',116150),
(1562,'Tri-City Herald','Tri-Cities','WA',40927),
(1563,'The Daily World','Aberdeen','WA',14098),
(1564,'The Sun','Bremerton','WA',29302),
(1565,'Skagit Valley Herald','Mount Vernon','WA',17983),
(1566,'Baraboo News-Republic','Baraboo','WI',4234),
(1567,'Marshfield News-Herald','Marshfield','WI',11588),
(1568,'EagleHerald','Marinette','WI',10153),
(1569,'Leader-Telegram','Eau Claire','WI',24919),
(1570,'The Daily Press','Ashland','WI',6153),
(1571,'Daily Jefferson County Union','Fort Atkinson','WI',7450),
(1572,'Antigo Daily Journal','Antigo','WI',6779),
(1573,'The Daily News','West Bend','WI',9607),
(1574,'The Daily Telegram','Superior','WI',8180),
(1575,'Oshkosh Northwestern','Oshkosh','WI',20760),
(1576,'The Sheboygan Press','Sheboygan','WI',20896),
(1577,'The Daily News','Rhinelander','WI',5302);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1578,'The Freeman','Waukesha','WI',12804),
(1579,'The Journal Times','Racine','WI',28375),
(1580,'The Monroe Times','Monroe','WI',5196),
(1581,'Shawano Leader','Shawano','WI',6575),
(1582,'The Wausau Daily Herald','Wausau','WI',20903),
(1583,'Stevens Point Journal','Stevens Point','WI',11381),
(1584,'Milwaukee Journal Sentinel','Milwaukee','WI',230781),
(1585,'The Capital Times','Madison','WI',17581),
(1586,'The Chippewa Herald','Chippewa Falls','WI',6882),
(1587,'The Post-Crescent','Appleton','WI',50868),
(1588,'Green Bay Press-Gazette','Green Bay','WI',54967),
(1589,'Beloit Daily News','Beloit','WI',14193),
(1590,'Watertown Daily Times','Watertown','WI',9287),
(1591,'Daily Register','Portage','WI',4927),
(1592,'Freeman Weekend','Waukesha','WI',0),
(1593,'Daily Tribune','Wisconsin Rapids','WI',11194),
(1594,'Kenosha News','Kenosha','WI',24768),
(1595,'Wisconsin State Journal','Madison','WI',87547),
(1596,'Herald Times Reporter','Manitowoc','WI',14118);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1597,'The Janesville Gazette','Janesville','WI',21677),
(1598,'The Reporter','Fond du Lac','WI',15491),
(1599,'Daily Citizen','Beaver Dam','WI',9917),
(1600,'La Crosse Tribune','La Crosse','WI',31941),
(1601,'Charleston Newspapers','Charleston','WV',0),
(1602,'West Virginia Daily News','Lewisburg','WV',4100),
(1603,'The Exponent Telegram','Clarksburg','WV',15417),
(1604,'The Register-Herald','Beckley','WV',27894),
(1605,'Williamson Daily News','Williamson','WV',8028),
(1606,'Point Pleasant Register','Point Pleasant','WV',3918),
(1607,'Moundsville Daily Echo','Moundsville','WV',3902),
(1608,'Sunday Gazette-Mail','Charleston','WV',0),
(1609,'The Logan Banner','Logan','WV',9579),
(1610,'Bluefield Daily Telegraph','Bluefield','WV',17910),
(1611,'The Dominion Post','Morgantown','WV',21125),
(1612,'Times West Virginian','Fairmont','WV',10626),
(1613,'Saturday Gazette-Mail','Charleston','WV',0),
(1614,'Saturday Gazette-Mail','Charleston','WV',0),
(1615,'The Parkersburg Sentinel','Parkersburg','WV',3590);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1616,'Mineral Daily News-Tribune','Keyser','WV',3935),
(1617,'Charleston Daily Mail','Charleston','WV',23259),
(1618,'The Parkersburg News','Parkersburg','WV',21961),
(1619,'The Herald-Dispatch','Huntington','WV',27652),
(1620,'Sunday Gazette-Mail','Charleston','WV',0),
(1621,'The Journal','Martinsburg','WV',18745),
(1622,'The Intelligencer','Wheeling','WV',19367),
(1623,'Charleston Gazette','Charleston','WV',48705),
(1624,'The Inter-Mountain','Elkins','WV',10526),
(1625,'The Sunday Journal','Martinsburg','WV',0),
(1626,'Wheeling News-Register','Wheeling','WV',13993),
(1627,'Mountain Echo','Keyser','WV',0),
(1628,'Rawlins Daily Times','Rawlins','WY',3575),
(1629,'The Riverton Ranger','Riverton','WY',7120),
(1630,'Laramie Daily Boomerang','Laramie','WY',5176),
(1631,'Northern Wyoming Daily News','Worland','WY',3468),
(1632,'Wyoming Tribune-Eagle','Cheyenne','WY',15681),
(1633,'The Sheridan Press','Sheridan','WY',6565),
(1634,'Daily Rocket-Miner','Rock Springs','WY',8064);
INSERT INTO `papers` (`id`,`name`,`state`,`city`,`circulation`) VALUES
(1635,'Casper Star-Tribune','Casper','WY',31562),
(1636,'The News-Record','Gillette','WY',6479),
(1637,'Whitehorse Star','Whitehorse','YT',2333);
Nice, I will go run that query in my database. Thanks for that, when I go back to my computer, I will try as what you suggested above.
Any thoughts on the other file?
Thanks a ton for this! I really appreciate it.
Ryan
Any thoughts on the other file?
Thanks a ton for this! I really appreciate it.
Ryan
I use this query to upload the second file
load data local infile 'D:/Documentos/Mis archivos recibidos/papers.csv' into table papers
fields terminated by ','
lines terminated by '\n'
(name,state,city,circulation)
Ill give this a shot, thanks! So the last line refers to the table names correct? And it does it by order left to right on the spreadsheet?
Ryan
Ryan
Yes, that's rigth Ryan, the las line must match the order of the csv file from left to rigth
Hope this helps with other files
Also, here is the link to the GUi tools of mysql
http://dev.mysql.com/downloads/gui-tools/5.0.html
Ruben
Hope this helps with other files
Also, here is the link to the GUi tools of mysql
http://dev.mysql.com/downloads/gui-tools/5.0.html
Ruben
Starting to get it, haha. Thanks for all of your help, Ill let you know how the rest goes!
Ryan
Ryan
hope it helps
Ruben
Ruben
I got it too work, thanks so much for your help!
That is good to hear
Anytime Ryan
And thanks for the points also
Anytime Ryan
And thanks for the points also
Hey man! I was wondering if you could take a look at this and help me out!
This is bugging me!
Thanks in advance!
Ryan
https://www.experts-exchange.com/questions/23012089/Organizing-spreadsheet-to-import-to-SQL.html
This is bugging me!
Thanks in advance!
Ryan
https://www.experts-exchange.com/questions/23012089/Organizing-spreadsheet-to-import-to-SQL.html
UPDATE!!!
Hey man sorry here is the new question:
https://www.experts-exchange.com/questions/23012190/Organizing-spreadsheet-to-import-to-SQL.html
Thanks so much,
Ryan
Hey man sorry here is the new question:
https://www.experts-exchange.com/questions/23012190/Organizing-spreadsheet-to-import-to-SQL.html
Thanks so much,
Ryan
ASKER