ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Collier" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
596302 | 596302 | 2020-10-04 | Collier | Florida | 12021 | 12909 | 228 |
593060 | 593060 | 2020-10-03 | Collier | Florida | 12021 | 12862 | 228 |
589820 | 589820 | 2020-10-02 | Collier | Florida | 12021 | 12811 | 225 |
586579 | 586579 | 2020-10-01 | Collier | Florida | 12021 | 12789 | 224 |
583339 | 583339 | 2020-09-30 | Collier | Florida | 12021 | 12751 | 221 |
580100 | 580100 | 2020-09-29 | Collier | Florida | 12021 | 12732 | 218 |
576859 | 576859 | 2020-09-28 | Collier | Florida | 12021 | 12692 | 216 |
573616 | 573616 | 2020-09-27 | Collier | Florida | 12021 | 12681 | 216 |
570374 | 570374 | 2020-09-26 | Collier | Florida | 12021 | 12656 | 216 |
567132 | 567132 | 2020-09-25 | Collier | Florida | 12021 | 12617 | 211 |
563892 | 563892 | 2020-09-24 | Collier | Florida | 12021 | 12588 | 211 |
560652 | 560652 | 2020-09-23 | Collier | Florida | 12021 | 12565 | 208 |
557416 | 557416 | 2020-09-22 | Collier | Florida | 12021 | 12520 | 205 |
554179 | 554179 | 2020-09-21 | Collier | Florida | 12021 | 12487 | 202 |
550940 | 550940 | 2020-09-20 | Collier | Florida | 12021 | 12466 | 202 |
547701 | 547701 | 2020-09-19 | Collier | Florida | 12021 | 12423 | 202 |
544463 | 544463 | 2020-09-18 | Collier | Florida | 12021 | 12368 | 201 |
541227 | 541227 | 2020-09-17 | Collier | Florida | 12021 | 12324 | 196 |
537990 | 537990 | 2020-09-16 | Collier | Florida | 12021 | 12272 | 194 |
534754 | 534754 | 2020-09-15 | Collier | Florida | 12021 | 12254 | 193 |
531519 | 531519 | 2020-09-14 | Collier | Florida | 12021 | 12234 | 192 |
528282 | 528282 | 2020-09-13 | Collier | Florida | 12021 | 12209 | 192 |
525046 | 525046 | 2020-09-12 | Collier | Florida | 12021 | 12169 | 192 |
521810 | 521810 | 2020-09-11 | Collier | Florida | 12021 | 12132 | 192 |
518573 | 518573 | 2020-09-10 | Collier | Florida | 12021 | 12096 | 188 |
515338 | 515338 | 2020-09-09 | Collier | Florida | 12021 | 12071 | 187 |
512105 | 512105 | 2020-09-08 | Collier | Florida | 12021 | 12049 | 184 |
508872 | 508872 | 2020-09-07 | Collier | Florida | 12021 | 12024 | 184 |
505640 | 505640 | 2020-09-06 | Collier | Florida | 12021 | 11994 | 184 |
502406 | 502406 | 2020-09-05 | Collier | Florida | 12021 | 11951 | 182 |
499172 | 499172 | 2020-09-04 | Collier | Florida | 12021 | 11893 | 181 |
495939 | 495939 | 2020-09-03 | Collier | Florida | 12021 | 11853 | 180 |
492705 | 492705 | 2020-09-02 | Collier | Florida | 12021 | 11819 | 180 |
489472 | 489472 | 2020-09-01 | Collier | Florida | 12021 | 11796 | 177 |
486239 | 486239 | 2020-08-31 | Collier | Florida | 12021 | 11609 | 176 |
483004 | 483004 | 2020-08-30 | Collier | Florida | 12021 | 11604 | 176 |
479770 | 479770 | 2020-08-29 | Collier | Florida | 12021 | 11570 | 176 |
476537 | 476537 | 2020-08-28 | Collier | Florida | 12021 | 11517 | 174 |
473304 | 473304 | 2020-08-27 | Collier | Florida | 12021 | 11471 | 172 |
470072 | 470072 | 2020-08-26 | Collier | Florida | 12021 | 11376 | 170 |
466843 | 466843 | 2020-08-25 | Collier | Florida | 12021 | 11351 | 166 |
463614 | 463614 | 2020-08-24 | Collier | Florida | 12021 | 11268 | 163 |
460385 | 460385 | 2020-08-23 | Collier | Florida | 12021 | 11245 | 163 |
457158 | 457158 | 2020-08-22 | Collier | Florida | 12021 | 11201 | 163 |
453930 | 453930 | 2020-08-21 | Collier | Florida | 12021 | 11144 | 162 |
450702 | 450702 | 2020-08-20 | Collier | Florida | 12021 | 11095 | 161 |
447474 | 447474 | 2020-08-19 | Collier | Florida | 12021 | 11016 | 160 |
444247 | 444247 | 2020-08-18 | Collier | Florida | 12021 | 10977 | 159 |
441021 | 441021 | 2020-08-17 | Collier | Florida | 12021 | 10918 | 154 |
437795 | 437795 | 2020-08-16 | Collier | Florida | 12021 | 10891 | 152 |
434569 | 434569 | 2020-08-15 | Collier | Florida | 12021 | 10840 | 151 |
431344 | 431344 | 2020-08-14 | Collier | Florida | 12021 | 10734 | 151 |
428116 | 428116 | 2020-08-13 | Collier | Florida | 12021 | 10640 | 148 |
424892 | 424892 | 2020-08-12 | Collier | Florida | 12021 | 10530 | 146 |
421671 | 421671 | 2020-08-11 | Collier | Florida | 12021 | 10487 | 143 |
418450 | 418450 | 2020-08-10 | Collier | Florida | 12021 | 10448 | 136 |
415229 | 415229 | 2020-08-09 | Collier | Florida | 12021 | 10334 | 136 |
412009 | 412009 | 2020-08-08 | Collier | Florida | 12021 | 10265 | 133 |
408790 | 408790 | 2020-08-07 | Collier | Florida | 12021 | 10202 | 131 |
405570 | 405570 | 2020-08-06 | Collier | Florida | 12021 | 10118 | 130 |
402352 | 402352 | 2020-08-05 | Collier | Florida | 12021 | 10050 | 129 |
399136 | 399136 | 2020-08-04 | Collier | Florida | 12021 | 9897 | 129 |
395920 | 395920 | 2020-08-03 | Collier | Florida | 12021 | 9811 | 124 |
392704 | 392704 | 2020-08-02 | Collier | Florida | 12021 | 9734 | 124 |
389487 | 389487 | 2020-08-01 | Collier | Florida | 12021 | 9662 | 124 |
386270 | 386270 | 2020-07-31 | Collier | Florida | 12021 | 9581 | 122 |
383052 | 383052 | 2020-07-30 | Collier | Florida | 12021 | 9355 | 121 |
379835 | 379835 | 2020-07-29 | Collier | Florida | 12021 | 9178 | 120 |
376618 | 376618 | 2020-07-28 | Collier | Florida | 12021 | 9069 | 120 |
373404 | 373404 | 2020-07-27 | Collier | Florida | 12021 | 8870 | 118 |
370192 | 370192 | 2020-07-26 | Collier | Florida | 12021 | 8795 | 117 |
366982 | 366982 | 2020-07-25 | Collier | Florida | 12021 | 8725 | 117 |
363775 | 363775 | 2020-07-24 | Collier | Florida | 12021 | 8601 | 117 |
360568 | 360568 | 2020-07-23 | Collier | Florida | 12021 | 8401 | 114 |
357363 | 357363 | 2020-07-22 | Collier | Florida | 12021 | 8249 | 114 |
354160 | 354160 | 2020-07-21 | Collier | Florida | 12021 | 8076 | 109 |
350958 | 350958 | 2020-07-20 | Collier | Florida | 12021 | 7934 | 107 |
347757 | 347757 | 2020-07-19 | Collier | Florida | 12021 | 7815 | 107 |
344557 | 344557 | 2020-07-18 | Collier | Florida | 12021 | 7577 | 105 |
341358 | 341358 | 2020-07-17 | Collier | Florida | 12021 | 7314 | 104 |
338161 | 338161 | 2020-07-16 | Collier | Florida | 12021 | 7076 | 100 |
334966 | 334966 | 2020-07-15 | Collier | Florida | 12021 | 6872 | 99 |
331773 | 331773 | 2020-07-14 | Collier | Florida | 12021 | 6731 | 96 |
328586 | 328586 | 2020-07-13 | Collier | Florida | 12021 | 6465 | 94 |
325400 | 325400 | 2020-07-12 | Collier | Florida | 12021 | 6220 | 94 |
322219 | 322219 | 2020-07-11 | Collier | Florida | 12021 | 5968 | 94 |
319040 | 319040 | 2020-07-10 | Collier | Florida | 12021 | 5777 | 91 |
315867 | 315867 | 2020-07-09 | Collier | Florida | 12021 | 5577 | 85 |
312692 | 312692 | 2020-07-08 | Collier | Florida | 12021 | 5433 | 85 |
309522 | 309522 | 2020-07-07 | Collier | Florida | 12021 | 5201 | 85 |
306354 | 306354 | 2020-07-06 | Collier | Florida | 12021 | 5076 | 85 |
303190 | 303190 | 2020-07-05 | Collier | Florida | 12021 | 5019 | 85 |
300026 | 300026 | 2020-07-04 | Collier | Florida | 12021 | 4880 | 85 |
296864 | 296864 | 2020-07-03 | Collier | Florida | 12021 | 4701 | 85 |
293708 | 293708 | 2020-07-02 | Collier | Florida | 12021 | 4539 | 82 |
290554 | 290554 | 2020-07-01 | Collier | Florida | 12021 | 4376 | 81 |
287403 | 287403 | 2020-06-30 | Collier | Florida | 12021 | 4225 | 74 |
284257 | 284257 | 2020-06-29 | Collier | Florida | 12021 | 4147 | 71 |
281111 | 281111 | 2020-06-28 | Collier | Florida | 12021 | 4087 | 71 |
277964 | 277964 | 2020-06-27 | Collier | Florida | 12021 | 3966 | 70 |
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);