Table 4-51: Air Pollution Trends in Selected Metropolitan Statistical Areas (Number of days with AQI values greater than 100 at trend sites and all monitoring sites)

data.transportation.gov | Last Updated 11 Oct 2018

This dataset has the following 106 columns:

Column NameAPI Column NameData TypeSample Values
Metropolitan Statistical Areametropolitan_statisticaltext
Total number of sites in 2010, Number of days with AQI > 100 (2010), Number of trend sites (2010)column_1text
Yearcolumn_2text
Akron, OHakron_ohnumber
Albany-Schenectady-Troy, NYalbany_schenectady_troy_nynumber
Albuquerque, NMalbuquerque_nmnumber
Allentown-Bethlehem-Easton, PAallentown_bethlehem_eastonnumber
Atlanta-Sandy Springs-Marietta, GAatlanta_sandy_springs_mariettanumber
Austin-Round Rock, TXaustin_round_rock_txnumber
Bakersfield, CAbakersfield_canumber
Baltimore-Towson, MDbaltimore_towson_mdnumber
Baton Rouge, LAbaton_rouge_lanumber
Bergen-Passaic, NJbergen_passaic_njtext
Birmingham-Hoover, ALbirmingham_hoover_alnumber
Boston-Cambridge-Quincy, MA-NHboston_cambridge_quincy_manumber
Bradenton-Sarasota-Venice, FLbradenton_sarasota_venicenumber
Bridgeport-Stamford-Norwalk, CTbridgeport_stamford_norwalknumber
Buffalo-Niagara Falls, NYbuffalo_niagara_falls_nynumber
Charleston-North Charleston, SCcharleston_north_charlestonnumber
Charlotte-Gastonia-Concord, NC-SCcharlotte_gastonia_concordnumber
Chicago-Naperville-Joliet, IL-IN-WIchicago_naperville_jolietnumber
Cincinnati-Middletown, OH-KY-INcincinnati_middletown_ohnumber
Cleveland-Elyria-Mentor, OHcleveland_elyria_mentor_ohnumber
Columbia, SCcolumbia_scnumber
Columbus, OHcolumbus_ohnumber
Dallas-Fort Worth-Arlington, TXdallas_fort_worth_arlingtonnumber
Dayton, OHdayton_ohnumber
Denver-Aurora, COdenver_aurora_conumber
Detroit-Warren-Livonia, MIdetroit_warren_livonia_minumber
El Paso, TXel_paso_txnumber
Fort Lauderdale, FLfort_lauderdale_fltext
Fort Worth-Arlington, TXfort_worth_arlington_txtext
Fresno, CAfresno_canumber
Gary, INgary_intext
Grand Rapids-Wyoming, MIgrand_rapids_wyoming_minumber
Greensboro-Winston Salem-High Point, NCgreensboro_winston_salemtext
Greenville-Mauldin-Easley, SCgreenville_mauldin_easleynumber
Harrisburg-Carlisle, PAharrisburg_carlisle_panumber
Hartford-West Hartford-East Hartford, CThartford_west_hartford_eastnumber
Honolulu, HIhonolulu_hinumber
Houston-Sugarland-Baytown, TXhouston_sugarland_baytownnumber
Indianapolis-Carmel, INindianapolis_carmel_innumber
Jacksonville, FLjacksonville_flnumber
Jersey City, NJjersey_city_njtext
Kansas City, MO-KSkansas_city_mo_ksnumber
Knoxville, TNknoxville_tnnumber
Las Vegas-Paradise, NVlas_vegas_paradise_nvnumber
Little Rock-North Little Rock-Conway, ARlittle_rock_north_littlenumber
Los Angeles-Long Beach-Santa Ana, CAlos_angeles_long_beach_santanumber
Louisville/Jefferson County, KY-INlouisville_jefferson_countynumber
Madison, WImadison_winumber
McAllen-Edinburg-Mission, TXmcallen_edinburg_missionnumber
Memphis, TN-AR-MSmemphis_tn_ar_msnumber
Miami-Fort Lauderdale-Pompano Beach, FLmiami_fort_lauderdale_pompanonumber
Middlesex-Somerset-Hunterdon, NJmiddlesex_somerset_hunterdontext
Milwaukee-Waukesha-West Allis, WImilwaukee_waukesha_west_allisnumber
Minneapolis-St. Paul-Bloomington, MN-WIminneapolis_st_paulnumber
Monmouth-Ocean, NJmonmouth_ocean_njtext
Nashville-Davidson-Murfreesboro-Franklin, TNnashville_davidsonnumber
Nassau-Suffolk, NYnassau_suffolk_nytext
New Haven-Milford, CTnew_haven_milford_ctnumber
New Orleans-Metairie-Kenner, LAnew_orleans_metairie_kennernumber
New York-Northern New Jersey-Long Island, NY-NJ-PAnew_york_northern_new_jerseynumber
Newark, NJnewark_njtext
Oakland, CAoakland_catext
Oklahoma City, OKoklahoma_city_oknumber
Omaha-Council Bluffs, NE-IAomaha_council_bluffs_ne_ianumber
Orange County, CAorange_county_catext
Orlando-Kissimmee, FLorlando_kissimmee_flnumber
Oxnard-Thousands Oaks-Ventura, CAoxnard_thousands_oaks_venturanumber
Philadelphia-Camden-Wilmington, PA-NJ-DE-MDphiladelphia_camden_wilmingtonnumber
Phoenix-Mesa-Scottsdale, AZphoenix_mesa_scottsdale_aznumber
Pittsburgh, PApittsburgh_panumber
Portland-Vancouver-Beaverton, OR-WAportland_vancouver_beavertonnumber
Poughkeepsie-Newburgh-Middleton, NYpoughkeepsie_newburghtext
Providence-New Bedford-Fall River, RI-MAprovidence_new_bedford_fallnumber
Raleigh-Cary, NCraleigh_cary_ncnumber
Richmond, VArichmond_vanumber
Riverside-San Bernardino-Ontario, CAriverside_san_bernardinonumber
Rochester, NYrochester_nynumber
Sacramento-Arden-Arcade-Roseville, CAsacramento_arden_arcadenumber
St, Louis, MO-ILst_louis_mo_ilnumber
Salt Lake City, UTsalt_lake_city_utnumber
San Antonio, TXsan_antonio_txnumber
San Diego-Carlsbad-San Marcos, CAsan_diego_carlsbad_san_marcosnumber
San Francisco-Oakland-Fremont, CAsan_francisco_oakland_fremontnumber
San Jose-Sunnyvale-Santa Clara, CAsan_jose_sunnyvale_santanumber
San Juan-Caguas-Guaynabo, PRsan_juan_caguas_guaynabonumber
Scranton-Wilkes Barre, PAscranton_wilkes_barre_panumber
Seattle-Tacoma-Bellevue, WAseattle_tacoma_bellevue_wanumber
Springfield, MAspringfield_manumber
Stockton, CAstockton_canumber
Syracuse, NYsyracuse_nynumber
Tacoma, WAtacoma_watext
Tampa-St. Petersburg-Clearwater, FLtampa_st_petersburg_clearwaternumber
Toledo, OHtoledo_ohnumber
Tucson, AZtucson_aznumber
Tulsa, OKtulsa_oknumber
Ventura, CAventura_catext
Virginia Beach-Norfolk-Newport News, VA-NCvirginia_beach_norfolk_newportnumber
Washington-Arlington-Alexandria, DC-MD-VA-WVwashington_arlingtonnumber
West Palm Beach-Boca Raton, FLwest_palm_beach_boca_ratontext
Wichita, KSwichita_ksnumber
Wilmington-Newark, DE-MDwilmington_newark_de_mdtext
Worcester, MAworcester_manumber
Youngstown-Warren-Boardman, OHyoungstown_warren_boardmannumber