Public-Environmental-Data-Partners/EJAM

FIPS missing/problems (mostly in Connecticut)

Open

#19 opened on Aug 2, 2025

View on GitHub
 (5 comments) (0 reactions) (1 assignee)R (1 fork)auto 404
BUGPRIORITY MEDIUMdatasets-relatedhelp wantedmaps-relatedrank:B-high-value-high-cost

Repository metrics

Stars
 (2 stars)
PR merge metrics
 (PR metrics pending)

Description

Missing some 19 bgfips in blockgroupstats (almost 1% of CT) and some County FIPS in censusplaces table (1% of USA) - Some FIPS for the State of CT in particular had problems or were missing in some tables:

dataload_dynamic("bgid2fips")
bgfips_via_blockgroupstats = blockgroupstats[ , unique( bgfips )]
bgfips_via_bgid2fips = bgid2fips[, unique(substr(bgfips, 1, 12))]
length(bgfips_via_bgid2fips)
length(bgfips_via_blockgroupstats)
fips2state_abbrev(setdiff(bgfips_via_bgid2fips,bgfips_via_blockgroupstats)) # all are in CT

And possibly related issues in this dataset mostly in CT but also in AK and a few others:

table(censusplaces$ST[is.na( fips_lead_zero(  censusplaces$countyfips)  )])
# in countyfips column, but 370 (1% of them) are NA values -- 85% of the problems are in CT 
table(is.na(censusplaces$countyfips))
table(censusplaces$ST[ is.na(censusplaces$countyfips) ])

Contributor guide

Research direction
Investigate the source of missing FIPS codes in blockgroupstats and censusplaces tables, focusing on Connecticut. Check the data loading process and identify if the missing values are due to data source issues or processing errors.
Tech stack
r
Domain
data
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Needs investigation
Prerequisites
RCensus FIPS codes
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70