About this Dataset

Municipal Coronavirus Relief Fund (CRF) Expenditures By Town, July 1, 2020 - December 31, 2021 - Invoice Transactions

This dataset includes municipal reporting information for the Municipal Coronavirus Relief Fund (CRF) Program for Connecticut municipalities from July 1, 2020 - December 31, 2021. This dataset includes invoice transactions; payroll expenditures for this reporting period are published in a separate dataset available here: https://data.ct.gov/d/huqw-chzi/

Municipal expenditures from the previous reporting period (March 1 - June 30, 2020) are available here: https://data.ct.gov/d/3vh2-vbmk

The CRF Program was established by the CT Office of Policy and Management (OPM) to reimburse municipalities for costs incurred in responding to the COVID-19 pandemic with funds from the Federal Coronavirus Aid, Relief, and Economic Security Act (CARES Act).

More information about the CRF Program can be found here: https://portal.ct.gov/OPM/Coronavirus/Coronavirus-Relief-Fund/Municipal-CRF-Program
Organization: State of Connecticut
Last updated: 2022-04-28T02:49:12.248812
Tags: covid-19, crf, economic-recovery, municipal-coronavirus-relief-fund

Tables

Table 1

@usgov.state_of_connecticut_municipal_coronavirus_relief_fund_94f52f85.table_1

514.28 kB
10,838 rows
21 columns

CREATE TABLE table_1 (
  "town_code" BIGINT,
  "town_name" VARCHAR,
  "claim_period" VARCHAR,
  "submitted" VARCHAR,
  "name_of_payee" VARCHAR,
  "invoice_date" TIMESTAMP,
  "invoice_date_of_actual" TIMESTAMP,
  "invoice_date_of_grantee" TIMESTAMP,
  "invoice_grantee_check_number" VARCHAR,
  "invoice_number" VARCHAR,
  "po_number" VARCHAR,
  "vendor_w9_on_file" BOOLEAN,
  "approver_of_payment" VARCHAR,
  "category" VARCHAR,
  "description" VARCHAR,
  "fema_amount" DOUBLE,
  "fema_percentage" DOUBLE,
  "crf_amount" DOUBLE,
  "crf_percentage" DOUBLE,
  "total_amount" DOUBLE,
  "comments" VARCHAR
);