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

23,396 rows where state = "Texas" sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
318936	318936	2020-07-11	Anderson	Texas	48001	1796	3
318937	318937	2020-07-11	Andrews	Texas	48003	155	2
318938	318938	2020-07-11	Angelina	Texas	48005	743	9
318939	318939	2020-07-11	Aransas	Texas	48007	50	0
318940	318940	2020-07-11	Archer	Texas	48009	10	0
318941	318941	2020-07-11	Armstrong	Texas	48011	3	0
318942	318942	2020-07-11	Atascosa	Texas	48013	207	2
318943	318943	2020-07-11	Austin	Texas	48015	128	0
318944	318944	2020-07-11	Bailey	Texas	48017	112	1
318945	318945	2020-07-11	Bandera	Texas	48019	44	0
318946	318946	2020-07-11	Bastrop	Texas	48021	727	11
318947	318947	2020-07-11	Baylor	Texas	48023	1	0
318948	318948	2020-07-11	Bee	Texas	48025	135	0
318949	318949	2020-07-11	Bell	Texas	48027	2083	14
318950	318950	2020-07-11	Bexar	Texas	48029	19149	175
318951	318951	2020-07-11	Blanco	Texas	48031	49	1
318952	318952	2020-07-11	Bosque	Texas	48035	41	0
318953	318953	2020-07-11	Bowie	Texas	48037	496	26
318954	318954	2020-07-11	Brazoria	Texas	48039	3358	25
318955	318955	2020-07-11	Brazos	Texas	48041	2961	35
318956	318956	2020-07-11	Brewster	Texas	48043	150	1
318957	318957	2020-07-11	Briscoe	Texas	48045	9	1
318958	318958	2020-07-11	Brooks	Texas	48047	37	0
318959	318959	2020-07-11	Brown	Texas	48049	171	13
318960	318960	2020-07-11	Burleson	Texas	48051	148	0
318961	318961	2020-07-11	Burnet	Texas	48053	230	3
318962	318962	2020-07-11	Caldwell	Texas	48055	645	5
318963	318963	2020-07-11	Calhoun	Texas	48057	153	3
318964	318964	2020-07-11	Callahan	Texas	48059	27	2
318965	318965	2020-07-11	Cameron	Texas	48061	3854	79
318966	318966	2020-07-11	Camp	Texas	48063	131	2
318967	318967	2020-07-11	Carson	Texas	48065	10	0
318968	318968	2020-07-11	Cass	Texas	48067	57	3
318969	318969	2020-07-11	Castro	Texas	48069	120	1
318970	318970	2020-07-11	Chambers	Texas	48071	590	2
318971	318971	2020-07-11	Cherokee	Texas	48073	357	2
318972	318972	2020-07-11	Childress	Texas	48075	7	0
318973	318973	2020-07-11	Clay	Texas	48077	16	0
318974	318974	2020-07-11	Cochran	Texas	48079	6	0
318975	318975	2020-07-11	Coke	Texas	48081	6	1
318976	318976	2020-07-11	Coleman	Texas	48083	5	0
318977	318977	2020-07-11	Collin	Texas	48085	4459	56
318978	318978	2020-07-11	Collingsworth	Texas	48087	6	0
318979	318979	2020-07-11	Colorado	Texas	48089	161	0
318980	318980	2020-07-11	Comal	Texas	48091	1282	22
318981	318981	2020-07-11	Comanche	Texas	48093	26	1
318982	318982	2020-07-11	Concho	Texas	48095	13	0
318983	318983	2020-07-11	Cooke	Texas	48097	87	0
318984	318984	2020-07-11	Coryell	Texas	48099	398	2
318985	318985	2020-07-11	Cottle	Texas	48101	4	1
318986	318986	2020-07-11	Crane	Texas	48103	64	9
318987	318987	2020-07-11	Crockett	Texas	48105	35	0
318988	318988	2020-07-11	Crosby	Texas	48107	35	2
318989	318989	2020-07-11	Culberson	Texas	48109	6	1
318990	318990	2020-07-11	Dallam	Texas	48111	116	1
318991	318991	2020-07-11	Dallas	Texas	48113	32626	449
318992	318992	2020-07-11	Dawson	Texas	48115	83	1
318993	318993	2020-07-11	DeWitt	Texas	48123	159	3
318994	318994	2020-07-11	Deaf Smith	Texas	48117	409	17
318995	318995	2020-07-11	Delta	Texas	48119	7	0
318996	318996	2020-07-11	Denton	Texas	48121	3937	40
318997	318997	2020-07-11	Dickens	Texas	48125	2	0
318998	318998	2020-07-11	Dimmit	Texas	48127	31	0
318999	318999	2020-07-11	Donley	Texas	48129	32	0
319000	319000	2020-07-11	Duval	Texas	48131	75	0
319001	319001	2020-07-11	Eastland	Texas	48133	20	0
319002	319002	2020-07-11	Ector	Texas	48135	1829	14
319003	319003	2020-07-11	Edwards	Texas	48137	4	0
319004	319004	2020-07-11	El Paso	Texas	48141	9099	150
319005	319005	2020-07-11	Ellis	Texas	48139	1510	20
319006	319006	2020-07-11	Erath	Texas	48143	216	1
319007	319007	2020-07-11	Falls	Texas	48145	56	0
319008	319008	2020-07-11	Fannin	Texas	48147	137	8
319009	319009	2020-07-11	Fayette	Texas	48149	151	3
319010	319010	2020-07-11	Fisher	Texas	48151	13	1
319011	319011	2020-07-11	Floyd	Texas	48153	52	1
319012	319012	2020-07-11	Foard	Texas	48155	1	0
319013	319013	2020-07-11	Fort Bend	Texas	48157	4758	62
319014	319014	2020-07-11	Franklin	Texas	48159	55	1
319015	319015	2020-07-11	Freestone	Texas	48161	73	0
319016	319016	2020-07-11	Frio	Texas	48163	338	0
319017	319017	2020-07-11	Gaines	Texas	48165	43	0
319018	319018	2020-07-11	Galveston	Texas	48167	5873	54
319019	319019	2020-07-11	Garza	Texas	48169	21	1
319020	319020	2020-07-11	Gillespie	Texas	48171	65	0
319021	319021	2020-07-11	Glasscock	Texas	48173	6	0
319022	319022	2020-07-11	Goliad	Texas	48175	30	0
319023	319023	2020-07-11	Gonzales	Texas	48177	323	4
319024	319024	2020-07-11	Gray	Texas	48179	133	4
319025	319025	2020-07-11	Grayson	Texas	48181	731	7
319026	319026	2020-07-11	Gregg	Texas	48183	788	14
319027	319027	2020-07-11	Grimes	Texas	48185	642	2
319028	319028	2020-07-11	Guadalupe	Texas	48187	1014	3
319029	319029	2020-07-11	Hale	Texas	48189	763	11
319030	319030	2020-07-11	Hall	Texas	48191	2	1
319031	319031	2020-07-11	Hamilton	Texas	48193	32	1
319032	319032	2020-07-11	Hansford	Texas	48195	35	2
319033	319033	2020-07-11	Hardeman	Texas	48197	5	0
319034	319034	2020-07-11	Hardin	Texas	48199	404	5
319035	319035	2020-07-11	Harris	Texas	48201	43939	455

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