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 · 935 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
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 |
45988 | 45988 | 2022-06-12 | California | 6 | 9789861 | 91862 |
45932 | 45932 | 2022-06-11 | California | 6 | 9789742 | 91862 |
45876 | 45876 | 2022-06-10 | California | 6 | 9789742 | 91862 |
45820 | 45820 | 2022-06-09 | California | 6 | 9740705 | 91771 |
45764 | 45764 | 2022-06-08 | California | 6 | 9735641 | 91763 |
45708 | 45708 | 2022-06-07 | California | 6 | 9728951 | 91740 |
45652 | 45652 | 2022-06-06 | California | 6 | 9675504 | 91681 |
45596 | 45596 | 2022-06-05 | California | 6 | 9661160 | 91659 |
45540 | 45540 | 2022-06-04 | California | 6 | 9661160 | 91659 |
45484 | 45484 | 2022-06-03 | California | 6 | 9661160 | 91660 |
45428 | 45428 | 2022-06-02 | California | 6 | 9623352 | 91590 |
45372 | 45372 | 2022-06-01 | California | 6 | 9618290 | 91552 |
45316 | 45316 | 2022-05-31 | California | 6 | 9572842 | 91489 |
45260 | 45260 | 2022-05-30 | California | 6 | 9569871 | 91469 |
45204 | 45204 | 2022-05-29 | California | 6 | 9557347 | 91464 |
45148 | 45148 | 2022-05-28 | California | 6 | 9557347 | 91463 |
45092 | 45092 | 2022-05-27 | California | 6 | 9557283 | 91462 |
45036 | 45036 | 2022-05-26 | California | 6 | 9516167 | 91353 |
44980 | 44980 | 2022-05-25 | California | 6 | 9509990 | 91340 |
44924 | 44924 | 2022-05-24 | California | 6 | 9505145 | 91316 |
44868 | 44868 | 2022-05-23 | California | 6 | 9461626 | 91231 |
44812 | 44812 | 2022-05-22 | California | 6 | 9449407 | 91209 |
44756 | 44756 | 2022-05-21 | California | 6 | 9449407 | 91203 |
44700 | 44700 | 2022-05-20 | California | 6 | 9449358 | 91203 |
44644 | 44644 | 2022-05-19 | California | 6 | 9407260 | 91079 |
44588 | 44588 | 2022-05-18 | California | 6 | 9402566 | 91067 |
44532 | 44532 | 2022-05-17 | California | 6 | 9398846 | 91058 |
44476 | 44476 | 2022-05-16 | California | 6 | 9359245 | 90986 |
44420 | 44420 | 2022-05-15 | California | 6 | 9351253 | 90961 |
44364 | 44364 | 2022-05-14 | California | 6 | 9351253 | 90961 |
44308 | 44308 | 2022-05-13 | California | 6 | 9351229 | 90959 |
44252 | 44252 | 2022-05-12 | California | 6 | 9328408 | 90818 |
44196 | 44196 | 2022-05-11 | California | 6 | 9324886 | 90804 |
44140 | 44140 | 2022-05-10 | California | 6 | 9321533 | 90822 |
44084 | 44084 | 2022-05-09 | California | 6 | 9296769 | 90712 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );