Dashboards
Capability proof
WV Dental Licensing Data
Explore West Virginia Board of Dentistry licensing records through clearer credential groups, layered filters, and direct professional research links.
Explore WV dental licensing dataWest Virginia's public dental licensing records contain useful signals about the workforce: who is licensed, when a license was issued, whether it remains active, where the professional studied, and what credentials or specialties appear on the record. But public access does not automatically make those records easy to analyze.
Degree and school information arrives as free text, with abbreviations, alternate spellings, repeated values, multiple credentials, and multiple institutions packed into single fields. Across 4,530 records, the live application retains 648 distinct degree strings and 919 distinct school strings.
The opportunity was to preserve that source detail while adding a clearer analytical layer. Seven practical degree categories, a West Virginia school marker, and layered filters make it possible to move from the statewide file to a meaningful subset—such as recently licensed dentists who may warrant further membership or workforce research.
Making inconsistent public records useful without losing their source detail.
Turn inconsistent free text into useful categories
Why it was difficult
Equivalent or related credentials appear as abbreviations, full names, combined degrees, certificates, residencies, fellowships, and specialty training. School names also appear under many written forms.
The response
Preserve the original degree and school text, then derive a separate analytical layer that maps credential descriptions into seven practical degree groups and identifies West Virginia schools.
Preserve awkward but legitimate records
Why it was difficult
The source includes duplicate license numbers, exact duplicate rows, missing values, and 619 records with multiple graduation dates in one field.
The response
Keep every Board result row, preserve multi-value graduation fields, derive one display date separately, and validate the source hash, schema, dates, row counts, keys, and transformed row equality before release.
Make a statewide file answer targeted questions
Why it was difficult
A broad license list does not readily answer questions such as which active DDS or DMD professionals were recently licensed or attended a West Virginia school.
The response
Combine status, action, school, years licensed, degree category, specialty, anesthesia, exact source values, search, and date ranges in one query that updates the matching subset immediately.
Connect the record to practical research
Why it was difficult
A license record establishes licensing facts but does not provide complete current employment, membership, or contact information.
The response
Link every professional name to a prefilled Google search, keeping the Board record as the licensing source while making current public follow-up research one click away.
Useful public records become a focused recruiting and research surface.
Dental associations
Membership teams looking for newly or recently licensed professionals who may be prospective members.
Define a current recruiting segment using license status, year, credential, school, specialty, and other relevant signals.
Reduce the statewide file to a focused candidate list, then use the direct research handoff to verify each professional's current context.
Workforce researchers
People studying West Virginia's licensed dental workforce and the schools and credentials represented in it.
Compare status, degree groups, specialties, authorizations, school patterns, and recent licensing activity.
Use the seven-category credential layer for broad patterns while retaining the exact source values for deeper review.
Employers and recruiters
Organizations defining a narrow universe of professionals for legitimate workforce or market research.
Find active professionals with a relevant credential, specialty, school background, or licensing timeframe.
Start with a more relevant result set and shorten the path from a government record to current public research.
Hundreds of source variations, resolved into useful structure.
Every row in the verified current export
Distinguished from 1,396 expired records
Source-level credential variation preserved
A compact analytical layer for filtering
Exact institution descriptions retained
From statewide totals to a focused professional subset.
Current license totals, credential distributions, and school patterns turn the statewide file into an understandable workforce snapshot.
Hundreds of inconsistent credential strings resolve into seven useful categories while the original degree and school values remain visible in each result.
Status, degree category, specialty, school, authorization, and date controls combine to reduce the statewide dataset to a meaningful professional subset.
Begin with a real question, combine the relevant filters, see the matching subset immediately, and retain the source detail needed to understand each result—without rebuilding the state data in a spreadsheet.
For a state dental association, one practical workflow is membership development: narrow to active professionals licensed in the current or recent years, focus on the relevant credential group, and use the Google handoff to investigate current professional context. The dashboard identifies candidates for careful follow-up; it does not establish eligibility, nonmembership, or verified contact information.
Public-data normalization and product design: acquiring a difficult state-government dataset, preserving source fidelity, deriving meaningful categories from inconsistent free text, and building layered filters and research handoffs around the result.
See the work