About this Dataset

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

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 payroll transactions; invoice transactions for this reporting period are published in a separate dataset available here: https://data.ct.gov/d/2jh6-p828

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:45.457225
Tags: covid-19, crf, economic-recovery, municipal-coronavirus-relief-fund

Tables

Table 1

@usgov.state_of_connecticut_municipal_coronavirus_relief_fund_2cae87d1.table_1

539.67 kB
50,646 rows
14 columns

CREATE TABLE table_1 (
  "town_code" BIGINT,
  "town_name" VARCHAR,
  "claim_period" VARCHAR,
  "pay_period_check_date" TIMESTAMP,
  "pay_period_payroll_period_end" TIMESTAMP,
  "pay_period_individual_approving" VARCHAR,
  "employee_name" VARCHAR,
  "employee_title" VARCHAR,
  "pay_roll_type_of_payment" VARCHAR,
  "pay_roll_basis_for_pay" VARCHAR,
  "pay_roll_gross_pay" DOUBLE,
  "pay_roll_disbursement_amount" DOUBLE,
  "pay_roll_status" VARCHAR,
  "payroll_comments" VARCHAR
);