omni-create-table

CREATE TABLE county_level_flood_risk_FSF (
  fips TEXT ENCODING DICT(32),
  name TEXT ENCODING DICT(32),
  count_property INTEGER,
  count_fema_sfha INTEGER,
  pct_fema_sfha FLOAT,
  count_fs_risk_2020_5 INTEGER,
  pct_fs_risk_2020_5 FLOAT,
  count_fs_risk_2050_5 INTEGER,
  pct_fs_risk_2050_5 FLOAT,
  count_fs_risk_2020_100 INTEGER,
  pct_fs_risk_2020_100 FLOAT,
  count_fs_risk_2050_100 INTEGER,
  pct_fs_risk_2050_100 FLOAT,
  count_fs_risk_2020_500 INTEGER,
  pct_fs_risk_2020_500 FLOAT,
  count_fs_risk_2050_500 INTEGER,
  pct_fs_risk_2050_500 FLOAT,
  pct_fs_fema_difference_2020 FLOAT,
  avg_risk_score_all FLOAT,
  avg_risk_score_2_10 FLOAT,
  avg_risk_fsf_2020_100 FLOAT,
  avg_risk_fsf_2020_500 FLOAT,
  avg_risk_score_sfha FLOAT,
  avg_risk_score_no_sfha FLOAT,
  count_floodfactor1 INTEGER,
  count_floodfactor2 INTEGER,
  count_floodfactor3 INTEGER,
  count_floodfactor4 INTEGER,
  count_floodfactor5 INTEGER,
  count_floodfactor6 INTEGER,
  count_floodfactor7 SMALLINT,
  count_floodfactor8 SMALLINT,
  count_floodfactor9 INTEGER,
  count_floodfactor10 INTEGER);