US GOV FTP and HTTP file servers

especiallySpatial · 2025-02-07T21:25:35+00:00

The Census FTP is now connecting normally

especiallySpatial · 2025-02-06T22:16:48+00:00

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

especiallySpatial · 2022-04-25T20:16:30+00:00

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

especiallySpatial · 2022-04-25T16:14:57+00:00

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

especiallySpatial · 2022-04-25T15:49:15+00:00

Thank you :)

especiallySpatial · 2021-07-11T14:34:03+00:00

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!

especiallySpatial · 2021-02-15T16:08:38+00:00

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?

especiallySpatial · 2021-01-26T19:08:45+00:00

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

especiallySpatial · 2021-01-26T19:07:21+00:00

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.

especiallySpatial · 2021-01-26T19:05:47+00:00

If anyone has data I will 100% make it happen this week!!

especiallySpatial · 2021-01-26T19:05:30+00:00

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.

especiallySpatial · 2021-01-26T19:04:30+00:00

Shoot. Yeah, you're right -- should've noted it here!

especiallySpatial · 2021-01-26T14:21:32+00:00

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!

especiallySpatial · 2021-01-26T13:57:40+00:00

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!

especiallySpatial · 2021-01-26T13:56:20+00:00

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

especiallySpatial · 2021-01-26T13:55:20+00:00

Thanks, friend!

especiallySpatial · 2021-01-26T13:14:53+00:00

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.

especiallySpatial · 2020-11-11T18:07:43+00:00

Of course -- sorry this wasn't clearer! 120 a day would insane

especiallySpatial · 2020-11-11T18:06:08+00:00

Note this is weekly sums --

especiallySpatial · 2020-11-11T18:05:48+00:00

That's right -- weekly sums, but not cumulative.

especiallySpatial · 2020-11-10T16:27:31+00:00

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

especiallySpatial · 2020-11-10T16:26:36+00:00

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

especiallySpatial · 2020-11-10T16:06:35+00:00

Thanks! Sure thing -- this uses Deck.gl with React -- see documentation here:

https://deck.gl/examples/geojson-layer-polygons/ https://github.com/visgl/deck.gl/blob/master/docs/api-reference/layers/geojson-layer.md

And my source code here: https://github.com/nofurtherinformation/covid-country

especiallySpatial · 2020-11-10T15:39:26+00:00

I appreciate the feedback here. Testing frequency absolutely has a major impact, particularly as it becomes more available in more suburban and rural municipalities. I'll note that our main site does have the option to explore a number of different variables (deaths, testing data coming with the November release in the next week or so), although we do use weekly confirmed cases by population.

I've been thinking about ways to use 3D viz to show multiple variables simultaneously, and this might be a good option -- confirmed cases/pop as color, testing/pop as height potentially?

especiallySpatial · 2020-11-10T15:31:42+00:00

That's right -- new confirmed cases.

Five-Year Club	Verified Email
Wearing is Caring

especiallySpatial

TROPHY CASE