From a 106-row sample across 14 columns.
year| year | make | model | hybrid_non_hybrid | standard_type | epa_rating_city | vehicle_count | total_actual_miles | total_actual_fuel | epa_expected_fuel | actual_fuel_economy_geotab | percent_difference_actual |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 | HONDA | CIVIC GX | Non-Hybrid | SEDAN | 24 | 9 | 4459 | 221 | 185.79 | 20.18 | -0.16 |
| 2008 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
year | categorical | The model year of the vehicle | 0% | 201520162017of 12 |
make | categorical | The make of the vehicle | 0% | FORDTOYOTACHEVROLETof 8 |
model | text | The model of the vehicle | 0% | PRIUSEXPRESSF150 |
hybrid_non_hybrid | categorical | Whether the vehicle is a non-nybrid or hybrid vehicle | 0% | Non-HybridHybridof 2 |
GET /api/datasets/mn2p-34if GET /api/datasets/mn2p-34if/quality GET /api/datasets/mn2p-34if/related GET /api/columns?dataset=mn2p-34if
| FORD |
| CROWN VIC |
| Non-Hybrid |
| SEDAN |
| 11 |
| 7 |
| 17162 |
| 1771 |
| 1560.18 |
| 9.69 |
| -0.12 |
| 2008 | CHEVROLET | EXPRESS | Non-Hybrid | VAN | 13 | 1 | 413 | 65 | 31.77 | 6.35 | -0.51 |
| 2008 | FORD | FOCUS | Non-Hybrid | SEDAN | 24 | 49 | 13074 | 793 | 544.75 | 16.49 | -0.31 |
| 2008 | FORD | FUSION | Non-Hybrid | SEDAN | 18 | 5 | 29482 | 1813 | 1637.89 | 16.26 | -0.1 |
| 2008 | TOYOTA | HIGHLANDER HYBRID | Hybrid | SUV | 27 | 15 | 36095 | 1667 | 1336.85 | 21.65 | -0.2 |
| 2008 | TOYOTA | PRIUS | Hybrid | SEDAN | 48 | 189 | 1034445 | 25453 | 21550.94 | 40.64 | -0.15 |
| 2008 | FORD | RANGER | Non-Hybrid | PICKUP | 15 | 14 | 8820 | 845 | 588.00 | 10.44 | -0.3 |
| 2009 | NISSAN | ALTIMA HYBRID | Hybrid | SEDAN | 35 | 11 | 73015 | 2790 | 2086.14 | 26.17 | -0.25 |
| 2009 | FORD | CROWN VIC | Non-Hybrid | SEDAN | 16 | 39 | 3263 | 290 | 203.94 | 11.25 | -0.3 |
Showing 12 of 14 columns. All of them are listed below.
standard_type |
| categorical |
| The categorization of the vehicle in the fleet management system |
| 0% |
SEDANSUVVANof 4 |
epa_rating_city | integer | The sticker rating provided by the EPA when a vehicle is purchased | 0% | 161315 |
vehicle_count | integer | How many active vehicles of the same year/make/model/standard type were included in the report | 0% | 9722 |
total_actual_miles | integer | Miles driven in total by the same vehicles based on year/make/model/standard type | 0% | 55031241639165019 |
total_actual_fuel | integer | Fuel used in total by the same vehicles based on year/make/model/standard type | 0% | 5419643220113 |
epa_expected_fuel | float | Using the actual miles driven and the EPA Rating to determine how many gallons of fuel should have been used | 0% | 4538.20820.8217938.00 |
actual_fuel_economy_geotab | float | Using the city's telematics reporting a calculation of what the actual fuel economy was | 0% | 15.5125.6611.07 |
percent_difference_actual | float | Comparing column 11 to column 6 | 0% | -0.01-0.14-0.3 |
estimated_fuel_costs_per | text | Based on a price per gallon of $2.50 what the costs associated for each year/make/model/standard type were | 0% | $ 13,547.50$ 4,782.50$ 42,790.00 |
fuel_costs_per_mile | text | Calculating the per mile driven cost of fuel by vehicle year/make/model/standard type | 0% | $ 0.06$ 0.05$ 0.22 |