ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where deaths = 77 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467343 | 2467343 | 2022-05-03 | Gulf | Florida | 12045 | 4283 | 77 |
2464088 | 2464088 | 2022-05-02 | Gulf | Florida | 12045 | 4283 | 77 |
2460832 | 2460832 | 2022-05-01 | Gulf | Florida | 12045 | 4283 | 77 |
2457576 | 2457576 | 2022-04-30 | Gulf | Florida | 12045 | 4283 | 77 |
2454320 | 2454320 | 2022-04-29 | Gulf | Florida | 12045 | 4283 | 77 |
2451064 | 2451064 | 2022-04-28 | Gulf | Florida | 12045 | 4283 | 77 |
2447808 | 2447808 | 2022-04-27 | Gulf | Florida | 12045 | 4283 | 77 |
1846241 | 1846241 | 2021-10-24 | Taylor | Florida | 12123 | 4582 | 77 |
1842991 | 1842991 | 2021-10-23 | Taylor | Florida | 12123 | 4582 | 77 |
1839741 | 1839741 | 2021-10-22 | Taylor | Florida | 12123 | 4582 | 77 |
1836492 | 1836492 | 2021-10-21 | Taylor | Florida | 12123 | 4572 | 77 |
1833243 | 1833243 | 2021-10-20 | Taylor | Florida | 12123 | 4572 | 77 |
1829994 | 1829994 | 2021-10-19 | Taylor | Florida | 12123 | 4572 | 77 |
1826745 | 1826745 | 2021-10-18 | Taylor | Florida | 12123 | 4572 | 77 |
1823496 | 1823496 | 2021-10-17 | Taylor | Florida | 12123 | 4572 | 77 |
1820247 | 1820247 | 2021-10-16 | Taylor | Florida | 12123 | 4572 | 77 |
1816998 | 1816998 | 2021-10-15 | Taylor | Florida | 12123 | 4572 | 77 |
1216192 | 1216192 | 2021-04-13 | Hendry | Florida | 12051 | 4555 | 77 |
1212945 | 1212945 | 2021-04-12 | Hendry | Florida | 12051 | 4543 | 77 |
1209697 | 1209697 | 2021-04-11 | Hendry | Florida | 12051 | 4542 | 77 |
1206448 | 1206448 | 2021-04-10 | Hendry | Florida | 12051 | 4533 | 77 |
1203200 | 1203200 | 2021-04-09 | Hendry | Florida | 12051 | 4525 | 77 |
1199952 | 1199952 | 2021-04-08 | Hendry | Florida | 12051 | 4514 | 77 |
1196703 | 1196703 | 2021-04-07 | Hendry | Florida | 12051 | 4504 | 77 |
1193455 | 1193455 | 2021-04-06 | Hendry | Florida | 12051 | 4495 | 77 |
1190205 | 1190205 | 2021-04-05 | Hendry | Florida | 12051 | 4482 | 77 |
1186958 | 1186958 | 2021-04-04 | Hendry | Florida | 12051 | 4482 | 77 |
1183711 | 1183711 | 2021-04-03 | Hendry | Florida | 12051 | 4479 | 77 |
1180464 | 1180464 | 2021-04-02 | Hendry | Florida | 12051 | 4474 | 77 |
1177217 | 1177217 | 2021-04-01 | Hendry | Florida | 12051 | 4470 | 77 |
1173970 | 1173970 | 2021-03-31 | Hendry | Florida | 12051 | 4466 | 77 |
1170723 | 1170723 | 2021-03-30 | Hendry | Florida | 12051 | 4464 | 77 |
1167475 | 1167475 | 2021-03-29 | Hendry | Florida | 12051 | 4460 | 77 |
1164227 | 1164227 | 2021-03-28 | Hendry | Florida | 12051 | 4458 | 77 |
1160979 | 1160979 | 2021-03-27 | Hendry | Florida | 12051 | 4457 | 77 |
1157731 | 1157731 | 2021-03-26 | Hendry | Florida | 12051 | 4455 | 77 |
1154484 | 1154484 | 2021-03-25 | Hendry | Florida | 12051 | 4446 | 77 |
1151237 | 1151237 | 2021-03-24 | Hendry | Florida | 12051 | 4442 | 77 |
1147990 | 1147990 | 2021-03-23 | Hendry | Florida | 12051 | 4435 | 77 |
1144743 | 1144743 | 2021-03-22 | Hendry | Florida | 12051 | 4428 | 77 |
1141496 | 1141496 | 2021-03-21 | Hendry | Florida | 12051 | 4425 | 77 |
1115511 | 1115511 | 2021-03-13 | DeSoto | Florida | 12027 | 3931 | 77 |
1112265 | 1112265 | 2021-03-12 | DeSoto | Florida | 12027 | 3920 | 77 |
1027879 | 1027879 | 2021-02-14 | Gadsden | Florida | 12039 | 5321 | 77 |
1024634 | 1024634 | 2021-02-13 | Gadsden | Florida | 12039 | 5312 | 77 |
1021389 | 1021389 | 2021-02-12 | Gadsden | Florida | 12039 | 5295 | 77 |
1011652 | 1011652 | 2021-02-09 | Flagler | Florida | 12035 | 5518 | 77 |
680690 | 680690 | 2020-10-30 | Suwannee | Florida | 12121 | 3010 | 77 |
677447 | 677447 | 2020-10-29 | Suwannee | Florida | 12121 | 2999 | 77 |
674204 | 674204 | 2020-10-28 | Suwannee | Florida | 12121 | 2989 | 77 |
670962 | 670962 | 2020-10-27 | Suwannee | Florida | 12121 | 2983 | 77 |
667719 | 667719 | 2020-10-26 | Suwannee | Florida | 12121 | 2976 | 77 |
664474 | 664474 | 2020-10-25 | Suwannee | Florida | 12121 | 2972 | 77 |
661230 | 661230 | 2020-10-24 | Suwannee | Florida | 12121 | 2967 | 77 |
657986 | 657986 | 2020-10-23 | Suwannee | Florida | 12121 | 2956 | 77 |
648252 | 648252 | 2020-10-20 | Suwannee | Florida | 12121 | 2935 | 77 |
645007 | 645007 | 2020-10-19 | Suwannee | Florida | 12121 | 2922 | 77 |
641759 | 641759 | 2020-10-18 | Suwannee | Florida | 12121 | 2919 | 77 |
638512 | 638512 | 2020-10-17 | Suwannee | Florida | 12121 | 2916 | 77 |
628774 | 628774 | 2020-10-14 | St. Johns | Florida | 12109 | 5814 | 77 |
628776 | 628776 | 2020-10-14 | Sumter | Florida | 12119 | 2700 | 77 |
625531 | 625531 | 2020-10-13 | St. Johns | Florida | 12109 | 5756 | 77 |
625533 | 625533 | 2020-10-13 | Sumter | Florida | 12119 | 2674 | 77 |
622290 | 622290 | 2020-10-12 | Sumter | Florida | 12119 | 2648 | 77 |
619047 | 619047 | 2020-10-11 | Sumter | Florida | 12119 | 2644 | 77 |
606074 | 606074 | 2020-10-07 | Santa Rosa | Florida | 12113 | 5477 | 77 |
602832 | 602832 | 2020-10-06 | Santa Rosa | Florida | 12113 | 5464 | 77 |
586623 | 586623 | 2020-10-01 | Santa Rosa | Florida | 12113 | 5378 | 77 |
583364 | 583364 | 2020-09-30 | Leon | Florida | 12073 | 10644 | 77 |
583383 | 583383 | 2020-09-30 | Santa Rosa | Florida | 12113 | 5354 | 77 |
580144 | 580144 | 2020-09-29 | Santa Rosa | Florida | 12113 | 5331 | 77 |
576879 | 576879 | 2020-09-28 | Jackson | Florida | 12063 | 2811 | 77 |
573636 | 573636 | 2020-09-27 | Jackson | Florida | 12063 | 2810 | 77 |
570394 | 570394 | 2020-09-26 | Jackson | Florida | 12063 | 2801 | 77 |
567152 | 567152 | 2020-09-25 | Jackson | Florida | 12063 | 2791 | 77 |
563912 | 563912 | 2020-09-24 | Jackson | Florida | 12063 | 2773 | 77 |
560672 | 560672 | 2020-09-23 | Jackson | Florida | 12063 | 2768 | 77 |
557436 | 557436 | 2020-09-22 | Jackson | Florida | 12063 | 2750 | 77 |
528298 | 528298 | 2020-09-13 | Highlands | Florida | 12055 | 1996 | 77 |
525062 | 525062 | 2020-09-12 | Highlands | Florida | 12055 | 1986 | 77 |
492704 | 492704 | 2020-09-02 | Clay | Florida | 12019 | 4127 | 77 |
489471 | 489471 | 2020-09-01 | Clay | Florida | 12019 | 4155 | 77 |
489507 | 489507 | 2020-09-01 | Okaloosa | Florida | 12091 | 4198 | 77 |
486274 | 486274 | 2020-08-31 | Okaloosa | Florida | 12091 | 4153 | 77 |
483039 | 483039 | 2020-08-30 | Okaloosa | Florida | 12091 | 4133 | 77 |
473296 | 473296 | 2020-08-27 | Bay | Florida | 12005 | 5289 | 77 |
466858 | 466858 | 2020-08-25 | Hernando | Florida | 12053 | 2476 | 77 |
395951 | 395951 | 2020-08-03 | Martin | Florida | 12085 | 3644 | 77 |
325454 | 325454 | 2020-07-12 | Volusia | Florida | 12127 | 3805 | 77 |
322273 | 322273 | 2020-07-11 | Volusia | Florida | 12127 | 3634 | 77 |
319077 | 319077 | 2020-07-10 | Orange | Florida | 12095 | 16147 | 77 |
315864 | 315864 | 2020-07-09 | Charlotte | Florida | 12015 | 1004 | 77 |
312689 | 312689 | 2020-07-08 | Charlotte | Florida | 12015 | 974 | 77 |
309519 | 309519 | 2020-07-07 | Charlotte | Florida | 12015 | 944 | 77 |
306351 | 306351 | 2020-07-06 | Charlotte | Florida | 12015 | 935 | 77 |
252951 | 252951 | 2020-06-19 | Polk | Florida | 12105 | 1856 | 77 |
197214 | 197214 | 2020-06-01 | Sarasota | Florida | 12115 | 639 | 77 |
194144 | 194144 | 2020-05-31 | Sarasota | Florida | 12115 | 635 | 77 |
191077 | 191077 | 2020-05-30 | Sarasota | Florida | 12115 | 629 | 77 |
188012 | 188012 | 2020-05-29 | Sarasota | Florida | 12115 | 622 | 77 |
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);