data analytics

Description

Using the attached dataset and Excel, organize the data by sorting on the variable TYPE_CNTRL from lowest to highest. For this assignment, you will only use the data for City and County, District, State, and University, so copy rows with the values of 1,2,3,4 into a new dataset and label it Public Hospital Utilization. (Alternatively, you can delete the rows that do not have that type of control and save that reduced data as Public Hospital Utilization). For political reasons, the legislature does not want to do anything with the psychiatric facilities, so sort your new dataset using TYPE_LIC (License Category (Type)) and only keep the rows associated with a General Acute Care License.

Don't use plagiarized sources. Get Your Custom Assignment on
data analytics
From as Little as $13/Page

Using this new dataset Public Hospital Utilization, which should have 70 observations and 43 variables, complete the following:

Part 1:

Create a table with frequency, relative frequency, and cumulative relative frequency for the categorical variables TRAUMA_CTR, TEACH_HOSP, and TYPE_CNTRL. Be sure to identify the actual variable name for these as a heading to your tables. (Use whatever method you wish to create these tables – all Excel, some Excel and some hand-calculated, all hand-calculated).
Interpret the frequency results for each variable; be sure to replace the numbers with the value name per Table 4 in the Code Book.
Include the appropriate graphs and tables for each variable in a word document. Label each with the variable name (Code Book)

Part 2:

Using Excel, compute the appropriate descriptive statistics for variables MED_SURG_LICBED_DAY, MED_SURG_CENS_DAY, GAC_LICBED_DAY_SUBTOTL, and SENATE_DIST based on their level of measurement.
Create an appropriate graph to display the descriptive statistics for each variable
Include a screenshot of the results for each variable as well as the graphs in your word document from Part 1.
Interpret the mean and standard deviation of the quantitative variables and include in your word document.
For each of the variables, discuss why you choose that descriptive statistic and graph.
Support your response using references to the Unit 1 content
Suggest an alternative approach or graph you could have used to describe that variable

Include at least one external source to support your written responses to parts 1 and 2.


Unformatted Attachment Preview

