ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2020-04-09 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alachua 1
- Baker 1
- Bay 1
- Bradford 1
- Brevard 1
- Broward 1
- Calhoun 1
- Charlotte 1
- Citrus 1
- Clay 1
- Collier 1
- Columbia 1
- DeSoto 1
- Dixie 1
- Duval 1
- Escambia 1
- Flagler 1
- Franklin 1
- Gadsden 1
- Gilchrist 1
- Glades 1
- Gulf 1
- Hamilton 1
- Hardee 1
- Hendry 1
- Hernando 1
- Highlands 1
- Hillsborough 1
- Holmes 1
- Indian River 1
- …
state 1
- Florida · 67 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
43484 | 43484 | 2020-04-09 | Alachua | Florida | 12001 | 154 | 0 |
43485 | 43485 | 2020-04-09 | Baker | Florida | 12003 | 16 | 2 |
43486 | 43486 | 2020-04-09 | Bay | Florida | 12005 | 34 | 1 |
43487 | 43487 | 2020-04-09 | Bradford | Florida | 12007 | 20 | 0 |
43488 | 43488 | 2020-04-09 | Brevard | Florida | 12009 | 111 | 2 |
43489 | 43489 | 2020-04-09 | Broward | Florida | 12011 | 2480 | 67 |
43490 | 43490 | 2020-04-09 | Calhoun | Florida | 12013 | 4 | 0 |
43491 | 43491 | 2020-04-09 | Charlotte | Florida | 12015 | 81 | 4 |
43492 | 43492 | 2020-04-09 | Citrus | Florida | 12017 | 58 | 6 |
43493 | 43493 | 2020-04-09 | Clay | Florida | 12019 | 110 | 7 |
43494 | 43494 | 2020-04-09 | Collier | Florida | 12021 | 303 | 3 |
43495 | 43495 | 2020-04-09 | Columbia | Florida | 12023 | 18 | 0 |
43496 | 43496 | 2020-04-09 | DeSoto | Florida | 12027 | 20 | 3 |
43497 | 43497 | 2020-04-09 | Dixie | Florida | 12029 | 1 | 0 |
43498 | 43498 | 2020-04-09 | Duval | Florida | 12031 | 595 | 11 |
43499 | 43499 | 2020-04-09 | Escambia | Florida | 12033 | 192 | 3 |
43500 | 43500 | 2020-04-09 | Flagler | Florida | 12035 | 41 | 1 |
43501 | 43501 | 2020-04-09 | Franklin | Florida | 12037 | 2 | 0 |
43502 | 43502 | 2020-04-09 | Gadsden | Florida | 12039 | 11 | 0 |
43503 | 43503 | 2020-04-09 | Gilchrist | Florida | 12041 | 3 | 0 |
43504 | 43504 | 2020-04-09 | Glades | Florida | 12043 | 4 | 1 |
43505 | 43505 | 2020-04-09 | Gulf | Florida | 12045 | 1 | 0 |
43506 | 43506 | 2020-04-09 | Hamilton | Florida | 12047 | 1 | 0 |
43507 | 43507 | 2020-04-09 | Hardee | Florida | 12049 | 3 | 0 |
43508 | 43508 | 2020-04-09 | Hendry | Florida | 12051 | 13 | 0 |
43509 | 43509 | 2020-04-09 | Hernando | Florida | 12053 | 62 | 1 |
43510 | 43510 | 2020-04-09 | Highlands | Florida | 12055 | 46 | 4 |
43511 | 43511 | 2020-04-09 | Hillsborough | Florida | 12057 | 657 | 9 |
43512 | 43512 | 2020-04-09 | Holmes | Florida | 12059 | 2 | 0 |
43513 | 43513 | 2020-04-09 | Indian River | Florida | 12061 | 68 | 0 |
43514 | 43514 | 2020-04-09 | Jackson | Florida | 12063 | 5 | 0 |
43515 | 43515 | 2020-04-09 | Jefferson | Florida | 12065 | 9 | 0 |
43516 | 43516 | 2020-04-09 | Lafayette | Florida | 12067 | 1 | 0 |
43517 | 43517 | 2020-04-09 | Lake | Florida | 12069 | 140 | 2 |
43518 | 43518 | 2020-04-09 | Lee | Florida | 12071 | 521 | 14 |
43519 | 43519 | 2020-04-09 | Leon | Florida | 12073 | 77 | 0 |
43520 | 43520 | 2020-04-09 | Levy | Florida | 12075 | 6 | 0 |
43521 | 43521 | 2020-04-09 | Madison | Florida | 12079 | 12 | 0 |
43522 | 43522 | 2020-04-09 | Manatee | Florida | 12081 | 179 | 11 |
43523 | 43523 | 2020-04-09 | Marion | Florida | 12083 | 75 | 2 |
43524 | 43524 | 2020-04-09 | Martin | Florida | 12085 | 109 | 1 |
43525 | 43525 | 2020-04-09 | Miami-Dade | Florida | 12086 | 5897 | 66 |
43526 | 43526 | 2020-04-09 | Monroe | Florida | 12087 | 53 | 3 |
43527 | 43527 | 2020-04-09 | Nassau | Florida | 12089 | 32 | 0 |
43528 | 43528 | 2020-04-09 | Okaloosa | Florida | 12091 | 82 | 1 |
43529 | 43529 | 2020-04-09 | Okeechobee | Florida | 12093 | 5 | 0 |
43530 | 43530 | 2020-04-09 | Orange | Florida | 12095 | 859 | 12 |
43531 | 43531 | 2020-04-09 | Osceola | Florida | 12097 | 295 | 5 |
43532 | 43532 | 2020-04-09 | Palm Beach | Florida | 12099 | 1331 | 75 |
43533 | 43533 | 2020-04-09 | Pasco | Florida | 12101 | 139 | 2 |
43534 | 43534 | 2020-04-09 | Pinellas | Florida | 12103 | 422 | 10 |
43535 | 43535 | 2020-04-09 | Polk | Florida | 12105 | 234 | 7 |
43536 | 43536 | 2020-04-09 | Putnam | Florida | 12107 | 25 | 1 |
43537 | 43537 | 2020-04-09 | Santa Rosa | Florida | 12113 | 96 | 2 |
43538 | 43538 | 2020-04-09 | Sarasota | Florida | 12115 | 201 | 10 |
43539 | 43539 | 2020-04-09 | Seminole | Florida | 12117 | 229 | 1 |
43540 | 43540 | 2020-04-09 | St. Johns | Florida | 12109 | 163 | 2 |
43541 | 43541 | 2020-04-09 | St. Lucie | Florida | 12111 | 137 | 6 |
43542 | 43542 | 2020-04-09 | Sumter | Florida | 12119 | 100 | 7 |
43543 | 43543 | 2020-04-09 | Suwannee | Florida | 12121 | 54 | 0 |
43544 | 43544 | 2020-04-09 | Taylor | Florida | 12123 | 1 | 0 |
43545 | 43545 | 2020-04-09 | Union | Florida | 12125 | 2 | 0 |
43546 | 43546 | 2020-04-09 | Unknown | Florida | 2 | 0 | |
43547 | 43547 | 2020-04-09 | Volusia | Florida | 12127 | 179 | 5 |
43548 | 43548 | 2020-04-09 | Wakulla | Florida | 12129 | 7 | 0 |
43549 | 43549 | 2020-04-09 | Walton | Florida | 12131 | 26 | 0 |
43550 | 43550 | 2020-04-09 | Washington | Florida | 12133 | 3 | 0 |
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);