ny_times_us_counties

Table actions
⚠️ 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

105 rows where date = "2020-03-27" and state = "Texas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: cases, deaths, date (date)

state 1

  • Texas · 105 ✖
Link rowid date ▲ county state fips cases deaths
15491 15491 2020-03-27 Angelina Texas 48005 2 0
15492 15492 2020-03-27 Atascosa Texas 48013 2 0
15493 15493 2020-03-27 Austin Texas 48015 1 0
15494 15494 2020-03-27 Bastrop Texas 48021 2 0
15495 15495 2020-03-27 Bell Texas 48027 25 1
15496 15496 2020-03-27 Bexar Texas 48029 113 5
15497 15497 2020-03-27 Blanco Texas 48031 1 0
15498 15498 2020-03-27 Bowie Texas 48037 2 0
15499 15499 2020-03-27 Brazoria Texas 48039 39 0
15500 15500 2020-03-27 Brazos Texas 48041 31 0
15501 15501 2020-03-27 Brown Texas 48049 3 0
15502 15502 2020-03-27 Burnet Texas 48053 1 0
15503 15503 2020-03-27 Calhoun Texas 48057 2 0
15504 15504 2020-03-27 Cameron Texas 48061 13 0
15505 15505 2020-03-27 Cass Texas 48067 1 0
15506 15506 2020-03-27 Castro Texas 48069 7 0
15507 15507 2020-03-27 Chambers Texas 48071 2 0
15508 15508 2020-03-27 Cherokee Texas 48073 1 0
15509 15509 2020-03-27 Collin Texas 48085 118 1
15510 15510 2020-03-27 Comal Texas 48091 9 1
15511 15511 2020-03-27 Coryell Texas 48099 1 0
15512 15512 2020-03-27 Crane Texas 48103 1 0
15513 15513 2020-03-27 Dallas Texas 48113 367 7
15514 15514 2020-03-27 DeWitt Texas 48123 3 0
15515 15515 2020-03-27 Deaf Smith Texas 48117 2 0
15516 15516 2020-03-27 Denton Texas 48121 137 1
15517 15517 2020-03-27 Eastland Texas 48133 2 0
15518 15518 2020-03-27 El Paso Texas 48141 30 0
15519 15519 2020-03-27 Ellis Texas 48139 13 0
15520 15520 2020-03-27 Erath Texas 48143 1 0
15521 15521 2020-03-27 Falls Texas 48145 1 0
15522 15522 2020-03-27 Fannin Texas 48147 1 0
15523 15523 2020-03-27 Fayette Texas 48149 1 0
15524 15524 2020-03-27 Fort Bend Texas 48157 101 1
15525 15525 2020-03-27 Gaines Texas 48165 1 0
15526 15526 2020-03-27 Galveston Texas 48167 49 0
15527 15527 2020-03-27 Grayson Texas 48181 2 0
15528 15528 2020-03-27 Gregg Texas 48183 4 0
15529 15529 2020-03-27 Grimes Texas 48185 2 0
15530 15530 2020-03-27 Guadalupe Texas 48187 8 0
15531 15531 2020-03-27 Hale Texas 48189 1 0
15532 15532 2020-03-27 Hardin Texas 48199 4 0
15533 15533 2020-03-27 Harris Texas 48201 229 2
15534 15534 2020-03-27 Harrison Texas 48203 1 0
15535 15535 2020-03-27 Hays Texas 48209 13 0
15536 15536 2020-03-27 Hidalgo Texas 48215 18 0
15537 15537 2020-03-27 Hockley Texas 48219 5 0
15538 15538 2020-03-27 Hood Texas 48221 2 0
15539 15539 2020-03-27 Hopkins Texas 48223 1 0
15540 15540 2020-03-27 Hunt Texas 48231 1 0
15541 15541 2020-03-27 Jackson Texas 48239 1 0
15542 15542 2020-03-27 Jefferson Texas 48245 8 0
15543 15543 2020-03-27 Johnson Texas 48251 6 0
15544 15544 2020-03-27 Karnes Texas 48255 1 0
15545 15545 2020-03-27 Kaufman Texas 48257 2 0
15546 15546 2020-03-27 Kendall Texas 48259 4 0
15547 15547 2020-03-27 Lamar Texas 48277 1 0
15548 15548 2020-03-27 Lavaca Texas 48285 1 0
15549 15549 2020-03-27 Liberty Texas 48291 2 0
15550 15550 2020-03-27 Limestone Texas 48293 1 0
15551 15551 2020-03-27 Llano Texas 48299 2 0
15552 15552 2020-03-27 Lubbock Texas 48303 31 0
15553 15553 2020-03-27 Martin Texas 48317 1 0
15554 15554 2020-03-27 Matagorda Texas 48321 9 1
15555 15555 2020-03-27 Maverick Texas 48323 1 0
15556 15556 2020-03-27 McLennan Texas 48309 33 0
15557 15557 2020-03-27 Medina Texas 48325 3 0
15558 15558 2020-03-27 Midland Texas 48329 6 1
15559 15559 2020-03-27 Milam Texas 48331 2 0
15560 15560 2020-03-27 Montague Texas 48337 1 0
15561 15561 2020-03-27 Montgomery Texas 48339 46 0
15562 15562 2020-03-27 Morris Texas 48343 1 0
15563 15563 2020-03-27 Nacogdoches Texas 48347 1 0
15564 15564 2020-03-27 Navarro Texas 48349 1 0
15565 15565 2020-03-27 Nueces Texas 48355 18 0
15566 15566 2020-03-27 Oldham Texas 48359 1 1
15567 15567 2020-03-27 Orange Texas 48361 1 0
15568 15568 2020-03-27 Parker Texas 48367 2 0
15569 15569 2020-03-27 Potter Texas 48375 2 0
15570 15570 2020-03-27 Randall Texas 48381 3 0
15571 15571 2020-03-27 Robertson Texas 48395 1 0
15572 15572 2020-03-27 Rockwall Texas 48397 3 0
15573 15573 2020-03-27 Rusk Texas 48401 2 0
15574 15574 2020-03-27 San Patricio Texas 48409 1 0
15575 15575 2020-03-27 Shelby Texas 48419 1 0
15576 15576 2020-03-27 Smith Texas 48423 27 1
15577 15577 2020-03-27 Starr Texas 48427 2 0
15578 15578 2020-03-27 Tarrant Texas 48439 114 1
15579 15579 2020-03-27 Taylor Texas 48441 1 0
15580 15580 2020-03-27 Terry Texas 48445 1 0
15581 15581 2020-03-27 Tom Green Texas 48451 2 0
15582 15582 2020-03-27 Travis Texas 48453 160 1
15583 15583 2020-03-27 Upshur Texas 48459 1 0
15584 15584 2020-03-27 Uvalde Texas 48463 1 0
15585 15585 2020-03-27 Val Verde Texas 48465 2 0
15586 15586 2020-03-27 Van Zandt Texas 48467 1 0
15587 15587 2020-03-27 Victoria Texas 48469 3 0
15588 15588 2020-03-27 Walker Texas 48471 2 0
15589 15589 2020-03-27 Webb Texas 48479 22 0
15590 15590 2020-03-27 Wharton Texas 48481 3 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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