ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
850 rows where deaths = 276 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 87
- Florida 81
- Virginia 60
- Georgia 45
- Illinois 42
- North Carolina 40
- Alabama 38
- Wisconsin 36
- Texas 35
- Ohio 29
- Michigan 27
- South Carolina 27
- Tennessee 25
- Arkansas 23
- New Mexico 22
- Kentucky 21
- Colorado 20
- Iowa 17
- Nebraska 14
- Oklahoma 14
- Louisiana 13
- Maryland 13
- New York 13
- Oregon 13
- Washington 13
- Idaho 12
- Mississippi 11
- Indiana 10
- Arizona 8
- California 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501325 | 2501325 | 2022-05-13 | Sarpy | Nebraska | 31153 | 49923 | 276 |
2501427 | 2501427 | 2022-05-13 | Valencia | New Mexico | 35061 | 19238 | 276 |
2501890 | 2501890 | 2022-05-13 | Mifflin | Pennsylvania | 42087 | 12348 | 276 |
2498067 | 2498067 | 2022-05-12 | Sarpy | Nebraska | 31153 | 49870 | 276 |
2498169 | 2498169 | 2022-05-12 | Valencia | New Mexico | 35061 | 19223 | 276 |
2498632 | 2498632 | 2022-05-12 | Mifflin | Pennsylvania | 42087 | 12348 | 276 |
2494809 | 2494809 | 2022-05-11 | Sarpy | Nebraska | 31153 | 49870 | 276 |
2494911 | 2494911 | 2022-05-11 | Valencia | New Mexico | 35061 | 19200 | 276 |
2495374 | 2495374 | 2022-05-11 | Mifflin | Pennsylvania | 42087 | 12348 | 276 |
2491653 | 2491653 | 2022-05-10 | Valencia | New Mexico | 35061 | 19191 | 276 |
2492116 | 2492116 | 2022-05-10 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2488395 | 2488395 | 2022-05-09 | Valencia | New Mexico | 35061 | 19187 | 276 |
2488858 | 2488858 | 2022-05-09 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2489725 | 2489725 | 2022-05-09 | Fond du Lac | Wisconsin | 55039 | 32325 | 276 |
2485601 | 2485601 | 2022-05-08 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2482343 | 2482343 | 2022-05-07 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2479085 | 2479085 | 2022-05-06 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2475827 | 2475827 | 2022-05-05 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2472570 | 2472570 | 2022-05-04 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2467144 | 2467144 | 2022-05-03 | Jefferson | Arkansas | 5069 | 18599 | 276 |
2468844 | 2468844 | 2022-05-03 | Santa Fe | New Mexico | 35049 | 29114 | 276 |
2469314 | 2469314 | 2022-05-03 | Mifflin | Pennsylvania | 42087 | 12326 | 276 |
2463889 | 2463889 | 2022-05-02 | Jefferson | Arkansas | 5069 | 18599 | 276 |
2466058 | 2466058 | 2022-05-02 | Mifflin | Pennsylvania | 42087 | 12326 | 276 |
2460633 | 2460633 | 2022-05-01 | Jefferson | Arkansas | 5069 | 18599 | 276 |
2462803 | 2462803 | 2022-05-01 | Mifflin | Pennsylvania | 42087 | 12326 | 276 |
2457377 | 2457377 | 2022-04-30 | Jefferson | Arkansas | 5069 | 18597 | 276 |
2459547 | 2459547 | 2022-04-30 | Mifflin | Pennsylvania | 42087 | 12322 | 276 |
2454121 | 2454121 | 2022-04-29 | Jefferson | Arkansas | 5069 | 18596 | 276 |
2456291 | 2456291 | 2022-04-29 | Mifflin | Pennsylvania | 42087 | 12321 | 276 |
2450865 | 2450865 | 2022-04-28 | Jefferson | Arkansas | 5069 | 18596 | 276 |
2453035 | 2453035 | 2022-04-28 | Mifflin | Pennsylvania | 42087 | 12317 | 276 |
2447609 | 2447609 | 2022-04-27 | Jefferson | Arkansas | 5069 | 18593 | 276 |
2449779 | 2449779 | 2022-04-27 | Mifflin | Pennsylvania | 42087 | 12313 | 276 |
2444353 | 2444353 | 2022-04-26 | Jefferson | Arkansas | 5069 | 18593 | 276 |
2445532 | 2445532 | 2022-04-26 | Tuscola | Michigan | 26157 | 13213 | 276 |
2446522 | 2446522 | 2022-04-26 | Mifflin | Pennsylvania | 42087 | 12311 | 276 |
2441097 | 2441097 | 2022-04-25 | Jefferson | Arkansas | 5069 | 18591 | 276 |
2442276 | 2442276 | 2022-04-25 | Tuscola | Michigan | 26157 | 13213 | 276 |
2443267 | 2443267 | 2022-04-25 | Mifflin | Pennsylvania | 42087 | 12308 | 276 |
2437841 | 2437841 | 2022-04-24 | Jefferson | Arkansas | 5069 | 18591 | 276 |
2439020 | 2439020 | 2022-04-24 | Tuscola | Michigan | 26157 | 13213 | 276 |
2440011 | 2440011 | 2022-04-24 | Mifflin | Pennsylvania | 42087 | 12307 | 276 |
2434585 | 2434585 | 2022-04-23 | Jefferson | Arkansas | 5069 | 18591 | 276 |
2435764 | 2435764 | 2022-04-23 | Tuscola | Michigan | 26157 | 13213 | 276 |
2436755 | 2436755 | 2022-04-23 | Mifflin | Pennsylvania | 42087 | 12303 | 276 |
2431329 | 2431329 | 2022-04-22 | Jefferson | Arkansas | 5069 | 18591 | 276 |
2432508 | 2432508 | 2022-04-22 | Tuscola | Michigan | 26157 | 13213 | 276 |
2433499 | 2433499 | 2022-04-22 | Mifflin | Pennsylvania | 42087 | 12302 | 276 |
2428073 | 2428073 | 2022-04-21 | Jefferson | Arkansas | 5069 | 18591 | 276 |
2429252 | 2429252 | 2022-04-21 | Tuscola | Michigan | 26157 | 13213 | 276 |
2430243 | 2430243 | 2022-04-21 | Mifflin | Pennsylvania | 42087 | 12299 | 276 |
2424817 | 2424817 | 2022-04-20 | Jefferson | Arkansas | 5069 | 18591 | 276 |
2425996 | 2425996 | 2022-04-20 | Tuscola | Michigan | 26157 | 13213 | 276 |
2426987 | 2426987 | 2022-04-20 | Mifflin | Pennsylvania | 42087 | 12296 | 276 |
2421561 | 2421561 | 2022-04-19 | Jefferson | Arkansas | 5069 | 18590 | 276 |
2422740 | 2422740 | 2022-04-19 | Tuscola | Michigan | 26157 | 13196 | 276 |
2423731 | 2423731 | 2022-04-19 | Mifflin | Pennsylvania | 42087 | 12296 | 276 |
2418305 | 2418305 | 2022-04-18 | Jefferson | Arkansas | 5069 | 18589 | 276 |
2419484 | 2419484 | 2022-04-18 | Tuscola | Michigan | 26157 | 13196 | 276 |
2420475 | 2420475 | 2022-04-18 | Mifflin | Pennsylvania | 42087 | 12292 | 276 |
2416228 | 2416228 | 2022-04-17 | Tuscola | Michigan | 26157 | 13196 | 276 |
2416731 | 2416731 | 2022-04-17 | Eddy | New Mexico | 35015 | 17012 | 276 |
2417219 | 2417219 | 2022-04-17 | Mifflin | Pennsylvania | 42087 | 12292 | 276 |
2412972 | 2412972 | 2022-04-16 | Tuscola | Michigan | 26157 | 13196 | 276 |
2413475 | 2413475 | 2022-04-16 | Eddy | New Mexico | 35015 | 17012 | 276 |
2413963 | 2413963 | 2022-04-16 | Mifflin | Pennsylvania | 42087 | 12288 | 276 |
2409716 | 2409716 | 2022-04-15 | Tuscola | Michigan | 26157 | 13196 | 276 |
2410219 | 2410219 | 2022-04-15 | Eddy | New Mexico | 35015 | 17012 | 276 |
2410707 | 2410707 | 2022-04-15 | Mifflin | Pennsylvania | 42087 | 12286 | 276 |
2406460 | 2406460 | 2022-04-14 | Tuscola | Michigan | 26157 | 13196 | 276 |
2407451 | 2407451 | 2022-04-14 | Mifflin | Pennsylvania | 42087 | 12283 | 276 |
2403204 | 2403204 | 2022-04-13 | Tuscola | Michigan | 26157 | 13196 | 276 |
2404195 | 2404195 | 2022-04-13 | Mifflin | Pennsylvania | 42087 | 12281 | 276 |
2398979 | 2398979 | 2022-04-12 | Jackson | Florida | 12063 | 14791 | 276 |
2400940 | 2400940 | 2022-04-12 | Mifflin | Pennsylvania | 42087 | 12279 | 276 |
2395724 | 2395724 | 2022-04-11 | Jackson | Florida | 12063 | 14791 | 276 |
2397685 | 2397685 | 2022-04-11 | Mifflin | Pennsylvania | 42087 | 12278 | 276 |
2392468 | 2392468 | 2022-04-10 | Jackson | Florida | 12063 | 14791 | 276 |
2392654 | 2392654 | 2022-04-10 | Ware | Georgia | 13299 | 10158 | 276 |
2394359 | 2394359 | 2022-04-10 | Deschutes | Oregon | 41017 | 45997 | 276 |
2394430 | 2394430 | 2022-04-10 | Mifflin | Pennsylvania | 42087 | 12274 | 276 |
2389212 | 2389212 | 2022-04-09 | Jackson | Florida | 12063 | 14791 | 276 |
2389398 | 2389398 | 2022-04-09 | Ware | Georgia | 13299 | 10158 | 276 |
2391103 | 2391103 | 2022-04-09 | Deschutes | Oregon | 41017 | 45997 | 276 |
2391174 | 2391174 | 2022-04-09 | Mifflin | Pennsylvania | 42087 | 12273 | 276 |
2385957 | 2385957 | 2022-04-08 | Jackson | Florida | 12063 | 14791 | 276 |
2386143 | 2386143 | 2022-04-08 | Ware | Georgia | 13299 | 10158 | 276 |
2387847 | 2387847 | 2022-04-08 | Deschutes | Oregon | 41017 | 45997 | 276 |
2387918 | 2387918 | 2022-04-08 | Mifflin | Pennsylvania | 42087 | 12269 | 276 |
2382702 | 2382702 | 2022-04-07 | Jackson | Florida | 12063 | 14737 | 276 |
2382888 | 2382888 | 2022-04-07 | Ware | Georgia | 13299 | 10161 | 276 |
2384592 | 2384592 | 2022-04-07 | Deschutes | Oregon | 41017 | 45987 | 276 |
2384663 | 2384663 | 2022-04-07 | Mifflin | Pennsylvania | 42087 | 12266 | 276 |
2385314 | 2385314 | 2022-04-07 | Danville city | Virginia | 51590 | 11036 | 276 |
2379447 | 2379447 | 2022-04-06 | Jackson | Florida | 12063 | 14737 | 276 |
2379633 | 2379633 | 2022-04-06 | Ware | Georgia | 13299 | 10161 | 276 |
2381408 | 2381408 | 2022-04-06 | Mifflin | Pennsylvania | 42087 | 12266 | 276 |
2376379 | 2376379 | 2022-04-05 | Ware | Georgia | 13299 | 10162 | 276 |
2378153 | 2378153 | 2022-04-05 | Mifflin | Pennsylvania | 42087 | 12262 | 276 |
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);