Name: Restaurant Revitalization Fund
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

Restaurant Revitalization Fund

Public US Government data about financial assistance to restaurants during the pandemic. According to the Small Business Administration website

The American Rescue Plan Act established the Restaurant Revitalization Fund (RRF) to provide funding to help restaurants and other eligible businesses keep their doors open. This program will provide restaurants with funding equal to their pandemic-related revenue loss up to $10 million per business and no more than $5 million per physical location. Recipients are not required to repay the funding as long as funds are used for eligible uses no later than March 11, 2023.

The original data and data dictionary are published here. I downloaded and minimally processed the data using this notebook.

Tables

Rrf Data

@kaggle.danb91_restaurant_revitalization_fund.rrf_data

6.58 MB
100,650 rows
29 columns

CREATE TABLE rrf_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "loannumber" BIGINT,
  "approvaldate" TIMESTAMP,
  "businessname" VARCHAR,
  "businessaddress" VARCHAR,
  "businesscity" VARCHAR,
  "businessstate" VARCHAR,
  "businesszip" BIGINT,
  "grantamount" DOUBLE,
  "franchisename" VARCHAR,
  "ruralurbanindicator" VARCHAR,
  "hubzoneindicator" VARCHAR,
  "cd" VARCHAR,
  "grant_purp_cons_outdoor_seating" VARCHAR,
  "grant_purpose_covered_supplier" VARCHAR,
  "grant_purpose_debt" VARCHAR,
  "grant_purpose_food" VARCHAR,
  "grant_purpose_maintenance_indoor" VARCHAR,
  "grant_purpose_operations" VARCHAR,
  "grant_purpose_payroll" VARCHAR,
  "grant_purpose_rent" VARCHAR,
  "grant_purpose_supplies" VARCHAR,
  "grant_purpose_utility" VARCHAR,
  "legalorganizationtype" VARCHAR,
  "lmiindicator" VARCHAR,
  "socioeconmicindicator" VARCHAR,
  "veteranindicator" VARCHAR,
  "womenownedindicator" VARCHAR,
  "restauranttype" VARCHAR
);

Rrf Dict

@kaggle.danb91_restaurant_revitalization_fund.rrf_dict

3.88 kB
28 rows
3 columns

CREATE TABLE rrf_dict (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "field_name" VARCHAR,
  "description" VARCHAR
);