government_units

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

92,206 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: level, source, source_year

Next page

CREATE TABLE government_units(
  gov_unit_id INT,
  census_pid6 TEXT,
  census_gidid TEXT,
  level TEXT,
  unit_type TEXT,
  name TEXT,
  name_normalized TEXT,
  state TEXT,
  fips_state TEXT,
  fips_county TEXT,
  county_name TEXT,
  city TEXT,
  zip TEXT,
  web_address TEXT,
  population INT,
  source TEXT,
  source_year INT
, dd_id TEXT
            GENERATED ALWAYS AS ('DD-G-' || gov_unit_id) VIRTUAL);
CREATE INDEX idx_gu_name_norm ON government_units(name_normalized);
CREATE INDEX idx_gu_name_state ON government_units(name_normalized, state);
CREATE INDEX idx_gu_state ON government_units(state);
CREATE INDEX idx_gu_level ON government_units(level);
CREATE INDEX idx_gu_pid6 ON government_units(census_pid6) WHERE census_pid6 IS NOT NULL;