← All audits

· Production · Read-only

Production data coverage

Duplicate candidates, invalid values and broken references need review. All project-field presence and audit sections are available below; source completeness and accuracy remain unverified.

Open summary reportOriginal reportDownload all evidence

Historical snapshot · Coverage observed 06:29–06:59 CDT; duplicate follow-up 07:15–07:26 CDT. Production data was unchanged.

What needs attention

Possible duplicates

737 matching project groups contain 1,584 projects; 5,221 matching item groups contain 11,057 items. Not yet confirmed duplicates.

Evidence for Possible duplicates

Invalid values

119 nonfinite bid quantities and one impossible deadline need source review.

Evidence for Invalid values

Broken references

1,101 shared items link to tenant projects; 606 Bid Items link to deleted Project Items.

Evidence for Broken references

Classification failures

79 classification failures out of 87 failed pipeline runs. The root cause remains unconfirmed.

Evidence for Classification failures

Quick overview

Project presence and source coverage

119 project fields checked, covering identity, agency, lifecycle, location, money, dates, files, items and participants. 55,934 projects lack item links; 53,734 lack file links. Presence does not establish whether a field is required or accurate.

View presence for all 119 project fields: Project presence and source coverage
Stored nonblank values or links across 81,770 projects. Presence does not establish validity, accuracy or required-field eligibility.
Project fieldPresentNot populatedPresence
% Complete6,21075,5607.6%
Additional Notes5281,7180.1%
Adj. Project Amount8,10673,6649.9%
AI Parsed81,57619499.8%
Awarded Amount10,96870,80213.4%
Awarded To20,08461,68624.6%
Bid19,09362,67723.3%
Bid Date81,46930199.6%
Bid Days20,85960,91125.5%
Bid Opening1881,7520.0%
Bid Package Notes5281,7180.1%
Bid Received Until19,94161,82924.4%
Bid Request Type1,98279,7882.4%
Bid-Location2281,7480.0%
Bidders19,09362,67723.3%
Bidders (V1)19,11262,65823.4%
Buyer481,7660.0%
City36,96744,80345.2%
CMMC Requirement36381,4070.4%
Completed17,47364,29721.4%
Completion Source12,87368,89715.7%
Construction Manager6,91774,8538.5%
Construction Manager Email5,09676,6746.2%
Contact Email4581,7250.1%
Contract Limits From12,01769,75314.7%
Contract Limits To9,68872,08211.8%
Contract Type15,26766,50318.7%
Control Section Job (CSJ)12,11869,65214.8%
Controlling Project ID (CCSJ)19,98761,78324.4%
Country78,9902,78096.6%
County76,7155,05593.8%
Created At81,63913199.8%
date081,7700.0%
Date Awarded5081,7200.1%
Day Type19,21162,55923.5%
Days Completed8,10673,6649.9%
DBE Goal Percent9,53572,23511.7%
Delivery Method4,36177,4095.3%
Demandstar Codes19481,5760.2%
Depth to restrictive feature081,7700.0%
Description62,02319,74775.9%
Detail URL3481,7360.0%
District69,91011,86085.5%
Districts (V1)63,46418,30677.6%
Docs URL14481,6260.2%
End Date19,00462,76623.2%
End-Point62,60619,16476.6%
Engineers Estimate23,67458,09629.0%
Environmental Clear-to-Let Date2,48879,2823.0%
Environmental Clearance Type3,41778,3534.2%
Federal Project Number8,31873,45210.2%
file_url381,7670.0%
Files28,03653,73434.3%
Final Days6,21075,5607.6%
Has Documents29481,4760.4%
Has External Portal Links29481,4760.4%
Highway12,09369,67714.8%
id_column11,59370,17714.2%
Item count81,63913199.8%
letting_month181,7690.0%
Limits From7,61574,1559.3%
Limits To7,58574,1859.3%
Liquidated Damages37181,3990.5%
Liquidated Damages Rate3,50078,2704.3%
Location80,4301,34098.4%
Location (page)65181,1190.8%
Match12281,6480.1%
MPO Description3,34778,4234.1%
NAICS codes15,60866,16219.1%
Name81,7700100.0%
NIGP Codes16681,6040.2%
Notes081,7700.0%
Notice to Proceed Date4,82876,9425.9%
Oversight Description12,06569,70514.8%
Owner81,74624100.0%
Owner Contracting Office17,19464,57621.0%
Paid to Contractor7,97773,7939.8%
Planholders5,09876,6726.2%
Planholders (V1)5,09876,6726.2%
Pre bid Analysis081,7700.0%
Pre-Bid Meeting5781,7130.1%
Pre-Bid Q&A3,37178,3994.1%
Project ID66,83214,93881.7%
Project Items25,83655,93431.6%
Project Limits From12,05869,71214.7%
Project Limits To9,75572,01511.9%
Project Materials26,03355,73731.8%
Project Sector63,37618,39477.5%
Project Size6581,7050.1%
Project Stage29,01252,75835.5%
Project Status29,93451,83636.6%
Project Sub-type80,80996198.8%
Project Type80,80996198.8%
Project Value31,60850,16238.7%
Proposal Guarantee Amount12,08069,69014.8%
Proposal Published Date80,91785399.0%
Proposed Main Line Type2,40579,3652.9%
Proposed Mainlane Length6,87274,8988.4%
Publication Date40881,3620.5%
Region15181,6190.2%
Section2,86178,9093.5%
Sequence Number5,24676,5246.4%
Set Asides8,75573,01510.7%
Short Description12,08469,68614.8%
Soil Conditions081,7700.0%
Source81,7234799.9%
Source Type081,7700.0%
Spec Book Year12,05269,71814.7%
Start Date64,94116,82979.4%
Start-Point62,61419,15676.6%
State80,88688498.9%
state_id181,7690.0%
Subcontractors3,16778,6033.9%
Subcontractors (V1)3,16778,6033.9%
TIP Year5,72276,0487.0%
title92780,8431.1%
TxDOT - Most Restrictive Proposed Class5,99775,7737.3%
Updated At30,51051,26037.3%
url66,12815,64280.9%
All project-field presence CSVSource coverage CSVProject cohorts CSV

