ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where deaths = 554 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 49
- South Carolina 24
- Pennsylvania 17
- Mississippi 13
- Illinois 11
- Texas 11
- Florida 10
- Arizona 9
- California 9
- Wisconsin 9
- North Carolina 8
- Ohio 8
- Oregon 8
- Tennessee 8
- Utah 6
- Washington 6
- Alabama 5
- Georgia 5
- Kansas 5
- New Jersey 5
- New York 5
- Michigan 4
- Massachusetts 3
- Maryland 2
- Minnesota 2
- Missouri 2
- Virginia 2
- Arkansas 1
- Colorado 1
- District of Columbia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500311 | 2500311 | 2022-05-13 | Hendricks | Indiana | 18063 | 41062 | 554 |
2501009 | 2501009 | 2022-05-13 | DeSoto | Mississippi | 28033 | 50344 | 554 |
2497053 | 2497053 | 2022-05-12 | Hendricks | Indiana | 18063 | 41000 | 554 |
2497751 | 2497751 | 2022-05-12 | DeSoto | Mississippi | 28033 | 50344 | 554 |
2493795 | 2493795 | 2022-05-11 | Hendricks | Indiana | 18063 | 41000 | 554 |
2494493 | 2494493 | 2022-05-11 | DeSoto | Mississippi | 28033 | 50344 | 554 |
2490537 | 2490537 | 2022-05-10 | Hendricks | Indiana | 18063 | 40964 | 554 |
2491235 | 2491235 | 2022-05-10 | DeSoto | Mississippi | 28033 | 50344 | 554 |
2487280 | 2487280 | 2022-05-09 | Hendricks | Indiana | 18063 | 40964 | 554 |
2487978 | 2487978 | 2022-05-09 | DeSoto | Mississippi | 28033 | 50344 | 554 |
2484720 | 2484720 | 2022-05-08 | DeSoto | Mississippi | 28033 | 50216 | 554 |
2481462 | 2481462 | 2022-05-07 | DeSoto | Mississippi | 28033 | 50216 | 554 |
2478204 | 2478204 | 2022-05-06 | DeSoto | Mississippi | 28033 | 50216 | 554 |
2474946 | 2474946 | 2022-05-05 | DeSoto | Mississippi | 28033 | 50216 | 554 |
2471689 | 2471689 | 2022-05-04 | DeSoto | Mississippi | 28033 | 50216 | 554 |
2468433 | 2468433 | 2022-05-03 | DeSoto | Mississippi | 28033 | 50216 | 554 |
2470164 | 2470164 | 2022-05-03 | Brown | Wisconsin | 55009 | 84855 | 554 |
2465178 | 2465178 | 2022-05-02 | DeSoto | Mississippi | 28033 | 50216 | 554 |
2461224 | 2461224 | 2022-05-01 | Hendricks | Indiana | 18063 | 40867 | 554 |
2457968 | 2457968 | 2022-04-30 | Hendricks | Indiana | 18063 | 40867 | 554 |
2454712 | 2454712 | 2022-04-29 | Hendricks | Indiana | 18063 | 40867 | 554 |
2451456 | 2451456 | 2022-04-28 | Hendricks | Indiana | 18063 | 40834 | 554 |
2448200 | 2448200 | 2022-04-27 | Hendricks | Indiana | 18063 | 40834 | 554 |
2444944 | 2444944 | 2022-04-26 | Hendricks | Indiana | 18063 | 40808 | 554 |
2441688 | 2441688 | 2022-04-25 | Hendricks | Indiana | 18063 | 40808 | 554 |
2438432 | 2438432 | 2022-04-24 | Hendricks | Indiana | 18063 | 40777 | 554 |
2435176 | 2435176 | 2022-04-23 | Hendricks | Indiana | 18063 | 40777 | 554 |
2431920 | 2431920 | 2022-04-22 | Hendricks | Indiana | 18063 | 40777 | 554 |
2428664 | 2428664 | 2022-04-21 | Hendricks | Indiana | 18063 | 40759 | 554 |
2425408 | 2425408 | 2022-04-20 | Hendricks | Indiana | 18063 | 40759 | 554 |
2422152 | 2422152 | 2022-04-19 | Hendricks | Indiana | 18063 | 40749 | 554 |
2418896 | 2418896 | 2022-04-18 | Hendricks | Indiana | 18063 | 40749 | 554 |
2415640 | 2415640 | 2022-04-17 | Hendricks | Indiana | 18063 | 40723 | 554 |
2412384 | 2412384 | 2022-04-16 | Hendricks | Indiana | 18063 | 40723 | 554 |
2409128 | 2409128 | 2022-04-15 | Hendricks | Indiana | 18063 | 40723 | 554 |
2405872 | 2405872 | 2022-04-14 | Hendricks | Indiana | 18063 | 40723 | 554 |
2402617 | 2402617 | 2022-04-13 | Hendricks | Indiana | 18063 | 40723 | 554 |
2399362 | 2399362 | 2022-04-12 | Hendricks | Indiana | 18063 | 40722 | 554 |
2396107 | 2396107 | 2022-04-11 | Hendricks | Indiana | 18063 | 40722 | 554 |
2392851 | 2392851 | 2022-04-10 | Hendricks | Indiana | 18063 | 40716 | 554 |
2389595 | 2389595 | 2022-04-09 | Hendricks | Indiana | 18063 | 40716 | 554 |
2386340 | 2386340 | 2022-04-08 | Hendricks | Indiana | 18063 | 40716 | 554 |
2383085 | 2383085 | 2022-04-07 | Hendricks | Indiana | 18063 | 40706 | 554 |
2379830 | 2379830 | 2022-04-06 | Hendricks | Indiana | 18063 | 40706 | 554 |
2308292 | 2308292 | 2022-03-15 | Porter | Indiana | 18127 | 37421 | 554 |
2305041 | 2305041 | 2022-03-14 | Porter | Indiana | 18127 | 37387 | 554 |
2301789 | 2301789 | 2022-03-13 | Porter | Indiana | 18127 | 37348 | 554 |
2298537 | 2298537 | 2022-03-12 | Porter | Indiana | 18127 | 37348 | 554 |
2295285 | 2295285 | 2022-03-11 | Porter | Indiana | 18127 | 37348 | 554 |
2292033 | 2292033 | 2022-03-10 | Porter | Indiana | 18127 | 37335 | 554 |
2288781 | 2288781 | 2022-03-09 | Porter | Indiana | 18127 | 37331 | 554 |
2289937 | 2289937 | 2022-03-09 | Catawba | North Carolina | 37035 | 47345 | 554 |
2285530 | 2285530 | 2022-03-08 | Porter | Indiana | 18127 | 37309 | 554 |
2286685 | 2286685 | 2022-03-08 | Catawba | North Carolina | 37035 | 47324 | 554 |
2283433 | 2283433 | 2022-03-07 | Catawba | North Carolina | 37035 | 47309 | 554 |
2280181 | 2280181 | 2022-03-06 | Catawba | North Carolina | 37035 | 47264 | 554 |
2276928 | 2276928 | 2022-03-05 | Catawba | North Carolina | 37035 | 47264 | 554 |
2273675 | 2273675 | 2022-03-04 | Catawba | North Carolina | 37035 | 47264 | 554 |
2269534 | 2269534 | 2022-03-03 | Fayette | Kentucky | 21067 | 93215 | 554 |
2269660 | 2269660 | 2022-03-03 | Rapides | Louisiana | 22079 | 32609 | 554 |
2269755 | 2269755 | 2022-03-03 | Calhoun | Michigan | 26025 | 33727 | 554 |
2270422 | 2270422 | 2022-03-03 | Catawba | North Carolina | 37035 | 47241 | 554 |
2266502 | 2266502 | 2022-03-02 | Calhoun | Michigan | 26025 | 33727 | 554 |
2231362 | 2231362 | 2022-02-19 | Niagara | New York | 36063 | 46969 | 554 |
2228111 | 2228111 | 2022-02-18 | Niagara | New York | 36063 | 46942 | 554 |
2224860 | 2224860 | 2022-02-17 | Niagara | New York | 36063 | 46899 | 554 |
2219949 | 2219949 | 2022-02-16 | Placer | California | 6061 | 68344 | 554 |
2216698 | 2216698 | 2022-02-15 | Placer | California | 6061 | 68297 | 554 |
2213447 | 2213447 | 2022-02-14 | Placer | California | 6061 | 68194 | 554 |
2210195 | 2210195 | 2022-02-13 | Placer | California | 6061 | 67810 | 554 |
2210963 | 2210963 | 2022-02-13 | Shawnee | Kansas | 20177 | 46968 | 554 |
2206942 | 2206942 | 2022-02-12 | Placer | California | 6061 | 67810 | 554 |
2207710 | 2207710 | 2022-02-12 | Shawnee | Kansas | 20177 | 46968 | 554 |
2203689 | 2203689 | 2022-02-11 | Placer | California | 6061 | 67810 | 554 |
2204457 | 2204457 | 2022-02-11 | Shawnee | Kansas | 20177 | 46968 | 554 |
2201204 | 2201204 | 2022-02-10 | Shawnee | Kansas | 20177 | 46968 | 554 |
2197950 | 2197950 | 2022-02-09 | Shawnee | Kansas | 20177 | 46968 | 554 |
2167696 | 2167696 | 2022-01-31 | Calhoun | Alabama | 1015 | 30046 | 554 |
2164441 | 2164441 | 2022-01-30 | Calhoun | Alabama | 1015 | 29876 | 554 |
2165220 | 2165220 | 2022-01-30 | Vanderburgh | Indiana | 18163 | 53066 | 554 |
2161186 | 2161186 | 2022-01-29 | Calhoun | Alabama | 1015 | 29732 | 554 |
2161965 | 2161965 | 2022-01-29 | Vanderburgh | Indiana | 18163 | 53066 | 554 |
2158710 | 2158710 | 2022-01-28 | Vanderburgh | Indiana | 18163 | 53066 | 554 |
2150438 | 2150438 | 2022-01-25 | Blair | Pennsylvania | 42013 | 26769 | 554 |
2119636 | 2119636 | 2022-01-16 | Madison | Indiana | 18095 | 27454 | 554 |
2116384 | 2116384 | 2022-01-15 | Madison | Indiana | 18095 | 27454 | 554 |
2113133 | 2113133 | 2022-01-14 | Madison | Indiana | 18095 | 27454 | 554 |
2109224 | 2109224 | 2022-01-13 | Apache | Arizona | 4001 | 17426 | 554 |
2105973 | 2105973 | 2022-01-12 | Apache | Arizona | 4001 | 17270 | 554 |
2102722 | 2102722 | 2022-01-11 | Apache | Arizona | 4001 | 17204 | 554 |
2098378 | 2098378 | 2022-01-09 | Marion | Oregon | 41047 | 44999 | 554 |
2095126 | 2095126 | 2022-01-08 | Marion | Oregon | 41047 | 44999 | 554 |
2091874 | 2091874 | 2022-01-07 | Marion | Oregon | 41047 | 44999 | 554 |
2092489 | 2092489 | 2022-01-07 | Wichita | Texas | 48485 | 25042 | 554 |
2085411 | 2085411 | 2022-01-05 | Franklin | Pennsylvania | 42055 | 31041 | 554 |
2082304 | 2082304 | 2022-01-04 | Florence | South Carolina | 45041 | 29356 | 554 |
2078933 | 2078933 | 2022-01-03 | Schuylkill | Pennsylvania | 42107 | 26622 | 554 |
2075682 | 2075682 | 2022-01-02 | Schuylkill | Pennsylvania | 42107 | 26470 | 554 |
2072431 | 2072431 | 2022-01-01 | Schuylkill | Pennsylvania | 42107 | 26330 | 554 |
2069180 | 2069180 | 2021-12-31 | Schuylkill | Pennsylvania | 42107 | 26171 | 554 |
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);