About this Dataset

Adult Jail Booking May 1, 2024 To Apr 30, 2025 As Of May 2, 2025

The Jail Bookings Open Data dataset is provided by the King County Department of Adult and Juvenile Detention. The dataset contains adult jail bookings which have occurred within the last twelve months; specific dates are indicated on the web site.

The data provided is a snapshot and is current as of the date and time it was extracted from the jail management systems. Every effort has been made to ensure the accuracy of data listed at the time of extraction. Updates, corrections, and additions may have occurred since the extraction date and time.

This dataset provides information associated with the booking of an individual into a King County jail facility, and not with any court cause, case, or criminal filing pursuant to the booking event. This information does not reflect the criminal history or criminal status of any inmate currently or previously in custody.

Current information about a specific booking event can be obtained by calling the Department of Adult and Juvenile Detention at (206) 296-1234 or by visiting our Jail Inmate Lookup Service (JILS). https://dajd-jms.powerappsportals.us/public/subject-lookup/
Organization: King County, Washington
Last updated: 2020-11-10T16:58:38.934792
Tags: bookings, charges, dajd, jail-inmate, kccf, mrjc

Tables

Table 1

@usgov.king_county_washington_adult_jail_booking_november_1_2_e3230be5.table_1

1.1 MB
39,986 rows
13 columns

CREATE TABLE table_1 (
  "book_of_arrest_number" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_name" VARCHAR,
  "jrsr" VARCHAR,
  "booking_date_time" VARCHAR,
  "release_date_time" VARCHAR,
  "current_facility" VARCHAR,
  "charge" VARCHAR,
  "court_case_cause_number" VARCHAR  -- Court Case / Cause Number,
  "court" VARCHAR,
  "rcw_ordinance_number" VARCHAR  -- RCW / Ordinance Number,
  "release_reason" VARCHAR
);