Happy World Kidney (Awareness) Day. This day is meant to commemorate survivors of, and raise awareness about, kidney and renal disease.
I decided to try and make a more detailed visualization for this map. It works on desktop best — perhaps mobile not at all. The side bar histogram is too small, but the goal of this project is to make half-decent maps fast. So I left it for now. This was a one-prompt output with two excel files. I’m pretty happy with the results. Perhaps I’ll come back to it in the future.

View the map here
LLM Tool Used: Web Mapper GPT
Here is the prompt that created this
# Purpose
I am creating a map for World Kidney Day. I would like it to be informative and more exploratory, health-oriented than many that I’ve made previously. I would like the legends to act as interactive filters by default. The dataset will be larger than normal, all US counties. I would like to use a generalized geometry of US counties to minimize load times, etc.
# Dataset
I have an Excel dataset in the US showing National Institute of Health (NIH) statistics by county for the following types of kidney treatment and disease (all combined into a single value per field, but just provided for context): Hemodialysis, Peritoneal Dialysis, Unknown Dialysis Type, Transplant Primary Cause of ESRD: Diabetes, Hypertension, Glomerulonephritis, Cystic Kidney, Other Urologic.
The dataset contains the following fields:
– State Name
– County Name
– FIPS Code
– Admission (Per PY)
– Hospitalized Days Rate (Per PY)
– Admission Count
– Hospitalization Days (Count)
Nulls = suppressed due to inadequate sample size
—
# Map type and layout
The map shape itself will not change once loaded on desktop. It should be an equal area projection of the contiguous United States, with Alaska and Hawaii in the lower left and Puerto Rico represented in the Gulf of Mexico.
There will be four different maps presented — **never** concurrently — within the same map area. Which map is shown at a particular time will be determined via user interactivity with a legend component (see next section). The first default map will be State Admission Rate (per Patient Year).
– State Dataset: Admission Rate (per Patient Year)
– State Dataset: Hospitalization Days (per Patient Year)
– County Dataset: Admissions (per Patient Year)
– County Dataset: Hospitalization Days (per Patient Year)
Each of the maps should be designed to show a diverging color scheme that is purple and green (Color Brewer based). Determine the mean value for each of the four numeric fields in the dataset. Then create a standard deviation classification scheme. The middle color should be white. States should have very light gray, thin outlines. Purple equals higher patients, hospitalizations, etc. Green should be below the average. White average. Have at least five classes. You will only map rates — Admission Rates per patient per year) and Hospitalized Day Rates (per patient per year), not the count fields.
—
# Interactive Legend and Exploration
There will be four different maps that can be shown. The user may change between maps by choosing which she prefers using a drop box within a panel taking up 90% of the vertical height of the window on the right side of the map. The panel should slide open and shut from the right edge of the window pane.
Create a horizontal leftward pointing arrow icon right aligned with the right-edge of the window that the user can easily click on or tap (make the select area larger than the arrow itself so it is not difficult to press) to slide the panel open. When open, the panel should be closable with a horizontal arrow facing rightward that they click on to slide the panel shut. The interactivity should be designed to allow the user to open and close the panel at will. However, the panel will **always** start open when the map is loaded on a desktop or laptop machine.
Near the top of the panel, which should be titled “Data Explorer Panel,” there should be a drop-down selector showing the four different options for different visualizations (discussed in the map section above). The default should already be showing in the drop down.
When the user selects a new visualization/map option in the drop down, the map should update to show the appropriate visualization. If it takes a while to load and visualize any of the visualizations, please put a spinner over the middle of the map a little message that says: loading the new data now. Thanks for your patience. If possible, cache previously loaded visualizations locally. (No worries if this isn’t possible.)
## Interactive Vertical Histogram
On desktop, inside the panel but beneath the map selection drop down, the right-hand side of the map should have an interactive vertical histogram (highest rates on top, lower on bottom) that allows users to group select subsets of counties in smaller ranges. Each county should be represented as a dot, stacked when applicable in ranges. The histogram bar should be on the left and the dots on the right of the bar. The histogram should have tick marks on the right-side of the vertical histogram line denoting value breakdowns (e.g., every 0.2 or so rate change a mark) and then the counties that fall within that range stacked (or lined up because it will be horizontal) as dots.
The county dot colors should match their color on the map. For white counties (counties near the average), the circles should have light gray outlines so they are visible).
Each horizontal area between tick marks on the vertical histogram will be multi-selectable. Users may Cmd/Ctrl click multiple select these ranges and these counties (or states if a state map is being shown) will light up on the map across the US. The other states will still be shown, but make 50% transparent. All states are shown again as soon as the selection changes or if the user clicks anywhere outside of the panel or off the map in the window. Near the top of the vertical histogram, please add a “Refresh” button.
The histogram will also act as a legend. Please highlight the range of each classification on the histogram vertical line itself by coloring the line appropriately where its values are. When the user hovers just a tad to the left of the vertical histogram, have a pop up show up with a background color matching that used to map its features and either white or black font highlighting the range of values.
The histogram must update for each map. When the user switches map views, the histogram must update to show that data in the histogram. Selections must work on the appropriate matching map as well, of course.
## Map Navigation Interactivity
The map area itself will not change. Users may zoom in and pan in a limited fashion (up to 4x zoom in D3), but they are never allowed to zoom or pan outside of the original Canvas extent. In the lower left-hand corner, please put a little “House” icon that when clicked zooms to the original default, entire US, Alaska, Hawaii, and Puerto Rico view.
## Desktop Sources Modal
The sources modal should be shown when the user clicks a small, subtle, stylish information button to the right of the title at the top of the map in desktop. Location of mobile sources modal button is discussed below.
The modal MUST not be open when the map loads.
—
# Desktop versus Mobile Layout
I’m envisioning that this map will work best on Desktop but it should function in a limited capacity on mobile. First, make sure the user turns their phone to landscape mode. If in portrait mode, show the title of the map. Provide a brief message saying the map is best viewed on a PC as it is meant to function as an exploratory tool. However, a limited version is viewable on mobile **but** the user must rotate their phone.
Once the phone is in landscape mode, center the US Map so it fills the whole screen. No need for a title or anything. Show statewide data, and Puerto Rico, of rates. The info window should present all the data concerning State Name, Rates, and Counts. Use the same State Admission Rates Per Patient Per Year map/visualization used on desktop. In an inconspicuous place, please add a button that allows the user to view Sources.
—
# Sources Modal
In both versions (mobile and desktop) the same sources modal can be used. It MUST start closed/invisible. It should only show up when interactivity calls for it. It MUST close whenever the user clicks outside of it. (On mobile, it must leave a little window space so the user can click outside of it.)
Content in the Sources Model should include:
– Data source: https://www.niddk.nih.gov/about-niddk/strategic-plans-reports/usrds/data-query-tools/esrd-hospitalization-rate
– 2023 county- and state-level data conglomerated and cleaned by <a href=”https://linkedin.com/in/ianmule”>Ian Muehlenhaus</a>.
– Download links to the XLSX datasets uploaded here.
– Subtly and more clearly than I did above, mention what the values represent and mean in plain English.
– Map tools: {Any mapping APIs used}
– Prompt cartographer: Ian Muehlenhaus
– Provenance file:
Created for the #365DaysOfMaps and #promptcartography campaign created for the <a href=”https://mapdesign.icaci.org/”>Commission on Map Design</a> of the International Cartographic Association. Sign up today to receive a map like this — though sometimes more uplifting — every day!
No rights reserved. 😉
Data year: 2023
—
# Title, Style, and Map Element Aesthetic
## Title
The title be in a formal but modern Google font display type across the top. Prominent but not obnoxious. Single Line. No background box. Add a slight black drop shadow so it remains readable even if it is over parts of the map after zooming and panning, etc. If the user hovers over the title, a little tool tip can show up “Designed to raise awareness about kidney diseases on World Kidney Day (March 12, 2026). More info available by clicking the info icon.”
Title: “The Geography of Kidney Disease across the US”
—
## Info Window
The background of the Info Window should be white but the window should have a 1.5px border in the color of the county or state on that particular map. The font color in the info window should be the same purple or green as the color of the county or state on that particular map.
Info window should show:
– State Name bold.
– Admission Rate
– Hospitalization Rate
– Admission Count
– Hospitalization Count
Subtly add in lighter gray text “All statistics per patient in 2013.”
—
## Style
### Fonts
Use Google fonts that exude modernity and clinical precision. Science! Title should use a Scientific and empathetic sans-serif Google Font.
All fonts must be sans-serif.
### Map Elements
Map elements should have 4px rounded corners. The background of the map should be sanitary white. Clear crisp design signaling medical modernity.
The panel and histogram and dropdowns, etc., should all be designed as ultra contemporary data exploration and visualization tools that you might see in the New York Times, Washington Post, or from Alberto Cairo.
Minimalism goes a long way here, as the data is already dense.
—
Before you begin, please let me know if you have any questions. One other note, I don’t have geometry files for these datasets. I would like these to be joined to state and county geometries, respectively, if possible. I believe this will work well in D3, but if you think there is another way that is better, please let me know.
Thank you!