home

GVI Single Audit findings database, FY2013–FY2024

Every finding in 12 consecutive Government of the Virgin Islands Single Audits (FY2013–FY2024), parsed from the audit PDFs: 821 findings, 228 repeat-finding lineages, 1,111 corrective actions, program opinions, and prior-finding statuses. SEFA totals reconcile dollar-exact with the Federal Audit Clearinghouse for all 12 years. Questioned-cost dollar amounts are withheld while machine-extracted values remain unverified (qc_verified=0) — quote dollars from the audit PDF, not from here. Every row's lf_id/records_url resolves to the source audit's permanent page on usvipublicrecords.com.

Data source: GVI Audit Census (VI Update / Brian Louden)

Tables

audits

fy, auditee, auditor, report_date, sefa_total, sefa_total_verified, passthrough_total, type_ab_threshold, low_risk_auditee, fac_accepted_date, fac_fed_expend, lag_months, pdf_url, sha256, page_count, lf_id, records_url

12 rows

corrective_actions

fy, finding_no, planned_action, responsible_official, target_completion_date

1,111 rows

finding_lineage

lineage_id, canonical_title, first_fy, last_fy, consecutive_years, fy_list, member_count, total_questioned_costs, times_management_concurred, ever_marked_corrected, reappeared_after_corrected, signals

228 rows

findings

fy, auditee, finding_no, sub, parent_finding_no, prefix_year, carried_forward, title, section, severity, aln, program_name, compliance_requirement, questioned_costs_usd, qc_verified, criteria, condition, cause, effect, recommendation, management_response, page_start, lf_id, records_url

821 rows

opinion_units

fy, auditee, opinion_unit, opinion

83 rows

prior_finding_status

fy_reported, prior_finding_no, prior_fy, status, explanation, restated_as_finding_no

405 rows

program_opinions

fy, auditee, aln, program_name, opinion, is_cluster, finding_no, compliance_requirement

237 rows

sources

fy, auditee, pdf_url, sha256, fetched_at, page_count, lf_id, records_url

12 rows

Powered by Datasette · Queries took 16.008ms · Data source: GVI Audit Census (VI Update / Brian Louden)