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

About this Dataset

OIP Master UIPA Record Request Semiannual Log For FY 2017

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

Tables

Table 1

@usgov.state_of_hawaii_oip_master_uipa_request_semiannual_log_2c63e0af.table_1

75.73 KB
234 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" DOUBLE,
  "request_granted_in_full" BIGINT,
  "request_denied_in_full" BIGINT,
  "request_granted_denied_inpart" BIGINT,
  "agency_ultimately_unable_to_respond" BIGINT,
  "requester_withdrew" BIGINT,
  "requeste_rabandoned_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,
  "n__of_actual_payments_by_requesters_01_4_99" DOUBLE,
  "n__of_actual_payments_by_requesters_5_49_99" DOUBLE,
  "n__of_actual_payments_by_requesters_50_99_99" BIGINT,
  "n__of_actual_payments_by_requesters_100_499_99" BIGINT,
  "n__of_actual_payments_by_requesters_500_999_99" DOUBLE,
  "n__of_actual_payments_by_requesters_1000_9999_99" DOUBLE,
  "n__of_actual_payments_by_requesters_10_000" BIGINT,
  "n__of_workdays_to_complete_all_requests" BIGINT,
  "n__of_workdays_to_complete_complex_requests" BIGINT,
  "n__of_workdays_to_complete_noncomplex_nonpersonal_requests" BIGINT,
  "n__of_workdays_to_complete_personal_record_requests" BIGINT,
  "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" BIGINT
);