ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 51036 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 387 ✖
- 507 17
- 27 15
- 1 14
- 41 11
- 500 11
- 83 9
- 501 9
- 45 8
- 502 8
- 522 8
- 653 8
- 13 7
- 39 7
- 69 7
- 524 7
- 1153 7
- 4 6
- 21 6
- 28 6
- 1148 6
- 9 5
- 11 5
- 17 5
- 66 5
- 84 5
- 509 5
- 546 5
- 674 5
- 1141 5
- 1143 5
- 1175 5
- 37 4
- 51 4
- 53 4
- 70 4
- 76 4
- 87 4
- 494 4
- 508 4
- 512 4
- 622 4
- 694 4
- 695 4
- 764 4
- 1112 4
- 1134 4
- 1137 4
- 1140 4
- 1147 4
- 12 3
- 22 3
- 40 3
- 42 3
- 43 3
- 50 3
- 52 3
- 86 3
- 95 3
- 102 3
- 141 3
- 145 3
- 162 3
- 466 3
- 498 3
- 510 3
- 511 3
- 513 3
- 529 3
- 531 3
- 540 3
- 574 3
- 593 3
- 604 3
- 632 3
- 639 3
- 649 3
- 670 3
- 688 3
- 698 3
- 715 3
- 731 3
- 752 3
- 775 3
- 791 3
- 829 3
- 888 3
- 957 3
- 1015 3
- 1090 3
- 1123 3
- 1154 3
- 1155 3
- 1157 3
- 1158 3
- 1160 3
- 1170 3
- 5 2
- 24 2
- 25 2
- 34 2
- 56 2
- 81 2
- 88 2
- 97 2
- 99 2
- 106 2
- 107 2
- 114 2
- 121 2
- 125 2
- 134 2
- 137 2
- 150 2
- 151 2
- 186 2
- 195 2
- 270 2
- 276 2
- 345 2
- 392 2
- 397 2
- 398 2
- 413 2
- 419 2
- 424 2
- 426 2
- 438 2
- 439 2
- 457 2
- 458 2
- 487 2
- 492 2
- 499 2
- 505 2
- 521 2
- 523 2
- 543 2
- 581 2
- 597 2
- 675 2
- 690 2
- 769 2
- 1120 2
- 1149 2
- 1151 2
- 1156 2
- 1189 2
- 2 1
- 7 1
- 8 1
- 10 1
- 19 1
- 23 1
- 29 1
- 30 1
- 32 1
- 33 1
- 35 1
- 46 1
- 47 1
- 49 1
- 54 1
- 55 1
- 57 1
- 58 1
- 60 1
- 61 1
- 65 1
- 71 1
- 73 1
- 77 1
- 79 1
- 82 1
- 85 1
- 90 1
- 91 1
- 94 1
- 96 1
- 98 1
- 100 1
- 101 1
- 103 1
- 104 1
- 105 1
- 109 1
- 110 1
- 111 1
- 112 1
- 113 1
- 116 1
- 117 1
- 127 1
- 135 1
- 139 1
- 142 1
- 146 1
- 149 1
- 153 1
- 154 1
- 156 1
- 159 1
- 161 1
- 163 1
- 165 1
- 166 1
- 169 1
- 172 1
- 180 1
- 181 1
- 183 1
- 184 1
- 189 1
- 193 1
- 201 1
- 202 1
- 203 1
- 212 1
- 220 1
- 227 1
- 230 1
- 232 1
- 244 1
- 252 1
- 274 1
- 290 1
- 300 1
- 307 1
- 311 1
- 313 1
- 316 1
- 319 1
- 321 1
- 326 1
- 328 1
- 333 1
- 335 1
- 338 1
- 340 1
- 342 1
- 348 1
- 351 1
- 357 1
- 359 1
- 362 1
- 365 1
- 366 1
- 369 1
- 371 1
- 373 1
- 376 1
- 377 1
- 378 1
- 382 1
- 385 1
- 387 1
- 388 1
- 389 1
- 391 1
- 393 1
- 396 1
- 401 1
- 402 1
- 408 1
- 410 1
- 412 1
- 414 1
- 416 1
- 417 1
- 421 1
- 422 1
- 427 1
- 431 1
- 435 1
- 441 1
- 445 1
- 448 1
- 449 1
- 451 1
- 453 1
- 459 1
- 460 1
- 461 1
- 469 1
- 470 1
- 474 1
- 478 1
- 479 1
- 481 1
- 485 1
- 489 1
- 491 1
- 493 1
- 497 1
- 527 1
- 533 1
- 535 1
- 537 1
- 539 1
- 553 1
- 559 1
- 567 1
- 573 1
- 586 1
- 592 1
- 596 1
- 600 1
- 610 1
- 614 1
- 617 1
- 637 1
- 641 1
- 642 1
- 644 1
- 645 1
- 660 1
- 662 1
- 669 1
- 681 1
- 683 1
- 685 1
- 686 1
- 693 1
- 705 1
- 706 1
- 709 1
- 710 1
- 720 1
- 727 1
- 729 1
- 730 1
- 741 1
- 742 1
- 745 1
- 749 1
- 755 1
- 759 1
- 761 1
- 770 1
- 772 1
- 783 1
- 787 1
- 788 1
- 789 1
- 797 1
- 803 1
- 808 1
- 817 1
- 856 1
- 862 1
- 868 1
- 880 1
- 926 1
- 930 1
- 941 1
- 949 1
- 984 1
- 988 1
- 994 1
- 1001 1
- 1028 1
- 1043 1
- 1058 1
- 1079 1
- 1105 1
- 1108 1
- 1109 1
- 1119 1
- 1121 1
- 1127 1
- 1128 1
- 1131 1
- 1133 1
- 1135 1
- 1136 1
- 1142 1
- 1145 1
- 1146 1
- 1159 1
- 1162 1
- 1163 1
- 1166 1
- 1168 1
- 1171 1
- 1172 1
- 1180 1
- 1186 1
- 1191 1
state 1
- Virginia 787
fips 1
- 51036 · 787 ✖
county 1
- Charles City 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502531 | 2502531 | 2022-05-13 | Charles City | Virginia | 51036 | 1191 | 27 |
2499273 | 2499273 | 2022-05-12 | Charles City | Virginia | 51036 | 1189 | 27 |
2496015 | 2496015 | 2022-05-11 | Charles City | Virginia | 51036 | 1189 | 27 |
2492757 | 2492757 | 2022-05-10 | Charles City | Virginia | 51036 | 1186 | 27 |
2489499 | 2489499 | 2022-05-09 | Charles City | Virginia | 51036 | 1180 | 27 |
2486242 | 2486242 | 2022-05-08 | Charles City | Virginia | 51036 | 1175 | 27 |
2482984 | 2482984 | 2022-05-07 | Charles City | Virginia | 51036 | 1175 | 27 |
2479726 | 2479726 | 2022-05-06 | Charles City | Virginia | 51036 | 1175 | 27 |
2476468 | 2476468 | 2022-05-05 | Charles City | Virginia | 51036 | 1175 | 27 |
2473210 | 2473210 | 2022-05-04 | Charles City | Virginia | 51036 | 1175 | 27 |
2469954 | 2469954 | 2022-05-03 | Charles City | Virginia | 51036 | 1172 | 27 |
2466698 | 2466698 | 2022-05-02 | Charles City | Virginia | 51036 | 1171 | 27 |
2463443 | 2463443 | 2022-05-01 | Charles City | Virginia | 51036 | 1170 | 27 |
2460187 | 2460187 | 2022-04-30 | Charles City | Virginia | 51036 | 1170 | 27 |
2456931 | 2456931 | 2022-04-29 | Charles City | Virginia | 51036 | 1170 | 27 |
2453675 | 2453675 | 2022-04-28 | Charles City | Virginia | 51036 | 1168 | 27 |
2450419 | 2450419 | 2022-04-27 | Charles City | Virginia | 51036 | 1166 | 27 |
2447162 | 2447162 | 2022-04-26 | Charles City | Virginia | 51036 | 1163 | 27 |
2443907 | 2443907 | 2022-04-25 | Charles City | Virginia | 51036 | 1162 | 27 |
2440651 | 2440651 | 2022-04-24 | Charles City | Virginia | 51036 | 1160 | 27 |
2437395 | 2437395 | 2022-04-23 | Charles City | Virginia | 51036 | 1160 | 27 |
2434139 | 2434139 | 2022-04-22 | Charles City | Virginia | 51036 | 1160 | 27 |
2430883 | 2430883 | 2022-04-21 | Charles City | Virginia | 51036 | 1159 | 27 |
2427627 | 2427627 | 2022-04-20 | Charles City | Virginia | 51036 | 1158 | 27 |
2424371 | 2424371 | 2022-04-19 | Charles City | Virginia | 51036 | 1158 | 27 |
2421115 | 2421115 | 2022-04-18 | Charles City | Virginia | 51036 | 1158 | 27 |
2417859 | 2417859 | 2022-04-17 | Charles City | Virginia | 51036 | 1157 | 27 |
2414603 | 2414603 | 2022-04-16 | Charles City | Virginia | 51036 | 1157 | 27 |
2411347 | 2411347 | 2022-04-15 | Charles City | Virginia | 51036 | 1157 | 27 |
2408091 | 2408091 | 2022-04-14 | Charles City | Virginia | 51036 | 1156 | 27 |
2404835 | 2404835 | 2022-04-13 | Charles City | Virginia | 51036 | 1156 | 27 |
2401580 | 2401580 | 2022-04-12 | Charles City | Virginia | 51036 | 1155 | 27 |
2398325 | 2398325 | 2022-04-11 | Charles City | Virginia | 51036 | 1155 | 27 |
2395070 | 2395070 | 2022-04-10 | Charles City | Virginia | 51036 | 1153 | 27 |
2391814 | 2391814 | 2022-04-09 | Charles City | Virginia | 51036 | 1153 | 27 |
2388558 | 2388558 | 2022-04-08 | Charles City | Virginia | 51036 | 1153 | 27 |
2385303 | 2385303 | 2022-04-07 | Charles City | Virginia | 51036 | 1153 | 27 |
2382048 | 2382048 | 2022-04-06 | Charles City | Virginia | 51036 | 1153 | 27 |
2378793 | 2378793 | 2022-04-05 | Charles City | Virginia | 51036 | 1153 | 27 |
2375539 | 2375539 | 2022-04-04 | Charles City | Virginia | 51036 | 1155 | 27 |
2372287 | 2372287 | 2022-04-03 | Charles City | Virginia | 51036 | 1154 | 27 |
2369034 | 2369034 | 2022-04-02 | Charles City | Virginia | 51036 | 1154 | 27 |
2365781 | 2365781 | 2022-04-01 | Charles City | Virginia | 51036 | 1154 | 27 |
2362528 | 2362528 | 2022-03-31 | Charles City | Virginia | 51036 | 1153 | 27 |
2359274 | 2359274 | 2022-03-30 | Charles City | Virginia | 51036 | 1151 | 27 |
2356020 | 2356020 | 2022-03-29 | Charles City | Virginia | 51036 | 1151 | 27 |
2352767 | 2352767 | 2022-03-28 | Charles City | Virginia | 51036 | 1148 | 27 |
2349515 | 2349515 | 2022-03-27 | Charles City | Virginia | 51036 | 1148 | 27 |
2346262 | 2346262 | 2022-03-26 | Charles City | Virginia | 51036 | 1148 | 27 |
2343009 | 2343009 | 2022-03-25 | Charles City | Virginia | 51036 | 1148 | 27 |
2339756 | 2339756 | 2022-03-24 | Charles City | Virginia | 51036 | 1148 | 27 |
2336502 | 2336502 | 2022-03-23 | Charles City | Virginia | 51036 | 1148 | 27 |
2333248 | 2333248 | 2022-03-22 | Charles City | Virginia | 51036 | 1149 | 27 |
2329995 | 2329995 | 2022-03-21 | Charles City | Virginia | 51036 | 1149 | 27 |
2326743 | 2326743 | 2022-03-20 | Charles City | Virginia | 51036 | 1147 | 27 |
2323490 | 2323490 | 2022-03-19 | Charles City | Virginia | 51036 | 1147 | 27 |
2320236 | 2320236 | 2022-03-18 | Charles City | Virginia | 51036 | 1147 | 27 |
2316982 | 2316982 | 2022-03-17 | Charles City | Virginia | 51036 | 1147 | 27 |
2313729 | 2313729 | 2022-03-16 | Charles City | Virginia | 51036 | 1145 | 27 |
2310476 | 2310476 | 2022-03-15 | Charles City | Virginia | 51036 | 1146 | 27 |
2307223 | 2307223 | 2022-03-14 | Charles City | Virginia | 51036 | 1143 | 27 |
2303972 | 2303972 | 2022-03-13 | Charles City | Virginia | 51036 | 1143 | 27 |
2300720 | 2300720 | 2022-03-12 | Charles City | Virginia | 51036 | 1143 | 27 |
2297468 | 2297468 | 2022-03-11 | Charles City | Virginia | 51036 | 1143 | 27 |
2294216 | 2294216 | 2022-03-10 | Charles City | Virginia | 51036 | 1143 | 27 |
2290964 | 2290964 | 2022-03-09 | Charles City | Virginia | 51036 | 1142 | 27 |
2287712 | 2287712 | 2022-03-08 | Charles City | Virginia | 51036 | 1141 | 27 |
2284460 | 2284460 | 2022-03-07 | Charles City | Virginia | 51036 | 1141 | 27 |
2281208 | 2281208 | 2022-03-06 | Charles City | Virginia | 51036 | 1140 | 27 |
2277955 | 2277955 | 2022-03-05 | Charles City | Virginia | 51036 | 1140 | 27 |
2274702 | 2274702 | 2022-03-04 | Charles City | Virginia | 51036 | 1140 | 27 |
2271449 | 2271449 | 2022-03-03 | Charles City | Virginia | 51036 | 1141 | 27 |
2268197 | 2268197 | 2022-03-02 | Charles City | Virginia | 51036 | 1141 | 27 |
2264944 | 2264944 | 2022-03-01 | Charles City | Virginia | 51036 | 1141 | 27 |
2261694 | 2261694 | 2022-02-28 | Charles City | Virginia | 51036 | 1140 | 27 |
2258443 | 2258443 | 2022-02-27 | Charles City | Virginia | 51036 | 1137 | 26 |
2255192 | 2255192 | 2022-02-26 | Charles City | Virginia | 51036 | 1137 | 26 |
2251941 | 2251941 | 2022-02-25 | Charles City | Virginia | 51036 | 1137 | 26 |
2248690 | 2248690 | 2022-02-24 | Charles City | Virginia | 51036 | 1137 | 26 |
2245439 | 2245439 | 2022-02-23 | Charles City | Virginia | 51036 | 1136 | 26 |
2242188 | 2242188 | 2022-02-22 | Charles City | Virginia | 51036 | 1135 | 26 |
2238937 | 2238937 | 2022-02-21 | Charles City | Virginia | 51036 | 1134 | 26 |
2235686 | 2235686 | 2022-02-20 | Charles City | Virginia | 51036 | 1134 | 26 |
2232435 | 2232435 | 2022-02-19 | Charles City | Virginia | 51036 | 1134 | 26 |
2229184 | 2229184 | 2022-02-18 | Charles City | Virginia | 51036 | 1134 | 26 |
2225933 | 2225933 | 2022-02-17 | Charles City | Virginia | 51036 | 1133 | 26 |
2222682 | 2222682 | 2022-02-16 | Charles City | Virginia | 51036 | 1131 | 26 |
2219431 | 2219431 | 2022-02-15 | Charles City | Virginia | 51036 | 1128 | 26 |
2216181 | 2216181 | 2022-02-14 | Charles City | Virginia | 51036 | 1127 | 26 |
2212930 | 2212930 | 2022-02-13 | Charles City | Virginia | 51036 | 1123 | 26 |
2209677 | 2209677 | 2022-02-12 | Charles City | Virginia | 51036 | 1123 | 26 |
2206424 | 2206424 | 2022-02-11 | Charles City | Virginia | 51036 | 1123 | 26 |
2203171 | 2203171 | 2022-02-10 | Charles City | Virginia | 51036 | 1121 | 24 |
2199917 | 2199917 | 2022-02-09 | Charles City | Virginia | 51036 | 1120 | 24 |
2196663 | 2196663 | 2022-02-08 | Charles City | Virginia | 51036 | 1120 | 24 |
2193408 | 2193408 | 2022-02-07 | Charles City | Virginia | 51036 | 1119 | 24 |
2190155 | 2190155 | 2022-02-06 | Charles City | Virginia | 51036 | 1112 | 23 |
2186902 | 2186902 | 2022-02-05 | Charles City | Virginia | 51036 | 1112 | 23 |
2183649 | 2183649 | 2022-02-04 | Charles City | Virginia | 51036 | 1112 | 23 |
2180397 | 2180397 | 2022-02-03 | Charles City | Virginia | 51036 | 1112 | 23 |
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);