Name: OIP Master UIPA Record Request Semiannual Log For FY 2018
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

OIP Master UIPA Record Request Semiannual Log For FY 2018

OIP Master UIPA Record Request Semiannual Log for FY 2018 (record requests received July 1, 2017, through December 31, 2017)
Organization: State of Hawaii
Last updated: 2024-04-10T22:39:29.815048

Tables

Table 1

@usgov.state_of_hawaii_oip_master_uipa_request_semiannual_log_7da6c5f0.table_1

76.26 KB
236 rows
58 columns


CREATE TABLE table_1 (
  "department" VARCHAR,
  "agency" VARCHAR,
  "personal_records_request" BIGINT,
  "date_agency_received_request" BIGINT,
  "date_agency_s_notice_was_sent" BIGINT,
  "agency_s_initial_response_sent_within_10_work_days" BIGINT,
  "request_needed_initial_clarification" BIGINT,
  "complex_request" BIGINT,
  "n__agency_gave_incremental_responses" BIGINT,
  "date_completed" BIGINT,
  "n__of_workdays_to_complete" BIGINT,
  "request_granted_in_full" BIGINT,
  "request_denied_in_full" BIGINT,
  "request_granted_denied_in_part" BIGINT,
  "agency_ultimately_unable_to_respond" BIGINT,
  "requester_withdrew" BIGINT,
  "requester_abandoned_or_failed_to_pay" BIGINT,
  "uipa_lawsuit_filed_against_agency" BIGINT,
  "actual_search_hours" DOUBLE,
  "n__actual_review_segregation_hours" DOUBLE,
  "actual_legal_review_hours" DOUBLE,
  "total_actual_srs_legal_review_hours" DOUBLE,
  "total_gross_srs_fees_incurred" DOUBLE,
  "additional_response_fees_incurred_but_not_chargeable" DOUBLE,
  "n__30_fee_waiver" BIGINT,
  "n__60_public_interest_fee_waiver" BIGINT,
  "fees_for_personal_records" DOUBLE,
  "total_net_srs_fees_chargeable" DOUBLE,
  "gross_copy_delivery_costs_that_agency_incurred" DOUBLE,
  "net_copy_delivery_costs_chargeable_to_requester" DOUBLE,
  "total_fees_costs_actually_paid_by_requesters_for_all_requests" DOUBLE,
  "total_net_fees_costs_chargeable_for_all_requests" DOUBLE,
  "total_gross_fees_costs_agency_incurred_for_all_requests" DOUBLE,
  "total_gross_fees_costs_incurred_but_not_charged_for_al_0e2843fa" DOUBLE,
  "total_net_fees_costs_actually_paid_for_complex_requests" DOUBLE,
  "total_net_fees_costs_chargeable_for_complex_requests" DOUBLE,
  "total_gross_fees_costs_incurred_for_complex_requests" DOUBLE,
  "total_gross_fees_costs_incurred_but_not_charged_for_co_7c531c9b" DOUBLE,
  "actual_payments_by_requesters_01_4_99" BIGINT,
  "n__actual_payments_by_requesters_5_49_99" BIGINT,
  "actual_payments_by_requesters_50_99_99" BIGINT,
  "actual_payments_by_requesters_100_499_99" BIGINT,
  "actual_payments_by_requesters_500_999_99" BIGINT,
  "actual_payments_by_requesters_1000_9999_99" BIGINT,
  "actual_payments_by_requesters_10_000" BIGINT,
  "n__of_workdays_to_complete_all_requests" BIGINT,
  "n__of_workdays_to_complete_complex_requests" DOUBLE,
  "n__of_workdays_to_complete_noncomplex_nonpersonal_requests" BIGINT,
  "n__of_workdays_to_complete_personal_record_requests" DOUBLE,
  "n__of_search_hours_incurred_for_all_requests" DOUBLE,
  "n__of_search_hours_incurred_for_complex_requests" DOUBLE,
  "n__of_search_hours_incurred_for_noncomplex_nonpersonal_requests" DOUBLE,
  "n__of_search_hours_incurred_for_personal_record_requests" DOUBLE,
  "n__of_review_segregation_hours_incurred_for_all_requests" DOUBLE,
  "n__of_review_segregation_hours_incurred_for_complex_requests" DOUBLE,
  "n__of_review_segregation_hours_incurred_for_noncomplex_22579cf1" DOUBLE,
  "n__of_review_segregation_hours_incurred_for_personal_requests" DOUBLE,
  "routine_requests" DOUBLE
);