This dataset contains all applicants for emergency rental and/or utility assistance in the Neighborly system.
This dataset has the following 55 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Row ID | id | number | 16336 10051 48498 48194 21232 view top 100 | |
| Case ID | case_id | number | 70315 34275 83970 48498 48194 view top 100 | |
| Case Status | case_status | text | Application in Progress Denied Duplicate Case Recertification In Progress Paid view top 100 | |
| Case: Date Created | case_datecreated | calendar_date | 2021-03-01T00:00:00.000 2021-03-02T00:00:00.000 2021-08-02T00:00:00.000 2021-03-03T00:00:00.000 2021-08-03T00:00:00.000 view top 100 | |
| Case: Program Year | case_programyear | number | 2021 view top 100 | |
| Funding Total Amount | funding_totalamount | number | 0 7800 3900 9000 5200 view top 100 | |
| Borrower 1: Age | borrower_1_age | number | 30 32 31 33 29 view top 100 | |
| Borrower 1: Ethnicity | borrower_1_ethnicity | text | Non-Hispanic or Latino Refuse to Answer Hispanic or Latino view top 100 | |
| Borrower 1: Gender | borrower_1_gender | text | Female Male Gender Non-Conforming Trans Female (Male to Female) Trans Male (Female to Male) view top 100 | |
| Borrower 1: Race | borrower_1_race | text | Black or African American Multi-Racial White Refuse to Answer American Indian or Alaska Native view top 100 | |
| borrower_1_relationshiptoheadofhousehold | borrower_1_relationshiptoheadofhousehold | text | Self Head of household's child Head of household's spouse or partner Head of household's other relation member (other relation to head of household) Other: non-relation member view top 100 | |
| Case: Landlord Case ID | case_landlordcaseid | number | 30532 32821 48280 41342 41586 view top 100 | |
| Case: Landlord Case Name | case_landlordcasename | text | The Park at Morella Colony Regency Partners LTD, dba Regency Park Apartments The Park at Galaway/ Parkside Camp Creek Arium Morgan Falls Apartments South The Amherst Group LLC F/K/A Amherst Residential LLC view top 100 | |
| Household AMI Ratio | household_amiratio | number | 80 0 83.37 83.4 83.43 view top 100 | |
| Household AMI Ratio Rounded | household_amiratio_rounded | number | 80 30 50 60 view top 100 | |
| Household Annual Income | household_annualincome | number | 48300 0 55200 62100 68950 view top 100 | |
| Household Monthly Income | household_monthlyincome | number | 4025 0 4600 5175 5745.83 view top 100 | |
| Household Size | household_size | number | 1 2 3 4 5 view top 100 | |
| Tenant Code | tenantcode | text | ERAP-FULTONCOUNTYGA view top 100 | |
| Submit Completed Date | submit_completeddate | calendar_date | 2021-03-02T00:00:00.000 2021-03-01T00:00:00.000 2021-03-03T00:00:00.000 2021-08-02T00:00:00.000 2021-03-15T00:00:00.000 view top 100 | |
| Total Rental Assistance Requested | total_rental_assistance_requested | number | 0 3000 3900 6000 7800 view top 100 | |
| Electricity Assistance Requested | electricity | number | 0 200 300 600 400 view top 100 | |
| Gas Assistance Requested | gas | number | 0 200 300 400 100 view top 100 | |
| Water Assistance Requested | water | number | 0 300 200 400 100 view top 100 | |
| Total Utility Assistance Requested | total_utility_requested | number | 0 200 300 600 400 view top 100 | |
| Total Assistance Approved | total_assistance_approved | number | 0 7800 3900 9000 5200 view top 100 | |
| Total Assistance Requested | total_assistance_requested | number | Rental + Utility; Utility = Gas + Water + Electricity | 0 3000 6000 3600 4800 view top 100 |
| Today | today | calendar_date | Today's date | 2024-02-19T00:00:00.000 view top 100 |
| applicantinfo_applicanthome_zip_clean | applicantinfo_applicanthome_zip_clean | number | 30349 30344 30331 30291 30350 view top 100 | |
| score | score | number | Score from geocoding. Higher score means more accurate/reliable geocoded point | 100 90.87 99.55 0 95.21 view top 100 |
| x | x | number | Applicant home address lat | -84.48734604 -84.49230201 -84.52891852 -84.49607186 -84.53068542 view top 100 |
| y | y | number | Applicant home address lon | 33.70836999 33.6315732 33.58661258 33.63091618 33.58329773 view top 100 |
| City | city | text | Actual applicant city | Address Not Provided or Incomplete Atlanta South Fulton East Point Sandy Springs view top 100 |
| District | district | text | Actual applicant commission district | Address Not Provided or Incomplete District 6 District 5 District 4 District 2 view top 100 |
| Geocoded | geocoded | checkbox | true false view top 100 | |
| Zip_Latitude | zip_latitude | number | 33.623227134666 33.6730112639137 33.7034531666661 33.5766172277425 33.9788804382285 view top 100 | |
| Zip_Longitude | zip_longitude | number | -84.525509663016 -84.4646137630501 -84.5457110854047 -84.5416539412239 -84.3332872280231 view top 100 | |
| CL_Latitude | cl_latitude | number | 33.7630780621068 33.6359291348216 33.6696716259648 33.9365358375266 33.5941330922595 view top 100 | |
| CL_Longitude | cl_longitude | number | -84.4286788401172 -84.5797316748002 -84.4700825599885 -84.3704186289487 -84.5628912991198 view top 100 | |
| CD_Latitude | cd_latitude | number | 33.6068587572448 33.6798683340169 33.7669436634111 34.0794333152755 33.8622857735145 view top 100 | |
| CD_Longitude | cd_longitude | number | -84.6208768207976 -84.4603758147468 -84.4468797728736 -84.3383014415765 -84.3953310669609 view top 100 | |
| City of Atlanta | coa | checkbox | TRUE if applicant lives within COA as determined by geocoding. | false true view top 100 |
| Applicant Home Point | applicant_home_point | point | {"coordinates":[33.70836999,-84.48734604],"type":"Point"} {"coordinates":[33.6315732,-84.49230201],"type":"Point"} {"coordinates":[33.58661258,-84.52891852],"type":"Point"} {"coordinates":[33.63091618,-84.49607186],"type":"Point"} {"coordinates":[33.58329773,-84.53068542],"type":"Point"} view top 100 | |
| Percent of Request Approved | percent_req_approved | number | 0 1 1.5 0.75 1.33333333333333 view top 100 | |
| City of Atlanta (text) | coa_text | text | Fulton Service Area COA Service Area view top 100 | |
| Out of County | out_of_county | checkbox | false true view top 100 | |
| Out of County Text | out_of_county_text | text | Fulton County Out of County view top 100 | |
| Fulton Service Area | fsa | checkbox | TRUE if applicant is in the Fulton County service area. False if applicant is in City of Atlanta or Out Of County | true false view top 100 |
| Fulton Service Area Text | fsa_text | text | Address Not Provided or Incomplete Fulton Service Area Non Fulton Service Area view top 100 | |
| Check Disbursement Date | ams_disb_date | calendar_date | Date the check was disbursed. Sourced from AMS. | 2022-11-02T00:00:00.000 2021-07-21T00:00:00.000 2022-01-31T00:00:00.000 2021-12-20T00:00:00.000 2022-02-01T00:00:00.000 view top 100 |
| AMS Amount | ams_amount | number | Amount of the check, from AMS. May differ from the Total Assistance Approved field, as payments lag behind approved payments. | 7800 3900 9000 5200 3600 view top 100 |
| Days from Creation to Submitted | create_to_submit | number | Days from application created to application submitted | 0 1 2 3 4 view top 100 |
| Submit to Disbursement | submit_to_disbursement | number | Days from application submitted to check disbursement | 21 36 29 35 49 view top 100 |
| Duplicate | duplicate_app | checkbox | TRUE if this application is a duplicate submission by the applicant, FALSE otherwise | false true view top 100 |
| Case Status 2 | case_status_2 | text | Application in Progress Denied Duplicate Case Recertification In Progress Paid view top 100 |