-------------------------------------------------
-- database schema for the COVIDNYT database
-------------------------------------------------

create table StatsC(
	date date NOT NULL,
	dd int NOT NULL,
	county varchar(50) NOT NULL,
	state varchar(50) NOT NULL,
	fips int NULL,
	cases int NOT NULL,
	deaths int NOT NULL
)

create table States (
	state varchar(50) NOT NULL,
	code varchar(6) NOT NULL,
	fips int NOT NULL
)

create table dbo.censusData (
	 fips int NOT NULL,
	 State varchar(128) NULL,
	 County varchar(50) NULL,
	 Population int NOT NULL,
	 HousingUnits int NOT NULL,
	 TotalArea real NOT NULL,
	 WaterArea real NOT NULL,
	 LandArea real NOT NULL,
	 Popdensity real NOT NULL,
	 HouseDensity real NOT NULL
)

create table Interventions (
	fips int NOT NULL,	
	state varchar(50) NOT NULL,
	county varchar(50) NULL,
	stayhome int NULL,
	gather50 int NULL,
	gather500 int NULL,
	schools int NULL,
	dinein int NULL,
	entgym int NULL,
	fedGuide int NULL
)

