ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,030 rows where state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Colorado · 324 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17895 | 17895 | 2021-01-22 | Colorado | 8 | 385153 | 5548 |
17840 | 17840 | 2021-01-21 | Colorado | 8 | 382918 | 5523 |
17785 | 17785 | 2021-01-20 | Colorado | 8 | 381414 | 5509 |
17730 | 17730 | 2021-01-19 | Colorado | 8 | 379999 | 5473 |
17675 | 17675 | 2021-01-18 | Colorado | 8 | 378311 | 5462 |
17620 | 17620 | 2021-01-17 | Colorado | 8 | 376921 | 5454 |
17565 | 17565 | 2021-01-16 | Colorado | 8 | 375463 | 5440 |
17510 | 17510 | 2021-01-15 | Colorado | 8 | 373647 | 5417 |
17455 | 17455 | 2021-01-14 | Colorado | 8 | 371362 | 5385 |
17400 | 17400 | 2021-01-13 | Colorado | 8 | 368775 | 5354 |
17345 | 17345 | 2021-01-12 | Colorado | 8 | 366385 | 5326 |
17290 | 17290 | 2021-01-11 | Colorado | 8 | 364815 | 5291 |
17235 | 17235 | 2021-01-10 | Colorado | 8 | 363019 | 5279 |
17180 | 17180 | 2021-01-09 | Colorado | 8 | 360857 | 5262 |
17125 | 17125 | 2021-01-08 | Colorado | 8 | 357465 | 5207 |
17070 | 17070 | 2021-01-07 | Colorado | 8 | 354998 | 5164 |
17015 | 17015 | 2021-01-06 | Colorado | 8 | 350560 | 5080 |
16960 | 16960 | 2021-01-05 | Colorado | 8 | 348483 | 5058 |
16905 | 16905 | 2021-01-04 | Colorado | 8 | 345239 | 5011 |
16850 | 16850 | 2021-01-03 | Colorado | 8 | 342494 | 4997 |
16795 | 16795 | 2021-01-02 | Colorado | 8 | 340454 | 4976 |
16740 | 16740 | 2021-01-01 | Colorado | 8 | 338357 | 4936 |
16685 | 16685 | 2020-12-31 | Colorado | 8 | 335579 | 4879 |
16630 | 16630 | 2020-12-30 | Colorado | 8 | 332686 | 4822 |
16575 | 16575 | 2020-12-29 | Colorado | 8 | 330118 | 4758 |
16520 | 16520 | 2020-12-28 | Colorado | 8 | 328249 | 4699 |
16465 | 16465 | 2020-12-27 | Colorado | 8 | 326276 | 4660 |
16410 | 16410 | 2020-12-26 | Colorado | 8 | 324869 | 4652 |
16355 | 16355 | 2020-12-25 | Colorado | 8 | 323329 | 4631 |
16300 | 16300 | 2020-12-24 | Colorado | 8 | 320714 | 4610 |
16245 | 16245 | 2020-12-23 | Colorado | 8 | 318027 | 4531 |
16190 | 16190 | 2020-12-22 | Colorado | 8 | 315397 | 4464 |
16135 | 16135 | 2020-12-21 | Colorado | 8 | 312713 | 4432 |
16080 | 16080 | 2020-12-20 | Colorado | 8 | 310522 | 4420 |
16025 | 16025 | 2020-12-19 | Colorado | 8 | 308350 | 4400 |
15970 | 15970 | 2020-12-18 | Colorado | 8 | 305622 | 4323 |
15915 | 15915 | 2020-12-17 | Colorado | 8 | 302086 | 4265 |
15860 | 15860 | 2020-12-16 | Colorado | 8 | 298492 | 4192 |
15805 | 15805 | 2020-12-15 | Colorado | 8 | 295558 | 4131 |
15750 | 15750 | 2020-12-14 | Colorado | 8 | 291645 | 4015 |
15695 | 15695 | 2020-12-13 | Colorado | 8 | 289679 | 3982 |
15640 | 15640 | 2020-12-12 | Colorado | 8 | 287364 | 3916 |
15585 | 15585 | 2020-12-11 | Colorado | 8 | 283571 | 3858 |
15530 | 15530 | 2020-12-10 | Colorado | 8 | 278916 | 3795 |
15475 | 15475 | 2020-12-09 | Colorado | 8 | 274354 | 3671 |
15420 | 15420 | 2020-12-08 | Colorado | 8 | 270381 | 3508 |
15365 | 15365 | 2020-12-07 | Colorado | 8 | 266670 | 3466 |
15310 | 15310 | 2020-12-06 | Colorado | 8 | 262460 | 3437 |
15255 | 15255 | 2020-12-05 | Colorado | 8 | 258124 | 3415 |
15200 | 15200 | 2020-12-04 | Colorado | 8 | 252960 | 3375 |
15145 | 15145 | 2020-12-03 | Colorado | 8 | 248779 | 3335 |
15090 | 15090 | 2020-12-02 | Colorado | 8 | 243324 | 3226 |
15035 | 15035 | 2020-12-01 | Colorado | 8 | 238779 | 3136 |
14980 | 14980 | 2020-11-30 | Colorado | 8 | 234502 | 3060 |
14925 | 14925 | 2020-11-29 | Colorado | 8 | 230057 | 3025 |
14870 | 14870 | 2020-11-28 | Colorado | 8 | 226567 | 3012 |
14815 | 14815 | 2020-11-27 | Colorado | 8 | 222544 | 2998 |
14760 | 14760 | 2020-11-26 | Colorado | 8 | 217655 | 2977 |
14705 | 14705 | 2020-11-25 | Colorado | 8 | 212416 | 2930 |
14650 | 14650 | 2020-11-24 | Colorado | 8 | 207882 | 2868 |
14595 | 14595 | 2020-11-23 | Colorado | 8 | 203578 | 2821 |
14540 | 14540 | 2020-11-22 | Colorado | 8 | 199296 | 2811 |
14485 | 14485 | 2020-11-21 | Colorado | 8 | 195220 | 2791 |
14430 | 14430 | 2020-11-20 | Colorado | 8 | 190100 | 2752 |
14375 | 14375 | 2020-11-19 | Colorado | 8 | 184260 | 2734 |
14320 | 14320 | 2020-11-18 | Colorado | 8 | 178224 | 2669 |
14265 | 14265 | 2020-11-17 | Colorado | 8 | 173220 | 2626 |
14210 | 14210 | 2020-11-16 | Colorado | 8 | 168890 | 2605 |
14155 | 14155 | 2020-11-15 | Colorado | 8 | 164408 | 2574 |
14100 | 14100 | 2020-11-14 | Colorado | 8 | 160459 | 2554 |
14045 | 14045 | 2020-11-13 | Colorado | 8 | 155761 | 2541 |
13990 | 13990 | 2020-11-12 | Colorado | 8 | 149262 | 2512 |
13935 | 13935 | 2020-11-11 | Colorado | 8 | 143553 | 2481 |
13880 | 13880 | 2020-11-10 | Colorado | 8 | 139246 | 2469 |
13825 | 13825 | 2020-11-09 | Colorado | 8 | 135747 | 2438 |
13770 | 13770 | 2020-11-08 | Colorado | 8 | 131870 | 2421 |
13715 | 13715 | 2020-11-07 | Colorado | 8 | 128611 | 2417 |
13660 | 13660 | 2020-11-06 | Colorado | 8 | 125397 | 2404 |
13605 | 13605 | 2020-11-05 | Colorado | 8 | 122170 | 2383 |
13550 | 13550 | 2020-11-04 | Colorado | 8 | 118356 | 2366 |
13495 | 13495 | 2020-11-03 | Colorado | 8 | 115364 | 2337 |
13440 | 13440 | 2020-11-02 | Colorado | 8 | 112821 | 2320 |
13385 | 13385 | 2020-11-01 | Colorado | 8 | 110640 | 2312 |
13330 | 13330 | 2020-10-31 | Colorado | 8 | 107844 | 2309 |
13275 | 13275 | 2020-10-30 | Colorado | 8 | 104927 | 2302 |
13220 | 13220 | 2020-10-29 | Colorado | 8 | 102665 | 2295 |
13165 | 13165 | 2020-10-28 | Colorado | 8 | 100614 | 2277 |
13110 | 13110 | 2020-10-27 | Colorado | 8 | 99111 | 2265 |
13055 | 13055 | 2020-10-26 | Colorado | 8 | 97686 | 2255 |
13000 | 13000 | 2020-10-25 | Colorado | 8 | 95742 | 2244 |
12945 | 12945 | 2020-10-24 | Colorado | 8 | 93989 | 2241 |
12890 | 12890 | 2020-10-23 | Colorado | 8 | 92067 | 2233 |
12835 | 12835 | 2020-10-22 | Colorado | 8 | 90639 | 2224 |
12780 | 12780 | 2020-10-21 | Colorado | 8 | 89245 | 2220 |
12725 | 12725 | 2020-10-20 | Colorado | 8 | 87966 | 2212 |
12670 | 12670 | 2020-10-19 | Colorado | 8 | 86727 | 2207 |
12615 | 12615 | 2020-10-18 | Colorado | 8 | 85803 | 2199 |
12560 | 12560 | 2020-10-17 | Colorado | 8 | 84804 | 2199 |
12505 | 12505 | 2020-10-16 | Colorado | 8 | 83712 | 2196 |
12450 | 12450 | 2020-10-15 | Colorado | 8 | 82443 | 2187 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );