ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where cases = 5155 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Oklahoma 8
- Ohio 6
- Kentucky 5
- Tennessee 5
- Alabama 4
- Georgia 4
- Indiana 4
- Mississippi 4
- Illinois 3
- North Carolina 3
- Pennsylvania 3
- Texas 3
- Utah 3
- Wisconsin 3
- Iowa 2
- Maryland 2
- Missouri 2
- Virginia 2
- Arkansas 1
- Colorado 1
- Florida 1
- Idaho 1
- Massachusetts 1
- Minnesota 1
- Nebraska 1
- Nevada 1
- South Carolina 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2357002 | 2357002 | 2022-03-30 | Richland | Illinois | 17159 | 5155 | 83 |
2353749 | 2353749 | 2022-03-29 | Richland | Illinois | 17159 | 5155 | 83 |
2350497 | 2350497 | 2022-03-28 | Richland | Illinois | 17159 | 5155 | 83 |
2335782 | 2335782 | 2022-03-23 | Woodward | Oklahoma | 40153 | 5155 | 73 |
2332528 | 2332528 | 2022-03-22 | Woodward | Oklahoma | 40153 | 5155 | 73 |
2329275 | 2329275 | 2022-03-21 | Woodward | Oklahoma | 40153 | 5155 | 73 |
2326023 | 2326023 | 2022-03-20 | Woodward | Oklahoma | 40153 | 5155 | 73 |
2322770 | 2322770 | 2022-03-19 | Woodward | Oklahoma | 40153 | 5155 | 73 |
2319516 | 2319516 | 2022-03-18 | Woodward | Oklahoma | 40153 | 5155 | 73 |
2316262 | 2316262 | 2022-03-17 | Woodward | Oklahoma | 40153 | 5155 | 73 |
2311999 | 2311999 | 2022-03-16 | Somerset | Maryland | 24039 | 5155 | 73 |
2291310 | 2291310 | 2022-03-10 | Marengo | Alabama | 1091 | 5155 | 104 |
2288058 | 2288058 | 2022-03-09 | Marengo | Alabama | 1091 | 5155 | 104 |
2200814 | 2200814 | 2022-02-10 | Payette | Idaho | 16075 | 5155 | 80 |
2187639 | 2187639 | 2022-02-06 | Dodge | Georgia | 13091 | 5155 | 138 |
2184386 | 2184386 | 2022-02-05 | Dodge | Georgia | 13091 | 5155 | 138 |
2181134 | 2181134 | 2022-02-04 | Dodge | Georgia | 13091 | 5155 | 138 |
2135078 | 2135078 | 2022-01-20 | Jackson | Wisconsin | 55053 | 5155 | 40 |
2097210 | 2097210 | 2022-01-09 | Mercer | Kentucky | 21167 | 5155 | 94 |
2093958 | 2093958 | 2022-01-08 | Mercer | Kentucky | 21167 | 5155 | 94 |
2090706 | 2090706 | 2022-01-07 | Mercer | Kentucky | 21167 | 5155 | 94 |
2072201 | 2072201 | 2022-01-01 | Gallia | Ohio | 39053 | 5155 | 85 |
2068950 | 2068950 | 2021-12-31 | Gallia | Ohio | 39053 | 5155 | 85 |
2016636 | 2016636 | 2021-12-15 | Nye | Nevada | 32023 | 5155 | 173 |
1944422 | 1944422 | 2021-11-23 | Marshall | Kentucky | 21157 | 5155 | 80 |
1941430 | 1941430 | 2021-11-22 | Carlton | Minnesota | 27017 | 5155 | 72 |
1919908 | 1919908 | 2021-11-15 | Hardeman | Tennessee | 47069 | 5155 | 83 |
1916658 | 1916658 | 2021-11-14 | Hardeman | Tennessee | 47069 | 5155 | 82 |
1913408 | 1913408 | 2021-11-13 | Hardeman | Tennessee | 47069 | 5155 | 82 |
1910158 | 1910158 | 2021-11-12 | Hardeman | Tennessee | 47069 | 5155 | 82 |
1904123 | 1904123 | 2021-11-10 | Prince George | Virginia | 51149 | 5155 | 48 |
1884270 | 1884270 | 2021-11-04 | Cooke | Texas | 48097 | 5155 | 102 |
1878001 | 1878001 | 2021-11-02 | Uintah | Utah | 49047 | 5155 | 45 |
1878339 | 1878339 | 2021-11-02 | Park | Wyoming | 56029 | 5155 | 79 |
1834984 | 1834984 | 2021-10-20 | Perry | Ohio | 39127 | 5155 | 63 |
1826649 | 1826649 | 2021-10-18 | Montrose | Colorado | 8085 | 5155 | 83 |
1809766 | 1809766 | 2021-10-12 | Sanpete | Utah | 49039 | 5155 | 38 |
1790108 | 1790108 | 2021-10-06 | Hopkins | Texas | 48223 | 5155 | 136 |
1768656 | 1768656 | 2021-09-30 | Steuben | Indiana | 18151 | 5155 | 72 |
1751022 | 1751022 | 2021-09-24 | Bee | Texas | 48025 | 5155 | 109 |
1725819 | 1725819 | 2021-09-17 | Unknown | Arkansas | 5155 | 0 | |
1719149 | 1719149 | 2021-09-15 | Chambers | Alabama | 1017 | 5155 | 127 |
1710115 | 1710115 | 2021-09-12 | Clinton | Indiana | 18023 | 5155 | 67 |
1706868 | 1706868 | 2021-09-11 | Clinton | Indiana | 18023 | 5155 | 67 |
1703620 | 1703620 | 2021-09-10 | Clinton | Indiana | 18023 | 5155 | 67 |
1695147 | 1695147 | 2021-09-07 | Stokes | North Carolina | 37169 | 5155 | 83 |
1671450 | 1671450 | 2021-08-31 | Floyd | Kentucky | 21071 | 5155 | 75 |
1642643 | 1642643 | 2021-08-22 | Marshall | Mississippi | 28093 | 5155 | 108 |
1639393 | 1639393 | 2021-08-21 | Marshall | Mississippi | 28093 | 5155 | 108 |
1636143 | 1636143 | 2021-08-20 | Marshall | Mississippi | 28093 | 5155 | 108 |
1520924 | 1520924 | 2021-07-15 | Dunn | Wisconsin | 55033 | 5155 | 33 |
1480306 | 1480306 | 2021-07-03 | Callaway | Missouri | 29027 | 5155 | 51 |
1455125 | 1455125 | 2021-06-25 | Huntingdon | Pennsylvania | 42061 | 5155 | 135 |
1353096 | 1353096 | 2021-05-25 | Sioux | Iowa | 19167 | 5155 | 74 |
1299165 | 1299165 | 2021-05-08 | Washington | Ohio | 39167 | 5155 | 109 |
1240713 | 1240713 | 2021-04-20 | Seneca | Ohio | 39147 | 5155 | 120 |
1221376 | 1221376 | 2021-04-14 | Columbia | Pennsylvania | 42037 | 5155 | 130 |
1142379 | 1142379 | 2021-03-21 | Berkshire | Massachusetts | 25003 | 5155 | 269 |
1030801 | 1030801 | 2021-02-15 | Coffee | Alabama | 1031 | 5155 | 91 |
1026480 | 1026480 | 2021-02-13 | Le Flore | Oklahoma | 40079 | 5155 | 42 |
1002091 | 1002091 | 2021-02-06 | Spalding | Georgia | 13255 | 5155 | 137 |
991764 | 991764 | 2021-02-02 | Grant | Wisconsin | 55043 | 5155 | 84 |
970567 | 970567 | 2021-01-27 | Lamar | Mississippi | 28073 | 5155 | 65 |
971050 | 971050 | 2021-01-27 | Duplin | North Carolina | 37061 | 5155 | 102 |
920090 | 920090 | 2021-01-11 | Tooele | Utah | 49045 | 5155 | 13 |
848354 | 848354 | 2020-12-20 | Hamblen | Tennessee | 47063 | 5155 | 71 |
828289 | 828289 | 2020-12-14 | Nash | North Carolina | 37127 | 5155 | 113 |
785730 | 785730 | 2020-12-01 | St. Francois | Missouri | 29187 | 5155 | 47 |
656667 | 656667 | 2020-10-22 | Northampton | Pennsylvania | 42095 | 5155 | 310 |
638931 | 638931 | 2020-10-17 | Black Hawk | Iowa | 19013 | 5155 | 96 |
637301 | 637301 | 2020-10-16 | Anderson | South Carolina | 45007 | 5155 | 190 |
587462 | 587462 | 2020-10-01 | Howard | Maryland | 24027 | 5155 | 122 |
543867 | 543867 | 2020-09-17 | Henrico | Virginia | 51087 | 5155 | 205 |
529667 | 529667 | 2020-09-13 | Lancaster | Nebraska | 31109 | 5155 | 22 |
407326 | 407326 | 2020-08-06 | Lucas | Ohio | 39095 | 5155 | 320 |
376612 | 376612 | 2020-07-28 | Brevard | Florida | 12009 | 5155 | 85 |
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);