Spaces:
Running
Running
File size: 2,104 Bytes
4f8926e 0ce399d 4f8926e 7e69a95 4f8926e c0f0e19 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
CREATE TABLE ev_population (
vin VARCHAR(10),
county VARCHAR(20),
city VARCHAR(24),
state VARCHAR(2),
postal_code INTEGER,
model_year INTEGER,
make VARCHAR(20),
model VARCHAR(24),
ev_type VARCHAR(38),
cafv_eligibility VARCHAR(60),
electric_range INTEGER,
base_msrp INTEGER,
legislative_district INTEGER,
dol_vehicle_id INTEGER,
electric_utility VARCHAR(112)
);
CREATE TABLE county_registrations (
month VARCHAR(9),
year INTEGER,
county VARCHAR(20),
state VARCHAR(2),
primary_use VARCHAR(9),
battery_evs INTEGER,
plug_in_hybrids INTEGER,
total_evs INTEGER,
total_non_evs INTEGER,
total_vehicles INTEGER,
percent_evs REAL
);
CREATE TABLE ev_registrations (
ev_type VARCHAR(38),
vin VARCHAR(10),
dol_vehicle_id INTEGER,
model_year INTEGER,
make VARCHAR(20),
model VARCHAR(24),
primary_use VARCHAR(34),
electric_range INTEGER,
odometer_reading INTEGER,
odometer_reading_description VARCHAR(55),
new_or_used VARCHAR(4),
sale_price INTEGER,
base_msrp INTEGER,
transaction_type VARCHAR(32),
transaction_month VARCHAR(9),
transaction_day INTEGER,
transaction_year INTEGER,
county VARCHAR(20),
city VARCHAR(24),
state VARCHAR(2),
postal_code INTEGER,
cafv_eligibility VARCHAR(40),
meets_2019_hb_2042_electric_range_requirement BOOLEAN,
meets_2019_hb_2042_sale_date_requirement BOOLEAN,
meets_2019_hb_2042_sale_price_value_requirement BOOLEAN,
battery_range_requirement_2019_hb_2042 VARCHAR(32),
purchase_date_requirement_2019_hb_2042 VARCHAR(59),
sale_price_value_requirement_2019_hb_2042 VARCHAR(59),
ev_fee_paid VARCHAR(14),
transportation_electrification_fee_paid VARCHAR(14),
hybrid_vehicle_electrificatin_fee_paid VARCHAR(14),
geoid_2020 INTEGER,
legislative_district INTEGER,
electric_utility VARCHAR(112)
);
CREATE TABLE washington_population (
county VARCHAR(12),
year INTEGER,
population INTEGER
) |