About this Dataset

FOIA Legacy

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 -received beginning September 2, 2014 through June 14, 2024. FOIA request that did not close prior to June 14, 2024 were migrated to the new system in July 2024. Their original dates and status remain the same within this archive. Updated information for any outstanding migrated FOIA requests can be cross-referenced in the FOIA Legacy Crossover dataset that is also found on Open Data DC.
Organization: District of Columbia
Last updated: 2025-02-04T23:14:04.386857
Tags: district-of-columbia, foia, freedom-of-information-act, government, operations, os, washington-dc

Tables

Table 1

@usgov.district_of_columbia_foia_legacy.table_1

1.68 MB
56,697 rows
22 columns

CREATE TABLE table_1 (
  "request_id" VARCHAR,
  "requester_category" VARCHAR,
  "action_office" VARCHAR,
  "primary_user_group" VARCHAR,
  "requested_date" TIMESTAMP,
  "received_date" TIMESTAMP,
  "received_mode" VARCHAR,
  "disposition_accepted_date" TIMESTAMP,
  "final_disposition" VARCHAR,
  "delivery_date" TIMESTAMP,
  "delivery_mode" VARCHAR,
  "target_mode" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "exemption_cited" VARCHAR,
  "extension_appr_dnl_dt" VARCHAR,
  "extension_reason" VARCHAR,
  "invoice_amount" DOUBLE,
  "processed_days" BIGINT,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "dcs_last_mod_dttm" TIMESTAMP,
  "object_id" BIGINT
);