ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
239 rows where cases = 2558 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 20
- Georgia 17
- Kentucky 16
- Mississippi 15
- Louisiana 13
- Virginia 12
- Texas 11
- Iowa 10
- Wisconsin 10
- Tennessee 9
- Montana 8
- Kansas 7
- North Carolina 7
- Alabama 6
- Arkansas 6
- Colorado 6
- Missouri 6
- New York 6
- Minnesota 5
- Ohio 5
- Washington 5
- Illinois 4
- Oklahoma 4
- West Virginia 4
- Michigan 3
- Puerto Rico 3
- California 2
- Florida 2
- Idaho 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496567 | 2496567 | 2022-05-12 | Bent | Colorado | 8011 | 2558 | 47 |
2492783 | 2492783 | 2022-05-10 | Galax city | Virginia | 51640 | 2558 | 78 |
2484003 | 2484003 | 2022-05-08 | Crawford | Indiana | 18025 | 2558 | 40 |
2480745 | 2480745 | 2022-05-07 | Crawford | Indiana | 18025 | 2558 | 40 |
2477487 | 2477487 | 2022-05-06 | Crawford | Indiana | 18025 | 2558 | 40 |
2474229 | 2474229 | 2022-05-05 | Crawford | Indiana | 18025 | 2558 | 40 |
2470972 | 2470972 | 2022-05-04 | Crawford | Indiana | 18025 | 2558 | 40 |
2473271 | 2473271 | 2022-05-04 | Nelson | Virginia | 51125 | 2558 | 35 |
2461913 | 2461913 | 2022-05-01 | Carroll | Mississippi | 28015 | 2558 | 53 |
2458657 | 2458657 | 2022-04-30 | Carroll | Mississippi | 28015 | 2558 | 53 |
2455401 | 2455401 | 2022-04-29 | Carroll | Mississippi | 28015 | 2558 | 53 |
2452145 | 2452145 | 2022-04-28 | Carroll | Mississippi | 28015 | 2558 | 53 |
2452349 | 2452349 | 2022-04-28 | Deer Lodge | Montana | 30023 | 2558 | 28 |
2448889 | 2448889 | 2022-04-27 | Carroll | Mississippi | 28015 | 2558 | 53 |
2449093 | 2449093 | 2022-04-27 | Deer Lodge | Montana | 30023 | 2558 | 28 |
2445633 | 2445633 | 2022-04-26 | Carroll | Mississippi | 28015 | 2558 | 53 |
2445836 | 2445836 | 2022-04-26 | Deer Lodge | Montana | 30023 | 2558 | 28 |
2442377 | 2442377 | 2022-04-25 | Carroll | Mississippi | 28015 | 2558 | 53 |
2442581 | 2442581 | 2022-04-25 | Deer Lodge | Montana | 30023 | 2558 | 28 |
2438730 | 2438730 | 2022-04-24 | Edmonson | Kentucky | 21061 | 2558 | 46 |
2439121 | 2439121 | 2022-04-24 | Carroll | Mississippi | 28015 | 2558 | 53 |
2439325 | 2439325 | 2022-04-24 | Deer Lodge | Montana | 30023 | 2558 | 28 |
2435474 | 2435474 | 2022-04-23 | Edmonson | Kentucky | 21061 | 2558 | 46 |
2435865 | 2435865 | 2022-04-23 | Carroll | Mississippi | 28015 | 2558 | 53 |
2436069 | 2436069 | 2022-04-23 | Deer Lodge | Montana | 30023 | 2558 | 28 |
2432218 | 2432218 | 2022-04-22 | Edmonson | Kentucky | 21061 | 2558 | 46 |
2432609 | 2432609 | 2022-04-22 | Carroll | Mississippi | 28015 | 2558 | 53 |
2432813 | 2432813 | 2022-04-22 | Deer Lodge | Montana | 30023 | 2558 | 28 |
2428962 | 2428962 | 2022-04-21 | Edmonson | Kentucky | 21061 | 2558 | 46 |
2429353 | 2429353 | 2022-04-21 | Carroll | Mississippi | 28015 | 2558 | 53 |
2429557 | 2429557 | 2022-04-21 | Deer Lodge | Montana | 30023 | 2558 | 28 |
2425706 | 2425706 | 2022-04-20 | Edmonson | Kentucky | 21061 | 2558 | 46 |
2426097 | 2426097 | 2022-04-20 | Carroll | Mississippi | 28015 | 2558 | 53 |
2422450 | 2422450 | 2022-04-19 | Edmonson | Kentucky | 21061 | 2558 | 46 |
2422841 | 2422841 | 2022-04-19 | Carroll | Mississippi | 28015 | 2558 | 53 |
2419194 | 2419194 | 2022-04-18 | Edmonson | Kentucky | 21061 | 2558 | 46 |
2419585 | 2419585 | 2022-04-18 | Carroll | Mississippi | 28015 | 2558 | 53 |
2324551 | 2324551 | 2022-03-20 | Newton | Indiana | 18111 | 2558 | 68 |
2321297 | 2321297 | 2022-03-19 | Newton | Indiana | 18111 | 2558 | 68 |
2318043 | 2318043 | 2022-03-18 | Newton | Indiana | 18111 | 2558 | 68 |
2314790 | 2314790 | 2022-03-17 | Newton | Indiana | 18111 | 2558 | 68 |
2311537 | 2311537 | 2022-03-16 | Newton | Indiana | 18111 | 2558 | 68 |
2308284 | 2308284 | 2022-03-15 | Newton | Indiana | 18111 | 2558 | 68 |
2265304 | 2265304 | 2022-03-02 | Sumter | Alabama | 1119 | 2558 | 45 |
2245718 | 2245718 | 2022-02-23 | Big Horn | Wyoming | 56003 | 2558 | 60 |
2238920 | 2238920 | 2022-02-21 | Amelia | Virginia | 51007 | 2558 | 53 |
2196746 | 2196746 | 2022-02-08 | Richmond | Virginia | 51159 | 2558 | 19 |
2155669 | 2155669 | 2022-01-27 | Wilson | Kansas | 20205 | 2558 | 35 |
2152416 | 2152416 | 2022-01-26 | Wilson | Kansas | 20205 | 2558 | 35 |
2150553 | 2150553 | 2022-01-25 | Orocovis | Puerto Rico | 72107 | 2558 | |
2138522 | 2138522 | 2022-01-22 | Chicot | Arkansas | 5017 | 2558 | 50 |
2123271 | 2123271 | 2022-01-17 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2120019 | 2120019 | 2022-01-16 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2116767 | 2116767 | 2022-01-15 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2113516 | 2113516 | 2022-01-14 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2096527 | 2096527 | 2022-01-09 | Bleckley | Georgia | 13023 | 2558 | 86 |
2093275 | 2093275 | 2022-01-08 | Bleckley | Georgia | 13023 | 2558 | 86 |
2090023 | 2090023 | 2022-01-07 | Bleckley | Georgia | 13023 | 2558 | 86 |
2086772 | 2086772 | 2022-01-06 | Bleckley | Georgia | 13023 | 2558 | 86 |
2083520 | 2083520 | 2022-01-05 | Bleckley | Georgia | 13023 | 2558 | 86 |
2080723 | 2080723 | 2022-01-04 | Madison | Iowa | 19121 | 2558 | 25 |
2077471 | 2077471 | 2022-01-03 | Madison | Iowa | 19121 | 2558 | 25 |
2074220 | 2074220 | 2022-01-02 | Madison | Iowa | 19121 | 2558 | 25 |
2076133 | 2076133 | 2022-01-02 | Leon | Texas | 48289 | 2558 | 75 |
2070267 | 2070267 | 2022-01-01 | Marion | Arkansas | 5089 | 2558 | 71 |
2070969 | 2070969 | 2022-01-01 | Madison | Iowa | 19121 | 2558 | 25 |
2072882 | 2072882 | 2022-01-01 | Leon | Texas | 48289 | 2558 | 75 |
2067718 | 2067718 | 2021-12-31 | Madison | Iowa | 19121 | 2558 | 25 |
2069631 | 2069631 | 2021-12-31 | Leon | Texas | 48289 | 2558 | 75 |
2064467 | 2064467 | 2021-12-30 | Madison | Iowa | 19121 | 2558 | 25 |
2066380 | 2066380 | 2021-12-30 | Leon | Texas | 48289 | 2558 | 75 |
2061217 | 2061217 | 2021-12-29 | Madison | Iowa | 19121 | 2558 | 25 |
2059912 | 2059912 | 2021-12-28 | Nolan | Texas | 48353 | 2558 | 84 |
2054898 | 2054898 | 2021-12-27 | Fleming | Kentucky | 21069 | 2558 | 41 |
2056179 | 2056179 | 2021-12-27 | Potter | Pennsylvania | 42105 | 2558 | 78 |
2056663 | 2056663 | 2021-12-27 | Nolan | Texas | 48353 | 2558 | 84 |
2024648 | 2024648 | 2021-12-18 | Lamar | Alabama | 1075 | 2558 | 55 |
2020108 | 2020108 | 2021-12-16 | Warren | North Carolina | 37185 | 2558 | 34 |
2011299 | 2011299 | 2021-12-13 | Bristol city | Virginia | 51520 | 2558 | 50 |
1993607 | 1993607 | 2021-12-08 | Bates | Missouri | 29013 | 2558 | 59 |
1987366 | 1987366 | 2021-12-06 | York | Nebraska | 31185 | 2558 | 19 |
1984265 | 1984265 | 2021-12-05 | Bertie | North Carolina | 37015 | 2558 | 53 |
1981015 | 1981015 | 2021-12-04 | Bertie | North Carolina | 37015 | 2558 | 53 |
1977765 | 1977765 | 2021-12-03 | Bertie | North Carolina | 37015 | 2558 | 53 |
1962180 | 1962180 | 2021-11-28 | Lewis | Tennessee | 47101 | 2558 | 41 |
1958929 | 1958929 | 2021-11-27 | Lewis | Tennessee | 47101 | 2558 | 41 |
1955678 | 1955678 | 2021-11-26 | Lewis | Tennessee | 47101 | 2558 | 41 |
1952427 | 1952427 | 2021-11-25 | Lewis | Tennessee | 47101 | 2558 | 41 |
1949176 | 1949176 | 2021-11-24 | Lewis | Tennessee | 47101 | 2558 | 41 |
1938734 | 1938734 | 2021-11-21 | Schoharie | New York | 36095 | 2558 | 24 |
1930407 | 1930407 | 2021-11-19 | Washington | Alabama | 1129 | 2558 | 52 |
1910709 | 1910709 | 2021-11-12 | Hardy | West Virginia | 54031 | 2558 | 31 |
1897989 | 1897989 | 2021-11-09 | Izard | Arkansas | 5065 | 2558 | 55 |
1892737 | 1892737 | 2021-11-07 | Redwood | Minnesota | 27127 | 2558 | 44 |
1889487 | 1889487 | 2021-11-06 | Redwood | Minnesota | 27127 | 2558 | 44 |
1886237 | 1886237 | 2021-11-05 | Redwood | Minnesota | 27127 | 2558 | 44 |
1882798 | 1882798 | 2021-11-04 | Waldo | Maine | 23027 | 2558 | 34 |
1855566 | 1855566 | 2021-10-26 | Sawyer | Wisconsin | 55113 | 2558 | 33 |
1834698 | 1834698 | 2021-10-20 | San Miguel | New Mexico | 35047 | 2558 | 22 |
1818181 | 1818181 | 2021-10-15 | Moniteau | Missouri | 29135 | 2558 | 38 |
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);