neon_queries documentation

sql_funcs houses all individual queries, while reporting_funcs streamlines the process of reporting many functions. For a table of example queries, check the sql_funcs reference table, and for a walkthrough of reports check report examples.

Full Table of Contents

Pages

• sql_funcs documentation
  • General Functions
    • Queries
      • __init__()
      • assess_assm()
      • assess_assm_improvement()
      • assess_outreach_completion()
      • assess_cm_tracker()
      • assess_score_change()
      • assess_risk_factor_assessments()
      • custody_status()
      • dem_address()
      • dem_age()
      • dem_race_gender()
      • dem_edu_employ_tracker()
      • enrollment()
      • enrollment_bundles()
      • enrollment_caseloads()
      • enrollment_flow()
      • enrollment_monthly()
      • incident_tally()
      • incident_type_tally()
      • idhs_incidents()
      • incident_response()
      • isp_goal_tracker()
      • isp_tracker()
      • isp_discharged()
      • legal_bonanza()
      • legal_bonanza_2()
      • legal_tally()
      • legal_rearrested()
      • legal_rearrested_details()
      • legal_rjcc()
      • linkages_edu_completed()
      • linkages_edu_employ()
      • linkages_edu_employ_new()
      • linkages_isp_goals()
      • linkages_monthly()
      • linkages_high_pcl()
      • linkages_percent()
      • linkages_tally()
      • linkages_total()
      • outreach_canvassing()
      • outreach_elig_tally()
      • outreach_elig_factors()
      • mediation_info()
      • mediation_tally()
      • session_tally()
      • session_avg_time_per_client()
      • session_frequency()
      • session_time_per_topic()
  • Specific-Use Functions
    • Audits
      • __init__()
      • active_missing_intake()
      • program_lacks_services()
      • service_lacks_grant()
      • service_lacks_staff()
      • staff_lacks_service()
      • legal_audit_lawyers()
      • missing_address_info()
      • missing_edu_employ()
      • active_session_tally()
      • cm_isp_status()
      • cm_missing_clinical_assess()
      • cm_linkage_totals()
      • cm_linkage_timeframe_info()
      • outreach_missing_eligibility()
      • outreach_missing_assessments()
    • ReferralAsks
      • __init__()
      • highest_cases()
      • cm_closures()
      • cpic_summary()
      • missing_isp()
      • last_30_days()
    • Grants
      • __init__()
      • audit_neighborhoods()
      • a2j_intake()
      • a2j_import()
      • cvi_demographics()
      • cvi_mental_health_linkages()
      • cvi_post_incident()
      • idhs_enrollment()
      • idhs_race_gender()
      • idhs_language()
      • idhs_age()
      • idhs_linkages()
      • idhs_linkages_detailed()
      • idhs_r_schooling_gender()
      • idhs_r_age_gender()
      • jac_linkages()
      • r3_ages()
      • ryds_ages()
      • ryds_curriculum()
      • victim_services_sessions()
  • Setup
    • Tables
      • __init__()
      • query_run()
      • query_modify()
      • stints_cloud_run()
      • stints_run()
      • run_report()
      • run_projections()
      • table_update()
• sql_funcs reference table
• reporting_funcs documentation
  • Report
    • __init__()
    • run_a_report()
    • report_to_excel()
    • make_date_dict()
    • generate_reports()
    • consolidate_query_outputs()
  • ReportFromXlsxTemplate
    • __init__()
    • filter_query_df()
    • format_df()
    • parse_df()
    • format_dictionary()
    • generate_output_dictionary()
    • format_output_dictionary()
    • find_missing_outputs()
    • add_missing_outputs()
    • report_to_excel()
• report examples
  • initializing a Report object
    • report_functions
    • engine_settings
    • Actual Setup of the Report Object
  • Using the Report Object
    • Inspecting Report Outputs
    • creating an excel file
  • Example Reports
    • IDHS
    • Monthly Referral Meeting
    • Data Digests