ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 5269 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 11
- California 7
- Virginia 7
- Alabama 6
- Indiana 6
- Pennsylvania 6
- Tennessee 6
- Kansas 5
- Maryland 5
- Illinois 4
- Kentucky 4
- Mississippi 4
- Missouri 3
- North Carolina 3
- Texas 3
- Washington 3
- Arkansas 2
- Colorado 2
- New Mexico 2
- Puerto Rico 2
- West Virginia 2
- Florida 1
- Georgia 1
- Maine 1
- Minnesota 1
- Montana 1
- Nebraska 1
- New Hampshire 1
- Oklahoma 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496370 | 2496370 | 2022-05-12 | Pickens | Alabama | 1107 | 5269 | 102 |
2472333 | 2472333 | 2022-05-04 | Carroll | Ohio | 39019 | 5269 | 126 |
2469077 | 2469077 | 2022-05-03 | Carroll | Ohio | 39019 | 5269 | 126 |
2465576 | 2465576 | 2022-05-02 | Lincoln | New Mexico | 35027 | 5269 | 67 |
2465821 | 2465821 | 2022-05-02 | Carroll | Ohio | 39019 | 5269 | 126 |
2462566 | 2462566 | 2022-05-01 | Carroll | Ohio | 39019 | 5269 | 126 |
2459310 | 2459310 | 2022-04-30 | Carroll | Ohio | 39019 | 5269 | 126 |
2456054 | 2456054 | 2022-04-29 | Carroll | Ohio | 39019 | 5269 | 126 |
2452798 | 2452798 | 2022-04-28 | Carroll | Ohio | 39019 | 5269 | 126 |
2446599 | 2446599 | 2022-04-26 | Naranjito | Puerto Rico | 72105 | 5269 | |
2437745 | 2437745 | 2022-04-24 | Monroe | Alabama | 1099 | 5269 | 80 |
2434489 | 2434489 | 2022-04-23 | Monroe | Alabama | 1099 | 5269 | 80 |
2431233 | 2431233 | 2022-04-22 | Monroe | Alabama | 1099 | 5269 | 80 |
2370116 | 2370116 | 2022-04-03 | Sullivan | Indiana | 18153 | 5269 | 76 |
2366863 | 2366863 | 2022-04-02 | Sullivan | Indiana | 18153 | 5269 | 76 |
2363610 | 2363610 | 2022-04-01 | Sullivan | Indiana | 18153 | 5269 | 76 |
2360356 | 2360356 | 2022-03-31 | Sullivan | Indiana | 18153 | 5269 | 76 |
2357102 | 2357102 | 2022-03-30 | Sullivan | Indiana | 18153 | 5269 | 76 |
2314811 | 2314811 | 2022-03-17 | Sullivan | Indiana | 18153 | 5269 | 76 |
2294177 | 2294177 | 2022-03-10 | Addison | Vermont | 50001 | 5269 | 15 |
2242896 | 2242896 | 2022-02-23 | Burke | Georgia | 13033 | 5269 | 99 |
2185175 | 2185175 | 2022-02-05 | Talbot | Maryland | 24041 | 5269 | 75 |
2186659 | 2186659 | 2022-02-05 | Frio | Texas | 48163 | 5269 | 84 |
2173963 | 2173963 | 2022-02-01 | Page | Virginia | 51139 | 5269 | 97 |
2160581 | 2160581 | 2022-01-28 | Calhoun | Texas | 48057 | 5269 | 41 |
2130636 | 2130636 | 2022-01-19 | Transylvania | North Carolina | 37175 | 5269 | 56 |
2086178 | 2086178 | 2022-01-05 | Wythe | Virginia | 51197 | 5269 | 119 |
2056150 | 2056150 | 2021-12-27 | Elk | Pennsylvania | 42047 | 5269 | 74 |
2051539 | 2051539 | 2021-12-26 | Geary | Kansas | 20061 | 5269 | 62 |
2048289 | 2048289 | 2021-12-25 | Geary | Kansas | 20061 | 5269 | 62 |
2045039 | 2045039 | 2021-12-24 | Geary | Kansas | 20061 | 5269 | 62 |
2041790 | 2041790 | 2021-12-23 | Geary | Kansas | 20061 | 5269 | 62 |
2038540 | 2038540 | 2021-12-22 | Geary | Kansas | 20061 | 5269 | 62 |
2035837 | 2035837 | 2021-12-21 | Prentiss | Mississippi | 28117 | 5269 | 86 |
2017533 | 2017533 | 2021-12-15 | Cooke | Texas | 48097 | 5269 | 106 |
1990974 | 1990974 | 2021-12-07 | Morrow | Ohio | 39117 | 5269 | 65 |
1984930 | 1984930 | 2021-12-05 | Lauderdale | Tennessee | 47097 | 5269 | 72 |
1981680 | 1981680 | 2021-12-04 | Lauderdale | Tennessee | 47097 | 5269 | 72 |
1978430 | 1978430 | 2021-12-03 | Lauderdale | Tennessee | 47097 | 5269 | 72 |
1973830 | 1973830 | 2021-12-02 | Worcester | Maryland | 24047 | 5269 | 125 |
1973982 | 1973982 | 2021-12-02 | Nobles | Minnesota | 27105 | 5269 | 54 |
1962628 | 1962628 | 2021-11-28 | Prince George | Virginia | 51149 | 5269 | 51 |
1959377 | 1959377 | 2021-11-27 | Prince George | Virginia | 51149 | 5269 | 51 |
1956126 | 1956126 | 2021-11-26 | Prince George | Virginia | 51149 | 5269 | 51 |
1935177 | 1935177 | 2021-11-20 | Polk | Missouri | 29167 | 5269 | 80 |
1920617 | 1920617 | 2021-11-16 | Dallas | Alabama | 1047 | 5269 | 207 |
1922249 | 1922249 | 2021-11-16 | Ravalli | Montana | 30081 | 5269 | 69 |
1899408 | 1899408 | 2021-11-09 | Marion | Missouri | 29127 | 5269 | 64 |
1897842 | 1897842 | 2021-11-08 | Teton | Wyoming | 56039 | 5269 | 14 |
1883903 | 1883903 | 2021-11-04 | McKean | Pennsylvania | 42083 | 5269 | 94 |
1833489 | 1833489 | 2021-10-20 | Fulton | Illinois | 17057 | 5269 | 84 |
1835175 | 1835175 | 2021-10-20 | Pike | Pennsylvania | 42103 | 5269 | 59 |
1831740 | 1831740 | 2021-10-19 | Putnam | Ohio | 39137 | 5269 | 108 |
1772235 | 1772235 | 2021-10-01 | Taylor | Kentucky | 21217 | 5269 | 76 |
1764905 | 1764905 | 2021-09-29 | La Plata | Colorado | 8067 | 5269 | 52 |
1766541 | 1766541 | 2021-09-29 | Bladen | North Carolina | 37017 | 5269 | 92 |
1746917 | 1746917 | 2021-09-23 | Belknap | New Hampshire | 33001 | 5269 | 114 |
1710089 | 1710089 | 2021-09-12 | Stephenson | Illinois | 17177 | 5269 | 107 |
1711801 | 1711801 | 2021-09-12 | Unknown | Puerto Rico | 5269 | 2998 | |
1706842 | 1706842 | 2021-09-11 | Stephenson | Illinois | 17177 | 5269 | 107 |
1703594 | 1703594 | 2021-09-10 | Stephenson | Illinois | 17177 | 5269 | 107 |
1639999 | 1639999 | 2021-08-21 | Auglaize | Ohio | 39011 | 5269 | 87 |
1623128 | 1623128 | 2021-08-16 | Hancock | Mississippi | 28045 | 5269 | 90 |
1608397 | 1608397 | 2021-08-11 | Campbell | Virginia | 51031 | 5269 | 105 |
1574012 | 1574012 | 2021-08-01 | Henderson | Kentucky | 21101 | 5269 | 79 |
1570764 | 1570764 | 2021-07-31 | Henderson | Kentucky | 21101 | 5269 | 79 |
1567516 | 1567516 | 2021-07-30 | Henderson | Kentucky | 21101 | 5269 | 79 |
1558787 | 1558787 | 2021-07-27 | Athens | Ohio | 39009 | 5269 | 60 |
1559847 | 1559847 | 2021-07-27 | Mercer | West Virginia | 54055 | 5269 | 129 |
1527712 | 1527712 | 2021-07-18 | Nevada | California | 6057 | 5269 | 75 |
1524465 | 1524465 | 2021-07-17 | Nevada | California | 6057 | 5269 | 75 |
1521217 | 1521217 | 2021-07-16 | Nevada | California | 6057 | 5269 | 75 |
1516339 | 1516339 | 2021-07-14 | Otero | New Mexico | 35035 | 5269 | 82 |
1433498 | 1433498 | 2021-06-19 | Hot Spring | Arkansas | 5059 | 5269 | 75 |
1302575 | 1302575 | 2021-05-09 | Mifflin | Pennsylvania | 42087 | 5269 | 177 |
1293738 | 1293738 | 2021-05-06 | Shawano | Wisconsin | 55115 | 5269 | 83 |
1197928 | 1197928 | 2021-04-07 | Newton | Missouri | 29145 | 5269 | 74 |
1178550 | 1178550 | 2021-04-01 | Buffalo | Nebraska | 31019 | 5269 | 57 |
1171563 | 1171563 | 2021-03-30 | Androscoggin | Maine | 23001 | 5269 | 59 |
1122892 | 1122892 | 2021-03-15 | St. Mary's | Maryland | 24037 | 5269 | 117 |
1120973 | 1120973 | 2021-03-14 | Dyer | Tennessee | 47045 | 5269 | 102 |
1117726 | 1117726 | 2021-03-13 | Dyer | Tennessee | 47045 | 5269 | 102 |
1114479 | 1114479 | 2021-03-12 | Dyer | Tennessee | 47045 | 5269 | 102 |
1014899 | 1014899 | 2021-02-10 | Gadsden | Florida | 12039 | 5269 | 75 |
981006 | 981006 | 2021-01-30 | Bryan | Oklahoma | 40013 | 5269 | 45 |
966000 | 966000 | 2021-01-26 | Crittenden | Arkansas | 5035 | 5269 | 80 |
967321 | 967321 | 2021-01-26 | Lafayette | Mississippi | 28071 | 5269 | 101 |
968964 | 968964 | 2021-01-26 | Whatcom | Washington | 53073 | 5269 | 60 |
962831 | 962831 | 2021-01-25 | Lassen | California | 6035 | 5269 | 16 |
959586 | 959586 | 2021-01-24 | Lassen | California | 6035 | 5269 | 16 |
956340 | 956340 | 2021-01-23 | Lassen | California | 6035 | 5269 | 16 |
953095 | 953095 | 2021-01-22 | Lassen | California | 6035 | 5269 | 16 |
910547 | 910547 | 2021-01-08 | Thurston | Washington | 53067 | 5269 | 58 |
881373 | 881373 | 2020-12-30 | Monongalia | West Virginia | 54061 | 5269 | 30 |
869715 | 869715 | 2020-12-27 | Allegany | Maryland | 24001 | 5269 | 151 |
786428 | 786428 | 2020-12-01 | Lackawanna | Pennsylvania | 42069 | 5269 | 231 |
666400 | 666400 | 2020-10-25 | Northampton | Pennsylvania | 42095 | 5269 | 311 |
660660 | 660660 | 2020-10-23 | Benton | Washington | 53005 | 5269 | 137 |
553582 | 553582 | 2020-09-20 | Henrico | Virginia | 51087 | 5269 | 209 |
536835 | 536835 | 2020-09-15 | Beaufort | South Carolina | 45013 | 5269 | 76 |
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);