ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where "date" is on date 2020-03-19 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alachua 1
- Baker 1
- Brevard 1
- Broward 1
- Charlotte 1
- Citrus 1
- Clay 1
- Collier 1
- Duval 1
- Escambia 1
- Hernando 1
- Hillsborough 1
- Indian River 1
- Jackson 1
- Lake 1
- Lee 1
- Leon 1
- Manatee 1
- Martin 1
- Miami-Dade 1
- Nassau 1
- Okaloosa 1
- Orange 1
- Osceola 1
- Palm Beach 1
- Pasco 1
- Pinellas 1
- Polk 1
- Santa Rosa 1
- Sarasota 1
- …
state 1
- Florida · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4520 | 4520 | 2020-03-19 | Alachua | Florida | 12001 | 11 | 0 |
4521 | 4521 | 2020-03-19 | Baker | Florida | 12003 | 1 | 0 |
4522 | 4522 | 2020-03-19 | Brevard | Florida | 12009 | 3 | 0 |
4523 | 4523 | 2020-03-19 | Broward | Florida | 12011 | 96 | 1 |
4524 | 4524 | 2020-03-19 | Charlotte | Florida | 12015 | 1 | 0 |
4525 | 4525 | 2020-03-19 | Citrus | Florida | 12017 | 3 | 0 |
4526 | 4526 | 2020-03-19 | Clay | Florida | 12019 | 4 | 1 |
4527 | 4527 | 2020-03-19 | Collier | Florida | 12021 | 18 | 0 |
4528 | 4528 | 2020-03-19 | Duval | Florida | 12031 | 15 | 1 |
4529 | 4529 | 2020-03-19 | Escambia | Florida | 12033 | 1 | 0 |
4530 | 4530 | 2020-03-19 | Hernando | Florida | 12053 | 4 | 0 |
4531 | 4531 | 2020-03-19 | Hillsborough | Florida | 12057 | 20 | 0 |
4532 | 4532 | 2020-03-19 | Indian River | Florida | 12061 | 1 | 0 |
4533 | 4533 | 2020-03-19 | Jackson | Florida | 12063 | 1 | 0 |
4534 | 4534 | 2020-03-19 | Lake | Florida | 12069 | 3 | 0 |
4535 | 4535 | 2020-03-19 | Lee | Florida | 12071 | 11 | 2 |
4536 | 4536 | 2020-03-19 | Leon | Florida | 12073 | 3 | 0 |
4537 | 4537 | 2020-03-19 | Manatee | Florida | 12081 | 9 | 1 |
4538 | 4538 | 2020-03-19 | Martin | Florida | 12085 | 1 | 0 |
4539 | 4539 | 2020-03-19 | Miami-Dade | Florida | 12086 | 101 | 0 |
4540 | 4540 | 2020-03-19 | Nassau | Florida | 12089 | 1 | 0 |
4541 | 4541 | 2020-03-19 | Okaloosa | Florida | 12091 | 5 | 0 |
4542 | 4542 | 2020-03-19 | Orange | Florida | 12095 | 19 | 1 |
4543 | 4543 | 2020-03-19 | Osceola | Florida | 12097 | 13 | 0 |
4544 | 4544 | 2020-03-19 | Palm Beach | Florida | 12099 | 28 | 0 |
4545 | 4545 | 2020-03-19 | Pasco | Florida | 12101 | 5 | 0 |
4546 | 4546 | 2020-03-19 | Pinellas | Florida | 12103 | 16 | 0 |
4547 | 4547 | 2020-03-19 | Polk | Florida | 12105 | 4 | 0 |
4548 | 4548 | 2020-03-19 | Santa Rosa | Florida | 12113 | 1 | 1 |
4549 | 4549 | 2020-03-19 | Sarasota | Florida | 12115 | 6 | 0 |
4550 | 4550 | 2020-03-19 | Seminole | Florida | 12117 | 13 | 0 |
4551 | 4551 | 2020-03-19 | St. Johns | Florida | 12109 | 4 | 0 |
4552 | 4552 | 2020-03-19 | Sumter | Florida | 12119 | 2 | 0 |
4553 | 4553 | 2020-03-19 | Volusia | Florida | 12127 | 9 | 0 |
4554 | 4554 | 2020-03-19 | Walton | Florida | 12131 | 1 | 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);