ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
322 rows where deaths = 474 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 39
- Texas 31
- Pennsylvania 26
- California 21
- Illinois 14
- Minnesota 14
- North Carolina 14
- Georgia 12
- Ohio 12
- Wisconsin 12
- Indiana 11
- Louisiana 10
- Virginia 10
- Arizona 8
- Alabama 7
- Mississippi 7
- New Jersey 7
- Oklahoma 7
- Idaho 6
- Maryland 6
- Michigan 6
- Kentucky 5
- Arkansas 4
- New Mexico 4
- South Carolina 4
- Utah 4
- Delaware 3
- Massachusetts 3
- Missouri 3
- Colorado 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2439511 | 2439511 | 2022-04-24 | Sussex | New Jersey | 34037 | 34490 | 474 |
2436255 | 2436255 | 2022-04-23 | Sussex | New Jersey | 34037 | 34454 | 474 |
2427691 | 2427691 | 2022-04-20 | Norfolk city | Virginia | 51710 | 42334 | 474 |
2376268 | 2376268 | 2022-04-05 | Coweta | Georgia | 13077 | 32919 | 474 |
2373016 | 2373016 | 2022-04-04 | Coweta | Georgia | 13077 | 32915 | 474 |
2328454 | 2328454 | 2022-03-21 | Washington | Minnesota | 27163 | 66404 | 474 |
2325201 | 2325201 | 2022-03-20 | Washington | Minnesota | 27163 | 66384 | 474 |
2321947 | 2321947 | 2022-03-19 | Washington | Minnesota | 27163 | 66384 | 474 |
2318693 | 2318693 | 2022-03-18 | Washington | Minnesota | 27163 | 66384 | 474 |
2315440 | 2315440 | 2022-03-17 | Washington | Minnesota | 27163 | 66356 | 474 |
2310479 | 2310479 | 2022-03-15 | Chesapeake city | Virginia | 51550 | 49555 | 474 |
2306902 | 2306902 | 2022-03-14 | Angelina | Texas | 48005 | 15270 | 474 |
2303651 | 2303651 | 2022-03-13 | Angelina | Texas | 48005 | 15265 | 474 |
2300399 | 2300399 | 2022-03-12 | Angelina | Texas | 48005 | 15265 | 474 |
2297147 | 2297147 | 2022-03-11 | Angelina | Texas | 48005 | 15259 | 474 |
2293895 | 2293895 | 2022-03-10 | Angelina | Texas | 48005 | 15258 | 474 |
2294300 | 2294300 | 2022-03-10 | Richmond city | Virginia | 51760 | 43915 | 474 |
2289142 | 2289142 | 2022-03-09 | Bossier | Louisiana | 22015 | 37391 | 474 |
2290643 | 2290643 | 2022-03-09 | Angelina | Texas | 48005 | 15253 | 474 |
2287391 | 2287391 | 2022-03-08 | Angelina | Texas | 48005 | 15245 | 474 |
2283505 | 2283505 | 2022-03-07 | Union | North Carolina | 37179 | 61254 | 474 |
2271316 | 2271316 | 2022-03-03 | Randall | Texas | 48381 | 37536 | 474 |
2265382 | 2265382 | 2022-03-02 | Garland | Arkansas | 5051 | 22578 | 474 |
2262029 | 2262029 | 2022-03-01 | Houston | Alabama | 1069 | 24883 | 474 |
2263471 | 2263471 | 2022-03-01 | Rankin | Mississippi | 28121 | 36319 | 474 |
2259745 | 2259745 | 2022-02-28 | Wyandotte | Kansas | 20209 | 46549 | 474 |
2255728 | 2255728 | 2022-02-27 | Sonoma | California | 6097 | 83625 | 474 |
2258653 | 2258653 | 2022-02-27 | Brown | Wisconsin | 55009 | 83339 | 474 |
2252477 | 2252477 | 2022-02-26 | Sonoma | California | 6097 | 83625 | 474 |
2255402 | 2255402 | 2022-02-26 | Brown | Wisconsin | 55009 | 83339 | 474 |
2249226 | 2249226 | 2022-02-25 | Sonoma | California | 6097 | 83625 | 474 |
2252151 | 2252151 | 2022-02-25 | Brown | Wisconsin | 55009 | 83339 | 474 |
2247882 | 2247882 | 2022-02-24 | Tuscarawas | Ohio | 39157 | 20426 | 474 |
2242540 | 2242540 | 2022-02-23 | Morgan | Alabama | 1103 | 35682 | 474 |
2244631 | 2244631 | 2022-02-23 | Tuscarawas | Ohio | 39157 | 20416 | 474 |
2241380 | 2241380 | 2022-02-22 | Tuscarawas | Ohio | 39157 | 20396 | 474 |
2236651 | 2236651 | 2022-02-21 | McHenry | Illinois | 17111 | 74315 | 474 |
2233400 | 2233400 | 2022-02-20 | McHenry | Illinois | 17111 | 74315 | 474 |
2230149 | 2230149 | 2022-02-19 | McHenry | Illinois | 17111 | 74315 | 474 |
2226898 | 2226898 | 2022-02-18 | McHenry | Illinois | 17111 | 74315 | 474 |
2225098 | 2225098 | 2022-02-17 | Medina | Ohio | 39103 | 39628 | 474 |
2221847 | 2221847 | 2022-02-16 | Medina | Ohio | 39103 | 39619 | 474 |
2218596 | 2218596 | 2022-02-15 | Medina | Ohio | 39103 | 39598 | 474 |
2192767 | 2192767 | 2022-02-07 | Mercer | Pennsylvania | 42085 | 22868 | 474 |
2189513 | 2189513 | 2022-02-06 | Mercer | Pennsylvania | 42085 | 22803 | 474 |
2186260 | 2186260 | 2022-02-05 | Mercer | Pennsylvania | 42085 | 22790 | 474 |
2176507 | 2176507 | 2022-02-02 | Monroe | Pennsylvania | 42089 | 35779 | 474 |
2169954 | 2169954 | 2022-01-31 | Washington | Oregon | 41067 | 76872 | 474 |
2159138 | 2159138 | 2022-01-28 | Frederick | Maryland | 24021 | 42433 | 474 |
2142340 | 2142340 | 2022-01-23 | Rock Island | Illinois | 17161 | 29966 | 474 |
2143090 | 2143090 | 2022-01-23 | DeSoto | Mississippi | 28033 | 43813 | 474 |
2139085 | 2139085 | 2022-01-22 | Rock Island | Illinois | 17161 | 29966 | 474 |
2139835 | 2139835 | 2022-01-22 | DeSoto | Mississippi | 28033 | 43813 | 474 |
2135829 | 2135829 | 2022-01-21 | Rock Island | Illinois | 17161 | 29966 | 474 |
2136579 | 2136579 | 2022-01-21 | DeSoto | Mississippi | 28033 | 43813 | 474 |
2127305 | 2127305 | 2022-01-18 | Buncombe | North Carolina | 37021 | 40565 | 474 |
2124053 | 2124053 | 2022-01-17 | Buncombe | North Carolina | 37021 | 38604 | 474 |
2120801 | 2120801 | 2022-01-16 | Buncombe | North Carolina | 37021 | 38604 | 474 |
2117549 | 2117549 | 2022-01-15 | Buncombe | North Carolina | 37021 | 38604 | 474 |
2114298 | 2114298 | 2022-01-14 | Buncombe | North Carolina | 37021 | 38604 | 474 |
2086654 | 2086654 | 2022-01-06 | Mesa | Colorado | 8077 | 31107 | 474 |
2081092 | 2081092 | 2022-01-04 | Washington | Maryland | 24043 | 26746 | 474 |
2074398 | 2074398 | 2022-01-02 | Fayette | Kentucky | 21067 | 58442 | 474 |
2071147 | 2071147 | 2022-01-01 | Fayette | Kentucky | 21067 | 58442 | 474 |
2067896 | 2067896 | 2021-12-31 | Fayette | Kentucky | 21067 | 58442 | 474 |
2064645 | 2064645 | 2021-12-30 | Fayette | Kentucky | 21067 | 58442 | 474 |
2061395 | 2061395 | 2021-12-29 | Fayette | Kentucky | 21067 | 58442 | 474 |
2057491 | 2057491 | 2021-12-28 | St. Johns | Florida | 12109 | 42217 | 474 |
2057493 | 2057493 | 2021-12-28 | Sumter | Florida | 12119 | 15017 | 474 |
2054242 | 2054242 | 2021-12-27 | St. Johns | Florida | 12109 | 42217 | 474 |
2054244 | 2054244 | 2021-12-27 | Sumter | Florida | 12119 | 15017 | 474 |
2050992 | 2050992 | 2021-12-26 | St. Johns | Florida | 12109 | 42217 | 474 |
2050994 | 2050994 | 2021-12-26 | Sumter | Florida | 12119 | 15017 | 474 |
2051197 | 2051197 | 2021-12-26 | Kootenai | Idaho | 16055 | 31891 | 474 |
2047742 | 2047742 | 2021-12-25 | St. Johns | Florida | 12109 | 42217 | 474 |
2047744 | 2047744 | 2021-12-25 | Sumter | Florida | 12119 | 15017 | 474 |
2047947 | 2047947 | 2021-12-25 | Kootenai | Idaho | 16055 | 31891 | 474 |
2044492 | 2044492 | 2021-12-24 | St. Johns | Florida | 12109 | 42217 | 474 |
2044494 | 2044494 | 2021-12-24 | Sumter | Florida | 12119 | 15017 | 474 |
2044697 | 2044697 | 2021-12-24 | Kootenai | Idaho | 16055 | 31891 | 474 |
2041243 | 2041243 | 2021-12-23 | St. Johns | Florida | 12109 | 41700 | 474 |
2041245 | 2041245 | 2021-12-23 | Sumter | Florida | 12119 | 14919 | 474 |
2041448 | 2041448 | 2021-12-23 | Kootenai | Idaho | 16055 | 31891 | 474 |
2037993 | 2037993 | 2021-12-22 | St. Johns | Florida | 12109 | 41700 | 474 |
2037995 | 2037995 | 2021-12-22 | Sumter | Florida | 12119 | 14919 | 474 |
2038198 | 2038198 | 2021-12-22 | Kootenai | Idaho | 16055 | 31830 | 474 |
2034743 | 2034743 | 2021-12-21 | St. Johns | Florida | 12109 | 41700 | 474 |
2037034 | 2037034 | 2021-12-21 | Comal | Texas | 48091 | 20964 | 474 |
2031493 | 2031493 | 2021-12-20 | St. Johns | Florida | 12109 | 41700 | 474 |
2033784 | 2033784 | 2021-12-20 | Comal | Texas | 48091 | 20884 | 474 |
2028242 | 2028242 | 2021-12-19 | St. Johns | Florida | 12109 | 41700 | 474 |
2030135 | 2030135 | 2021-12-19 | Blair | Pennsylvania | 42013 | 22376 | 474 |
2030534 | 2030534 | 2021-12-19 | Comal | Texas | 48091 | 20845 | 474 |
2024991 | 2024991 | 2021-12-18 | St. Johns | Florida | 12109 | 41700 | 474 |
2026884 | 2026884 | 2021-12-18 | Blair | Pennsylvania | 42013 | 22280 | 474 |
2027283 | 2027283 | 2021-12-18 | Comal | Texas | 48091 | 20813 | 474 |
2021740 | 2021740 | 2021-12-17 | St. Johns | Florida | 12109 | 41700 | 474 |
2023633 | 2023633 | 2021-12-17 | Blair | Pennsylvania | 42013 | 22230 | 474 |
2024032 | 2024032 | 2021-12-17 | Comal | Texas | 48091 | 20780 | 474 |
2018489 | 2018489 | 2021-12-16 | St. Johns | Florida | 12109 | 41549 | 474 |
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);