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 · 364 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17894 | 17894 | 2021-01-22 | California | 6 | 3141404 | 36326 |
17839 | 17839 | 2021-01-21 | California | 6 | 3116369 | 35704 |
17784 | 17784 | 2021-01-20 | California | 6 | 3090794 | 35001 |
17729 | 17729 | 2021-01-19 | California | 6 | 3071465 | 34390 |
17674 | 17674 | 2021-01-18 | California | 6 | 3032359 | 33742 |
17619 | 17619 | 2021-01-17 | California | 6 | 3006966 | 33593 |
17564 | 17564 | 2021-01-16 | California | 6 | 2975419 | 33393 |
17509 | 17509 | 2021-01-15 | California | 6 | 2937860 | 32947 |
17454 | 17454 | 2021-01-14 | California | 6 | 2898756 | 32246 |
17399 | 17399 | 2021-01-13 | California | 6 | 2858041 | 31653 |
17344 | 17344 | 2021-01-12 | California | 6 | 2816366 | 31105 |
17289 | 17289 | 2021-01-11 | California | 6 | 2770482 | 30381 |
17234 | 17234 | 2021-01-10 | California | 6 | 2729858 | 30000 |
17179 | 17179 | 2021-01-09 | California | 6 | 2687450 | 29699 |
17124 | 17124 | 2021-01-08 | California | 6 | 2640221 | 29228 |
17069 | 17069 | 2021-01-07 | California | 6 | 2589250 | 28554 |
17014 | 17014 | 2021-01-06 | California | 6 | 2548830 | 28040 |
16959 | 16959 | 2021-01-05 | California | 6 | 2511923 | 27486 |
16904 | 16904 | 2021-01-04 | California | 6 | 2474639 | 26995 |
16849 | 16849 | 2021-01-03 | California | 6 | 2433916 | 26635 |
16794 | 16794 | 2021-01-02 | California | 6 | 2398005 | 26542 |
16739 | 16739 | 2021-01-01 | California | 6 | 2345811 | 26236 |
16684 | 16684 | 2020-12-31 | California | 6 | 2307860 | 25965 |
16629 | 16629 | 2020-12-30 | California | 6 | 2275565 | 25391 |
16574 | 16574 | 2020-12-29 | California | 6 | 2243191 | 24954 |
16519 | 16519 | 2020-12-28 | California | 6 | 2209024 | 24529 |
16464 | 16464 | 2020-12-27 | California | 6 | 2167303 | 24283 |
16409 | 16409 | 2020-12-26 | California | 6 | 2129749 | 24221 |
16354 | 16354 | 2020-12-25 | California | 6 | 2064763 | 23964 |
16299 | 16299 | 2020-12-24 | California | 6 | 2048014 | 23944 |
16244 | 16244 | 2020-12-23 | California | 6 | 2013298 | 23633 |
16189 | 16189 | 2020-12-22 | California | 6 | 1968541 | 23254 |
16134 | 16134 | 2020-12-21 | California | 6 | 1933169 | 22980 |
16079 | 16079 | 2020-12-20 | California | 6 | 1889914 | 22736 |
16024 | 16024 | 2020-12-19 | California | 6 | 1847031 | 22651 |
15969 | 15969 | 2020-12-18 | California | 6 | 1809673 | 22496 |
15914 | 15914 | 2020-12-17 | California | 6 | 1761430 | 22155 |
15859 | 15859 | 2020-12-16 | California | 6 | 1716108 | 21881 |
15804 | 15804 | 2020-12-15 | California | 6 | 1655166 | 21483 |
15749 | 15749 | 2020-12-14 | California | 6 | 1620916 | 21196 |
15694 | 15694 | 2020-12-13 | California | 6 | 1590726 | 21043 |
15639 | 15639 | 2020-12-12 | California | 6 | 1554920 | 20958 |
15584 | 15584 | 2020-12-11 | California | 6 | 1528237 | 20854 |
15529 | 15529 | 2020-12-10 | California | 6 | 1491132 | 20636 |
15474 | 15474 | 2020-12-09 | California | 6 | 1457273 | 20466 |
15419 | 15419 | 2020-12-08 | California | 6 | 1425501 | 20238 |
15364 | 15364 | 2020-12-07 | California | 6 | 1399239 | 20052 |
15309 | 15309 | 2020-12-06 | California | 6 | 1371985 | 19937 |
15254 | 15254 | 2020-12-05 | California | 6 | 1343193 | 19876 |
15199 | 15199 | 2020-12-04 | California | 6 | 1318188 | 19791 |
15144 | 15144 | 2020-12-03 | California | 6 | 1293937 | 19586 |
15089 | 15089 | 2020-12-02 | California | 6 | 1272079 | 19440 |
15034 | 15034 | 2020-12-01 | California | 6 | 1253905 | 19327 |
14979 | 14979 | 2020-11-30 | California | 6 | 1237238 | 19209 |
14924 | 14924 | 2020-11-29 | California | 6 | 1219511 | 19151 |
14869 | 14869 | 2020-11-28 | California | 6 | 1206296 | 19132 |
14814 | 14814 | 2020-11-27 | California | 6 | 1193089 | 19100 |
14759 | 14759 | 2020-11-26 | California | 6 | 1176159 | 19025 |
14704 | 14704 | 2020-11-25 | California | 6 | 1167176 | 18982 |
14649 | 14649 | 2020-11-24 | California | 6 | 1153032 | 18875 |
14594 | 14594 | 2020-11-23 | California | 6 | 1136498 | 18768 |
14539 | 14539 | 2020-11-22 | California | 6 | 1118673 | 18726 |
14484 | 14484 | 2020-11-21 | California | 6 | 1109869 | 18709 |
14429 | 14429 | 2020-11-20 | California | 6 | 1096427 | 18649 |
14374 | 14374 | 2020-11-19 | California | 6 | 1082705 | 18555 |
14319 | 14319 | 2020-11-18 | California | 6 | 1069544 | 18467 |
14264 | 14264 | 2020-11-17 | California | 6 | 1058123 | 18360 |
14209 | 14209 | 2020-11-16 | California | 6 | 1047390 | 18304 |
14154 | 14154 | 2020-11-15 | California | 6 | 1036008 | 18265 |
14099 | 14099 | 2020-11-14 | California | 6 | 1027044 | 18254 |
14044 | 14044 | 2020-11-13 | California | 6 | 1019080 | 18218 |
13989 | 13989 | 2020-11-12 | California | 6 | 1009216 | 18141 |
13934 | 13934 | 2020-11-11 | California | 6 | 999516 | 18109 |
13879 | 13879 | 2020-11-10 | California | 6 | 994366 | 18073 |
13824 | 13824 | 2020-11-09 | California | 6 | 985623 | 18035 |
13769 | 13769 | 2020-11-08 | California | 6 | 978861 | 17975 |
13714 | 13714 | 2020-11-07 | California | 6 | 972821 | 17964 |
13659 | 13659 | 2020-11-06 | California | 6 | 967618 | 17939 |
13604 | 13604 | 2020-11-05 | California | 6 | 960905 | 17866 |
13549 | 13549 | 2020-11-04 | California | 6 | 954629 | 17818 |
13494 | 13494 | 2020-11-03 | California | 6 | 949390 | 17751 |
13439 | 13439 | 2020-11-02 | California | 6 | 944148 | 17700 |
13384 | 13384 | 2020-11-01 | California | 6 | 938897 | 17671 |
13329 | 13329 | 2020-10-31 | California | 6 | 935262 | 17661 |
13274 | 13274 | 2020-10-30 | California | 6 | 931843 | 17627 |
13219 | 13219 | 2020-10-29 | California | 6 | 926910 | 17567 |
13164 | 13164 | 2020-10-28 | California | 6 | 922685 | 17541 |
13109 | 13109 | 2020-10-27 | California | 6 | 918635 | 17478 |
13054 | 13054 | 2020-10-26 | California | 6 | 913707 | 17398 |
12999 | 12999 | 2020-10-25 | California | 6 | 909345 | 17358 |
12944 | 12944 | 2020-10-24 | California | 6 | 906645 | 17345 |
12889 | 12889 | 2020-10-23 | California | 6 | 902328 | 17316 |
12834 | 12834 | 2020-10-22 | California | 6 | 896427 | 17266 |
12779 | 12779 | 2020-10-21 | California | 6 | 890154 | 17189 |
12724 | 12724 | 2020-10-20 | California | 6 | 887094 | 17067 |
12669 | 12669 | 2020-10-19 | California | 6 | 882666 | 16987 |
12614 | 12614 | 2020-10-18 | California | 6 | 878395 | 16979 |
12559 | 12559 | 2020-10-17 | California | 6 | 876258 | 16940 |
12504 | 12504 | 2020-10-16 | California | 6 | 874102 | 16901 |
12449 | 12449 | 2020-10-15 | California | 6 | 870380 | 16839 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );