bloom-housing / bloom

Bloom is Exygy’s affordable housing platform. Bloom's goal is to be a single entry point for affordable housing seekers and a hub for application and listing management for developers.
https://bloomhousing.com
Apache License 2.0
33 stars 25 forks source link

Bi-Annual Report Application Data Pull #4197

Closed iph-97 closed 2 months ago

iph-97 commented 3 months ago

To write the bi-annual reports, I need a full application data pull of all applications received in a jurisdiction between 1/1/24 and 7/1/24. I can do this manually for SJ and SMC, but for some larger application datasets on AC listings, I need a manual pull. It would be super awesome the get all of this pulled for me, but that is not necessary if it adds more work.

I need the following columns for each application: 'Primary Applicant First Name', 'Primary Applicant Last Name', 'Primary Applicant Birthday', 'Primary Applicant Email Address', 'Application Type', 'Application Submission Date', 'Primary Applicant City', 'Income', 'Income Period', 'Accessibility Mobility', 'Accessibility Vision', 'Accessibility Hearing', 'Vouchers or Subsidies', 'Requested Unit Types', 'Household Size', 'Flagged As Duplicate', 'Ethnicity', 'Race', 'How Did You Hear'

I also need all preference columns and which listing they are associated with. Ideally the listing ID! Happy to provide more info. This is a low priority request.