ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 12119 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 156 ✖
- 284 103
- 17 49
- 471 23
- 572 21
- 0 15
- 475 15
- 477 14
- 242 12
- 437 12
- 14 11
- 278 11
- 243 10
- 275 10
- 122 9
- 11 8
- 18 8
- 428 8
- 464 8
- 551 8
- 46 7
- 65 7
- 92 7
- 101 7
- 411 7
- 451 7
- 465 7
- 474 7
- 481 7
- 486 7
- 498 7
- 504 7
- 505 7
- 506 7
- 520 7
- 538 7
- 566 7
- 570 7
- 574 7
- 16 6
- 44 6
- 55 6
- 86 6
- 89 6
- 186 6
- 273 6
- 279 6
- 459 6
- 472 6
- 564 6
- 9 5
- 12 5
- 73 5
- 88 5
- 215 5
- 238 5
- 281 5
- 21 4
- 27 4
- 41 4
- 60 4
- 77 4
- 83 4
- 95 4
- 118 4
- 244 4
- 263 4
- 389 4
- 3 3
- 7 3
- 13 3
- 50 3
- 67 3
- 70 3
- 79 3
- 84 3
- 87 3
- 98 3
- 102 3
- 109 3
- 117 3
- 120 3
- 157 3
- 169 3
- 224 3
- 226 3
- 257 3
- 266 3
- 269 3
- 446 3
- 576 3
- 15 2
- 19 2
- 25 2
- 32 2
- 40 2
- 48 2
- 76 2
- 91 2
- 115 2
- 124 2
- 170 2
- 177 2
- 187 2
- 206 2
- 207 2
- 234 2
- 261 2
- 264 2
- 277 2
- 2 1
- 5 1
- 20 1
- 22 1
- 24 1
- 30 1
- 35 1
- 38 1
- 42 1
- 45 1
- 47 1
- 53 1
- 54 1
- 56 1
- 59 1
- 61 1
- 62 1
- 64 1
- 66 1
- 69 1
- 75 1
- 78 1
- 80 1
- 85 1
- 90 1
- 106 1
- 107 1
- 114 1
- 116 1
- 121 1
- 125 1
- 126 1
- 156 1
- 163 1
- 214 1
- 219 1
- 233 1
- 235 1
- 241 1
- 258 1
- 260 1
- 262 1
- 270 1
- 272 1
- 280 1
- 282 1
- 283 1
state 1
- Florida 787
fips 1
- 12119 · 787 ✖
county 1
- Sumter 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499957 | 2499957 | 2022-05-13 | Sumter | Florida | 12119 | 22305 | 576 |
2496699 | 2496699 | 2022-05-12 | Sumter | Florida | 12119 | 22305 | 576 |
2493441 | 2493441 | 2022-05-11 | Sumter | Florida | 12119 | 22305 | 576 |
2490183 | 2490183 | 2022-05-10 | Sumter | Florida | 12119 | 22305 | 574 |
2486926 | 2486926 | 2022-05-09 | Sumter | Florida | 12119 | 22305 | 574 |
2483668 | 2483668 | 2022-05-08 | Sumter | Florida | 12119 | 22305 | 574 |
2480410 | 2480410 | 2022-05-07 | Sumter | Florida | 12119 | 22305 | 574 |
2477152 | 2477152 | 2022-05-06 | Sumter | Florida | 12119 | 22305 | 574 |
2473894 | 2473894 | 2022-05-05 | Sumter | Florida | 12119 | 21960 | 574 |
2470637 | 2470637 | 2022-05-04 | Sumter | Florida | 12119 | 21960 | 574 |
2467381 | 2467381 | 2022-05-03 | Sumter | Florida | 12119 | 21960 | 572 |
2464126 | 2464126 | 2022-05-02 | Sumter | Florida | 12119 | 21960 | 572 |
2460870 | 2460870 | 2022-05-01 | Sumter | Florida | 12119 | 21960 | 572 |
2457614 | 2457614 | 2022-04-30 | Sumter | Florida | 12119 | 21960 | 572 |
2454358 | 2454358 | 2022-04-29 | Sumter | Florida | 12119 | 21960 | 572 |
2451102 | 2451102 | 2022-04-28 | Sumter | Florida | 12119 | 21960 | 572 |
2447846 | 2447846 | 2022-04-27 | Sumter | Florida | 12119 | 21960 | 572 |
2444590 | 2444590 | 2022-04-26 | Sumter | Florida | 12119 | 21960 | 572 |
2441334 | 2441334 | 2022-04-25 | Sumter | Florida | 12119 | 21960 | 572 |
2438078 | 2438078 | 2022-04-24 | Sumter | Florida | 12119 | 21960 | 572 |
2434822 | 2434822 | 2022-04-23 | Sumter | Florida | 12119 | 21960 | 572 |
2431566 | 2431566 | 2022-04-22 | Sumter | Florida | 12119 | 21960 | 572 |
2428310 | 2428310 | 2022-04-21 | Sumter | Florida | 12119 | 21747 | 572 |
2425054 | 2425054 | 2022-04-20 | Sumter | Florida | 12119 | 21747 | 572 |
2421798 | 2421798 | 2022-04-19 | Sumter | Florida | 12119 | 21747 | 572 |
2418542 | 2418542 | 2022-04-18 | Sumter | Florida | 12119 | 21747 | 572 |
2415286 | 2415286 | 2022-04-17 | Sumter | Florida | 12119 | 21747 | 572 |
2412030 | 2412030 | 2022-04-16 | Sumter | Florida | 12119 | 21747 | 572 |
2408774 | 2408774 | 2022-04-15 | Sumter | Florida | 12119 | 21747 | 572 |
2405518 | 2405518 | 2022-04-14 | Sumter | Florida | 12119 | 21747 | 572 |
2402263 | 2402263 | 2022-04-13 | Sumter | Florida | 12119 | 21747 | 572 |
2399008 | 2399008 | 2022-04-12 | Sumter | Florida | 12119 | 21747 | 570 |
2395753 | 2395753 | 2022-04-11 | Sumter | Florida | 12119 | 21747 | 570 |
2392497 | 2392497 | 2022-04-10 | Sumter | Florida | 12119 | 21747 | 570 |
2389241 | 2389241 | 2022-04-09 | Sumter | Florida | 12119 | 21747 | 570 |
2385986 | 2385986 | 2022-04-08 | Sumter | Florida | 12119 | 21747 | 570 |
2382731 | 2382731 | 2022-04-07 | Sumter | Florida | 12119 | 21641 | 570 |
2379476 | 2379476 | 2022-04-06 | Sumter | Florida | 12119 | 21641 | 570 |
2376222 | 2376222 | 2022-04-05 | Sumter | Florida | 12119 | 21641 | 566 |
2372970 | 2372970 | 2022-04-04 | Sumter | Florida | 12119 | 21641 | 566 |
2369717 | 2369717 | 2022-04-03 | Sumter | Florida | 12119 | 21641 | 566 |
2366464 | 2366464 | 2022-04-02 | Sumter | Florida | 12119 | 21641 | 566 |
2363211 | 2363211 | 2022-04-01 | Sumter | Florida | 12119 | 21641 | 566 |
2359957 | 2359957 | 2022-03-31 | Sumter | Florida | 12119 | 21641 | 566 |
2356703 | 2356703 | 2022-03-30 | Sumter | Florida | 12119 | 21641 | 566 |
2353450 | 2353450 | 2022-03-29 | Sumter | Florida | 12119 | 21641 | 564 |
2350198 | 2350198 | 2022-03-28 | Sumter | Florida | 12119 | 21641 | 564 |
2346945 | 2346945 | 2022-03-27 | Sumter | Florida | 12119 | 21641 | 564 |
2343692 | 2343692 | 2022-03-26 | Sumter | Florida | 12119 | 21641 | 564 |
2340439 | 2340439 | 2022-03-25 | Sumter | Florida | 12119 | 21641 | 564 |
2337186 | 2337186 | 2022-03-24 | Sumter | Florida | 12119 | 21550 | 564 |
2333932 | 2333932 | 2022-03-23 | Sumter | Florida | 12119 | 21550 | 551 |
2330678 | 2330678 | 2022-03-22 | Sumter | Florida | 12119 | 21550 | 551 |
2327426 | 2327426 | 2022-03-21 | Sumter | Florida | 12119 | 21550 | 551 |
2324173 | 2324173 | 2022-03-20 | Sumter | Florida | 12119 | 21550 | 551 |
2320919 | 2320919 | 2022-03-19 | Sumter | Florida | 12119 | 21550 | 551 |
2317665 | 2317665 | 2022-03-18 | Sumter | Florida | 12119 | 21550 | 551 |
2314412 | 2314412 | 2022-03-17 | Sumter | Florida | 12119 | 21550 | 551 |
2311159 | 2311159 | 2022-03-16 | Sumter | Florida | 12119 | 21550 | 551 |
2307906 | 2307906 | 2022-03-15 | Sumter | Florida | 12119 | 21550 | 538 |
2304655 | 2304655 | 2022-03-14 | Sumter | Florida | 12119 | 21550 | 538 |
2301403 | 2301403 | 2022-03-13 | Sumter | Florida | 12119 | 21550 | 538 |
2298151 | 2298151 | 2022-03-12 | Sumter | Florida | 12119 | 21550 | 538 |
2294899 | 2294899 | 2022-03-11 | Sumter | Florida | 12119 | 21550 | 538 |
2291647 | 2291647 | 2022-03-10 | Sumter | Florida | 12119 | 21466 | 538 |
2288395 | 2288395 | 2022-03-09 | Sumter | Florida | 12119 | 21466 | 538 |
2285144 | 2285144 | 2022-03-08 | Sumter | Florida | 12119 | 21466 | 520 |
2281892 | 2281892 | 2022-03-07 | Sumter | Florida | 12119 | 21466 | 520 |
2278639 | 2278639 | 2022-03-06 | Sumter | Florida | 12119 | 21466 | 520 |
2275386 | 2275386 | 2022-03-05 | Sumter | Florida | 12119 | 21466 | 520 |
2272133 | 2272133 | 2022-03-04 | Sumter | Florida | 12119 | 21466 | 520 |
2268881 | 2268881 | 2022-03-03 | Sumter | Florida | 12119 | 21343 | 520 |
2265628 | 2265628 | 2022-03-02 | Sumter | Florida | 12119 | 21343 | 520 |
2262377 | 2262377 | 2022-03-01 | Sumter | Florida | 12119 | 21343 | 506 |
2259126 | 2259126 | 2022-02-28 | Sumter | Florida | 12119 | 21343 | 506 |
2255875 | 2255875 | 2022-02-27 | Sumter | Florida | 12119 | 21343 | 506 |
2252624 | 2252624 | 2022-02-26 | Sumter | Florida | 12119 | 21343 | 506 |
2249373 | 2249373 | 2022-02-25 | Sumter | Florida | 12119 | 21343 | 506 |
2246122 | 2246122 | 2022-02-24 | Sumter | Florida | 12119 | 21144 | 506 |
2242871 | 2242871 | 2022-02-23 | Sumter | Florida | 12119 | 21144 | 506 |
2239620 | 2239620 | 2022-02-22 | Sumter | Florida | 12119 | 21144 | 505 |
2236369 | 2236369 | 2022-02-21 | Sumter | Florida | 12119 | 21144 | 505 |
2233118 | 2233118 | 2022-02-20 | Sumter | Florida | 12119 | 21144 | 505 |
2229867 | 2229867 | 2022-02-19 | Sumter | Florida | 12119 | 21144 | 505 |
2226616 | 2226616 | 2022-02-18 | Sumter | Florida | 12119 | 21144 | 505 |
2223365 | 2223365 | 2022-02-17 | Sumter | Florida | 12119 | 20796 | 505 |
2220114 | 2220114 | 2022-02-16 | Sumter | Florida | 12119 | 20796 | 505 |
2216863 | 2216863 | 2022-02-15 | Sumter | Florida | 12119 | 20796 | 504 |
2213612 | 2213612 | 2022-02-14 | Sumter | Florida | 12119 | 20796 | 504 |
2210360 | 2210360 | 2022-02-13 | Sumter | Florida | 12119 | 20796 | 504 |
2207107 | 2207107 | 2022-02-12 | Sumter | Florida | 12119 | 20796 | 504 |
2203854 | 2203854 | 2022-02-11 | Sumter | Florida | 12119 | 20796 | 504 |
2200601 | 2200601 | 2022-02-10 | Sumter | Florida | 12119 | 20225 | 504 |
2197347 | 2197347 | 2022-02-09 | Sumter | Florida | 12119 | 20225 | 504 |
2194093 | 2194093 | 2022-02-08 | Sumter | Florida | 12119 | 20225 | 498 |
2190839 | 2190839 | 2022-02-07 | Sumter | Florida | 12119 | 20225 | 498 |
2187586 | 2187586 | 2022-02-06 | Sumter | Florida | 12119 | 20225 | 498 |
2184333 | 2184333 | 2022-02-05 | Sumter | Florida | 12119 | 20225 | 498 |
2181081 | 2181081 | 2022-02-04 | Sumter | Florida | 12119 | 20225 | 498 |
2177830 | 2177830 | 2022-02-03 | Sumter | Florida | 12119 | 19492 | 498 |
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);