ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53,362 rows where state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 12081 803
- 12057 802
- 12113 799
- 12071 798
- 12011 797
- 12091 797
- 12127 797
- 12015 796
- 12089 794
- 12101 794
- 12103 794
- 12001 793
- 12021 793
- 12086 793
- 12109 793
- 12099 792
- 12115 792
- 12117 792
- 12019 791
- 12031 791
- 12095 791
- 12097 791
- 12003 788
- 12017 788
- 12069 788
- 12033 787
- 12105 787
- 12009 786
- 12073 786
- 12119 786
- …
county >30
- Manatee 803
- Hillsborough 802
- Santa Rosa 799
- Lee 798
- Broward 797
- Okaloosa 797
- Volusia 797
- Charlotte 796
- Nassau 794
- Pasco 794
- Pinellas 794
- Alachua 793
- Collier 793
- Miami-Dade 793
- St. Johns 793
- Palm Beach 792
- Sarasota 792
- Seminole 792
- Clay 791
- Duval 791
- Orange 791
- Osceola 791
- Baker 788
- Citrus 788
- Lake 788
- Escambia 787
- Polk 787
- Brevard 786
- Leon 786
- Sumter 786
- …
state 1
- Florida · 53,262 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496672 | 2496672 | 2022-05-12 | Lafayette | Florida | 12067 | 2780 | 61 |
2496673 | 2496673 | 2022-05-12 | Lake | Florida | 12069 | 86320 | 1501 |
2496674 | 2496674 | 2022-05-12 | Lee | Florida | 12071 | 191963 | 2158 |
2496675 | 2496675 | 2022-05-12 | Leon | Florida | 12073 | 85724 | 663 |
2496676 | 2496676 | 2022-05-12 | Levy | Florida | 12075 | 10284 | 169 |
2496677 | 2496677 | 2022-05-12 | Liberty | Florida | 12077 | 2507 | 30 |
2496678 | 2496678 | 2022-05-12 | Madison | Florida | 12079 | 5849 | 97 |
2496679 | 2496679 | 2022-05-12 | Manatee | Florida | 12081 | 96960 | 1434 |
2496680 | 2496680 | 2022-05-12 | Marion | Florida | 12083 | 84120 | 2105 |
2496681 | 2496681 | 2022-05-12 | Martin | Florida | 12085 | 30920 | 616 |
2496682 | 2496682 | 2022-05-12 | Miami-Dade | Florida | 12086 | 1209302 | 10921 |
2496683 | 2496683 | 2022-05-12 | Monroe | Florida | 12087 | 18412 | 119 |
2496684 | 2496684 | 2022-05-12 | Nassau | Florida | 12089 | 21949 | 294 |
2496685 | 2496685 | 2022-05-12 | Okaloosa | Florida | 12091 | 51630 | 688 |
2496686 | 2496686 | 2022-05-12 | Okeechobee | Florida | 12093 | 10649 | 183 |
2496687 | 2496687 | 2022-05-12 | Orange | Florida | 12095 | 383010 | 2835 |
2496688 | 2496688 | 2022-05-12 | Osceola | Florida | 12097 | 115328 | 1147 |
2496689 | 2496689 | 2022-05-12 | Palm Beach | Florida | 12099 | 375184 | 5059 |
2496690 | 2496690 | 2022-05-12 | Pasco | Florida | 12101 | 123993 | 1900 |
2496691 | 2496691 | 2022-05-12 | Pinellas | Florida | 12103 | 212746 | 3356 |
2496692 | 2496692 | 2022-05-12 | Polk | Florida | 12105 | 202456 | 2991 |
2496693 | 2496693 | 2022-05-12 | Putnam | Florida | 12107 | 17669 | 424 |
2496694 | 2496694 | 2022-05-12 | Santa Rosa | Florida | 12113 | 48592 | 621 |
2496695 | 2496695 | 2022-05-12 | Sarasota | Florida | 12115 | 91416 | 1620 |
2496696 | 2496696 | 2022-05-12 | Seminole | Florida | 12117 | 105227 | 1096 |
2496697 | 2496697 | 2022-05-12 | St. Johns | Florida | 12109 | 63143 | 567 |
2496698 | 2496698 | 2022-05-12 | St. Lucie | Florida | 12111 | 75157 | 1221 |
2496699 | 2496699 | 2022-05-12 | Sumter | Florida | 12119 | 22305 | 576 |
2496700 | 2496700 | 2022-05-12 | Suwannee | Florida | 12121 | 12972 | 315 |
2496701 | 2496701 | 2022-05-12 | Taylor | Florida | 12123 | 7015 | 101 |
2496702 | 2496702 | 2022-05-12 | Union | Florida | 12125 | 4321 | 116 |
2496703 | 2496703 | 2022-05-12 | Unknown | Florida | 35735 | 98 | |
2496704 | 2496704 | 2022-05-12 | Volusia | Florida | 12127 | 118119 | 1988 |
2496705 | 2496705 | 2022-05-12 | Wakulla | Florida | 12129 | 9972 | 125 |
2496706 | 2496706 | 2022-05-12 | Walton | Florida | 12131 | 16555 | 210 |
2496707 | 2496707 | 2022-05-12 | Washington | Florida | 12133 | 6642 | 110 |
2493382 | 2493382 | 2022-05-11 | Alachua | Florida | 12001 | 69008 | 665 |
2493383 | 2493383 | 2022-05-11 | Baker | Florida | 12003 | 8712 | 142 |
2493384 | 2493384 | 2022-05-11 | Bay | Florida | 12005 | 45926 | 827 |
2493385 | 2493385 | 2022-05-11 | Bradford | Florida | 12007 | 7538 | 150 |
2493386 | 2493386 | 2022-05-11 | Brevard | Florida | 12009 | 135740 | 2100 |
2493387 | 2493387 | 2022-05-11 | Broward | Florida | 12011 | 614436 | 5852 |
2493388 | 2493388 | 2022-05-11 | Calhoun | Florida | 12013 | 4103 | 98 |
2493389 | 2493389 | 2022-05-11 | Charlotte | Florida | 12015 | 36528 | 812 |
2493390 | 2493390 | 2022-05-11 | Citrus | Florida | 12017 | 29988 | 976 |
2493391 | 2493391 | 2022-05-11 | Clay | Florida | 12019 | 53825 | 856 |
2493392 | 2493392 | 2022-05-11 | Collier | Florida | 12021 | 85078 | 1000 |
2493393 | 2493393 | 2022-05-11 | Columbia | Florida | 12023 | 21193 | 402 |
2493394 | 2493394 | 2022-05-11 | DeSoto | Florida | 12027 | 9455 | 150 |
2493395 | 2493395 | 2022-05-11 | Dixie | Florida | 12029 | 4046 | 70 |
2493396 | 2493396 | 2022-05-11 | Duval | Florida | 12031 | 255189 | 3410 |
2493397 | 2493397 | 2022-05-11 | Escambia | Florida | 12033 | 78190 | 1311 |
2493398 | 2493398 | 2022-05-11 | Flagler | Florida | 12035 | 22651 | 359 |
2493399 | 2493399 | 2022-05-11 | Franklin | Florida | 12037 | 3087 | 52 |
2493400 | 2493400 | 2022-05-11 | Gadsden | Florida | 12039 | 13475 | 207 |
2493401 | 2493401 | 2022-05-11 | Gilchrist | Florida | 12041 | 4562 | 93 |
2493402 | 2493402 | 2022-05-11 | Glades | Florida | 12043 | 1995 | 36 |
2493403 | 2493403 | 2022-05-11 | Gulf | Florida | 12045 | 4292 | 79 |
2493404 | 2493404 | 2022-05-11 | Hamilton | Florida | 12047 | 3841 | 56 |
2493405 | 2493405 | 2022-05-11 | Hardee | Florida | 12049 | 8696 | 124 |
2493406 | 2493406 | 2022-05-11 | Hendry | Florida | 12051 | 11773 | 160 |
2493407 | 2493407 | 2022-05-11 | Hernando | Florida | 12053 | 42396 | 1095 |
2493408 | 2493408 | 2022-05-11 | Highlands | Florida | 12055 | 24304 | 686 |
2493409 | 2493409 | 2022-05-11 | Hillsborough | Florida | 12057 | 379994 | 3793 |
2493410 | 2493410 | 2022-05-11 | Holmes | Florida | 12059 | 5429 | 87 |
2493411 | 2493411 | 2022-05-11 | Indian River | Florida | 12061 | 33156 | 654 |
2493412 | 2493412 | 2022-05-11 | Jackson | Florida | 12063 | 14854 | 280 |
2493413 | 2493413 | 2022-05-11 | Jefferson | Florida | 12065 | 3964 | 61 |
2493414 | 2493414 | 2022-05-11 | Lafayette | Florida | 12067 | 2780 | 61 |
2493415 | 2493415 | 2022-05-11 | Lake | Florida | 12069 | 86320 | 1501 |
2493416 | 2493416 | 2022-05-11 | Lee | Florida | 12071 | 191963 | 2158 |
2493417 | 2493417 | 2022-05-11 | Leon | Florida | 12073 | 85724 | 663 |
2493418 | 2493418 | 2022-05-11 | Levy | Florida | 12075 | 10284 | 169 |
2493419 | 2493419 | 2022-05-11 | Liberty | Florida | 12077 | 2507 | 30 |
2493420 | 2493420 | 2022-05-11 | Madison | Florida | 12079 | 5849 | 97 |
2493421 | 2493421 | 2022-05-11 | Manatee | Florida | 12081 | 96960 | 1434 |
2493422 | 2493422 | 2022-05-11 | Marion | Florida | 12083 | 84120 | 2105 |
2493423 | 2493423 | 2022-05-11 | Martin | Florida | 12085 | 30920 | 616 |
2493424 | 2493424 | 2022-05-11 | Miami-Dade | Florida | 12086 | 1209302 | 10921 |
2493425 | 2493425 | 2022-05-11 | Monroe | Florida | 12087 | 18412 | 119 |
2493426 | 2493426 | 2022-05-11 | Nassau | Florida | 12089 | 21949 | 294 |
2493427 | 2493427 | 2022-05-11 | Okaloosa | Florida | 12091 | 51630 | 688 |
2493428 | 2493428 | 2022-05-11 | Okeechobee | Florida | 12093 | 10649 | 183 |
2493429 | 2493429 | 2022-05-11 | Orange | Florida | 12095 | 383010 | 2835 |
2493430 | 2493430 | 2022-05-11 | Osceola | Florida | 12097 | 115328 | 1147 |
2493431 | 2493431 | 2022-05-11 | Palm Beach | Florida | 12099 | 375184 | 5059 |
2493432 | 2493432 | 2022-05-11 | Pasco | Florida | 12101 | 123993 | 1900 |
2493433 | 2493433 | 2022-05-11 | Pinellas | Florida | 12103 | 212746 | 3356 |
2493434 | 2493434 | 2022-05-11 | Polk | Florida | 12105 | 202456 | 2991 |
2493435 | 2493435 | 2022-05-11 | Putnam | Florida | 12107 | 17669 | 424 |
2493436 | 2493436 | 2022-05-11 | Santa Rosa | Florida | 12113 | 48592 | 621 |
2493437 | 2493437 | 2022-05-11 | Sarasota | Florida | 12115 | 91416 | 1620 |
2493438 | 2493438 | 2022-05-11 | Seminole | Florida | 12117 | 105227 | 1096 |
2493439 | 2493439 | 2022-05-11 | St. Johns | Florida | 12109 | 63143 | 567 |
2493440 | 2493440 | 2022-05-11 | St. Lucie | Florida | 12111 | 75157 | 1221 |
2493441 | 2493441 | 2022-05-11 | Sumter | Florida | 12119 | 22305 | 576 |
2493442 | 2493442 | 2022-05-11 | Suwannee | Florida | 12121 | 12972 | 315 |
2493443 | 2493443 | 2022-05-11 | Taylor | Florida | 12123 | 7015 | 101 |
2493444 | 2493444 | 2022-05-11 | Union | Florida | 12125 | 4321 | 116 |
2493445 | 2493445 | 2022-05-11 | Unknown | Florida | 27923 | 73 |
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);