Task: Data-transform-reshape (source dataset: Auto-Tables)

Given a table, predict what python pandas transformation may be needed on the given input table. Valid choices for transformation include: {"stack", "wide_to_long", "transpose", "pivot", "explode", "ffill", "subtitles"}. Note that each of these is a common Python Pandas operator. Some transformations can have parameters. Each transformation and its parameters are describe as follows.
 
- stack: collapse homogeneous cols into rows.
@param (int): stack_start_idx: zero-based starting column index of the homogeneous column-group.
@param (int): stack_end_idx: zero-based ending column index of the homogeneous column-group.
 
- wide_to_long: collapse repeating col-groups into rows.
@param (int): wide_to_long_start_idx: zero-based starting column index of the repeating col-groups.
@param (int): wide_to_long_end_idx: zero-based ending column index of the repeating col-groups.
 
- transpose: convert rows to columns and vice versa.
 
- pivot: pivot repeating row-groups into cols.
@param (int): pivot_row_frequency: frequency of repeating row-groups.
 
- ffill: fill structurally empty cells in tables.
@param (int): ffill_end_idx: zero-based ending column index of the columns to be filled.
 
- explode: convert composite cells into atomic values
@param (int): explode_column_idx: zero-based column index of the column to be exploded.
 
- subtitle: convert table subtitles into a column.
 
OUTPUT the predicted transformation name along with its parameters for the given INPUT table in a JSON, e.g., {"transformation": "stack", "stack_start_idx": 1, "stack_end_idx": 5}. If the input table needs multi-step transformations (e.g, ffill followed by stack), list JSON of each transformation sequentially in a list, e.g., [{"transformation": "ffill", "ffill_end_idx": 1}, {"transformation": "stack", "stack_start_idx": 1, "stack_end_idx": 5}]. No explanation is needed.

