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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Colorado · 1,030 ✖
Link | rowid | date | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|
304 | 304 | 2020-03-05 | Colorado | 8 | 2 | 0 |
325 | 325 | 2020-03-06 | Colorado | 8 | 8 | 0 |
353 | 353 | 2020-03-07 | Colorado | 8 | 8 | 0 |
386 | 386 | 2020-03-08 | Colorado | 8 | 8 | 0 |
421 | 421 | 2020-03-09 | Colorado | 8 | 12 | 0 |
458 | 458 | 2020-03-10 | Colorado | 8 | 17 | 0 |
498 | 498 | 2020-03-11 | Colorado | 8 | 34 | 0 |
544 | 544 | 2020-03-12 | Colorado | 8 | 49 | 1 |
592 | 592 | 2020-03-13 | Colorado | 8 | 78 | 2 |
643 | 643 | 2020-03-14 | Colorado | 8 | 103 | 2 |
695 | 695 | 2020-03-15 | Colorado | 8 | 136 | 2 |
748 | 748 | 2020-03-16 | Colorado | 8 | 161 | 2 |
801 | 801 | 2020-03-17 | Colorado | 8 | 183 | 3 |
855 | 855 | 2020-03-18 | Colorado | 8 | 216 | 3 |
909 | 909 | 2020-03-19 | Colorado | 8 | 278 | 5 |
963 | 963 | 2020-03-20 | Colorado | 8 | 364 | 5 |
1017 | 1017 | 2020-03-21 | Colorado | 8 | 475 | 6 |
1071 | 1071 | 2020-03-22 | Colorado | 8 | 591 | 7 |
1125 | 1125 | 2020-03-23 | Colorado | 8 | 721 | 10 |
1179 | 1179 | 2020-03-24 | Colorado | 8 | 912 | 11 |
1233 | 1233 | 2020-03-25 | Colorado | 8 | 1086 | 19 |
1287 | 1287 | 2020-03-26 | Colorado | 8 | 1432 | 24 |
1341 | 1341 | 2020-03-27 | Colorado | 8 | 1735 | 31 |
1395 | 1395 | 2020-03-28 | Colorado | 8 | 2061 | 44 |
1450 | 1450 | 2020-03-29 | Colorado | 8 | 2315 | 47 |
1505 | 1505 | 2020-03-30 | Colorado | 8 | 2628 | 51 |
1560 | 1560 | 2020-03-31 | Colorado | 8 | 2990 | 69 |
1615 | 1615 | 2020-04-01 | Colorado | 8 | 3346 | 80 |
1670 | 1670 | 2020-04-02 | Colorado | 8 | 3728 | 96 |
1725 | 1725 | 2020-04-03 | Colorado | 8 | 4182 | 110 |
1780 | 1780 | 2020-04-04 | Colorado | 8 | 4574 | 126 |
1835 | 1835 | 2020-04-05 | Colorado | 8 | 4950 | 140 |
1890 | 1890 | 2020-04-06 | Colorado | 8 | 5172 | 150 |
1945 | 1945 | 2020-04-07 | Colorado | 8 | 5429 | 179 |
2000 | 2000 | 2020-04-08 | Colorado | 8 | 5655 | 192 |
2055 | 2055 | 2020-04-09 | Colorado | 8 | 6202 | 227 |
2110 | 2110 | 2020-04-10 | Colorado | 8 | 6510 | 253 |
2165 | 2165 | 2020-04-11 | Colorado | 8 | 6893 | 274 |
2220 | 2220 | 2020-04-12 | Colorado | 8 | 7303 | 290 |
2275 | 2275 | 2020-04-13 | Colorado | 8 | 7691 | 308 |
2330 | 2330 | 2020-04-14 | Colorado | 8 | 7941 | 329 |
2385 | 2385 | 2020-04-15 | Colorado | 8 | 8280 | 355 |
2440 | 2440 | 2020-04-16 | Colorado | 8 | 8675 | 374 |
2495 | 2495 | 2020-04-17 | Colorado | 8 | 9047 | 389 |
2550 | 2550 | 2020-04-18 | Colorado | 8 | 9433 | 409 |
2605 | 2605 | 2020-04-19 | Colorado | 8 | 9730 | 421 |
2660 | 2660 | 2020-04-20 | Colorado | 8 | 10106 | 448 |
2715 | 2715 | 2020-04-21 | Colorado | 8 | 10447 | 484 |
2770 | 2770 | 2020-04-22 | Colorado | 8 | 10878 | 526 |
2825 | 2825 | 2020-04-23 | Colorado | 8 | 11262 | 557 |
2880 | 2880 | 2020-04-24 | Colorado | 8 | 12255 | 672 |
2935 | 2935 | 2020-04-25 | Colorado | 8 | 12967 | 670 |
2990 | 2990 | 2020-04-26 | Colorado | 8 | 13440 | 678 |
3045 | 3045 | 2020-04-27 | Colorado | 8 | 13804 | 705 |
3100 | 3100 | 2020-04-28 | Colorado | 8 | 14239 | 734 |
3155 | 3155 | 2020-04-29 | Colorado | 8 | 14680 | 764 |
3210 | 3210 | 2020-04-30 | Colorado | 8 | 15207 | 775 |
3265 | 3265 | 2020-05-01 | Colorado | 8 | 15661 | 818 |
3320 | 3320 | 2020-05-02 | Colorado | 8 | 16118 | 830 |
3375 | 3375 | 2020-05-03 | Colorado | 8 | 16527 | 840 |
3430 | 3430 | 2020-05-04 | Colorado | 8 | 16799 | 849 |
3485 | 3485 | 2020-05-05 | Colorado | 8 | 17256 | 901 |
3540 | 3540 | 2020-05-06 | Colorado | 8 | 17720 | 919 |
3595 | 3595 | 2020-05-07 | Colorado | 8 | 18264 | 942 |
3650 | 3650 | 2020-05-08 | Colorado | 8 | 18719 | 958 |
3705 | 3705 | 2020-05-09 | Colorado | 8 | 19267 | 965 |
3760 | 3760 | 2020-05-10 | Colorado | 8 | 19595 | 969 |
3815 | 3815 | 2020-05-11 | Colorado | 8 | 19793 | 986 |
3870 | 3870 | 2020-05-12 | Colorado | 8 | 20103 | 1009 |
3925 | 3925 | 2020-05-13 | Colorado | 8 | 20442 | 1062 |
3980 | 3980 | 2020-05-14 | Colorado | 8 | 20813 | 1091 |
4035 | 4035 | 2020-05-15 | Colorado | 8 | 21207 | 1150 |
4090 | 4090 | 2020-05-16 | Colorado | 8 | 21604 | 1192 |
4145 | 4145 | 2020-05-17 | Colorado | 8 | 21909 | 1215 |
4200 | 4200 | 2020-05-18 | Colorado | 8 | 22174 | 1224 |
4255 | 4255 | 2020-05-19 | Colorado | 8 | 22454 | 1257 |
4310 | 4310 | 2020-05-20 | Colorado | 8 | 22769 | 1299 |
4365 | 4365 | 2020-05-21 | Colorado | 8 | 23161 | 1310 |
4420 | 4420 | 2020-05-22 | Colorado | 8 | 23456 | 1324 |
4475 | 4475 | 2020-05-23 | Colorado | 8 | 23932 | 1327 |
4530 | 4530 | 2020-05-24 | Colorado | 8 | 24140 | 1332 |
4585 | 4585 | 2020-05-25 | Colorado | 8 | 24256 | 1333 |
4640 | 4640 | 2020-05-26 | Colorado | 8 | 24553 | 1352 |
4695 | 4695 | 2020-05-27 | Colorado | 8 | 24775 | 1393 |
4750 | 4750 | 2020-05-28 | Colorado | 8 | 25116 | 1422 |
4805 | 4805 | 2020-05-29 | Colorado | 8 | 25602 | 1437 |
4860 | 4860 | 2020-05-30 | Colorado | 8 | 26084 | 1443 |
4915 | 4915 | 2020-05-31 | Colorado | 8 | 26364 | 1445 |
4970 | 4970 | 2020-06-01 | Colorado | 8 | 26563 | 1458 |
5025 | 5025 | 2020-06-02 | Colorado | 8 | 26774 | 1474 |
5080 | 5080 | 2020-06-03 | Colorado | 8 | 27046 | 1494 |
5135 | 5135 | 2020-06-04 | Colorado | 8 | 27346 | 1512 |
5190 | 5190 | 2020-06-05 | Colorado | 8 | 27601 | 1524 |
5245 | 5245 | 2020-06-06 | Colorado | 8 | 27834 | 1527 |
5300 | 5300 | 2020-06-07 | Colorado | 8 | 27987 | 1527 |
5355 | 5355 | 2020-06-08 | Colorado | 8 | 28169 | 1543 |
5410 | 5410 | 2020-06-09 | Colorado | 8 | 28333 | 1553 |
5465 | 5465 | 2020-06-10 | Colorado | 8 | 28484 | 1573 |
5520 | 5520 | 2020-06-11 | Colorado | 8 | 28632 | 1583 |
5575 | 5575 | 2020-06-12 | Colorado | 8 | 28807 | 1595 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );