ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,190 rows where state = "Florida" sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
292077	292077	2020-07-03	Alachua	Florida	12001	1423	12
292078	292078	2020-07-03	Baker	Florida	12003	84	4
292079	292079	2020-07-03	Bay	Florida	12005	625	5
292080	292080	2020-07-03	Bradford	Florida	12007	92	2
292081	292081	2020-07-03	Brevard	Florida	12009	2366	18
292082	292082	2020-07-03	Broward	Florida	12011	18229	406
292083	292083	2020-07-03	Calhoun	Florida	12013	97	6
292084	292084	2020-07-03	Charlotte	Florida	12015	860	76
292085	292085	2020-07-03	Citrus	Florida	12017	364	13
292086	292086	2020-07-03	Clay	Florida	12019	871	34
292087	292087	2020-07-03	Collier	Florida	12021	4701	85
292088	292088	2020-07-03	Columbia	Florida	12023	331	3
292089	292089	2020-07-03	DeSoto	Florida	12027	676	10
292090	292090	2020-07-03	Dixie	Florida	12029	72	4
292091	292091	2020-07-03	Duval	Florida	12031	7961	68
292092	292092	2020-07-03	Escambia	Florida	12033	2397	46
292093	292093	2020-07-03	Flagler	Florida	12035	359	5
292094	292094	2020-07-03	Franklin	Florida	12037	11	0
292095	292095	2020-07-03	Gadsden	Florida	12039	427	7
292096	292096	2020-07-03	Gilchrist	Florida	12041	109	0
292097	292097	2020-07-03	Glades	Florida	12043	172	1
292098	292098	2020-07-03	Gulf	Florida	12045	34	0
292099	292099	2020-07-03	Hamilton	Florida	12047	380	2
292100	292100	2020-07-03	Hardee	Florida	12049	496	3
292101	292101	2020-07-03	Hendry	Florida	12051	1021	27
292102	292102	2020-07-03	Hernando	Florida	12053	472	5
292103	292103	2020-07-03	Highlands	Florida	12055	390	11
292104	292104	2020-07-03	Hillsborough	Florida	12057	13044	148
292105	292105	2020-07-03	Holmes	Florida	12059	196	0
292106	292106	2020-07-03	Indian River	Florida	12061	820	16
292107	292107	2020-07-03	Jackson	Florida	12063	394	2
292108	292108	2020-07-03	Jefferson	Florida	12065	57	4
292109	292109	2020-07-03	Lafayette	Florida	12067	34	0
292110	292110	2020-07-03	Lake	Florida	12069	1603	23
292111	292111	2020-07-03	Lee	Florida	12071	6667	162
292112	292112	2020-07-03	Leon	Florida	12073	1465	8
292113	292113	2020-07-03	Levy	Florida	12075	192	1
292114	292114	2020-07-03	Liberty	Florida	12077	238	1
292115	292115	2020-07-03	Madison	Florida	12079	220	3
292116	292116	2020-07-03	Manatee	Florida	12081	3261	131
292117	292117	2020-07-03	Marion	Florida	12083	817	12
292118	292118	2020-07-03	Martin	Florida	12085	2208	28
292119	292119	2020-07-03	Miami-Dade	Florida	12086	42310	1034
292120	292120	2020-07-03	Monroe	Florida	12087	322	5
292121	292121	2020-07-03	Nassau	Florida	12089	253	1
292122	292122	2020-07-03	Okaloosa	Florida	12091	819	8
292123	292123	2020-07-03	Okeechobee	Florida	12093	402	0
292124	292124	2020-07-03	Orange	Florida	12095	12077	58
292125	292125	2020-07-03	Osceola	Florida	12097	2526	25
292126	292126	2020-07-03	Palm Beach	Florida	12099	15322	536
292127	292127	2020-07-03	Pasco	Florida	12101	2443	23
292128	292128	2020-07-03	Pinellas	Florida	12103	7697	183
292129	292129	2020-07-03	Polk	Florida	12105	4660	105
292130	292130	2020-07-03	Putnam	Florida	12107	489	6
292131	292131	2020-07-03	Santa Rosa	Florida	12113	743	9
292132	292132	2020-07-03	Sarasota	Florida	12115	1814	98
292133	292133	2020-07-03	Seminole	Florida	12117	2987	20
292134	292134	2020-07-03	St. Johns	Florida	12109	1188	8
292135	292135	2020-07-03	St. Lucie	Florida	12111	1983	50
292136	292136	2020-07-03	Sumter	Florida	12119	401	17
292137	292137	2020-07-03	Suwannee	Florida	12121	581	21
292138	292138	2020-07-03	Taylor	Florida	12123	91	1
292139	292139	2020-07-03	Union	Florida	12125	74	2
292140	292140	2020-07-03	Unknown	Florida		187	0
292141	292141	2020-07-03	Volusia	Florida	12127	2496	58
292142	292142	2020-07-03	Wakulla	Florida	12129	72	1
292143	292143	2020-07-03	Walton	Florida	12131	295	9
292144	292144	2020-07-03	Washington	Florida	12133	118	13
289000	289000	2020-07-02	Alachua	Florida	12001	1332	12
289001	289001	2020-07-02	Baker	Florida	12003	80	4
289002	289002	2020-07-02	Bay	Florida	12005	581	5
289003	289003	2020-07-02	Bradford	Florida	12007	89	2
289004	289004	2020-07-02	Brevard	Florida	12009	2180	17
289005	289005	2020-07-02	Broward	Florida	12011	17116	394
289006	289006	2020-07-02	Calhoun	Florida	12013	85	6
289007	289007	2020-07-02	Charlotte	Florida	12015	836	76
289008	289008	2020-07-02	Citrus	Florida	12017	345	13
289009	289009	2020-07-02	Clay	Florida	12019	801	34
289010	289010	2020-07-02	Collier	Florida	12021	4539	82
289011	289011	2020-07-02	Columbia	Florida	12023	316	3
289012	289012	2020-07-02	DeSoto	Florida	12027	661	10
289013	289013	2020-07-02	Dixie	Florida	12029	69	4
289014	289014	2020-07-02	Duval	Florida	12031	7247	68
289015	289015	2020-07-02	Escambia	Florida	12033	2240	45
289016	289016	2020-07-02	Flagler	Florida	12035	340	5
289017	289017	2020-07-02	Franklin	Florida	12037	9	0
289018	289018	2020-07-02	Gadsden	Florida	12039	405	7
289019	289019	2020-07-02	Gilchrist	Florida	12041	106	0
289020	289020	2020-07-02	Glades	Florida	12043	167	1
289021	289021	2020-07-02	Gulf	Florida	12045	32	0
289022	289022	2020-07-02	Hamilton	Florida	12047	376	2
289023	289023	2020-07-02	Hardee	Florida	12049	468	3
289024	289024	2020-07-02	Hendry	Florida	12051	993	25
289025	289025	2020-07-02	Hernando	Florida	12053	451	5
289026	289026	2020-07-02	Highlands	Florida	12055	372	11
289027	289027	2020-07-02	Hillsborough	Florida	12057	12376	145
289028	289028	2020-07-02	Holmes	Florida	12059	191	0
289029	289029	2020-07-02	Indian River	Florida	12061	772	16
289030	289030	2020-07-02	Jackson	Florida	12063	381	2
289031	289031	2020-07-02	Jefferson	Florida	12065	57	4

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
);