About this Dataset

Audits

Historical audit documents for Oregon. This data populates the Audits Search tool at https://sos.oregon.gov/audits/Pages/stateaudits.aspx

If you are using the data raw, preface each number in a url field with http://records.sos.state.or.us/ORSOSWebDrawer/Recordpdf/

Example: http://records.sos.state.or.us/ORSOSWebDrawer/Recordpdf/6402626
Organization: State of Oregon
Last updated: 2020-11-10T17:22:53.648721
Tags: audit, cafr

Tables

Table 1

@usgov.state_of_oregon_audits.table_1

89.6 kB
2,124 rows
30 columns

CREATE TABLE table_1 (
  "agency" VARCHAR,
  "report_name" VARCHAR,
  "report_number" VARCHAR,
  "month" BIGINT,
  "year" BIGINT,
  "contract_audit" VARCHAR,
  "url" DOUBLE,
  "type" VARCHAR,
  "supp_doc_name1" VARCHAR,
  "supp_doc_num1" VARCHAR,
  "support_doc_url1" DOUBLE,
  "supp_doc_name2" VARCHAR,
  "supp_doc_num2" VARCHAR,
  "support_doc_url2" DOUBLE,
  "supp_doc_name3" VARCHAR,
  "supp_doc_num3" VARCHAR,
  "support_doc_url3" DOUBLE,
  "supp_doc_name4" VARCHAR,
  "supp_doc_num4" VARCHAR,
  "support_doc_url4" DOUBLE,
  "supp_doc_name5" VARCHAR,
  "supp_doc_num5" VARCHAR,
  "support_doc_url5" DOUBLE,
  "supp_doc_name6" VARCHAR,
  "supp_doc_num6" VARCHAR,
  "support_doc_url6" DOUBLE,
  "supp_doc_name7" VARCHAR,
  "supp_doc_num7" VARCHAR,
  "support_doc_url7" VARCHAR,
  "day" DOUBLE
);