OIP Master UIPA Record Request Semiannual Log For FY 2018

CREATE TABLE table_1 (
  "department" VARCHAR,
  "agency" VARCHAR,
  "personal_records_request" BIGINT  -- Personal Records Request?,
  "date_agency_received_request" BIGINT,
  "date_agency_s_notice_was_sent" BIGINT,
  "agency_s_initial_response_sent_within_10_work_days" BIGINT  -- Agency 's Initial Response Sent Within 10 Work Days,
  "request_needed_initial_clarification" BIGINT,
  "complex_request" BIGINT  -- Complex Request?,
  "n__agency_gave_incremental_responses" BIGINT  -- Agency Gave Incremental Responses?,
  "date_completed" BIGINT,
  "n__of_workdays_to_complete" BIGINT  -- # Of Workdays To Complete,
  "request_granted_in_full" BIGINT,
  "request_denied_in_full" BIGINT,
  "request_granted_denied_in_part" BIGINT  -- Request Granted/ Denied In Part,
  "agency_ultimately_unable_to_respond" BIGINT,
  "requester_withdrew" BIGINT,
  "requester_abandoned_or_failed_to_pay" BIGINT,
  "uipa_lawsuit_filed_against_agency" BIGINT  -- UIPA Lawsuit Filed Against Agency?,
  "actual_search_hours" DOUBLE,
  "n__actual_review_segregation_hours" DOUBLE  -- Actual Review/ Segregation Hours,
  "actual_legal_review_hours" DOUBLE,
  "total_actual_srs_legal_review_hours" DOUBLE  -- TOTAL Actual SRS & Legal Review Hours,
  "total_gross_srs_fees_incurred" DOUBLE,
  "additional_response_fees_incurred_but_not_chargeable" DOUBLE,
  "n__30_fee_waiver" BIGINT  -- $30 Fee Waiver,
  "n__60_public_interest_fee_waiver" BIGINT  -- $60 Public Interest Fee Waiver,
  "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 Fees & Costs ACTUALLY PAID By Requesters For ALL Requests,
  "total_net_fees_costs_chargeable_for_all_requests" DOUBLE  -- TOTAL NET Fees & Costs CHARGEABLE For ALL Requests,
  "total_gross_fees_costs_agency_incurred_for_all_requests" DOUBLE  -- TOTAL GROSS Fees & Costs Agency INCURRED For ALL Requests,
  "total_gross_fees_costs_incurred_but_not_charged_for_al_0e2843fa" DOUBLE  -- TOTAL GROSS Fees & Costs INCURRED BUT NOT CHARGED For ALL Requests,
  "total_net_fees_costs_actually_paid_for_complex_requests" DOUBLE  -- TOTAL NET Fees & Costs ACTUALLY PAID For COMPLEX Requests,
  "total_net_fees_costs_chargeable_for_complex_requests" DOUBLE  -- TOTAL NET Fees & Costs CHARGEABLE For COMPLEX Requests,
  "total_gross_fees_costs_incurred_for_complex_requests" DOUBLE  -- TOTAL GROSS Fees & Costs INCURRED For COMPLEX Requests,
  "total_gross_fees_costs_incurred_but_not_charged_for_co_7c531c9b" DOUBLE  -- TOTAL GROSS Fees & Costs INCURRED BUT NOT CHARGED For COMPLEX Requests,
  "actual_payments_by_requesters_01_4_99" BIGINT  -- ACTUAL PAYMENTS By Requesters $ .01-4.99,
  "n__actual_payments_by_requesters_5_49_99" BIGINT  -- ACTUAL PAYMENTS By Requesters $5-49.99,
  "actual_payments_by_requesters_50_99_99" BIGINT  -- ACTUAL PAYMENTS By Requesters $50-99.99,
  "actual_payments_by_requesters_100_499_99" BIGINT  -- ACTUAL PAYMENTS By Requesters $100-499.99,
  "actual_payments_by_requesters_500_999_99" BIGINT  -- ACTUAL PAYMENTS By Requesters $500-999.99,
  "actual_payments_by_requesters_1000_9999_99" BIGINT  -- ACTUAL PAYMENTS By Requesters $1000 - 9999.99,
  "actual_payments_by_requesters_10_000" BIGINT  -- ACTUAL PAYMENTS By Requesters $10,000+,
  "n__of_workdays_to_complete_all_requests" BIGINT  -- # Of Workdays To Complete ALL Requests,
  "n__of_workdays_to_complete_complex_requests" DOUBLE  -- # Of Workdays To Complete COMPLEX Requests,
  "n__of_workdays_to_complete_noncomplex_nonpersonal_requests" BIGINT  -- # Of Workdays To Complete NONCOMPLEX, NONPERSONAL RECORD Requests,
  "n__of_workdays_to_complete_personal_record_requests" DOUBLE  -- # Of Workdays To Complete PERSONAL RECORD Requests,
  "n__of_search_hours_incurred_for_all_requests" DOUBLE  -- # Of Search Hours Incurred For ALL Requests,
  "n__of_search_hours_incurred_for_complex_requests" DOUBLE  -- # Of Search Hours Incurred For COMPLEX Requests,
  "n__of_search_hours_incurred_for_noncomplex_nonpersonal_requests" DOUBLE  -- # Of Search Hours Incurred For NONCOMPLEX, NONPERSONAL RECORD Requests,
  "n__of_search_hours_incurred_for_personal_record_requests" DOUBLE  -- # Of Search Hours Incurred For PERSONAL RECORD Requests,
  "n__of_review_segregation_hours_incurred_for_all_requests" DOUBLE  -- # Of Review & Segregation Hours Incurred For ALL Requests,
  "n__of_review_segregation_hours_incurred_for_complex_requests" DOUBLE  -- # Of Review & Segregation Hours Incurred For COMPLEX Requests,
  "n__of_review_segregation_hours_incurred_for_noncomplex_22579cf1" DOUBLE  -- # Of Review & Segregation Hours Incurred For NONCOMPLEX, NONPERSONAL RECORD Requests,
  "n__of_review_segregation_hours_incurred_for_personal_requests" DOUBLE  -- # Of Review & Segregation Hours Incurred For PERSONAL RECORD Requests,
  "routine_requests" DOUBLE
);