From a 500-row sample across 9 columns.
sponsornamecontractyearprogramname+4sponsornamecontractyearprogramname+3sponsornamecontractyearprogramname+2sponsornameprogramnameprovidertype| providertype | dfta_id | contractyear | sponsorname | programname | servicefromdate | servicetodate | entrytype | reportedamount |
|---|---|---|---|---|---|---|---|---|
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2022-07-01T00:00:00.000 | 2022-07-31T00:00:00.000 | Contracted Services | 4103 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
providertype | categorical | Types of services provided | 0% | Older Adult CenterNORC SitesCase Managementof 12 |
dfta_id | text | Provider ID Number | 0% | C17C35C83 |
contractyear | categorical | City fiscal year (runs from July-June) | 0% | 20232024of 2 |
sponsorname | text | Organization name of Sponsor (Provider) providing the program | 0% | The Jewish Association F…Catholic Charities Neigh… |
GET /api/datasets/tt8e-a9vn GET /api/datasets/tt8e-a9vn/quality GET /api/datasets/tt8e-a9vn/related GET /api/columns?dataset=tt8e-a9vn
dfta_iddfta_iddfta_id| 2022-08-01T00:00:00.000 |
| 2022-08-31T00:00:00.000 |
| Contracted Services |
| 5995 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2022-09-01T00:00:00.000 | 2022-09-30T00:00:00.000 | Contracted Services | 5246 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2022-10-01T00:00:00.000 | 2022-10-31T00:00:00.000 | Contracted Services | 6568 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2022-11-01T00:00:00.000 | 2022-11-30T00:00:00.000 | Contracted Services | 5288 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2022-12-01T00:00:00.000 | 2022-12-31T00:00:00.000 | Contracted Services | 2289 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2023-01-01T00:00:00.000 | 2023-01-31T00:00:00.000 | Contracted Services | 2542 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2023-02-01T00:00:00.000 | 2023-02-28T00:00:00.000 | Contracted Services | 1537 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2023-03-01T00:00:00.000 | 2023-03-31T00:00:00.000 | Contracted Services | 1095 |
| Caregiver Services | 3K4 | 2023 | Hamilton-Madison House, Inc. | 3K4-Hamilton-Madison House, Inc.-01|DFTABASELINE | 2023-04-01T00:00:00.000 | 2023-04-30T00:00:00.000 | Contracted Services | 2785 |
Regional Aid for Interim…programname | text | Name of program | 0% | 01|DFTAONETIME-COUNCIL, …HDM Rate IncreaseW22-04-MN|JASA Brookdale… |
servicefromdate | datetime | Start of timeframe when expense occurred | 0% | 2023-06-01T00:00:00.0002023-04-01T00:00:00.0002023-05-01T00:00:00.000 |
servicetodate | datetime | End of timeframe when expense occurred | 0% | 2023-06-30T00:00:00.0002023-04-30T00:00:00.0002023-03-31T00:00:00.000 |
entrytype | categorical | Type of reported expense | 0% | Personnel Service SalaryPersonnel Service Fringe…Indirect Rateof 10 |
reportedamount | integer | Amount of approved expense reported for the timeframe indicated | 0% | 03003000 |