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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- California · 970 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
51588 | 51588 | 2022-09-20 | California | 6 | 11201464 | 95695 |
51532 | 51532 | 2022-09-19 | California | 6 | 11199912 | 95680 |
51476 | 51476 | 2022-09-18 | California | 6 | 11196447 | 95643 |
51420 | 51420 | 2022-09-17 | California | 6 | 11196447 | 95643 |
51364 | 51364 | 2022-09-16 | California | 6 | 11196447 | 95643 |
51308 | 51308 | 2022-09-15 | California | 6 | 11194286 | 95624 |
51252 | 51252 | 2022-09-14 | California | 6 | 11171759 | 95521 |
51196 | 51196 | 2022-09-13 | California | 6 | 11169894 | 95472 |
51140 | 51140 | 2022-09-12 | California | 6 | 11168261 | 95459 |
51084 | 51084 | 2022-09-11 | California | 6 | 11163758 | 95415 |
51028 | 51028 | 2022-09-10 | California | 6 | 11163758 | 95407 |
50972 | 50972 | 2022-09-09 | California | 6 | 11163758 | 95407 |
50916 | 50916 | 2022-09-08 | California | 6 | 11147393 | 95295 |
50860 | 50860 | 2022-09-07 | California | 6 | 11145708 | 95183 |
50804 | 50804 | 2022-09-06 | California | 6 | 11124581 | 95147 |
50748 | 50748 | 2022-09-05 | California | 6 | 11122387 | 95119 |
50692 | 50692 | 2022-09-04 | California | 6 | 11117372 | 95097 |
50636 | 50636 | 2022-09-03 | California | 6 | 11117372 | 95097 |
50580 | 50580 | 2022-09-02 | California | 6 | 11117372 | 95097 |
50524 | 50524 | 2022-09-01 | California | 6 | 11093984 | 95017 |
50468 | 50468 | 2022-08-31 | California | 6 | 11091425 | 95001 |
50412 | 50412 | 2022-08-30 | California | 6 | 11088191 | 94973 |
50356 | 50356 | 2022-08-29 | California | 6 | 11060838 | 94947 |
50300 | 50300 | 2022-08-28 | California | 6 | 11054444 | 94913 |
50244 | 50244 | 2022-08-27 | California | 6 | 11054444 | 94913 |
50188 | 50188 | 2022-08-26 | California | 6 | 11054444 | 94913 |
50132 | 50132 | 2022-08-25 | California | 6 | 11022505 | 94750 |
50076 | 50076 | 2022-08-24 | California | 6 | 11019530 | 94725 |
50020 | 50020 | 2022-08-23 | California | 6 | 11015161 | 94685 |
49964 | 49964 | 2022-08-22 | California | 6 | 10987530 | 94571 |
49908 | 49908 | 2022-08-21 | California | 6 | 10979626 | 94547 |
49852 | 49852 | 2022-08-20 | California | 6 | 10979626 | 94547 |
49796 | 49796 | 2022-08-19 | California | 6 | 10979626 | 94547 |
49740 | 49740 | 2022-08-18 | California | 6 | 10947473 | 94448 |
49684 | 49684 | 2022-08-17 | California | 6 | 10944159 | 94424 |
49628 | 49628 | 2022-08-16 | California | 6 | 10939491 | 94365 |
49572 | 49572 | 2022-08-15 | California | 6 | 10908539 | 94262 |
49516 | 49516 | 2022-08-14 | California | 6 | 10898548 | 94234 |
49460 | 49460 | 2022-08-13 | California | 6 | 10898548 | 94234 |
49404 | 49404 | 2022-08-12 | California | 6 | 10898548 | 94234 |
49348 | 49348 | 2022-08-11 | California | 6 | 10862660 | 94098 |
49292 | 49292 | 2022-08-10 | California | 6 | 10858351 | 94057 |
49236 | 49236 | 2022-08-09 | California | 6 | 10853402 | 94034 |
49180 | 49180 | 2022-08-08 | California | 6 | 10817941 | 93950 |
49124 | 49124 | 2022-08-07 | California | 6 | 10807573 | 93919 |
49068 | 49068 | 2022-08-06 | California | 6 | 10807573 | 93919 |
49012 | 49012 | 2022-08-05 | California | 6 | 10807573 | 93919 |
48956 | 48956 | 2022-08-04 | California | 6 | 10769686 | 93813 |
48900 | 48900 | 2022-08-03 | California | 6 | 10764622 | 93782 |
48844 | 48844 | 2022-08-02 | California | 6 | 10757986 | 93734 |
48788 | 48788 | 2022-08-01 | California | 6 | 10713333 | 93651 |
48732 | 48732 | 2022-07-31 | California | 6 | 10700053 | 93613 |
48676 | 48676 | 2022-07-30 | California | 6 | 10700053 | 93613 |
48620 | 48620 | 2022-07-29 | California | 6 | 10700053 | 93613 |
48564 | 48564 | 2022-07-28 | California | 6 | 10656412 | 93508 |
48508 | 48508 | 2022-07-27 | California | 6 | 10649458 | 93482 |
48452 | 48452 | 2022-07-26 | California | 6 | 10641665 | 93438 |
48396 | 48396 | 2022-07-25 | California | 6 | 10594052 | 93362 |
48340 | 48340 | 2022-07-24 | California | 6 | 10578770 | 93325 |
48284 | 48284 | 2022-07-23 | California | 6 | 10578770 | 93325 |
48228 | 48228 | 2022-07-22 | California | 6 | 10578770 | 93325 |
48172 | 48172 | 2022-07-21 | California | 6 | 10522372 | 93216 |
48116 | 48116 | 2022-07-20 | California | 6 | 10513729 | 93180 |
48060 | 48060 | 2022-07-19 | California | 6 | 10506662 | 93152 |
48004 | 48004 | 2022-07-18 | California | 6 | 10454194 | 93072 |
47948 | 47948 | 2022-07-17 | California | 6 | 10435541 | 93043 |
47892 | 47892 | 2022-07-16 | California | 6 | 10435541 | 93043 |
47836 | 47836 | 2022-07-15 | California | 6 | 10435541 | 93043 |
47780 | 47780 | 2022-07-14 | California | 6 | 10374290 | 92947 |
47724 | 47724 | 2022-07-13 | California | 6 | 10365785 | 92927 |
47668 | 47668 | 2022-07-12 | California | 6 | 10358182 | 92900 |
47612 | 47612 | 2022-07-11 | California | 6 | 10298129 | 92829 |
47556 | 47556 | 2022-07-10 | California | 6 | 10279898 | 92793 |
47500 | 47500 | 2022-07-09 | California | 6 | 10279898 | 92793 |
47444 | 47444 | 2022-07-08 | California | 6 | 10279898 | 92793 |
47388 | 47388 | 2022-07-07 | California | 6 | 10233568 | 92690 |
47332 | 47332 | 2022-07-06 | California | 6 | 10228221 | 92673 |
47276 | 47276 | 2022-07-05 | California | 6 | 10177563 | 92580 |
47220 | 47220 | 2022-07-04 | California | 6 | 10171959 | 92560 |
47164 | 47164 | 2022-07-03 | California | 6 | 10156643 | 92541 |
47108 | 47108 | 2022-07-02 | California | 6 | 10156643 | 92541 |
47052 | 47052 | 2022-07-01 | California | 6 | 10156643 | 92541 |
46996 | 46996 | 2022-06-30 | California | 6 | 10101062 | 92418 |
46940 | 46940 | 2022-06-29 | California | 6 | 10095355 | 92403 |
46884 | 46884 | 2022-06-28 | California | 6 | 10087984 | 92371 |
46828 | 46828 | 2022-06-27 | California | 6 | 10038765 | 92289 |
46772 | 46772 | 2022-06-26 | California | 6 | 10025110 | 92272 |
46716 | 46716 | 2022-06-25 | California | 6 | 10025036 | 92271 |
46660 | 46660 | 2022-06-24 | California | 6 | 10025036 | 92271 |
46604 | 46604 | 2022-06-23 | California | 6 | 9967883 | 92186 |
46548 | 46548 | 2022-06-22 | California | 6 | 9962108 | 92173 |
46492 | 46492 | 2022-06-21 | California | 6 | 9955717 | 92155 |
46436 | 46436 | 2022-06-20 | California | 6 | 9906427 | 92097 |
46380 | 46380 | 2022-06-19 | California | 6 | 9894394 | 92086 |
46324 | 46324 | 2022-06-18 | California | 6 | 9894394 | 92086 |
46268 | 46268 | 2022-06-17 | California | 6 | 9894394 | 92086 |
46212 | 46212 | 2022-06-16 | California | 6 | 9861034 | 92004 |
46156 | 46156 | 2022-06-15 | California | 6 | 9856336 | 91969 |
46100 | 46100 | 2022-06-14 | California | 6 | 9850089 | 91956 |
46044 | 46044 | 2022-06-13 | California | 6 | 9802778 | 91881 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );