ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48423 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 352 ✖
- 4 58
- 964 21
- 0 13
- 2 13
- 1 11
- 5 11
- 3 10
- 487 9
- 489 9
- 492 9
- 835 9
- 387 8
- 839 8
- 966 8
- 8 7
- 486 7
- 837 7
- 469 6
- 483 6
- 493 6
- 962 6
- 18 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
- 35 4
- 115 4
- 219 4
- 459 4
- 484 4
- 485 4
- 819 4
- 945 4
- 958 4
- 960 4
- 968 4
- 11 3
- 13 3
- 23 3
- 58 3
- 85 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
- 12 2
- 14 2
- 15 2
- 36 2
- 43 2
- 47 2
- 57 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
- 6 1
- 9 1
- 10 1
- 16 1
- 17 1
- 20 1
- 21 1
- 22 1
- 27 1
- 49 1
- 51 1
- 52 1
- 53 1
- 54 1
- 63 1
- 66 1
- 70 1
- 73 1
- 77 1
- 83 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 1
- Texas 792
fips 1
- 48423 · 792 ✖
county 1
- Smith 792
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502419 | 2502419 | 2022-05-13 | Smith | Texas | 48423 | 45581 | 968 |
2499161 | 2499161 | 2022-05-12 | Smith | Texas | 48423 | 45574 | 968 |
2495903 | 2495903 | 2022-05-11 | Smith | Texas | 48423 | 45571 | 968 |
2492645 | 2492645 | 2022-05-10 | Smith | Texas | 48423 | 45561 | 968 |
2489387 | 2489387 | 2022-05-09 | Smith | Texas | 48423 | 45555 | 967 |
2486129 | 2486129 | 2022-05-08 | Smith | Texas | 48423 | 45545 | 967 |
2482871 | 2482871 | 2022-05-07 | Smith | Texas | 48423 | 45529 | 967 |
2479613 | 2479613 | 2022-05-06 | Smith | Texas | 48423 | 45523 | 966 |
2476355 | 2476355 | 2022-05-05 | Smith | Texas | 48423 | 45520 | 966 |
2473098 | 2473098 | 2022-05-04 | Smith | Texas | 48423 | 45515 | 966 |
2469842 | 2469842 | 2022-05-03 | Smith | Texas | 48423 | 45507 | 966 |
2466586 | 2466586 | 2022-05-02 | Smith | Texas | 48423 | 45505 | 966 |
2463331 | 2463331 | 2022-05-01 | Smith | Texas | 48423 | 45503 | 966 |
2460075 | 2460075 | 2022-04-30 | Smith | Texas | 48423 | 45497 | 966 |
2456819 | 2456819 | 2022-04-29 | Smith | Texas | 48423 | 45494 | 966 |
2453563 | 2453563 | 2022-04-28 | Smith | Texas | 48423 | 45492 | 965 |
2450307 | 2450307 | 2022-04-27 | Smith | Texas | 48423 | 45489 | 965 |
2447050 | 2447050 | 2022-04-26 | Smith | Texas | 48423 | 45486 | 965 |
2443795 | 2443795 | 2022-04-25 | Smith | Texas | 48423 | 45483 | 964 |
2440539 | 2440539 | 2022-04-24 | Smith | Texas | 48423 | 45478 | 964 |
2437283 | 2437283 | 2022-04-23 | Smith | Texas | 48423 | 45472 | 964 |
2434027 | 2434027 | 2022-04-22 | Smith | Texas | 48423 | 45468 | 964 |
2430771 | 2430771 | 2022-04-21 | Smith | Texas | 48423 | 45465 | 964 |
2427515 | 2427515 | 2022-04-20 | Smith | Texas | 48423 | 45460 | 964 |
2424259 | 2424259 | 2022-04-19 | Smith | Texas | 48423 | 45456 | 964 |
2421003 | 2421003 | 2022-04-18 | Smith | Texas | 48423 | 45455 | 964 |
2417747 | 2417747 | 2022-04-17 | Smith | Texas | 48423 | 45427 | 964 |
2414491 | 2414491 | 2022-04-16 | Smith | Texas | 48423 | 45427 | 964 |
2411235 | 2411235 | 2022-04-15 | Smith | Texas | 48423 | 45427 | 964 |
2407979 | 2407979 | 2022-04-14 | Smith | Texas | 48423 | 45427 | 964 |
2404723 | 2404723 | 2022-04-13 | Smith | Texas | 48423 | 45421 | 964 |
2401468 | 2401468 | 2022-04-12 | Smith | Texas | 48423 | 45418 | 964 |
2398213 | 2398213 | 2022-04-11 | Smith | Texas | 48423 | 45415 | 964 |
2394958 | 2394958 | 2022-04-10 | Smith | Texas | 48423 | 45409 | 964 |
2391702 | 2391702 | 2022-04-09 | Smith | Texas | 48423 | 45407 | 964 |
2388446 | 2388446 | 2022-04-08 | Smith | Texas | 48423 | 45403 | 964 |
2385191 | 2385191 | 2022-04-07 | Smith | Texas | 48423 | 45396 | 964 |
2381936 | 2381936 | 2022-04-06 | Smith | Texas | 48423 | 45393 | 964 |
2378681 | 2378681 | 2022-04-05 | Smith | Texas | 48423 | 45392 | 964 |
2375427 | 2375427 | 2022-04-04 | Smith | Texas | 48423 | 45387 | 962 |
2372175 | 2372175 | 2022-04-03 | Smith | Texas | 48423 | 45384 | 962 |
2368922 | 2368922 | 2022-04-02 | Smith | Texas | 48423 | 45383 | 962 |
2365669 | 2365669 | 2022-04-01 | Smith | Texas | 48423 | 45378 | 962 |
2362416 | 2362416 | 2022-03-31 | Smith | Texas | 48423 | 45375 | 962 |
2359162 | 2359162 | 2022-03-30 | Smith | Texas | 48423 | 45343 | 962 |
2355908 | 2355908 | 2022-03-29 | Smith | Texas | 48423 | 45342 | 960 |
2352655 | 2352655 | 2022-03-28 | Smith | Texas | 48423 | 45336 | 960 |
2349403 | 2349403 | 2022-03-27 | Smith | Texas | 48423 | 45335 | 960 |
2346150 | 2346150 | 2022-03-26 | Smith | Texas | 48423 | 45335 | 960 |
2342897 | 2342897 | 2022-03-25 | Smith | Texas | 48423 | 45330 | 959 |
2339644 | 2339644 | 2022-03-24 | Smith | Texas | 48423 | 45329 | 958 |
2336390 | 2336390 | 2022-03-23 | Smith | Texas | 48423 | 45325 | 958 |
2333136 | 2333136 | 2022-03-22 | Smith | Texas | 48423 | 45318 | 958 |
2329883 | 2329883 | 2022-03-21 | Smith | Texas | 48423 | 45318 | 958 |
2326631 | 2326631 | 2022-03-20 | Smith | Texas | 48423 | 45314 | 954 |
2323378 | 2323378 | 2022-03-19 | Smith | Texas | 48423 | 45307 | 954 |
2320124 | 2320124 | 2022-03-18 | Smith | Texas | 48423 | 45307 | 952 |
2316870 | 2316870 | 2022-03-17 | Smith | Texas | 48423 | 45304 | 952 |
2313617 | 2313617 | 2022-03-16 | Smith | Texas | 48423 | 45297 | 951 |
2310364 | 2310364 | 2022-03-15 | Smith | Texas | 48423 | 45292 | 951 |
2307111 | 2307111 | 2022-03-14 | Smith | Texas | 48423 | 45287 | 951 |
2303860 | 2303860 | 2022-03-13 | Smith | Texas | 48423 | 45283 | 951 |
2300608 | 2300608 | 2022-03-12 | Smith | Texas | 48423 | 45281 | 951 |
2297356 | 2297356 | 2022-03-11 | Smith | Texas | 48423 | 45270 | 947 |
2294104 | 2294104 | 2022-03-10 | Smith | Texas | 48423 | 45269 | 947 |
2290852 | 2290852 | 2022-03-09 | Smith | Texas | 48423 | 45258 | 945 |
2287600 | 2287600 | 2022-03-08 | Smith | Texas | 48423 | 45251 | 945 |
2284348 | 2284348 | 2022-03-07 | Smith | Texas | 48423 | 45249 | 945 |
2281096 | 2281096 | 2022-03-06 | Smith | Texas | 48423 | 45212 | 945 |
2277843 | 2277843 | 2022-03-05 | Smith | Texas | 48423 | 45209 | 943 |
2274590 | 2274590 | 2022-03-04 | Smith | Texas | 48423 | 45204 | 938 |
2271337 | 2271337 | 2022-03-03 | Smith | Texas | 48423 | 45193 | 936 |
2268085 | 2268085 | 2022-03-02 | Smith | Texas | 48423 | 45189 | 935 |
2264832 | 2264832 | 2022-03-01 | Smith | Texas | 48423 | 45180 | 935 |
2261582 | 2261582 | 2022-02-28 | Smith | Texas | 48423 | 45168 | 933 |
2258331 | 2258331 | 2022-02-27 | Smith | Texas | 48423 | 45152 | 929 |
2255080 | 2255080 | 2022-02-26 | Smith | Texas | 48423 | 45148 | 927 |
2251829 | 2251829 | 2022-02-25 | Smith | Texas | 48423 | 45131 | 925 |
2248578 | 2248578 | 2022-02-24 | Smith | Texas | 48423 | 45123 | 924 |
2245327 | 2245327 | 2022-02-23 | Smith | Texas | 48423 | 45112 | 919 |
2242076 | 2242076 | 2022-02-22 | Smith | Texas | 48423 | 45104 | 916 |
2238825 | 2238825 | 2022-02-21 | Smith | Texas | 48423 | 45060 | 916 |
2235574 | 2235574 | 2022-02-20 | Smith | Texas | 48423 | 45032 | 912 |
2232323 | 2232323 | 2022-02-19 | Smith | Texas | 48423 | 45025 | 912 |
2229072 | 2229072 | 2022-02-18 | Smith | Texas | 48423 | 44974 | 907 |
2225821 | 2225821 | 2022-02-17 | Smith | Texas | 48423 | 44937 | 903 |
2222570 | 2222570 | 2022-02-16 | Smith | Texas | 48423 | 44782 | 894 |
2219319 | 2219319 | 2022-02-15 | Smith | Texas | 48423 | 44761 | 893 |
2216068 | 2216068 | 2022-02-14 | Smith | Texas | 48423 | 44708 | 890 |
2212817 | 2212817 | 2022-02-13 | Smith | Texas | 48423 | 44660 | 890 |
2209564 | 2209564 | 2022-02-12 | Smith | Texas | 48423 | 44585 | 887 |
2206311 | 2206311 | 2022-02-11 | Smith | Texas | 48423 | 44482 | 887 |
2203058 | 2203058 | 2022-02-10 | Smith | Texas | 48423 | 44404 | 884 |
2199804 | 2199804 | 2022-02-09 | Smith | Texas | 48423 | 44334 | 884 |
2196550 | 2196550 | 2022-02-08 | Smith | Texas | 48423 | 44268 | 884 |
2193296 | 2193296 | 2022-02-07 | Smith | Texas | 48423 | 44190 | 882 |
2190042 | 2190042 | 2022-02-06 | Smith | Texas | 48423 | 44130 | 882 |
2186789 | 2186789 | 2022-02-05 | Smith | Texas | 48423 | 43987 | 882 |
2183537 | 2183537 | 2022-02-04 | Smith | Texas | 48423 | 43888 | 879 |
2180285 | 2180285 | 2022-02-03 | Smith | Texas | 48423 | 43724 | 878 |
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);