Fern now carries a WSDOT bid-tab archive layer: downloaded source evidence, normalized contract totals, OCR recovery notes, and a live QA queue for records that still need human judgment.
Archive PDFs
3,931
downloaded and checksummed
Extracted totals
3,994
101.6% of archive PDFs
Cost observations
20,065
normalized records
Bid items
188,293
3,601 contracts
Open QA
0
17 source defects closed
AKDOTPF history
154,737
161 parsed · 7 closed
ODOT prices
139,759
461 contracts · 2018, 2020–2026
ALDOT prices
1,517,812
9,969 contracts · TXT/PDF + aggregate
AZDOT prices
8,274
22 contracts · live PDFs
ARDOT prices
323,105
200 contracts · bid tabs + aggregates
Caltrans prices
1,052,438
16,709 contracts · query HTML
CDOT prices
913,096
3,231 contracts · PDFs + EEMA
CTDOT prices
476,618
1,082 contracts · PDFs + aggregate
DelDOT prices
414,176
1,170 contracts · final PDFs
FDOT prices
19,787
20 Excel sources · aggregates
GDOT prices
964
57 LIBP contracts · summary PDF
HDOT prices
2,862
775 contracts · bid-result totals
ITD prices
213,172
1,160 contracts · AvgUnitPrice workbook
IDOT prices
1,565,954
11,001 contracts · WCTB tabs
INDOT prices
99,372
16 annual workbooks · aggregates
Iowa DOT prices
199,952
1,487 contracts · bid-tab PDFs
KDOT prices
569,210
235 CSVs · awarded items
KYTC prices
15,562
11 annual XLSX · aggregates
MaineDOT prices
95,735
1,110 contracts · bid-tab PDFs
MassDOT prices
7,552
3,776 Book rows · aggregates
Michigan DOT prices
2,790,789
7,732 contracts · btaexcel
MnDOT prices
711,763
1,742 contracts · abstract CSVs
MSDOT prices
252,696
1,999 contracts · bid-tab PDFs
MoDOT prices
18,470
18,470 aggregate rows · Unit Bid Books
Montana DOT prices
139,226
650 contracts · Bid Tabs
Nebraska DOT prices
30,291
27 AUP reports · aggregates
Nevada DOT prices
17
5 contracts · archived totals
NHDOT prices
1,308
1,308 aggregate rows · WAUP PDF
NJDOT prices
116,653
746 contracts · Bid Price Reports
MDOT SHA prices
204,474
2,658 proposals · Price Index
Coverage
WSDOT first, then the wider public works graph.
The first live public-works slice starts with WSDOT bid-tab PDFs. Direct text extraction handled most documents; OCR fallback recovered older scans where total rows were visible but not machine-readable.
Full CSVs, source manifests, schemas, parser scripts, and QA notes are committed under data/public-works and research/public-works.
Annual reports separate aggregate and contract rows.
New Jersey Phase 1 saves the official 2007-2021 AASHTOWare Bid Price Report PDFs and normalizes annual aggregates, top-standard-item aggregates, quarterly weighted averages, awarded contract item rows, second/third bidder columns, and engineer estimate columns as distinct price types. Partial modern rows with blank bidder columns stay in the review queue instead of inferring missing column identities.
New Jersey Phase 1 coverage
Metric
Count
Source inventory rows
15
Checksummed sources
15
Bid Price Report PDFs
15
Parsed Bid Price Report PDFs
15
Annual weighted averages
13,980
Awarded contract item rows
75,882
Quarter aggregate rows
9,548
Top-standard aggregates
200
Contracts
746
Bid item occurrences
116,653
Duplicate render layers removed
0
Explicit exclusions
11
Normalized price rows
116,653
Price types
Type
Price rows
Njdot Awarded Contract Item Unit Price
75,882
Njdot Annual Weighted Average Unit Price
13,980
Njdot Second Bidder Contract Item Unit Price
5,681
Njdot Third Bidder Contract Item Unit Price
5,681
Njdot Engineer Estimate Item Unit Price
5,681
Njdot Quarter Weighted Average Awarded Unit Price
4,774
Njdot Quarter Average Low 3 Bidders Unit Price
4,774
Njdot Top Standard Item Average Unit Price
200
Annual coverage
Year
Price rows
2006
211
2007
5,905
2008
9,248
2009
9,838
2010
5,585
2011
5,621
2012
5,252
2013
6,093
2014
3,651
2015
5,924
2016
5,617
2017
6,922
2018
6,509
2019
6,211
2020
26,042
2021
7,824
Source statuses
Status
Sources
Parsed
15
Review closeout
Status
Rows
Queued For Manual Review
4,097
Common descriptions
Description
Price rows
CLEARING SITE
704
EXCAVATION, UNCLASSIFIED
689
CONSTRUCTION LAYOUT
670
MOBILIZATION
664
PERFORMANCE BOND AND PAYMENT BOND
657
FINAL CLEANUP
612
CONSTRUCTION SIGNS
580
PROGRESS SCHEDULE
571
No duplicate render layers were removed; New Jersey parsing uses official embedded PDF text. Partial 2020-2021 bidder columns remain queued for manual review.
Line items
The WSDOT archive now has an item catalog.
This first line-item layer extracts item numbers, descriptions, categories, units, quantities, source IDs, and page references from readable direct-text bid check reports. Validated 2021-2026 price extracts now add bidder-level unit prices and extended amounts for contracts whose item sums match WSDOT total blocks.
Line-item coverage
Metric
Count
Bid item rows
188,293
Represented contracts
3,601
Validated price rows
829,569
Priced contracts
3,148
Source PDFs extracted
3,602
Top work categories
Category
Items
Traffic
53,466
Other Items
39,176
Preparation
16,359
Erosion Control And Planting
13,041
Structure
12,795
Hot Mix Asphalt
10,716
Erosion Control And Roadside Planting
7,962
Drainage
6,682
Top units
Unit
Items
EACH
42,121
L.S.
35,304
L.F.
33,707
EST.
16,060
CALC
11,891
S.Y.
9,742
C.Y.
9,312
TON
8,561
Most common WSDOT bid items
Item
Rows
Mobilization
3,440
Minor Change
3,395
Reimbursement For Third Party Damage
3,240
Spcc Plan
3,074
Roadside Cleanup
2,341
Erosion/Water Pollution Control
1,990
Esc Lead
1,848
Construction Signs Class A
1,673
Paint Line
1,635
Project Temporary Traffic Control
1,627
Compaction Price Adjustment
1,558
Crushed Surfacing Base Course
1,534
Permanent Signing
1,517
Flexible Guide Post
1,494
Rows are direct-text item catalog entries. Price rows are promoted only when bidder-rank item sums reconcile to WSDOT total blocks.
Validated 2026 cost drivers
Item
Low-bid amount
Contracts
DESIGN BUILD WORK (RULE 170) OTHER ITEMS
$1182.6M
6
MOBILIZATION PREPARATION
$796.7M
2,389
TOTAL FOR DESIGN-BUILD WORK (UNDER OTHER ITEMS
$476.3M
4
TOTAL DESIGN-BUILD WORK - LUMP SUM (DOR OTHER ITEMS
$300.0M
1
HMA CL. 1/2 IN. PG 64-22
$264.2M
344
PROJECT TEMPORARY TRAFFIC CONTROL
$255.4M
1,225
DESIGN-BUILD WORK (RULE 170) OTHER ITEMS
$240.2M
3
STRUCTURAL LOW ALLOY STEEL
$159.1M
31
TOTAL FOR DESIGN BUILD WORK (UNDER OTHER ITEMS
$153.3M
2
ROADWAY EXCAVATION INCL. HAUL GRADING
$148.2M
844
MOBILIZATION
$138.3M
531
CEMENT CONC. PAVEMENT CEMENT CONCRETE PAVEMENT
$135.3M
114
2,770 contracts are fully validated; 379 have low-bidder validation; 0 remain in price QA; 329 historical contracts are closed as unresolved total mismatches and excluded from promotion.
Validated 2021-2026 price categories
Category
Low-bid amount
Design Build Work (Rule
$1187.9M
Uncategorized
$877.9M
Job Mix Compliance Price Adjustment
$770.7M
Structure
$605.7M
Clearing And Grubbing
$450.4M
Total For Design-Build Work (Under Revenue
$368.4M
Hot Mix Asphalt
$333.2M
Total Design-Build Work Lump Sum (Dor Rule
$300.0M
Traffic
$270.1M
Design-Build Work (Rule
$238.0M
Alaska DOT&PF
Historical item prices are now normalized.
Alaska Phase 9 carries closed historical bid-price books plus broader modern DOT&PF API coverage. Historical rows summarize estimate/min/average/max unit prices; modern rows come from the public post-2018 bid item API. BidX full-tab access is verified as credential-required.
Modern API rows stay needs_review until spot QA and duplicate/adjustment classification are complete.
Common Alaska units
Unit
Price rows
Lump
43,422
Each
27,355
Linear
16,861
Contingent
12,720
Ton
12,576
Square
11,292
Cubic
5,245
LUMP
4,067
Common Alaska items
Item
Price rows
Traffic Maintenance
2,682
Construction Surveying
2,427
Field Office
2,095
Mobilization And Demobilization
2,031
Traffic Control
1,908
Worker Meals and Lodging, or Per Diem
1,815
Standard Sign
1,805
Unclassified Excavation
1,753
Rows are verified item-summary price records from official DOT&PF historical bid-price PDFs.
Alabama DOT
Bid tabs are now checksummed.
Alabama Phase 1 inventories official bid-tab pages back to 1996, checksums recoverable bid-tab and low-bid-sheet evidence, promotes TXT and PDF bid-tab bidder rows plus rolling item-summary aggregates, while paired PDF/TXT sources stay classified as duplicate official evidence.
Alabama Phase 1 coverage
Metric
Count
Source inventory rows
978
Checksummed sources
971
TXT bid-tab price rows
1,013,268
PDF bid-tab price rows
452,443
Item-summary aggregates
52,101
PDF bid tabs pending layout QA
0
Explicit review rows
538
Explicit exclusions
311
Normalized price rows
1,517,812
Price types
Type
Price rows
Bidder
1,465,711
Aggregate Min Bid
17,367
Aggregate Average Bid
17,367
Aggregate Max Bid
17,367
Annual coverage
Year
Price rows
1996
41,231
1997
39,244
1998
40,310
1999
47,809
2000
69,557
2001
60,719
2002
78,068
2003
58,426
2004
51,396
2005
43,161
2006
37,449
2007
48,264
2008
51,345
2009
68,233
2010
66,644
2011
52,385
2012
56,606
2013
53,516
2014
59,762
2015
50,510
2016
50,461
2017
52,596
2018
47,745
2019
34,741
2020
36,033
2021
31,685
2022
28,730
2023
29,946
2024
44,643
2025
66,451
2026
17,972
Source statuses
Status
Sources
Parsed
242
Normalization Excluded Txt Equivalent Bidtab
238
Normalization Excluded Contract Level
232
Parsed Pdf Layout
138
Excluded Non Bidtab Collateral
70
Html Index Parsed
51
Normalization Excluded Unavailable Contract Level
6
Official Url Unavailable Or Malformed
1
Common units
Unit
Price rows
EACH
290,246
LF
153,088
TON
76,665
LUMP
72,228
MILE
66,984
SQFT
56,869
SQYD
54,674
CUYD
52,179
Common item-summary items
Item
Price rows
Construction Signs
1,086
Channelizing Drums
909
Tack Coat
894
Solid White, Class 2, Type A Traffic Stripe (5" Wide)
879
Solid Temporary Traffic Stripe
858
Traffic Control Markings, Class 2, Type A
858
Solid Yellow, Class 2, Type A Traffic Stripe (5" Wide)
855
Cones (36 Inches High)
834
ALDOT item-summary rows are min, average, and max unit-price aggregates; bidder-specific rows remain separate.
Arizona DOT
Current bid tabs are parsed.
Arizona Phase 1 captures the live CNSAWS bid-tab index, checksums current official S3 bid-tab PDFs, parses engineer-estimate and bidder-rank item rows, and keeps as-read totals, E2C2 redirect boundaries, no-document rows, and credentialed workflows out of item prices.
Arizona Phase 1 coverage
Metric
Count
Source inventory rows
45
Checksummed sources
44
Live bid-tab PDFs
22
Engineer estimate rows
1,752
Bidder rows
6,522
Contracts
22
Explicit review rows
601
Explicit exclusions
21
Normalized price rows
8,274
Price types
Type
Price rows
Bidder
6,522
Engineer Estimate
1,752
Annual coverage
Year
Price rows
2026
8,274
Source statuses
Status
Sources
Parsed
22
Boundary Evidence Acquired
11
Normalization Excluded Contract Level As Read
9
Live Fetch Redirect Loop Boundary
1
Html Index Parsed
1
Html Index Parsed Contract Level Excluded
1
Common units
Unit
Price rows
EACH
2,206
L.FT.
1,833
EACH-DAY
1,019
L.SUM
592
SQ.YD.
511
CU.YD.
419
HOUR
342
TON
325
Common items
Item
Price rows
CHANGEABLE MESSAGE BOARD (CONTRACTOR FURNISHED)
110
MOBILIZATION
110
CONSTRUCTION SURVEYING AND LAYOUT
110
TRUCK-MOUNTED ATTENUATOR
106
FLAGGING SERVICES (CIVILIAN)
91
WATERBORNE-TYPE I PAVEMENT MARKING (PAINTED) (WHITE)
85
SEEDING (CLASS II)
82
WATERBORNE-TYPE I PAVEMENT MARKING (PAINTED) (YELLOW)
81
AZDOT as-read pages remain excluded because they are contract-total bidder summaries, not unit-price bid tabs.
Arkansas DOT
Bid tabs and aggregates stay separate.
Arkansas Phase 1 uses ARDOT REST page content as the official index, checksums recoverable media.ark.org bid-tab and weighted-average PDFs, parses bidder item rows and aggregate unit prices, and keeps awards, apparent results, plans, notices, and retired-domain evidence in explicit exclusion queues.
Arkansas Phase 1 coverage
Metric
Count
Source inventory rows
525
Checksummed sources
525
Bid-tab PDFs
233
Weighted-average PDFs
23
Bid-tab bidder rows
279,008
Aggregate rows
44,097
Contracts
200
Explicit review rows
27,650
Explicit exclusions
1,235
Normalized price rows
323,105
Price types
Type
Price rows
Bidder
279,008
Aggregate High Unit Price
14,699
Aggregate Low Unit Price
14,699
Weighted Average Awarded
14,699
Annual coverage
Year
Price rows
2005
1,344
2006
1,182
2007
1,278
2008
1,155
2009
1,296
2010
30,508
2011
30,769
2012
29,269
2013
24,527
2014
28,978
2015
20,743
2016
32,313
2017
15,027
2018
16,498
2019
16,263
2020
18,962
2021
9,620
2022
12,222
2023
8,963
2024
2,070
2025
8,384
2026
11,734
Source statuses
Status
Sources
Normalization Excluded Award Level
253
Parsed
223
No Item Rows Extracted
33
Boundary Evidence Acquired
12
Normalization Excluded Contract Level As Read
4
Common units
Unit
Price rows
LF
87,298
EACH
75,955
TON
38,642
CUYD
26,556
SQYD
23,501
L.S.
20,173
SQFT
11,541
ACRE
10,338
Common items
Item
Price rows
SIGNS
7,660
TACK COAT
6,393
MAINTENANCE OF TRAFFIC
5,028
RAISED PAVEMENT MARKERS (TYPE II)
3,750
REFLECTORIZED PAINT PAVEMENT MARKING
3,695
MINERAL AGGREGATE IN ACHM SURFACE
3,646
ACHM PATCHING OF EXISTING ROADWAY
3,617
COLD MILLING ASPHALT PAVEMENT
3,456
ARDOT weighted-average rows are aggregate unit prices and are not mixed with bidder-ranked contract rows.
California DOT
Query evidence is bounded.
Caltrans Phase 1 uses the official Contract Cost Data database result pages as saved HTML evidence, keeps bidder-rank rows distinct from public summary statistics, and records capped query pages, ServiceNow attachment authentication, procurement-only pages, and archive captures as explicit review or exclusion boundaries.
California Phase 1 coverage
Metric
Count
Source inventory rows
8,337
Checksummed sources
8,336
Result query pages
8,318
Official result caps
1,579
Contracts
16,709
Explicit review rows
328,899
Explicit exclusions
23
Normalized price rows
1,052,438
Price types
Type
Price rows
Bidder
1,052,438
Annual coverage
Year
Price rows
1993
14,060
1994
15,047
1995
11,532
1996
17,287
1997
11,650
1998
14,063
1999
13,425
2000
14,613
2001
12,359
2002
53,025
2003
27,161
2004
38,625
2005
41,652
2006
39,538
2007
36,096
2008
41,014
2009
42,228
2010
41,259
2011
37,108
2012
37,524
2013
34,924
2014
35,660
2015
35,453
2016
36,854
2017
32,965
2018
35,623
2019
35,728
2020
38,552
2021
38,854
2022
36,314
2023
33,184
2024
35,019
2025
36,818
2026
27,224
Source statuses
Status
Sources
Parsed
6,250
Parsed With Official Result Cap
1,579
Partitioned By District Due To Official Result Cap
320
Partitioned By Unit Due To Official Result Cap
97
Partitioned By Item Due To Official Result Cap
67
Boundary Evidence Acquired
18
Parsed Empty Result
5
Access Boundary Unavailable
1
Common units
Unit
Price rows
EA
192,348
LS
189,708
LF
172,658
CY
94,084
M
78,608
SQFT
74,455
M3
48,485
SQYD
43,915
Common items
Item
Price rows
CONSTRUCTION AREA SIGNS
37,654
TRAFFIC CONTROL SYSTEM
33,435
ROADWAY EXCAVATION
27,819
TEMPORARY DRAINAGE INLET PROTECTION
24,359
PAVEMENT MARKER (RETROREFLECTIVE)
21,161
COLD PLANE ASPHALT CONCRETE PAVEMENT
19,909
HOT MIX ASPHALT (TYPE A)
16,243
THERMOPLASTIC PAVEMENT MARKING
15,400
Caltrans result rows expose bid rank but not bidder name; current bid-summary attachments are recorded as an authentication boundary.
Colorado DOT
Cost books and EEMA stay typed.
Colorado Phase 1 checksums the official State Publications Library Cost Data PDF archive, parses project item unit costs and aggregate weighted averages, saves the 2026 public EEMA awarded-item lookup, and keeps Hyland bid-tab viewers, CORA request-only records, index reports, item-code books, and archive boundaries out of normalized item prices.
Colorado Phase 1 coverage
Metric
Count
Source inventory rows
66
Checksummed sources
66
Cost Data PDFs
39
PDF price rows
909,437
EEMA awarded rows
3,659
Aggregate rows
291,919
Contracts
3,231
Explicit review rows
765
Explicit exclusions
14
Normalized price rows
913,096
Price types
Type
Price rows
Average Bid
205,855
Awarded Bid
205,838
Engineer Estimate
205,825
Average Bid Weighted Average
97,311
Awarded Bid Weighted Average
97,304
Engineer Estimate Weighted Average
97,304
Awarded First Bidder
3,659
Annual coverage
Year
Price rows
2001
29,448
2002
37,764
2003
38,009
2004
40,113
2005
35,685
2006
43,113
2007
36,577
2008
40,253
2009
40,816
2010
12,147
2011
9,504
2012
26,298
2013
40,554
2014
51,810
2015
42,071
2016
46,086
2017
34,293
2018
42,921
2019
40,542
2020
43,235
2021
47,043
2022
41,310
2023
8,202
2024
47,197
2025
34,446
2026
3,659
Source statuses
Status
Sources
Parsed
37
Boundary Or Context
25
Parsed No Item Rows
3
Boundary Context
1
Common units
Unit
Price rows
Each
372,890
Foot
242,185
Hour
61,785
Cubic Yard
61,213
Lump Sum
55,706
Ton
32,248
Day
27,776
Gallon
22,577
Common items
Item
Price rows
Mobilization
9,571
Const Traf Sign (B)
8,970
Traf Ctrl Mgmt
8,886
Traffic Cone
8,550
Flagging
8,532
Rem C, G and Sidewalk Lin
8,466
Const Traf Sign (A)
8,362
Traf Ctrl Inspection
8,015
CDOT weighted averages are aggregate observations; EEMA rows expose only awarded first-bidder information.
Connecticut DOT
Apparent low bids are checksummed.
Connecticut Phase 1 saves the official CTDOT Project Awards archive, parses apparent 3-low-bid PDF item rows where text is extractable, preserves scanned and ambiguous PDFs in review, and keeps DBE/SBE/PAC award-context documents and procurement boundaries out of normalized item prices.
Connecticut Phase 1 coverage
Metric
Count
Source inventory rows
2,263
Checksummed sources
2,263
Bid-tab PDFs
1,334
Parsed bid-tab PDFs
1,083
Bid-tab bidder rows
474,023
Aggregate rows
2,595
Contracts
1,082
Explicit review rows
6,770
Explicit exclusions
932
Normalized price rows
476,618
Price types
Type
Price rows
Bidder
474,023
Weighted Average Aggregate
2,595
Annual coverage
Year
Price rows
2012
14,303
2013
19,377
2014
26,726
2015
45,247
2016
47,725
2017
46,814
2018
44,557
2019
37,012
2020
31,293
2021
34,628
2022
27,930
2023
23,365
2024
21,892
2025
36,540
2026
19,209
Source statuses
Status
Sources
Parsed
1,084
Excluded Award Context
922
Blocked Scanned Or No Extractable Text
245
Blocked Non Bidtab Pdf Text
6
Excluded Context
4
Not Applicable
2
Common units
Unit
Price rows
ea.
140,827
l.f.
103,572
ls
57,159
c.y.
40,792
s.y.
34,874
s.f.
27,130
ton
14,731
est.
13,681
Common items
Item
Price rows
MAINTENANCE AND PROTECTION OF TRAFFIC ** See Special Provisions **
4,311
TRAFFIC DRUM
3,886
MOBILIZATION AND PROJECT CLOSEOUT
3,438
BARRICADE WARNING LIGHTS - HIGH INTENSITY
3,317
CUT BITUMINOUS CONCRETE PAVEMENT
3,267
EARTH EXCAVATION
3,056
CONSTRUCTION SIGNS
2,939
MATERIAL FOR TACK COAT
2,924
CTDOT weighted-average rows are aggregate unit prices; apparent low-bid PDF rows remain bidder-ranked contract observations.
Delaware DOT
Final bid tabs are parsed.
Delaware Phase 1 saves the official Project Status feed, acquires recoverable final bid-tab PDFs, parses legacy fixed-width and modern AASHTOWare item rows, and keeps engineer-estimate rows separate from bidder-ranked prices.
Delaware Phase 1 coverage
Metric
Count
Source inventory rows
1,904
Checksummed sources
1,904
Final bid-tab PDFs
1,893
Parsed bid-tab PDFs
1,170
Bid-tab price rows
414,176
Engineer estimate rows
74,753
Bidder rows
339,423
Contracts
1,170
Explicit review rows
6,721
Explicit exclusions
8
Normalized price rows
414,176
Price types
Type
Price rows
Bidder
339,423
Engineer Estimate
74,753
Annual coverage
Year
Price rows
1900
303
2007
512
2008
24,537
2009
26,411
2010
28,181
2011
29,577
2012
20,061
2013
20,656
2014
20,259
2015
28,706
2016
15,446
2017
20,477
2018
22,892
2019
18,117
2020
21,358
2021
18,521
2022
23,378
2023
19,498
2024
15,899
2025
19,791
2026
9,834
Source statuses
Status
Sources
Parsed
1,170
Blocked Legacy Project Item List No Bid Prices
718
Boundary Evidence Acquired
10
Blocked Non Bidtab Pdf Text
4
Feed Parsed
1
Blocked No Item Price Rows Extracted
1
Common units
Unit
Price rows
LF
94,993
EACH
92,919
TON
36,341
CY
35,653
SY
34,864
SF
33,049
LUMP
24,605
EADY
20,044
Common items
Item
Price rows
GRADED AGGREGATE BASE COURSE, TYPE B
4,442
EXCAVATION AND EMBANKMENT
4,147
SAW CUTTING, CONCRETE, FULL DEPTH
3,971
INITIAL EXPENSE
3,728
PERMANENT GRASS SEEDING, DRY GROUND
3,610
CLEARING AND GRUBBING
3,402
ADJUSTING AND REPAIRING EXISTING DRAINAGE INLET
3,229
TOPSOIL, 6" DEPTH
3,015
DelDOT Phase 1 does not remove duplicate render layers unless an exact source/page/line/rank duplicate is proven by stable price IDs.
Florida DOT
Average-cost rows stay aggregate.
Florida Phase 1 saves FDOT's official Historical Item Average Cost reports, parses direct Sitefinity Excel workbooks, keeps paired PDF renditions as support evidence, and records Cerberus folder, bid-tab, PowerBI, retired-source, workflow, and public-records boundaries without assigning bidder or engineer-estimate semantics.
Florida Phase 1 coverage
Metric
Count
Source inventory rows
44
Checksummed sources
44
Excel workbooks
20
PDF support renditions
20
Archive folder boundaries
3
Aggregate rows
19,787
Obs flag review rows
1,054
Duplicate render layers removed
0
Explicit exclusions
7
Normalized price rows
19,787
Price types
Type
Price rows
Weighted Average Awarded
19,787
Annual coverage
Year
Price rows
2022
2,023
2023
2,026
2024
2,035
2025
12,002
2026
1,701
Source statuses
Status
Sources
Support Pdf Rendition Not Parsed
20
Parsed Average Cost Workbook
20
Cerberus Folder Ui Boundary Not Enumerated
3
Boundary Html Acquired
1
Common units
Unit
Price rows
EA
9,843
LF
3,952
SY
1,336
GM
969
AS
843
LS
519
CY
501
SF
416
Common items
Item
Price rows
THERMOPLASTIC, PREFORMED, WHITE, MESSAGE
23
MAINTENANCE OF TRAFFIC
20
TRAFFIC CONTROL OFFICER
20
WORK ZONE SIGN
20
TYPE III BARRICADE
20
LITTER REMOVAL
20
MOWING
20
CLEARING & GRUBBING
20
FDOT Phase 1 normalizes weighted average awarded-price rows only; contract-level bid-tab and bidder rows remain source-boundary evidence until a separate parser can preserve those semantics.
Georgia DOT
LIBP summary rows keep their published role.
Georgia Phase 1 saves GDOT contractor, BidX, BI, archive, aviation, and Low Impact Bridge Program evidence. The normalized rows come only from the official LIBP bid-tab summary PDF; rank rows, aggregate average columns, total-bid rows, and bridge $/ft2 unit-cost rows remain separate.
Georgia Phase 1 coverage
Metric
Count
Source inventory rows
25
Checksummed sources
25
LIBP summary PDFs
1
Bidder-rank rows
462
Aggregate average rows
194
$/ft2 unit-cost rows
308
Contracts
57
Official n/a review rows
119
Source anomaly rows
1
Duplicate render layers removed
0
Explicit exclusions
10
Normalized price rows
964
Price types
Type
Price rows
Bidder
462
Unit Cost Per Square Foot Bidder
308
Average Low And Second Bid
104
Average All Three Bids
90
Annual coverage
Year
Price rows
2020
258
2021
435
2022
271
Source statuses
Status
Sources
Boundary Or Context Acquired
16
Source Access Boundary
4
Support Pdf Not Bid Price Table
2
Aviation Context Excluded
2
Parsed Libp Summary Pdf
1
Common units
Unit
Price rows
LS
656
SF
308
Common items
Item
Price rows
Grading complete lump-sum bid price
251
Traffic control lump-sum bid price
251
Construct new bridge unit cost
154
Remove existing bridge unit cost
154
LIBP total bid
154
GDOT Phase 1 excludes aviation samples from highway rows and treats current BidX/SharePoint/BI limits as explicit source boundaries.
Hawaii DOT
Bid-result totals remain contract-level.
Hawaii Phase 1 saves HDOT FY2017-FY2023 bid-result PDF archives plus HANDS, WordPress REST, archive, average-unit-price, and public-records boundary evidence. The normalized rows are bidder contract, area, or top-level item totals only; HDOT did not publish itemized unit-price bid tabs in the recovered public archive.
Hawaii Phase 1 coverage
Metric
Count
Source inventory rows
865
Checksummed sources
865
Bid-result PDFs
834
Parsed total PDFs
775
Whole-contract total rows
2,349
Area total rows
166
Top-level item total rows
62
Unlabeled component rows
285
Contracts
775
Repeated bidder/amount review rows
1
Duplicate render layers removed
0
Explicit exclusions
10
Normalized price rows
2,862
Price types
Type
Price rows
Contract Total Bidder
2,349
Contract Component Total Bidder
285
Contract Area Total Bidder
166
Contract Item Total Bidder
62
Annual coverage
Year
Price rows
2016
113
2017
653
2018
613
2019
621
2020
463
2021
164
2022
220
Source statuses
Status
Sources
Parsed Contract Total Pdf
775
No Contract Total Rows
59
Download Failed
11
Parsed Index Or Context Page
9
Boundary Source Acquired
8
Hands Search Json Or Shell Acquired
2
Hands Config Json Acquired
1
Review closeout
Status
Rows
Included With Source Anomaly
475
Preserved Raw Not Normalized
340
Excluded From Normalized
82
Not Promoted To Bid Price Table
17
Common totals
Item
Price rows
Contract bid total
2,349
Displayed amount 2 bid total
108
Displayed amount 1 bid total
96
Displayed amount 3 bid total
54
Area 1 bid total
47
Area 2 bid total
45
Area 3 bid total
33
Area 4 bid total
31
HDOT Phase 1 does not promote estimate ranges or HANDS award metadata into item-price rows, and no duplicate render layers were removed without direct evidence.
Idaho DOT
Bidder item rows from the official workbook.
Idaho Phase 1 saves ITD contractor-bidding pages, linked bid-result summaries, AASHTOWare bid abstracts, and the official AvgUnitPrice workbook. The normalized rows come from the workbook's bidder-rank item observations; linked PDFs are inventoried and text-probed without being conflated with workbook rows.
Idaho Phase 1 coverage
Metric
Count
Source inventory rows
441
Checksummed sources
437
Workbook sources
1
Bid-result summary PDFs
195
Bid-abstract PDFs
202
Contracts
1,160
Bid item occurrences
58,661
Workbook rows routed to review
1,163
Duplicate render layers removed
0
Explicit exclusions
35
Normalized price rows
213,172
Price types
Type
Price rows
Bidder
213,172
Annual coverage
Year
Price rows
2013
23,288
2014
16,239
2015
19,652
2016
18,484
2017
16,863
2018
17,665
2019
13,416
2020
13,577
2021
16,145
2022
14,264
2023
12,659
2024
11,621
2025
13,231
2026
6,068
Source statuses
Status
Sources
Text Extracted Itemized Pdf Not Promoted Phase1
199
Text Extracted Contract Summary Not Item Price
195
Source Boundary Evidence
40
Unavailable Or Failed
4
Context Or Boundary Evidence
2
Parsed Bidder Item Rows
1
Review closeout
Status
Rows
Excluded From Normalized Price Rows
1,163
Source Inventoried Text Probed Not Normalized
394
Common items
Item
Price rows
SP
27,146
SP BRIDGE
6,308
CONTINGENCY AMOUNT
5,976
MOBILIZATION
4,039
TEMPORARY TRAFFIC CONTROL SIGNS
2,731
DRUMS
2,400
TRAF CNTL MAINTENANCE
2,315
EXCAVATION
2,209
ITD Phase 1 preserves workbook duplicate and missing-rank/price anomalies in review rows and performs no PDF render-layer deduplication.
Illinois DOT
WCTB tabs keep bidder and award semantics apart.
Illinois Phase 1 saves WCTB letting pages, public attachments, awarded pay-item workbooks, unit-price tabulation ZIPs, and publication-boundary context. The normalized rows keep bidder unit-tab observations separate from awarded workbook rows, while as-accepted totals and pay-item context stay out of the price layer.
Illinois Phase 1 coverage
Metric
Count
Source inventory rows
533
Checksummed sources
533
Awarded-price workbooks
62
Unit-price tab ZIPs
85
Bidder rows
1,333,209
Awarded unit-price rows
232,745
Contracts
11,001
Bid item occurrences
1,565,808
Duplicate render layers removed
0
Explicit exclusions
326
Normalized price rows
1,565,954
Price types
Type
Price rows
Bidder
1,333,209
Awarded Unit Price
232,745
Annual coverage
Year
Price rows
2018
208,582
2019
202,058
2020
210,762
2021
220,061
2022
191,056
2023
134,684
2024
159,397
2025
155,984
2026
83,370
Source statuses
Status
Sources
Checksummed Context Not Normalized
318
Parsed Unit Price Zip
85
Html Inventory Source Boundary
65
Parsed Awarded Xlsx
37
No Awarded Rows Extracted
25
Source Boundary Or Context Not Normalized
3
Review closeout
Status
Rows
Excluded From Normalized
162,403
Official Repeated Layout Row Excluded
310
Common items
Item
Price rows
MOBILIZATION
26,873
BIT MATLS TACK CT
14,205
EARTH EXCAVATION
11,328
SHRT TRM PAVT MK REM
10,992
CHANGEABLE MESSAGE SN
10,669
SHORT TERM PAVT MKING
10,088
PROTECTIVE COAT
9,749
POTASSIUM FERT NUTR
9,581
IDOT Phase 1 does not remove duplicate render layers: awarded XLSX rows and unit-tab TXT bidder rows are separate official publications with different semantics.
Indiana DOT
Annual low-bid unit-price history is live.
Indiana Phase 1 saves INDOT annual summary workbooks, modern and known-path legacy letting pages, Official Bid Results, Unit Tab PDFs, and SOPI context. The normalized layer promotes only annual high, low, and weighted-average rows based on low bids for awarded contracts; itemized Unit Tab PDFs stay in review until a dedicated layout parser can separate bidder and item semantics.
Indiana Phase 1 coverage
Metric
Count
Source inventory rows
1,173
Checksummed sources
1,170
Annual XLSX summaries
16
Legacy binary XLS summaries
7
Letting pages
170
Unit Tab PDFs
113
Official Result PDFs
134
SOPI context sources
730
Bid item occurrences
33,124
Duplicate render layers removed
0
Explicit exclusions
8
Normalized price rows
99,372
Price types
Type
Price rows
Aggregate Low Bid High Unit Price
33,124
Aggregate Low Bid Low Unit Price
33,124
Weighted Average Low Bid Unit Price
33,124
Annual coverage
Year
Price rows
2011
6,792
2012
7,926
2013
6,753
2014
6,414
2015
6,138
2016
7,386
2017
6,219
2018
6,351
2019
6,513
2020
6,579
2021
6,303
2022
6,507
2023
6,387
2024
6,786
2025
6,318
Source statuses
Status
Sources
Pay Item Context Not Price Source
729
Source Page Acquired
173
Official Result Contract Total Context
133
Unit Tab Pdf Pending Layout Parser
112
Parsed Annual Unit Price Summary
16
Legacy Binary Xls Requires Review
7
Download Failed
3
Review closeout
Status
Rows
Excluded From Normalized
130
Common items
Item
Price rows
CLEARING AND GRUBBING
96
ASPHALT FOR TACK COAT
93
REGULATED ASBESTOS CONTAINING MATERIALS, REMOVE
90
RIPRAP, REVETMENT
90
STRUCTURAL STEEL
90
CONDUIT, STEEL, GALVANIZED, 2 IN.
90
B BORROW
87
MOBILIZATION AND DEMOBILIZATION
84
INDOT Phase 1 removes no duplicate render layers: annual workbooks, Official Results, Unit Tab PDFs, and SOPI files are distinct official evidence classes.
Iowa DOT
Public bid-tab PDFs are live.
Iowa Phase 1 saves Iowa DOT bid-tabulation archive pages and public PDF media. The normalized layer promotes only item-level bidder-rank unit prices from construction and material bid-tab pages; alternate sections with fewer displayed bid columns than the bidder header stay in review.
Iowa Phase 1 coverage
Metric
Count
Source inventory rows
74
Checksummed sources
72
Bid-tab PDFs
46
Parsed bid-tab PDFs
45
Bidder rows
199,952
Contracts
1,487
Bid item occurrences
47,221
Duplicate render layers removed
0
Explicit exclusions
7
Normalized price rows
199,952
Price types
Type
Price rows
Bidder
199,952
Annual coverage
Year
Price rows
2024
66,709
2025
80,065
2026
53,178
Source statuses
Status
Sources
Parsed
45
Context Only
26
Not Acquired
2
No Item Prices Found
1
Review closeout
Status
Rows
Pending Manual Review
19,420
Common items
Item
Price rows
MOBILIZATION
7,674
TRAFFIC CONTROL
6,920
PAINTED PAVEMENT MARKINGS, WATERBORNE OR SOLVENT-BASED
2,780
FLAGGERS
2,723
SAFETY CLOSURE
2,521
REMOVAL OF PAVEMENT
2,293
CONSTRUCTION SURVEY
2,134
ENGINEERING FABRIC
2,025
Iowa DOT Phase 1 removes no duplicate render layers; anomaly rows are preserved in review rather than inferred across alternate sections.
Kansas DOT
Awarded-item CSV history is live.
Kansas Phase 1 saves KDOT current and historical bid-tab indexes, month-coded awarded-item CSVs, complete-bid context, and public-access boundaries for Bid Express, KART, retired ASP paths, proposals, and archives. The normalized layer promotes awarded-vendor item rows only; bidder-rank PDF columns and engineer estimates are not inferred from the CSV source.
Kansas Phase 1 coverage
Metric
Count
Source inventory rows
281
Checksummed sources
253
Awarded-item CSVs
235
Current snapshots excluded
2
Awarded-vendor rows
569,210
Contracts
6,202
Bid item occurrences
224,710
Duplicate render layers removed
0
Explicit exclusions
32
Normalized price rows
569,210
Price types
Type
Price rows
Awarded Vendor Item Price
569,210
Annual coverage
Year
Price rows
2006
27,834
2007
25,774
2008
28,468
2009
39,634
2010
32,634
2011
37,041
2012
30,699
2013
36,034
2014
32,482
2015
32,108
2017
20,891
2018
19,314
2019
25,849
2020
26,131
2021
33,564
2022
24,236
2023
23,403
2024
32,625
2025
29,468
2026
10,319
Source statuses
Status
Sources
Parsed Awarded Item Csv
235
Not Parsed Context
23
Unavailable Filename Pattern
19
Parsed Index Context
2
Parsed Current Snapshot Excluded
2
Review closeout
Status
Rows
Excluded From Normalized
4,732
Common items
Item
Price rows
MOBILIZATION
20,545
TRAFFIC CONTROL
12,399
FIELD OFFICE AND LABORATORY (TYPE A)
8,407
REMOVAL OF EXISTING STRUCTURES
7,229
MILLING
7,119
CONTRACTOR CONSTRUCTION STAKING
6,355
REINFORCING STEEL (GRADE 60)
5,796
FLAGGER (SET PRICE)
5,548
KDOT Phase 1 removes no duplicate render layers; repeated awarded CSV rows are counted in review and bidder-level PDF layouts remain separate.
Kentucky TC
Annual awarded averages are live.
Kentucky Phase 1 saves KYTC Unit Bid Tabulations PDFs, Letting Results PDFs, SharePoint archive pages, and Average Unit Bid Prices workbooks. The normalized layer promotes only annual awarded aggregate average unit prices from OOXML workbooks; bidder-level PDF layouts and legacy binary XLS workbooks stay in review.
Kentucky Phase 1 coverage
Metric
Count
Source inventory rows
300
Checksummed sources
300
Average-price XLSX
11
Legacy binary XLS
19
Unit Bid Tab PDFs
255
Letting Results PDFs
9
Aggregate average rows
15,562
Bid item occurrences
15,562
Duplicate render layers removed
0
Explicit exclusions
10
Normalized price rows
15,562
Price types
Type
Price rows
Aggregate Awarded Average Unit Price
15,562
Annual coverage
Year
Price rows
2012
1,592
2013
1,410
2014
1,609
2015
1,729
2017
1,267
2019
1,323
2021
1,330
2022
1,382
2023
1,335
2024
1,249
2025
1,336
Source statuses
Status
Sources
Bidtab Pdf Layout Review
255
Legacy Binary Xls Review
19
Parsed Average Xlsx
11
Letting Result Context Only
9
Source Page Acquired
6
Review closeout
Status
Rows
Excluded From Normalized
292
Included With Source Anomaly
4
Common items
Item
Price rows
DURABLE WATERBORNE MARKING-6 IN W
27
DURABLE WATERBORNE MARKING-6 IN Y
27
SITE PREPARATION
27
REMOVE
23
MAINTAIN & CONTROL TRAFFIC
21
PARTIAL DEPTH PATCHING
20
CLEAN
20
REPLACE GRATE
20
KYTC Phase 1 removes no duplicate render layers; bid-tab PDFs and aggregate workbooks are distinct official sources with separate review paths.
Louisiana DOTD
Bid tabs and weighted averages are live.
Louisiana Phase 1 saves LADOTD current Construction Letting dropdowns, official bid-tab detail pages, Standard Item File weighted-average CSV exports, result/context pages, and archive-boundary probes. The normalized layer keeps contract-level bidder item prices separate from aggregate weighted-average rows.
LADOTD Phase 1 removes no duplicate render layers; bid-tab HTML rows and Standard Item File aggregate CSV rows are distinct source surfaces.
Maine DOT
Legacy bid tabs are normalized.
Maine Phase 1 saves the official 2011-2024 archive indexes, project detail pages, resolved bid-tab PDFs, current/archive context, and public-access boundaries. The normalized layer promotes bidder item unit-price rows only; vendor-ranking contract totals and project context documents stay out of item prices.
Maine Phase 1 coverage
Metric
Count
Source inventory rows
7,265
Checksummed sources
5,830
Archive year pages
14
Project detail pages
3,862
Bid-tab PDFs
3,378
Parsed bid-tab PDFs
1,110
Bidder item rows
95,735
Contracts
1,110
Bid item occurrences
36,647
Duplicate render layers removed
0
Explicit exclusions
19,143
Normalized price rows
95,735
Price types
Type
Price rows
Bidder Unit Price
95,735
Annual coverage
Year
Price rows
2018
17,616
2019
13,847
2020
15,828
2021
12,246
2022
11,262
2023
14,266
2024
10,670
Source statuses
Status
Sources
Project Detail Checksummed
3,862
Not Acquired
1,435
Parsed Bidder Item Rows
1,110
No Rows Extracted
834
Archive Year Index Checksummed
14
Checksummed Context Not Normalized
10
Review closeout
Status
Rows
Excluded From Normalized
6,933
Common items
Item
Price rows
MOBILIZATION
2,113
TEMPORARY SOIL EROSION AND WATER POLLUTION CONTROL
1,827
CONSTRUCTION SIGNS
1,747
CONE
1,700
FLAGGER
1,693
MAINTENANCE OF TRAFFIC CONTROL DEVICES
1,674
HAND LABOR, STRAIGHT TIME
1,625
TRUCK - LARGE (INCLUDING OPERATOR)
1,559
MaineDOT Phase 1 removes no duplicate render layers; direct text extraction is used only on official bid-tab item tables.
Massachusetts DOT
Weighted bid prices are aggregate observations.
Massachusetts Phase 1 parses the official CPE Book response as mean and median bid-price aggregates. Contract-level bidder, rank, and project-search records stay blank or explicitly bounded because the public Book view does not publish those fields.
MassDOT Phase 1 coverage
Metric
Count
Source inventory rows
14
Checksummed sources
10
Item catalog rows
605
Weighted Book sources
1
Parsed Book sources
1
Book aggregate rows
3,776
Mean price rows
3,776
Median price rows
3,776
Bid item occurrences
3,776
Explicit exclusions
10
Normalized price rows
7,552
Price types
Type
Price rows
Massdot Weighted Average Median
3,776
Massdot Weighted Average Mean
3,776
Annual coverage
Year
Price rows
2026
7,552
Source statuses
Status
Sources
Context
12
Parsed
1
Parsed Item Catalog
1
Exclusion statuses
Status
Sources
Classified Access Boundary
10
Common items
Item
Price rows
CLEAN (FULL REMOVAL) AND PAINT STEEL BRIDGE NO. _____
34
TREE TRIMMING
32
CLEAN (FULL REMOVAL) AND PAINT STEEL BRIDGE NO. ________
32
DENSE GRADED CRUSHED STONE FOR SUB-BASE
24
MODIFIED ROCKFILL
24
HOT MIX ASPHALT WATERWAY
20
HIGH EARLY STRENGTH CEMENT CONCRETE BASE COURSE
20
DEMOLITION OF SUPERSTRUCTURE OF BRIDGE NO. _____
18
MassDOT CPE Book rows are aggregate mean/median observations; no duplicate render layers were removed.
Minnesota DOT
Awarded abstracts carry CSV item rows.
Minnesota Phase 1 saves the official MnDOT awarded-abstract app indexes, contract CSV abstracts, and eDOCS Average Bid Prices workbooks. Bidder and engineer-estimate item rows remain separate from annual average bid-price aggregate rows.
Minnesota Phase 1 coverage
Metric
Count
Source inventory rows
5,576
Checksummed sources
5,576
Abstract index pages
30
Abstract CSV sources
5,525
Average Bid Prices XLSX
10
Engineer estimate rows
145,122
Bidder item rows
545,828
Average aggregate rows
20,813
Contracts
1,742
Bid item occurrences
165,936
Explicit exclusions
19
Normalized price rows
711,763
Price types
Type
Price rows
Mndot Bidder Item
545,828
Mndot Engineer Estimate Item
145,122
Mndot Average Bid Price Aggregate
20,813
Annual coverage
Year
Price rows
2016
60,632
2017
90,969
2018
69,716
2019
52,033
2020
59,263
2021
59,756
2022
62,418
2023
60,723
2024
74,654
2025
68,826
2026
52,773
Source statuses
Status
Sources
Parsed No Rows
3,783
Parsed
1,752
Parsed Link Inventory
28
Excluded Duplicate Pdf Render
10
No Contract Links
2
Parsed Document Inventory
1
Review closeout
Status
Rows
Included With Source Anomaly
44,622
Excluded From Normalized
3,801
Common items
Item
Price rows
TRAFFIC CONTROL
7,406
MOBILIZATION
5,598
AS BUILT
3,907
COMMON EMBANKMENT (CV)
3,761
EXCAVATION - COMMON
3,748
GRUBBING
3,542
MAINT AND RESTORATION OF HAUL ROADS
3,448
SAWING BITUMINOUS PAVEMENT (FULL DEPTH)
3,432
Minnesota Phase 1 removes duplicate PDF render layers only where same-title eDOCS workbooks are parsed.
Mississippi DOT
Bid-tab PDFs expose ranked item prices.
Mississippi Phase 1 saves the official MDOT portal archive response, current and archived letting calendars, project detail pages, letting-level result PDFs, and project bid-tab PDFs. Normalized rows come only from item-level bidder-rank unit prices; contract-level engineer estimates, award PDFs, checked results, and legacy archive gaps stay in review or exclusion queues.
Mississippi Phase 1 coverage
Metric
Count
Source inventory rows
4,237
Checksummed sources
4,237
Portal archive API
1
Letting calendars
23
Letting detail pages
367
Bid-tab PDFs
2,821
Parsed bid-tab PDFs
1,999
Letting result PDFs
1,025
Bidder rank rows
252,696
Contracts
1,999
Bid item occurrences
96,085
Explicit exclusions
1,052
Normalized price rows
252,696
Price types
Type
Price rows
Msdot Bidder Rank Item
252,696
Annual coverage
Year
Price rows
2006
340
2007
14,741
2008
11,200
2009
24,999
2010
16,554
2011
14,525
2012
18,485
2013
15,866
2014
15,269
2018
6,687
2019
18,655
2020
11,906
2021
14,423
2022
12,126
2023
13,285
2024
18,030
2025
14,855
2026
10,750
Source statuses
Status
Sources
Parsed Bid Tab Pdf
1,999
Contract Level Result Not Item Prices
1,025
Bid Tab Pdf No Rows
822
Parsed Project Links
367
Parsed Calendar Links
23
Parsed Archive Year Links
1
Review closeout
Status
Rows
Excluded From Normalized
68,114
Common items
Item
Price rows
Maintenance of Traffic
4,859
Mobilization
3,943
Thermoplastic Legend, White
3,537
Two-Way Yellow Reflective High Performance Raised Markers
3,353
Temporary Traffic Stripe, Legend
3,175
Temporary Traffic Stripe, Continuous White
2,869
Temporary Traffic Stripe, Continuous Yellow
2,862
Asphalt for Tack Coat
2,518
Mississippi Phase 1 removes no duplicate render layers; repeated ref/item rows are kept distinct with stable row-fingerprint occurrence IDs.
Missouri DOT
Unit Bid Books publish aggregate prices.
Missouri Phase 1 saves the official MoDOT Plans Room Unit Bid Price Book PDFs for 2021 through 2025 plus source-boundary evidence for Plans Room, Bid Express, EPG policy, bid item catalog, retired legacy paths, and public-records fallback. Normalized rows represent only annual district/statewide aggregate unit-price observations.
Missouri Phase 1 coverage
Metric
Count
Source inventory rows
16
Checksummed sources
16
Unit Bid Price Books
5
Parsed Unit Bid Price Books
5
Aggregate price rows
18,470
Contracts
0
Bid item occurrences
18,470
Duplicate render layers removed
0
Explicit exclusions
7
Normalized price rows
18,470
Price types
Type
Price rows
Modot Unit Bid Price Aggregate
18,470
Annual coverage
Year
Price rows
2021
3,634
2022
3,642
2023
3,613
2024
3,763
2025
3,818
Source statuses
Status
Sources
Source Boundary Only
11
Parsed
5
Review closeout
Status
Rows
Included With Source Anomaly
351
Excluded From Normalized
145
Common items
Item
Price rows
PREFORMED THERMOPLASTIC
470
GRAVEL (A) OR CRUSHED STONE (B)
76
TYPE A2 SHOULDER
64
BITUMINOUS PAVEMENT MIXTURE
60
PULL BOX, PREFORMED CLASS 1
60
PULL BOX, PREFORMED CLASS 2
60
CABLE, 10 AWG 1 CONDUCTOR, POLE AND BRACKET
58
FINISH FIELD COAT (SYSTEM G)
54
Missouri Phase 1 removes no duplicate render layers; aggregate rows keep contract-level bidder and engineer-estimate semantics out of normalized price rows.
Montana DOT
Bid Tabs keep engineer and bidder rows separate.
Montana Phase 1 saves official MDT Bid Tabs, Weighted Average Prices, Award Sheets, current as-read, archive-capture, and access-boundary evidence. Normalized rows preserve Bid Tab engineer estimates, bidder item prices, and annual weighted-average aggregates as separate price types.
Montana Phase 1 coverage
Metric
Count
Source inventory rows
45
Checksummed sources
45
Bid Tabs
10
Parsed Bid Tabs
8
Average Prices
10
Parsed Average Prices
10
Award Sheets
10
Engineer estimate rows
32,021
Bidder item rows
99,764
Weighted aggregate rows
7,441
Contracts
650
Bid item occurrences
39,682
Explicit exclusions
8
Normalized price rows
139,226
Price types
Type
Price rows
Mtdot Bidder Item
99,764
Mtdot Engineer Estimate Item
32,021
Mtdot Weighted Average Aggregate
7,441
Annual coverage
Year
Price rows
2016
821
2017
758
2018
832
2019
892
2020
711
2021
672
2022
670
2023
691
2024
676
2025
718
Source statuses
Status
Sources
Source Boundary Only
14
Parsed Weighted Average Pdf
10
Checksummed Award Context Not Normalized
10
Parsed Bid Tab Pdf
8
Layout Review No Normalized Rows
2
Checksummed Current Boundary Not Normalized
1
Review closeout
Status
Rows
Needs Review
1,258
Common items
Item
Price rows
MISCELLANEOUS WORK
2,572
MOBILIZATION
2,571
STRIPING-WHITE EPOXY
1,887
STRIPING-YELLOW EPOXY
1,881
STRIPING-YELLOW PAINT
1,758
STRIPING-WHITE PAINT
1,753
EMULSIFIED ASPHALT-TACK COAT
1,639
REMOVE SIGN
1,635
Montana Phase 1 removes no duplicate render layers; older unresolved text-layer rows stay in review rather than being normalized under guessed identities.
Nebraska DOT
Average unit prices stay aggregate.
Nebraska Phase 1 saves official NDOT current average-unit-price PDFs, retired NDOR English and metric AUP reports, Bid Express and report-server access boundaries, and representative legacy bid-tab context. Normalized rows are aggregate AUP observations only; bidder/rank and engineer-estimate fields remain empty instead of being inferred from aggregate reports.
Nebraska Phase 1 coverage
Metric
Count
Source inventory rows
39
Checksummed sources
39
Current AUP PDFs
19
Legacy AUP PDFs
8
Parsed AUP PDFs
27
English aggregate rows
28,577
Metric aggregate rows
1,714
Report occurrences
27
Bid item occurrences
30,291
Explicit exclusions
11
Normalized price rows
30,291
Price types
Type
Price rows
Ndot Average Unit Price Aggregate
28,577
Ndot Metric Average Unit Price Aggregate
1,714
Annual coverage
Year
Price rows
2000
998
2001
2,280
2002
1,419
2016
1,342
2017
2,786
2018
3,054
2019
3,145
2020
2,849
2021
2,497
2022
2,577
2023
2,540
2024
2,247
2025
2,557
Source statuses
Status
Sources
Parsed
27
Source Boundary Context
12
Review closeout
Status
Rows
Preserved For Qa
8,467
Source Page Anomaly Preserved
35
Common items
Item
Price rows
MOBILIZATION
367
PREPARATION OF STRUCTURE
194
REMOVE STRUCTURE
174
MANHOLE
167
OVERHEAD SIGN SUPPORT, LOCATION
139
COLD MILLING, CLASS 3
137
REMOVE
122
REMOVE BUILDING
89
Nebraska Phase 1 removes no duplicate render layers; split PDF columns are paired by explicit text coordinates or table order, and rounded aggregate-total differences remain in review.
Nevada DOT
Archived portal totals stay contract-level.
Nevada Phase 1 saves NDOT Contract Services, Active and Awarded Contracts, archived EBidding contract-list/detail pages, Bid Express, bid-tab policy, and public-records boundaries. The recovered rows are EBidding bidder and award contract totals only; bid-item and average-unit-price routes remain explicit source boundaries.
Nevada Phase 1 coverage
Metric
Count
Source inventory rows
40
Checksummed sources
40
Archived contract details
7
Parsed contract details
5
Archived bidder rows
25
Contract bid total rows
13
Contract award total rows
4
Contracts
5
Bid item occurrences
0
Explicit exclusions
8
Normalized price rows
17
Price types
Type
Price rows
Nvdot Contract Bid Total
13
Nvdot Contract Award Total
4
Annual coverage
Year
Price rows
2018
7
2021
5
2022
5
Source statuses
Status
Sources
Source Boundary Only
33
Parsed Contract Totals
5
No Usable Bid Amounts
2
Review closeout
Status
Rows
Excluded From Normalized Prices
8
Common descriptions
Description
Price rows
Widen from 4 to 6 lanes
5
Install complete street design with pedestrian, bike, and ADA improvements
4
reconstruct pavement
3
Pedestrian and ADA improvements
3
cold mill and place plantmix bituminous surface with open grade, widen for a third lane, striping and signs
2
Nevada Phase 1 removes no duplicate render layers; zero BidAmount and 9999999999.99 portal sentinel rows are preserved in review and excluded from normalized prices.
New Hampshire DOT
Current weighted-average rows stay aggregate.
New Hampshire Phase 1 saves the NHDOT bid-result library boundary, document-list API evidence, direct-fetch 403 evidence, and the current weighted-average unit-price PDF recovered from an official archive capture. The normalized rows are aggregate average unit prices only; current bid-item advertisements, iPD, Box proposal packages, CCI reports, and public-records routes remain explicit source boundaries.
New Hampshire Phase 1 coverage
Metric
Count
Source inventory rows
17
Checksummed sources
17
Weighted-average PDFs
1
Parsed weighted-average PDFs
1
Aggregate price rows
1,308
Report occurrences
1
Bid item occurrences
1,308
Duplicate render layers removed
0
Explicit exclusions
7
Normalized price rows
1,308
Price types
Type
Price rows
Nhdot Weighted Average Unit Price Aggregate
1,308
Annual coverage
Year
Price rows
2025
1,308
Source statuses
Status
Sources
Source Boundary
16
Parsed
1
Review closeout
Status
Rows
Closed Parser Used Ocr
52
Common descriptions
Description
Price rows
COFFERDAMS
20
BRIDGE WASHING
11
WATER DIVERSION STRUCTURE
8
PREFABRICATED STRIP SEAL EXPANSION JOINT (F)
7
CONSTRUCT AND REMOVE TEMPORARY ACCESS ROAD
7
UNIFORMED OFFICERS WITH VEHICLE
6
MAINTENANCE OF TRAFFIC
6
TURF ESTABLISHMENT WITH MULCH AND TACKIFIERS
6
New Hampshire Phase 1 uses rendered OCR because the PDF text layer is custom-font encoded; no duplicate render layers were removed.
Michigan DOT
Letting workbooks keep bidder rows separate.
Michigan Phase 1 saves MDOT BidLetting detail pages, accepted/as-read result boundaries, btaexcel item workbooks, and recent Michigan.gov weighted-average reports. The normalized layer promotes workbook engineer-estimate, bidder-rank, and aggregate average rows without treating contract-level result PDFs as item prices.
Michigan Phase 1 coverage
Metric
Count
Source inventory rows
1,975
Checksummed sources
1,975
Letting detail pages
621
Btaexcel workbooks
235
Parsed btaexcel sources
233
Weighted-average sources
3
Parsed weighted-average sources
3
Engineer estimate rows
560,613
Bidder rank rows
2,121,960
Weighted-average rows
108,216
Contracts
7,732
Bid item occurrences
612,387
Explicit exclusions
1,424
Normalized price rows
2,790,789
Price types
Type
Price rows
Mdot Bidder Rank Item
2,121,960
Mdot Engineer Estimate Item
560,613
Mdot Weighted Average Award Price
54,109
Mdot Weighted Average Low Three
54,107
Annual coverage
Year
Price rows
2015
244,491
2016
262,786
2017
255,451
2018
245,319
2019
245,962
2020
226,338
2021
241,159
2022
218,333
2023
228,010
2024
228,099
2025
245,649
2026
149,192
Source statuses
Status
Sources
Contract Level Result Not Item Prices
1,111
Parsed Link Inventory
618
Parsed Btaexcel Xlsx
233
Source Boundary Inventory
7
Parsed Weighted Average Xlsx
3
Btaexcel No Rows
2
Parsed Letting Dates
1
Review closeout
Status
Rows
Excluded From Normalized
16,482
Included With Source Anomaly
3,227
Common items
Item
Price rows
Minor Traf Devices
34,711
Sign, Type B, Temp, Prismatic, Oper
34,026
Sign, Type B, Temp, Prismatic, Furn
34,021
Traf Regulator Control
23,516
Lighted Arrow, Type C, Oper
22,501
Lighted Arrow, Type C, Furn
22,498
Barricade, Type III, High Intensity, Double Sided, Lighted, Oper
19,830
Barricade, Type III, High Intensity, Double Sided, Lighted, Furn
19,823
Michigan Phase 1 removes no duplicate render layers; normalized rows come from official XLSX cell values.
Maryland SHA
Price Index rows stay semantic.
Maryland Phase 1 saves the official MDOT SHA Price Index page and semiannual documents from 2008-2026. The normalized layer promotes proposal/item unit-price observations from structured workbooks and parseable PDF text only; Bid Express, eMMA, legacy binary/archive files, and text-layer-limited PDFs stay explicit boundaries.
Maryland Phase 1 coverage
Metric
Count
Source inventory rows
58
Checksummed sources
51
Price Index documents
50
Parsed Price Index sources
24
PDF text-layer boundaries
14
Price Index rows
204,474
Proposals
2,658
Bid item occurrences
204,474
Duplicate render layers removed
5
Explicit exclusions
7
Normalized price rows
204,474
Price types
Type
Price rows
Mdotsha Price Index Observation
204,474
Annual coverage
Year
Price rows
2013
5,176
2014
30,432
2015
20,894
2016
24,168
2017
24,574
2018
19,136
2019
16,996
2020
12,843
2021
5,836
2022
13,930
2023
11,524
2024
3,973
2025
11,206
2026
3,786
Source statuses
Status
Sources
Parsed
24
Pdf Text Layer Unusable
14
Context
8
Legacy Binary Or Archive Not Parsed Pdf Used
7
Duplicate Print Rendition Not Parsed
5
Review closeout
Status
Rows
Included With Source Flag
10,514
Common items
Item
Price rows
MAINTENANCE OF TRAFFIC
3,626
PROTECTION VEHICLE
3,031
DRUMS FOR MAINTENANCE OF TRAFFIC
2,237
PORTABLE VARIABLE MESSAGE SIGN
2,081
ARROW PANEL
2,036
PRICE ADJUSTMENT FOR ASPHALT BINDER
1,678
PRICE ADJUSTMENT FOR DIESEL FUEL
1,527
PAYMENT ADJUSTMENT FOR PAVEMENT DENSITY
1,510
MDOT SHA duplicate render layers are skipped only when a same-period official workbook is parsed instead of its PDF print rendition.
Oregon DOT
Official annual bid prices are live.
Oregon Phase 5 closes the public-access archive: recovered contract and aggregate prices retain source-occurrence identity, while missing retired files are explicitly classified instead of left as parser failures.
Oregon Phase 5 closeout
Metric
Count
Annual workbook sources
6
Historical boundaries reviewed
7
Retired archives mapped
5
Legacy price rows
12,793
Legacy contracts
90
Aggregate price rows
7,146
Active source blocks
0
Closed access boundaries
4
Verified price rows
139,759
Contracts
461
Rows in review
0
Price types
Type
Price rows
Bidder
132,217
Weighted Average Awarded
3,573
Weighted Average Low 3 Bidders
3,573
Independent Cost Estimate
396
Annual coverage
Year
Price rows
2018
16,625
2020
3,314
2021
25,799
2022
20,790
2023
15,556
2024
29,226
2025
14,967
2026
13,482
Historical source boundary
Years
Source
Status
2000-2015
Legacy Public Archive
No Public Source Located
2016
Retired Awarded And Weighted Average Pdf
Official Link Verified File Not Archived
2017
Retired Awarded And Weighted Average Pdf
Official Link Verified File Not Archived
2018
Retired Awarded And Weighted Average Pdf
Recovered Official Sources Ingested
2019
Retired Awarded And Weighted Average Pdf
Official Reports Mapped No 2019 Rows Recoverable
2020
Retired Weighted Average Pdf
Retired Aggregate Pdf Archive Ingested
2021-2026
Annual Bid Data Workbook
Open Workbook Ingested
The recovered 2019-titled report contains source rows explicitly labeled calendar year 2018. Weighted-average rows are aggregate evidence and are not counted as contracts.
Common Oregon units
Unit
Price rows
EACH
50,138
FOOT
26,067
SQFT
13,835
LS
12,597
SQYD
11,652
CUYD
7,935
TON
6,113
LB
4,165
Common Oregon items
Item
Price rows
TEMPORARY SIGNS
1,466
POLLUTION CONTROL PLAN
1,421
TEMPORARY BARRICADES, TYPE III
1,354
FLAGGERS
1,353
TEMPORARY PLASTIC DRUMS
1,343
AGGREGATE BASE
1,159
PORTABLE CHANGEABLE MESSAGE SIGNS
1,129
SIGN SUPPORT FOOTINGS
1,091
Verified rows come directly from official ODOT annual bid-data workbooks.
OCR recovery mix
Basis
Records
Contract Total
117
Small Works Base Bid
61
Base Total
13
Single Reported Total
7
Total Bid Price
5
One Page Award Summary
4
Stacked Total
4
Summary Total
4
Design Build Proposal Price
3
Proposal Schedule Total
2
Small Works Total Bid
2
Lump Sum Bid
1
One Page Bidder Amounts
1
Total Base Bid
1
Total Contract Price
1
Blocked source closeouts
Reason
PDFs
OCR text has money values but no supported total-row pattern
11
OCR text produced no parseable money values
3
small-works/table layout remains blocked by OCR quality or ambiguous totals
2
one-page award summary has money values but insufficient total context
1
Trends
Bid history is becoming a market signal.
WSDOT contractsContract counts come from normalized low-bid records with usable contract dates.Average bidder countBidder count is the visible competitive field on the WSDOT bid summary.Bid pressureAvg spreadAvg estimate deltaSpread excludes obvious display/OCR outliers above 200%; estimate delta is low bid versus engineer estimate.
Recent annual WSDOT bid summary
Year
Contracts
Total low bid
Avg low bid
Avg spread
Avg bidders
Avg est. delta
2017
139
$373.7M
$2.7M
16.41%
2.44
-12.63%
2018
140
$397.4M
$2.8M
17.80%
2.24
-8.15%
2019
114
$412.1M
$3.6M
19.86%
2.53
-13.81%
2020
95
$597.7M
$6.3M
16.36%
2.59
-18.21%
2021
96
$838.2M
$8.7M
14.40%
2.27
-8.47%
2022
113
$627.8M
$5.6M
24.97%
2.32
-19.70%
2023
95
$646.3M
$6.8M
17.70%
2.77
-15.70%
2024
47
$161.9M
$3.4M
17.08%
2.38
-20.12%
2025
56
$367.5M
$6.6M
13.16%
2.45
-10.81%
2026
45
$357.3M
$7.9M
10.18%
4.18
-10.01%
Average spread excludes obvious OCR/display outliers above 200%; raw values stay in the CSV for audit.
QA signals
Records now carry review flags.
QA flag counts
Flag
Contracts
Large estimate delta
907
Single bidder
775
Needs review
224
OCR-derived
224
Extreme spread
115
$50M+ low bid
38
Flags are generated from normalized fields and observation review status; they do not change the underlying totals.
Bid-spread distribution
Spread bucket
Contracts
0-5%
1,057
5-10%
671
10-25%
680
25-50%
231
50-100%
96
100%+
135
Spread buckets use low bid to second bid where a second bid is available.
Searchable register
Find a WSDOT contract in the live archive.
0 shown · 3,644 searchable
Loading contract register...
Contract
Year
Name
Low bid
Engineer est.
Bidders
Spread
QA
Contract samples
Big bids and tight spreads, pulled from the same evidence spine.
Largest low bids
Contract
Name
Low bid
Engineer est.
Bidders
Spread
6441
CONTRACT 6441 TACOMA NARROWS BRIDGE
$615.0M
$615.0M
1
n/a
9540
I-5 to SR 509 - New Expressway Project
$449.5M
$376.0M
1
n/a
7963
CONTRACT 7963 Executed 11/29/10 EASTSIDE TRANSIT AND HOV DESIGN-BUILD
$306.3M
$386.1M
2
19.34%
9424
SR 509 COMPLETION STAGE 1B
$264.0M
$329.9M
2
20.28%
9786
Cabin Creek I/C to W Easton I/C Phase 3 Add Lanes/Wildlife Bridges
$249.3M
$251.6M
6
14.49%
6525
CONTRACT 6525 SR 104, HOOD CANAL BRIDGE RETROFIT AND EAST-HALF REPLACEMENT
$204.0M
$258.5M
2
24.44%
8625
SR 520, MONTLAKE TO EVERGREEN PT. BRIDGE - WEST APPROACH BRIDGE NORTH
$199.5M
$249.9M
3
7.72%
XE3694
US 395, NSC Sprague Ave to Spokane River - Stage 2