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 191,482
- Georgia 123,449
- Virginia 102,064
- Kentucky 91,612
- Missouri 88,664
- Illinois 78,575
- Kansas 78,382
- North Carolina 77,009
- Iowa 76,170
- Tennessee 73,951
- Indiana 71,084
- Nebraska 68,503
- Ohio 68,389
- Minnesota 67,179
- Michigan 64,530
- Mississippi 63,484
- Oklahoma 59,299
- Arkansas 58,348
- Puerto Rico 57,765
- Wisconsin 55,417
- Florida 52,750
- Pennsylvania 51,905
- Alabama 51,709
- Louisiana 50,382
- South Dakota 49,024
- Colorado 48,951
- New York 45,228
- California 45,171
- West Virginia 41,798
- Montana 40,208
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474474 | 2474474 | 2022-05-05 | Morton | Kansas | 20129 | 620 | 11 |
2474475 | 2474475 | 2022-05-05 | Nemaha | Kansas | 20131 | 3238 | 60 |
2474476 | 2474476 | 2022-05-05 | Neosho | Kansas | 20133 | 5159 | 66 |
2474477 | 2474477 | 2022-05-05 | Ness | Kansas | 20135 | 780 | 18 |
2474478 | 2474478 | 2022-05-05 | Norton | Kansas | 20137 | 2153 | 37 |
2474479 | 2474479 | 2022-05-05 | Osage | Kansas | 20139 | 3922 | 49 |
2474480 | 2474480 | 2022-05-05 | Osborne | Kansas | 20141 | 803 | 17 |
2474481 | 2474481 | 2022-05-05 | Ottawa | Kansas | 20143 | 1208 | 17 |
2474482 | 2474482 | 2022-05-05 | Pawnee | Kansas | 20145 | 2137 | 24 |
2474483 | 2474483 | 2022-05-05 | Phillips | Kansas | 20147 | 1357 | 30 |
2474484 | 2474484 | 2022-05-05 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2474485 | 2474485 | 2022-05-05 | Pratt | Kansas | 20151 | 1926 | 30 |
2474486 | 2474486 | 2022-05-05 | Rawlins | Kansas | 20153 | 678 | 9 |
2474487 | 2474487 | 2022-05-05 | Reno | Kansas | 20155 | 18594 | 236 |
2474488 | 2474488 | 2022-05-05 | Republic | Kansas | 20157 | 1348 | 16 |
2474489 | 2474489 | 2022-05-05 | Rice | Kansas | 20159 | 2611 | 23 |
2474490 | 2474490 | 2022-05-05 | Riley | Kansas | 20161 | 13624 | 84 |
2474491 | 2474491 | 2022-05-05 | Rooks | Kansas | 20163 | 1371 | 20 |
2474492 | 2474492 | 2022-05-05 | Rush | Kansas | 20165 | 808 | 18 |
2474493 | 2474493 | 2022-05-05 | Russell | Kansas | 20167 | 1882 | 37 |
2474494 | 2474494 | 2022-05-05 | Saline | Kansas | 20169 | 14124 | 244 |
2474495 | 2474495 | 2022-05-05 | Scott | Kansas | 20171 | 1275 | 34 |
2474496 | 2474496 | 2022-05-05 | Sedgwick | Kansas | 20173 | 144967 | 1411 |
2474497 | 2474497 | 2022-05-05 | Seward | Kansas | 20175 | 6913 | 61 |
2474498 | 2474498 | 2022-05-05 | Shawnee | Kansas | 20177 | 48484 | 630 |
2474499 | 2474499 | 2022-05-05 | Sheridan | Kansas | 20179 | 785 | 18 |
2474500 | 2474500 | 2022-05-05 | Sherman | Kansas | 20181 | 1511 | 20 |
2474501 | 2474501 | 2022-05-05 | Smith | Kansas | 20183 | 644 | 7 |
2474502 | 2474502 | 2022-05-05 | Stafford | Kansas | 20185 | 1139 | 26 |
2474503 | 2474503 | 2022-05-05 | Stanton | Kansas | 20187 | 426 | 8 |
2474504 | 2474504 | 2022-05-05 | Stevens | Kansas | 20189 | 1464 | 20 |
2474505 | 2474505 | 2022-05-05 | Sumner | Kansas | 20191 | 5717 | 70 |
2474506 | 2474506 | 2022-05-05 | Thomas | Kansas | 20193 | 2389 | 28 |
2474507 | 2474507 | 2022-05-05 | Trego | Kansas | 20195 | 755 | 10 |
2474508 | 2474508 | 2022-05-05 | Unknown | Kansas | 0 | 90 | |
2474509 | 2474509 | 2022-05-05 | Wabaunsee | Kansas | 20197 | 1638 | 22 |
2474510 | 2474510 | 2022-05-05 | Wallace | Kansas | 20199 | 438 | 5 |
2474511 | 2474511 | 2022-05-05 | Washington | Kansas | 20201 | 1396 | 22 |
2474512 | 2474512 | 2022-05-05 | Wichita | Kansas | 20203 | 493 | 8 |
2474513 | 2474513 | 2022-05-05 | Wilson | Kansas | 20205 | 2822 | 43 |
2474514 | 2474514 | 2022-05-05 | Woodson | Kansas | 20207 | 796 | 15 |
2474515 | 2474515 | 2022-05-05 | Wyandotte | Kansas | 20209 | 47076 | 500 |
2474516 | 2474516 | 2022-05-05 | Adair | Kentucky | 21001 | 5927 | 107 |
2474517 | 2474517 | 2022-05-05 | Allen | Kentucky | 21003 | 6598 | 104 |
2474518 | 2474518 | 2022-05-05 | Anderson | Kentucky | 21005 | 6603 | 69 |
2474519 | 2474519 | 2022-05-05 | Ballard | Kentucky | 21007 | 1384 | 28 |
2474520 | 2474520 | 2022-05-05 | Barren | Kentucky | 21009 | 13022 | 218 |
2474521 | 2474521 | 2022-05-05 | Bath | Kentucky | 21011 | 3199 | 45 |
2474522 | 2474522 | 2022-05-05 | Bell | Kentucky | 21013 | 8866 | 149 |
2474523 | 2474523 | 2022-05-05 | Boone | Kentucky | 21015 | 39848 | 290 |
2474524 | 2474524 | 2022-05-05 | Bourbon | Kentucky | 21017 | 5991 | 57 |
2474525 | 2474525 | 2022-05-05 | Boyd | Kentucky | 21019 | 16332 | 177 |
2474526 | 2474526 | 2022-05-05 | Boyle | Kentucky | 21021 | 8457 | 130 |
2474527 | 2474527 | 2022-05-05 | Bracken | Kentucky | 21023 | 2183 | 26 |
2474528 | 2474528 | 2022-05-05 | Breathitt | Kentucky | 21025 | 3796 | 54 |
2474529 | 2474529 | 2022-05-05 | Breckinridge | Kentucky | 21027 | 5154 | 78 |
2474530 | 2474530 | 2022-05-05 | Bullitt | Kentucky | 21029 | 21719 | 222 |
2474531 | 2474531 | 2022-05-05 | Butler | Kentucky | 21031 | 3870 | 54 |
2474532 | 2474532 | 2022-05-05 | Caldwell | Kentucky | 21033 | 4155 | 60 |
2474533 | 2474533 | 2022-05-05 | Calloway | Kentucky | 21035 | 8356 | 93 |
2474534 | 2474534 | 2022-05-05 | Campbell | Kentucky | 21037 | 24871 | 177 |
2474535 | 2474535 | 2022-05-05 | Carlisle | Kentucky | 21039 | 1072 | 20 |
2474536 | 2474536 | 2022-05-05 | Carroll | Kentucky | 21041 | 3500 | 45 |
2474537 | 2474537 | 2022-05-05 | Carter | Kentucky | 21043 | 8650 | 107 |
2474538 | 2474538 | 2022-05-05 | Casey | Kentucky | 21045 | 4212 | 72 |
2474539 | 2474539 | 2022-05-05 | Christian | Kentucky | 21047 | 16367 | 210 |
2474540 | 2474540 | 2022-05-05 | Clark | Kentucky | 21049 | 10690 | 67 |
2474541 | 2474541 | 2022-05-05 | Clay | Kentucky | 21051 | 7866 | 92 |
2474542 | 2474542 | 2022-05-05 | Clinton | Kentucky | 21053 | 3667 | 52 |
2474543 | 2474543 | 2022-05-05 | Crittenden | Kentucky | 21055 | 2293 | 49 |
2474544 | 2474544 | 2022-05-05 | Cumberland | Kentucky | 21057 | 2237 | 31 |
2474545 | 2474545 | 2022-05-05 | Daviess | Kentucky | 21059 | 31142 | 390 |
2474546 | 2474546 | 2022-05-05 | Edmonson | Kentucky | 21061 | 2560 | 46 |
2474547 | 2474547 | 2022-05-05 | Elliott | Kentucky | 21063 | 2563 | 19 |
2474548 | 2474548 | 2022-05-05 | Estill | Kentucky | 21065 | 4116 | 48 |
2474549 | 2474549 | 2022-05-05 | Fayette | Kentucky | 21067 | 95539 | 602 |
2474550 | 2474550 | 2022-05-05 | Fleming | Kentucky | 21069 | 3907 | 56 |
2474551 | 2474551 | 2022-05-05 | Floyd | Kentucky | 21071 | 12549 | 198 |
2474552 | 2474552 | 2022-05-05 | Franklin | Kentucky | 21073 | 13870 | 153 |
2474553 | 2474553 | 2022-05-05 | Fulton | Kentucky | 21075 | 1217 | 29 |
2474554 | 2474554 | 2022-05-05 | Gallatin | Kentucky | 21077 | 2217 | 50 |
2474555 | 2474555 | 2022-05-05 | Garrard | Kentucky | 21079 | 4813 | 77 |
2474556 | 2474556 | 2022-05-05 | Grant | Kentucky | 21081 | 7802 | 61 |
2474557 | 2474557 | 2022-05-05 | Graves | Kentucky | 21083 | 11345 | 180 |
2474558 | 2474558 | 2022-05-05 | Grayson | Kentucky | 21085 | 8008 | 133 |
2474559 | 2474559 | 2022-05-05 | Green | Kentucky | 21087 | 3752 | 45 |
2474560 | 2474560 | 2022-05-05 | Greenup | Kentucky | 21089 | 12076 | 144 |
2474561 | 2474561 | 2022-05-05 | Hancock | Kentucky | 21091 | 2495 | 24 |
2474562 | 2474562 | 2022-05-05 | Hardin | Kentucky | 21093 | 32662 | 433 |
2474563 | 2474563 | 2022-05-05 | Harlan | Kentucky | 21095 | 9215 | 210 |
2474564 | 2474564 | 2022-05-05 | Harrison | Kentucky | 21097 | 6405 | 72 |
2474565 | 2474565 | 2022-05-05 | Hart | Kentucky | 21099 | 5423 | 100 |
2474566 | 2474566 | 2022-05-05 | Henderson | Kentucky | 21101 | 13941 | 165 |
2474567 | 2474567 | 2022-05-05 | Henry | Kentucky | 21103 | 4807 | 52 |
2474568 | 2474568 | 2022-05-05 | Hickman | Kentucky | 21105 | 877 | 27 |
2474569 | 2474569 | 2022-05-05 | Hopkins | Kentucky | 21107 | 14954 | 252 |
2474570 | 2474570 | 2022-05-05 | Jackson | Kentucky | 21109 | 4281 | 80 |
2474571 | 2474571 | 2022-05-05 | Jefferson | Kentucky | 21111 | 232332 | 2348 |
2474572 | 2474572 | 2022-05-05 | Jessamine | Kentucky | 21113 | 15239 | 138 |
2474573 | 2474573 | 2022-05-05 | Johnson | Kentucky | 21115 | 6153 | 117 |
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);