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: deaths, date (date)
cases 459 ✖
- 37076 6
- 3908 5
- 9393 5
- 19868 5
- 20024 5
- 20765 5
- 28187 5
- 32559 5
- 36127 5
- 36884 5
- 189 4
- 198 4
- 223 4
- 12844 4
- 13854 4
- 15407 4
- 16335 4
- 18366 4
- 19454 4
- 19573 4
- 19696 4
- 20149 4
- 20334 4
- 20389 4
- 20452 4
- 20520 4
- 20588 4
- 20663 4
- 20732 4
- 20927 4
- 21115 4
- 21471 4
- 22634 4
- 23060 4
- 23643 4
- 24855 4
- 26363 4
- 30322 4
- 33974 4
- 34714 4
- 35383 4
- 36039 4
- 36535 4
- 36719 4
- 37702 4
- 38011 4
- 45427 4
- 4 3
- 10 3
- 146 3
- 174 3
- 204 3
- 271 3
- 340 3
- 500 3
- 772 3
- 1300 3
- 1763 3
- 2310 3
- 2822 3
- 3053 3
- 3371 3
- 4074 3
- 4303 3
- 4625 3
- 4969 3
- 5350 3
- 5765 3
- 6258 3
- 6685 3
- 7225 3
- 8038 3
- 9000 3
- 10366 3
- 11225 3
- 11733 3
- 12138 3
- 17952 3
- 18555 3
- 18634 3
- 18831 3
- 18989 3
- 19029 3
- 19107 3
- 19308 3
- 19368 3
- 19524 3
- 19624 3
- 19789 3
- 20078 3
- 20206 3
- 20253 3
- 20287 3
- 20368 3
- 20424 3
- 20492 3
- 20564 3
- 20608 3
- 20645 3
- 20698 3
- 20859 3
- 21268 3
- 22316 3
- 24025 3
- 24609 3
- 25678 3
- 27284 3
- 31302 3
- 34432 3
- 35092 3
- 35848 3
- 36437 3
- 36627 3
- 36804 3
- 36952 3
- 37023 3
- 3 2
- 5 2
- 8 2
- 27 2
- 32 2
- 57 2
- 82 2
- 93 2
- 108 2
- 121 2
- 134 2
- 139 2
- 192 2
- 195 2
- 244 2
- 310 2
- 2107 2
- 3088 2
- 3241 2
- 3646 2
- 6786 2
- 12137 2
- 16247 2
- 16779 2
- 17206 2
- 17292 2
- 17553 2
- 17764 2
- 18100 2
- 18230 2
- 18535 2
- 18896 2
- 18944 2
- 19248 2
- 19927 2
- 20812 2
- 21020 2
- 29822 2
- 33040 2
- 36283 2
- 45307 2
- 45318 2
- 45335 2
- 14 1
- 21 1
- 31 1
- 43 1
- 47 1
- 53 1
- 62 1
- 63 1
- 96 1
- 101 1
- 103 1
- 116 1
- 123 1
- 124 1
- 125 1
- 131 1
- 132 1
- 142 1
- 144 1
- 155 1
- 156 1
- 165 1
- 170 1
- 178 1
- 185 1
- 186 1
- 199 1
- 200 1
- 202 1
- 210 1
- 212 1
- 215 1
- 216 1
- 238 1
- 283 1
- 297 1
- 318 1
- 392 1
- 422 1
- 455 1
- 567 1
- 619 1
- 657 1
- 702 1
- 849 1
- 1099 1
- 1164 1
- 1221 1
- 1442 1
- 1500 1
- 1569 1
- 1717 1
- 1908 1
- 1961 1
- 2007 1
- 2058 1
- 2106 1
- 2190 1
- 2223 1
- 2252 1
- 2293 1
- 2369 1
- 2416 1
- 2446 1
- 2470 1
- 2893 1
- 2928 1
- 2996 1
- 3322 1
- 3451 1
- 3562 1
- 3588 1
- 3609 1
- 3645 1
- 3786 1
- 3829 1
- 3981 1
- 4023 1
- 4051 1
- 4056 1
- 4117 1
- 4179 1
- 4260 1
- 4341 1
- 4436 1
- 4493 1
- 4542 1
- 4586 1
- 4722 1
- 4763 1
- 4826 1
- 4901 1
- 5067 1
- 5127 1
- 5234 1
- 5290 1
- 5477 1
- 5559 1
- 5665 1
- 5714 1
- 5910 1
- 5980 1
- 6058 1
- 6114 1
- 6383 1
- 6458 1
- 6563 1
- 6622 1
- 6981 1
- 7063 1
- 7501 1
- 7608 1
- 7708 1
- 7901 1
- 8389 1
- 8540 1
- 8777 1
- 8862 1
- 9139 1
- 9273 1
- 9685 1
- 9790 1
- 9900 1
- 10162 1
- 10650 1
- 10822 1
- 10939 1
- 11059 1
- 11399 1
- 11503 1
- 11595 1
- 11659 1
- 11900 1
- 12024 1
- 12482 1
- 12614 1
- 12749 1
- 13161 1
- 13340 1
- 13544 1
- 13545 1
- 14526 1
- 14806 1
- 15248 1
- 15874 1
- 18476 1
- 18743 1
- 19080 1
- 19119 1
- 19188 1
- 20252 1
- 21019 1
- 37172 1
- 37223 1
- 37230 1
- 37235 1
- 37249 1
- 37260 1
- 37263 1
- 37283 1
- 37306 1
- 37309 1
- 37316 1
- 37408 1
- 37428 1
- 37442 1
- 37475 1
- 37488 1
- 37498 1
- 37525 1
- 37534 1
- 37555 1
- 37606 1
- 37624 1
- 37644 1
- 37679 1
- 37689 1
- 37878 1
- 37929 1
- 37967 1
- 38016 1
- 38142 1
- 38455 1
- 38654 1
- 38892 1
- 38900 1
- 39195 1
- 39200 1
- 39364 1
- 39588 1
- 39594 1
- 39716 1
- 39902 1
- 39975 1
- 40169 1
- 40217 1
- 40402 1
- 40518 1
- 40659 1
- 41044 1
- 41236 1
- 41431 1
- 41514 1
- 41653 1
- 41844 1
- 42044 1
- 42212 1
- 42423 1
- 42565 1
- 42689 1
- 43724 1
- 43888 1
- 43987 1
- 44130 1
- 44190 1
- 44268 1
- 44334 1
- 44404 1
- 44482 1
- 44585 1
- 44660 1
- 44708 1
- 44761 1
- 44782 1
- 44937 1
- 44974 1
- 45025 1
- 45032 1
- 45060 1
- 45104 1
- 45112 1
- 45123 1
- 45131 1
- 45148 1
- 45152 1
- 45168 1
- 45180 1
- 45189 1
- 45193 1
- 45204 1
- 45209 1
- 45212 1
- 45249 1
- 45251 1
- 45258 1
- 45269 1
- 45270 1
- 45281 1
- 45283 1
- 45287 1
- 45292 1
- 45297 1
- 45304 1
- 45314 1
- 45325 1
- 45329 1
- 45330 1
- 45336 1
- 45342 1
- 45343 1
- 45375 1
- 45378 1
- 45383 1
- 45384 1
- 45387 1
- 45392 1
- 45393 1
- 45396 1
- 45403 1
- 45407 1
- 45409 1
- 45415 1
- 45418 1
- 45421 1
- 45455 1
- 45456 1
- 45460 1
- 45465 1
- 45468 1
- 45472 1
- 45478 1
- 45483 1
- 45486 1
- 45489 1
- 45492 1
- 45494 1
- 45497 1
- 45503 1
- 45505 1
- 45507 1
- 45515 1
- 45520 1
- 45523 1
- 45529 1
- 45545 1
- 45555 1
- 45561 1
- 45571 1
- 45574 1
- 45581 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);