ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 12017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 217 ✖
- 463 105
- 12 43
- 11 21
- 826 18
- 975 14
- 13 12
- 733 12
- 0 10
- 976 10
- 2 9
- 8 8
- 695 8
- 815 8
- 837 8
- 950 8
- 17 7
- 130 7
- 667 7
- 777 7
- 820 7
- 838 7
- 839 7
- 840 7
- 846 7
- 849 7
- 853 7
- 864 7
- 891 7
- 907 7
- 925 7
- 933 7
- 944 7
- 965 7
- 969 7
- 973 7
- 362 6
- 420 6
- 432 6
- 433 6
- 438 6
- 802 6
- 835 6
- 962 6
- 1 5
- 20 5
- 36 5
- 445 5
- 462 5
- 822 5
- 6 4
- 46 4
- 64 4
- 131 4
- 135 4
- 143 4
- 612 4
- 9 3
- 38 3
- 40 3
- 57 3
- 103 3
- 136 3
- 142 3
- 157 3
- 223 3
- 283 3
- 308 3
- 330 3
- 344 3
- 363 3
- 404 3
- 428 3
- 435 3
- 436 3
- 444 3
- 451 3
- 452 3
- 461 3
- 758 3
- 7 2
- 14 2
- 18 2
- 30 2
- 34 2
- 70 2
- 72 2
- 86 2
- 107 2
- 108 2
- 112 2
- 115 2
- 118 2
- 124 2
- 158 2
- 160 2
- 165 2
- 171 2
- 181 2
- 188 2
- 218 2
- 249 2
- 251 2
- 260 2
- 266 2
- 287 2
- 299 2
- 323 2
- 336 2
- 356 2
- 365 2
- 386 2
- 397 2
- 411 2
- 412 2
- 414 2
- 417 2
- 419 2
- 421 2
- 429 2
- 437 2
- 439 2
- 460 2
- 5 1
- 15 1
- 16 1
- 23 1
- 26 1
- 27 1
- 29 1
- 37 1
- 43 1
- 45 1
- 48 1
- 50 1
- 53 1
- 54 1
- 55 1
- 59 1
- 60 1
- 61 1
- 62 1
- 67 1
- 73 1
- 75 1
- 76 1
- 80 1
- 81 1
- 84 1
- 88 1
- 92 1
- 97 1
- 100 1
- 102 1
- 106 1
- 110 1
- 111 1
- 121 1
- 125 1
- 126 1
- 134 1
- 139 1
- 146 1
- 147 1
- 148 1
- 149 1
- 150 1
- 152 1
- 168 1
- 174 1
- 176 1
- 177 1
- 184 1
- 186 1
- 203 1
- 204 1
- 216 1
- 219 1
- 220 1
- 224 1
- 226 1
- 239 1
- 261 1
- 274 1
- 275 1
- 276 1
- 282 1
- 296 1
- 297 1
- 309 1
- 316 1
- 319 1
- 341 1
- 345 1
- 353 1
- 354 1
- 373 1
- 376 1
- 380 1
- 382 1
- 384 1
- 391 1
- 395 1
- 399 1
- 406 1
- 410 1
- 415 1
- 416 1
- 424 1
- 425 1
- 434 1
- 446 1
- 447 1
- 453 1
- 454 1
- 455 1
- 456 1
- 459 1
state 1
- Florida 790
fips 1
- 12017 · 790 ✖
county 1
- Citrus 790
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499906 | 2499906 | 2022-05-13 | Citrus | Florida | 12017 | 29988 | 976 |
2496648 | 2496648 | 2022-05-12 | Citrus | Florida | 12017 | 29988 | 976 |
2493390 | 2493390 | 2022-05-11 | Citrus | Florida | 12017 | 29988 | 976 |
2490132 | 2490132 | 2022-05-10 | Citrus | Florida | 12017 | 29988 | 976 |
2486875 | 2486875 | 2022-05-09 | Citrus | Florida | 12017 | 29988 | 976 |
2483617 | 2483617 | 2022-05-08 | Citrus | Florida | 12017 | 29988 | 976 |
2480359 | 2480359 | 2022-05-07 | Citrus | Florida | 12017 | 29988 | 976 |
2477101 | 2477101 | 2022-05-06 | Citrus | Florida | 12017 | 29988 | 976 |
2473843 | 2473843 | 2022-05-05 | Citrus | Florida | 12017 | 29688 | 976 |
2470586 | 2470586 | 2022-05-04 | Citrus | Florida | 12017 | 29688 | 976 |
2467330 | 2467330 | 2022-05-03 | Citrus | Florida | 12017 | 29688 | 975 |
2464075 | 2464075 | 2022-05-02 | Citrus | Florida | 12017 | 29688 | 975 |
2460819 | 2460819 | 2022-05-01 | Citrus | Florida | 12017 | 29688 | 975 |
2457563 | 2457563 | 2022-04-30 | Citrus | Florida | 12017 | 29688 | 975 |
2454307 | 2454307 | 2022-04-29 | Citrus | Florida | 12017 | 29688 | 975 |
2451051 | 2451051 | 2022-04-28 | Citrus | Florida | 12017 | 29688 | 975 |
2447795 | 2447795 | 2022-04-27 | Citrus | Florida | 12017 | 29688 | 975 |
2444539 | 2444539 | 2022-04-26 | Citrus | Florida | 12017 | 29688 | 975 |
2441283 | 2441283 | 2022-04-25 | Citrus | Florida | 12017 | 29688 | 975 |
2438027 | 2438027 | 2022-04-24 | Citrus | Florida | 12017 | 29688 | 975 |
2434771 | 2434771 | 2022-04-23 | Citrus | Florida | 12017 | 29688 | 975 |
2431515 | 2431515 | 2022-04-22 | Citrus | Florida | 12017 | 29688 | 975 |
2428259 | 2428259 | 2022-04-21 | Citrus | Florida | 12017 | 29539 | 975 |
2425003 | 2425003 | 2022-04-20 | Citrus | Florida | 12017 | 29539 | 975 |
2421747 | 2421747 | 2022-04-19 | Citrus | Florida | 12017 | 29539 | 973 |
2418491 | 2418491 | 2022-04-18 | Citrus | Florida | 12017 | 29539 | 973 |
2415235 | 2415235 | 2022-04-17 | Citrus | Florida | 12017 | 29539 | 973 |
2411979 | 2411979 | 2022-04-16 | Citrus | Florida | 12017 | 29539 | 973 |
2408723 | 2408723 | 2022-04-15 | Citrus | Florida | 12017 | 29539 | 973 |
2405467 | 2405467 | 2022-04-14 | Citrus | Florida | 12017 | 29539 | 973 |
2402212 | 2402212 | 2022-04-13 | Citrus | Florida | 12017 | 29539 | 973 |
2398957 | 2398957 | 2022-04-12 | Citrus | Florida | 12017 | 29539 | 969 |
2395702 | 2395702 | 2022-04-11 | Citrus | Florida | 12017 | 29539 | 969 |
2392446 | 2392446 | 2022-04-10 | Citrus | Florida | 12017 | 29539 | 969 |
2389190 | 2389190 | 2022-04-09 | Citrus | Florida | 12017 | 29539 | 969 |
2385935 | 2385935 | 2022-04-08 | Citrus | Florida | 12017 | 29539 | 969 |
2382680 | 2382680 | 2022-04-07 | Citrus | Florida | 12017 | 29491 | 969 |
2379425 | 2379425 | 2022-04-06 | Citrus | Florida | 12017 | 29491 | 969 |
2376171 | 2376171 | 2022-04-05 | Citrus | Florida | 12017 | 29491 | 965 |
2372919 | 2372919 | 2022-04-04 | Citrus | Florida | 12017 | 29491 | 965 |
2369666 | 2369666 | 2022-04-03 | Citrus | Florida | 12017 | 29491 | 965 |
2366413 | 2366413 | 2022-04-02 | Citrus | Florida | 12017 | 29491 | 965 |
2363160 | 2363160 | 2022-04-01 | Citrus | Florida | 12017 | 29491 | 965 |
2359906 | 2359906 | 2022-03-31 | Citrus | Florida | 12017 | 29491 | 965 |
2356652 | 2356652 | 2022-03-30 | Citrus | Florida | 12017 | 29491 | 965 |
2353399 | 2353399 | 2022-03-29 | Citrus | Florida | 12017 | 29491 | 962 |
2350147 | 2350147 | 2022-03-28 | Citrus | Florida | 12017 | 29491 | 962 |
2346894 | 2346894 | 2022-03-27 | Citrus | Florida | 12017 | 29491 | 962 |
2343641 | 2343641 | 2022-03-26 | Citrus | Florida | 12017 | 29491 | 962 |
2340388 | 2340388 | 2022-03-25 | Citrus | Florida | 12017 | 29491 | 962 |
2337135 | 2337135 | 2022-03-24 | Citrus | Florida | 12017 | 29404 | 962 |
2333881 | 2333881 | 2022-03-23 | Citrus | Florida | 12017 | 29404 | 950 |
2330627 | 2330627 | 2022-03-22 | Citrus | Florida | 12017 | 29404 | 950 |
2327375 | 2327375 | 2022-03-21 | Citrus | Florida | 12017 | 29404 | 950 |
2324122 | 2324122 | 2022-03-20 | Citrus | Florida | 12017 | 29404 | 950 |
2320868 | 2320868 | 2022-03-19 | Citrus | Florida | 12017 | 29404 | 950 |
2317614 | 2317614 | 2022-03-18 | Citrus | Florida | 12017 | 29404 | 950 |
2314361 | 2314361 | 2022-03-17 | Citrus | Florida | 12017 | 29404 | 950 |
2311108 | 2311108 | 2022-03-16 | Citrus | Florida | 12017 | 29404 | 950 |
2307855 | 2307855 | 2022-03-15 | Citrus | Florida | 12017 | 29404 | 944 |
2304604 | 2304604 | 2022-03-14 | Citrus | Florida | 12017 | 29404 | 944 |
2301352 | 2301352 | 2022-03-13 | Citrus | Florida | 12017 | 29404 | 944 |
2298100 | 2298100 | 2022-03-12 | Citrus | Florida | 12017 | 29404 | 944 |
2294848 | 2294848 | 2022-03-11 | Citrus | Florida | 12017 | 29404 | 944 |
2291596 | 2291596 | 2022-03-10 | Citrus | Florida | 12017 | 29347 | 944 |
2288344 | 2288344 | 2022-03-09 | Citrus | Florida | 12017 | 29347 | 944 |
2285093 | 2285093 | 2022-03-08 | Citrus | Florida | 12017 | 29347 | 933 |
2281841 | 2281841 | 2022-03-07 | Citrus | Florida | 12017 | 29347 | 933 |
2278588 | 2278588 | 2022-03-06 | Citrus | Florida | 12017 | 29347 | 933 |
2275335 | 2275335 | 2022-03-05 | Citrus | Florida | 12017 | 29347 | 933 |
2272082 | 2272082 | 2022-03-04 | Citrus | Florida | 12017 | 29347 | 933 |
2268830 | 2268830 | 2022-03-03 | Citrus | Florida | 12017 | 29219 | 933 |
2265577 | 2265577 | 2022-03-02 | Citrus | Florida | 12017 | 29219 | 933 |
2262326 | 2262326 | 2022-03-01 | Citrus | Florida | 12017 | 29219 | 925 |
2259075 | 2259075 | 2022-02-28 | Citrus | Florida | 12017 | 29219 | 925 |
2255824 | 2255824 | 2022-02-27 | Citrus | Florida | 12017 | 29219 | 925 |
2252573 | 2252573 | 2022-02-26 | Citrus | Florida | 12017 | 29219 | 925 |
2249322 | 2249322 | 2022-02-25 | Citrus | Florida | 12017 | 29219 | 925 |
2246071 | 2246071 | 2022-02-24 | Citrus | Florida | 12017 | 29041 | 925 |
2242820 | 2242820 | 2022-02-23 | Citrus | Florida | 12017 | 29041 | 925 |
2239569 | 2239569 | 2022-02-22 | Citrus | Florida | 12017 | 29041 | 907 |
2236318 | 2236318 | 2022-02-21 | Citrus | Florida | 12017 | 29041 | 907 |
2233067 | 2233067 | 2022-02-20 | Citrus | Florida | 12017 | 29041 | 907 |
2229816 | 2229816 | 2022-02-19 | Citrus | Florida | 12017 | 29041 | 907 |
2226565 | 2226565 | 2022-02-18 | Citrus | Florida | 12017 | 29041 | 907 |
2223314 | 2223314 | 2022-02-17 | Citrus | Florida | 12017 | 28654 | 907 |
2220063 | 2220063 | 2022-02-16 | Citrus | Florida | 12017 | 28654 | 907 |
2216812 | 2216812 | 2022-02-15 | Citrus | Florida | 12017 | 28654 | 891 |
2213561 | 2213561 | 2022-02-14 | Citrus | Florida | 12017 | 28654 | 891 |
2210309 | 2210309 | 2022-02-13 | Citrus | Florida | 12017 | 28654 | 891 |
2207056 | 2207056 | 2022-02-12 | Citrus | Florida | 12017 | 28654 | 891 |
2203803 | 2203803 | 2022-02-11 | Citrus | Florida | 12017 | 28654 | 891 |
2200550 | 2200550 | 2022-02-10 | Citrus | Florida | 12017 | 27941 | 891 |
2197296 | 2197296 | 2022-02-09 | Citrus | Florida | 12017 | 27941 | 891 |
2194042 | 2194042 | 2022-02-08 | Citrus | Florida | 12017 | 27941 | 864 |
2190788 | 2190788 | 2022-02-07 | Citrus | Florida | 12017 | 27941 | 864 |
2187535 | 2187535 | 2022-02-06 | Citrus | Florida | 12017 | 27941 | 864 |
2184282 | 2184282 | 2022-02-05 | Citrus | Florida | 12017 | 27941 | 864 |
2181030 | 2181030 | 2022-02-04 | Citrus | Florida | 12017 | 27941 | 864 |
2177779 | 2177779 | 2022-02-03 | Citrus | Florida | 12017 | 26800 | 864 |
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);