ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "District of Columbia" and fips = 11001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 414 ✖
- 1141 20
- 1340 17
- 1333 16
- 0 14
- 1146 14
- 1196 14
- 1149 13
- 1331 13
- 1193 10
- 1197 8
- 642 7
- 1155 7
- 1167 7
- 1207 7
- 1321 7
- 568 6
- 616 6
- 1137 6
- 1326 6
- 611 5
- 1110 5
- 1132 5
- 1136 5
- 1150 5
- 1182 5
- 1183 5
- 1186 5
- 1309 5
- 1317 5
- 1327 5
- 581 4
- 604 4
- 605 4
- 621 4
- 641 4
- 657 4
- 1099 4
- 1106 4
- 1143 4
- 1159 4
- 1162 4
- 1165 4
- 1172 4
- 1174 4
- 1194 4
- 1199 4
- 1211 4
- 1255 4
- 1314 4
- 1335 4
- 2 3
- 587 3
- 597 3
- 619 3
- 624 3
- 631 3
- 637 3
- 646 3
- 647 3
- 660 3
- 677 3
- 1125 3
- 1176 3
- 1190 3
- 1206 3
- 1227 3
- 1267 3
- 1284 3
- 1293 3
- 1329 3
- 1 2
- 3 2
- 9 2
- 24 2
- 440 2
- 515 2
- 551 2
- 561 2
- 578 2
- 580 2
- 584 2
- 585 2
- 586 2
- 591 2
- 593 2
- 594 2
- 607 2
- 629 2
- 634 2
- 638 2
- 644 2
- 654 2
- 670 2
- 680 2
- 701 2
- 720 2
- 756 2
- 842 2
- 979 2
- 995 2
- 1019 2
- 1030 2
- 1038 2
- 1042 2
- 1050 2
- 1053 2
- 1056 2
- 1070 2
- 1081 2
- 1096 2
- 1097 2
- 1105 2
- 1115 2
- 1122 2
- 1130 2
- 1138 2
- 1144 2
- 1145 2
- 1151 2
- 1161 2
- 1163 2
- 1171 2
- 1185 2
- 1187 2
- 1195 2
- 1203 2
- 1209 2
- 1290 2
- 1304 2
- 1305 2
- 1324 2
- 4 1
- 5 1
- 11 1
- 12 1
- 15 1
- 21 1
- 22 1
- 27 1
- 32 1
- 38 1
- 47 1
- 50 1
- 52 1
- 67 1
- 72 1
- 81 1
- 86 1
- 91 1
- 96 1
- 105 1
- 112 1
- 127 1
- 139 1
- 153 1
- 165 1
- 178 1
- 185 1
- 190 1
- 205 1
- 224 1
- 231 1
- 240 1
- 251 1
- 258 1
- 264 1
- 277 1
- 285 1
- 304 1
- 311 1
- 323 1
- 328 1
- 336 1
- 350 1
- 358 1
- 368 1
- 375 1
- 383 1
- 392 1
- 400 1
- 407 1
- 412 1
- 418 1
- 427 1
- 432 1
- 445 1
- 453 1
- 460 1
- 462 1
- 466 1
- 468 1
- 470 1
- 473 1
- 475 1
- 479 1
- 483 1
- 489 1
- 491 1
- 495 1
- 499 1
- 502 1
- 506 1
- 511 1
- 520 1
- 523 1
- 527 1
- 530 1
- 531 1
- 533 1
- 535 1
- 537 1
- 541 1
- 543 1
- 546 1
- 548 1
- 550 1
- 553 1
- 554 1
- 555 1
- 557 1
- 559 1
- 564 1
- 571 1
- 574 1
- 577 1
- 579 1
- 582 1
- 583 1
- 589 1
- 590 1
- 599 1
- 600 1
- 601 1
- 602 1
- 606 1
- 608 1
- 609 1
- 615 1
- 617 1
- 620 1
- 623 1
- 626 1
- 627 1
- 628 1
- 632 1
- 636 1
- 645 1
- 650 1
- 652 1
- 655 1
- 658 1
- 665 1
- 667 1
- 669 1
- 672 1
- 673 1
- 678 1
- 685 1
- 690 1
- 692 1
- 693 1
- 695 1
- 697 1
- 704 1
- 708 1
- 709 1
- 713 1
- 715 1
- 716 1
- 725 1
- 728 1
- 730 1
- 737 1
- 742 1
- 744 1
- 751 1
- 762 1
- 768 1
- 771 1
- 775 1
- 780 1
- 786 1
- 788 1
- 792 1
- 794 1
- 797 1
- 801 1
- 806 1
- 808 1
- 809 1
- 813 1
- 817 1
- 821 1
- 825 1
- 831 1
- 847 1
- 850 1
- 857 1
- 861 1
- 863 1
- 864 1
- 867 1
- 870 1
- 872 1
- 879 1
- 888 1
- 895 1
- 902 1
- 907 1
- 909 1
- 913 1
- 916 1
- 921 1
- 926 1
- 932 1
- 940 1
- 947 1
- 952 1
- 956 1
- 961 1
- 965 1
- 973 1
- 976 1
- 980 1
- 982 1
- 985 1
- 992 1
- 993 1
- 994 1
- 998 1
- 1001 1
- 1005 1
- 1009 1
- 1010 1
- 1017 1
- 1023 1
- 1024 1
- 1027 1
- 1035 1
- 1036 1
- 1037 1
- 1040 1
- 1041 1
- 1044 1
- 1046 1
- 1047 1
- 1049 1
- 1051 1
- 1055 1
- 1059 1
- 1061 1
- 1064 1
- 1066 1
- 1069 1
- 1072 1
- 1074 1
- 1076 1
- 1077 1
- 1079 1
- 1084 1
- 1085 1
- 1088 1
- 1090 1
- 1093 1
- 1095 1
- 1098 1
- 1100 1
- 1104 1
- 1109 1
- 1113 1
- 1116 1
- 1118 1
- 1120 1
- 1124 1
- 1127 1
- 1131 1
- 1134 1
- 1135 1
- 1139 1
- 1140 1
- 1158 1
- 1160 1
- 1164 1
- 1178 1
- 1179 1
- 1180 1
- 1181 1
- 1184 1
- 1188 1
- 1191 1
- 1204 1
- 1210 1
- 1218 1
- 1220 1
- 1222 1
- 1225 1
- 1233 1
- 1237 1
- 1240 1
- 1245 1
- 1260 1
- 1263 1
- 1264 1
- 1275 1
- 1278 1
- 1280 1
- 1282 1
- 1289 1
- 1291 1
- 1311 1
- 1313 1
- 1315 1
- 1318 1
- 1319 1
state 1
fips 1
- 11001 · 798 ✖
county 1
- District of Columbia · 798 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499897 | 2499897 | 2022-05-13 | District of Columbia | District of Columbia | 11001 | 143943 | 1340 |
2496639 | 2496639 | 2022-05-12 | District of Columbia | District of Columbia | 11001 | 143943 | 1340 |
2493381 | 2493381 | 2022-05-11 | District of Columbia | District of Columbia | 11001 | 143005 | 1340 |
2490123 | 2490123 | 2022-05-10 | District of Columbia | District of Columbia | 11001 | 143005 | 1340 |
2486866 | 2486866 | 2022-05-09 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2483608 | 2483608 | 2022-05-08 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2480350 | 2480350 | 2022-05-07 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2477092 | 2477092 | 2022-05-06 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2473834 | 2473834 | 2022-05-05 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2470577 | 2470577 | 2022-05-04 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2467321 | 2467321 | 2022-05-03 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2464066 | 2464066 | 2022-05-02 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2460810 | 2460810 | 2022-05-01 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2457554 | 2457554 | 2022-04-30 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2454298 | 2454298 | 2022-04-29 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2451042 | 2451042 | 2022-04-28 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2447786 | 2447786 | 2022-04-27 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2444530 | 2444530 | 2022-04-26 | District of Columbia | District of Columbia | 11001 | 141355 | 1335 |
2441274 | 2441274 | 2022-04-25 | District of Columbia | District of Columbia | 11001 | 141355 | 1335 |
2438018 | 2438018 | 2022-04-24 | District of Columbia | District of Columbia | 11001 | 141355 | 1335 |
2434762 | 2434762 | 2022-04-23 | District of Columbia | District of Columbia | 11001 | 141355 | 1335 |
2431506 | 2431506 | 2022-04-22 | District of Columbia | District of Columbia | 11001 | 140845 | 1333 |
2428250 | 2428250 | 2022-04-21 | District of Columbia | District of Columbia | 11001 | 140845 | 1333 |
2424994 | 2424994 | 2022-04-20 | District of Columbia | District of Columbia | 11001 | 140674 | 1333 |
2421738 | 2421738 | 2022-04-19 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2418482 | 2418482 | 2022-04-18 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2415226 | 2415226 | 2022-04-17 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2411970 | 2411970 | 2022-04-16 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2408714 | 2408714 | 2022-04-15 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2405458 | 2405458 | 2022-04-14 | District of Columbia | District of Columbia | 11001 | 139160 | 1333 |
2402203 | 2402203 | 2022-04-13 | District of Columbia | District of Columbia | 11001 | 139160 | 1333 |
2398948 | 2398948 | 2022-04-12 | District of Columbia | District of Columbia | 11001 | 138939 | 1333 |
2395693 | 2395693 | 2022-04-11 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2392437 | 2392437 | 2022-04-10 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2389181 | 2389181 | 2022-04-09 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2385926 | 2385926 | 2022-04-08 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2382671 | 2382671 | 2022-04-07 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2379416 | 2379416 | 2022-04-06 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2376162 | 2376162 | 2022-04-05 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2372910 | 2372910 | 2022-04-04 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2369657 | 2369657 | 2022-04-03 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2366404 | 2366404 | 2022-04-02 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2363151 | 2363151 | 2022-04-01 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2359897 | 2359897 | 2022-03-31 | District of Columbia | District of Columbia | 11001 | 136598 | 1331 |
2356643 | 2356643 | 2022-03-30 | District of Columbia | District of Columbia | 11001 | 136598 | 1331 |
2353390 | 2353390 | 2022-03-29 | District of Columbia | District of Columbia | 11001 | 136506 | 1331 |
2350138 | 2350138 | 2022-03-28 | District of Columbia | District of Columbia | 11001 | 136322 | 1331 |
2346885 | 2346885 | 2022-03-27 | District of Columbia | District of Columbia | 11001 | 136322 | 1331 |
2343632 | 2343632 | 2022-03-26 | District of Columbia | District of Columbia | 11001 | 136322 | 1331 |
2340379 | 2340379 | 2022-03-25 | District of Columbia | District of Columbia | 11001 | 136213 | 1331 |
2337126 | 2337126 | 2022-03-24 | District of Columbia | District of Columbia | 11001 | 136062 | 1329 |
2333872 | 2333872 | 2022-03-23 | District of Columbia | District of Columbia | 11001 | 135955 | 1329 |
2330618 | 2330618 | 2022-03-22 | District of Columbia | District of Columbia | 11001 | 135884 | 1329 |
2327366 | 2327366 | 2022-03-21 | District of Columbia | District of Columbia | 11001 | 135752 | 1327 |
2324113 | 2324113 | 2022-03-20 | District of Columbia | District of Columbia | 11001 | 135752 | 1327 |
2320859 | 2320859 | 2022-03-19 | District of Columbia | District of Columbia | 11001 | 135752 | 1327 |
2317605 | 2317605 | 2022-03-18 | District of Columbia | District of Columbia | 11001 | 135681 | 1327 |
2314352 | 2314352 | 2022-03-17 | District of Columbia | District of Columbia | 11001 | 135575 | 1327 |
2311099 | 2311099 | 2022-03-16 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2307846 | 2307846 | 2022-03-15 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2304595 | 2304595 | 2022-03-14 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2301343 | 2301343 | 2022-03-13 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2298091 | 2298091 | 2022-03-12 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2294839 | 2294839 | 2022-03-11 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2291587 | 2291587 | 2022-03-10 | District of Columbia | District of Columbia | 11001 | 135086 | 1324 |
2288335 | 2288335 | 2022-03-09 | District of Columbia | District of Columbia | 11001 | 135086 | 1324 |
2285084 | 2285084 | 2022-03-08 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2281832 | 2281832 | 2022-03-07 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2278579 | 2278579 | 2022-03-06 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2275326 | 2275326 | 2022-03-05 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2272073 | 2272073 | 2022-03-04 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2268821 | 2268821 | 2022-03-03 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2265568 | 2265568 | 2022-03-02 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2262317 | 2262317 | 2022-03-01 | District of Columbia | District of Columbia | 11001 | 134623 | 1319 |
2259066 | 2259066 | 2022-02-28 | District of Columbia | District of Columbia | 11001 | 134564 | 1318 |
2255815 | 2255815 | 2022-02-27 | District of Columbia | District of Columbia | 11001 | 134326 | 1317 |
2252564 | 2252564 | 2022-02-26 | District of Columbia | District of Columbia | 11001 | 134326 | 1317 |
2249313 | 2249313 | 2022-02-25 | District of Columbia | District of Columbia | 11001 | 134326 | 1317 |
2246062 | 2246062 | 2022-02-24 | District of Columbia | District of Columbia | 11001 | 134214 | 1317 |
2242811 | 2242811 | 2022-02-23 | District of Columbia | District of Columbia | 11001 | 134114 | 1317 |
2239560 | 2239560 | 2022-02-22 | District of Columbia | District of Columbia | 11001 | 134066 | 1315 |
2236309 | 2236309 | 2022-02-21 | District of Columbia | District of Columbia | 11001 | 133697 | 1314 |
2233058 | 2233058 | 2022-02-20 | District of Columbia | District of Columbia | 11001 | 133697 | 1314 |
2229807 | 2229807 | 2022-02-19 | District of Columbia | District of Columbia | 11001 | 133697 | 1314 |
2226556 | 2226556 | 2022-02-18 | District of Columbia | District of Columbia | 11001 | 133697 | 1314 |
2223305 | 2223305 | 2022-02-17 | District of Columbia | District of Columbia | 11001 | 133587 | 1313 |
2220054 | 2220054 | 2022-02-16 | District of Columbia | District of Columbia | 11001 | 133459 | 1311 |
2216803 | 2216803 | 2022-02-15 | District of Columbia | District of Columbia | 11001 | 133339 | 1309 |
2213552 | 2213552 | 2022-02-14 | District of Columbia | District of Columbia | 11001 | 133295 | 1309 |
2210300 | 2210300 | 2022-02-13 | District of Columbia | District of Columbia | 11001 | 132820 | 1309 |
2207047 | 2207047 | 2022-02-12 | District of Columbia | District of Columbia | 11001 | 132820 | 1309 |
2203794 | 2203794 | 2022-02-11 | District of Columbia | District of Columbia | 11001 | 132820 | 1309 |
2200541 | 2200541 | 2022-02-10 | District of Columbia | District of Columbia | 11001 | 132628 | 1305 |
2197287 | 2197287 | 2022-02-09 | District of Columbia | District of Columbia | 11001 | 132384 | 1305 |
2194033 | 2194033 | 2022-02-08 | District of Columbia | District of Columbia | 11001 | 132257 | 1304 |
2190779 | 2190779 | 2022-02-07 | District of Columbia | District of Columbia | 11001 | 132170 | 1304 |
2187526 | 2187526 | 2022-02-06 | District of Columbia | District of Columbia | 11001 | 131543 | 1293 |
2184273 | 2184273 | 2022-02-05 | District of Columbia | District of Columbia | 11001 | 131543 | 1293 |
2181021 | 2181021 | 2022-02-04 | District of Columbia | District of Columbia | 11001 | 131543 | 1293 |
2177770 | 2177770 | 2022-02-03 | District of Columbia | District of Columbia | 11001 | 131284 | 1291 |
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);