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 56
- Texas 168,366
- Georgia 108,889
- Virginia 89,958
- Kentucky 80,572
- Missouri 77,900
- Illinois 69,202
- Kansas 68,758
- North Carolina 67,818
- Iowa 67,070
- Tennessee 65,215
- Indiana 62,686
- Ohio 60,290
- Nebraska 59,855
- Minnesota 59,083
- Michigan 56,802
- Mississippi 55,890
- Oklahoma 52,201
- Arkansas 51,432
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,562
- Pennsylvania 45,808
- Alabama 45,612
- Louisiana 44,402
- Colorado 43,127
- South Dakota 43,018
- California 39,892
- New York 39,892
- West Virginia 36,793
- North Dakota 35,153
- Montana 35,056
- South Carolina 31,537
- Idaho 28,784
- Washington 27,022
- Oregon 24,219
- New Mexico 22,087
- Utah 19,949
- Alaska 17,770
- Maryland 17,145
- Wyoming 15,538
- New Jersey 15,217
- Maine 11,398
- Nevada 11,107
- Arizona 10,419
- Massachusetts 10,414
- Vermont 10,273
- New Hampshire 7,512
- Connecticut 6,191
- Rhode Island 4,110
- Hawaii 3,382
- Delaware 2,731
- Virgin Islands 2,184
- Northern Mariana Islands 1,441
- District of Columbia 698
- Guam 690
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179444 | 2179444 | 2022-02-03 | Wake | North Carolina | 37183 | 270169 | 967 |
2179445 | 2179445 | 2022-02-03 | Warren | North Carolina | 37185 | 3986 | 38 |
2179446 | 2179446 | 2022-02-03 | Washington | North Carolina | 37187 | 2822 | 42 |
2179447 | 2179447 | 2022-02-03 | Watauga | North Carolina | 37189 | 10961 | 49 |
2179448 | 2179448 | 2022-02-03 | Wayne | North Carolina | 37191 | 26360 | 359 |
2179449 | 2179449 | 2022-02-03 | Wilkes | North Carolina | 37193 | 16285 | 233 |
2179450 | 2179450 | 2022-02-03 | Wilson | North Carolina | 37195 | 20129 | 260 |
2179451 | 2179451 | 2022-02-03 | Yadkin | North Carolina | 37197 | 10094 | 98 |
2179452 | 2179452 | 2022-02-03 | Yancey | North Carolina | 37199 | 4425 | 46 |
2179453 | 2179453 | 2022-02-03 | Adams | North Dakota | 38001 | 556 | 9 |
2179454 | 2179454 | 2022-02-03 | Barnes | North Dakota | 38003 | 2819 | 44 |
2179455 | 2179455 | 2022-02-03 | Benson | North Dakota | 38005 | 1809 | 22 |
2179456 | 2179456 | 2022-02-03 | Billings | North Dakota | 38007 | 139 | 1 |
2179457 | 2179457 | 2022-02-03 | Bottineau | North Dakota | 38009 | 1501 | 24 |
2179458 | 2179458 | 2022-02-03 | Bowman | North Dakota | 38011 | 794 | 9 |
2179459 | 2179459 | 2022-02-03 | Burke | North Dakota | 38013 | 421 | 3 |
2179460 | 2179460 | 2022-02-03 | Burleigh | North Dakota | 38015 | 33218 | 291 |
2179461 | 2179461 | 2022-02-03 | Cass | North Dakota | 38017 | 56257 | 315 |
2179462 | 2179462 | 2022-02-03 | Cavalier | North Dakota | 38019 | 755 | 7 |
2179463 | 2179463 | 2022-02-03 | Dickey | North Dakota | 38021 | 1433 | 38 |
2179464 | 2179464 | 2022-02-03 | Divide | North Dakota | 38023 | 447 | 4 |
2179465 | 2179465 | 2022-02-03 | Dunn | North Dakota | 38025 | 981 | 8 |
2179466 | 2179466 | 2022-02-03 | Eddy | North Dakota | 38027 | 720 | 6 |
2179467 | 2179467 | 2022-02-03 | Emmons | North Dakota | 38029 | 699 | 17 |
2179468 | 2179468 | 2022-02-03 | Foster | North Dakota | 38031 | 934 | 20 |
2179469 | 2179469 | 2022-02-03 | Golden Valley | North Dakota | 38033 | 461 | 4 |
2179470 | 2179470 | 2022-02-03 | Grand Forks | North Dakota | 38035 | 20855 | 114 |
2179471 | 2179471 | 2022-02-03 | Grant | North Dakota | 38037 | 441 | 11 |
2179472 | 2179472 | 2022-02-03 | Griggs | North Dakota | 38039 | 555 | 2 |
2179473 | 2179473 | 2022-02-03 | Hettinger | North Dakota | 38041 | 796 | 7 |
2179474 | 2179474 | 2022-02-03 | Kidder | North Dakota | 38043 | 477 | 13 |
2179475 | 2179475 | 2022-02-03 | LaMoure | North Dakota | 38045 | 942 | 19 |
2179476 | 2179476 | 2022-02-03 | Logan | North Dakota | 38047 | 418 | 11 |
2179477 | 2179477 | 2022-02-03 | McHenry | North Dakota | 38049 | 1236 | 30 |
2179478 | 2179478 | 2022-02-03 | McIntosh | North Dakota | 38051 | 618 | 9 |
2179479 | 2179479 | 2022-02-03 | McKenzie | North Dakota | 38053 | 3130 | 24 |
2179480 | 2179480 | 2022-02-03 | McLean | North Dakota | 38055 | 2643 | 49 |
2179481 | 2179481 | 2022-02-03 | Mercer | North Dakota | 38057 | 2461 | 23 |
2179482 | 2179482 | 2022-02-03 | Morton | North Dakota | 38059 | 10718 | 138 |
2179483 | 2179483 | 2022-02-03 | Mountrail | North Dakota | 38061 | 3041 | 33 |
2179484 | 2179484 | 2022-02-03 | Nelson | North Dakota | 38063 | 723 | 17 |
2179485 | 2179485 | 2022-02-03 | Oliver | North Dakota | 38065 | 315 | 4 |
2179486 | 2179486 | 2022-02-03 | Pembina | North Dakota | 38067 | 1882 | 16 |
2179487 | 2179487 | 2022-02-03 | Pierce | North Dakota | 38069 | 1024 | 31 |
2179488 | 2179488 | 2022-02-03 | Ramsey | North Dakota | 38071 | 3345 | 48 |
2179489 | 2179489 | 2022-02-03 | Ransom | North Dakota | 38073 | 1408 | 26 |
2179490 | 2179490 | 2022-02-03 | Renville | North Dakota | 38075 | 533 | 15 |
2179491 | 2179491 | 2022-02-03 | Richland | North Dakota | 38077 | 3860 | 21 |
2179492 | 2179492 | 2022-02-03 | Rolette | North Dakota | 38079 | 5432 | 39 |
2179493 | 2179493 | 2022-02-03 | Sargent | North Dakota | 38081 | 982 | 9 |
2179494 | 2179494 | 2022-02-03 | Sheridan | North Dakota | 38083 | 276 | 6 |
2179495 | 2179495 | 2022-02-03 | Sioux | North Dakota | 38085 | 1284 | 19 |
2179496 | 2179496 | 2022-02-03 | Slope | North Dakota | 38087 | 62 | 0 |
2179497 | 2179497 | 2022-02-03 | Stark | North Dakota | 38089 | 11123 | 80 |
2179498 | 2179498 | 2022-02-03 | Steele | North Dakota | 38091 | 376 | 2 |
2179499 | 2179499 | 2022-02-03 | Stutsman | North Dakota | 38093 | 6558 | 94 |
2179500 | 2179500 | 2022-02-03 | Towner | North Dakota | 38095 | 598 | 12 |
2179501 | 2179501 | 2022-02-03 | Traill | North Dakota | 38097 | 2062 | 22 |
2179502 | 2179502 | 2022-02-03 | Unknown | North Dakota | 0 | 47 | |
2179503 | 2179503 | 2022-02-03 | Walsh | North Dakota | 38099 | 3194 | 34 |
2179504 | 2179504 | 2022-02-03 | Ward | North Dakota | 38101 | 19730 | 243 |
2179505 | 2179505 | 2022-02-03 | Wells | North Dakota | 38103 | 983 | 11 |
2179506 | 2179506 | 2022-02-03 | Williams | North Dakota | 38105 | 10062 | 67 |
2179507 | 2179507 | 2022-02-03 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2179508 | 2179508 | 2022-02-03 | Saipan | Northern Mariana Islands | 69110 | 5190 | 23 |
2179509 | 2179509 | 2022-02-03 | Tinian | Northern Mariana Islands | 69120 | 24 | 0 |
2179510 | 2179510 | 2022-02-03 | Unknown | Northern Mariana Islands | 295 | 0 | |
2179511 | 2179511 | 2022-02-03 | Adams | Ohio | 39001 | 6667 | 132 |
2179512 | 2179512 | 2022-02-03 | Allen | Ohio | 39003 | 26888 | 416 |
2179513 | 2179513 | 2022-02-03 | Ashland | Ohio | 39005 | 11642 | 195 |
2179514 | 2179514 | 2022-02-03 | Ashtabula | Ohio | 39007 | 19049 | 373 |
2179515 | 2179515 | 2022-02-03 | Athens | Ohio | 39009 | 13631 | 112 |
2179516 | 2179516 | 2022-02-03 | Auglaize | Ohio | 39011 | 11317 | 158 |
2179517 | 2179517 | 2022-02-03 | Belmont | Ohio | 39013 | 15093 | 257 |
2179518 | 2179518 | 2022-02-03 | Brown | Ohio | 39015 | 10816 | 149 |
2179519 | 2179519 | 2022-02-03 | Butler | Ohio | 39017 | 87660 | 1005 |
2179520 | 2179520 | 2022-02-03 | Carroll | Ohio | 39019 | 5163 | 108 |
2179521 | 2179521 | 2022-02-03 | Champaign | Ohio | 39021 | 8459 | 122 |
2179522 | 2179522 | 2022-02-03 | Clark | Ohio | 39023 | 34005 | 479 |
2179523 | 2179523 | 2022-02-03 | Clermont | Ohio | 39025 | 49607 | 469 |
2179524 | 2179524 | 2022-02-03 | Clinton | Ohio | 39027 | 10008 | 139 |
2179525 | 2179525 | 2022-02-03 | Columbiana | Ohio | 39029 | 23706 | 431 |
2179526 | 2179526 | 2022-02-03 | Coshocton | Ohio | 39031 | 7733 | 139 |
2179527 | 2179527 | 2022-02-03 | Crawford | Ohio | 39033 | 10845 | 185 |
2179528 | 2179528 | 2022-02-03 | Cuyahoga | Ohio | 39035 | 263716 | 3296 |
2179529 | 2179529 | 2022-02-03 | Darke | Ohio | 39037 | 12070 | 206 |
2179530 | 2179530 | 2022-02-03 | Defiance | Ohio | 39039 | 9950 | 146 |
2179531 | 2179531 | 2022-02-03 | Delaware | Ohio | 39041 | 43013 | 234 |
2179532 | 2179532 | 2022-02-03 | Erie | Ohio | 39043 | 19022 | 241 |
2179533 | 2179533 | 2022-02-03 | Fairfield | Ohio | 39045 | 37379 | 371 |
2179534 | 2179534 | 2022-02-03 | Fayette | Ohio | 39047 | 7581 | 99 |
2179535 | 2179535 | 2022-02-03 | Franklin | Ohio | 39049 | 280802 | 2219 |
2179536 | 2179536 | 2022-02-03 | Fulton | Ohio | 39051 | 10098 | 161 |
2179537 | 2179537 | 2022-02-03 | Gallia | Ohio | 39053 | 6917 | 95 |
2179538 | 2179538 | 2022-02-03 | Geauga | Ohio | 39055 | 15713 | 238 |
2179539 | 2179539 | 2022-02-03 | Greene | Ohio | 39057 | 36047 | 448 |
2179540 | 2179540 | 2022-02-03 | Guernsey | Ohio | 39059 | 10127 | 130 |
2179541 | 2179541 | 2022-02-03 | Hamilton | Ohio | 39061 | 182296 | 1816 |
2179542 | 2179542 | 2022-02-03 | Hancock | Ohio | 39063 | 16690 | 242 |
2179543 | 2179543 | 2022-02-03 | Hardin | Ohio | 39065 | 6879 | 137 |
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);