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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, 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 |
---|---|---|---|---|---|---|---|
2499836 | 2499836 | 2022-05-13 | Denver | Colorado | 8031 | 177033 | 1360 |
2496578 | 2496578 | 2022-05-12 | Denver | Colorado | 8031 | 176787 | 1359 |
2493320 | 2493320 | 2022-05-11 | Denver | Colorado | 8031 | 175501 | 1359 |
2490062 | 2490062 | 2022-05-10 | Denver | Colorado | 8031 | 175374 | 1357 |
2486805 | 2486805 | 2022-05-09 | Denver | Colorado | 8031 | 175189 | 1356 |
2483547 | 2483547 | 2022-05-08 | Denver | Colorado | 8031 | 174538 | 1357 |
2480289 | 2480289 | 2022-05-07 | Denver | Colorado | 8031 | 174538 | 1357 |
2477031 | 2477031 | 2022-05-06 | Denver | Colorado | 8031 | 174538 | 1357 |
2473773 | 2473773 | 2022-05-05 | Denver | Colorado | 8031 | 174393 | 1357 |
2470516 | 2470516 | 2022-05-04 | Denver | Colorado | 8031 | 174098 | 1353 |
2467260 | 2467260 | 2022-05-03 | Denver | Colorado | 8031 | 173929 | 1352 |
2464005 | 2464005 | 2022-05-02 | Denver | Colorado | 8031 | 173706 | 1304 |
2460749 | 2460749 | 2022-05-01 | Denver | Colorado | 8031 | 173249 | 1303 |
2457493 | 2457493 | 2022-04-30 | Denver | Colorado | 8031 | 173249 | 1303 |
2454237 | 2454237 | 2022-04-29 | Denver | Colorado | 8031 | 173249 | 1303 |
2450981 | 2450981 | 2022-04-28 | Denver | Colorado | 8031 | 173065 | 1303 |
2447725 | 2447725 | 2022-04-27 | Denver | Colorado | 8031 | 172861 | 1303 |
2444469 | 2444469 | 2022-04-26 | Denver | Colorado | 8031 | 172716 | 1303 |
2441213 | 2441213 | 2022-04-25 | Denver | Colorado | 8031 | 172582 | 1302 |
2437957 | 2437957 | 2022-04-24 | Denver | Colorado | 8031 | 172140 | 1296 |
2434701 | 2434701 | 2022-04-23 | Denver | Colorado | 8031 | 172140 | 1296 |
2431445 | 2431445 | 2022-04-22 | Denver | Colorado | 8031 | 172140 | 1296 |
2428189 | 2428189 | 2022-04-21 | Denver | Colorado | 8031 | 171828 | 1292 |
2424933 | 2424933 | 2022-04-20 | Denver | Colorado | 8031 | 171562 | 1287 |
2421677 | 2421677 | 2022-04-19 | Denver | Colorado | 8031 | 171307 | 1287 |
2418421 | 2418421 | 2022-04-18 | Denver | Colorado | 8031 | 171071 | 1287 |
2415165 | 2415165 | 2022-04-17 | Denver | Colorado | 8031 | 170683 | 1287 |
2411909 | 2411909 | 2022-04-16 | Denver | Colorado | 8031 | 170683 | 1287 |
2408653 | 2408653 | 2022-04-15 | Denver | Colorado | 8031 | 170683 | 1287 |
2405397 | 2405397 | 2022-04-14 | Denver | Colorado | 8031 | 170388 | 1284 |
2402142 | 2402142 | 2022-04-13 | Denver | Colorado | 8031 | 170150 | 1284 |
2398887 | 2398887 | 2022-04-12 | Denver | Colorado | 8031 | 169839 | 1283 |
2395632 | 2395632 | 2022-04-11 | Denver | Colorado | 8031 | 169686 | 1287 |
2392376 | 2392376 | 2022-04-10 | Denver | Colorado | 8031 | 169304 | 1283 |
2389120 | 2389120 | 2022-04-09 | Denver | Colorado | 8031 | 169304 | 1283 |
2385865 | 2385865 | 2022-04-08 | Denver | Colorado | 8031 | 169304 | 1283 |
2382610 | 2382610 | 2022-04-07 | Denver | Colorado | 8031 | 169056 | 1283 |
2379355 | 2379355 | 2022-04-06 | Denver | Colorado | 8031 | 168829 | 1285 |
2376101 | 2376101 | 2022-04-05 | Denver | Colorado | 8031 | 168699 | 1285 |
2372849 | 2372849 | 2022-04-04 | Denver | Colorado | 8031 | 168564 | 1285 |
2369596 | 2369596 | 2022-04-03 | Denver | Colorado | 8031 | 168288 | 1285 |
2366343 | 2366343 | 2022-04-02 | Denver | Colorado | 8031 | 168288 | 1285 |
2363090 | 2363090 | 2022-04-01 | Denver | Colorado | 8031 | 168288 | 1285 |
2359836 | 2359836 | 2022-03-31 | Denver | Colorado | 8031 | 168118 | 1285 |
2356582 | 2356582 | 2022-03-30 | Denver | Colorado | 8031 | 167957 | 1285 |
2353329 | 2353329 | 2022-03-29 | Denver | Colorado | 8031 | 167847 | 1285 |
2350077 | 2350077 | 2022-03-28 | Denver | Colorado | 8031 | 167679 | 1284 |
2346824 | 2346824 | 2022-03-27 | Denver | Colorado | 8031 | 167406 | 1283 |
2343571 | 2343571 | 2022-03-26 | Denver | Colorado | 8031 | 167406 | 1283 |
2340318 | 2340318 | 2022-03-25 | Denver | Colorado | 8031 | 167406 | 1283 |
2337065 | 2337065 | 2022-03-24 | Denver | Colorado | 8031 | 167062 | 1283 |
2333811 | 2333811 | 2022-03-23 | Denver | Colorado | 8031 | 166945 | 1283 |
2330557 | 2330557 | 2022-03-22 | Denver | Colorado | 8031 | 166807 | 1282 |
2327305 | 2327305 | 2022-03-21 | Denver | Colorado | 8031 | 166633 | 1282 |
2324052 | 2324052 | 2022-03-20 | Denver | Colorado | 8031 | 166275 | 1279 |
2320798 | 2320798 | 2022-03-19 | Denver | Colorado | 8031 | 166275 | 1279 |
2317544 | 2317544 | 2022-03-18 | Denver | Colorado | 8031 | 166275 | 1279 |
2314291 | 2314291 | 2022-03-17 | Denver | Colorado | 8031 | 166275 | 1279 |
2311038 | 2311038 | 2022-03-16 | Denver | Colorado | 8031 | 166147 | 1278 |
2307785 | 2307785 | 2022-03-15 | Denver | Colorado | 8031 | 166005 | 1278 |
2304534 | 2304534 | 2022-03-14 | Denver | Colorado | 8031 | 165862 | 1278 |
2301282 | 2301282 | 2022-03-13 | Denver | Colorado | 8031 | 165670 | 1275 |
2298030 | 2298030 | 2022-03-12 | Denver | Colorado | 8031 | 165670 | 1275 |
2294778 | 2294778 | 2022-03-11 | Denver | Colorado | 8031 | 165670 | 1275 |
2291526 | 2291526 | 2022-03-10 | Denver | Colorado | 8031 | 165532 | 1275 |
2288274 | 2288274 | 2022-03-09 | Denver | Colorado | 8031 | 165360 | 1275 |
2285023 | 2285023 | 2022-03-08 | Denver | Colorado | 8031 | 165227 | 1275 |
2281771 | 2281771 | 2022-03-07 | Denver | Colorado | 8031 | 165157 | 1274 |
2278518 | 2278518 | 2022-03-06 | Denver | Colorado | 8031 | 164919 | 1272 |
2275265 | 2275265 | 2022-03-05 | Denver | Colorado | 8031 | 164919 | 1272 |
2272012 | 2272012 | 2022-03-04 | Denver | Colorado | 8031 | 164919 | 1272 |
2268760 | 2268760 | 2022-03-03 | Denver | Colorado | 8031 | 164817 | 1273 |
2265507 | 2265507 | 2022-03-02 | Denver | Colorado | 8031 | 164792 | 1273 |
2262256 | 2262256 | 2022-03-01 | Denver | Colorado | 8031 | 164683 | 1271 |
2259005 | 2259005 | 2022-02-28 | Denver | Colorado | 8031 | 164575 | 1270 |
2255754 | 2255754 | 2022-02-27 | Denver | Colorado | 8031 | 164275 | 1267 |
2252503 | 2252503 | 2022-02-26 | Denver | Colorado | 8031 | 164275 | 1267 |
2249252 | 2249252 | 2022-02-25 | Denver | Colorado | 8031 | 164275 | 1267 |
2246001 | 2246001 | 2022-02-24 | Denver | Colorado | 8031 | 164171 | 1266 |
2242750 | 2242750 | 2022-02-23 | Denver | Colorado | 8031 | 164032 | 1265 |
2239499 | 2239499 | 2022-02-22 | Denver | Colorado | 8031 | 163872 | 1261 |
2236248 | 2236248 | 2022-02-21 | Denver | Colorado | 8031 | 163725 | 1259 |
2232997 | 2232997 | 2022-02-20 | Denver | Colorado | 8031 | 163261 | 1258 |
2229746 | 2229746 | 2022-02-19 | Denver | Colorado | 8031 | 163261 | 1258 |
2226495 | 2226495 | 2022-02-18 | Denver | Colorado | 8031 | 163261 | 1258 |
2223244 | 2223244 | 2022-02-17 | Denver | Colorado | 8031 | 163016 | 1258 |
2219993 | 2219993 | 2022-02-16 | Denver | Colorado | 8031 | 162792 | 1258 |
2216742 | 2216742 | 2022-02-15 | Denver | Colorado | 8031 | 162646 | 1256 |
2213491 | 2213491 | 2022-02-14 | Denver | Colorado | 8031 | 162441 | 1254 |
2210239 | 2210239 | 2022-02-13 | Denver | Colorado | 8031 | 161991 | 1250 |
2206986 | 2206986 | 2022-02-12 | Denver | Colorado | 8031 | 161991 | 1250 |
2203733 | 2203733 | 2022-02-11 | Denver | Colorado | 8031 | 161991 | 1250 |
2200480 | 2200480 | 2022-02-10 | Denver | Colorado | 8031 | 161761 | 1248 |
2197226 | 2197226 | 2022-02-09 | Denver | Colorado | 8031 | 161473 | 1244 |
2193972 | 2193972 | 2022-02-08 | Denver | Colorado | 8031 | 161196 | 1222 |
2190718 | 2190718 | 2022-02-07 | Denver | Colorado | 8031 | 160912 | 1221 |
2187465 | 2187465 | 2022-02-06 | Denver | Colorado | 8031 | 160195 | 1196 |
2184212 | 2184212 | 2022-02-05 | Denver | Colorado | 8031 | 160195 | 1196 |
2180960 | 2180960 | 2022-02-04 | Denver | Colorado | 8031 | 160195 | 1196 |
2177709 | 2177709 | 2022-02-03 | Denver | Colorado | 8031 | 159856 | 1197 |
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);