Weekly updates on the following DCFC networks:
Walmart
RaceTrac
711 7Charge
Circle K
MercedesBenz Charging Hub
Pilot Flying J
Tesla Supercharger
Electrify America
ChargePoint
EV Connect
EVgo
Rivian Adventure Network
Francis Energy
Database Setup Vid: • National EV Database Mashing
SQL used in this video:
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date from NewData where (City like 'Cross%' or City like 'Springdal%') and (State like 'TX' or State like 'AR');
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date from NewData where Station_Name like 'RaceTrac%' and isnumber(EV_DC_Fast_Count) = 1 order by Open_Date;
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date, id from NewData where EV_Network like '7%' and isnumber(EV_DC_Fast_Count) = 1 order by id;
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date, id from NewData where EV_Network like 'Circle%' and isnumber(EV_DC_Fast_Count) = 1 order by id;
select substring(Station_Name, 1, length(Station_Name)4) as Station_Name, City, State, EV_Network, sum(EV_DC_Fast_Count) as '# of Stalls', Open_Date from NewData where (Station_Name like 'Bucees%' or Station_Name like 'MBUSA HQ%') and isnumber(EV_DC_Fast_Count) = 1 group by City order by Open_Date;
select Station_Name, City, State, EV_Network, EV_DC_Fast_Count as '# of Stalls', Open_Date from NewData where (isnumber(Station_Name) = 1 or Station_Name like 'Pilot%' or Station_Name like 'Flying%') and EV_Network like 'eVgo%';
select NewData.Station_Name, NewData.City, NewData.State, NewData.EV_Network, NewData.EV_DC_Fast_Count as '# of Stalls', NewData.Open_Date from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.Station_Name like '%esla Su%' order by NewData.id;
select count(id) from NewData where Station_Name like '%esla Su%';
select NewData.Station_Name, NewData.City, NewData.State, NewData.EV_Network, NewData.EV_DC_Fast_Count as '# of Stalls', NewData.Open_Date, NewData.id from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.EV_Network like 'Electrify A%' and isnumber(NewData.EV_DC_Fast_Count) = 1 order by NewData.id;
select count(id) from NewData where EV_Network like '%lectrify A%';
select NewData.Station_Name, NewData.City, NewData.State, NewData.EV_Network, NewData.EV_DC_Fast_Count as '# of Stalls', NewData.Open_Date, NewData.id from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.EV_Network like 'ChargePoi%' and isnumber(NewData.EV_DC_Fast_Count) = 1 and not (NewData.Station_Name like 'Bucees%' or NewData.Station_Name like 'MBUSA HQ%') order by NewData.id;
select count(id) from NewData where EV_Network like 'ChargePoi%' and isnumber(NewData.EV_DC_Fast_Count) = 1;
select NewData.Station_Name, NewData.City, NewData.State, NewData.EV_Network, NewData.EV_DC_Fast_Count as '# of Stalls', NewData.Open_Date, NewData.id from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.EV_Network like 'eVgo%' and not (isnumber(NewData.Station_Name) = 1 or NewData.Station_Name like 'Pilot%' or NewData.Station_Name like 'Flying%') order by NewData.id;
select count(id) from NewData where EV_Network like 'eVgo%';
select substring(NewData.Station_Name, 1, length(NewData.Station_Name)15) as Station_Name, NewData.City, NewData.State, NewData.EV_Network, sum(NewData.EV_DC_Fast_Count) as '# of Stalls', NewData.Open_Date, NewData.id from NewData left join OldData on OldData.Station_Name = NewData.Station_Name where OldData.Station_Name is null and NewData.EV_Network like 'RIVIAN_A%' group by NewData.City, NewData.State order by NewData.id;
select count(id) from NewData where EV_Network like 'RIVIAN_A%';