Restaurant Revitalization Fund

Which restaurants received US Government assistance during the pandemic

@kaggle.danb91_restaurant_revitalization_fund

Table List

2 tables(6.28 MB)

Rrf Data

@kaggle.danb91_restaurant_revitalization_fund.rrf_data

6.28 MB
100650 rows
29 columns

unnamed_0 Unnamed: 0	loannumber LoanNumber	approvaldate ApprovalDate	businessname BusinessName	businessaddress BusinessAddress	businesscity BusinessCity	businessstate BusinessState	businesszip BusinessZip	grantamount GrantAmount	franchisename FranchiseName	ruralurbanindicator RuralUrbanIndicator	hubzoneindicator HubzoneIndicator	cd CD	grant_purp_cons_outdoor_seating Grant Purp Cons Outdoor Seating	grant_purpose_covered_supplier Grant Purpose Covered Supplier	grant_purpose_debt Grant Purpose Debt	grant_purpose_food Grant Purpose Food	grant_purpose_maintenance_indoor Grant Purpose Maintenance Indoor	grant_purpose_operations Grant Purpose Operations	grant_purpose_payroll Grant Purpose Payroll	grant_purpose_rent Grant Purpose Rent	grant_purpose_supplies Grant Purpose Supplies	grant_purpose_utility Grant Purpose Utility	legalorganizationtype LegalOrganizationType	lmiindicator LMIIndicator	socioeconmicindicator SocioeconmicIndicator	veteranindicator VeteranIndicator	womenownedindicator WomenOwnedIndicator	restauranttype RestaurantType
	1036429110	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	KB V LLC	852 W Fulton Market St	Chicago	IL	60607	819728.2	nan	U	N	IL-07	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Limited Liability Company(LLC)	N	N	N	N	Restaurant
1	1036439102	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Champs Diner	197 Meserole Street	Brooklyn	NY	11206	1766654.57	nan	U	Y	NY-07	N	N	N	N	Y	N	Y	Y	Y	N	Subchapter S Corporation	Y	N	N	N	Restaurant
2	1036449105	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	KRH LLC	5055 N High St	Columbus	OH	43214	51044	Subway	U	Y	OH-03	N	N	N	Y	Y	Y	Y	Y	Y	Y	Limited Liability Company(LLC)	N	N	N	N	Restaurant
3	1036459108	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Del Road	550 W Date St Ste B	San Diego	CA	92101	1414662.2	nan	U	N	CA-51	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Limited Liability Company(LLC)	N	N	N	N	Restaurant
4	1036469100	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	DOJ DONUTS LLC	25 MARKET STREET	TRENTON	NJ	8611	310688	Dunkin' Donuts	U	Y	NJ-04	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Limited Liability Company(LLC)	Y	N	N	N	Restaurant
5	1036479103	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	111 W Hubbard Partnership	111 W Hubbard St	Chicago	IL	60654	3561150	nan	U	N	IL-07	N	N	N	Y	Y	Y	Y	Y	Y	Y	Limited Liability Partnership	N	N	N	N	Bar, Saloon, Lounge, Tavern && Restaurant
6	1036489106	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	TCIrving2950 LLC	2950 N Belt Line Rd	Irving	TX	75062	819921.98	nan	U	N	TX-24	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Limited Liability Company(LLC)	Y	N	N	N	Restaurant
7	1036499109	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Ferraros Pizza Forte Ballpark LLC	1650 S Pavilion Center Dr	Las Vegas	NV	89135	45980.65	nan	U	N	NV-03	N	Y	Y	Y	Y	Y	Y	Y	Y	N	Limited Liability Company(LLC)	N	N	N	N	Food Stand, Food Truck, Food Cart
8	1036509110	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Money Pancho Mexican Restaurants Inc.	3661 Las Posas Rd Ste 165G	Camarillo	CA	93010	52582.5	nan	U	N	CA-26	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Corporation	N	N	N	N	Other && Bar, Saloon, Lounge, Tavern && Caterer && Restaurant
9	1036519102	Thu Jun 17 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	GT Perryville LLC	1201 Chesapeake Overlook Pkwy	Perryville	MD	21903	494595.02	The Greene Turtle	R	N	MD-01	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	Limited Liability Company(LLC)	N	N	N	N	Restaurant


CREATE TABLE rrf_data (
  "unnamed_0" BIGINT,
  "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
);