ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Collier" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 274 ✖
- 551 104
- 0 19
- 869 18
- 962 14
- 992 14
- 998 14
- 773 12
- 505 8
- 720 8
- 854 8
- 878 8
- 980 8
- 49 7
- 85 7
- 719 7
- 833 7
- 862 7
- 881 7
- 884 7
- 886 7
- 889 7
- 894 7
- 904 7
- 926 7
- 946 7
- 969 7
- 970 7
- 987 7
- 995 7
- 256 6
- 849 6
- 875 6
- 984 6
- 3 5
- 27 5
- 60 5
- 267 5
- 490 5
- 492 5
- 542 5
- 544 5
- 867 5
- 1 4
- 2 4
- 15 4
- 37 4
- 192 4
- 228 4
- 259 4
- 280 4
- 386 4
- 516 4
- 538 4
- 713 4
- 5 3
- 8 3
- 21 3
- 46 3
- 57 3
- 64 3
- 70 3
- 94 3
- 117 3
- 124 3
- 163 3
- 176 3
- 184 3
- 202 3
- 216 3
- 249 3
- 253 3
- 255 3
- 279 3
- 363 3
- 404 3
- 422 3
- 459 3
- 465 3
- 481 3
- 506 3
- 514 3
- 528 3
- 539 3
- 823 3
- 1000 3
- 4 2
- 10 2
- 40 2
- 45 2
- 56 2
- 59 2
- 61 2
- 71 2
- 107 2
- 114 2
- 120 2
- 129 2
- 136 2
- 151 2
- 180 2
- 211 2
- 234 2
- 237 2
- 239 2
- 268 2
- 273 2
- 276 2
- 303 2
- 308 2
- 310 2
- 315 2
- 317 2
- 325 2
- 326 2
- 332 2
- 339 2
- 420 2
- 430 2
- 440 2
- 443 2
- 461 2
- 472 2
- 498 2
- 517 2
- 531 2
- 533 2
- 535 2
- 6 1
- 9 1
- 14 1
- 16 1
- 17 1
- 19 1
- 22 1
- 25 1
- 28 1
- 32 1
- 34 1
- 35 1
- 41 1
- 42 1
- 53 1
- 55 1
- 65 1
- 67 1
- 74 1
- 81 1
- 82 1
- 91 1
- 96 1
- 99 1
- 100 1
- 104 1
- 105 1
- 109 1
- 118 1
- 121 1
- 122 1
- 130 1
- 131 1
- 133 1
- 143 1
- 146 1
- 148 1
- 152 1
- 154 1
- 159 1
- 160 1
- 161 1
- 162 1
- 166 1
- 170 1
- 172 1
- 174 1
- 177 1
- 181 1
- 182 1
- 187 1
- 188 1
- 193 1
- 194 1
- 196 1
- 201 1
- 205 1
- 208 1
- 218 1
- 221 1
- 224 1
- 225 1
- 230 1
- 232 1
- 242 1
- 243 1
- 244 1
- 245 1
- 246 1
- 251 1
- 260 1
- 261 1
- 265 1
- 269 1
- 281 1
- 284 1
- 285 1
- 289 1
- 293 1
- 294 1
- 295 1
- 299 1
- 306 1
- 312 1
- 314 1
- 321 1
- 322 1
- 328 1
- 331 1
- 333 1
- 341 1
- 346 1
- 350 1
- 354 1
- 360 1
- 361 1
- 367 1
- 370 1
- 371 1
- 375 1
- 376 1
- 377 1
- 381 1
- 382 1
- 394 1
- 396 1
- 398 1
- 402 1
- 403 1
- 410 1
- 413 1
- 414 1
- 419 1
- 426 1
- 428 1
- 431 1
- 433 1
- 434 1
- 438 1
- 448 1
- 450 1
- 452 1
- 462 1
- 463 1
- 464 1
- 469 1
- 477 1
- 479 1
- 480 1
- 484 1
- 488 1
- 496 1
- 500 1
- 504 1
- 507 1
- 510 1
- 515 1
- 522 1
- 524 1
- 525 1
- 527 1
- 530 1
- 532 1
- 536 1
- 540 1
- 543 1
- 549 1
state 1
- Florida 795
fips 1
- 12021 795
county 1
- Collier · 795 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499908 | 2499908 | 2022-05-13 | Collier | Florida | 12021 | 85078 | 1000 |
2496650 | 2496650 | 2022-05-12 | Collier | Florida | 12021 | 85078 | 1000 |
2493392 | 2493392 | 2022-05-11 | Collier | Florida | 12021 | 85078 | 1000 |
2490134 | 2490134 | 2022-05-10 | Collier | Florida | 12021 | 85078 | 998 |
2486877 | 2486877 | 2022-05-09 | Collier | Florida | 12021 | 85078 | 998 |
2483619 | 2483619 | 2022-05-08 | Collier | Florida | 12021 | 85078 | 998 |
2480361 | 2480361 | 2022-05-07 | Collier | Florida | 12021 | 85078 | 998 |
2477103 | 2477103 | 2022-05-06 | Collier | Florida | 12021 | 85078 | 998 |
2473845 | 2473845 | 2022-05-05 | Collier | Florida | 12021 | 84241 | 998 |
2470588 | 2470588 | 2022-05-04 | Collier | Florida | 12021 | 84241 | 998 |
2467332 | 2467332 | 2022-05-03 | Collier | Florida | 12021 | 84241 | 998 |
2464077 | 2464077 | 2022-05-02 | Collier | Florida | 12021 | 84241 | 998 |
2460821 | 2460821 | 2022-05-01 | Collier | Florida | 12021 | 84241 | 998 |
2457565 | 2457565 | 2022-04-30 | Collier | Florida | 12021 | 84241 | 998 |
2454309 | 2454309 | 2022-04-29 | Collier | Florida | 12021 | 84241 | 998 |
2451053 | 2451053 | 2022-04-28 | Collier | Florida | 12021 | 84241 | 998 |
2447797 | 2447797 | 2022-04-27 | Collier | Florida | 12021 | 84241 | 998 |
2444541 | 2444541 | 2022-04-26 | Collier | Florida | 12021 | 84241 | 995 |
2441285 | 2441285 | 2022-04-25 | Collier | Florida | 12021 | 84241 | 995 |
2438029 | 2438029 | 2022-04-24 | Collier | Florida | 12021 | 84241 | 995 |
2434773 | 2434773 | 2022-04-23 | Collier | Florida | 12021 | 84241 | 995 |
2431517 | 2431517 | 2022-04-22 | Collier | Florida | 12021 | 84241 | 995 |
2428261 | 2428261 | 2022-04-21 | Collier | Florida | 12021 | 83668 | 995 |
2425005 | 2425005 | 2022-04-20 | Collier | Florida | 12021 | 83668 | 995 |
2421749 | 2421749 | 2022-04-19 | Collier | Florida | 12021 | 83668 | 992 |
2418493 | 2418493 | 2022-04-18 | Collier | Florida | 12021 | 83668 | 992 |
2415237 | 2415237 | 2022-04-17 | Collier | Florida | 12021 | 83668 | 992 |
2411981 | 2411981 | 2022-04-16 | Collier | Florida | 12021 | 83668 | 992 |
2408725 | 2408725 | 2022-04-15 | Collier | Florida | 12021 | 83668 | 992 |
2405469 | 2405469 | 2022-04-14 | Collier | Florida | 12021 | 83668 | 992 |
2402214 | 2402214 | 2022-04-13 | Collier | Florida | 12021 | 83668 | 992 |
2398959 | 2398959 | 2022-04-12 | Collier | Florida | 12021 | 83668 | 992 |
2395704 | 2395704 | 2022-04-11 | Collier | Florida | 12021 | 83668 | 992 |
2392448 | 2392448 | 2022-04-10 | Collier | Florida | 12021 | 83668 | 992 |
2389192 | 2389192 | 2022-04-09 | Collier | Florida | 12021 | 83668 | 992 |
2385937 | 2385937 | 2022-04-08 | Collier | Florida | 12021 | 83668 | 992 |
2382682 | 2382682 | 2022-04-07 | Collier | Florida | 12021 | 83299 | 992 |
2379427 | 2379427 | 2022-04-06 | Collier | Florida | 12021 | 83299 | 992 |
2376173 | 2376173 | 2022-04-05 | Collier | Florida | 12021 | 83299 | 987 |
2372921 | 2372921 | 2022-04-04 | Collier | Florida | 12021 | 83299 | 987 |
2369668 | 2369668 | 2022-04-03 | Collier | Florida | 12021 | 83299 | 987 |
2366415 | 2366415 | 2022-04-02 | Collier | Florida | 12021 | 83299 | 987 |
2363162 | 2363162 | 2022-04-01 | Collier | Florida | 12021 | 83299 | 987 |
2359908 | 2359908 | 2022-03-31 | Collier | Florida | 12021 | 83299 | 987 |
2356654 | 2356654 | 2022-03-30 | Collier | Florida | 12021 | 83299 | 987 |
2353401 | 2353401 | 2022-03-29 | Collier | Florida | 12021 | 83299 | 984 |
2350149 | 2350149 | 2022-03-28 | Collier | Florida | 12021 | 83299 | 984 |
2346896 | 2346896 | 2022-03-27 | Collier | Florida | 12021 | 83299 | 984 |
2343643 | 2343643 | 2022-03-26 | Collier | Florida | 12021 | 83299 | 984 |
2340390 | 2340390 | 2022-03-25 | Collier | Florida | 12021 | 83299 | 984 |
2337137 | 2337137 | 2022-03-24 | Collier | Florida | 12021 | 82944 | 984 |
2333883 | 2333883 | 2022-03-23 | Collier | Florida | 12021 | 82944 | 980 |
2330629 | 2330629 | 2022-03-22 | Collier | Florida | 12021 | 82944 | 980 |
2327377 | 2327377 | 2022-03-21 | Collier | Florida | 12021 | 82944 | 980 |
2324124 | 2324124 | 2022-03-20 | Collier | Florida | 12021 | 82944 | 980 |
2320870 | 2320870 | 2022-03-19 | Collier | Florida | 12021 | 82944 | 980 |
2317616 | 2317616 | 2022-03-18 | Collier | Florida | 12021 | 82944 | 980 |
2314363 | 2314363 | 2022-03-17 | Collier | Florida | 12021 | 82944 | 980 |
2311110 | 2311110 | 2022-03-16 | Collier | Florida | 12021 | 82944 | 980 |
2307857 | 2307857 | 2022-03-15 | Collier | Florida | 12021 | 82944 | 969 |
2304606 | 2304606 | 2022-03-14 | Collier | Florida | 12021 | 82944 | 969 |
2301354 | 2301354 | 2022-03-13 | Collier | Florida | 12021 | 82944 | 969 |
2298102 | 2298102 | 2022-03-12 | Collier | Florida | 12021 | 82944 | 969 |
2294850 | 2294850 | 2022-03-11 | Collier | Florida | 12021 | 82944 | 969 |
2291598 | 2291598 | 2022-03-10 | Collier | Florida | 12021 | 82787 | 969 |
2288346 | 2288346 | 2022-03-09 | Collier | Florida | 12021 | 82787 | 969 |
2285095 | 2285095 | 2022-03-08 | Collier | Florida | 12021 | 82787 | 962 |
2281843 | 2281843 | 2022-03-07 | Collier | Florida | 12021 | 82787 | 962 |
2278590 | 2278590 | 2022-03-06 | Collier | Florida | 12021 | 82787 | 962 |
2275337 | 2275337 | 2022-03-05 | Collier | Florida | 12021 | 82787 | 962 |
2272084 | 2272084 | 2022-03-04 | Collier | Florida | 12021 | 82787 | 962 |
2268832 | 2268832 | 2022-03-03 | Collier | Florida | 12021 | 82571 | 962 |
2265579 | 2265579 | 2022-03-02 | Collier | Florida | 12021 | 82571 | 962 |
2262328 | 2262328 | 2022-03-01 | Collier | Florida | 12021 | 82571 | 970 |
2259077 | 2259077 | 2022-02-28 | Collier | Florida | 12021 | 82571 | 970 |
2255826 | 2255826 | 2022-02-27 | Collier | Florida | 12021 | 82571 | 970 |
2252575 | 2252575 | 2022-02-26 | Collier | Florida | 12021 | 82571 | 970 |
2249324 | 2249324 | 2022-02-25 | Collier | Florida | 12021 | 82571 | 970 |
2246073 | 2246073 | 2022-02-24 | Collier | Florida | 12021 | 82205 | 970 |
2242822 | 2242822 | 2022-02-23 | Collier | Florida | 12021 | 82205 | 970 |
2239571 | 2239571 | 2022-02-22 | Collier | Florida | 12021 | 82205 | 962 |
2236320 | 2236320 | 2022-02-21 | Collier | Florida | 12021 | 82205 | 962 |
2233069 | 2233069 | 2022-02-20 | Collier | Florida | 12021 | 82205 | 962 |
2229818 | 2229818 | 2022-02-19 | Collier | Florida | 12021 | 82205 | 962 |
2226567 | 2226567 | 2022-02-18 | Collier | Florida | 12021 | 82205 | 962 |
2223316 | 2223316 | 2022-02-17 | Collier | Florida | 12021 | 81561 | 962 |
2220065 | 2220065 | 2022-02-16 | Collier | Florida | 12021 | 81561 | 962 |
2216814 | 2216814 | 2022-02-15 | Collier | Florida | 12021 | 81561 | 946 |
2213563 | 2213563 | 2022-02-14 | Collier | Florida | 12021 | 81561 | 946 |
2210311 | 2210311 | 2022-02-13 | Collier | Florida | 12021 | 81561 | 946 |
2207058 | 2207058 | 2022-02-12 | Collier | Florida | 12021 | 81561 | 946 |
2203805 | 2203805 | 2022-02-11 | Collier | Florida | 12021 | 81561 | 946 |
2200552 | 2200552 | 2022-02-10 | Collier | Florida | 12021 | 80296 | 946 |
2197298 | 2197298 | 2022-02-09 | Collier | Florida | 12021 | 80296 | 946 |
2194044 | 2194044 | 2022-02-08 | Collier | Florida | 12021 | 80296 | 926 |
2190790 | 2190790 | 2022-02-07 | Collier | Florida | 12021 | 80296 | 926 |
2187537 | 2187537 | 2022-02-06 | Collier | Florida | 12021 | 80296 | 926 |
2184284 | 2184284 | 2022-02-05 | Collier | Florida | 12021 | 80296 | 926 |
2181032 | 2181032 | 2022-02-04 | Collier | Florida | 12021 | 80296 | 926 |
2177781 | 2177781 | 2022-02-03 | Collier | Florida | 12021 | 78527 | 926 |
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);