License Tally

Method and sources

Every number on this site is a count, a share or a median computed by License Tally from a file published by a state regulator. Nothing is estimated, modelled or taken from a secondary report. This page lists the files, the terms under which each is published, the rules applied to them and the limits a reader should keep in mind.

Source files and their terms

StateFile and publisherTerms recorded at retrievalRows read
WashingtonL&I Contractor License Data, General, Department of Labor & IndustriesOpen Data Commons Public Domain Dedication and License161,862
OregonCCB Active Licenses, Construction Contractors BoardPublic Domain, U.S. Government works, as labelled on the portal56,641
TexasTDLR license data files, Department of Licensing and RegulationTDLR policies page: copying allowed with conditions, set out below37,451
ConnecticutState Licenses and Credentials, Department of Administrative Services and Department of Consumer ProtectionPublic Domain, as labelled on the portal209,486
ColoradoProfessional and Occupational Licenses in Colorado, Department of Regulatory AgenciesPublic Domain, as labelled on the portal18,072

All five files were retrieved in November 2026. One further file is used as a lookup and contributes no counts of its own: the U.S. Census Bureau 2020 ZCTA to county relationship file, a federal government work, which assigns Washington ZIP codes to counties.

Texas terms

The TDLR policies page reproduces the state's rule on copying from agency websites. Information may be copied so long as it is presented in a non-misleading way and does not imply endorsement by the State. A user must identify the state agency that is the source, give its web address and the date the information was copied, and state that neither the site owner nor the information as presented is endorsed by the State or any state agency.

This site meets those conditions as follows. Source: Texas Department of Licensing and Regulation, www.tdlr.texas.gov. Copied: November 2026. Neither License Tally nor the Texas figures as presented on License Tally are endorsed by the State of Texas or any state agency. The same statement appears beneath each Texas chart and in the footer of every page.

What is published and what is not

The source files contain business names, addresses, telephone numbers and, in some states, the names of principals. License Tally publishes none of these. The output of the site is a set of aggregate tables. Names are read in one place only: the Oregon file has no business structure column, so each licensed name is tested for an entity suffix such as LLC, and the result is published as three totals.

Local profiles are produced only where a place has enough records for its shares to mean something. The thresholds are 150 active records for a Washington, Oregon or Texas county, 400 for a Washington city, 300 for an Oregon city, 250 for a Connecticut town and 100 for a Colorado city.

Rules applied to each file

Washington

One row is one registration or license. Active means the status column reads ACTIVE. The effective date does not change on renewal, so it is treated as the start of the registration. A business that lapses and registers again receives a new row, and the old row is marked RE-LICENSED; counts of new registrations therefore include returning businesses.

The file is a rolling window. Aside from five stray rows, it carries no record with an expiration date before November 2019. A registration that began in 2018 or later is in the file whatever became of it. A registration that began earlier is in the file only if it was still running in late 2019. Start year tables label the two periods, and charts draw the earlier period in a paler tone.

Counties are assigned from ZIP codes, because the file has a city and a ZIP code but no county. Each ZIP code goes to the county holding the largest land share of the matching Census ZCTA. 2,349 active records with a Washington address have a ZIP code that is not in the Census file, mostly post office box ZIP codes, and are reported on a separate row.

Oregon

One row is one endorsement. Contractor counts are of distinct license numbers that hold at least one contractor endorsement; rows for lead based paint renovation, home inspector certification and locksmith certification are set aside for those counts. The county is the one recorded by the CCB, which uses the value Out of State for 6,633 licenses.

The file lists active licenses only. The year of original registration is known for every license, but the number of licenses issued in a past year is not, because those that lapsed have left the file.

Texas

Six download files were read. A license is counted as current when its expiration date is on or after the day the files were copied. The business county is used, falling back to the mailing county where the business county is blank. The files give no issue date and no status column for five of the six types.

Connecticut

The statewide credentials file was filtered to the 31 credentials whose name contains the word contractor. Active uses the file's own active flag. The file mixes business registrations with trade licenses, and the tables report them on separate rows. 39,518 home improvement records have no issue date.

Colorado

The file was filtered to license types EC, PC and WC. Active means a status beginning with the word Active. First issue dates show 2,210 registrations in 2008 against 246 in 2007, which is treated as a record conversion, and charts of first issue year start at 2009.

Medians, shares and rounding

Shares are computed from unrounded counts and shown to one decimal place, so a column of shares can sum to 99.9 or 100.1. Ages are measured in days to the retrieval date and divided by 365.25. A median is the middle value of the group named in the table.

Why states are not ranked against each other

A Washington registration, an Oregon license, a Texas trade license, a Connecticut registration and a Colorado registration are different legal objects with different entry requirements. The licensing pages describe each. Dividing any of these counts by population would produce a rate that looks comparable and is not, so the site does not publish such rates.

Checks

Each table is produced by a script that reads the source file from start to finish on every build. Totals are reconciled: status counts sum to the row count, county counts plus unmatched and out-of-state rows sum to the active count, and so on. The site is rebuilt from the files, so a correction to a rule changes every page that depends on it.

Corrections

If a figure looks wrong, write to corrections@licensetally.com with the page address and the figure. The query is rerun against the source file. Where an error is confirmed the table is corrected and a note is added to the dataset page stating what changed. The citation page explains the process in full.

Questions

Where does License Tally get its data?

From contractor license files published by five state regulators: Washington L&I, the Oregon Construction Contractors Board, the Texas Department of Licensing and Regulation, the Connecticut Department of Consumer Protection and the Colorado Department of Regulatory Agencies. All were retrieved in November 2026.

Can the figures be checked?

Yes. Each dataset page states the columns and filters used, and every source file is public. Running the described grouping on the same file should return the same counts, apart from changes the regulator has made to the file since November 2026.