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
- California 856
- Georgia 641
- Florida 538
- New York 519
- Texas 517
- Washington 488
- North Carolina 379
- Indiana 372
- Colorado 368
- Mississippi 368
- Virginia 356
- Ohio 354
- Tennessee 347
- Pennsylvania 343
- Wisconsin 342
- Louisiana 335
- Illinois 332
- Michigan 315
- South Carolina 292
- Minnesota 284
- New Jersey 279
- Arkansas 249
- Oregon 244
- Kentucky 238
- Massachusetts 229
- Alabama 217
- Iowa 207
- Maryland 201
- Missouri 196
- Oklahoma 161
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13952 | 13952 | 2020-03-26 | Stevens | Washington | 53065 | 2 | 0 |
13953 | 13953 | 2020-03-26 | Thurston | Washington | 53067 | 24 | 0 |
13954 | 13954 | 2020-03-26 | Unknown | Washington | 65 | 0 | |
13955 | 13955 | 2020-03-26 | Walla Walla | Washington | 53071 | 3 | 0 |
13956 | 13956 | 2020-03-26 | Whatcom | Washington | 53073 | 86 | 4 |
13957 | 13957 | 2020-03-26 | Whitman | Washington | 53075 | 3 | 0 |
13958 | 13958 | 2020-03-26 | Yakima | Washington | 53077 | 61 | 2 |
13959 | 13959 | 2020-03-26 | Berkeley | West Virginia | 54003 | 4 | 0 |
13960 | 13960 | 2020-03-26 | Harrison | West Virginia | 54033 | 4 | 0 |
13961 | 13961 | 2020-03-26 | Jackson | West Virginia | 54035 | 5 | 0 |
13962 | 13962 | 2020-03-26 | Jefferson | West Virginia | 54037 | 4 | 0 |
13963 | 13963 | 2020-03-26 | Kanawha | West Virginia | 54039 | 15 | 0 |
13964 | 13964 | 2020-03-26 | Logan | West Virginia | 54045 | 1 | 0 |
13965 | 13965 | 2020-03-26 | Marion | West Virginia | 54049 | 2 | 0 |
13966 | 13966 | 2020-03-26 | Marshall | West Virginia | 54051 | 3 | 0 |
13967 | 13967 | 2020-03-26 | Mason | West Virginia | 54053 | 1 | 0 |
13968 | 13968 | 2020-03-26 | Mercer | West Virginia | 54055 | 2 | 0 |
13969 | 13969 | 2020-03-26 | Monongalia | West Virginia | 54061 | 24 | 0 |
13970 | 13970 | 2020-03-26 | Ohio | West Virginia | 54069 | 1 | 0 |
13971 | 13971 | 2020-03-26 | Preston | West Virginia | 54077 | 1 | 0 |
13972 | 13972 | 2020-03-26 | Putnam | West Virginia | 54079 | 2 | 0 |
13973 | 13973 | 2020-03-26 | Raleigh | West Virginia | 54081 | 2 | 0 |
13974 | 13974 | 2020-03-26 | Tucker | West Virginia | 54093 | 2 | 0 |
13975 | 13975 | 2020-03-26 | Upshur | West Virginia | 54097 | 1 | 0 |
13976 | 13976 | 2020-03-26 | Wood | West Virginia | 54107 | 2 | 0 |
13977 | 13977 | 2020-03-26 | Bayfield | Wisconsin | 55007 | 1 | 0 |
13978 | 13978 | 2020-03-26 | Brown | Wisconsin | 55009 | 4 | 0 |
13979 | 13979 | 2020-03-26 | Calumet | Wisconsin | 55015 | 1 | 0 |
13980 | 13980 | 2020-03-26 | Chippewa | Wisconsin | 55017 | 1 | 0 |
13981 | 13981 | 2020-03-26 | Clark | Wisconsin | 55019 | 1 | 0 |
13982 | 13982 | 2020-03-26 | Columbia | Wisconsin | 55021 | 5 | 0 |
13983 | 13983 | 2020-03-26 | Dane | Wisconsin | 55025 | 114 | 1 |
13984 | 13984 | 2020-03-26 | Dodge | Wisconsin | 55027 | 3 | 0 |
13985 | 13985 | 2020-03-26 | Douglas | Wisconsin | 55031 | 4 | 0 |
13986 | 13986 | 2020-03-26 | Dunn | Wisconsin | 55033 | 1 | 0 |
13987 | 13987 | 2020-03-26 | Eau Claire | Wisconsin | 55035 | 6 | 0 |
13988 | 13988 | 2020-03-26 | Fond du Lac | Wisconsin | 55039 | 17 | 1 |
13989 | 13989 | 2020-03-26 | Grant | Wisconsin | 55043 | 1 | 0 |
13990 | 13990 | 2020-03-26 | Green | Wisconsin | 55045 | 1 | 0 |
13991 | 13991 | 2020-03-26 | Iowa | Wisconsin | 55049 | 3 | 0 |
13992 | 13992 | 2020-03-26 | Jefferson | Wisconsin | 55055 | 5 | 0 |
13993 | 13993 | 2020-03-26 | Juneau | Wisconsin | 55057 | 1 | 0 |
13994 | 13994 | 2020-03-26 | Kenosha | Wisconsin | 55059 | 19 | 0 |
13995 | 13995 | 2020-03-26 | La Crosse | Wisconsin | 55063 | 12 | 0 |
13996 | 13996 | 2020-03-26 | Marathon | Wisconsin | 55073 | 1 | 0 |
13997 | 13997 | 2020-03-26 | Milwaukee | Wisconsin | 55079 | 393 | 7 |
13998 | 13998 | 2020-03-26 | Monroe | Wisconsin | 55081 | 1 | 0 |
13999 | 13999 | 2020-03-26 | Outagamie | Wisconsin | 55087 | 4 | 0 |
14000 | 14000 | 2020-03-26 | Ozaukee | Wisconsin | 55089 | 22 | 1 |
14001 | 14001 | 2020-03-26 | Pierce | Wisconsin | 55093 | 3 | 0 |
14002 | 14002 | 2020-03-26 | Portage | Wisconsin | 55097 | 1 | 0 |
14003 | 14003 | 2020-03-26 | Racine | Wisconsin | 55101 | 8 | 0 |
14004 | 14004 | 2020-03-26 | Rock | Wisconsin | 55105 | 8 | 0 |
14005 | 14005 | 2020-03-26 | Sauk | Wisconsin | 55111 | 7 | 0 |
14006 | 14006 | 2020-03-26 | Sheboygan | Wisconsin | 55117 | 7 | 0 |
14007 | 14007 | 2020-03-26 | St. Croix | Wisconsin | 55109 | 4 | 0 |
14008 | 14008 | 2020-03-26 | Vilas | Wisconsin | 55125 | 1 | 0 |
14009 | 14009 | 2020-03-26 | Walworth | Wisconsin | 55127 | 5 | 0 |
14010 | 14010 | 2020-03-26 | Washington | Wisconsin | 55131 | 25 | 0 |
14011 | 14011 | 2020-03-26 | Waukesha | Wisconsin | 55133 | 56 | 0 |
14012 | 14012 | 2020-03-26 | Winnebago | Wisconsin | 55139 | 6 | 0 |
14013 | 14013 | 2020-03-26 | Wood | Wisconsin | 55141 | 2 | 0 |
14014 | 14014 | 2020-03-26 | Albany | Wyoming | 56001 | 1 | 0 |
14015 | 14015 | 2020-03-26 | Campbell | Wyoming | 56005 | 1 | 0 |
14016 | 14016 | 2020-03-26 | Carbon | Wyoming | 56007 | 3 | 0 |
14017 | 14017 | 2020-03-26 | Fremont | Wyoming | 56013 | 14 | 0 |
14018 | 14018 | 2020-03-26 | Hot Springs | Wyoming | 56017 | 1 | 0 |
14019 | 14019 | 2020-03-26 | Johnson | Wyoming | 56019 | 1 | 0 |
14020 | 14020 | 2020-03-26 | Laramie | Wyoming | 56021 | 15 | 0 |
14021 | 14021 | 2020-03-26 | Natrona | Wyoming | 56025 | 6 | 0 |
14022 | 14022 | 2020-03-26 | Park | Wyoming | 56029 | 1 | 0 |
14023 | 14023 | 2020-03-26 | Sheridan | Wyoming | 56033 | 4 | 0 |
14024 | 14024 | 2020-03-26 | Sweetwater | Wyoming | 56037 | 1 | 0 |
14025 | 14025 | 2020-03-26 | Teton | Wyoming | 56039 | 8 | 0 |
10836 | 10836 | 2020-03-25 | Autauga | Alabama | 1001 | 4 | 0 |
10837 | 10837 | 2020-03-25 | Baldwin | Alabama | 1003 | 4 | 0 |
10838 | 10838 | 2020-03-25 | Blount | Alabama | 1009 | 1 | 0 |
10839 | 10839 | 2020-03-25 | Butler | Alabama | 1013 | 1 | 0 |
10840 | 10840 | 2020-03-25 | Calhoun | Alabama | 1015 | 2 | 0 |
10841 | 10841 | 2020-03-25 | Chambers | Alabama | 1017 | 10 | 0 |
10842 | 10842 | 2020-03-25 | Cherokee | Alabama | 1019 | 1 | 0 |
10843 | 10843 | 2020-03-25 | Chilton | Alabama | 1021 | 1 | 0 |
10844 | 10844 | 2020-03-25 | Clay | Alabama | 1027 | 1 | 0 |
10845 | 10845 | 2020-03-25 | Cleburne | Alabama | 1029 | 1 | 0 |
10846 | 10846 | 2020-03-25 | Colbert | Alabama | 1033 | 1 | 0 |
10847 | 10847 | 2020-03-25 | Cullman | Alabama | 1043 | 4 | 0 |
10848 | 10848 | 2020-03-25 | Dallas | Alabama | 1047 | 2 | 0 |
10849 | 10849 | 2020-03-25 | Elmore | Alabama | 1051 | 9 | 0 |
10850 | 10850 | 2020-03-25 | Etowah | Alabama | 1055 | 3 | 0 |
10851 | 10851 | 2020-03-25 | Franklin | Alabama | 1059 | 2 | 0 |
10852 | 10852 | 2020-03-25 | Houston | Alabama | 1069 | 2 | 0 |
10853 | 10853 | 2020-03-25 | Jackson | Alabama | 1071 | 2 | 1 |
10854 | 10854 | 2020-03-25 | Jefferson | Alabama | 1073 | 129 | 0 |
10855 | 10855 | 2020-03-25 | Lamar | Alabama | 1075 | 1 | 0 |
10856 | 10856 | 2020-03-25 | Lauderdale | Alabama | 1077 | 7 | 0 |
10857 | 10857 | 2020-03-25 | Lawrence | Alabama | 1079 | 1 | 0 |
10858 | 10858 | 2020-03-25 | Lee | Alabama | 1081 | 40 | 0 |
10859 | 10859 | 2020-03-25 | Limestone | Alabama | 1083 | 6 | 0 |
10860 | 10860 | 2020-03-25 | Madison | Alabama | 1089 | 35 | 0 |
10861 | 10861 | 2020-03-25 | Marion | Alabama | 1093 | 3 | 0 |
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);