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)
Suggested facets: date (date)
state 1
- California · 1,070 ✖
Link | rowid | date | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|
6 | 6 | 2020-01-25 | California | 6 | 1 | 0 |
10 | 10 | 2020-01-26 | California | 6 | 2 | 0 |
14 | 14 | 2020-01-27 | California | 6 | 2 | 0 |
18 | 18 | 2020-01-28 | California | 6 | 2 | 0 |
22 | 22 | 2020-01-29 | California | 6 | 2 | 0 |
26 | 26 | 2020-01-30 | California | 6 | 2 | 0 |
30 | 30 | 2020-01-31 | California | 6 | 3 | 0 |
34 | 34 | 2020-02-01 | California | 6 | 3 | 0 |
39 | 39 | 2020-02-02 | California | 6 | 6 | 0 |
44 | 44 | 2020-02-03 | California | 6 | 6 | 0 |
49 | 49 | 2020-02-04 | California | 6 | 6 | 0 |
54 | 54 | 2020-02-05 | California | 6 | 6 | 0 |
60 | 60 | 2020-02-06 | California | 6 | 6 | 0 |
66 | 66 | 2020-02-07 | California | 6 | 6 | 0 |
72 | 72 | 2020-02-08 | California | 6 | 6 | 0 |
78 | 78 | 2020-02-09 | California | 6 | 6 | 0 |
84 | 84 | 2020-02-10 | California | 6 | 7 | 0 |
90 | 90 | 2020-02-11 | California | 6 | 7 | 0 |
96 | 96 | 2020-02-12 | California | 6 | 7 | 0 |
103 | 103 | 2020-02-13 | California | 6 | 7 | 0 |
110 | 110 | 2020-02-14 | California | 6 | 7 | 0 |
117 | 117 | 2020-02-15 | California | 6 | 7 | 0 |
124 | 124 | 2020-02-16 | California | 6 | 7 | 0 |
131 | 131 | 2020-02-17 | California | 6 | 7 | 0 |
139 | 139 | 2020-02-18 | California | 6 | 7 | 0 |
147 | 147 | 2020-02-19 | California | 6 | 7 | 0 |
155 | 155 | 2020-02-20 | California | 6 | 8 | 0 |
163 | 163 | 2020-02-21 | California | 6 | 9 | 0 |
171 | 171 | 2020-02-22 | California | 6 | 9 | 0 |
179 | 179 | 2020-02-23 | California | 6 | 9 | 0 |
187 | 187 | 2020-02-24 | California | 6 | 11 | 0 |
195 | 195 | 2020-02-25 | California | 6 | 11 | 0 |
204 | 204 | 2020-02-26 | California | 6 | 26 | 0 |
213 | 213 | 2020-02-27 | California | 6 | 26 | 0 |
222 | 222 | 2020-02-28 | California | 6 | 27 | 0 |
232 | 232 | 2020-02-29 | California | 6 | 28 | 0 |
242 | 242 | 2020-03-01 | California | 6 | 33 | 0 |
255 | 255 | 2020-03-02 | California | 6 | 38 | 0 |
270 | 270 | 2020-03-03 | California | 6 | 45 | 0 |
286 | 286 | 2020-03-04 | California | 6 | 55 | 1 |
303 | 303 | 2020-03-05 | California | 6 | 67 | 1 |
324 | 324 | 2020-03-06 | California | 6 | 81 | 1 |
352 | 352 | 2020-03-07 | California | 6 | 100 | 1 |
385 | 385 | 2020-03-08 | California | 6 | 112 | 1 |
420 | 420 | 2020-03-09 | California | 6 | 172 | 2 |
457 | 457 | 2020-03-10 | California | 6 | 179 | 3 |
497 | 497 | 2020-03-11 | California | 6 | 202 | 4 |
543 | 543 | 2020-03-12 | California | 6 | 252 | 4 |
591 | 591 | 2020-03-13 | California | 6 | 320 | 5 |
642 | 642 | 2020-03-14 | California | 6 | 381 | 5 |
694 | 694 | 2020-03-15 | California | 6 | 478 | 6 |
747 | 747 | 2020-03-16 | California | 6 | 588 | 11 |
800 | 800 | 2020-03-17 | California | 6 | 732 | 14 |
854 | 854 | 2020-03-18 | California | 6 | 893 | 17 |
908 | 908 | 2020-03-19 | California | 6 | 1067 | 19 |
962 | 962 | 2020-03-20 | California | 6 | 1283 | 24 |
1016 | 1016 | 2020-03-21 | California | 6 | 1544 | 28 |
1070 | 1070 | 2020-03-22 | California | 6 | 1851 | 35 |
1124 | 1124 | 2020-03-23 | California | 6 | 2240 | 39 |
1178 | 1178 | 2020-03-24 | California | 6 | 2644 | 52 |
1232 | 1232 | 2020-03-25 | California | 6 | 3183 | 68 |
1286 | 1286 | 2020-03-26 | California | 6 | 4060 | 83 |
1340 | 1340 | 2020-03-27 | California | 6 | 4915 | 104 |
1394 | 1394 | 2020-03-28 | California | 6 | 5566 | 122 |
1449 | 1449 | 2020-03-29 | California | 6 | 6321 | 132 |
1504 | 1504 | 2020-03-30 | California | 6 | 7421 | 147 |
1559 | 1559 | 2020-03-31 | California | 6 | 8583 | 184 |
1614 | 1614 | 2020-04-01 | California | 6 | 9857 | 212 |
1669 | 1669 | 2020-04-02 | California | 6 | 11190 | 247 |
1724 | 1724 | 2020-04-03 | California | 6 | 12569 | 282 |
1779 | 1779 | 2020-04-04 | California | 6 | 13796 | 323 |
1834 | 1834 | 2020-04-05 | California | 6 | 15202 | 351 |
1889 | 1889 | 2020-04-06 | California | 6 | 16361 | 386 |
1944 | 1944 | 2020-04-07 | California | 6 | 17540 | 447 |
1999 | 1999 | 2020-04-08 | California | 6 | 19043 | 506 |
2054 | 2054 | 2020-04-09 | California | 6 | 20191 | 548 |
2109 | 2109 | 2020-04-10 | California | 6 | 21366 | 594 |
2164 | 2164 | 2020-04-11 | California | 6 | 22421 | 632 |
2219 | 2219 | 2020-04-12 | California | 6 | 23323 | 676 |
2274 | 2274 | 2020-04-13 | California | 6 | 24334 | 725 |
2329 | 2329 | 2020-04-14 | California | 6 | 25758 | 778 |
2384 | 2384 | 2020-04-15 | California | 6 | 27107 | 885 |
2439 | 2439 | 2020-04-16 | California | 6 | 28142 | 971 |
2494 | 2494 | 2020-04-17 | California | 6 | 29398 | 1050 |
2549 | 2549 | 2020-04-18 | California | 6 | 30829 | 1146 |
2604 | 2604 | 2020-04-19 | California | 6 | 31544 | 1176 |
2659 | 2659 | 2020-04-20 | California | 6 | 33862 | 1223 |
2714 | 2714 | 2020-04-21 | California | 6 | 35844 | 1316 |
2769 | 2769 | 2020-04-22 | California | 6 | 37573 | 1425 |
2824 | 2824 | 2020-04-23 | California | 6 | 39534 | 1548 |
2879 | 2879 | 2020-04-24 | California | 6 | 41368 | 1619 |
2934 | 2934 | 2020-04-25 | California | 6 | 42590 | 1692 |
2989 | 2989 | 2020-04-26 | California | 6 | 43691 | 1716 |
3044 | 3044 | 2020-04-27 | California | 6 | 45208 | 1800 |
3099 | 3099 | 2020-04-28 | California | 6 | 46570 | 1884 |
3154 | 3154 | 2020-04-29 | California | 6 | 48904 | 1961 |
3209 | 3209 | 2020-04-30 | California | 6 | 50470 | 2057 |
3264 | 3264 | 2020-05-01 | California | 6 | 52318 | 2147 |
3319 | 3319 | 2020-05-02 | California | 6 | 53753 | 2213 |
3374 | 3374 | 2020-05-03 | California | 6 | 55072 | 2235 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );