About this Dataset

FOIA Legacy Crossover

In the summer of 2024, the District of Columbia migrated its FOIA records management to a new system. This dataset houses the archived Freedom of Information Act (FOIA) requests to DC Government by various organizations and individuals - that have now closed since the June 14, 2024 migration. Their original details remain unchanged in the FOIA Legacy dataset, also found on Open Data DC.
Organization: District of Columbia
Last updated: 2025-02-04T23:13:24.570857
Tags: district-of-columbia, foia, freedom-of-information-act, government, operations, os, washington-dc

Tables

Table 1

@usgov.district_of_columbia_foia_legacy_crossover.table_1

1.98 MB
110,266 rows
18 columns

CREATE TABLE table_1 (
  "legacy_actionoffice" VARCHAR,
  "legacy_foia_request" VARCHAR,
  "legacy_requester_category" VARCHAR,
  "legacy_receiveddate" VARCHAR,
  "legacy_receivemode" VARCHAR,
  "legacy_targetdate" VARCHAR,
  "required_completion_date" VARCHAR,
  "request_status" VARCHAR,
  "exemptions" VARCHAR,
  "close_date" VARCHAR,
  "completed_closed" VARCHAR,
  "days_open" DOUBLE,
  "grand_tot_fee_time_charge" DOUBLE,
  "method_of_payment" VARCHAR,
  "extension_act_description" VARCHAR,
  "legacy_extension" DOUBLE,
  "dcs_last_mod_ddtm" TIMESTAMP,
  "objectid" BIGINT
);