2020 Census Tracts from the US Census for New York City. These boundary files are derived from the US Census Bureau's TIGER data products and have been geographically modified to fit the New York City base map. All previously released versions of this data are available at BYTES of the BIG APPLE- Archive.

My ArcGIS StoryMap is centered around The Green Book, an annual travel guide that allowed African Americans to travel safely during the height of the Jim Crow Era in the United States. More specifically, The Green Book listed establishments, such as hotels and restaurants, that would openly accept and welcome black customers into their businesses. As someone who is interested in the intersection between STEM and the humanities, I wanted to utilize The Science of Where to formulate a project that would reveal important historical implications to the public. Therefore, my overarching goal was to map each location in The Green Book in order to draw significant conclusions regarding racial segregation in one of the largest cities in the entire world.Although a more detailed methodology of my work can be found in the project itself, the following is a step by step walkthrough of my overall scientific process:Develop a question in relation to The Green Book to be solved through the completion of the project.Perform background research on The Green Book to gain a more comprehensive understanding of the subject matter.Formulate a hypothesis that answers the proposed question based on the background research.Transcribe names and addresses for each of the hotel listings in The Green Book into a comma separated values file.Transcribe names and addresses for each of the restaurants listings in The Green Book into a comma separated values file.Repeat Steps 4 and 5 for the 1940, 1950, 1960, and 1966 publications of The Green Book. In total, there should be eight unique database files (1940 New York City Hotels, 1940 New York City Restaurants, 1950 New York City Hotels, 1950 New York City Restaurants, 1960 New York City Hotels, 1960 New York City Restaurants, 1966 New York City Hotels, and 1966 New York City Restaurants.)Construct an address locator that references a New York City street base map to plot the information from the databases in Step 6 as points on a map.Manually plot locations that the address locator did not automatically match on the map.Repeat Steps 7 and 8 for all eight database files.Find and match the point locations for each listing in The Green Book with historical photographs.Generate a map tour using the geotagged images for each point from Step 10.Create a point density heat map for the locations in all eight database files.Research and obtain professional and historically accurate racial demographic data for New York City during the same time period as when The Green Book was published.Generate a hot spot map of the black population percentage using the demographic data.Analyze any geospatial trends between the point density heat maps for The Green Book and the black population percentage hot spot maps from the demographic data.Research and obtain professional and historically accurate redlining data for New York City during the same time period as when The Green Book was published.Overlay the points from The Green Book listings from Step 9 on top of the redlining shapefile.Count the number of point features completely located within each redlining zone ranking utilizing the spatial join tool.Plot the data recorded from Step 18 in the form of graphs.Analyze any geospatial trends between the listings for The Green Book and its location relative to the redlining ranking zones.Draw conclusions from the analyses in Steps 15 and 20 to present a justifiable rationale for the results._Student Generated Maps:New York City Pin Location Maphttps://arcg.is/15i4nj1940 New York City Hotels Maphttps://arcg.is/WuXeq1940 New York City Restaurants Maphttps://arcg.is/L4aqq1950 New York City Hotels Maphttps://arcg.is/1CvTGj1950 New York City Restaurants Maphttps://arcg.is/0iSG4r1960 New York City Hotels Maphttps://arcg.is/1DOzeT1960 New York City Restaurants Maphttps://arcg.is/1rWKTj1966 New York City Hotels Maphttps://arcg.is/4PjOK1966 New York City Restaurants Maphttps://arcg.is/1zyDTv11930s Manhattan Black Population Percentage Enumeration District Maphttps://arcg.is/1rKSzz1930s Manhattan Black Population Percentage Hot Spot Map (Same as Previous)https://arcg.is/1rKSzz1940 Hotels Point Density Heat Maphttps://arcg.is/jD1Ki1940 Restaurants Point Density Heat Maphttps://arcg.is/1aKbTS1940 Hotels Redlining Maphttps://arcg.is/8b10y1940 Restaurants Redlining Maphttps://arcg.is/9WrXv1950 Hotels Redlining Maphttps://arcg.is/ruGiP1950 Restaurants Redlining Maphttps://arcg.is/0qzfvC01960 Hotels Redlining Maphttps://arcg.is/1KTHLK01960 Restaurants Redlining Maphttps://arcg.is/0jiu9q1966 Hotels Redlining Maphttps://arcg.is/PXKn41966 Restaurants Redlining Maphttps://arcg.is/uCD05_Bibliography:Image Credits (In Order of Appearance)Header/Thumbnail Image:Student Generated Collage (Created Using Pictures from the Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library, https://digitalcollections.nypl.org/collections/the-green-book#/?tab=about.)Mob Violence Image:Kelley, Robert W. “A Mob Rocks an out of State Car Passing.” Life Magazine, www.life.com/history/school-integration-clinton-history, The Green Book Example Image:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library Digital Collections, https://images.nypl.org/index.php?id=5207583&t=w. 1940s Borough of Manhattan Hotels and Restaurants Photographs:“Manhattan 1940s Tax Photos.” NYC Municipal Archives Collections, The New York City Department of Records & Information Services, https://nycma.lunaimaging.com/luna/servlet/NYCMA~5~5?cic=NYCMA~5~5.Figure 1:Student Generated GraphFigure 2:Student Generated GraphFigure 3:Student Generated GraphGIS DataThe Green Book Database:Student Generated (See Above)The Green Book Listings Maps:Student Generated (See Above)The Green Book Point Density Heat Maps:Student Generated (See Above)The Green Book Road Trip Map:Student GeneratedLION New York City Single Line Street Base Map:https://www1.nyc.gov/site/planning/data-maps/open-data/dwn-lion.page 1930s Manhattan Census Data:https://s4.ad.brown.edu/Projects/UTP2/ncities.htm Mapping Inequality Redlining Data:https://dsl.richmond.edu/panorama/redlining/#loc=12/40.794/-74.072&city=manhattan-ny&text=downloads 1940 The Green Book Document:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library. "The Negro Motorist Green-Book: 1940" The New York Public Library Digital Collections, 1940, https://digitalcollections.nypl.org/items/dc858e50-83d3-0132-2266-58d385a7b928. 1950 The Green Book Document:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library. "The Negro Motorist Green-Book: 1950" The New York Public Library Digital Collections, 1950, https://digitalcollections.nypl.org/items/283a7180-87c6-0132-13e6-58d385a7b928. 1960 The Green Book Document:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library. "The Travelers' Green Book: 1960" The New York Public Library Digital Collections, 1960, https://digitalcollections.nypl.org/items/a7bf74e0-9427-0132-17bf-58d385a7b928. 1966 The Green Book Document:Schomburg Center for Research in Black Culture, Manuscripts, Archives and Rare Books Division, The New York Public Library. "Travelers' Green Book: 1966-67 International Edition" The New York Public Library Digital Collections, 1966, https://digitalcollections.nypl.org/items/27516920-8308-0132-5063-58d385a7bbd0. Hyperlink Credits (In Order of Appearance)Referenced Hyperlink #1: Coen, Ross. “Sundown Towns.” Black Past, 23 Aug. 2020, blackpast.org/african-american-history/sundown-towns.Referenced Hyperlink #2: Foster, Mark S. “In the Face of ‘Jim Crow’: Prosperous Blacks and Vacations, Travel and Outdoor Leisure, 1890-1945.” The Journal of Negro History, vol. 84, no. 2, 1999, pp. 130–149., doi:10.2307/2649043. Referenced Hyperlink #3:Driskell, Jay. “An Atlas of Self-Reliance: The Negro Motorist's Green Book (1937-1964).” National Museum of American History, Smithsonian Institution, 30 July 2015, americanhistory.si.edu/blog/negro-motorists-green-book. Referenced Hyperlink #4:Kahn, Eve M. “The 'Green Book' Legacy, a Beacon for Black Travelers.” The New York Times, The New York Times, 6 Aug. 2015, www.nytimes.com/2015/08/07/arts/design/the-green-book-legacy-a-beacon-for-black-travelers.html. Referenced Hyperlink #5:Giorgis, Hannah. “The Documentary Highlighting the Real 'Green Book'.” The Atlantic, Atlantic Media Company, 25 Feb. 2019, www.theatlantic.com/entertainment/archive/2019/02/real-green-book-preserving-stories-of-jim-crow-era-travel/583294/. Referenced Hyperlink #6:Staples, Brent. “Traveling While Black: The Green Book's Black History.” The New York Times, The New York Times, 25 Jan. 2019, www.nytimes.com/2019/01/25/opinion/green-book-black-travel.html. Referenced Hyperlink #7:Pollak, Michael. “How Official Is Official?” The New York Times, The New York Times, 15 Oct. 2010, www.nytimes.com/2010/10/17/nyregion/17fyi.html. Referenced Hyperlink #8:“New Name: Avenue Becomes a Boulevard.” The New York Times, The New York Times, 22 Oct. 1987, www.nytimes.com/1987/10/22/nyregion/new-name-avenue-becomes-a-boulevard.html. Referenced Hyperlink #9:Norris, Frank. “Racial Dynamism in Los Angeles, 1900–1964.” Southern California Quarterly, vol. 99, no. 3, 2017, pp. 251–289., doi:10.1525/scq.2017.99.3.251. Referenced Hyperlink #10:Shertzer, Allison, et al. Urban Transition Historical GIS Project, 2016, https://s4.ad.brown.edu/Projects/UTP2/ncities.htm. Referenced Hyperlink #11:Mitchell, Bruce. “HOLC ‘Redlining’ Maps: The Persistent Structure Of Segregation And Economic Inequality.” National Community Reinvestment Coalition, 20 Mar. 2018,

Includes the error tables, ESRI ArcMap document, accompanying ESRI Geodatabase, ESRI Toolkit and the Python scripts/codes used in the analysis. The error tables are by Census Block for each tested method as well as the calculated grouped error statistics.Our study area focuses on New York City, which provides a data-rich urban environment with extreme variations in local population density and diverse types of input data in which to construct multiple methods. In this study area we can then compare the efficacy of multiple methodologies, which employ a strong binary mask paired with a density variable directly derived from the binary mask. We test the following methodologies:1. Land areas binary mask2. Building footprint binary mask3. Building footprint binary mask and area density variable4. Building footprints binary mask and volume density variable5. Residential building footprint binary mask6. Residential building footprint binary mask and area density variable7. Residential building footprint binary mask and volume density variable

A dataset listing New York cities by population for 2024.

This map answers the question "What is the most common, or predominant, education level for people in this area?" The map shows predominant educational attainment in each census tract. Darker colors indicate a greater gap between the predominant group and the next largest group.The U.S. Census Bureau asks citizens to indicate how far they went in formal education. The database includes seven different columns, each representing a count of population by that education level. A simple routine in compares the seven columns of information, and finds which one has the highest value, writing that to a string field. Each tract's transparency is set by a transparency field added to the data.Predominance maps can be created in ArcGIS Online by adding two fields, calculating their values, and setting up the renderer based on those two fields. See this blog by Jim Herries for details on how to create a predominance map in ArcGIS Online from any feature layer.See this GitHub repo by Jennifer Bell for a script you can run in ArcMap as a script tool, to calculate predominance for any columns of data you have.

