home / la-times

Menu
  • GraphQL API

cdc-vaccination-state-totals

Table actions
  • GraphQL API for cdc-vaccination-state-totals

State-level vaccination totals derived from the dashboard published by the U.S. Centers for Disease Control and Prevention.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

date
The date when the data were collected in ISO 8601 format.
state
The name of the state.
population
The number of people who live in the state.
doses_distributed
The total number of doses sent to the state as of that date.
doses_administered
The total number of shots given out in the state as of that date.
doses_administered_percent
The percentage of distributed doses that have been administered as of that date.
administered_dose1
The number of first doses administered in the state of that date.
administered_dose1_percent
The percentage of people in the state who have received at least one dose as of that date.
administered_dose2
The number of second doses administered in the state of that date.
administered_dose2_percent
The percentage of people in the state who are fully vaccinated as of that date.

29,979 rows

✖

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date state population doses_distributed doses_administered doses_administered_percent administered_dose1 administered_dose1_percent administered_dose2 administered_dose2_percent
1 1 2021-01-13 Alabama 4903185 378975 84040 0.22175605251006 74792.0 0.0152537585263456    
2 2 2021-01-13 Hawaii 1415872 154150 36605 0.237463509568602 0.0 0.0    
3 3 2021-01-13 Rhode Island 1059361 82175 42028 0.5114450867052023 36489.0 0.0344443489990664    
4 4 2021-01-13 Guam 165768 34300 3791 0.1105247813411078 401.0 0.0024190434824574    
5 5 2021-01-13 South Carolina 5148714 317450 99887 0.3146542762639785 87584.0 0.017010849699556    
6 6 2021-01-13 Georgia 10617423 1003975 198756 0.197969072935083 86105.0 0.0081097833250121    
7 7 2021-01-13 South Dakota 884659 88375 50712 0.5738274398868458 42789.0 0.0483677891707426    
8 8 2021-01-13 Florida 21477737 1680200 705398 0.4198297821687894 647330.0 0.0301395812789773    
9 9 2021-01-13 Tennessee 6829174 598000 264713 0.4426638795986622 150893.0 0.022095351502246    
10 10 2021-01-13 Federated States of Micronesia 103643 9800 565 0.0576530612244897 555.0 0.0053549202551064    
11 11 2021-01-13 Texas 28995881 1984225 978042 0.4929088183043758 861072.0 0.0296963558375756    
12 12 2021-01-13 District of Columbia 705749 68325 33049 0.4837028905964142 1957.0 0.0027729405213468    
13 13 2021-01-13 Utah 3205958 266025 104036 0.3910760266892209 98010.0 0.0305712052372488    
14 14 2021-01-13 Delaware 973764 91250 28413 0.3113753424657534 16647.0 0.0170955180105241    
15 15 2021-01-13 Vermont 623989 69800 29571 0.4236532951289398 0.0 0.0    
16 16 2021-01-13 Connecticut 3565287 315025 161875 0.513848107293072 58920.0 0.0165260188029743    
17 17 2021-01-13 Virgin Islands 104680 9575 1195 0.1248041775456919 0.0 0.0    
18 18 2021-01-13 Colorado 5758736 530800 239665 0.451516578749058 198227.0 0.034421963430864    
19 19 2021-01-13 Virginia 8535519 845900 217836 0.2575198013949639 0.0 0.0    
20 20 2021-01-13 California 39512223 3435650 891489 0.2594819029877898 744545.0 0.0188434095444338    
21 21 2021-01-13 Washington 7614893 572600 208238 0.3636709745022703 169650.0 0.0222787109418346    
22 22 2021-01-13 Arkansas 3017804 297800 94854 0.3185157824042982 80458.0 0.0266611085411776    
23 23 2021-01-13 West Virginia 1792147 160975 110709 0.6877403323497437 0.0 0.0    
24 24 2021-01-13 Arizona 7278717 569525 154745 0.2717088802071902 104387.0 0.0143414011013204    
25 25 2021-01-13 Wisconsin 5822434 435900 137253 0.3148726772195457 125895.0 0.0216224005287135    
26 26 2021-01-13 American Samoa 55689 10650 2577 0.2419718309859155 1193.0 0.02142254305159    
27 27 2021-01-13 Republic of Palau 17907 6000 725 0.1208333333333333 725.0 0.0404869604065449    
28 28 2021-01-13 Idaho 1787065 158125 38872 0.2458308300395257 33176.0 0.018564517798737    
29 29 2021-01-13 Puerto Rico 3193694 305475 84432 0.2763957770684999 67475.0 0.021127572021615    
30 30 2021-01-13 Illinois 12671821 920225 365859 0.3975755929256432 291445.0 0.0229994568262919    
31 31 2021-01-13 Missouri 6137428 526425 161784 0.3073258298902978 107939.0 0.0175870087600212    
32 32 2021-01-13 Nebraska 1934408 199800 79699 0.3988938938938939 69113.0 0.0357282434729384    
33 33 2021-01-13 Mississippi 2976149 218825 61289 0.2800822575117103 51588.0 0.01733380956397    
34 34 2021-01-13 Nevada 3080156 207150 61653 0.2976249094858798 31320.0 0.0101683161502209    
35 35 2021-01-13 Minnesota 5639632 511200 165355 0.3234643974960876 154767.0 0.0274427480374606    
36 36 2021-01-13 New Hampshire 1359711 124300 55218 0.4442316975060338 12722.0 0.0093563999997058    
37 37 2021-01-13 Michigan 9986857 772150 291519 0.3775419283817911 259119.0 0.0259460008288894    
38 38 2021-01-13 New Jersey 8882190 654900 262982 0.4015605435944419 236053.0 0.02657599083109    
39 39 2021-01-13 Massachusetts 6892503 656850 217443 0.3310390500114181 192619.0 0.0279461612131325    
40 40 2021-01-13 New Mexico 2096829 199525 81855 0.4102493421876957 45873.0 0.0218773204681926    
41 41 2021-01-13 Maryland 6045680 561500 178056 0.3171077471059662 162350.0 0.0268538857498246    
42 42 2021-01-13 New York 19453561 1796850 632473 0.3519898711634249 587865.0 0.030218888973592    
43 43 2021-01-13 Wyoming 578759 57800 17794 0.3078546712802768 14406.0 0.0248911895970516    
44 44 2021-01-13 Marshall Islands 58413 13600 649 0.0477205882352941 633.0 0.0108366288326228    
45 45 2021-01-13 Maine 1344212 136875 57248 0.4182502283105023 39157.0 0.0291300776960777    
46 46 2021-01-13 North Dakota 762062 66725 40728 0.6103859123267141 34317.0 0.0450317690686584    
47 47 2021-01-13 Louisiana 4648794 369475 156186 0.4227241355978077 127078.0 0.027335691794474    
48 48 2021-01-13 Northern Mariana Islands 56882 18650 4141 0.2220375335120643 1141.0 0.0200590696529657    
49 49 2021-01-13 Kentucky 4467673 329450 142436 0.4323448171194415 111449.0 0.0249456484393553    
50 50 2021-01-13 Ohio 11689100 957700 329318 0.3438634227837527 329295.0 0.0281711166813527    
51 51 2021-01-13 Kansas 2913314 261175 85650 0.3279410357040299 58477.0 0.0200723299994439    
52 52 2021-01-13 Oklahoma 3956971 396975 172403 0.4342918319793438 118786.0 0.030019426475453    
53 53 2021-01-13 Iowa 3155070 264125 112093 0.4243937529578798 101859.0 0.0322842282421626    
54 54 2021-01-13 Oregon 4217737 325325 115075 0.353723199877046 107843.0 0.025568924757518    
55 55 2021-01-13 Indiana 6732219 579050 211334 0.3649667558932735 125763.0 0.0186807648414289    
56 56 2021-01-13 Pennsylvania 12801989 1017475 379944 0.3734185115113393 285938.0 0.0223354355327129    
57 57 2021-01-13 North Carolina 10488084 852000 266938 0.3133075117370892 228686.0 0.0218043638857202    
58 58 2021-01-13 Alaska 731545 149475 38680 0.258772369961532 24541.0 0.0335468084670116    
59 59 2021-01-13 Montana 1068778 89550 44063 0.4920491345616973 31886.0 0.029834072183372    
60 60 2021-01-15 Michigan 9986857 773750 364182 0.4706714054927302 312415.0 0.0312826147405535 48536.0 0.0048599874815469
61 61 2021-01-15 Kansas 2913314 263175 97779 0.3715360501567398 83293.0 0.0285904643303124 13496.0 0.004632525021333
62 62 2021-01-15 Minnesota 5639632 519600 198253 0.3815492686682063 170273.0 0.0301922182156566 27799.0 0.0049292223322372
63 63 2021-01-15 Arizona 7278717 571725 197086 0.3447216756307665 176213.0 0.0242093489827946 20837.0 0.0028627297915278
64 64 2021-01-15 North Dakota 762062 68675 46410 0.6757917728431015 38506.0 0.0505286971401277 7555.0 0.0099138915206374
65 65 2021-01-15 Illinois 12671821 1011225 437765 0.4329056342554822 341518.0 0.026950980447088 91248.0 0.007200859292441
66 66 2021-01-15 Oklahoma 3956971 424000 203410 0.4797405660377358 173162.0 0.0437612507142458 28917.0 0.0073078625039202
67 67 2021-01-15 California 39512223 3548575 1072959 0.3023633430320622 865387.0 0.0219017543001819 204374.0 0.0051724247456287
68 68 2021-01-15 Idaho 1787065 160075 46636 0.2913384351085428 37646.0 0.0210658258093578 8843.0 0.0049483370778343
69 69 2021-01-15 Wyoming 578759 58775 22745 0.3869842620161633 19931.0 0.0344374774301565 2803.0 0.0048431212300802
70 70 2021-01-15 Missouri 6137428 528800 190447 0.3601493948562784 153664.0 0.0250371979923837 36525.0 0.0059511899772999
71 71 2021-01-15 Alaska 731545 150450 49039 0.3259488202060485 39546.0 0.0540581919089051 9406.0 0.0128577189373175
72 72 2021-01-15 Indiana 6732219 642425 260310 0.4051990504728178 222599.0 0.0330647294747838 37683.0 0.0055974114924068
73 73 2021-01-15 Connecticut 3565287 328775 185866 0.5653288723291005 166722.0 0.0467625747941189 17162.0 0.0048136377239756
74 74 2021-01-15 Massachusetts 6892503 669325 257175 0.3842303813543495 222109.0 0.0322247230070121 34885.0 0.0050612963099181
75 75 2021-01-15 Arkansas 3017804 297800 118338 0.3973740765614506 97829.0 0.0324172809102247 18781.0 0.0062233995315799
76 76 2021-01-15 Nevada 3080156 211750 83674 0.3951546635182998 67679.0 0.0219725884013666 15308.0 0.0049698781490288
77 77 2021-01-15 District of Columbia 705749 68325 39934 0.5844712769849981 31667.0 0.0448700600355083 8250.0 0.0116897083807415
78 78 2021-01-15 Maine 1344212 136875 61129 0.4466045662100457 51631.0 0.0384098639202744 8274.0 0.0061552790780025
79 79 2021-01-15 Hawaii 1415872 154150 46958 0.3046253649043139 39690.0 0.028032195000678 7268.0 0.0051332323825882
80 80 2021-01-15 Mississippi 2976149 233550 84328 0.3610704345964461 75885.0 0.0254977153361609 8396.0 0.0028210953147843
81 81 2021-01-15 North Carolina 10488084 999650 302824 0.3029300255089281 259859.0 0.0247765940852495 42790.0 0.0040798681627645
82 82 2021-01-15 Washington 7614893 696175 242606 0.3484842173304126 200682.0 0.0263538831077468 31581.0 0.0041472677291722
83 83 2021-01-15 Alabama 4903185 444650 100567 0.2261711458450466 86956.0 0.0177345949622541 13488.0 0.0027508649989751
84 84 2021-01-15 Federated States of Micronesia 103643 9800 694 0.0708163265306122 692.0 0.0066767654351958 2.0 1.929700992831161e-05
85 85 2021-01-15 West Virginia 1792147 205475 134207 0.6531548850225088 113034.0 0.063071835067101 21162.0 0.0118081831456906
86 86 2021-01-15 Guam 165768 34300 3791 0.1105247813411078 3785.0 0.0228331161623473 0.0 0.0
87 87 2021-01-15 Colorado 5758736 531775 272233 0.5119326782943914 223761.0 0.0388559225496706 47021.0 0.0081651598545236
88 88 2021-01-15 Montana 1068778 98500 49364 0.5011573604060914 41160.0 0.0385112717514769 8193.0 0.0076657640782276
89 89 2021-01-15 Nebraska 1934408 211500 91195 0.4311820330969267 77734.0 0.0401849041153676 13050.0 0.0067462500155086
90 90 2021-01-15 Maryland 6045680 565125 194705 0.3445343950453439 178831.0 0.0295799645366608 15830.0 0.0026183985920525
91 91 2021-01-15 American Samoa 55689 18450 3883 0.210460704607046 3144.0 0.0564563917470236 738.0 0.0132521682917631
92 92 2021-01-15 Utah 3205958 268175 128210 0.4780833411018924 114504.0 0.0357160012701351 10534.0 0.0032857573305701
93 93 2021-01-15 South Carolina 5148714 350550 121836 0.3475566966195977 101722.0 0.0197567781003178 19477.0 0.003782886367353
94 94 2021-01-15 Delaware 973764 91250 31090 0.3407123287671232 25649.0 0.0263400577552671 5354.0 0.0054982521432297
95 95 2021-01-15 New Mexico 2096829 204750 99305 0.485006105006105 80172.0 0.0382348775222013 18711.0 0.008923474446414
96 96 2021-01-15 Virginia 8535519 852725 244234 0.2864159019613592 214732.0 0.0251574625983493 28164.0 0.003299623608125
97 97 2021-01-15 Louisiana 4648794 370175 197967 0.5347930033092456 167193.0 0.0359648115188584 30416.0 0.0065427721684376
98 98 2021-01-15 New York 19453561 1884325 757466 0.401982672840407 671311.0 0.0345083864080206 73523.0 0.0037794108749549
99 99 2021-01-15 Kentucky 4467673 337450 174748 0.517848570158542 162733.0 0.0364245547961992 10672.0 0.0023887155572934
100 100 2021-01-15 Ohio 11689100 968250 375428 0.3877387038471469 361818.0 0.0309534523616018 13552.0 0.0011593706957764

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "cdc-vaccination-state-totals" (
   [date] TEXT,
   [state] TEXT,
   [population] INTEGER,
   [doses_distributed] INTEGER,
   [doses_administered] INTEGER,
   [doses_administered_percent] FLOAT,
   [administered_dose1] FLOAT,
   [administered_dose1_percent] FLOAT,
   [administered_dose2] FLOAT,
   [administered_dose2_percent] FLOAT
);
Powered by Datasette · Queries took 496.647ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows