ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,070 rows where state = "California" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- California · 970 ✖
Link | rowid | date | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|
3429 | 3429 | 2020-05-04 | California | 6 | 56333 | 2297 |
3484 | 3484 | 2020-05-05 | California | 6 | 58848 | 2386 |
3539 | 3539 | 2020-05-06 | California | 6 | 60787 | 2478 |
3594 | 3594 | 2020-05-07 | California | 6 | 62481 | 2561 |
3649 | 3649 | 2020-05-08 | California | 6 | 64616 | 2650 |
3704 | 3704 | 2020-05-09 | California | 6 | 66824 | 2732 |
3759 | 3759 | 2020-05-10 | California | 6 | 68051 | 2769 |
3814 | 3814 | 2020-05-11 | California | 6 | 69514 | 2820 |
3869 | 3869 | 2020-05-12 | California | 6 | 71150 | 2902 |
3924 | 3924 | 2020-05-13 | California | 6 | 73218 | 3014 |
3979 | 3979 | 2020-05-14 | California | 6 | 74947 | 3039 |
4034 | 4034 | 2020-05-15 | California | 6 | 77015 | 3192 |
4089 | 4089 | 2020-05-16 | California | 6 | 78933 | 3254 |
4144 | 4144 | 2020-05-17 | California | 6 | 80366 | 3290 |
4199 | 4199 | 2020-05-18 | California | 6 | 81943 | 3322 |
4254 | 4254 | 2020-05-19 | California | 6 | 83981 | 3422 |
4309 | 4309 | 2020-05-20 | California | 6 | 86125 | 3514 |
4364 | 4364 | 2020-05-21 | California | 6 | 88488 | 3624 |
4419 | 4419 | 2020-05-22 | California | 6 | 90801 | 3690 |
4474 | 4474 | 2020-05-23 | California | 6 | 92815 | 3768 |
4529 | 4529 | 2020-05-24 | California | 6 | 94743 | 3790 |
4584 | 4584 | 2020-05-25 | California | 6 | 97017 | 3808 |
4639 | 4639 | 2020-05-26 | California | 6 | 99924 | 3859 |
4694 | 4694 | 2020-05-27 | California | 6 | 101873 | 3961 |
4749 | 4749 | 2020-05-28 | California | 6 | 104071 | 4042 |
4804 | 4804 | 2020-05-29 | California | 6 | 107043 | 4144 |
4859 | 4859 | 2020-05-30 | California | 6 | 110100 | 4214 |
4914 | 4914 | 2020-05-31 | California | 6 | 113114 | 4242 |
4969 | 4969 | 2020-06-01 | California | 6 | 115643 | 4287 |
5024 | 5024 | 2020-06-02 | California | 6 | 118081 | 4360 |
5079 | 5079 | 2020-06-03 | California | 6 | 120407 | 4422 |
5134 | 5134 | 2020-06-04 | California | 6 | 122917 | 4484 |
5189 | 5189 | 2020-06-05 | California | 6 | 126510 | 4550 |
5244 | 5244 | 2020-06-06 | California | 6 | 129147 | 4626 |
5299 | 5299 | 2020-06-07 | California | 6 | 131997 | 4653 |
5354 | 5354 | 2020-06-08 | California | 6 | 134287 | 4679 |
5409 | 5409 | 2020-06-09 | California | 6 | 137245 | 4775 |
5464 | 5464 | 2020-06-10 | California | 6 | 140139 | 4869 |
5519 | 5519 | 2020-06-11 | California | 6 | 143709 | 4941 |
5574 | 5574 | 2020-06-12 | California | 6 | 147285 | 4986 |
5629 | 5629 | 2020-06-13 | California | 6 | 150434 | 5059 |
5684 | 5684 | 2020-06-14 | California | 6 | 152953 | 5089 |
5739 | 5739 | 2020-06-15 | California | 6 | 155662 | 5120 |
5794 | 5794 | 2020-06-16 | California | 6 | 159131 | 5202 |
5849 | 5849 | 2020-06-17 | California | 6 | 163381 | 5283 |
5904 | 5904 | 2020-06-18 | California | 6 | 167135 | 5359 |
5959 | 5959 | 2020-06-19 | California | 6 | 170843 | 5425 |
6014 | 6014 | 2020-06-20 | California | 6 | 174854 | 5495 |
6069 | 6069 | 2020-06-21 | California | 6 | 178807 | 5517 |
6124 | 6124 | 2020-06-22 | California | 6 | 184620 | 5561 |
6179 | 6179 | 2020-06-23 | California | 6 | 191039 | 5637 |
6234 | 6234 | 2020-06-24 | California | 6 | 195889 | 5728 |
6289 | 6289 | 2020-06-25 | California | 6 | 201413 | 5810 |
6344 | 6344 | 2020-06-26 | California | 6 | 207027 | 5872 |
6399 | 6399 | 2020-06-27 | California | 6 | 211453 | 5902 |
6454 | 6454 | 2020-06-28 | California | 6 | 216955 | 5937 |
6509 | 6509 | 2020-06-29 | California | 6 | 223995 | 5979 |
6564 | 6564 | 2020-06-30 | California | 6 | 232153 | 6083 |
6619 | 6619 | 2020-07-01 | California | 6 | 239764 | 6168 |
6674 | 6674 | 2020-07-02 | California | 6 | 248198 | 6263 |
6729 | 6729 | 2020-07-03 | California | 6 | 256298 | 6315 |
6784 | 6784 | 2020-07-04 | California | 6 | 265176 | 6329 |
6839 | 6839 | 2020-07-05 | California | 6 | 271587 | 6369 |
6894 | 6894 | 2020-07-06 | California | 6 | 277869 | 6452 |
6949 | 6949 | 2020-07-07 | California | 6 | 287766 | 6563 |
7004 | 7004 | 2020-07-08 | California | 6 | 296304 | 6708 |
7059 | 7059 | 2020-07-09 | California | 6 | 303516 | 6825 |
7114 | 7114 | 2020-07-10 | California | 6 | 311505 | 6936 |
7169 | 7169 | 2020-07-11 | California | 6 | 320030 | 7012 |
7224 | 7224 | 2020-07-12 | California | 6 | 327676 | 7042 |
7279 | 7279 | 2020-07-13 | California | 6 | 336206 | 7086 |
7334 | 7334 | 2020-07-14 | California | 6 | 346593 | 7227 |
7389 | 7389 | 2020-07-15 | California | 6 | 355497 | 7368 |
7444 | 7444 | 2020-07-16 | California | 6 | 364761 | 7490 |
7499 | 7499 | 2020-07-17 | California | 6 | 374922 | 7607 |
7554 | 7554 | 2020-07-18 | California | 6 | 383194 | 7697 |
7609 | 7609 | 2020-07-19 | California | 6 | 391460 | 7710 |
7664 | 7664 | 2020-07-20 | California | 6 | 400195 | 7764 |
7719 | 7719 | 2020-07-21 | California | 6 | 410366 | 7883 |
7774 | 7774 | 2020-07-22 | California | 6 | 422528 | 8038 |
7829 | 7829 | 2020-07-23 | California | 6 | 433175 | 8190 |
7884 | 7884 | 2020-07-24 | California | 6 | 443096 | 8325 |
7939 | 7939 | 2020-07-25 | California | 6 | 453327 | 8428 |
7994 | 7994 | 2020-07-26 | California | 6 | 459338 | 8451 |
8049 | 8049 | 2020-07-27 | California | 6 | 467103 | 8544 |
8104 | 8104 | 2020-07-28 | California | 6 | 474951 | 8716 |
8159 | 8159 | 2020-07-29 | California | 6 | 486039 | 8884 |
8214 | 8214 | 2020-07-30 | California | 6 | 494269 | 9009 |
8269 | 8269 | 2020-07-31 | California | 6 | 502273 | 9222 |
8324 | 8324 | 2020-08-01 | California | 6 | 509507 | 9365 |
8379 | 8379 | 2020-08-02 | California | 6 | 515937 | 9399 |
8434 | 8434 | 2020-08-03 | California | 6 | 522235 | 9500 |
8489 | 8489 | 2020-08-04 | California | 6 | 527258 | 9696 |
8544 | 8544 | 2020-08-05 | California | 6 | 532776 | 9866 |
8599 | 8599 | 2020-08-06 | California | 6 | 541013 | 10014 |
8654 | 8654 | 2020-08-07 | California | 6 | 548142 | 10197 |
8709 | 8709 | 2020-08-08 | California | 6 | 556158 | 10299 |
8764 | 8764 | 2020-08-09 | California | 6 | 563244 | 10365 |
8819 | 8819 | 2020-08-10 | California | 6 | 574267 | 10460 |
8874 | 8874 | 2020-08-11 | California | 6 | 586078 | 10654 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );