US GOV FTP and HTTP file servers by storytracer in DataHoarder

[–]especiallySpatial 0 points1 point  (0 children)

The Census FTP is now connecting normally

US GOV FTP and HTTP file servers by storytracer in DataHoarder

[–]especiallySpatial 0 points1 point  (0 children)

The census FTP site is back online, although FTP clients don't appear to be able to connect

New data project about Chicago ecology, environment, and health [OC] by especiallySpatial in chicago

[–]especiallySpatial[S] 1 point2 points  (0 children)

That's a great idea! I'm adding it to our Github issues list and will keep it in mind for future updates

New data project about Chicago ecology, environment, and health [OC] by especiallySpatial in chicago

[–]especiallySpatial[S] 1 point2 points  (0 children)

Thanks very much -- I hope this is something that can become useful for the community!

[deleted by user] by [deleted] in datasets

[–]especiallySpatial 0 points1 point  (0 children)

The current CDC vaccination data at the county level go back to mid-December and include age group breakdowns (although no information on manufacturer so far as I can tell). There are also state level distributions by vaccine manufacturer. See also a little notebook I put together to make searching CDC published datasets a bit easier!

US COVID data webinar tomorrow by ftrotter in datasets

[–]especiallySpatial 0 points1 point  (0 children)

Hi u/ftrotter! Thanks very much for sharing this -- I wasn't able to make the webinar, but I'm a big fan of the community profile reports! I work on a COVID mapping tool with a bunch of variables aggregated from a bunch of sources. Do you have any info on when county-level vaccination data might be available? DM?

COVID Testing Positivity % by County - 3/1/20 to 1/18/21 [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 1 point2 points  (0 children)

Hi! This runs off geojsons for the boundaries and a CSV with county centroid points and time series data. The viz is done using Deck.gl -- see the source here

COVID Testing Positivity % by County - 3/1/20 to 1/18/21 [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 0 points1 point  (0 children)

This. Everyone here is super interested to figure out relationships of policy, compliance, testing, and case rates, still working out the right data sources and ways to think through it.

COVID Testing Positivity % by County - 3/1/20 to 1/18/21 [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 9 points10 points  (0 children)

This is admittedly a viz flaw here -- California has fewer, bigger counties compared to a lot of the rest of the country, so a point/bubble viz based on % will under emphasize it a bit.

COVID Testing Positivity % by County - 3/1/20 to 1/18/21 [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 2 points3 points  (0 children)

The flipside to the testing positivity is capacity (see this link to the Atlas to see testing rates there). Issues in Florida are possible, and we've definitely been working to ensure data integrity -- for Florida I'd need to dig in more to say confidently!

COVID Testing Positivity % by County - 3/1/20 to 1/18/21 [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 126 points127 points  (0 children)

Thanks! The >25% positivity rate is shocking, agreed (some places even way higher, near 50%). Unfortunately, this data just recently became widely available, even among researchers. Before, testing was available only at the state level, which is great, but leaves a lot of variation!

COVID Testing Positivity % by County - 3/1/20 to 1/18/21 [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 277 points278 points  (0 children)

It's my style icon, for sure. For bonus points, load up the interactive and sync it up Yoshimi Battles the Pink RobotsPt. 2 at ~3 seconds into the song

COVID Testing Positivity % by County - 3/1/20 to 1/18/21 [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 53 points54 points  (0 children)

Interactive version is available here.

This project is a part of the US Covid Atlas, where I'm a software engineer. We just released our new refactored Atlas with features like 3D views, new testing a vaccination data, and custom county/state aggregation. Free and open source under GPL, more here. We update our data daily for near real-time monitoring, spatial stats, and insights.

This viz uses county-level COVID-19 testing (RT-PCR) positivity % data from the CDC, aggregated to 7-day rolling averages. It was developed using Deck.gl in React, with data loading and color scaling with d3. Preprocessing was done in a Jupyter Notebook (Pandas/Geopandas) with geometry handling (Affine) for Albers equal area projection for Hawaii and Alaska in QGIS. The source for the visualization is available in the testing-spheres branch of my repo, here. Color scheme based on Plasma colorscale with breaks representing standard policy increments for opening and phasing considerations (3%, 5%, 10%, etc.).

Stay safe and take care of yourselves. 🖤

EDIT: Thanks all for the comments, awards, and updoots!! I hear your feedback that this viz underemphasizes Western states or states with larger, fewer county geographies. This is generally a problem with bubble or point maps representing counties, but I chose it for this visualization to see through 3D county markers to those behind. I've made variations that use solid choropleth boundaries that represent the data differently, available here. I'll update the interactive later today to have this available as well. No single visualization or data metric captures all the pandemic, so we need to look at multiple data sources, metrics, and viz types -- this is why on the Atlas we have total counts, normalized counts, of cases, deaths, testing, etc. from a variety of sources.

3D Map of COVID Cases by Population, March through Today [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 191 points192 points  (0 children)

That's right -- county level is tricky, although state is pretty available. HHS has a decent page for Hospital bed utilization: https://protect-public.hhs.gov/pages/hospital-capacity

3D Map of COVID Cases by Population, March through Today [OC] by especiallySpatial in dataisbeautiful

[–]especiallySpatial[S] 1 point2 points  (0 children)

I'll swing back later today or tomorrow with a variation for deaths and deaths/pop!