Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

COVID-19 Loan/Grant Report (Historical)

buv4-at34City Government12 columns
This dataset includes small business loans or grants issued for emergency COVID-19 financial assistance. Underlying data is provided by the Department of Small Business Services (SBS). Dollar amounts are in actual dollars.
View on NYC Open Data↗

Quality

A90.2 / 100

From a 404-row sample across 12 columns.

completeness100/ 25% weight
consistency75/ 20% weight
accuracy100/ 20% weight
timeliness68/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • COVID-19 Expenditures Report (Historical)0.45
    joins onpub_dtagy_name
  • COVID-19 Revenue Report (Historical)0.41
    joins onpub_dt
  • Social Distancing: Citywide Ambassador Data0.32
  • Tax Lien Sale Lists0.30
    joins onzip_code
  • Parks Closure Status Due to COVID-19: Adult Exercise Equipment0.28
  • DSNY Monthly Tonnage Data0.26

Geography

Has zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.

Sample rows

pub_dtagy_namebz_nametypezip_codebz_descfunding_sourceloan_numloan_amtfund_datemat_dateloan_desc
20201022Department of Small Business Services70 West 95th Street Cleaners, Inc.Small Business Loan10025Drycleaning and Laundry Services (except Coin-Operated)CRF1200009050000.002020-04-14T00:00:00.0002025-04-01T00:00:00.000Emergency Financing

Columns

12 queryable · 12 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
pub_dttext8-digit number for date of publication0%20201022of 1
agy_nametextThe name of the City agency awarding the loan or grant.0%Department of Small Busi…of 1
bz_nametextLegal name of the recipient of the loan or grant0%RFC PRODUCTIONSBK, LLCCEDENO DRIVING SCHOOLNNOWW Inc
typetextType of service provided, whether a loan or a grant.0%Small Business Loanof 1

Query this from your own app

GET /api/datasets/buv4-at34
GET /api/datasets/buv4-at34/quality
GET /api/datasets/buv4-at34/related
GET /api/columns?dataset=buv4-at34
Citywide Payroll Data (Fiscal Year)
0.26
  • 2020 Neighborhood Tabulation Areas (NTAs)0.26
    • 20201022Department of Small Business ServicesCleanlab, Inc.Small Business Loan10024Drycleaning and Laundry Services (except Coin-Operated)CRF1200009850000.002020-04-14T00:00:00.0002025-04-01T00:00:00.000Emergency Financing
    20201022Department of Small Business ServicesNicolas Cogrel, LLCSmall Business Loan10001FloristsCRF1200021650000.002020-04-14T00:00:00.0002025-04-01T00:00:00.000Emergency Financing
    20201022Department of Small Business ServicesShopboy LLCSmall Business Loan10013Other Clothing StoresCRF1200023450000.002020-04-14T00:00:00.0002025-04-01T00:00:00.000Emergency Financing
    20201022Department of Small Business ServicesDYNAMIC SMILE DENTAL PLLCSmall Business Loan10013Offices of DentistsCRF1200062050000.002020-05-21T00:00:00.0002025-05-01T00:00:00.000Emergency Financing
    20201022Department of Small Business ServicesGrand EndeavorsSmall Business Loan11211Drinking Places (Alcoholic Beverages)CRF1200042251000.002020-05-14T00:00:00.0002025-05-01T00:00:00.000Emergency Financing
    20201022Department of Small Business ServicesWangjo IncSmall Business Loan11373Food Service ContractorsCRF1200074551000.002020-06-12T00:00:00.0002025-06-01T00:00:00.000Emergency Financing
    20201022Department of Small Business ServicesJesse Dittmar Studio LLCSmall Business Loan11201Photography Studios, PortraitCRF1200006052000.002020-04-14T00:00:00.0002025-04-01T00:00:00.000Emergency Financing
    20201022Department of Small Business ServicesOfficeOpsSmall Business Loan11237Lessors of Residential Buildings and DwellingsCRF1200007552000.002020-04-16T00:00:00.0002025-04-01T00:00:00.000Emergency Financing
    20201022Department of Small Business ServicesLion's Cathedral Productions, LLCSmall Business Loan10065Theater Companies and Dinner TheatersCRF1200013252000.002020-04-22T00:00:00.0002025-04-01T00:00:00.000Emergency Financing
    zip_code
    text
    Zip Code of the Recipient entity.
    0%
    100181000110012
    bz_desctextBrief description of the type of business0%Full-Service RestaurantsOffices of DentistsAll Other Personal Servi…
    funding_sourcetextAbbreviation for the source of funding. CRF refers to the Coronavirus Relief Fund.0%CRFof 1
    loan_numtextSBS identification number for the loan or grant0%120006661200046912000064
    loan_amtintegerAmount for the loan or grant made to the Recipient.0%75000.0060000.0052000.00
    fund_datedatetimeDate of which the loan or grant was funded.0%2020-05-21T00:00:00.0002020-04-14T00:00:00.0002020-04-22T00:00:00.000
    mat_datedatetimeFor loans, the maturity date of the loan.0%2025-05-01T00:00:00.0002025-04-01T00:00:00.0002025-06-01T00:00:00.000of 4
    loan_desctextSBS description for the purpose of the loan or grant.0%Emergency Financingof 1