ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,942 rows where deaths = 40 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 1,007
- Iowa 992
- Georgia 839
- Virginia 784
- Kentucky 768
- Missouri 679
- Illinois 566
- Mississippi 557
- Minnesota 548
- Arkansas 504
- Tennessee 494
- Louisiana 476
- North Carolina 473
- Wisconsin 457
- Indiana 440
- South Dakota 397
- Alabama 360
- Ohio 360
- Michigan 353
- Oklahoma 346
- Kansas 246
- West Virginia 204
- South Carolina 162
- Nebraska 159
- North Dakota 151
- California 143
- New York 135
- Pennsylvania 127
- Colorado 124
- Idaho 124
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499841 | 2499841 | 2022-05-13 | Elbert | Colorado | 8039 | 4880 | 40 |
2500292 | 2500292 | 2022-05-13 | Crawford | Indiana | 18025 | 2560 | 40 |
2500433 | 2500433 | 2022-05-13 | Madison | Iowa | 19121 | 3181 | 40 |
2500690 | 2500690 | 2022-05-13 | Trimble | Kentucky | 21223 | 2217 | 40 |
2501173 | 2501173 | 2022-05-13 | Shannon | Missouri | 29203 | 1609 | 40 |
2501485 | 2501485 | 2022-05-13 | Yates | New York | 36123 | 3704 | 40 |
2501785 | 2501785 | 2022-05-13 | Nowata | Oklahoma | 40105 | 2785 | 40 |
2502033 | 2502033 | 2022-05-13 | McCormick | South Carolina | 45065 | 2244 | 40 |
2502174 | 2502174 | 2022-05-13 | Moore | Tennessee | 47127 | 2239 | 40 |
2502262 | 2502262 | 2022-05-13 | Dallam | Texas | 48111 | 2155 | 40 |
2502563 | 2502563 | 2022-05-13 | Greensville | Virginia | 51081 | 3341 | 40 |
2502579 | 2502579 | 2022-05-13 | Lexington city | Virginia | 51678 | 2857 | 40 |
2496583 | 2496583 | 2022-05-12 | Elbert | Colorado | 8039 | 4874 | 40 |
2497034 | 2497034 | 2022-05-12 | Crawford | Indiana | 18025 | 2560 | 40 |
2497175 | 2497175 | 2022-05-12 | Madison | Iowa | 19121 | 3181 | 40 |
2497432 | 2497432 | 2022-05-12 | Trimble | Kentucky | 21223 | 2217 | 40 |
2497915 | 2497915 | 2022-05-12 | Shannon | Missouri | 29203 | 1609 | 40 |
2498227 | 2498227 | 2022-05-12 | Yates | New York | 36123 | 3704 | 40 |
2498527 | 2498527 | 2022-05-12 | Nowata | Oklahoma | 40105 | 2785 | 40 |
2498775 | 2498775 | 2022-05-12 | McCormick | South Carolina | 45065 | 2244 | 40 |
2498916 | 2498916 | 2022-05-12 | Moore | Tennessee | 47127 | 2239 | 40 |
2499004 | 2499004 | 2022-05-12 | Dallam | Texas | 48111 | 2155 | 40 |
2499305 | 2499305 | 2022-05-12 | Greensville | Virginia | 51081 | 3341 | 40 |
2499321 | 2499321 | 2022-05-12 | Lexington city | Virginia | 51678 | 2855 | 40 |
2493325 | 2493325 | 2022-05-11 | Elbert | Colorado | 8039 | 4834 | 40 |
2493776 | 2493776 | 2022-05-11 | Crawford | Indiana | 18025 | 2560 | 40 |
2493917 | 2493917 | 2022-05-11 | Madison | Iowa | 19121 | 3181 | 40 |
2494174 | 2494174 | 2022-05-11 | Trimble | Kentucky | 21223 | 2217 | 40 |
2494657 | 2494657 | 2022-05-11 | Shannon | Missouri | 29203 | 1609 | 40 |
2494969 | 2494969 | 2022-05-11 | Yates | New York | 36123 | 3696 | 40 |
2495269 | 2495269 | 2022-05-11 | Nowata | Oklahoma | 40105 | 2779 | 40 |
2495517 | 2495517 | 2022-05-11 | McCormick | South Carolina | 45065 | 2244 | 40 |
2495658 | 2495658 | 2022-05-11 | Moore | Tennessee | 47127 | 2239 | 40 |
2495746 | 2495746 | 2022-05-11 | Dallam | Texas | 48111 | 2155 | 40 |
2496047 | 2496047 | 2022-05-11 | Greensville | Virginia | 51081 | 3340 | 40 |
2496063 | 2496063 | 2022-05-11 | Lexington city | Virginia | 51678 | 2849 | 40 |
2490067 | 2490067 | 2022-05-10 | Elbert | Colorado | 8039 | 4831 | 40 |
2490518 | 2490518 | 2022-05-10 | Crawford | Indiana | 18025 | 2559 | 40 |
2490659 | 2490659 | 2022-05-10 | Madison | Iowa | 19121 | 3173 | 40 |
2490916 | 2490916 | 2022-05-10 | Trimble | Kentucky | 21223 | 2217 | 40 |
2491399 | 2491399 | 2022-05-10 | Shannon | Missouri | 29203 | 1609 | 40 |
2491711 | 2491711 | 2022-05-10 | Yates | New York | 36123 | 3683 | 40 |
2492011 | 2492011 | 2022-05-10 | Nowata | Oklahoma | 40105 | 2779 | 40 |
2492259 | 2492259 | 2022-05-10 | McCormick | South Carolina | 45065 | 2239 | 40 |
2492400 | 2492400 | 2022-05-10 | Moore | Tennessee | 47127 | 2238 | 40 |
2492488 | 2492488 | 2022-05-10 | Dallam | Texas | 48111 | 2155 | 40 |
2492789 | 2492789 | 2022-05-10 | Greensville | Virginia | 51081 | 3338 | 40 |
2492805 | 2492805 | 2022-05-10 | Lexington city | Virginia | 51678 | 2848 | 40 |
2486810 | 2486810 | 2022-05-09 | Elbert | Colorado | 8039 | 4826 | 40 |
2487261 | 2487261 | 2022-05-09 | Crawford | Indiana | 18025 | 2559 | 40 |
2487402 | 2487402 | 2022-05-09 | Madison | Iowa | 19121 | 3173 | 40 |
2487659 | 2487659 | 2022-05-09 | Trimble | Kentucky | 21223 | 2217 | 40 |
2488141 | 2488141 | 2022-05-09 | Shannon | Missouri | 29203 | 1609 | 40 |
2488453 | 2488453 | 2022-05-09 | Yates | New York | 36123 | 3682 | 40 |
2488753 | 2488753 | 2022-05-09 | Nowata | Oklahoma | 40105 | 2779 | 40 |
2489001 | 2489001 | 2022-05-09 | McCormick | South Carolina | 45065 | 2239 | 40 |
2489142 | 2489142 | 2022-05-09 | Moore | Tennessee | 47127 | 2238 | 40 |
2489230 | 2489230 | 2022-05-09 | Dallam | Texas | 48111 | 2155 | 40 |
2489531 | 2489531 | 2022-05-09 | Greensville | Virginia | 51081 | 3340 | 40 |
2489547 | 2489547 | 2022-05-09 | Lexington city | Virginia | 51678 | 2849 | 40 |
2489709 | 2489709 | 2022-05-09 | Bayfield | Wisconsin | 55007 | 3395 | 40 |
2483552 | 2483552 | 2022-05-08 | Elbert | Colorado | 8039 | 4824 | 40 |
2484003 | 2484003 | 2022-05-08 | Crawford | Indiana | 18025 | 2558 | 40 |
2484144 | 2484144 | 2022-05-08 | Madison | Iowa | 19121 | 3173 | 40 |
2484401 | 2484401 | 2022-05-08 | Trimble | Kentucky | 21223 | 2215 | 40 |
2484884 | 2484884 | 2022-05-08 | Shannon | Missouri | 29203 | 1609 | 40 |
2485196 | 2485196 | 2022-05-08 | Yates | New York | 36123 | 3675 | 40 |
2485496 | 2485496 | 2022-05-08 | Nowata | Oklahoma | 40105 | 2779 | 40 |
2485744 | 2485744 | 2022-05-08 | McCormick | South Carolina | 45065 | 2239 | 40 |
2485885 | 2485885 | 2022-05-08 | Moore | Tennessee | 47127 | 2238 | 40 |
2485973 | 2485973 | 2022-05-08 | Dallam | Texas | 48111 | 2155 | 40 |
2486274 | 2486274 | 2022-05-08 | Greensville | Virginia | 51081 | 3334 | 40 |
2486290 | 2486290 | 2022-05-08 | Lexington city | Virginia | 51678 | 2847 | 40 |
2486452 | 2486452 | 2022-05-08 | Bayfield | Wisconsin | 55007 | 3386 | 40 |
2480294 | 2480294 | 2022-05-07 | Elbert | Colorado | 8039 | 4824 | 40 |
2480745 | 2480745 | 2022-05-07 | Crawford | Indiana | 18025 | 2558 | 40 |
2480886 | 2480886 | 2022-05-07 | Madison | Iowa | 19121 | 3173 | 40 |
2481143 | 2481143 | 2022-05-07 | Trimble | Kentucky | 21223 | 2215 | 40 |
2481626 | 2481626 | 2022-05-07 | Shannon | Missouri | 29203 | 1609 | 40 |
2481938 | 2481938 | 2022-05-07 | Yates | New York | 36123 | 3664 | 40 |
2482238 | 2482238 | 2022-05-07 | Nowata | Oklahoma | 40105 | 2779 | 40 |
2482486 | 2482486 | 2022-05-07 | McCormick | South Carolina | 45065 | 2239 | 40 |
2482627 | 2482627 | 2022-05-07 | Moore | Tennessee | 47127 | 2238 | 40 |
2483016 | 2483016 | 2022-05-07 | Greensville | Virginia | 51081 | 3334 | 40 |
2483032 | 2483032 | 2022-05-07 | Lexington city | Virginia | 51678 | 2847 | 40 |
2483194 | 2483194 | 2022-05-07 | Bayfield | Wisconsin | 55007 | 3386 | 40 |
2477036 | 2477036 | 2022-05-06 | Elbert | Colorado | 8039 | 4824 | 40 |
2477487 | 2477487 | 2022-05-06 | Crawford | Indiana | 18025 | 2558 | 40 |
2477628 | 2477628 | 2022-05-06 | Madison | Iowa | 19121 | 3173 | 40 |
2477885 | 2477885 | 2022-05-06 | Trimble | Kentucky | 21223 | 2215 | 40 |
2478368 | 2478368 | 2022-05-06 | Shannon | Missouri | 29203 | 1609 | 40 |
2478680 | 2478680 | 2022-05-06 | Yates | New York | 36123 | 3655 | 40 |
2478980 | 2478980 | 2022-05-06 | Nowata | Oklahoma | 40105 | 2779 | 40 |
2479228 | 2479228 | 2022-05-06 | McCormick | South Carolina | 45065 | 2239 | 40 |
2479369 | 2479369 | 2022-05-06 | Moore | Tennessee | 47127 | 2238 | 40 |
2479758 | 2479758 | 2022-05-06 | Greensville | Virginia | 51081 | 3334 | 40 |
2479774 | 2479774 | 2022-05-06 | Lexington city | Virginia | 51678 | 2847 | 40 |
2479936 | 2479936 | 2022-05-06 | Bayfield | Wisconsin | 55007 | 3386 | 40 |
2473778 | 2473778 | 2022-05-05 | Elbert | Colorado | 8039 | 4822 | 40 |
2474229 | 2474229 | 2022-05-05 | Crawford | Indiana | 18025 | 2558 | 40 |
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);