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,809
- Iowa 67,070
- Tennessee 65,215
- Indiana 62,686
- Ohio 60,245
- 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,099
- 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,437
- District of Columbia 698
- Guam 690
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179556 | 2179556 | 2022-02-03 | Logan | Ohio | 39091 | 9880 | 148 |
2179557 | 2179557 | 2022-02-03 | Lorain | Ohio | 39093 | 65114 | 867 |
2179558 | 2179558 | 2022-02-03 | Lucas | Ohio | 39095 | 96516 | 1218 |
2179559 | 2179559 | 2022-02-03 | Madison | Ohio | 39097 | 9402 | 116 |
2179560 | 2179560 | 2022-02-03 | Mahoning | Ohio | 39099 | 52282 | 974 |
2179561 | 2179561 | 2022-02-03 | Marion | Ohio | 39101 | 19332 | 242 |
2179562 | 2179562 | 2022-02-03 | Medina | Ohio | 39103 | 39339 | 443 |
2179563 | 2179563 | 2022-02-03 | Meigs | Ohio | 39105 | 4264 | 74 |
2179564 | 2179564 | 2022-02-03 | Mercer | Ohio | 39107 | 9463 | 115 |
2179565 | 2179565 | 2022-02-03 | Miami | Ohio | 39109 | 25178 | 429 |
2179566 | 2179566 | 2022-02-03 | Monroe | Ohio | 39111 | 3344 | 69 |
2179567 | 2179567 | 2022-02-03 | Montgomery | Ohio | 39113 | 123292 | 1726 |
2179568 | 2179568 | 2022-02-03 | Morgan | Ohio | 39115 | 3096 | 49 |
2179569 | 2179569 | 2022-02-03 | Morrow | Ohio | 39117 | 7542 | 87 |
2179570 | 2179570 | 2022-02-03 | Muskingum | Ohio | 39119 | 24528 | 260 |
2179571 | 2179571 | 2022-02-03 | Noble | Ohio | 39121 | 3117 | 53 |
2179572 | 2179572 | 2022-02-03 | Ottawa | Ohio | 39123 | 8196 | 126 |
2179573 | 2179573 | 2022-02-03 | Paulding | Ohio | 39125 | 4492 | 69 |
2179574 | 2179574 | 2022-02-03 | Perry | Ohio | 39127 | 7901 | 108 |
2179575 | 2179575 | 2022-02-03 | Pickaway | Ohio | 39129 | 17027 | 194 |
2179576 | 2179576 | 2022-02-03 | Pike | Ohio | 39131 | 7089 | 93 |
2179577 | 2179577 | 2022-02-03 | Portage | Ohio | 39133 | 33093 | 396 |
2179578 | 2179578 | 2022-02-03 | Preble | Ohio | 39135 | 9041 | 178 |
2179579 | 2179579 | 2022-02-03 | Putnam | Ohio | 39137 | 8309 | 139 |
2179580 | 2179580 | 2022-02-03 | Richland | Ohio | 39139 | 30639 | 461 |
2179581 | 2179581 | 2022-02-03 | Ross | Ohio | 39141 | 18520 | 263 |
2179582 | 2179582 | 2022-02-03 | Sandusky | Ohio | 39143 | 13667 | 210 |
2179583 | 2179583 | 2022-02-03 | Scioto | Ohio | 39145 | 19535 | 219 |
2179584 | 2179584 | 2022-02-03 | Seneca | Ohio | 39147 | 12440 | 213 |
2179585 | 2179585 | 2022-02-03 | Shelby | Ohio | 39149 | 10830 | 167 |
2179586 | 2179586 | 2022-02-03 | Stark | Ohio | 39151 | 78539 | 1526 |
2179587 | 2179587 | 2022-02-03 | Summit | Ohio | 39153 | 110399 | 1505 |
2179588 | 2179588 | 2022-02-03 | Trumbull | Ohio | 39155 | 40578 | 823 |
2179589 | 2179589 | 2022-02-03 | Tuscarawas | Ohio | 39157 | 20158 | 446 |
2179590 | 2179590 | 2022-02-03 | Union | Ohio | 39159 | 15013 | 85 |
2179591 | 2179591 | 2022-02-03 | Unknown | Ohio | 0 | 5 | |
2179592 | 2179592 | 2022-02-03 | Van Wert | Ohio | 39161 | 6363 | 127 |
2179593 | 2179593 | 2022-02-03 | Vinton | Ohio | 39163 | 2761 | 47 |
2179594 | 2179594 | 2022-02-03 | Warren | Ohio | 39165 | 55916 | 508 |
2179595 | 2179595 | 2022-02-03 | Washington | Ohio | 39167 | 11879 | 173 |
2179596 | 2179596 | 2022-02-03 | Wayne | Ohio | 39169 | 22687 | 389 |
2179597 | 2179597 | 2022-02-03 | Williams | Ohio | 39171 | 8730 | 149 |
2179598 | 2179598 | 2022-02-03 | Wood | Ohio | 39173 | 30494 | 309 |
2179599 | 2179599 | 2022-02-03 | Wyandot | Ohio | 39175 | 5242 | 95 |
2179600 | 2179600 | 2022-02-03 | Adair | Oklahoma | 40001 | 7348 | 66 |
2179601 | 2179601 | 2022-02-03 | Alfalfa | Oklahoma | 40003 | 1663 | 11 |
2179602 | 2179602 | 2022-02-03 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2179603 | 2179603 | 2022-02-03 | Beaver | Oklahoma | 40007 | 894 | 10 |
2179604 | 2179604 | 2022-02-03 | Beckham | Oklahoma | 40009 | 5624 | 90 |
2179605 | 2179605 | 2022-02-03 | Blaine | Oklahoma | 40011 | 2329 | 34 |
2179606 | 2179606 | 2022-02-03 | Bryan | Oklahoma | 40013 | 12916 | 121 |
2179607 | 2179607 | 2022-02-03 | Caddo | Oklahoma | 40015 | 7875 | 145 |
2179608 | 2179608 | 2022-02-03 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2179609 | 2179609 | 2022-02-03 | Carter | Oklahoma | 40019 | 13021 | 208 |
2179610 | 2179610 | 2022-02-03 | Cherokee | Oklahoma | 40021 | 13799 | 132 |
2179611 | 2179611 | 2022-02-03 | Choctaw | Oklahoma | 40023 | 3858 | 54 |
2179612 | 2179612 | 2022-02-03 | Cimarron | Oklahoma | 40025 | 520 | 0 |
2179613 | 2179613 | 2022-02-03 | Cleveland | Oklahoma | 40027 | 75571 | 687 |
2179614 | 2179614 | 2022-02-03 | Coal | Oklahoma | 40029 | 1510 | 20 |
2179615 | 2179615 | 2022-02-03 | Comanche | Oklahoma | 40031 | 30399 | 343 |
2179616 | 2179616 | 2022-02-03 | Cotton | Oklahoma | 40033 | 1342 | 24 |
2179617 | 2179617 | 2022-02-03 | Craig | Oklahoma | 40035 | 4435 | 42 |
2179618 | 2179618 | 2022-02-03 | Creek | Oklahoma | 40037 | 17298 | 291 |
2179619 | 2179619 | 2022-02-03 | Custer | Oklahoma | 40039 | 7465 | 143 |
2179620 | 2179620 | 2022-02-03 | Delaware | Oklahoma | 40041 | 10471 | 175 |
2179621 | 2179621 | 2022-02-03 | Dewey | Oklahoma | 40043 | 1019 | 25 |
2179622 | 2179622 | 2022-02-03 | Ellis | Oklahoma | 40045 | 697 | 7 |
2179623 | 2179623 | 2022-02-03 | Garfield | Oklahoma | 40047 | 14095 | 233 |
2179624 | 2179624 | 2022-02-03 | Garvin | Oklahoma | 40049 | 6743 | 120 |
2179625 | 2179625 | 2022-02-03 | Grady | Oklahoma | 40051 | 13148 | 218 |
2179626 | 2179626 | 2022-02-03 | Grant | Oklahoma | 40053 | 986 | 12 |
2179627 | 2179627 | 2022-02-03 | Greer | Oklahoma | 40055 | 1215 | 29 |
2179628 | 2179628 | 2022-02-03 | Harmon | Oklahoma | 40057 | 493 | 11 |
2179629 | 2179629 | 2022-02-03 | Harper | Oklahoma | 40059 | 687 | 11 |
2179630 | 2179630 | 2022-02-03 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2179631 | 2179631 | 2022-02-03 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2179632 | 2179632 | 2022-02-03 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2179633 | 2179633 | 2022-02-03 | Jefferson | Oklahoma | 40067 | 1228 | 21 |
2179634 | 2179634 | 2022-02-03 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2179635 | 2179635 | 2022-02-03 | Kay | Oklahoma | 40071 | 11459 | 186 |
2179636 | 2179636 | 2022-02-03 | Kingfisher | Oklahoma | 40073 | 3756 | 56 |
2179637 | 2179637 | 2022-02-03 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2179638 | 2179638 | 2022-02-03 | Latimer | Oklahoma | 40077 | 2169 | 31 |
2179639 | 2179639 | 2022-02-03 | Le Flore | Oklahoma | 40079 | 11543 | 98 |
2179640 | 2179640 | 2022-02-03 | Lincoln | Oklahoma | 40081 | 7382 | 119 |
2179641 | 2179641 | 2022-02-03 | Logan | Oklahoma | 40083 | 10177 | 140 |
2179642 | 2179642 | 2022-02-03 | Love | Oklahoma | 40085 | 2887 | 31 |
2179643 | 2179643 | 2022-02-03 | Major | Oklahoma | 40093 | 2377 | 35 |
2179644 | 2179644 | 2022-02-03 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2179645 | 2179645 | 2022-02-03 | Mayes | Oklahoma | 40097 | 9704 | 140 |
2179646 | 2179646 | 2022-02-03 | McClain | Oklahoma | 40087 | 11079 | 115 |
2179647 | 2179647 | 2022-02-03 | McCurtain | Oklahoma | 40089 | 7710 | 145 |
2179648 | 2179648 | 2022-02-03 | McIntosh | Oklahoma | 40091 | 4678 | 111 |
2179649 | 2179649 | 2022-02-03 | Murray | Oklahoma | 40099 | 4004 | 62 |
2179650 | 2179650 | 2022-02-03 | Muskogee | Oklahoma | 40101 | 19064 | 293 |
2179651 | 2179651 | 2022-02-03 | Noble | Oklahoma | 40103 | 2826 | 33 |
2179652 | 2179652 | 2022-02-03 | Nowata | Oklahoma | 40105 | 2655 | 34 |
2179653 | 2179653 | 2022-02-03 | Okfuskee | Oklahoma | 40107 | 3398 | 52 |
2179654 | 2179654 | 2022-02-03 | Oklahoma | Oklahoma | 40109 | 185532 | 2065 |
2179655 | 2179655 | 2022-02-03 | Okmulgee | Oklahoma | 40111 | 9060 | 159 |
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);