Spreadsheet: 847068d1698160570-relationship-between-tables-unique-dates-1-
Sheet: Sheet1

Date of ASA | Weekday | Medical # | Client Name | Provider | Phone | Housing location | Address of Housing | Location of ASA | Referral Source | Notified | NOTES | Emergency Contact Notified | Reason For Leaving | Other facility | Reason for seeking other services
2023-03-01 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA |  |  |  |  |  |  | 7
2023-03-01 00:00:00 |  |  |  |  |  | SCSL |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-02 00:00:00 | 2
2023-03-01 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-03 00:00:00 | 2
2023-03-01 00:00:00 |  |  |  |  |  | Hughes |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-04 00:00:00 | 4
2023-03-01 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-05 00:00:00 | 8
2023-03-01 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-06 00:00:00 | 4
2023-03-01 00:00:00 |  |  |  |  |  | SSOP |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-07 00:00:00 | 6
2023-03-02 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-08 00:00:00 | 7
2023-03-02 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-09 00:00:00 | 5
2023-03-03 00:00:00 |  |  |  |  |  | Crisis Center |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-10 00:00:00 | 1
2023-03-03 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-11 00:00:00 | 4
2023-03-04 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-12 00:00:00 | 4
2023-03-04 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA |  |  |  |  |  | 2023-03-13 00:00:00 | 4
2023-03-04 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-04 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-05 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-05 00:00:00 |  |  |  |  |  | LCB |  |  |  |  |  | NA
2023-03-05 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-05 00:00:00 |  |  |  |  |  | LCB |  |  |  |  |  | NA
2023-03-05 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA
2023-03-05 00:00:00 |  |  |  |  |  | LCB |  |  |  |  |  | NA
2023-03-05 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA
2023-03-05 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-06 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA
2023-03-06 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA
2023-03-06 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-06 00:00:00 |  |  |  |  |  | LCB |  |  |  |  |  | NA
2023-03-07 00:00:00 |  |  |  |  |  | LCB |  |  |  |  |  | NA
2023-03-07 00:00:00 |  |  |  |  |  | Crisis Center |  |  |  |  |  | NA
2023-03-07 00:00:00 |  |  |  |  |  | LCB |  |  |  |  |  | NA
2023-03-07 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-07 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-07 00:00:00 |  |  |  |  |  | Crisis Center |  |  |  |  |  | NA
2023-03-08 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-08 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-08 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-08 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-08 00:00:00 |  |  |  |  |  | Day One |  |  |  |  |  | NA
2023-03-08 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-08 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA
2023-03-09 00:00:00 |  |  |  |  |  | Day One |  |  |  |  |  | NA
2023-03-09 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-09 00:00:00 |  |  |  |  |  | Crisis Center |  |  |  |  |  | NA
2023-03-09 00:00:00 |  |  |  |  |  | Crisis Center |  |  |  |  |  | NA
2023-03-09 00:00:00 |  |  |  |  |  | Hughes |  |  |  |  |  | NA
2023-03-10 00:00:00 |  |  |  |  |  | [NAME] |  |  |  |  |  | NA
2023-03-11 00:00:00 |  |  |  |  |  | ACSL |  |  |  |  |  | NA
2023-03-11 00:00:00 |  |  |  |  |  | Hughes |  |  |  |  |  | NA
2023-03-11 00:00:00 |  |  |  |  |  | ACM |  |  |  |  |  | NA
2023-03-11 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-12 00:00:00 |  |  |  |  |  | SCSL |  |  |  |  |  | NA
2023-03-12 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-12 00:00:00 |  |  |  |  |  | Transitional |  |  |  |  |  | NA
2023-03-12 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-13 00:00:00 |  |  |  |  |  | SCSL |  |  |  |  |  | NA
2023-03-13 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-13 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA
2023-03-13 00:00:00 |  |  |  |  |  | Foundations |  |  |  |  |  | NA