## Input:
| Hispanic American                | Column1   | Dollars           | M/F   | Contract   | prime comment                                                  | Contract Comment   | Districts                  | Prime   |
|:---------------------------------|:----------|:------------------|:------|:-----------|:---------------------------------------------------------------|:-------------------|:---------------------------|:--------|
| 3531 TRUCKING                    | 43.0      | 660000.0          | 0.0   | 1.0        | C.A.RASMUSSEN INC                                              | 08-0P3904          | 4,8                        | 1.0     |
| A & M CONSULTING ENGINEERS       | -4142.0   | 190800.0          | 0.0   | 10.0       | GHILOTTI BROS., INC.                                           | 03-4F8404          | 3, 4                       | 4.0     |
|                                  |           |                   |       |            | GOLDEN STATE BRIDGE, INC.                                      | 03-3F5504          |                            |         |
|                                  |           |                   |       |            | O.C. JONES & SONS INC                                          | 03-0H4704          |                            |         |
|                                  |           |                   |       |            | Q&D CONSTRUCTION LLC                                           | 04-270104          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-2J5404          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-3G6904          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G5604          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-OK8404          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-2J1004          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4K1104          |                            |         |
| ABSL CONSTRUCTION                | -4142.0   | 4918680.5         | 0.0   | 35.0       | AMERICAN CIVIL CONSTRUCTORS WEST COAST LLC                     | 10-1E3504          | 1,3,4,5,6,8,10             | 17.0    |
|                                  |           |                   |       |            | BAY CITIES PAVING & GRADING, INC.                              | 01-0A0404          |                            |         |
|                                  |           |                   |       |            | BALDWIN CONTRACTING COMPANY                                    | 04-1J3704          |                            |         |
|                                  |           |                   |       |            | BRIDGEWAY CIVIL CONSTRUCTORS, INC                              | 08-0K2934          |                            |         |
|                                  |           |                   |       |            | CALPORTLAND COMPANY                                            | 05-1C6504          |                            |         |
|                                  |           |                   |       |            | COFFMAN SPECIALTIES                                            | 05-1F7604          |                            |         |
|                                  |           |                   |       |            | DESILVA GATES CONSTRUCTION                                     | 04-3J9004          |                            |         |
|                                  |           |                   |       |            | FLATIRON WEST INC                                              | 03-2F3204          |                            |         |
|                                  |           |                   |       |            | GEORGE REED INC                                                | 10-0L0204          |                            |         |
|                                  |           |                   |       |            | GHILOTTI BROTHERS INC                                          | 06-394604          |                            |         |
|                                  |           |                   |       |            | GHILOTTI CONSTRUCTION COMPANY INC                              | 01-0H3604          |                            |         |
|                                  |           |                   |       |            | GORDON N. BALL, INC.                                           | 02-4H2004          |                            |         |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 04-151614          |                            |         |
|                                  |           |                   |       |            | GRANITE ROCK COMPANY                                           | 04-4G1134          |                            |         |
|                                  |           |                   |       |            | HAT CREEK CONSTRUCTION & MATERIALS, INC.                       | 05-0A0504          |                            |         |
|                                  |           |                   |       |            | LAMON CONSTRUCTION CO INC                                      | 05-1A0004          |                            |         |
|                                  |           |                   |       |            | M.C.M. CONSTRUCTION INC                                        | 10-1C2904          |                            |         |
|                                  |           |                   |       |            | O.C. JONES & SONS, INC.                                        | 03-2G3404          |                            |         |
|                                  |           |                   |       |            | TEICHERT CONSTRUCTION                                          | 04-2J1004          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G8404          |                            |         |
|                                  |           |                   |       |            |                                                                | 05-1C2504          |                            |         |
|                                  |           |                   |       |            |                                                                | 05-1C85U4          |                            |         |
|                                  |           |                   |       |            |                                                                | 05-1K3304          |                            |         |
|                                  |           |                   |       |            |                                                                | 06-0T2104          |                            |         |
|                                  |           |                   |       |            |                                                                | 03-1F1904          |                            |         |
|                                  |           |                   |       |            |                                                                | 03-0H5104          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G3804          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4K1104          |                            |         |
|                                  |           |                   |       |            |                                                                | 10-1H4704          |                            |         |
| ALL STATE TRUCKING               | 43.0      | 658690.0          | 0.0   | 3.0        | SEMA CONSTRUCTION INC                                          | 06-0S5504          | 6,7,8                      | 1.0     |
|                                  |           |                   |       |            |                                                                | 07-312604          |                            |         |
|                                  |           |                   |       |            |                                                                | 08-0F0304          |                            |         |
| ANCO IRON & CONSTRUCTION, INC.   | -4142.0   | 1206045.56        | 0.0   | 1.0        | GOLDEN STATE BRIDGE, INC.                                      | 03-3F5504          | 3                          | 1.0     |
| AUSTIN ENTERPRISE                | -4142.0   | 3705737.28        | 1.0   | 21.0       | BAY CITIES PAVING & GRADING, INC.                              | 06-0Q2804          | 4, 5, 6, 7, 10             | 15.0    |
|                                  |           |                   |       |            | BRIDGEWAY CIVIL CONSTRUCTORS, INC                              | 04-3J9004          |                            |         |
|                                  |           |                   |       |            | BROSAMER & WALL INC                                            | 06-0H2004          |                            |         |
|                                  |           |                   |       |            | CALPORTLAND COMPANY                                            | 06-0P9004          |                            |         |
|                                  |           |                   |       |            | GHILOTTI BROS., INC.                                           | 04-4G8804          |                            |         |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 04-4H0804          |                            |         |
|                                  |           |                   |       |            | GRANITE ROCK COMPANY                                           | 05-0A0504          |                            |         |
|                                  |           |                   |       |            | DISNEY CONSTRUCTION COMPANY                                    | 07-4W0804          |                            |         |
|                                  |           |                   |       |            | OHL USA                                                        | 10-1C2904          |                            |         |
|                                  |           |                   |       |            | RV CONCRETE, INC                                               | 04-3G6904          |                            |         |
|                                  |           |                   |       |            | SECURITY PAVING COMPANY                                        | 05-1F75U4          |                            |         |
|                                  |           |                   |       |            | SEMA CONSTRUCTION                                              | 06-0S5504          |                            |         |
|                                  |           |                   |       |            | A. TEICHERT & SON, INC. DBA TEICHERT CONSTRUCTION              | 06-0Q19A4          |                            |         |
|                                  |           |                   |       |            | VIKING CONSTRUCTION COMPANY INC                                | 06-0T2104          |                            |         |
|                                  |           |                   |       |            | PAPICH CONSTRUCTION COMPANY INC                                | 04-1A6834          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G3804          |                            |         |
|                                  |           |                   |       |            |                                                                | 06-470904          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-1A6834          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G3804          |                            |         |
|                                  |           |                   |       |            |                                                                | 06-470904          |                            |         |
|                                  |           |                   |       |            |                                                                | 05-1F7404          |                            |         |
| AVISION CONSTRUCTION INC         | -4142.0   | 374132.19         | 0.0   | 1.0        | AVISION CONSTRUCTION INC                                       | 06-0V9804          | 6                          | 1.0     |
| BARGAS ENVIRONMENTAL CONSULTING  | -4142.0   | 189900.0          | 1.0   | 3.0        | C. A. RASMUSSEN, INC.                                          | 08-0N9724          | 8                          | 3.0     |
|                                  |           |                   |       |            | ORTIZ ENTERPRISES, INC.                                        | 08-0P3904          |                            |         |
|                                  |           |                   |       |            | SULLY-MILLER CONTRACTING COMPANY                               | 08-0Q1204          |                            |         |
| BLANCO CONSTRUCTION              | -4142.0   | 5693130.0         | 0.0   | 3.0        | AUTOBAHN CONSTRUCTION INC                                      | 08-1E5504          | 8                          | 2.0     |
|                                  |           |                   |       |            | J. MCLOUGHLIN ENGINEERING CO INC                               | 08-1E5604          |                            |         |
|                                  |           |                   |       |            |                                                                | 08-0Q75U4          |                            |         |
| CENTRAL COAST TRAFFIC SAFETY     | -4142.0   | 113189.06         | 0.0   | 2.0        | BRIDEWAY CIVIL CONSTRUCTORS INC                                | 05-1C3704          | 5                          | 2.0     |
|                                  |           |                   |       |            | R. BURKE CORPORATION                                           | 05-1G7504          |                            |         |
| CHAVEZ TRUCKING                  | 43.0      | 1834360.73        | 1.0   | 6.0        | BAY CITIES PAVING & GRADING, INC.                              | 04-4J2814          | 4                          | 4.0     |
|                                  |           |                   |       |            | DESILVA GATES CONSTRUCTION                                     | 04-4G1134          |                            |         |
|                                  |           |                   |       |            | GHILOTTI CONSTRUCTION COMPANY                                  | 04-270104          |                            |         |
|                                  |           |                   |       |            | O.C. JONES & SONS INC                                          | 04-4G5604          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-2J1004          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G3804          |                            |         |
| CLAY MIRANDA TRUCKING            | 43.0      | 403200.0          | 1.0   | 1.0        | TEICHERT CONSTRUCTION                                          | 06-394604          | 6                          | 1.0     |
| CONSTRUCTION AREA SIGNS, INC.    | 33.0      | 453400.16         | 1.0   | 3.0        | FLATIRON WEST INC                                              | 03-0H4704          | 3,8                        | 4.0     |
|                                  |           |                   |       |            | O.C. JONES & SONS                                              | 03-2F3404          |                            |         |
|                                  |           |                   |       |            | ROAD AND HIGHWAY BUILDERS LLC                                  | 03-4F6004          |                            |         |
|                                  |           |                   |       |            | SEMA CONSTRUCTION INC                                          |                    |                            |         |
| CONTERA CONSTRUCTION CORPORATION | -4142.0   | 3167532.8         | 0.0   | 2.0        | OHL USA                                                        | 05-1F75U4          | 5, 8                       | 2.0     |
|                                  |           |                   |       |            | ORTIZ ENTERPRISES INC                                          | 08-0Q1204          |                            |         |
| D.B. ELECTRIC INC                | -4142.0   | 407510.0          | 0.0   | 3.0        | BAY CITIES PAVING & GRADING, INC.                              | 08-0K2934          | 4, 8                       | 3.0     |
|                                  |           |                   |       |            | COFFMAN SPECIALTIES                                            | 04-4G1134          |                            |         |
|                                  |           |                   |       |            | SEMA CONSTRUCTION                                              | 08-0F0304          |                            |         |
| DON MAHAFFEY DRILLING COMPANY    | -4142.0   | 2427504.0         | 1.0   | 2.0        | FLATIRON WEST, INC.                                            | 11-430184          | 11                         | 1.0     |
|                                  |           |                   |       |            |                                                                | 08-0F0304          |                            |         |
| DOUBLE M TRUCKING                | 43.0      | 1106520.0         | 0.0   | 4.0        | O.C. JONES & SONS INC                                          | 03-2F9804          | 3,4                        | 2.0     |
|                                  |           |                   |       |            | TEICHERT CONSTRUCTION                                          | 04-4G5604          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-2J1004          |                            |         |
|                                  |           |                   |       |            |                                                                | 03-1F1904          |                            |         |
| DRAGON MATERIAL                  | 43.0      | 9835651.090000002 | 1.0   | 14.0       | BROSAMER & WALL INC                                            | 06-0Q2804          | 1,2,4,5,6,11               | 9.0     |
|                                  |           |                   |       |            | BAY CITIES PAVING & GRADING INC                                | 05-1C6504          |                            |         |
|                                  |           |                   |       |            | GHILOTTI BROS. INC.                                            | 05-1F7604          |                            |         |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 06-394604          |                            |         |
|                                  |           |                   |       |            | KNIFE RIVER CONSTRUCTION                                       | 01-0H3604          |                            |         |
|                                  |           |                   |       |            | OHL USA                                                        | 02-0H4504          |                            |         |
|                                  |           |                   |       |            | SECURITY PAVING COMPANY                                        | 05-1A0004          |                            |         |
|                                  |           |                   |       |            | TEICHERT CONSTRUCTION                                          | 05-1F75U4          |                            |         |
|                                  |           |                   |       |            | CALMEX ENGINEERING INC                                         | 05-1C2504          |                            |         |
|                                  |           |                   |       |            |                                                                | 06-0T2104          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-1A6834          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4K1104          |                            |         |
|                                  |           |                   |       |            |                                                                | 06-470904          |                            |         |
|                                  |           |                   |       |            |                                                                | 11-2N0214          |                            |         |
| DRS REBAR INC                    | -4142.0   | 2028803.45        | 0.0   | 5.0        | C.A. RASMUSSEN INC                                             | 07-275104          | 7, 8,12                    | 4.0     |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION INC                                       | 07-312204          |                            |         |
|                                  |           |                   |       |            | ORTIZ ENTERPRISES INC.                                         | 08-0Q1204          |                            |         |
|                                  |           |                   |       |            | SECURITY PAVING COMPANY INC                                    | 08-0N6704          |                            |         |
|                                  |           |                   |       |            |                                                                | 12-0C1104          |                            |         |
| EAGLE ROCK INDUSTRIES            | -4142.0   | 9828650.0         | 0.0   | 1.0        | 0                                                              | 05-1C8904          | 5                          | 1.0     |
| EIGHTEEN TRUCKING COMPANY        | 43.0      | 115000.0          | 1.0   | 2.0        | GORDON N. BALL INC                                             | 04-2J5404          | 4                          | 1.0     |
|                                  |           |                   |       |            |                                                                | 04-4G8404          |                            |         |
| FLASH TRAFFIC  INC               | -4142.0   | 112075.0          | 1.0   | 8.0        | BORTOLUSSI & WATKIN, INC.                                      | 10-1C5404          | 2, 4, 5, 7, 10             | 6.0     |
|                                  |           |                   |       |            | GEORGE REED INC                                                | 02-2E4804          |                            |         |
|                                  |           |                   |       |            | GOLDEN STATE BRIDGE, INC.                                      | 05-1A0004          |                            |         |
|                                  |           |                   |       |            | GORDON N. BALL                                                 | 10-0X56Y4          |                            |         |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 04-1G4304          |                            |         |
|                                  |           |                   |       |            | O.C. JONES & SONS INC                                          | 04-2J5404          |                            |         |
|                                  |           |                   |       |            |                                                                | 07-312204          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-2J1004          |                            |         |
| FLORES SWEEPING SERVICE          | -4142.0   | 198900.0          | 0.0   | 1.0        | A. TEICHERT & SON, INC. DBA TEICHERT CONSTRUCTION              | 10-1C2904          | 10                         | 1.0     |
| FRANK MEDINA GENERAL ENGINEERING | -4142.0   | 905920.0          | 0.0   | 4.0        | O.C. JONES & SONS INC                                          | 04-2J1004          | 3,4,5                      | 3.0     |
|                                  |           |                   |       |            | CORAL CONSTRUCTION COMPANY                                     | 03-1F1904          |                            |         |
|                                  |           |                   |       |            | PAPICH CONSTRUCTION COMPANY                                    | 03-0H5004          |                            |         |
|                                  |           |                   |       |            |                                                                | 05-1F7404          |                            |         |
| FULL TRAFFIC MAINTENANCE         | -4142.0   | 387130.62         | 0.0   | 5.0        | ALFARO COMMUNICATIONS COMPANY                                  | 07-305704          | 7, 8, 12                   | 5.0     |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 07-4T8904          |                            |         |
|                                  |           |                   |       |            | MURPHY IHDUSTRIAL COATINGS, INC.                               | 07-312504          |                            |         |
|                                  |           |                   |       |            | PETERSON-CHASE GENERAL ENGINEERING CONSTRUCTION, INC.          | 08-0N6704          |                            |         |
|                                  |           |                   |       |            | POWELL CONSTRUCTORS INC                                        | 12-0N8404          |                            |         |
| G & F CONCRETE CUTTING           | -4142.0   | 2731524.51        | 1.0   | 4.0        | ALFARO COMMUNICATIONS CONSTRUCTION INC                         | 12-0M4804          | 8,11, 12                   | 4.0     |
|                                  |           |                   |       |            | FLATIRON WEST, INC.                                            | 11-430184          |                            |         |
|                                  |           |                   |       |            | PETERSON CHASE GENERAL ENGINEERING CONSTRUCTION                | 12-0M9004          |                            |         |
|                                  |           |                   |       |            | POWELL CONSTRUCTORS INC                                        | 08-0Q9104          |                            |         |
| G & G ELECTRIC                   | -4142.0   | 1434890.0         | 0.0   | 4.0        | LANDSCAPE SUPPORT SERVICES                                     | 08-1F9204          | 7, 8,11, 12                | 3.0     |
|                                  |           |                   |       |            | PETERSON CHASE GENERAL ENGINEERING CONSTRUCTION INC            | 11-420804          |                            |         |
|                                  |           |                   |       |            | POWELL CONSTRUCTORS INC                                        | 07-295404          |                            |         |
|                                  |           |                   |       |            |                                                                | 12-0M9004          |                            |         |
| G.O. RODRIGUEZ TRUCKING          | 43.0      | 137700.0          | 0.0   | 1.0        | SPECTRUM CONSTRUCTION GROUP INC                                | 08-1E7804          | 8                          | 1.0     |
| GASPAR TRUCKING                  | 43.0      | 178000.0          | 0.0   | 1.0        | 1                                                              | 08-0K2934          | 8                          | 1.0     |
| GOLDEN BAY FENCE PLUS IRON       | -4142.0   | 112981.0          | 0.0   | 2.0        | BRIDGEWAY CIVIL CONSTRUCTION INC                               | 05-1C3704          | 5                          | 2.0     |
|                                  |           |                   |       |            | GRANITE ROCK COMPANY                                           | 05-1F4304          |                            |         |
| HOPPY'S SWEEPING SERVICES        | -4142.0   | 65280.0           | 1.0   | 1.0        | 2                                                              | 06-0T2104          | 6                          | 1.0     |
| J. TORRES COMPANY                | -4142.0   | 367500.0          | 1.0   | 3.0        | BOSCO CONSTRUCTORS                                             | 06-0T2904          | 4,6,7                      | 2.0     |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 07-312204          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-0J6604          |                            |         |
| JOSH ARBISO TRUCKING             | 43.0      | 22500.0           | 0.0   | 1.0        | STEELHEAD CONSTRUCTION                                         | 02-4F8604          | 2                          | 1.0     |
| KODIAK TRUCKING                  | 43.0      | 1408670.0         | 0.0   | 1.0        | SECURITY PAVING COMPANY                                        | 06-470904          | 6                          | 1.0     |
| LA FIRMA INC                     | -4142.0   | 825.0             | 0.0   | 1.0        | 2                                                              | 05-1K3304          | 5                          | 1.0     |
| LOGISTICAL ENTERPRISES           | -4142.0   | 1677067.65        | 1.0   | 10.0       | BALDWIN CONTRACTING COMPANY                                    | 10-1E3504          | 2,3,4,8,10                 | 8.0     |
|                                  |           |                   |       |            | BAY CITIES PAVING & GRADING                                    | 03-4F4604          |                            |         |
|                                  |           |                   |       |            | DESILVA GATES CONSTRUCTION                                     | 04-2J0004          |                            |         |
|                                  |           |                   |       |            | GEORGE REED INC                                                | 04-2J6704          |                            |         |
|                                  |           |                   |       |            | GHILOTTI CONSTRUCTION COMPANY                                  | 10-0W9014          |                            |         |
|                                  |           |                   |       |            | STUDEBAKER BROWN ELECTRIC INC                                  | 04-270104          |                            |         |
|                                  |           |                   |       |            | PACIFIC INFRASTRUCTURE CONSTRUCTION LLC                        | 04-4H9804          |                            |         |
|                                  |           |                   |       |            | FBD VANGUARD CONSTRUCTION                                      | 04-OK8404          |                            |         |
|                                  |           |                   |       |            |                                                                | 03-0H5104          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G3804          |                            |         |
| LONE STAR LANDSCAPE, INC         | -4142.0   | 353704.0          | 0.0   | 4.0        | GHILOTTI CONSTRUCTION CO. INC.                                 | 04-151614          | 4, 5                       | 3.0     |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 05-1A0004          |                            |         |
|                                  |           |                   |       |            | GRANITE ROCK COMPANY                                           | 05-1C2504          |                            |         |
|                                  |           |                   |       |            |                                                                | 05-1C6704          |                            |         |
| M & S ENVIRONMENTAL              | -4142.0   | 974473.0          | 0.0   | 8.0        | GOLDEN STATE BRIDGE, INC.                                      | 03-2F9804          | 2,3                        | 5.0     |
|                                  |           |                   |       |            | HAT CREEK CONSTRUCTION                                         | 02-4F2004          |                            |         |
|                                  |           |                   |       |            | TEICHERT CONSTRUCTION                                          | 02-4F5104          |                            |         |
|                                  |           |                   |       |            | STEELHEAD CONSTRUCITON                                         | 02-4F8604          |                            |         |
|                                  |           |                   |       |            | TULLIS, INC.                                                   | 02-2E4804          |                            |         |
|                                  |           |                   |       |            | WEST COAST CONTRACTORS, INC. DBA OREGON WEST COAST CONTRACTORS | 02-4F2104          |                            |         |
|                                  |           |                   |       |            |                                                                | 02-4F7804          |                            |         |
|                                  |           |                   |       |            |                                                                | 02-0H7604          |                            |         |
| MANERI TRAFFIC CONTROL           | -4142.0   | 2256208.8         | 0.0   | 13.0       | ALL AMERICAN ASPHALT                                           | 08-1E6104          | 7,8,11                     | 10.0    |
|                                  |           |                   |       |            | C.A. RASMUSSEN INC                                             | 07-275104          |                            |         |
|                                  |           |                   |       |            | COFFMAN SPECIALTIES                                            | 08-0K2934          |                            |         |
|                                  |           |                   |       |            | O'DONNELL CONSTRUCITON INC                                     | 08-1E8504          |                            |         |
|                                  |           |                   |       |            | LB CIVIL CONSTRUCTION                                          | 08-388524          |                            |         |
|                                  |           |                   |       |            | ORTIZ ENTERPRISES INC                                          | 11-416604          |                            |         |
|                                  |           |                   |       |            | PETERSON-CHASE GENERAL ENGINEERING CONSTRUCTION                | 07-340604          |                            |         |
|                                  |           |                   |       |            | PTM ENGINEERING SERVICES, INC                                  | 07-4W0804          |                            |         |
|                                  |           |                   |       |            | RV CONCRETE, INC.                                              | 08-0N9724          |                            |         |
|                                  |           |                   |       |            | SEMA CONSTRUCTION INC                                          | 08-0Q9104          |                            |         |
|                                  |           |                   |       |            | SULLY-MILLER CONTRACTING COMPANY                               | 08-0Q1204          |                            |         |
|                                  |           |                   |       |            | CALMEX ENGINEERING                                             | 08-0F0304          |                            |         |
|                                  |           |                   |       |            |                                                                | 11-2N0214          |                            |         |
| MEX ELECTRIC                     | -4142.0   | 11741665.0        | 0.0   | 4.0        | BROSAMER & WALL INC                                            | 06-0Q2804          | 3,6,12                     | 3.0     |
|                                  |           |                   |       |            | Q&D CONSTRUCTION LLC                                           | 03-4F8404          |                            |         |
|                                  |           |                   |       |            | SECURITY PAVING COMPANY INC.                                   | 06-470904          |                            |         |
|                                  |           |                   |       |            |                                                                | 12-0C1104          |                            |         |
| MIRANDA LOGISTIC ENTERPRISE LLC  | -4142.0   | 2697483.96        | 0.0   | 4.0        | GRANITE CONSTRUCTION COMPANY                                   | 07-312504          | 6,7, 8,12                  | 4.0     |
|                                  |           |                   |       |            | POWELL CONSTRUCTORS INC                                        | 06-0E3204          |                            |         |
|                                  |           |                   |       |            | WEST COAST PUBLIC WORKS INC                                    | 08-0N6704          |                            |         |
|                                  |           |                   |       |            | SECURITY PAVING COMPANY                                        | 12-0C1104          |                            |         |
| MONZON & SON ENTERPRISES INC     | 43.0      | 188970.0          | 0.0   | 3.0        | C.A. RASMUSSEN INC                                             | 07-275104          | 7,8                        | 3.0     |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 07-312204          |                            |         |
|                                  |           |                   |       |            | PETERSON-CHASE GENERAL ENGINEERING                             | 08-0Q9104          |                            |         |
| MORALES CONTRACTING              | -4142.0   | 1124503.2         | 0.0   | 1.0        | 1                                                              | 08-0K2934          | 8                          | 1.0     |
| OST TRUCKS AND CRANES INC.       | -4142.0   | 51057.0           | 0.0   | 1.0        | 2                                                              | 06-0Q19A4          | 6                          | 1.0     |
| PTM GENERAL ENGINEERING SERVICES | -4142.0   | 8609993.37        | 1.0   | 1.0        | PTM ENGINEERING SERVICES, INC                                  | 07-340604          | 7                          | 1.0     |
| PRE-CON PRODUCTS LTD             | -4142.0   | 158648.92         | 0.0   | 2.0        | GHILOTTI CONSTRUCTION COMPANY INC                              | 01-0A0404          | 1, 7                       | 2.0     |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 07-312204          |                            |         |
| QUALITY TRAFFIC CONTROL          | -4142.0   | 11050.0           | 0.0   | 2.0        | PAVE-TECH INC                                                  | 08-0Q9104          | 8                          | 2.0     |
|                                  |           |                   |       |            | PETERSON-CHASE ENGINEERING CONSTRUCTION                        | 08-1F7704          |                            |         |
| R N R CONSTRUCTION INC           | -4142.0   | 21244557.5        | 0.0   | 1.0        | J.F. SHEA CONSTRUCTION INC                                     | 02-4C40V4          | 2                          | 1.0     |
| RANGEL BROTHERS                  | 43.0      | 600080.0          | 0.0   | 2.0        | SECURITY PAVING COMPANY                                        | 07-301504          | 5,7                        | 2.0     |
|                                  |           |                   |       |            | PAPICH CONSTRUCTION COMPANY INC                                | 05-1F7404          |                            |         |
| S & S TRUCKING                   | 43.0      | 275440.0          | 0.0   | 2.0        | DISNEY CONSTRUCTION INC.                                       | 04-4G8804          | 0                          | 2.0     |
|                                  |           |                   |       |            | GRANITE ROCK COMPANY                                           | 10-0X7004          |                            |         |
| SAVALA EQUIPMENT COMPANY INC     | -4142.0   | 108441.7          | 1.0   | 2.0        | FLATIRON WEST, INC.                                            | 11-430184          | 8,11                       | 2.0     |
|                                  |           |                   |       |            | ORTIZ ENTERPRISES INC                                          | 08-0Q1204          |                            |         |
| SAN JOSE TRANSPORT               | 43.0      | 8000.0            | 0.0   | 1.0        | 0                                                              | 05-1C2604          | 5                          | 1.0     |
| SAWMAN CONCRETE CUTTING          | 43.0      | 1094000.0         | 0.0   | 1.0        | J MCLOUGHLIN ENGINEERING CO INC                                | 08-0Q75U4          | 8                          | 1.0     |
| SEALRIGHT PAVING                 | -4142.0   | 220276.0          | 0.0   | 1.0        | LB CIVIL CONSTRUCTION INC                                      | 11-416604          | 11                         | 1.0     |
| SoCAL WELDING                    | -4142.0   | 200796.0          | 0.0   | 1.0        | DISNEY CONSTRUCTION INC.                                       | 04-4G8804          | 4                          | 1.0     |
| T.D.W. CONSTRUCTION, INC         | -4142.0   | 250037.93         | 0.0   | 1.0        | DESILVA GATES CONSTRUCTION                                     | 04-270104          | 4                          | 1.0     |
| TULLY CONSULTING GROUP           | -4142.0   | 525380.0          | 1.0   | 28.0       | BAY CITIES PAVING & GRADING, INC.                              | 10-1E3504          | 1,3, 4, 5, 6, 7, 8, 10, 12 | 16.0    |
|                                  |           |                   |       |            | BORTOLUSSI & WATKIN, INC.                                      | 05-1C2604          |                            |         |
|                                  |           |                   |       |            | BRIDGEWAY CIVIL CONSTRUCTORS                                   | 06-0H2004          |                            |         |
|                                  |           |                   |       |            | C.A. RASMUSSEN INC                                             | 07-275104          |                            |         |
|                                  |           |                   |       |            | DESILVA GATES CONSTRUCTION                                     | 10-0L0204          |                            |         |
|                                  |           |                   |       |            | GEORGE REED INC                                                | 10-0V1104          |                            |         |
|                                  |           |                   |       |            | GORDON N BALL                                                  | 01-0H3604          |                            |         |
|                                  |           |                   |       |            | GRANITE CONSTRUCTION COMPANY                                   | 04-4G1134          |                            |         |
|                                  |           |                   |       |            | GRANITE ROCK COMPANY                                           | 05-1A0004          |                            |         |
|                                  |           |                   |       |            | M.C.M. CONSTRUCTION INC                                        | 10-0X56Y4          |                            |         |
|                                  |           |                   |       |            | MEYERS EARTHWORK                                               | 03-0H4704          |                            |         |
|                                  |           |                   |       |            | O.C. JONES & SONS                                              | 04-1G4304          |                            |         |
|                                  |           |                   |       |            | PETERSON-CHASE GENERAL ENGINEERING                             | 04-270104          |                            |         |
|                                  |           |                   |       |            | SAK CONSTRUCTION                                               | 04-2J5404          |                            |         |
|                                  |           |                   |       |            | TEICHERT CONSTRUCTION                                          | 04-3G6904          |                            |         |
|                                  |           |                   |       |            | VIKING CONSTRUCTION COMPANY INC                                | 04-4G5604          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-OK8404          |                            |         |
|                                  |           |                   |       |            |                                                                | 08-0Q9104          |                            |         |
|                                  |           |                   |       |            |                                                                | 09-353204          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-2J1004          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G8404          |                            |         |
|                                  |           |                   |       |            |                                                                | 05-1C6704          |                            |         |
|                                  |           |                   |       |            |                                                                | 05-1C85U4          |                            |         |
|                                  |           |                   |       |            |                                                                | 12-0Q0404          |                            |         |
|                                  |           |                   |       |            |                                                                | 03-1F1904          |                            |         |
|                                  |           |                   |       |            |                                                                | 03-4F2504          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-1A6834          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-0J6604          |                            |         |
| TERRA WEST INC                   | -4142.0   | 20000.0           | 0.0   | 3.0        | HAZARD CONSTRUCTION COMPANY                                    | 11-419504          | 11                         | 2.0     |
|                                  |           |                   |       |            | LB CIVIL CONSTRUCTION INC                                      | 11-416604          |                            |         |
|                                  |           |                   |       |            |                                                                | 11-420104          |                            |         |
| UNIVERSAL CONCRETE CONSTRUCTION  | -4142.0   | 719714.25         | 0.0   | 1.0        | 2                                                              | 08-0N6704          | 8                          | 1.0     |
| VALDIVIA TRUCKING                | 43.0      | 1116000.0         | 0.0   | 3.0        | GHILOTTI CONSTRUCTION COMPANY INC                              | 01-0A0404          | 1, 4                       | 1.0     |
|                                  |           |                   |       |            |                                                                | 04-4H9804          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-4G3804          |                            |         |
| VINTAGE PAVING COMPANY           | -4142.0   | 2439247.0         | 0.0   | 3.0        | MCM CONSTRUCTION INC                                           | 10-1H3414          | 0                          | 2.0     |
|                                  |           |                   |       |            | AMERICAN CIVIL CONSTRUCTORS WEST COAST LLC                     | 04-1J3704          |                            |         |
|                                  |           |                   |       |            |                                                                | 10-0L0204          |                            |         |
| WCW INC                          | -4142.0   | 515520.0          | 0.0   | 1.0        | BRIDGEWAY CIVIL CONSTRUCTORS INC                               | 10-0P5504          | 10                         | 1.0     |
| WESTERN TRAFFIC SUPPLY INC       | -4142.0   | 2732315.0         | 0.0   | 8.0        | BAY CITIES PAVING & GRADING, INC.                              | 04-2J0004          | 4, 10                      | 5.0     |
|                                  |           |                   |       |            | BRIDGEWAY CIVIL CONSTRUCTORS, INC.                             | 04-2J6704          |                            |         |
|                                  |           |                   |       |            | DESILVA GATES CONSTRUCTION                                     | 04-4G1134          |                            |         |
|                                  |           |                   |       |            | PACIFIC INFRASTRUCTURE CONSTRUCTION LLC                        | 04-4H0804          |                            |         |
|                                  |           |                   |       |            | FBD VANGUARD CONSTRUCTION                                      | 10-1C0604          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-270104          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-0K8404          |                            |         |
|                                  |           |                   |       |            |                                                                | 04-1A6834          |                            |         |

## Output:


source: excel_file
label: explode