ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,114 rows where county = "Smith" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 389 ✖
- 3 280
- 0 270
- 1 161
- 34 137
- 2 133
- 40 104
- 7 86
- 4 81
- 52 73
- 16 66
- 11 56
- 13 56
- 8 55
- 36 50
- 67 46
- 12 39
- 68 39
- 39 36
- 53 34
- 5 33
- 66 32
- 20 30
- 37 27
- 83 22
- 10 21
- 14 21
- 15 21
- 17 21
- 27 21
- 49 21
- 50 21
- 84 21
- 964 21
- 23 20
- 41 19
- 55 17
- 35 16
- 54 15
- 73 15
- 24 14
- 30 14
- 44 14
- 65 13
- 85 13
- 19 12
- 18 11
- 57 11
- 38 10
- 6 9
- 26 9
- 33 9
- 64 9
- 487 9
- 489 9
- 492 9
- 835 9
- 31 8
- 42 8
- 43 8
- 46 8
- 47 8
- 48 8
- 51 8
- 387 8
- 839 8
- 966 8
- 71 7
- 72 7
- 74 7
- 76 7
- 80 7
- 486 7
- 837 7
- 9 6
- 28 6
- 469 6
- 483 6
- 493 6
- 962 6
- 56 5
- 63 5
- 78 5
- 110 5
- 196 5
- 462 5
- 482 5
- 490 5
- 502 5
- 504 5
- 797 5
- 821 5
- 827 5
- 951 5
- 22 4
- 58 4
- 115 4
- 219 4
- 459 4
- 484 4
- 485 4
- 819 4
- 945 4
- 958 4
- 960 4
- 968 4
- 25 3
- 29 3
- 32 3
- 59 3
- 96 3
- 125 3
- 145 3
- 156 3
- 187 3
- 189 3
- 190 3
- 211 3
- 235 3
- 269 3
- 410 3
- 422 3
- 439 3
- 447 3
- 452 3
- 468 3
- 473 3
- 475 3
- 478 3
- 481 3
- 491 3
- 496 3
- 775 3
- 809 3
- 826 3
- 829 3
- 830 3
- 855 3
- 882 3
- 884 3
- 965 3
- 967 3
- 61 2
- 89 2
- 97 2
- 99 2
- 103 2
- 124 2
- 134 2
- 203 2
- 251 2
- 307 2
- 324 2
- 338 2
- 346 2
- 375 2
- 381 2
- 389 2
- 405 2
- 411 2
- 438 2
- 441 2
- 442 2
- 448 2
- 449 2
- 450 2
- 457 2
- 463 2
- 465 2
- 497 2
- 500 2
- 524 2
- 528 2
- 534 2
- 547 2
- 550 2
- 560 2
- 600 2
- 643 2
- 726 2
- 758 2
- 787 2
- 790 2
- 811 2
- 831 2
- 841 2
- 846 2
- 864 2
- 887 2
- 890 2
- 912 2
- 916 2
- 935 2
- 947 2
- 952 2
- 954 2
- 21 1
- 45 1
- 70 1
- 77 1
- 91 1
- 94 1
- 104 1
- 105 1
- 106 1
- 107 1
- 108 1
- 112 1
- 113 1
- 117 1
- 119 1
- 120 1
- 123 1
- 127 1
- 132 1
- 135 1
- 137 1
- 139 1
- 141 1
- 144 1
- 146 1
- 147 1
- 150 1
- 159 1
- 161 1
- 167 1
- 188 1
- 192 1
- 197 1
- 200 1
- 204 1
- 207 1
- 212 1
- 213 1
- 215 1
- 218 1
- 221 1
- 226 1
- 232 1
- 237 1
- 243 1
- 248 1
- 252 1
- 254 1
- 256 1
- 259 1
- 261 1
- 267 1
- 272 1
- 273 1
- 280 1
- 284 1
- 287 1
- 289 1
- 290 1
- 292 1
- 293 1
- 295 1
- 298 1
- 303 1
- 309 1
- 312 1
- 314 1
- 318 1
- 323 1
- 329 1
- 340 1
- 347 1
- 350 1
- 355 1
- 362 1
- 367 1
- 371 1
- 378 1
- 383 1
- 388 1
- 391 1
- 396 1
- 401 1
- 404 1
- 406 1
- 407 1
- 415 1
- 416 1
- 417 1
- 419 1
- 427 1
- 428 1
- 431 1
- 433 1
- 440 1
- 444 1
- 446 1
- 454 1
- 455 1
- 456 1
- 466 1
- 467 1
- 470 1
- 472 1
- 474 1
- 476 1
- 480 1
- 488 1
- 499 1
- 503 1
- 506 1
- 507 1
- 513 1
- 518 1
- 520 1
- 543 1
- 549 1
- 553 1
- 557 1
- 563 1
- 573 1
- 581 1
- 587 1
- 599 1
- 607 1
- 613 1
- 621 1
- 629 1
- 635 1
- 645 1
- 647 1
- 665 1
- 669 1
- 677 1
- 683 1
- 684 1
- 689 1
- 700 1
- 706 1
- 713 1
- 719 1
- 733 1
- 742 1
- 745 1
- 748 1
- 751 1
- 759 1
- 763 1
- 770 1
- 772 1
- 776 1
- 777 1
- 780 1
- 782 1
- 785 1
- 786 1
- 791 1
- 804 1
- 807 1
- 817 1
- 818 1
- 824 1
- 825 1
- 833 1
- 840 1
- 842 1
- 843 1
- 848 1
- 850 1
- 852 1
- 854 1
- 856 1
- 860 1
- 867 1
- 868 1
- 869 1
- 870 1
- 872 1
- 878 1
- 879 1
- 893 1
- 894 1
- 903 1
- 907 1
- 919 1
- 924 1
- 925 1
- 927 1
- 929 1
- 933 1
- 936 1
- 938 1
- 943 1
- 959 1
state 4
- Texas 792
- Mississippi 785
- Tennessee 778
- Kansas 759
county 1
- Smith · 3,114 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500564 | 2500564 | 2022-05-13 | Smith | Kansas | 20183 | 645 | 7 |
2501057 | 2501057 | 2022-05-13 | Smith | Mississippi | 28129 | 4127 | 68 |
2502190 | 2502190 | 2022-05-13 | Smith | Tennessee | 47159 | 6171 | 85 |
2502419 | 2502419 | 2022-05-13 | Smith | Texas | 48423 | 45581 | 968 |
2497306 | 2497306 | 2022-05-12 | Smith | Kansas | 20183 | 645 | 7 |
2497799 | 2497799 | 2022-05-12 | Smith | Mississippi | 28129 | 4127 | 68 |
2498932 | 2498932 | 2022-05-12 | Smith | Tennessee | 47159 | 6171 | 85 |
2499161 | 2499161 | 2022-05-12 | Smith | Texas | 48423 | 45574 | 968 |
2494048 | 2494048 | 2022-05-11 | Smith | Kansas | 20183 | 645 | 7 |
2494541 | 2494541 | 2022-05-11 | Smith | Mississippi | 28129 | 4127 | 68 |
2495674 | 2495674 | 2022-05-11 | Smith | Tennessee | 47159 | 6171 | 85 |
2495903 | 2495903 | 2022-05-11 | Smith | Texas | 48423 | 45571 | 968 |
2490790 | 2490790 | 2022-05-10 | Smith | Kansas | 20183 | 645 | 7 |
2491283 | 2491283 | 2022-05-10 | Smith | Mississippi | 28129 | 4127 | 68 |
2492416 | 2492416 | 2022-05-10 | Smith | Tennessee | 47159 | 6168 | 85 |
2492645 | 2492645 | 2022-05-10 | Smith | Texas | 48423 | 45561 | 968 |
2487533 | 2487533 | 2022-05-09 | Smith | Kansas | 20183 | 645 | 7 |
2488026 | 2488026 | 2022-05-09 | Smith | Mississippi | 28129 | 4127 | 68 |
2489158 | 2489158 | 2022-05-09 | Smith | Tennessee | 47159 | 6168 | 85 |
2489387 | 2489387 | 2022-05-09 | Smith | Texas | 48423 | 45555 | 967 |
2484275 | 2484275 | 2022-05-08 | Smith | Kansas | 20183 | 645 | 7 |
2484768 | 2484768 | 2022-05-08 | Smith | Mississippi | 28129 | 4115 | 68 |
2485901 | 2485901 | 2022-05-08 | Smith | Tennessee | 47159 | 6168 | 85 |
2486129 | 2486129 | 2022-05-08 | Smith | Texas | 48423 | 45545 | 967 |
2481017 | 2481017 | 2022-05-07 | Smith | Kansas | 20183 | 645 | 7 |
2481510 | 2481510 | 2022-05-07 | Smith | Mississippi | 28129 | 4115 | 68 |
2482643 | 2482643 | 2022-05-07 | Smith | Tennessee | 47159 | 6168 | 85 |
2482871 | 2482871 | 2022-05-07 | Smith | Texas | 48423 | 45529 | 967 |
2477759 | 2477759 | 2022-05-06 | Smith | Kansas | 20183 | 645 | 7 |
2478252 | 2478252 | 2022-05-06 | Smith | Mississippi | 28129 | 4115 | 68 |
2479385 | 2479385 | 2022-05-06 | Smith | Tennessee | 47159 | 6168 | 85 |
2479613 | 2479613 | 2022-05-06 | Smith | Texas | 48423 | 45523 | 966 |
2474501 | 2474501 | 2022-05-05 | Smith | Kansas | 20183 | 644 | 7 |
2474994 | 2474994 | 2022-05-05 | Smith | Mississippi | 28129 | 4115 | 68 |
2476127 | 2476127 | 2022-05-05 | Smith | Tennessee | 47159 | 6168 | 85 |
2476355 | 2476355 | 2022-05-05 | Smith | Texas | 48423 | 45520 | 966 |
2471244 | 2471244 | 2022-05-04 | Smith | Kansas | 20183 | 644 | 7 |
2471737 | 2471737 | 2022-05-04 | Smith | Mississippi | 28129 | 4115 | 68 |
2472870 | 2472870 | 2022-05-04 | Smith | Tennessee | 47159 | 6168 | 85 |
2473098 | 2473098 | 2022-05-04 | Smith | Texas | 48423 | 45515 | 966 |
2467988 | 2467988 | 2022-05-03 | Smith | Kansas | 20183 | 644 | 7 |
2468481 | 2468481 | 2022-05-03 | Smith | Mississippi | 28129 | 4115 | 68 |
2469614 | 2469614 | 2022-05-03 | Smith | Tennessee | 47159 | 6163 | 84 |
2469842 | 2469842 | 2022-05-03 | Smith | Texas | 48423 | 45507 | 966 |
2464733 | 2464733 | 2022-05-02 | Smith | Kansas | 20183 | 644 | 7 |
2465226 | 2465226 | 2022-05-02 | Smith | Mississippi | 28129 | 4115 | 68 |
2466358 | 2466358 | 2022-05-02 | Smith | Tennessee | 47159 | 6163 | 84 |
2466586 | 2466586 | 2022-05-02 | Smith | Texas | 48423 | 45505 | 966 |
2461477 | 2461477 | 2022-05-01 | Smith | Kansas | 20183 | 644 | 7 |
2461970 | 2461970 | 2022-05-01 | Smith | Mississippi | 28129 | 4113 | 68 |
2463103 | 2463103 | 2022-05-01 | Smith | Tennessee | 47159 | 6163 | 84 |
2463331 | 2463331 | 2022-05-01 | Smith | Texas | 48423 | 45503 | 966 |
2458221 | 2458221 | 2022-04-30 | Smith | Kansas | 20183 | 644 | 7 |
2458714 | 2458714 | 2022-04-30 | Smith | Mississippi | 28129 | 4113 | 68 |
2459847 | 2459847 | 2022-04-30 | Smith | Tennessee | 47159 | 6163 | 84 |
2460075 | 2460075 | 2022-04-30 | Smith | Texas | 48423 | 45497 | 966 |
2454965 | 2454965 | 2022-04-29 | Smith | Kansas | 20183 | 644 | 7 |
2455458 | 2455458 | 2022-04-29 | Smith | Mississippi | 28129 | 4113 | 68 |
2456591 | 2456591 | 2022-04-29 | Smith | Tennessee | 47159 | 6163 | 84 |
2456819 | 2456819 | 2022-04-29 | Smith | Texas | 48423 | 45494 | 966 |
2451709 | 2451709 | 2022-04-28 | Smith | Kansas | 20183 | 644 | 7 |
2452202 | 2452202 | 2022-04-28 | Smith | Mississippi | 28129 | 4113 | 68 |
2453335 | 2453335 | 2022-04-28 | Smith | Tennessee | 47159 | 6163 | 84 |
2453563 | 2453563 | 2022-04-28 | Smith | Texas | 48423 | 45492 | 965 |
2448453 | 2448453 | 2022-04-27 | Smith | Kansas | 20183 | 644 | 7 |
2448946 | 2448946 | 2022-04-27 | Smith | Mississippi | 28129 | 4113 | 68 |
2450079 | 2450079 | 2022-04-27 | Smith | Tennessee | 47159 | 6163 | 84 |
2450307 | 2450307 | 2022-04-27 | Smith | Texas | 48423 | 45489 | 965 |
2445197 | 2445197 | 2022-04-26 | Smith | Kansas | 20183 | 644 | 7 |
2445690 | 2445690 | 2022-04-26 | Smith | Mississippi | 28129 | 4113 | 68 |
2446822 | 2446822 | 2022-04-26 | Smith | Tennessee | 47159 | 6163 | 84 |
2447050 | 2447050 | 2022-04-26 | Smith | Texas | 48423 | 45486 | 965 |
2441941 | 2441941 | 2022-04-25 | Smith | Kansas | 20183 | 644 | 7 |
2442434 | 2442434 | 2022-04-25 | Smith | Mississippi | 28129 | 4112 | 68 |
2443567 | 2443567 | 2022-04-25 | Smith | Tennessee | 47159 | 6163 | 84 |
2443795 | 2443795 | 2022-04-25 | Smith | Texas | 48423 | 45483 | 964 |
2438685 | 2438685 | 2022-04-24 | Smith | Kansas | 20183 | 644 | 7 |
2439178 | 2439178 | 2022-04-24 | Smith | Mississippi | 28129 | 4112 | 68 |
2440311 | 2440311 | 2022-04-24 | Smith | Tennessee | 47159 | 6163 | 84 |
2440539 | 2440539 | 2022-04-24 | Smith | Texas | 48423 | 45478 | 964 |
2435429 | 2435429 | 2022-04-23 | Smith | Kansas | 20183 | 644 | 7 |
2435922 | 2435922 | 2022-04-23 | Smith | Mississippi | 28129 | 4112 | 68 |
2437055 | 2437055 | 2022-04-23 | Smith | Tennessee | 47159 | 6163 | 84 |
2437283 | 2437283 | 2022-04-23 | Smith | Texas | 48423 | 45472 | 964 |
2432173 | 2432173 | 2022-04-22 | Smith | Kansas | 20183 | 644 | 7 |
2432666 | 2432666 | 2022-04-22 | Smith | Mississippi | 28129 | 4112 | 68 |
2433799 | 2433799 | 2022-04-22 | Smith | Tennessee | 47159 | 6163 | 84 |
2434027 | 2434027 | 2022-04-22 | Smith | Texas | 48423 | 45468 | 964 |
2428917 | 2428917 | 2022-04-21 | Smith | Kansas | 20183 | 644 | 7 |
2429410 | 2429410 | 2022-04-21 | Smith | Mississippi | 28129 | 4112 | 68 |
2430543 | 2430543 | 2022-04-21 | Smith | Tennessee | 47159 | 6163 | 84 |
2430771 | 2430771 | 2022-04-21 | Smith | Texas | 48423 | 45465 | 964 |
2425661 | 2425661 | 2022-04-20 | Smith | Kansas | 20183 | 644 | 7 |
2426154 | 2426154 | 2022-04-20 | Smith | Mississippi | 28129 | 4112 | 68 |
2427287 | 2427287 | 2022-04-20 | Smith | Tennessee | 47159 | 6163 | 84 |
2427515 | 2427515 | 2022-04-20 | Smith | Texas | 48423 | 45460 | 964 |
2422405 | 2422405 | 2022-04-19 | Smith | Kansas | 20183 | 644 | 7 |
2422898 | 2422898 | 2022-04-19 | Smith | Mississippi | 28129 | 4112 | 68 |
2424031 | 2424031 | 2022-04-19 | Smith | Tennessee | 47159 | 6161 | 84 |
2424259 | 2424259 | 2022-04-19 | Smith | Texas | 48423 | 45456 | 964 |
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);