FAC_CITY
BANNING
PORTOLA
ALTURAS
BIG BEAR LAKE
COALINGA
ESCONDIDO
FALL RIVER MILLS
FORT BRAGG
GARBERVILLE
HEALDSBURG
HOLLISTER
HOLLISTER
LAKE ISABELLA
LONE PINE
MAMMOTH LAKES
SALINAS
WEAVERVILLE
DOWNEY
LA JOLLA
LOS ANGELES
COSTA MESA
ELDRIDGE
PORTERVILLE
BISHOP
BLYTHE
CEDARVILLE
LAKE ARROWHEAD
LOMPOC
MARIPOSA
OAKDALE
OCEANSIDE
PORTERVILLE
POWAY
SONOMA
TRUCKEE
TULARE
VICTORVILLE
SAN FRANCISCO
SAN LEANDRO
ORANGE
SACRAMENTO
SAN DIEGO
SAN FRANCISCO
SAN FRANCISCO
SANTA MONICA
SAN FRANCISCO
TRAUMA_CTR TEACH_HOSP ASSEMBLY_DIST SENATE_DIST CONGRESS_DIST
0
2
42
23
36
0
2
1
1
1
0
2
1
1
1
0
2
33
23
8
0
2
31
12
21
0
2
75
38
50
0
2
1
1
1
0
2
2
2
2
0
2
2
2
2
0
2
2
2
2
0
2
30
12
20
0
2
30
12
20
0
2
26
16
23
0
2
26
8
8
0
2
5
8
8
0
2
30
12
20
0
2
2
2
2
0
1
58
32
40
1
2
78
39
52
1
1
54
26
33
1
2
74
37
48
1
2
4
2
5
1
2
26
14
23
1
2
26
8
8
1
2
56
28
36
1
2
1
1
1
1
2
33
23
8
1
2
35
19
24
1
2
5
8
4
1
2
12
8
10
1
2
76
36
49
1
2
26
14
23
1
2
77
38
52
1
2
10
3
5
1
2
1
1
4
1
2
26
16
22
1
2
33
21
8
1
2
19
11
14
1
2
20
10
15
2
1
69
34
46
2
1
7
6
6
2
1
78
39
53
2
2
17
11
12
2
1
17
11
12
2
2
50
26
33
2
1
19
11
12
FREMONT
ALAMEDA
MARTINEZ
OAKLAND
SAN FRANCISCO
SAN LEANDRO
SAN MATEO
SANTA PAULA
SYLMAR
TORRANCE
ESCONDIDO
LANCASTER
BAKERSFIELD
COLTON
LOS ANGELES
MORENO VALLEY
SALINAS
SAN JOSE
VENTURA
BRAWLEY
VISALIA
CHESTER
EL CENTRO
FRENCH CAMP
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
4
4
4
4
4
2
2
2
1
1
2
2
2
1
1
2
2
1
1
1
1
2
1
2
2
2
2
2
2
20
18
14
18
17
18
22
37
39
66
75
36
32
47
51
61
30
28
37
56
26
1
56
13
10
9
3
9
11
9
13
19
18
35
38
21
16
20
24
31
12
15
19
40
16
1
40
5
17
13
5
13
12
13
14
26
29
43
50
23
23
31
34
41
20
18
26
51
22
1
51
9
TYPE_LIC
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
TYPE_CNTRL TYPE_SVC_PRINCIPAL MED_SURG_LICBED_DAY
2 General Medical / Surgical
17520
2 General Medical / Surgical
3285
2 General Medical / Surgical
5840
2 General Medical / Surgical
3285
2 General Medical / Surgical
8030
2 Physical Rehabilitation
57305
2 General Medical / Surgical
7300
2 General Medical / Surgical
13870
2 Other
3285
2 General Medical / Surgical
6205
2 Long-Term Care (SN/IC)
0
2 General Medical / Surgical
12045
2 Long-Term Care (SN/IC)
8760
2 Long-Term Care (SN/IC)
1460
2 General Medical / Surgical
4745
2 General Medical / Surgical
75920
2 General Medical / Surgical
9125
1 General Medical / Surgical
46355
4 General Medical / Surgical
93805
4 General Medical / Surgical
85410
3 Developmentally Disabled
10950
3 Developmentally Disabled
4745
3 Developmentally Disabled
15330
2 General Medical / Surgical
5840
2 General Medical / Surgical
14965
2 Other
1460
2 General Medical / Surgical
6205
2 General Medical / Surgical
17520
2 General Medical / Surgical
6570
2 General Medical / Surgical
10950
2 General Medical / Surgical
99280
2 General Medical / Surgical
39420
2 General Medical / Surgical
24820
2 General Medical / Surgical
13870
2 General Medical / Surgical
9125
2 General Medical / Surgical
22422
1 General Medical / Surgical
23360
1 Long-Term Care (SN/IC)
2190
1 Long-Term Care (SN/IC)
0
4 General Medical / Surgical
80300
4 General Medical / Surgical
127385
4 General Medical / Surgical
76285
4 General Medical / Surgical
20440
4 General Medical / Surgical
154395
4 General Medical / Surgical
64240
4 General Medical / Surgical
48545
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
2 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
2 General Medical / Surgical
2 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
2 General Medical / Surgical
2 General Medical / Surgical
2 General Medical / Surgical
1 General Medical / Surgical
1 General Medical / Surgical
94535
30660
36135
40880
67160
30660
31390
10950
73000
100740
74460
91615
29200
74095
125195
82125
22958
86634
29519
24090
89790
3650
40150
44165
MED_SURG_CENS_DAY ICU_LICBED_DAY ICU_CENS_DAY CCU_LICBED_DAY CCU_CENS_DAY
9528
5840
1711
0
0
1127
0
0
0
0
588
0
0
0
0
592
0
0
0
0
378
0
0
0
0
0
7665
0
5110
0
2162
0
0
0
0
792
1460
235
0
0
87
0
0
0
0
2393
1460
459
0
0
0
0
0
0
0
4027
2920
880
0
0
2416
1095
7
0
0
4
0
0
0
0
1098
730
49
0
0
36121
2190
1505
2555
1698
2067
0
0
0
0
24521
4380
1128
0
0
79827
17520
8335
4380
7593
90480
43800
42391
4380
4139
368
0
0
0
0
1404
0
0
0
0
730
0
0
0
0
2277
1460
284
0
0
2035
1460
12
0
0
33
0
0
0
0
1220
0
0
0
0
6098
2190
1081
0
0
884
0
0
0
0
2988
1825
336
0
0
38854
5110
2787
5110
2787
16878
3650
1648
0
0
13740
4380
2101
0
0
3148
2190
879
0
0
3067
2190
1060
0
0
7832
4242
628
0
0
17878
3650
1900
0
0
106
0
0
0
0
0
0
0
0
0
53037
21900
15921
0
0
111543
43070
32404
2920
2774
49197
11680
8224
4745
4021
14777
16790
11453
0
0
115499
31390
14940
5840
5216
57565
8030
6020
0
0
0
2555
0
0
0
52307
9815
28794
39492
62079
10393
13006
3029
45164
71082
62403
46701
20563
60956
119526
54638
14130
68316
11952
12285
77851
675
14283
30376
4745
2920
2920
8760
21170
3285
2555
2190
15330
16060
8760
7665
8760
17520
47450
16060
3650
16468
9585
2920
14965
0
7300
5840
4733
1513
2313
6773
9914
2055
1396
1495
3584
12301
5029
10238
6773
10350
28419
8502
2628
8636
2207
1426
1406
0
1849
4957
5840
2920
0
0
0
0
0
0
0
2190
8760
0
0
0
3650
0
0
3056
3285
0
0
0
0
0
2428
0
0
0
0
0
0
0
0
1702
5029
0
0
0
2584
0
0
2578
3285
0
0
0
0
0
GAC_LICBED_DAY_SUBTOTL
GAC_CENS_DAY_SUBTOTL
HOSP_LICBED_DAY_TOTL
28835
11815
28835
3285
1127
27375
5840
597
31755
3285
592
10950
8760
378
44895
97455
6824
106580
8030
2170
44165
17885
1447
17885
3285
87
6205
9490
2852
15695
0
0
22692
22630
6091
43435
9855
2423
36865
1460
4
13505
6205
1294
6205
95995
46630
95995
9125
2067
18250
105485
42760
105485
152570
117188
152570
162425
164075
162425
10950
368
444570
4745
1404
359890
16060
730
447490
9125
2963
9125
18615
2336
18615
1460
33
9490
6205
1220
13505
21900
8125
62050
6570
884
12410
12775
3324
54750
134320
57898
140890
48180
22013
60955
34675
18215
86140
17520
4309
27375
12775
5015
26280
33936
9578
33936
36865
22062
36865
4015
875
284700
18250
6549
58035
134685
89823
152205
228855
189004
228855
130670
66106
142350
105485
83793
105485
215350
135655
215350
96725
77317
96725
51100
0
51100
124465
36500
45260
61685
103660
33945
36500
17885
110595
151475
104390
142350
71905
133590
219000
132130
54750
191894
65700
39055
163520
3650
58765
71540
64935
11328
36310
52258
79804
12448
14427
5108
55117
94455
80045
78058
42098
100143
172734
76103
34827
116703
26934
19437
100601
675
18937
46421
124465
102565
60955
90885
144905
33945
185785
17885
129575
165345
104390
153300
81030
166440
246740
160235
62780
210144
81395
39055
212065
9490
58765
71540
HOSP_CENS_DAY_TOTL EMSA_TRAUMA_CTR_DESIG
11815
12323
13453
7667
25577
14257
29127
1447
2997
7815
18224
24022
26862
455
1294
46630
3970
42760
117188
164075
39938
93246
98550
3265
2336
7186
8051
43704
10052
36102
63455
34673
32251
10771
14406
9578
22062
277081
44771
102794
189004
75905
83793
135655
77317
0
ED_LIC_LEVL_END
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
1
1
3
3
3
0
3
3
3
3
0
1
3
3
3
1
3
0
1
2
0
0
0
1
3
3
3
1
3
1
1
1
1
1
1
1
1
0
0
2
2
2
1
1
1
0
64935
74766
42486
76571
107238
12448
35579
5108
66741
107401
80045
82350
49929
119771
192777
102211
39334
129362
36874
19437
113733
6369
18937
46421
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
4
4
4
4
4
1
1
1
1
2
1
1
1
1
1
1
1
1
1
2
1
1
2
1
1
1
3
1
1
ED_ANESTH_AVAIL_ON_CALL
ED_LAB_SVCS_AVAIL24HRS
1
1
1
1
2
2
2
1
1
1
1
1
2
2
1
1
1
2
2
2
1
1
1
1
1
2
1
1
2
2
2
1
2
1
1
2
2
2
2
2
2
2
2
2
2
1
ED_OP_RM_AVAIL24HRS
1
1
2
1
1
1
2
2
2
2
2
1
1
2
2
1
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
2
2
2
2
2
2
2
1
2
1
2
2
1
1
2
2
1
1
1
1
1
1
1
1
1
2
2
2
1
1
1
2
2
2
1
2
2
2
2
2
2
1
1
2
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
2
1
1
1
2
2
2
2
1
1
1
1
1
1
1
1
1
2
2
1
2
2
1
ED_PHARM_AVAIL24HRS
ED_PHYSN_AVAIL24HRS
2
2
2
2
2
1
2
2
2
2
2
2
1
2
2
1
2
2
1
1
1
1
1
2
2
2
2
2
2
1
1
1
2
2
1
1
2
2
1
1
1
1
1
1
1
ED_RADIOL_SVCS_AVAIL24HRS
1
1
2
1
1
2
1
1
1
1
2
1
2
2
2
1
1
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
2
2
1
1
1
1
1
1
1
1
2
1
1
1
2
2
2
1
1
1
1
1
1
1
1
1
1
1
2
1
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
1
2
2
2
1
2
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
EMS_VISITS_NON_URGENT_NOT_ADMITTED
EMS_VISITS_NON_URGENT_ADMITTED
1844
566
172
260
20
0
32
3
893
486
0
586
468
96
31
236
58
0
257
5670
0
0
0
532
198
0
826
896
477
742
9049
5406
153
55
529
95
2960
0
0
338
4616
554
2
8
6552
0
0
0
0
0
0
0
0
0
1
0
0
2
0
0
0
0
0
0
5
4
0
0
0
0
0
0
0
1
0
0
15
1
0
1
1
0
0
0
0
2
78
8
2
0
2
0
2510
553
3557
1191
1597
488
6204
78
3055
2622
335
1354
5897
8885
6614
7884
2684
86
259
1283
1659
153
2055
108
7
2
116
4
7
1
3
0
0
7
0
3
18
21
46
6
0
1
0
1
0
0
0
0
EMS_VISITS_URGENT_NOT_ADMITTED
EMS_VISITS_URGENT_ADMITTED
8514
1
1709
6
659
0
871
0
2277
0
0
0
798
3
729
0
1628
11
1339
0
0
0
9689
79
473
0
331
0
122
0
5705
5
1507
0
0
0
4035
81
5463
1
0
0
0
0
0
0
4342
27
3610
0
0
0
2579
0
2187
0
969
0
7963
0
9813
21
4578
1
2346
0
1293
0
1474
5
1792
0
7628
22
0
0
0
0
7502
229
14524
301
7784
307
2672
0
1925
7
6380
3
0
0
5728
2756
8746
7517
19620
6463
12558
1196
25615
22315
5819
27168
8630
14676
32361
3167
5221
1280
2881
1316
15896
1243
3481
12932
9
3
464
5
305
8
12
1
0
194
0
12
11
100
493
0
0
8
2
4
59
1
0
176
EMS_VISITS_MODERATE_NOT_ADMITTED
EMS_VISITS_MODERATE_ADMITTED
10549
2
1188
70
2189
0
4355
0
2173
0
0
0
1810
34
3991
0
1405
8
3529
0
0
0
6154
513
1984
21
524
1
3978
14
20617
125
2031
0
0
0
16997
5775
10642
1
0
0
0
0
0
0
2063
84
3691
0
231
3
3546
0
10268
4
3135
0
11431
0
13102
160
16958
23
9922
11
4199
4
4629
1
7374
3
14031
50
0
0
0
0
17465
4987
30032
4404
25714
6233
7843
9
9277
41
11358
15
0
0
17963
7033
16779
25630
25340
11855
10103
6191
27035
37301
25430
31669
13756
36599
73955
20562
20553
13811
14182
19466
42769
1040
20741
8936
46
66
969
143
4497
158
46
2
0
4473
47
43
77
2648
8530
22
0
89
19
47
7958
4
0
431
EMS_VISITS_SEVERE_NOT_ADMITTED
EMS_VISITS_SEVERE_ADMITTED
13758
286
254
14
1278
0
3633
0
2174
0
2
0
731
71
3652
0
399
7
2304
0
0
0
2457
518
2393
344
365
0
3704
34
18461
2005
603
36
0
0
975
1401
12663
79
0
0
0
0
0
0
1236
234
1850
0
81
2
1706
0
3287
18
1625
20
3940
0
13915
1331
12088
103
11101
158
3584
4
3187
35
6489
43
8917
42
0
0
0
0
6513
6483
10777
4966
3587
2675
2100
43
9656
107
13583
56
0
0
12389
3537
2927
20081
11465
7116
8095
4593
5644
10696
34881
47264
9330
10839
16523
17814
15846
16403
11399
21936
9663
482
15734
4727
134
1014
1611
698
4563
748
946
76
0
5919
311
234
400
4397
10374
46
0
1671
699
172
11646
12
0
1267
EMS_VISITS_CRITICAL_NOT_ADMITTED
EMS_VISITS_CRITICAL_ADMITTED
EMS_NO_ADM_VIS_TOTL
7188
2410
41853
22
1
3739
379
137
4677
2299
0
11418
2219
0
8863
30
0
32
506
119
3877
1166
458
9541
74
1
4399
1002
0
8660
0
0
0
777
263
19663
2184
69
7502
200
1
1516
934
343
8769
5520
5547
50539
281
259
4480
0
0
0
7
20
22271
7265
10481
41703
0
0
0
0
0
0
0
0
0
641
198
8814
143
0
9492
2
0
314
694
268
9351
6892
922
23530
670
179
6876
934
0
25010
10620
6312
56499
3068
3837
42098
5396
3510
28918
1009
770
10140
2805
506
12624
2560
1420
18310
1674
2576
35210
0
0
0
0
0
0
421
531
32239
10954
15380
70903
61
137
37700
597
1734
13214
10047
9328
30913
3738
8463
41611
0
0
0
4364
798
2785
5044
2318
5725
1501
1207
14
291
17943
5740
4165
2808
558
15068
7624
11334
2568
1043
428
106
6042
7397
6708
671
1023
5684
2689
1648
911
872
0
612
14010
12524
4663
8604
1537
8384
0
8614
2689
2589
1345
0
0
4472
42954
14677
34794
59463
60340
31647
38461
13265
61363
73225
84408
113195
41778
73807
130011
64495
51928
42914
31289
45044
70415
3024
48053
34100
EMS_ADM_VIS_TOTL ED_TRAFFIC_TOTL EMS_STATION EMS_NON_EMERG_VIS
2699
44552
28
0
91
3830
3
0
137
4814
5
172
141
11559
7
0
130
8993
9
0
0
32
0
0
227
4104
4
0
458
9999
8
0
28
4427
2
367
385
9045
8
0
0
0
0
0
1375
21038
18
0
434
7936
8
0
2
1518
2
0
391
9160
18
0
7682
58221
17
0
295
4775
4
58
0
0
0
0
7282
29553
32
0
10566
52269
41
0
0
0
0
0
0
0
0
0
0
0
0
0
543
9357
7
0
0
9492
6
0
5
319
1
0
268
9619
6
0
945
24475
10
0
199
7075
4
0
715
25725
12
742
7839
64338
40
0
3965
46063
26
0
3679
32597
20
2499
779
10919
9
124
548
13172
15
0
1466
19776
12
95
2690
37900
16
0
0
0
0
0
0
0
0
0
12232
44471
36
3304
25129
96032
66
21769
9360
47060
36
0
1788
15002
19
0
9483
40396
33
0
8539
50150
21
0
0
0
0
0
6904
1756
4183
6534
12061
2563
1918
951
7985
11205
14368
12816
5169
15770
20980
8458
5203
10383
3409
2813
21008
17
3279
6346
49858
16433
38977
65997
72401
34210
40379
14216
69348
84430
98776
126011
46947
89577
150991
72953
57131
53297
34698
47857
91423
3041
51332
40446
23
12
26
57
59
12
15
9
51
75
52
28
32
43
106
40
19
24
22
16
40
2
24
26
0
0
1078
25956
0
8030
0
0
0
0
27758
1357
0
0
20077
0
0
35559
0
0
0
0
45853
3277
EMS_REGISTERS_NO_TREAT
859
30
37
0
72
0
0
272
159
120
0
242
348
0
55
1135
101
0
614
1252
0
0
0
189
0
0
112
891
0
750
4081
1259
0
160
19
2119
0
0
0
443
4879
2216
79
3048
722
0
854
229
3202
2910
3795
0
739
217
2874
0
2376
5579
2209
3197
3949
1045
836
4642
894
374
3180
16
0
3452
FAC_CITY
DOWNEY
OAKLAND
SAN FRANCISCO
SYLMAR
TORRANCE
BAKERSFIELD
COLTON
LOS ANGELES
MORENO VALLEY
SAN JOSE
VICTORVILLE
SAN FRANCISCO
SAN LEANDRO
ALAMEDA
MARTINEZ
SAN LEANDRO
SAN MATEO
SANTA PAULA
SALINAS
VENTURA
EL CENTRO
FRENCH CAMP
BANNING
PORTOLA
ALTURAS
BIG BEAR LAKE
COALINGA
ESCONDIDO
FALL RIVER MILLS
FORT BRAGG
GARBERVILLE
HEALDSBURG
HOLLISTER
HOLLISTER
LAKE ISABELLA
LONE PINE
MAMMOTH LAKES
SALINAS
WEAVERVILLE
BISHOP
BLYTHE
CEDARVILLE
LAKE ARROWHEAD
LOMPOC
MARIPOSA
OAKDALE
TRAUMA_CTR TEACH_HOSP TYPE_CNTRL
0
1
1
2
1
1
2
1
1
2
1
1
2
1
1
3
1
1
3
1
1
3
1
1
3
1
1
3
1
1
1
2
1
1
2
1
1
2
1
2
2
1
2
2
1
2
2
1
2
2
1
2
2
1
3
2
1
3
2
1
4
2
1
4
2
1
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
0
2
2
1
2
2
1
2
2
1
2
2
1
2
2
1
2
2
1
2
2
1
2
2
Classes
1
2
3
4
TOTAL
T
Classes
0
1
2
3
4
TOTAL
T
Classes
1
2
TOTAL
OCEANSIDE
PORTERVILLE
POWAY
SONOMA
TRUCKEE
TULARE
FREMONT
ESCONDIDO
LANCASTER
BRAWLEY
VISALIA
CHESTER
COSTA MESA
ELDRIDGE
PORTERVILLE
LOS ANGELES
ORANGE
SACRAMENTO
SAN DIEGO
SAN FRANCISCO
SAN FRANCISCO
LA JOLLA
SAN FRANCISCO
SANTA MONICA
1
1
1
1
1
1
2
3
3
4
4
4
1
1
1
1
2
2
2
2
2
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
3
3
3
4
4
4
4
4
4
4
4
4
Frequency
22
36
3
9
70
TYPE_CNTRL
Rel. Frequency
0,314
0,514
0,043
0,129
1,0000
Frequency
18
21
17
9
5
70
TRAUMA_CTR
Rel. Frequency
0,257
0,300
0,243
0,129
0,071
1
Frequency
16
54
70
TEACH_HOSP
Rel. Frequency
0,229
0,771
1
Cumul. Frequency
0,314
0,829
0,871
1,000
0,257
0,557
0,800
0,929
1,000
0,229
1,000
FAC_CITY
HAWAIIAN GARDENS
SAN CLEMENTE
ALAMEDA
BAKERSFIELD
COLTON
EL CENTRO
FRENCH CAMP
LOS ANGELES
MARTINEZ
MORENO VALLEY
OAKLAND
SALINAS
SAN FRANCISCO
SAN JOSE
SAN LEANDRO
SAN MATEO
SANTA PAULA
SYLMAR
TORRANCE
VENTURA
VICTORVILLE
CHICO
DOWNEY
EUREKA
MERCED
SACRAMENTO
SAN DIEGO
SAN FRANCISCO
SAN LEANDRO
SAN LUIS OBISPO
SANTA BARBARA
STOCKTON
YUBA CITY
BANNING
BISHOP
BLYTHE
BRAWLEY
CEDARVILLE
ESCONDIDO
FREMONT
LAKE ARROWHEAD
LANCASTER
LOMPOC
MARIPOSA
OAKDALE
OCEANSIDE
TRAUMA_CTR
TEACH_HOSP
ASSEMBLY_DIST
SENATE_DIST
CONGRESS_DIST
0
2
63
32
38
0
2
73
36
49
2
2
18
9
13
3
1
32
16
23
3
1
47
20
31
4
2
56
40
51
4
2
13
5
9
3
1
51
24
34
2
2
14
3
5
3
1
61
31
41
2
1
18
9
13
3
2
30
12
20
2
1
17
11
12
3
1
28
15
18
2
2
18
9
13
2
2
22
13
14
2
2
37
19
26
2
1
39
18
29
2
1
66
35
43
3
2
37
19
26
1
2
33
21
8
0
2
3
4
1
0
1
58
32
40
0
2
2
2
2
0
2
21
12
16
0
2
7
6
6
0
2
78
39
53
1
2
19
11
14
1
2
20
10
15
0
2
35
17
24
0
2
37
19
24
0
2
13
5
9
0
2
3
4
3
0
2
42
23
36
1
2
26
8
8
1
2
56
28
36
4
2
56
40
51
1
2
1
1
1
3
2
75
38
50
2
2
20
10
17
1
2
33
23
8
3
2
36
21
23
1
2
35
19
24
1
2
5
8
4
1
2
12
8
10
1
2
76
36
49
PORTERVILLE
PORTOLA
POWAY
SONOMA
TRUCKEE
TULARE
VISALIA
ALTURAS
BIG BEAR LAKE
CHESTER
COALINGA
ESCONDIDO
FALL RIVER MILLS
FORT BRAGG
GARBERVILLE
HEALDSBURG
HOLLISTER
HOLLISTER
LAKE ISABELLA
LOMPOC
LONE PINE
MAMMOTH LAKES
SALINAS
WEAVERVILLE
NORWALK
ATASCADERO
COALINGA
COSTA MESA
ELDRIDGE
LONG BEACH
NAPA
NEWPORT BEACH
PATTON
PORTERVILLE
LA JOLLA
LOS ANGELES
ORANGE
SACRAMENTO
SAN DIEGO
SAN FRANCISCO
SAN FRANCISCO
SANTA MONICA
LOS ANGELES
SAN FRANCISCO
SAN FRANCISCO
ARCATA
BAKERSFIELD
1
0
1
1
1
1
4
0
0
4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
4
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
2
1
2
2
2
1
2
2
26
1
77
10
1
26
26
1
33
1
31
75
1
2
2
2
30
30
26
35
26
5
30
2
57
35
31
74
4
70
4
74
40
26
78
54
69
7
78
17
17
50
54
17
19
2
34
14
1
38
3
1
16
16
1
23
1
12
38
1
2
2
2
12
12
16
19
8
8
12
2
32
17
12
37
2
33
3
37
23
14
39
26
34
6
39
11
11
26
26
11
11
2
16
23
1
52
5
4
22
22
1
8
1
21
50
1
2
2
2
20
20
23
24
8
8
20
2
38
24
21
48
5
47
5
48
31
23
52
33
46
6
53
12
12
33
33
12
12
2
23
BARSTOW
CHINO
CORONA
CULVER CITY
FOUNTAIN VALLEY
HUNTINGTON PARK
INDIO
LAKEWOOD
LOS ALAMITOS
LOS ANGELES
MODESTO
MURRIETA
ORANGE
PALM SPRINGS
PALMDALE
PLACENTIA
SAN DIEGO
SAN DIEGO
SAN JOSE
SAN JOSE
SAN LUIS OBISPO
SAN RAMON
SANTA ANA
SANTA ANA
SOUTH EL MONTE
SUN VALLEY
TEMECULA
TEMPLETON
THOUSAND OAKS
TURLOCK
TUSTIN
VICTORVILLE
WATSONVILLE
WEST HILLS
WHITTIER
WILDOMAR
ANAHEIM
BAKERSFIELD
BALDWIN PARK
BELLFLOWER
BREA
CAMPBELL
CARMICHAEL
CERES
CERRITOS
CHINO
CORONA
1
1
1
1
1
1
1
1
1
1
3
2
2
2
1
1
1
1
1
2
3
2
2
2
1
1
1
1
3
1
1
1
1
2
2
3
0
0
0
0
0
0
0
0
0
0
0
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
33
52
60
54
72
53
56
63
72
51
21
67
68
42
36
55
79
79
28
27
35
16
69
69
57
39
75
35
44
12
68
33
30
45
57
67
69
32
48
58
55
28
8
21
58
52
60
16
20
31
30
34
33
28
33
34
24
5
28
37
28
21
29
39
39
15
15
17
7
34
34
22
18
28
17
27
8
37
21
17
27
32
28
34
16
22
32
29
15
6
12
32
20
31
8
35
42
37
48
40
36
38
47
40
10
42
45
36
25
39
53
53
18
19
24
15
46
46
38
29
50
24
26
10
45
8
20
30
38
42
46
23
32
38
39
18
7
10
38
35
42
CULVER CITY
FOUNTAIN VALLEY
FREMONT
FRESNO
FRESNO
HOLLYWOOD
INDIO
LA MIRADA
LOMA LINDA
LONG BEACH
LOS ANGELES
LOS ANGELES
LOS GATOS
MANTECA
MODESTO
NORWALK
Oakland
ONTARIO
PERRIS
PLACERVILLE
RED BLUFF
REDDING
ROSEVILLE
SACRAMENTO
SACRAMENTO
SAN DIEGO
SAN JOSE
SAN LEANDRO
SAN LEANDRO
SAN RAMON
SANTA ANA
SANTA CRUZ
THOUSAND OAKS
TORRANCE
TORRANCE
VALLEJO
WEST COVINA
WEST COVINA
WESTLAKE VILAGE
WESTMINSTER
COSTA MESA
REDDING
ANAHEIM
GARDEN GROVE
HEMET
INGLEWOOD
IRVINE
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
54
72
25
31
31
50
56
57
40
63
51
54
28
12
12
57
18
52
61
5
3
1
6
7
9
78
28
18
20
16
69
29
44
66
66
14
48
48
44
72
74
1
65
69
42
62
74
30
34
10
14
14
26
28
32
23
33
24
30
15
5
5
32
9
20
31
1
4
1
4
6
6
39
15
9
10
7
34
17
27
26
26
3
22
22
27
34
37
1
29
34
23
35
37
37
48
17
16
16
28
36
38
31
44
34
37
18
10
10
38
13
35
41
4
1
1
4
6
6
53
18
13
15
15
46
20
26
33
43
5
32
32
26
47
48
1
46
46
36
43
45
JOSHUA TREE
LONG BEACH
NATIONAL CITY
NORWALK
ORANGE
SAN DIMAS
SAN GABRIEL
ALISO VIEJO
BAKERSFIELD
BAKERSFIELD
COVINA
FOLSOM
FRESNO
GARDENA
KENTFIELD
LA MESA
LOS ANGELES
LOS ANGELES
LOS ANGELES
MODESTO
MODESTO
MODESTO
MONROVIA
PANORAMA CITY
PASADENA
RANCHO CUCAMONGA
REDDING
REDDING
RIVERSIDE
SACRAMENTO
SAN BERNARDINO
SAN DIEGO
SAN DIEGO
SAN JOSE
SANTA ROSA
VENTURA
Yuba City
YUBA CITY
ALHAMBRA
ANAHEIM
GARDENA
LOS ANGELES
LOS ANGELES
MONTEREY PARK
MONTEREY PARK
RIVERSIDE
BAKERSFIELD
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4
0
0
0
0
0
0
0
0
0
0
2
2
2
2
2
2
2
2
0
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
42
70
79
57
68
41
49
73
34
34
48
6
23
66
10
79
50
54
50
21
12
21
41
46
41
40
1
1
61
7
47
77
78
27
10
37
3
3
49
69
66
51
43
49
49
61
34
16
33
40
32
37
25
22
36
16
16
22
1
8
35
2
38
30
30
26
5
5
5
25
18
25
23
1
1
31
6
20
38
39
17
2
19
4
4
22
29
35
24
24
22
22
31
16
8
47
51
38
46
32
27
48
23
23
32
7
22
43
2
53
37
37
37
10
10
10
32
29
27
31
1
1
41
6
31
52
53
19
5
26
3
3
27
46
43
40
28
27
27
41
23
FRESNO
GLENDORA
LOS ANGELES
LOS ANGELES
PARAMOUNT
TUSTIN
ANAHEIM
ANTIOCH
APPLE VALLEY
ARCADIA
ARROYO GRANDE
AUBURN
BAKERSFIELD
BAKERSFIELD
BAKERSFIELD
BALDWIN PARK
BERKELEY
BURBANK
BURLINGAME
CAMARILLO
CARMICHAEL
CASTRO VALLEY
CHICO
CHULA VISTA
CHULA VISTA
CLEARLAKE
CLOVIS
CONCORD
CORONADO
COVINA
CRESCENT CITY
DALY CITY
DAVIS
DELANO
DOWNEY
DOWNEY
ENCINITAS
ENCINO
EUREKA
FAIRFIELD
FOLSOM
FONTANA
FOUNTAIN VALLEY
FREMONT
FRESNO
FRESNO
FRESNO
0
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
1
1
1
1
1
1
1
4
1
1
1
1
1
1
1
3
3
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
23
48
51
53
63
68
68
11
33
49
35
1
34
34
34
48
15
43
22
44
8
20
3
80
79
4
23
14
78
48
2
19
4
32
58
58
76
45
2
11
6
47
72
25
23
23
31
8
25
24
24
33
37
37
7
21
22
17
1
16
16
16
22
9
25
13
19
4
10
4
40
40
2
8
7
39
22
2
11
3
14
32
32
36
27
2
3
1
20
34
10
8
8
14
22
27
34
34
40
45
46
9
8
27
24
1
23
23
23
32
13
30
14
26
7
15
1
51
53
3
22
11
52
32
2
14
3
21
40
40
49
30
2
3
7
35
48
17
22
22
16
FULLERTON
GLENDALE
GLENDORA
GRASS VALLEY
GREENBRAE
HARBOR CITY
HAYWARD
HUNTINGTON BEACH
IRVINE
IRVINE
KING CITY
LA JOLLA
LA MESA
LA PALMA
LAGUNA BEACH
LAGUNA HILLS
LODI
LOMA LINDA
LONG BEACH
LONG BEACH
LONG BEACH
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS BANOS
LYNWOOD
MADERA
MADERA
MANTECA
MARYSVILLE
MERCED
MISSION HILLS
MISSION VIEJO
MISSION VIEJO
MODESTO
MODESTO
MONTCLAIR
MONTEBELLO
MONTEREY
MORENO VALLEY
MOSS BEACH
2
2
2
2
4
1
1
1
1
1
1
3
1
1
1
1
1
2
1
2
2
1
1
1
1
1
1
2
2
2
1
2
1
2
1
3
1
2
1
2
1
2
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
2
2
1
2
2
1
1
1
2
2
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
65
43
48
1
10
66
20
72
74
74
30
78
79
65
74
73
9
40
70
70
70
51
53
53
64
43
54
53
50
43
21
63
5
5
12
3
21
39
73
73
12
12
52
58
29
61
22
29
25
25
1
2
35
10
34
37
37
12
39
38
29
37
36
5
23
33
33
33
24
24
24
35
24
30
30
26
24
12
33
12
12
5
4
12
18
36
36
5
5
20
32
17
31
13
39
28
27
1
2
33
15
48
45
45
20
52
53
38
48
45
9
31
47
47
47
34
34
34
44
28
37
34
28
28
16
44
16
16
10
3
16
29
45
45
10
10
35
38
20
41
14
MOUNT SHASTA
MOUNTAIN VIEW
MURRIETA
NAPA
NEEDLES
NEWPORT BEACH
NORTHRIDGE
NOVATO
OAKLAND
OAKLAND
OAKLAND
ONTARIO
ORANGE
ORANGE
OROVILLE
OXNARD
PALO ALTO
PANORAMA CITY
PARADISE
PASADENA
PETALUMA
PLACERVILLE
PLEASANTON
POMONA
RANCHO MIRAGE
RED BLUFF
REDDING
REDLANDS
REDWOOD CITY
REDWOOD CITY
REEDLEY
RICHMOND
RIDGECREST
RIVERSIDE
RIVERSIDE
ROSEVILLE
ROSEVILLE
SACRAMENTO
SACRAMENTO
SACRAMENTO
SACRAMENTO
SACRAMENTO
SAN ANDREAS
SAN BERNARDINO
SAN BERNARDINO
SAN DIEGO
SAN DIEGO
3
1
1
3
1
1
2
1
2
1
1
1
1
2
1
1
2
1
1
2
1
3
1
2
1
3
2
1
1
1
1
1
4
1
1
2
1
1
1
1
1
2
1
1
1
1
1
2
2
2
2
2
2
2
2
1
2
2
2
2
2
2
2
1
2
2
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
1
24
67
4
33
74
45
10
15
18
15
52
68
68
3
44
24
46
3
41
10
5
16
52
42
3
1
40
22
22
31
15
34
60
60
6
6
7
9
7
8
9
5
40
40
77
78
1
13
28
3
16
37
27
2
9
9
9
20
37
37
4
19
13
18
4
25
3
1
7
20
28
4
1
23
13
13
14
9
16
31
31
4
4
6
6
6
6
6
8
23
23
39
39
1
18
42
5
8
48
30
2
13
13
13
35
46
46
1
26
18
29
1
27
2
4
15
35
36
1
1
31
18
14
22
11
23
41
41
4
4
6
6
6
7
6
4
31
31
52
53
SAN DIEGO
SAN DIEGO
SAN DIEGO
SAN FRANCISCO
SAN FRANCISCO
SAN FRANCISCO
SAN FRANCISCO
SAN FRANCISCO
SAN FRANCISCO
SAN FRANCISCO
SAN JOSE
SAN LEANDRO
SAN LUIS OBISPO
SAN PEDRO
SAN RAFAEL
SANTA BARBARA
SANTA BARBARA
SANTA CLARA
SANTA CRUZ
SANTA MARIA
SANTA MONICA
SANTA ROSA
SANTA ROSA
SANTA ROSA
SELMA
SIMI VALLEY
SOLVANG
SONORA
SOUTH LAKE TAHOE
SOUTH SAN FRANCISCO
STOCKTON
STOCKTON
TARZANA
TEHACHAPI
TORRANCE
TORRANCE
TRACY
UKIAH
UPLAND
VACAVILLE
VACAVILLE
VALENCIA
VALLEJO
VALLEJO
VAN NUYS
VENTURA
WALNUT CREEK
1
2
2
1
1
1
1
1
1
1
1
1
1
1
1
1
2
1
1
3
1
1
3
1
1
1
1
1
3
1
1
1
2
2
2
1
1
4
3
3
2
2
1
1
2
2
2
2
2
2
2
2
2
1
1
2
1
2
2
2
2
2
2
2
2
2
2
2
2
2
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
79
79
79
19
17
17
19
17
17
19
29
18
35
70
10
37
37
25
29
35
50
2
10
2
31
38
37
5
5
19
13
13
45
34
66
66
13
2
41
11
11
38
14
14
46
37
16
39
39
39
11
11
11
11
11
11
11
17
9
17
35
2
19
19
10
17
19
26
2
2
2
14
27
19
8
1
13
5
5
27
16
26
26
5
2
25
3
3
27
3
3
18
19
7
53
53
53
12
12
12
12
12
12
12
19
13
24
44
2
24
24
17
20
24
33
2
5
5
21
25
24
4
4
14
9
9
30
23
33
43
10
2
31
3
3
25
5
5
29
26
11
WALNUT CREEK
WEST COVINA
WHITTIER
WILLOWS
WOODLAND
WOODLAND HILLS
YREKA
ANTIOCH
AVALON
BAKERSFIELD
BERKELEY
CHICO
CHICO
CONCORD
DUARTE
EUREKA
FORTUNA
FRESNO
FRESNO
FRESNO
GILROY
GLENDALE
GLENDALE
GRIDLEY
HANFORD
JACKSON
LA JOLLA
LAKEPORT
LOMA LINDA
LOMA LINDA
LONG BEACH
LONG BEACH
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS ANGELES
LOS GATOS
MARINA DEL REY
MENLO PARK
OAKLAND
OAKLAND
OJAI
PALO ALTO
POMONA
1
1
1
4
1
1
4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4
0
0
0
3
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
2
2
2
2
2
2
2
2
2
2
2
2
16
48
57
3
4
45
1
11
70
34
15
3
3
14
48
2
2
23
23
31
30
43
43
3
32
5
78
4
40
40
70
70
51
53
51
51
59
51
51
28
62
24
18
18
37
24
52
7
22
32
4
3
27
1
7
26
16
9
4
4
7
25
2
2
8
8
8
17
25
25
4
14
8
39
2
23
23
33
33
24
24
24
24
30
24
24
15
26
13
9
9
19
13
20
11
32
38
3
3
30
1
9
47
23
13
1
1
11
32
2
2
22
22
16
20
28
28
1
21
4
49
3
31
31
47
47
34
34
34
34
40
28
34
18
33
18
13
13
26
18
35
POMONA
RANCHO MIRAGE
REDLANDS
REDLANDS
RESEDA
ROSEMEAD
SACRAMENTO
SACRAMENTO
SAN DIEGO
SAN DIEGO
SAN DIEGO
SAN FRANCISCO
SAN FRANCISCO
SAN JOSE
SANTA BARBARA
SANTA CLARA
SANTA CRUZ
SANTA ROSA
SHERMAN OAKS
SONORA
ST. HELENA
STOCKTON
TARZANA
VALLEJO
WILLITS
WOODLAND HILLS
YUBA CITY
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4
0
0
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
52
42
40
40
45
49
7
7
79
79
77
19
17
28
37
25
29
10
46
5
4
13
45
14
2
45
3
20
28
23
23
27
22
6
6
39
39
39
11
11
10
19
10
17
2
18
8
3
5
27
3
2
27
4
35
36
31
31
30
27
6
6
53
53
53
14
12
18
24
17
20
5
30
4
5
9
30
5
2
30
3
TYPE_LIC
TYPE_CNTRL
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
Psychiatric Health Facility
General Acute Care
Psychiatric Health Facility
Psychiatric Health Facility
Psychiatric Health Facility
Acute Psychiatric
General Acute Care
General Acute Care
Psychiatric Health Facility
Psychiatric Health Facility
Psychiatric Health Facility
Psychiatric Health Facility
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
General Acute Care
TYPE_SVC_PRINCIPAL
MED_SURG_LICBED_DAY
MED_SURG_CENS_DAY
ICU_LICBED_DAY
0
43435
0
4745
0
24090
0
2555
1 General Medical / Surgical
30660
9815
2920
1 General Medical / Surgical
29200
20563
8760
1 General Medical / Surgical
74095
60956
17520
1 General Medical / Surgical
40150
14283
7300
1 General Medical / Surgical
44165
30376
5840
1 General Medical / Surgical
125195
119526
47450
1 General Medical / Surgical
36135
28794
2920
1 General Medical / Surgical
82125
54638
16060
1 General Medical / Surgical
40880
39492
8760
1 General Medical / Surgical
22958
14130
3650
1 General Medical / Surgical
67160
62079
21170
1 General Medical / Surgical
86634
68316
16468
1 General Medical / Surgical
30660
10393
3285
1 General Medical / Surgical
31390
13006
2555
1 General Medical / Surgical
10950
3029
2190
1 General Medical / Surgical
73000
45164
15330
1 General Medical / Surgical
100740
71082
16060
1 General Medical / Surgical
29519
11952
9585
1 General Medical / Surgical
23360
17878
3650
1 Psychiatric
0
0
0
1 General Medical / Surgical
46355
24521
4380
1 Psychiatric
0
0
0
1 Psychiatric
0
0
0
1 Psychiatric
0
0
0
1 Psychiatric
0
0
0
1 Long-Term Care (SN/IC)
2190
106
0
1 Long-Term Care (SN/IC)
0
0
0
1 Psychiatric
0
0
0
1 Psychiatric
0
0
0
1 Psychiatric
0
0
0
1 Psychiatric
0
0
0
2 General Medical / Surgical
17520
9528
5840
2 General Medical / Surgical
5840
2277
1460
2 General Medical / Surgical
14965
2035
1460
2 General Medical / Surgical
24090
12285
2920
2 Other
1460
33
0
2 General Medical / Surgical
74460
62403
8760
2 General Medical / Surgical
94535
52307
4745
2 General Medical / Surgical
6205
1220
0
2 General Medical / Surgical
91615
46701
7665
2 General Medical / Surgical
17520
6098
2190
2 General Medical / Surgical
6570
884
0
2 General Medical / Surgical
10950
2988
1825
2 General Medical / Surgical
99280
38854
5110
General Acute Care
2 General Medical / Surgical
39420
General Acute Care
2 General Medical / Surgical
3285
General Acute Care
2 General Medical / Surgical
24820
General Acute Care
2 General Medical / Surgical
13870
General Acute Care
2 General Medical / Surgical
9125
General Acute Care
2 General Medical / Surgical
22422
General Acute Care
2 General Medical / Surgical
89790
General Acute Care
2 General Medical / Surgical
5840
General Acute Care
2 General Medical / Surgical
3285
General Acute Care
2 General Medical / Surgical
3650
General Acute Care
2 General Medical / Surgical
8030
General Acute Care
2 Physical Rehabilitation
57305
General Acute Care
2 General Medical / Surgical
7300
General Acute Care
2 General Medical / Surgical
13870
General Acute Care
2 Other
3285
General Acute Care
2 General Medical / Surgical
6205
General Acute Care
2 Long-Term Care (SN/IC)
0
General Acute Care
2 General Medical / Surgical
12045
General Acute Care
2 Long-Term Care (SN/IC)
8760
Chemical Dependency Recovery Hospital
2 Chemical Dependency (Alcohol/Drug) 0
General Acute Care
2 Long-Term Care (SN/IC)
1460
General Acute Care
2 General Medical / Surgical
4745
General Acute Care
2 General Medical / Surgical
75920
General Acute Care
2 General Medical / Surgical
9125
Acute Psychiatric
3 Psychiatric
0
Acute Psychiatric
3 Psychiatric
0
Acute Psychiatric
3 Psychiatric
0
General Acute Care
3 Developmentally Disabled
10950
General Acute Care
3 Developmentally Disabled
4745
Psychiatric Health Facility
3 Psychiatric
0
Acute Psychiatric
3 Psychiatric
0
Acute Psychiatric
3 Psychiatric
0
Acute Psychiatric
3 Psychiatric
0
General Acute Care
3 Developmentally Disabled
15330
General Acute Care
4 General Medical / Surgical
93805
General Acute Care
4 General Medical / Surgical
85410
General Acute Care
4 General Medical / Surgical
80300
General Acute Care
4 General Medical / Surgical
127385
General Acute Care
4 General Medical / Surgical
76285
General Acute Care
4 General Medical / Surgical
20440
General Acute Care
4 General Medical / Surgical
154395
General Acute Care
4 General Medical / Surgical
64240
Acute Psychiatric
4 Psychiatric
0
Acute Psychiatric
4 Psychiatric
0
General Acute Care
4 General Medical / Surgical
48545
General Acute Care Investor – Corporation
General Medical / Surgical
22630
General Acute Care Investor – Corporation
General Medical / Surgical
13505
16878
1127
13740
3148
3067
7832
77851
588
592
675
378
0
2162
792
87
2393
0
4027
2416
0
4
1098
36121
2067
0
0
0
368
1404
0
0
0
0
730
79827
90480
53037
111543
49197
14777
115499
57565
0
0
0
4778
12766
3650
0
4380
2190
2190
4242
14965
0
0
0
0
7665
0
1460
0
1460
0
2920
1095
0
0
730
2190
0
0
0
0
0
0
0
0
0
0
0
17520
43800
21900
43070
11680
16790
31390
8030