Spreadsheet: 874954d1721478502-pulling-data-from-multiple-tables-across-multiple-sheets-book_test-bsb-
Sheet: Raw Data

CON | Incident ID | Incident # | Run Number | Date | Call Type | Jurisdiction | Response Area | Pt Condition Description | Initial Priority Number | Final Priority Code | LOS | LOS  Requested | From Address | From City | Caller Type | Unit # | Outcome | Call [NAME] | Time Call Taking Complete | Time First Unit Assigned | Assigned | EnRoute | Wheels Rolling | Pckup Promised | Time Pickup Requested | At Scene | Time Depart Scene | Time Arrived Destination | Cleared | Response Time | Business Unit | Latitude | Longitude | To Location Name | To Address | To City | Billing
CON136 | [PHONE] | 51207979 | 21737285 | 2024-06-01 01:50:43 | System | AV911 | AVONDALE | 31 Unconscious / Fainting | A1 | A1 | ALS | ALS | 12707 W Parkway Ln | Avondale | Customer | WAr171 | Transport | 2024-06-01 01:50:43 | 2024-06-01 01:50:43 | 2024-06-01 01:00:11 | 2024-06-01 01:00:11 | 2024-06-01 01:51:51 | 2024-06-01 01:55:50 | 2024-06-01 01:50:43 | 2024-06-01 01:50:43 | 2024-06-01 01:13:11 | 2024-06-01 02:15:22 | 2024-06-01 02:30:46 | 2024-06-01 03:18:30 | 00:14:25 | SWA City Of Glendale EMS | 33.4037 | -112.332 | [NAME] | 13677 W McDowell Rd | Goodyear | F
CON136 | [PHONE] | 51208597 | 21737425 | 2024-06-01 02:16:31 | System | EL911 | EL MIRAGE | 28 Stroke | A1 | A1 | ALS | ALS | 16101 N El Mirage Rd | El Mirage | Customer | WAr121 | Transport | 2024-06-01 02:16:31 | 2024-06-01 02:16:31 | 2024-06-01 01:00:11 | 2024-06-01 01:00:28 | 2024-06-01 02:19:11 | 2024-06-01 02:19:47 | 2024-06-01 02:16:31 | 2024-06-01 02:16:31 | 2024-06-01 01:12:11 | 2024-06-01 02:31:15 | 2024-06-01 02:38:19 | 2024-06-01 03:35:20 | 00:10:47 | SWA City Of Glendale EMS | 33.6289 | -112.323 | Banner Boswell Medical Center | 10401 W Thunderbird Blvd | Sun City | F
CON136 | [PHONE] | 51209344 | 21737607 | 2024-06-01 03:13:08 | System | AV911 | AVONDALE | 13 Diabetic Problems | A2 | A1 | ALS | ALS | 102 S 4Th Ave | Avondale | Customer | WAr173 | Transport | 2024-06-01 03:13:08 | 2024-06-01 03:13:08 | 2024-06-01 01:00:11 | 2024-06-01 01:00:22 | 2024-06-01 03:13:42 | 2024-06-01 03:16:45 | 2024-06-01 03:13:08 | 2024-06-01 03:13:08 | 2024-06-01 01:13:11 | 2024-06-01 03:36:30 | 2024-06-01 03:44:54 | 2024-06-01 04:24:43 | 00:11:22 | SWA City Of Glendale EMS | 33.4344 | -112.355 | [NAME] | 13677 W McDowell Rd | Goodyear | F
CON136 | [PHONE] | 51209483 | 21737650 | 2024-06-01 03:24:22 | System | AV911 | AVONDALE | 31 Unconscious / Fainting | A1 | A1 | ALS | ALS | 10550 W Mcdowell Rd | Avondale | Customer | [NAME] | Transport | 2024-06-01 03:24:22 | 2024-06-01 03:24:22 | 2024-06-01 01:00:11 | 2024-06-01 01:00:31 | 2024-06-01 03:24:59 | 2024-06-01 03:29:41 | 2024-06-01 03:24:22 | 2024-06-01 03:24:22 | 2024-06-01 01:15:11 | 2024-06-01 03:39:13 | 2024-06-01 03:45:55 | 2024-06-01 04:22:49 | 00:07:57 | SWA City Of Glendale EMS | 33.4651 | -112.288 | Banner Estrella Medical Center | 9201 W Thomas Rd | Phoenix | F
CON136 | [PHONE] | 51212753 | 21738717 | 2024-06-01 07:45:23 | System | AV911 | AVONDALE | 13 Diabetic Problems | A1 | A1 | ALS | ALS | 12576 W Coronado Rd | Avondale | Customer | WAr173 | [NAME] | 2024-06-01 07:45:23 | 2024-06-01 07:45:23 | 2024-06-01 01:00:11 | 2024-06-01 01:00:11 | 2024-06-01 07:46:15 | 2024-06-01 07:50:30 | 2024-06-01 07:45:23 | 2024-06-01 07:45:23 | 2024-06-01 01:17:11 |  |  | 2024-06-01 08:16:17 | 00:10:07 | SWA City Of Glendale EMS | 33.4677 | -112.334 |  |  |  | F
CON136 | [PHONE] | 51213258 | 21738911 | 2024-06-01 08:12:48 | System | RMFD | RURAL METRO FIRE WEST | 06D02 - E - Breathing Problems - COPD (Emphysema/Chronic bronchitis) - DELTA. | MED-A | A1 | ALS | ALS | 9344 W San Miguel Ave | Glendale | Customer | [NAME] | Transport | 2024-06-01 08:12:48 | 2024-06-01 08:12:48 | 2024-06-01 01:00:11 | 2024-06-01 01:00:11 | 2024-06-01 08:15:51 | 2024-06-01 08:18:55 | 2024-06-01 08:12:48 | 2024-06-01 08:12:48 | 2024-06-01 01:20:11 | 2024-06-01 08:53:54 | 2024-06-01 09:02:52 | 2024-06-01 10:16:44 | 00:16:12 | SWA City Of Glendale EMS | 33.5192 | -112.262 | Banner Estrella Medical Center | 9201 W Thomas Rd | Phoenix | F
CON136 | [PHONE] | 51212829 | 21738739 | 2024-06-01 08:30:00 | Non-System | NCIFT | SURPRISE | Now - Customer Desire (60) | A7 | A1 | ALS | ALS | 16575 W Waddell Rd | Surprise | Hospital (H) | WA174 | Transport | 2024-06-01 07:50:26 | 2024-06-01 07:50:26 | 2024-06-01 01:00:11 | 2024-06-01 01:00:11 | 2024-06-01 09:37:03 | 2024-06-01 09:37:21 | 2024-06-01 08:30:00 | 2024-06-01 08:30:00 | 2024-06-01 01:25:11 | 2024-06-01 10:20:07 | 2024-06-01 10:52:39 | 2024-06-01 11:44:04 | [NAME] | SWA City Of Glendale EMS | 33.6097 | -112.415 | Honorhealth Sonoran Crossing Medical Center | 33400 N 32Nd Ave | Phoenix | F
CON136 | [PHONE] | 51215030 | 21739654 | 2024-06-01 09:53:27 | System | AV911 | AVONDALE | 26 Sick Person | A1 | A1 | ALS | ALS | 11901 W Mcdowell Rd | Avondale | Customer | WAr173 | Transport | 2024-06-01 09:53:27 | 2024-06-01 09:53:27 | 2024-06-01 01:00:11 | 2024-06-01 01:00:11 | 2024-06-01 09:53:49 | 2024-06-01 09:56:43 | 2024-06-01 09:53:27 | 2024-06-01 09:53:27 | 2024-06-01 01:00:11 | 2024-06-01 10:06:37 | 2024-06-01 10:17:19 | 2024-06-01 11:29:50 | 00:04:36 | SWA City Of Glendale EMS | 33.4637 | -112.317 | Banner Estrella Medical Center | 9201 W Thomas Rd | Phoenix | F