{"county_public_safety": {"columns": [[0, "County_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Population", "INT", 0, null, 0], [3, "Police_officers", "INT", 0, null, 0], [4, "Residents_per_officer", "INT", 0, null, 0], [5, "Case_burden", "INT", 0, null, 0], [6, "Crime_rate", "REAL", 0, null, 0], [7, "Police_force", "TEXT", 0, null, 0], [8, "Location", "TEXT", 0, null, 0]], "primary_keys": ["County_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "County_ID"]]], "check_constraints": []}, "city": {"columns": [[0, "City_ID", "INT", 0, null, 1], [1, "County_ID", "INT", 0, null, 0], [2, "Name", "TEXT", 0, null, 0], [3, "White", "REAL", 0, null, 0], [4, "Black", "REAL", 0, null, 0], [5, "Amerindian", "REAL", 0, null, 0], [6, "Asian", "REAL", 0, null, 0], [7, "Multiracial", "REAL", 0, null, 0], [8, "Hispanic", "REAL", 0, null, 0]], "primary_keys": ["City_ID"], "foreign_keys": [[0, 0, "county_public_safety", "County_ID", "County_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "City_ID"]]], "check_constraints": []}}
CREATE TABLE county_public_safety (
    County_ID INT   PRIMARY KEY,
    Name TEXT,
    Population INT,
    Police_officers INT,
    Residents_per_officer INT,
    Case_burden INT,
    Crime_rate REAL,
    Police_force TEXT,
    Location TEXT,
    UNIQUE (County_ID)
);

CREATE TABLE city (
    City_ID INT   PRIMARY KEY,
    County_ID INT,
    Name TEXT,
    White REAL,
    Black REAL,
    Amerindian REAL,
    Asian REAL,
    Multiracial REAL,
    Hispanic REAL,
    UNIQUE (City_ID),
    FOREIGN KEY (County_ID) REFERENCES county_public_safety(County_ID)
);