Reports
INFO

This is a simple one-table application that lists all of the assigned area codes in North America.  If you know the area code, you can do a search to determine its location.  The source of this data is:
http://www.bennetyee.org/ucsd-pages/area.state.html

Manager: QuickBase
Account: QuickBase_Exchange_Account
Last modified: Jan. 8, 2019 4:37 PM (PST)
application stats

List All
 
Area Code
State
Location
Timezone Offset (from UTC)
Daylight savings
not observed
Notes
 
52 MX Mexico: Mexico City area -6   (country code + city code)
201 NJ N New Jersey: Jersey City, Hackensack -5   (see split 973, overlay 551)
202 DC Washington, D.C. -5    
203 CT Connecticut: Fairfield County and New Haven County; Bridgeport, New Haven -5   (see 860)
204 MB Canada: Manitoba -6    
205 AL Central Alabama -6   (including Birmingham; excludes the southeastern corner of Alabama and the deep south; see splits 256 and 334)
206 WA W Washington state: Seattle and Bainbridge Island -8   (see splits 253, 360, 425; overlay 564)
207 ME Maine -5    
208 ID Idaho -7/-8    
209 CA Cent. California: Stockton -8   (see split 559)
210 TX S Texas: San Antonio -6   (see also splits 830, 956)
211   Local community info / referral services      
212 NY New York City, New York -5   (Manhattan; see 646, 718)
213 CA S California: Los Angeles -8   (see 310, 323, 626, 818)
214 TX Texas: Dallas Metro -6   (overlays 469/972)
215 PA SE Pennsylvania: Philadelphia -5   (see overlays 267)
216 OH Cleveland -5   (see splits 330, 440)
217 IL Cent. Illinois: Springfield -6    
218 MN N Minnesota: Duluth -6    
219 IN NW Indiana: Gary -6/-5   (see split 574, 260)
224 IL Northern NE Illinois: Evanston, Waukegan, Northbrook -6   (overlay on 847, eff 1/5/02)
225 LA Louisiana: Baton Rouge, New Roads, Donaldsonville, Albany, Gonzales, Greensburg, Plaquemine, Vacherie -6   (split from 504)
226 ON Canada: SW Ontario: Windsor -5   (overlaid on 519; eff 6/06)
228 MS S Mississippi -6   (coastal areas, Biloxi, Gulfport; split from 601)
229 GA SW Georgia: Albany -5   (split from 912; see also 478; perm 8/1/00)
231 MI W Michigan: Northwestern portion of lower Peninsula; Traverse City, Muskegon, Cheboygan, Alanson -5    
234 OH NE Ohio: Canton, Akron -5   (overlaid on 330; perm 10/30/00)
236 VA Virginia -5   (region unknown) / Unassigned?
239 FL Florida -5   (Lee, Collier, and Monroe Counties, excl the Keys; see 305; eff 3/11/02; mand 3/11/03)
240 MD W Maryland: Silver Spring, Frederick, Gaithersburg -5   (overlay, see 301)
242   Bahamas -5    
246   Barbados -4    
248 MI Michigan: Oakland County, Pontiac -5   (split from 810; see overlay 947)
250 BC Canada: British Columbia -8/-7   (see 604)
251 AL S Alabama: Mobile and coastal areas, Jackson, Evergreen, Monroeville -6   (split from 334, eff 6/18/01; see also 205, 256)
252 NC E North Carolina -5   (Rocky Mount; split from 919)
253 WA Washington: South Tier - Tacoma, Federal Way -8   (split from 206, see also 425; overlay 564)
254 TX Central Texas -6   (Waco, Stephenville; split, see 817, 940)
256 AL E and N Alabama -6   (Huntsville, Florence, Gadsden; split from 205; see also 334)
260 IN NE Indiana: Fort Wayne -5   (see 219)
262 WI SE Wisconsin: counties of Kenosha, Ozaukee, Racine, Walworth, Washington, Waukesha -6   (split from 414)
264   Anguilla -4   (split from 809)
267 PA SE Pennsylvania: Philadelphia -5   (see 215)
268   Antigua and Barbuda -4   (split from 809)
269 MI SW Michigan: Kalamazoo, Saugatuck, Hastings, Battle Creek, Sturgis to Lake Michigan -5   (split from 616)
270 KY W Kentucky: Bowling Green, Paducah -6   (split from 502)
276 VA S and SW Virginia: Bristol, Stuart, Martinsville -5   (split from 540; perm 9/1/01, mand 3/16/02)
278 MI Michigan -5   (overlaid on 734, SUSPENDED)
281 TX Texas: Houston Metro -6   (split 713; overlay 832)
283 OH SW Ohio: Cincinnati -5   (cancelled: overlaid on 513)
284   British Virgin Islands -4   (split from 809)
289 ON Canada: S Cent. Ontario: Greater Toronto Area -- Durham, Halton, Hamilton-Wentworth, Niagara, Peel, York, and southern Simcoe County -5   (excluding Toronto -- overlaid on 905, eff 6/9/01)
301 MD W Maryland: Silver Spring, Frederick, Camp Springs, Prince George's County -5   (see 240)
302 DE Delaware -5    
303 CO Central Colorado: Denver -7   (see 970, also 720 overlay)
304 WV West Virginia -5    
305 FL SE Florida: Miami, the Keys -5   (see 786, 954; 239)
306 SK Canada: Saskatchewan -6/-7 Yes  
307 WY Wyoming -7    
308 NE W Nebraska: North Platte -6/-7    
309 IL W Cent. Illinois: Peoria -6    
310 CA S California: Beverly Hills, West Hollywood, West Los Angeles -8   (see split 562; overlay 424)
311   Reserved for special applications      
312 IL Illinois: Chicago -6   (downtown only -- in the loop; see 773; overlay 872)
313 MI Michigan: Detroit and suburbs -5   (see 734, overlay 679)
314 MO SE Missouri: St Louis city and parts of the metro area only -6   (see 573, 636, overlay 557)
315 NY N Cent. New York: Syracuse -5    
316 KS S Kansas: Wichita -6   (see split 620)
317 IN Cent. Indiana: Indianapolis -5   (see 765)
318 LA N Louisiana: Shreveport, Ruston, Monroe, Alexandria -6   (see split 337)
319 IA E Iowa: Cedar Rapids -6   (see split 563)
320 MN Cent. Minnesota: Saint Cloud -6   (rural Minn, excl St. Paul/Minneapolis)
321 FL Florida: Brevard County, Cape Canaveral area; Metro Orlando -5   (split from 407)
323 CA S California: Los Angeles -8   (outside downtown: Hollywood; split from 213)
325 TX Central Texas: Abilene, Sweetwater, Snyder, San Angelo -6   (split from 915)
330 OH NE Ohio: Akron, Canton, Youngstown; Mahoning County, parts of Trumbull/Warren counties -5   (see splits 216, 440, overlay 234)
331 IL W NE Illinois, western suburbs of Chicago -6   (part of what used to be 708; overlaid on 630; assigned but not in use)
334 AL S Alabama: Auburn/Opelika, Montgomery and coastal areas -6   (part of what used to be 205; see also 256, split 251)
336 NC Cent. North Carolina: Greensboro, Winston-Salem, High Point -5   (split from 910)
337 LA SW Louisiana: Lake Charles, Lafayette -6   (see split 318)
339 MA Massachusetts: Boston suburbs, to the south and west -5   (see splits 617, 508; overlaid on 781, eff 5/2/01)
340 VI US Virgin Islands -4 Yes (see also 809)
341 CA   -8   (overlay on 510; SUSPENDED)
345   Cayman Islands -5    
347 NY New York -5   (overlay for 718: NYC area, except Manhattan)
351 MA Massachusetts: north of Boston to NH, 508, and 781 -5   (overlaid on 978, eff 4/2/01)
352 FL Florida: Gainesville area, Ocala, Crystal River -5   (split from 904)
360 WA W Washington State: Olympia, Bellingham -8   (except Seattle area; part of what used to be 206; see overlay 564)
361 TX S Texas: Corpus Christi -6   (split from 512; eff 2/13/99)
369 CA Solano County -8   (perm 12/2/00, mand 6/2/01)
380 OH Ohio: Columbus -5   (overlaid on 614; assigned but not in use)
385 UT Utah: Salt Lake City Metro -7   (split from 801, eff 3/30/02 POSTPONED; see also 435)
386 FL N central Florida: Lake City -5   (split from 904, perm 2/15/01, mand 11/5/01)
401 RI Rhode Island -5    
402 NE E Nebraska: Omaha, Lincoln -6    
403 AB Canada: Southern Alberta -7   (see 780, 867)
404 GA N Georgia: Atlanta and suburbs -5   (see overlay 678, split 770)
405 OK W Oklahoma: Oklahoma City -6   (see 580)
406 MT Montana -7    
407 FL Central Florida: Metro Orlando -5   (see overlay 689, eff 7/02; split 321)
Result Pages:  1  2  3  4    
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:
Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.

Show fields from Show fields from Show fields from a related table