ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 8031 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 392 ✖
- 0 19
- 434 14
- 426 10
- 1283 10
- 848 9
- 1285 9
- 440 8
- 793 8
- 447 7
- 449 7
- 450 7
- 459 7
- 1287 7
- 441 6
- 766 6
- 769 6
- 786 6
- 852 6
- 1275 6
- 1303 6
- 398 5
- 420 5
- 468 5
- 482 5
- 806 5
- 808 5
- 843 5
- 845 5
- 851 5
- 858 5
- 867 5
- 1258 5
- 1357 5
- 382 4
- 394 4
- 438 4
- 720 4
- 752 4
- 825 4
- 829 4
- 834 4
- 849 4
- 877 4
- 899 4
- 1002 4
- 1022 4
- 1085 4
- 1106 4
- 1279 4
- 3 3
- 299 3
- 360 3
- 367 3
- 369 3
- 381 3
- 405 3
- 417 3
- 418 3
- 429 3
- 437 3
- 654 3
- 681 3
- 728 3
- 744 3
- 768 3
- 772 3
- 779 3
- 789 3
- 791 3
- 792 3
- 819 3
- 820 3
- 828 3
- 842 3
- 855 3
- 863 3
- 874 3
- 879 3
- 888 3
- 908 3
- 919 3
- 923 3
- 929 3
- 942 3
- 957 3
- 971 3
- 983 3
- 1047 3
- 1058 3
- 1099 3
- 1117 3
- 1122 3
- 1141 3
- 1196 3
- 1250 3
- 1267 3
- 1272 3
- 1278 3
- 1284 3
- 1296 3
- 5 2
- 14 2
- 46 2
- 132 2
- 166 2
- 327 2
- 339 2
- 364 2
- 366 2
- 374 2
- 403 2
- 411 2
- 413 2
- 419 2
- 462 2
- 491 2
- 547 2
- 582 2
- 612 2
- 642 2
- 658 2
- 674 2
- 708 2
- 743 2
- 745 2
- 746 2
- 748 2
- 751 2
- 765 2
- 770 2
- 775 2
- 778 2
- 787 2
- 794 2
- 798 2
- 800 2
- 816 2
- 817 2
- 821 2
- 824 2
- 826 2
- 838 2
- 841 2
- 847 2
- 857 2
- 862 2
- 870 2
- 886 2
- 906 2
- 909 2
- 920 2
- 925 2
- 944 2
- 1012 2
- 1093 2
- 1127 2
- 1166 2
- 1176 2
- 1273 2
- 1282 2
- 1359 2
- 6 1
- 7 1
- 8 1
- 11 1
- 15 1
- 16 1
- 31 1
- 33 1
- 38 1
- 42 1
- 51 1
- 56 1
- 61 1
- 63 1
- 66 1
- 74 1
- 75 1
- 83 1
- 91 1
- 96 1
- 98 1
- 128 1
- 135 1
- 145 1
- 150 1
- 154 1
- 163 1
- 164 1
- 188 1
- 195 1
- 199 1
- 202 1
- 205 1
- 206 1
- 212 1
- 214 1
- 233 1
- 237 1
- 248 1
- 261 1
- 265 1
- 272 1
- 285 1
- 294 1
- 296 1
- 298 1
- 301 1
- 313 1
- 324 1
- 326 1
- 329 1
- 332 1
- 334 1
- 336 1
- 338 1
- 348 1
- 349 1
- 357 1
- 358 1
- 363 1
- 375 1
- 376 1
- 383 1
- 386 1
- 387 1
- 395 1
- 397 1
- 399 1
- 402 1
- 407 1
- 412 1
- 416 1
- 428 1
- 473 1
- 481 1
- 492 1
- 493 1
- 494 1
- 502 1
- 506 1
- 507 1
- 510 1
- 515 1
- 521 1
- 523 1
- 526 1
- 527 1
- 531 1
- 539 1
- 552 1
- 566 1
- 567 1
- 571 1
- 592 1
- 593 1
- 623 1
- 626 1
- 635 1
- 647 1
- 648 1
- 649 1
- 650 1
- 662 1
- 667 1
- 672 1
- 679 1
- 684 1
- 694 1
- 699 1
- 706 1
- 707 1
- 713 1
- 715 1
- 721 1
- 725 1
- 732 1
- 733 1
- 736 1
- 738 1
- 739 1
- 741 1
- 756 1
- 760 1
- 762 1
- 767 1
- 771 1
- 780 1
- 782 1
- 783 1
- 785 1
- 790 1
- 795 1
- 797 1
- 805 1
- 807 1
- 812 1
- 813 1
- 814 1
- 823 1
- 831 1
- 833 1
- 836 1
- 837 1
- 839 1
- 840 1
- 844 1
- 846 1
- 850 1
- 859 1
- 860 1
- 865 1
- 866 1
- 868 1
- 872 1
- 882 1
- 884 1
- 892 1
- 895 1
- 896 1
- 901 1
- 905 1
- 914 1
- 915 1
- 921 1
- 922 1
- 926 1
- 927 1
- 933 1
- 935 1
- 938 1
- 940 1
- 946 1
- 952 1
- 963 1
- 966 1
- 967 1
- 969 1
- 974 1
- 976 1
- 977 1
- 980 1
- 993 1
- 995 1
- 1004 1
- 1018 1
- 1029 1
- 1033 1
- 1035 1
- 1038 1
- 1048 1
- 1052 1
- 1055 1
- 1056 1
- 1065 1
- 1076 1
- 1079 1
- 1083 1
- 1096 1
- 1101 1
- 1102 1
- 1103 1
- 1108 1
- 1136 1
- 1139 1
- 1145 1
- 1158 1
- 1162 1
- 1185 1
- 1194 1
- 1195 1
- 1197 1
- 1221 1
- 1222 1
- 1244 1
- 1248 1
- 1254 1
- 1256 1
- 1259 1
- 1261 1
- 1265 1
- 1266 1
- 1270 1
- 1271 1
- 1274 1
- 1292 1
- 1302 1
- 1304 1
- 1352 1
- 1353 1
- 1356 1
- 1360 1
state 1
- Colorado 799
fips 1
- 8031 · 799 ✖
county 1
- Denver 799
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
600 | 600 | 2020-03-06 | Denver | Colorado | 8031 | 2 | 0 |
678 | 678 | 2020-03-07 | Denver | Colorado | 8031 | 2 | 0 |
773 | 773 | 2020-03-08 | Denver | Colorado | 8031 | 2 | 0 |
889 | 889 | 2020-03-09 | Denver | Colorado | 8031 | 3 | 0 |
1023 | 1023 | 2020-03-10 | Denver | Colorado | 8031 | 4 | 0 |
1190 | 1190 | 2020-03-11 | Denver | Colorado | 8031 | 6 | 0 |
1398 | 1398 | 2020-03-12 | Denver | Colorado | 8031 | 9 | 0 |
1660 | 1660 | 2020-03-13 | Denver | Colorado | 8031 | 17 | 0 |
1979 | 1979 | 2020-03-14 | Denver | Colorado | 8031 | 23 | 0 |
2360 | 2360 | 2020-03-15 | Denver | Colorado | 8031 | 28 | 0 |
2795 | 2795 | 2020-03-16 | Denver | Colorado | 8031 | 28 | 0 |
3277 | 3277 | 2020-03-17 | Denver | Colorado | 8031 | 41 | 0 |
3831 | 3831 | 2020-03-18 | Denver | Colorado | 8031 | 45 | 0 |
4492 | 4492 | 2020-03-19 | Denver | Colorado | 8031 | 61 | 0 |
5268 | 5268 | 2020-03-20 | Denver | Colorado | 8031 | 79 | 0 |
6192 | 6192 | 2020-03-21 | Denver | Colorado | 8031 | 98 | 0 |
7227 | 7227 | 2020-03-22 | Denver | Colorado | 8031 | 125 | 0 |
8370 | 8370 | 2020-03-23 | Denver | Colorado | 8031 | 148 | 0 |
9613 | 9613 | 2020-03-24 | Denver | Colorado | 8031 | 176 | 0 |
10986 | 10986 | 2020-03-25 | Denver | Colorado | 8031 | 214 | 3 |
12531 | 12531 | 2020-03-26 | Denver | Colorado | 8031 | 262 | 3 |
14199 | 14199 | 2020-03-27 | Denver | Colorado | 8031 | 312 | 3 |
15982 | 15982 | 2020-03-28 | Denver | Colorado | 8031 | 367 | 5 |
17872 | 17872 | 2020-03-29 | Denver | Colorado | 8031 | 408 | 5 |
19850 | 19850 | 2020-03-30 | Denver | Colorado | 8031 | 465 | 6 |
21925 | 21925 | 2020-03-31 | Denver | Colorado | 8031 | 539 | 7 |
24084 | 24084 | 2020-04-01 | Denver | Colorado | 8031 | 586 | 8 |
26314 | 26314 | 2020-04-02 | Denver | Colorado | 8031 | 643 | 11 |
28614 | 28614 | 2020-04-03 | Denver | Colorado | 8031 | 716 | 14 |
30971 | 30971 | 2020-04-04 | Denver | Colorado | 8031 | 769 | 14 |
35822 | 35822 | 2020-04-06 | Denver | Colorado | 8031 | 847 | 15 |
33377 | 33377 | 2020-04-05 | Denver | Colorado | 8031 | 825 | 16 |
38312 | 38312 | 2020-04-07 | Denver | Colorado | 8031 | 884 | 31 |
40855 | 40855 | 2020-04-08 | Denver | Colorado | 8031 | 927 | 33 |
43427 | 43427 | 2020-04-09 | Denver | Colorado | 8031 | 1031 | 38 |
46027 | 46027 | 2020-04-10 | Denver | Colorado | 8031 | 1113 | 42 |
48657 | 48657 | 2020-04-11 | Denver | Colorado | 8031 | 1182 | 46 |
51319 | 51319 | 2020-04-12 | Denver | Colorado | 8031 | 1247 | 46 |
53998 | 53998 | 2020-04-13 | Denver | Colorado | 8031 | 1346 | 51 |
56690 | 56690 | 2020-04-14 | Denver | Colorado | 8031 | 1402 | 56 |
59398 | 59398 | 2020-04-15 | Denver | Colorado | 8031 | 1468 | 61 |
62117 | 62117 | 2020-04-16 | Denver | Colorado | 8031 | 1549 | 63 |
64850 | 64850 | 2020-04-17 | Denver | Colorado | 8031 | 1636 | 66 |
67598 | 67598 | 2020-04-18 | Denver | Colorado | 8031 | 1723 | 74 |
70360 | 70360 | 2020-04-19 | Denver | Colorado | 8031 | 1784 | 75 |
73129 | 73129 | 2020-04-20 | Denver | Colorado | 8031 | 1880 | 83 |
75905 | 75905 | 2020-04-21 | Denver | Colorado | 8031 | 2004 | 91 |
78689 | 78689 | 2020-04-22 | Denver | Colorado | 8031 | 2071 | 96 |
81483 | 81483 | 2020-04-23 | Denver | Colorado | 8031 | 2172 | 98 |
84283 | 84283 | 2020-04-24 | Denver | Colorado | 8031 | 2385 | 128 |
87091 | 87091 | 2020-04-25 | Denver | Colorado | 8031 | 2487 | 132 |
89908 | 89908 | 2020-04-26 | Denver | Colorado | 8031 | 2583 | 132 |
92726 | 92726 | 2020-04-27 | Denver | Colorado | 8031 | 2682 | 135 |
95558 | 95558 | 2020-04-28 | Denver | Colorado | 8031 | 2791 | 145 |
98403 | 98403 | 2020-04-29 | Denver | Colorado | 8031 | 2890 | 150 |
101253 | 101253 | 2020-04-30 | Denver | Colorado | 8031 | 3001 | 154 |
104108 | 104108 | 2020-05-01 | Denver | Colorado | 8031 | 3092 | 163 |
106973 | 106973 | 2020-05-02 | Denver | Colorado | 8031 | 3222 | 164 |
109842 | 109842 | 2020-05-03 | Denver | Colorado | 8031 | 3345 | 166 |
112717 | 112717 | 2020-05-04 | Denver | Colorado | 8031 | 3428 | 166 |
115600 | 115600 | 2020-05-05 | Denver | Colorado | 8031 | 3546 | 188 |
118559 | 118559 | 2020-05-06 | Denver | Colorado | 8031 | 3674 | 195 |
121528 | 121528 | 2020-05-07 | Denver | Colorado | 8031 | 3799 | 199 |
124508 | 124508 | 2020-05-08 | Denver | Colorado | 8031 | 3892 | 202 |
127494 | 127494 | 2020-05-09 | Denver | Colorado | 8031 | 4001 | 205 |
130485 | 130485 | 2020-05-10 | Denver | Colorado | 8031 | 4070 | 206 |
133476 | 133476 | 2020-05-11 | Denver | Colorado | 8031 | 4118 | 212 |
136465 | 136465 | 2020-05-12 | Denver | Colorado | 8031 | 4187 | 214 |
139456 | 139456 | 2020-05-13 | Denver | Colorado | 8031 | 4254 | 233 |
142452 | 142452 | 2020-05-14 | Denver | Colorado | 8031 | 4359 | 237 |
145452 | 145452 | 2020-05-15 | Denver | Colorado | 8031 | 4452 | 248 |
148455 | 148455 | 2020-05-16 | Denver | Colorado | 8031 | 4548 | 261 |
151464 | 151464 | 2020-05-17 | Denver | Colorado | 8031 | 4656 | 265 |
154476 | 154476 | 2020-05-18 | Denver | Colorado | 8031 | 4720 | 272 |
157492 | 157492 | 2020-05-19 | Denver | Colorado | 8031 | 4790 | 285 |
160518 | 160518 | 2020-05-20 | Denver | Colorado | 8031 | 4858 | 294 |
163546 | 163546 | 2020-05-21 | Denver | Colorado | 8031 | 4948 | 296 |
175701 | 175701 | 2020-05-25 | Denver | Colorado | 8031 | 5216 | 298 |
166579 | 166579 | 2020-05-22 | Denver | Colorado | 8031 | 5056 | 299 |
169616 | 169616 | 2020-05-23 | Denver | Colorado | 8031 | 5151 | 299 |
172657 | 172657 | 2020-05-24 | Denver | Colorado | 8031 | 5173 | 299 |
178745 | 178745 | 2020-05-26 | Denver | Colorado | 8031 | 5269 | 301 |
181789 | 181789 | 2020-05-27 | Denver | Colorado | 8031 | 5316 | 313 |
184843 | 184843 | 2020-05-28 | Denver | Colorado | 8031 | 5434 | 324 |
187899 | 187899 | 2020-05-29 | Denver | Colorado | 8031 | 5569 | 326 |
190964 | 190964 | 2020-05-30 | Denver | Colorado | 8031 | 5690 | 327 |
194031 | 194031 | 2020-05-31 | Denver | Colorado | 8031 | 5775 | 327 |
197101 | 197101 | 2020-06-01 | Denver | Colorado | 8031 | 5802 | 329 |
200174 | 200174 | 2020-06-02 | Denver | Colorado | 8031 | 5854 | 332 |
203250 | 203250 | 2020-06-03 | Denver | Colorado | 8031 | 5917 | 334 |
206330 | 206330 | 2020-06-04 | Denver | Colorado | 8031 | 5977 | 336 |
209411 | 209411 | 2020-06-05 | Denver | Colorado | 8031 | 6041 | 338 |
212496 | 212496 | 2020-06-06 | Denver | Colorado | 8031 | 6079 | 339 |
215583 | 215583 | 2020-06-07 | Denver | Colorado | 8031 | 6106 | 339 |
218674 | 218674 | 2020-06-08 | Denver | Colorado | 8031 | 6138 | 348 |
221769 | 221769 | 2020-06-09 | Denver | Colorado | 8031 | 6176 | 349 |
224864 | 224864 | 2020-06-10 | Denver | Colorado | 8031 | 6204 | 357 |
227966 | 227966 | 2020-06-11 | Denver | Colorado | 8031 | 6232 | 358 |
231069 | 231069 | 2020-06-12 | Denver | Colorado | 8031 | 6257 | 360 |
234175 | 234175 | 2020-06-13 | Denver | Colorado | 8031 | 6301 | 360 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);