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 71,066
- Georgia 47,609
- Virginia 39,014
- Kentucky 34,732
- Missouri 33,205
- Illinois 29,767
- North Carolina 29,608
- Iowa 28,770
- Kansas 28,454
- Tennessee 28,447
- Indiana 27,450
- Ohio 26,250
- Minnesota 25,467
- Michigan 24,714
- Mississippi 24,566
- Nebraska 24,071
- Oklahoma 22,328
- Arkansas 22,324
- Wisconsin 21,287
- Florida 20,518
- Puerto Rico 20,319
- Pennsylvania 20,147
- Alabama 19,951
- Louisiana 19,573
- Colorado 18,615
- South Dakota 17,740
- New York 17,736
- California 17,671
- West Virginia 15,726
- North Dakota 14,471
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934416 | 934416 | 2021-01-16 | Wilson | Kansas | 20205 | 786 | 10 |
934417 | 934417 | 2021-01-16 | Woodson | Kansas | 20207 | 166 | 0 |
934418 | 934418 | 2021-01-16 | Wyandotte | Kansas | 20209 | 17217 | 209 |
934419 | 934419 | 2021-01-16 | Adair | Kentucky | 21001 | 1444 | 47 |
934420 | 934420 | 2021-01-16 | Allen | Kentucky | 21003 | 1403 | 19 |
934421 | 934421 | 2021-01-16 | Anderson | Kentucky | 21005 | 1251 | 4 |
934422 | 934422 | 2021-01-16 | Ballard | Kentucky | 21007 | 279 | 3 |
934423 | 934423 | 2021-01-16 | Barren | Kentucky | 21009 | 3005 | 35 |
934424 | 934424 | 2021-01-16 | Bath | Kentucky | 21011 | 627 | 10 |
934425 | 934425 | 2021-01-16 | Bell | Kentucky | 21013 | 2203 | 32 |
934426 | 934426 | 2021-01-16 | Boone | Kentucky | 21015 | 9927 | 47 |
934427 | 934427 | 2021-01-16 | Bourbon | Kentucky | 21017 | 1221 | 6 |
934428 | 934428 | 2021-01-16 | Boyd | Kentucky | 21019 | 3849 | 32 |
934429 | 934429 | 2021-01-16 | Boyle | Kentucky | 21021 | 2790 | 12 |
934430 | 934430 | 2021-01-16 | Bracken | Kentucky | 21023 | 381 | 3 |
934431 | 934431 | 2021-01-16 | Breathitt | Kentucky | 21025 | 760 | 3 |
934432 | 934432 | 2021-01-16 | Breckinridge | Kentucky | 21027 | 863 | 5 |
934433 | 934433 | 2021-01-16 | Bullitt | Kentucky | 21029 | 4935 | 31 |
934434 | 934434 | 2021-01-16 | Butler | Kentucky | 21031 | 1014 | 17 |
934435 | 934435 | 2021-01-16 | Caldwell | Kentucky | 21033 | 1042 | 17 |
934436 | 934436 | 2021-01-16 | Calloway | Kentucky | 21035 | 2816 | 29 |
934437 | 934437 | 2021-01-16 | Campbell | Kentucky | 21037 | 5938 | 39 |
934438 | 934438 | 2021-01-16 | Carlisle | Kentucky | 21039 | 386 | 1 |
934439 | 934439 | 2021-01-16 | Carroll | Kentucky | 21041 | 734 | 8 |
934440 | 934440 | 2021-01-16 | Carter | Kentucky | 21043 | 1640 | 18 |
934441 | 934441 | 2021-01-16 | Casey | Kentucky | 21045 | 1015 | 30 |
934442 | 934442 | 2021-01-16 | Christian | Kentucky | 21047 | 5200 | 69 |
934443 | 934443 | 2021-01-16 | Clark | Kentucky | 21049 | 1923 | 16 |
934444 | 934444 | 2021-01-16 | Clay | Kentucky | 21051 | 2035 | 14 |
934445 | 934445 | 2021-01-16 | Clinton | Kentucky | 21053 | 1175 | 22 |
934446 | 934446 | 2021-01-16 | Crittenden | Kentucky | 21055 | 465 | 3 |
934447 | 934447 | 2021-01-16 | Cumberland | Kentucky | 21057 | 531 | 7 |
934448 | 934448 | 2021-01-16 | Daviess | Kentucky | 21059 | 7367 | 118 |
934449 | 934449 | 2021-01-16 | Edmonson | Kentucky | 21061 | 666 | 13 |
934450 | 934450 | 2021-01-16 | Elliott | Kentucky | 21063 | 873 | 1 |
934451 | 934451 | 2021-01-16 | Estill | Kentucky | 21065 | 794 | 0 |
934452 | 934452 | 2021-01-16 | Fayette | Kentucky | 21067 | 26909 | 173 |
934453 | 934453 | 2021-01-16 | Fleming | Kentucky | 21069 | 885 | 4 |
934454 | 934454 | 2021-01-16 | Floyd | Kentucky | 21071 | 2316 | 16 |
934455 | 934455 | 2021-01-16 | Franklin | Kentucky | 21073 | 2575 | 23 |
934456 | 934456 | 2021-01-16 | Fulton | Kentucky | 21075 | 404 | 4 |
934457 | 934457 | 2021-01-16 | Gallatin | Kentucky | 21077 | 517 | 13 |
934458 | 934458 | 2021-01-16 | Garrard | Kentucky | 21079 | 1133 | 4 |
934459 | 934459 | 2021-01-16 | Grant | Kentucky | 21081 | 1585 | 10 |
934460 | 934460 | 2021-01-16 | Graves | Kentucky | 21083 | 3303 | 54 |
934461 | 934461 | 2021-01-16 | Grayson | Kentucky | 21085 | 1542 | 37 |
934462 | 934462 | 2021-01-16 | Green | Kentucky | 21087 | 910 | 12 |
934463 | 934463 | 2021-01-16 | Greenup | Kentucky | 21089 | 2806 | 21 |
934464 | 934464 | 2021-01-16 | Hancock | Kentucky | 21091 | 633 | 13 |
934465 | 934465 | 2021-01-16 | Hardin | Kentucky | 21093 | 7219 | 53 |
934466 | 934466 | 2021-01-16 | Harlan | Kentucky | 21095 | 1957 | 26 |
934467 | 934467 | 2021-01-16 | Harrison | Kentucky | 21097 | 1129 | 2 |
934468 | 934468 | 2021-01-16 | Hart | Kentucky | 21099 | 1422 | 12 |
934469 | 934469 | 2021-01-16 | Henderson | Kentucky | 21101 | 3619 | 52 |
934470 | 934470 | 2021-01-16 | Henry | Kentucky | 21103 | 967 | 5 |
934471 | 934471 | 2021-01-16 | Hickman | Kentucky | 21105 | 253 | 7 |
934472 | 934472 | 2021-01-16 | Hopkins | Kentucky | 21107 | 3248 | 113 |
934473 | 934473 | 2021-01-16 | Jackson | Kentucky | 21109 | 1042 | 22 |
934474 | 934474 | 2021-01-16 | Jefferson | Kentucky | 21111 | 61065 | 745 |
934475 | 934475 | 2021-01-16 | Jessamine | Kentucky | 21113 | 3129 | 48 |
934476 | 934476 | 2021-01-16 | Johnson | Kentucky | 21115 | 1407 | 16 |
934477 | 934477 | 2021-01-16 | Kenton | Kentucky | 21117 | 11654 | 91 |
934478 | 934478 | 2021-01-16 | Knott | Kentucky | 21119 | 829 | 14 |
934479 | 934479 | 2021-01-16 | Knox | Kentucky | 21121 | 2266 | 10 |
934480 | 934480 | 2021-01-16 | Larue | Kentucky | 21123 | 957 | 6 |
934481 | 934481 | 2021-01-16 | Laurel | Kentucky | 21125 | 4590 | 17 |
934482 | 934482 | 2021-01-16 | Lawrence | Kentucky | 21127 | 993 | 5 |
934483 | 934483 | 2021-01-16 | Lee | Kentucky | 21129 | 1098 | 18 |
934484 | 934484 | 2021-01-16 | Leslie | Kentucky | 21131 | 624 | 2 |
934485 | 934485 | 2021-01-16 | Letcher | Kentucky | 21133 | 1351 | 5 |
934486 | 934486 | 2021-01-16 | Lewis | Kentucky | 21135 | 935 | 28 |
934487 | 934487 | 2021-01-16 | Lincoln | Kentucky | 21137 | 1722 | 28 |
934488 | 934488 | 2021-01-16 | Livingston | Kentucky | 21139 | 577 | 15 |
934489 | 934489 | 2021-01-16 | Logan | Kentucky | 21141 | 1979 | 43 |
934490 | 934490 | 2021-01-16 | Lyon | Kentucky | 21143 | 376 | 8 |
934491 | 934491 | 2021-01-16 | Madison | Kentucky | 21151 | 6786 | 45 |
934492 | 934492 | 2021-01-16 | Magoffin | Kentucky | 21153 | 773 | 1 |
934493 | 934493 | 2021-01-16 | Marion | Kentucky | 21155 | 1742 | 20 |
934494 | 934494 | 2021-01-16 | Marshall | Kentucky | 21157 | 1947 | 25 |
934495 | 934495 | 2021-01-16 | Martin | Kentucky | 21159 | 775 | 10 |
934496 | 934496 | 2021-01-16 | Mason | Kentucky | 21161 | 1103 | 24 |
934497 | 934497 | 2021-01-16 | McCracken | Kentucky | 21145 | 4848 | 47 |
934498 | 934498 | 2021-01-16 | McCreary | Kentucky | 21147 | 1352 | 15 |
934499 | 934499 | 2021-01-16 | McLean | Kentucky | 21149 | 678 | 22 |
934500 | 934500 | 2021-01-16 | Meade | Kentucky | 21163 | 1418 | 5 |
934501 | 934501 | 2021-01-16 | Menifee | Kentucky | 21165 | 275 | 2 |
934502 | 934502 | 2021-01-16 | Mercer | Kentucky | 21167 | 1917 | 11 |
934503 | 934503 | 2021-01-16 | Metcalfe | Kentucky | 21169 | 701 | 12 |
934504 | 934504 | 2021-01-16 | Monroe | Kentucky | 21171 | 1089 | 28 |
934505 | 934505 | 2021-01-16 | Montgomery | Kentucky | 21173 | 1773 | 15 |
934506 | 934506 | 2021-01-16 | Morgan | Kentucky | 21175 | 1697 | 0 |
934507 | 934507 | 2021-01-16 | Muhlenberg | Kentucky | 21177 | 2375 | 41 |
934508 | 934508 | 2021-01-16 | Nelson | Kentucky | 21179 | 3585 | 23 |
934509 | 934509 | 2021-01-16 | Nicholas | Kentucky | 21181 | 378 | 4 |
934510 | 934510 | 2021-01-16 | Ohio | Kentucky | 21183 | 1906 | 34 |
934511 | 934511 | 2021-01-16 | Oldham | Kentucky | 21185 | 5492 | 47 |
934512 | 934512 | 2021-01-16 | Owen | Kentucky | 21187 | 499 | 7 |
934513 | 934513 | 2021-01-16 | Owsley | Kentucky | 21189 | 355 | 10 |
934514 | 934514 | 2021-01-16 | Pendleton | Kentucky | 21191 | 738 | 1 |
934515 | 934515 | 2021-01-16 | Perry | Kentucky | 21193 | 1845 | 17 |
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);