ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 68,780
- Georgia 46,169
- Virginia 37,817
- Kentucky 33,532
- Missouri 32,035
- Illinois 28,849
- North Carolina 28,608
- Iowa 27,870
- Tennessee 27,583
- Kansas 27,497
- Indiana 26,622
- Ohio 25,370
- Minnesota 24,587
- Michigan 23,874
- Mississippi 23,746
- Nebraska 23,141
- Arkansas 21,640
- Oklahoma 21,548
- Wisconsin 20,639
- Florida 19,906
- Puerto Rico 19,608
- Pennsylvania 19,544
- Alabama 19,348
- Louisiana 18,923
- Colorado 18,039
- New York 17,156
- California 17,149
- South Dakota 17,146
- West Virginia 15,231
- North Dakota 13,931
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
906467 | 906467 | 2021-01-07 | Umatilla | Oregon | 41059 | 6146 | 59 |
906468 | 906468 | 2021-01-07 | Union | Oregon | 41061 | 1012 | 16 |
906469 | 906469 | 2021-01-07 | Wallowa | Oregon | 41063 | 86 | 3 |
906470 | 906470 | 2021-01-07 | Wasco | Oregon | 41065 | 952 | 22 |
906471 | 906471 | 2021-01-07 | Washington | Oregon | 41067 | 16902 | 152 |
906472 | 906472 | 2021-01-07 | Wheeler | Oregon | 41069 | 17 | 1 |
906473 | 906473 | 2021-01-07 | Yamhill | Oregon | 41071 | 2866 | 37 |
906474 | 906474 | 2021-01-07 | Adams | Pennsylvania | 42001 | 5059 | 108 |
906475 | 906475 | 2021-01-07 | Allegheny | Pennsylvania | 42003 | 58372 | 1118 |
906476 | 906476 | 2021-01-07 | Armstrong | Pennsylvania | 42005 | 3823 | 76 |
906477 | 906477 | 2021-01-07 | Beaver | Pennsylvania | 42007 | 9185 | 269 |
906478 | 906478 | 2021-01-07 | Bedford | Pennsylvania | 42009 | 3129 | 99 |
906479 | 906479 | 2021-01-07 | Berks | Pennsylvania | 42011 | 25523 | 605 |
906480 | 906480 | 2021-01-07 | Blair | Pennsylvania | 42013 | 8517 | 185 |
906481 | 906481 | 2021-01-07 | Bradford | Pennsylvania | 42015 | 3284 | 59 |
906482 | 906482 | 2021-01-07 | Bucks | Pennsylvania | 42017 | 32988 | 928 |
906483 | 906483 | 2021-01-07 | Butler | Pennsylvania | 42019 | 10349 | 225 |
906484 | 906484 | 2021-01-07 | Cambria | Pennsylvania | 42021 | 9342 | 271 |
906485 | 906485 | 2021-01-07 | Cameron | Pennsylvania | 42023 | 181 | 4 |
906486 | 906486 | 2021-01-07 | Carbon | Pennsylvania | 42025 | 3198 | 95 |
906487 | 906487 | 2021-01-07 | Centre | Pennsylvania | 42027 | 9444 | 148 |
906488 | 906488 | 2021-01-07 | Chester | Pennsylvania | 42029 | 22280 | 555 |
906489 | 906489 | 2021-01-07 | Clarion | Pennsylvania | 42031 | 2171 | 50 |
906490 | 906490 | 2021-01-07 | Clearfield | Pennsylvania | 42033 | 4559 | 55 |
906491 | 906491 | 2021-01-07 | Clinton | Pennsylvania | 42035 | 2108 | 30 |
906492 | 906492 | 2021-01-07 | Columbia | Pennsylvania | 42037 | 3147 | 82 |
906493 | 906493 | 2021-01-07 | Crawford | Pennsylvania | 42039 | 5144 | 92 |
906494 | 906494 | 2021-01-07 | Cumberland | Pennsylvania | 42041 | 11302 | 329 |
906495 | 906495 | 2021-01-07 | Dauphin | Pennsylvania | 42043 | 14879 | 341 |
906496 | 906496 | 2021-01-07 | Delaware | Pennsylvania | 42045 | 31675 | 1022 |
906497 | 906497 | 2021-01-07 | Elk | Pennsylvania | 42047 | 1605 | 21 |
906498 | 906498 | 2021-01-07 | Erie | Pennsylvania | 42049 | 12599 | 247 |
906499 | 906499 | 2021-01-07 | Fayette | Pennsylvania | 42051 | 8096 | 133 |
906500 | 906500 | 2021-01-07 | Forest | Pennsylvania | 42053 | 354 | 4 |
906501 | 906501 | 2021-01-07 | Franklin | Pennsylvania | 42055 | 9515 | 253 |
906502 | 906502 | 2021-01-07 | Fulton | Pennsylvania | 42057 | 819 | 11 |
906503 | 906503 | 2021-01-07 | Greene | Pennsylvania | 42059 | 1889 | 19 |
906504 | 906504 | 2021-01-07 | Huntingdon | Pennsylvania | 42061 | 3306 | 90 |
906505 | 906505 | 2021-01-07 | Indiana | Pennsylvania | 42063 | 4242 | 130 |
906506 | 906506 | 2021-01-07 | Jefferson | Pennsylvania | 42065 | 2062 | 50 |
906507 | 906507 | 2021-01-07 | Juniata | Pennsylvania | 42067 | 1457 | 55 |
906508 | 906508 | 2021-01-07 | Lackawanna | Pennsylvania | 42069 | 9747 | 276 |
906509 | 906509 | 2021-01-07 | Lancaster | Pennsylvania | 42071 | 30347 | 773 |
906510 | 906510 | 2021-01-07 | Lawrence | Pennsylvania | 42073 | 4579 | 135 |
906511 | 906511 | 2021-01-07 | Lebanon | Pennsylvania | 42075 | 9629 | 166 |
906512 | 906512 | 2021-01-07 | Lehigh | Pennsylvania | 42077 | 22433 | 536 |
906513 | 906513 | 2021-01-07 | Luzerne | Pennsylvania | 42079 | 18654 | 491 |
906514 | 906514 | 2021-01-07 | Lycoming | Pennsylvania | 42081 | 6545 | 137 |
906515 | 906515 | 2021-01-07 | McKean | Pennsylvania | 42083 | 1930 | 26 |
906516 | 906516 | 2021-01-07 | Mercer | Pennsylvania | 42085 | 6366 | 154 |
906517 | 906517 | 2021-01-07 | Mifflin | Pennsylvania | 42087 | 3658 | 123 |
906518 | 906518 | 2021-01-07 | Monroe | Pennsylvania | 42089 | 6736 | 212 |
906519 | 906519 | 2021-01-07 | Montgomery | Pennsylvania | 42091 | 39388 | 1207 |
906520 | 906520 | 2021-01-07 | Montour | Pennsylvania | 42093 | 1202 | 30 |
906521 | 906521 | 2021-01-07 | Northampton | Pennsylvania | 42095 | 18331 | 469 |
906522 | 906522 | 2021-01-07 | Northumberland | Pennsylvania | 42097 | 5479 | 245 |
906523 | 906523 | 2021-01-07 | Perry | Pennsylvania | 42099 | 1896 | 46 |
906524 | 906524 | 2021-01-07 | Philadelphia | Pennsylvania | 42101 | 97891 | 2576 |
906525 | 906525 | 2021-01-07 | Pike | Pennsylvania | 42103 | 1613 | 35 |
906526 | 906526 | 2021-01-07 | Potter | Pennsylvania | 42105 | 665 | 15 |
906527 | 906527 | 2021-01-07 | Schuylkill | Pennsylvania | 42107 | 8969 | 261 |
906528 | 906528 | 2021-01-07 | Snyder | Pennsylvania | 42109 | 2076 | 48 |
906529 | 906529 | 2021-01-07 | Somerset | Pennsylvania | 42111 | 5275 | 98 |
906530 | 906530 | 2021-01-07 | Sullivan | Pennsylvania | 42113 | 177 | 3 |
906531 | 906531 | 2021-01-07 | Susquehanna | Pennsylvania | 42115 | 1132 | 39 |
906532 | 906532 | 2021-01-07 | Tioga | Pennsylvania | 42117 | 2029 | 70 |
906533 | 906533 | 2021-01-07 | Union | Pennsylvania | 42119 | 3157 | 49 |
906534 | 906534 | 2021-01-07 | Venango | Pennsylvania | 42121 | 2609 | 55 |
906535 | 906535 | 2021-01-07 | Warren | Pennsylvania | 42123 | 1677 | 46 |
906536 | 906536 | 2021-01-07 | Washington | Pennsylvania | 42125 | 9900 | 148 |
906537 | 906537 | 2021-01-07 | Wayne | Pennsylvania | 42127 | 2111 | 21 |
906538 | 906538 | 2021-01-07 | Westmoreland | Pennsylvania | 42129 | 21003 | 465 |
906539 | 906539 | 2021-01-07 | Wyoming | Pennsylvania | 42131 | 862 | 32 |
906540 | 906540 | 2021-01-07 | York | Pennsylvania | 42133 | 25349 | 474 |
906541 | 906541 | 2021-01-07 | Adjuntas | Puerto Rico | 72001 | 419 | |
906542 | 906542 | 2021-01-07 | Aguada | Puerto Rico | 72003 | 963 | |
906543 | 906543 | 2021-01-07 | Aguadilla | Puerto Rico | 72005 | 1258 | |
906544 | 906544 | 2021-01-07 | Aguas Buenas | Puerto Rico | 72007 | 849 | |
906545 | 906545 | 2021-01-07 | Aibonito | Puerto Rico | 72009 | 454 | |
906546 | 906546 | 2021-01-07 | Anasco | Puerto Rico | 72011 | 688 | |
906547 | 906547 | 2021-01-07 | Arecibo | Puerto Rico | 72013 | 2415 | |
906548 | 906548 | 2021-01-07 | Arroyo | Puerto Rico | 72015 | 316 | |
906549 | 906549 | 2021-01-07 | Barceloneta | Puerto Rico | 72017 | 622 | |
906550 | 906550 | 2021-01-07 | Barranquitas | Puerto Rico | 72019 | 1021 | |
906551 | 906551 | 2021-01-07 | Bayamon | Puerto Rico | 72021 | 8297 | |
906552 | 906552 | 2021-01-07 | Cabo Rojo | Puerto Rico | 72023 | 773 | |
906553 | 906553 | 2021-01-07 | Caguas | Puerto Rico | 72025 | 4705 | |
906554 | 906554 | 2021-01-07 | Camuy | Puerto Rico | 72027 | 953 | |
906555 | 906555 | 2021-01-07 | Canovanas | Puerto Rico | 72029 | 1500 | |
906556 | 906556 | 2021-01-07 | Carolina | Puerto Rico | 72031 | 6744 | |
906557 | 906557 | 2021-01-07 | Catano | Puerto Rico | 72033 | 1033 | |
906558 | 906558 | 2021-01-07 | Cayey | Puerto Rico | 72035 | 1099 | |
906559 | 906559 | 2021-01-07 | Ceiba | Puerto Rico | 72037 | 334 | |
906560 | 906560 | 2021-01-07 | Ciales | Puerto Rico | 72039 | 613 | |
906561 | 906561 | 2021-01-07 | Cidra | Puerto Rico | 72041 | 994 | |
906562 | 906562 | 2021-01-07 | Coamo | Puerto Rico | 72043 | 792 | |
906563 | 906563 | 2021-01-07 | Comerio | Puerto Rico | 72045 | 622 | |
906564 | 906564 | 2021-01-07 | Corozal | Puerto Rico | 72047 | 1437 | |
906565 | 906565 | 2021-01-07 | Culebra | Puerto Rico | 72049 | 28 | |
906566 | 906566 | 2021-01-07 | Dorado | Puerto Rico | 72051 | 1897 |
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);