Duplicate projects and project items

737 groups of possibly duplicate projects (1,584 records) and 5,221 groups of possibly duplicate items (11,057 records). Duplication is unconfirmed until source rows and versions are reviewed. These are group counts, not counts of duplicate records.

View evidence and details: Duplicate projects and project items
Project candidates CSVItem candidates CSVMethods and limits

Items, quantities, units and prices

119 NaN quantities and 120 missing quantities need review. 12 money values fail single-number parsing; some are legitimate ranges. Zero and negative quantities are not automatic defects.

View evidence and details: Items, quantities, units and prices
Quantity findings CSVMoney and date findings CSVFull item checks

Graph links and references

1,101 item links cross into tenant projects; 606 Bid Item links target deleted items. 2,219 Materials → Agency targets are invalid. Reverse File links add no coverage.

View evidence and details: Graph links and references
Relationship findings CSVReference findings CSVGraph integrity CSV

Provenance, files and pipeline

79 classification failures dominate the failed runs. Only 1 of 134,617 files with metadata has checksum evidence; 9.2% of recent changes have run IDs. Seven IDs do not join scraper runs.

View evidence and details: Provenance, files and pipeline
Pipeline runs CSVProvenance by source CSVSchedule observations CSV

Field coverage

951 boolean values are stored in number fields; 834 Project Owner tags are invalid. All 397 fields are covered by the full matrix. Required-field eligibility and usable rates remain unknown; sparse optional fields are not automatically defects.

View evidence and details: Field coverage
Full field matrix CSVSearchable field details

What still needs source evidence

52,217 projects have unresolved lifecycle; 77 subcontract-assignment candidates need eligibility review. Source completeness, accuracy and item-to-source-row lineage are unverified.

View evidence and details: What still needs source evidence
Assignment candidates CSVAudit frameworkUnverified checks

Full findings, methods and downloads

All 15 original findings, reproducible queries and evidence files are retained. The original audit report is unchanged. Coverage and duplicate checks were observed in separate windows.

View evidence and details: Full findings, methods and downloads
All findings CSVEntity findings CSVOriginal query bundleDuplicate query bundleOriginal report

Pass this audit to an agent

The Markdown summary includes findings, next steps, methods, observation windows and limitations. The JSON manifest links every evidence file and its checksum.

View agent summaryExport summary (.md)Evidence manifest (.json)
Browse all 39 evidence files