A dataset listing New York counties by population for 2024.

Note: These layers were compiled by Esri's Demographics Team using data from the Census Bureau's American Community Survey. These data sets are not owned by the City of Rochester.Overview of the map/data: This map shows the percentage of the population living below the federal poverty level over the previous 12 months, shown by tract, county, and state boundaries. Estimates are from the 2018 ACS 5-year samples. This service is updated annually to contain the most currently released American Community Survey (ACS) 5-year data, and contains estimates and margins of error. There are also additional calculated attributes related to this topic, which can be mapped or used within analysis. Current Vintage: 2019-2023ACS Table(s): B17020, C17002Data downloaded from: Census Bureau's API for American Community Survey Date of API call: December 12, 2024National Figures: data.census.govThe United States Census Bureau's American Community Survey (ACS):About the SurveyGeography & ACSTechnical DocumentationNews & UpdatesThis ready-to-use layer can be used within ArcGIS Pro, ArcGIS Online, its configurable apps, dashboards, Story Maps, custom apps, and mobile apps. Data can also be exported for offline workflows. Please cite the Census and ACS when using this data.Data Note from the Census:Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of error. The value shown here is the 90 percent margin of error. The margin of error can be interpreted as providing a 90 percent probability that the interval defined by the estimate minus the margin of error and the estimate plus the margin of error (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling error (for a discussion of nonsampling variability, see Accuracy of the Data). The effect of nonsampling error is not represented in these tables.Data Processing Notes:This layer will be updated automatically when the most current vintage of ACS data is released each year, usually in December. The layer always contains the latest available ACS 5-year estimates. It is updated annually within days of the Census Bureau's release schedule. Click here to learn more about ACS data releases.Boundaries come from the US Census TIGER geodatabases. Boundaries are updated at the same time as the data updates (annually), and the boundary vintage appropriately matches the data vintage as specified by the Census. These are Census boundaries with water and/or coastlines clipped for cartographic purposes. For census tracts, the water cutouts are derived from a subset of the 2010 AWATER (Area Water) boundaries offered by TIGER. For state and county boundaries, the water and coastlines are derived from the coastlines of the 500k TIGER Cartographic Boundary Shapefiles. The original AWATER and ALAND fields are still available as attributes within the data table (units are square meters). The States layer contains 52 records - all US states, Washington D.C., and Puerto Rico.Census tracts with no population are removed from this data service (Census Tracts beginning with 99).Percentages and derived counts, and associated margins of error, are calculated values (that can be identified by the "_calc_" stub in the field name), and abide by the specifications defined by the American Community Survey.Field alias names were created based on the Table Shells file available from the American Community Survey Summary File Documentation page.Negative values (e.g., -555555...) have been set to null. These negative values exist in the raw API data to indicate the following situations:The margin of error column indicates that either no sample observations or too few sample observations were available to compute a standard error and thus the margin of error. A statistical test is not appropriate.Either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution.The median falls in the lowest interval of an open-ended distribution, or in the upper interval of an open-ended distribution. A statistical test is not appropriate.The estimate is controlled. A statistical test for sampling variability is not appropriate.The data for this geographic area cannot be displayed because the number of sample cases is too small. NOTE: any calculated percentages or counts that contain estimates that have null margins of error yield null margins of error for the calculated fields.

The City Council District boundaries for New York City clipped to the shoreline. The City Council redistricting process takes place every ten years to reflect population changes reported in the US Census by the New York City Council Redistricting Commission. These district boundaries represent the redistricting as of the US Census 2010.

Many residents of New York City speak more than one language; a number of them speak and understand non-English languages more fluently than English. This dataset, derived from the Census Bureau's American Community Survey (ACS), includes information on over 1.7 million limited English proficient (LEP) residents and a subset of that population called limited English proficient citizens of voting age (CVALEP) at the Community District level. There are 59 community districts throughout NYC, with each district being represented by a Community Board.

The 2020 NYC Public Use Microdata Areas (PUMAs) are statistical geographic areas defined for the dissemination of 2020 Public Use Microdata Sample (PUMS) data. PUMAs have a minimum population of 100,000, are aggregated from census tracts, and approximate Community Districts (CDs), or combinations of CDs (There are 59 CDs and only 55 NYC PUMAs because of such combinations). These boundary files are derived from the US Census Bureau's TIGER project and have been geographically modified to fit the New York City base map.

Listing of all Senior Centers, Abuse Prevention Contracts, Home Care Contracts, Legal Services Contracts, NORC Contracts, Transportation Contracts, Case Mangement Contracts, Home Delivered Meal Contracts and Caregiver Contracts in all five boroughs.

The Department for the Aging (DFTA) provides a wide array of services specific to the elderly population of New York City. To accomplish this, the department contracts out to organizations (mainly non-profit) to provide these services throughout the five boroughs. The majority of the services provided are through our Neighborhood Senior Centers which provide free meals (mostly lunch, some breakfast and dinner meals) that meet nutritional standards defined by the FDA. DFTA provides this data of our contracted agencies sorted by the contract servivce type. The dataset contains the relevant information for the public to contact the agencies providing the services they may be seeking. The data is limited in that the contract service type does not provide the full scope of services that are provided in detail.

This dataset contains information on antibody testing for COVID-19: the number of people who received a test, the number of people with positive results, the percentage of people tested who tested positive, and the rate of testing per 100,000 people, stratified by modified ZIP Code Tabulation Area (ZCTA) of residence. Modified ZCTA reflects the first non-missing address within NYC for each person reported with an antibody test result. This unit of geography is similar to ZIP codes but combines census blocks with smaller populations to allow more stable estimates of population size for rate calculation. It can be challenging to map data that are reported by ZIP Code. A ZIP Code doesn’t refer to an area, but rather a collection of points that make up a mail delivery route. Furthermore, there are some buildings that have their own ZIP Code, and some non-residential areas with ZIP Codes. To deal with the challenges of ZIP Codes, the Health Department uses ZCTAs which solidify ZIP codes into units of area. Often, data reported by ZIP code are actually mapped by ZCTA. The ZCTA geography was developed by the U.S. Census Bureau. These data can also be accessed here: https://github.com/nychealth/coronavirus-data/blob/master/totals/antibody-by-modzcta.csv Exposure to COVID-19 can be detected by measuring antibodies to the disease in a person’s blood, which can indicate that a person may have had an immune response to the virus. Antibodies are proteins produced by the body’s immune system that can be found in the blood. People can test positive for antibodies after they have been exposed, sometimes when they no longer test positive for the virus itself. It is important to note that the science around COVID-19 antibody tests is evolving rapidly and there is still much uncertainty about what individual antibody test results mean for a single person and what population-level antibody test results mean for understanding the epidemiology of COVID-19 at a population level. These data only provide information on people tested. People receiving an antibody test do not reflect all people in New York City; therefore, these data may not reflect antibody prevalence among all New Yorkers. Increasing instances of screening programs further impact the generalizability of these data, as screening programs influence who and how many people are tested over time. Examples of screening programs in NYC include: employers screening their workers (e.g., hospitals), and long-term care facilities screening their residents. In addition, there may be potential biases toward people receiving an antibody test who have a positive result because people who were previously ill are preferentially seeking testing, in addition to the testing of persons with higher exposure (e.g., health care workers, first responders) Rates were calculated using interpolated intercensal population estimates updated in 2019. These rates differ from previously reported rates based on the 2000 Census or previous versions of population estimates. The Health Department produced these population estimates based on estimates from the U.S. Census Bureau and NYC Department of City Planning. Antibody tests are categorized based on the date of specimen collection and are aggregated by full weeks starting each Sunday and ending on Saturday. For example, a person whose blood was collected for antibody testing on Wednesday, May 6 would be categorized as tested during the week ending May 9. A person tested twice in one week would only be counted once in that week. This dataset includes testing data beginning April 5, 2020. Data are updated daily, and the dataset preserves historical records and source data changes, so each extract date reflects the current copy of the data as of that date. For example, an extract date of 11/04/2020 and extract date of 11/03/2020 will both contain all records as they were as of that extract date. Without filtering or grouping by extract date, an analysis wi

Usage notes

The Gridded Population of the World, Version 4 (GPWv4): Population Density, Revision 11 consists of estimates of human population density (number of persons per square kilometer) based on counts consistent with national censuses and population registers. A proportional allocation gridding algorithm, utilizing approximately 13.5 million national and sub-national administrative units, was used to assign population counts to 30 arc-second grid cells. The population density rasters were created by dividing the population count raster for a given target year by the land area raster. The data files were produced as global rasters at 30 arc-second (~1 km at the equator) resolution. To enable faster global processing, and in support of research communities, the 30 arc-second count data were aggregated to 2.5 arc-minute, 15 arc-minute, 30 arc-minute and 1-degree resolutions to produce density rasters at these resolutions.Source: Center for International Earth Science Information Network - CIESIN - Columbia University. 2018. Gridded Population of the World, Version 4 (GPWv4): Population Density, Revision 11. Palisades, New York: NASA Socioeconomic Data and Applications Center (SEDAC). Available at https://doi.org/10.7927/H49C6VHW. (October 2022)Files Download

The New York Times is releasing a series of data files with cumulative counts of coronavirus cases in the United States, at the state and county level, over time. We are compiling this time series data from state and local governments and health departments in an attempt to provide a complete record of the ongoing outbreak.

Since late January, The Times has tracked cases of coronavirus in real time as they were identified after testing. Because of the widespread shortage of testing, however, the data is necessarily limited in the picture it presents of the outbreak.

We have used this data to power our maps and reporting tracking the outbreak, and it is now being made available to the public in response to requests from researchers, scientists and government officials who would like access to the data to better understand the outbreak.

The data begins with the first reported coronavirus case in Washington State on Jan. 21, 2020. We will publish regular updates to the data in this repository.

This ArcGIS Map Package contains information on brook trout occupancy in the southern portion of the brook trout range (PA and south). Fish sample data from a number of state and federal agencies/organizations were used to define patches for brook trout as groups of occupied contiguous catchment polygons from the National Hydrography Dataset Plus Version 1 (NHDPlusV1) catchment GIS layer. After defining patches, NHDPlusV1 catchments were assigned occupancy codes. Then state and federal agencies reviewed patches and codes to verify data accuracy. A similar effort is currently being conducted by the Eastern Brook Trout Joint Venture to develop occupancy data for the remainder of the brook trout range including states of New York, Maine, New Hampshire, Connecticut, Vermont, Massachusetts, Rhode Island, and Ohio. This ArcGIS Map Package contains data for the entire southern portion of the brook trout range with preset symbology that displays brook trout occupancy. The Map Package also includes the same information clipped into seperate layers for each state. State information is provided for the convenience of users that are interested in data for only a particular state. Additional layers displaying state boundaries, quadrangle maps, and the brook trout range are also included as spatial references.

The National Flood Hazard Layer (NFHL) is a geospatial database that contains current effective flood hazard data. FEMA provides the flood hazard data to support the National Flood Insurance Program. You can use the information to better understand your level of flood risk and type of flooding.The NFHL is made from effective flood maps and Letters of Map Change (LOMC) delivered to communities. NFHL digital data covers over 90 percent of the U.S. population. New and revised data is being added continuously. If you need information for areas not covered by the NFHL data, there may be other FEMA products which provide coverage for those areas.In the NFHL Viewer, you can use the address search or map navigation to locate an area of interest and the NFHL Print Tool to download and print a full Flood Insurance Rate Map (FIRM) or FIRMette (a smaller, printable version of a FIRM) where modernized data exists. Technical GIS users can also utilize a series of dedicated GIS web services that allow the NFHL database to be incorporated into websites and GIS applications. For more information on available services, go to the NFHL GIS Services User Guide.You can also use the address search on the FEMA Flood Map Service Center (MSC) to view the NFHL data or download a FIRMette. Using the “Search All Products” on the MSC, you can download the NFHL data for a County or State in a GIS file format. This data can be used in most GIS applications to perform spatial analyses and for integration into custom maps and reports. To do so, you will need GIS or mapping software that can read data in shapefile format.FEMA also offers a download of a KMZ (keyhole markup file zipped) file, which overlays the data in Google Earth™. For more information on using the data in Google Earth™, please see Using the National Flood Hazard Layer Web Map Service (WMS) in Google Earth™.

Updates

• Notice of data discontinuation: Since the start of the pandemic, AP has reported case and death counts from data provided by Johns Hopkins University. Johns Hopkins University has announced that they will stop their daily data collection efforts after March 10. As Johns Hopkins stops providing data, the AP will also stop collecting daily numbers for COVID cases and deaths. The HHS and CDC now collect and visualize key metrics for the pandemic. AP advises using those resources when reporting on the pandemic going forward.

  • CDC Weekly case and death counts (national and state level)
  • CDC County level cases and deaths
  • HHS New hospital admissions
  • CDC NowCast COVID variant proportions (national and regional level)

• April 9, 2020

  • The population estimate data for New York County, NY has been updated to include all five New York City counties (Kings County, Queens County, Bronx County, Richmond County and New York County). This has been done to match the Johns Hopkins COVID-19 data, which aggregates counts for the five New York City counties to New York County.

• April 20, 2020

  • Johns Hopkins death totals in the US now include confirmed and probable deaths in accordance with CDC guidelines as of April 14. One significant result of this change was an increase of more than 3,700 deaths in the New York City count. This change will likely result in increases for death counts elsewhere as well. The AP does not alter the Johns Hopkins source data, so probable deaths are included in this dataset as well.

• April 29, 2020

  • The AP is now providing timeseries data for counts of COVID-19 cases and deaths. The raw counts are provided here unaltered, along with a population column with Census ACS-5 estimates and calculated daily case and death rates per 100,000 people. Please read the updated caveats section for more information.

• September 1st, 2020

  • Johns Hopkins is now providing counts for the five New York City counties individually.

• February 12, 2021

  • The Ohio Department of Health recently announced that as many as 4,000 COVID-19 deaths may have been underreported through the state’s reporting system, and that the "daily reported death counts will be high for a two to three-day period."
  • Because deaths data will be anomalous for consecutive days, we have chosen to freeze Ohio's rolling average for daily deaths at the last valid measure until Johns Hopkins is able to back-distribute the data. The raw daily death counts, as reported by Johns Hopkins and including the backlogged death data, will still be present in the new_deaths column.

• February 16, 2021

  - Johns Hopkins has reconciled Ohio's historical deaths data with the state.

  Overview

The AP is using data collected by the Johns Hopkins University Center for Systems Science and Engineering as our source for outbreak caseloads and death counts for the United States and globally.

The Hopkins data is available at the county level in the United States. The AP has paired this data with population figures and county rural/urban designations, and has calculated caseload and death rates per 100,000 people. Be aware that caseloads may reflect the availability of tests -- and the ability to turn around test results quickly -- rather than actual disease spread or true infection rates.

This data is from the Hopkins dashboard that is updated regularly throughout the day. Like all organizations dealing with data, Hopkins is constantly refining and cleaning up their feed, so there may be brief moments where data does not appear correctly. At this link, you’ll find the Hopkins daily data reports, and a clean version of their feed.

The AP is updating this dataset hourly at 45 minutes past the hour.

To learn more about AP's data journalism capabilities for publishers, corporations and financial institutions, go here or email kromano@ap.org.

Queries

Use AP's queries to filter the data or to join to other datasets we've made available to help cover the coronavirus pandemic

• Filter cases by state here

• Rank states by their status as current hotspots. Calculates the 7-day rolling average of new cases per capita in each state: https://data.world/associatedpress/johns-hopkins-coronavirus-case-tracker/workspace/query?queryid=481e82a4-1b2f-41c2-9ea1-d91aa4b3b1ac

• Find recent hotspots within your state by running a query to calculate the 7-day rolling average of new cases by capita in each county: https://data.world/associatedpress/johns-hopkins-coronavirus-case-tracker/workspace/query?queryid=b566f1db-3231-40fe-8099-311909b7b687&showTemplatePreview=true

• Join county-level case data to an earlier dataset released by AP on local hospital capacity here. To find out more about the hospital capacity dataset, see the full details.

• Pull the 100 counties with the highest per-capita confirmed cases here

• Rank all the counties by the highest per-capita rate of new cases in the past 7 days here. Be aware that because this ranks per-capita caseloads, very small counties may rise to the very top, so take into account raw caseload figures as well.

Interactive

The AP has designed an interactive map to track COVID-19 cases reported by Johns Hopkins.

@(https://datawrapper.dwcdn.net/nRyaf/15/)

Interactive Embed Code

<iframe title="USA counties (2018) choropleth map Mapping COVID-19 cases by county" aria-describedby="" id="datawrapper-chart-nRyaf" src="https://datawrapper.dwcdn.net/nRyaf/10/" scrolling="no" frameborder="0" style="width: 0; min-width: 100% !important;" height="400"></iframe><script type="text/javascript">(function() {'use strict';window.addEventListener('message', function(event) {if (typeof event.data['datawrapper-height'] !== 'undefined') {for (var chartId in event.data['datawrapper-height']) {var iframe = document.getElementById('datawrapper-chart-' + chartId) || document.querySelector("iframe[src*='" + chartId + "']");if (!iframe) {continue;}iframe.style.height = event.data['datawrapper-height'][chartId] + 'px';}}});})();</script>

Caveats

• This data represents the number of cases and deaths reported by each state and has been collected by Johns Hopkins from a number of sources cited on their website.
• In some cases, deaths or cases of people who've crossed state lines -- either to receive treatment or because they became sick and couldn't return home while traveling -- are reported in a state they aren't currently in, because of state reporting rules.
• In some states, there are a number of cases not assigned to a specific county -- for those cases, the county name is "unassigned to a single county"
• This data should be credited to Johns Hopkins University's COVID-19 tracking project. The AP is simply making it available here for ease of use for reporters and members.
• Caseloads may reflect the availability of tests -- and the ability to turn around test results quickly -- rather than actual disease spread or true infection rates.
• Population estimates at the county level are drawn from 2014-18 5-year estimates from the American Community Survey.
• The Urban/Rural classification scheme is from the Center for Disease Control and Preventions's National Center for Health Statistics. It puts each county into one of six categories -- from Large Central Metro to Non-Core -- according to population and other characteristics. More details about the classifications can be found here.

Johns Hopkins timeseries data - Johns Hopkins pulls data regularly to update their dashboard. Once a day, around 8pm EDT, Johns Hopkins adds the counts for all areas they cover to the timeseries file. These counts are snapshots of the latest cumulative counts provided by the source on that day. This can lead to inconsistencies if a source updates their historical data for accuracy, either increasing or decreasing the latest cumulative count. - Johns Hopkins periodically edits their historical timeseries data for accuracy. They provide a file documenting all errors in their timeseries files that they have identified and fixed here

Attribution

This data should be credited to Johns Hopkins University COVID-19 tracking project

New York City’s comprehensive effort to reduce or eliminate potential losses from the hazards described in the Hazard Specific section of the website. The map includes existing and completed mitigation actions that will minimize the effects of a hazard event on New York City’s population, economy, property, building stock, and infrastructure. It is the result of a coordinated effort by 46 New York City agencies and partners to develop and implement a broad range of inventive and effective ways to mitigate hazards. Point, line, polygon features and a table for the Mitigation Actions map on the Hazard Mitigation website: www.nychazardmitigation.com/all-hazards/mitigation/actions-map/ This table contains more information on each project: https://data.cityofnewyork.us/City-Government/Hazard-Mitigation-Plan-Mitigation-Actions-Database/veqt-eu3t

A dataset showing the population of 10467 between 2010 and 2020.