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

About this Dataset

OIP Master UIPA Record Request Semiannual Log For FY 2019

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

Tables

Table 1

@usgov.state_of_hawaii_oip_master_uipa_request_semiannual_log_edf84aec.table_1

72.43 KB
197 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" VARCHAR,
  "additional_response_fees_incurred_but_not_chargeable" VARCHAR,
  "n__30_fee_waiver" BIGINT,
  "n__60_public_interest_fee_waiver" BIGINT,
  "fees_for_personal_records" VARCHAR,
  "total_net_srs_fees_chargeable" VARCHAR,
  "gross_copy_delivery_costs_that_agency_incurred" VARCHAR,
  "net_copy_delivery_costs_chargeable_to_requester" VARCHAR,
  "total_fees_costs_actually_paid_by_requesters_for_all_requests" VARCHAR,
  "total_net_fees_costs_chargeable_for_all_requests" VARCHAR,
  "totalgross_fees_costs_agency_incurred_for_all_requests" VARCHAR,
  "total_gross_fees_costs_incurred_but_not_charged_for_al_0e2843fa" VARCHAR,
  "total_net_fees_costs_actually_paid_for_complex_requests" VARCHAR,
  "total_net_fees_costs_chargeable_for_complex_requests" VARCHAR,
  "total_gross_fees_costs_incurred_for_complex_requests" VARCHAR,
  "total_gross_fees_costs_incurred_but_not_charged_for_co_7c531c9b" VARCHAR,
  "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" DOUBLE,
  "actual_payments_by_requesters_1000_9999_99" DOUBLE,
  "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
);