ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,248 rows where deaths = 222 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 125
- North Carolina 85
- Ohio 84
- South Carolina 72
- Louisiana 68
- Georgia 65
- Virginia 63
- Pennsylvania 47
- Illinois 46
- Kentucky 45
- Indiana 43
- Michigan 41
- California 39
- Tennessee 37
- Oregon 35
- Alabama 33
- Wisconsin 31
- Oklahoma 22
- Arkansas 20
- Colorado 20
- Missouri 20
- New Mexico 16
- New York 16
- Arizona 15
- Idaho 15
- Washington 15
- Maryland 14
- Utah 13
- Florida 12
- Minnesota 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501431 | 2501431 | 2022-05-13 | Cattaraugus | New York | 36009 | 16113 | 222 |
2501682 | 2501682 | 2022-05-13 | Huron | Ohio | 39077 | 14626 | 222 |
2501828 | 2501828 | 2022-05-13 | Klamath | Oregon | 41035 | 14285 | 222 |
2501846 | 2501846 | 2022-05-13 | Yamhill | Oregon | 41071 | 18265 | 222 |
2502381 | 2502381 | 2022-05-13 | Navarro | Texas | 48349 | 12469 | 222 |
2502623 | 2502623 | 2022-05-13 | Shenandoah | Virginia | 51171 | 10936 | 222 |
2498173 | 2498173 | 2022-05-12 | Cattaraugus | New York | 36009 | 16113 | 222 |
2498424 | 2498424 | 2022-05-12 | Huron | Ohio | 39077 | 14626 | 222 |
2498570 | 2498570 | 2022-05-12 | Klamath | Oregon | 41035 | 14283 | 222 |
2498588 | 2498588 | 2022-05-12 | Yamhill | Oregon | 41071 | 18244 | 222 |
2499123 | 2499123 | 2022-05-12 | Navarro | Texas | 48349 | 12468 | 222 |
2499365 | 2499365 | 2022-05-12 | Shenandoah | Virginia | 51171 | 10929 | 222 |
2494915 | 2494915 | 2022-05-11 | Cattaraugus | New York | 36009 | 16081 | 222 |
2495166 | 2495166 | 2022-05-11 | Huron | Ohio | 39077 | 14567 | 222 |
2495312 | 2495312 | 2022-05-11 | Klamath | Oregon | 41035 | 14276 | 222 |
2495330 | 2495330 | 2022-05-11 | Yamhill | Oregon | 41071 | 18207 | 222 |
2495865 | 2495865 | 2022-05-11 | Navarro | Texas | 48349 | 12466 | 222 |
2496107 | 2496107 | 2022-05-11 | Shenandoah | Virginia | 51171 | 10919 | 222 |
2491657 | 2491657 | 2022-05-10 | Cattaraugus | New York | 36009 | 16040 | 222 |
2491908 | 2491908 | 2022-05-10 | Huron | Ohio | 39077 | 14567 | 222 |
2492054 | 2492054 | 2022-05-10 | Klamath | Oregon | 41035 | 14270 | 222 |
2492072 | 2492072 | 2022-05-10 | Yamhill | Oregon | 41071 | 18179 | 222 |
2492849 | 2492849 | 2022-05-10 | Shenandoah | Virginia | 51171 | 10908 | 222 |
2488399 | 2488399 | 2022-05-09 | Cattaraugus | New York | 36009 | 16026 | 222 |
2488650 | 2488650 | 2022-05-09 | Huron | Ohio | 39077 | 14567 | 222 |
2488796 | 2488796 | 2022-05-09 | Klamath | Oregon | 41035 | 14261 | 222 |
2488814 | 2488814 | 2022-05-09 | Yamhill | Oregon | 41071 | 18138 | 222 |
2489591 | 2489591 | 2022-05-09 | Shenandoah | Virginia | 51171 | 10907 | 222 |
2484304 | 2484304 | 2022-05-08 | Bullitt | Kentucky | 21029 | 21719 | 222 |
2485142 | 2485142 | 2022-05-08 | Cattaraugus | New York | 36009 | 16013 | 222 |
2485393 | 2485393 | 2022-05-08 | Huron | Ohio | 39077 | 14567 | 222 |
2485539 | 2485539 | 2022-05-08 | Klamath | Oregon | 41035 | 14232 | 222 |
2486334 | 2486334 | 2022-05-08 | Shenandoah | Virginia | 51171 | 10895 | 222 |
2481046 | 2481046 | 2022-05-07 | Bullitt | Kentucky | 21029 | 21719 | 222 |
2482135 | 2482135 | 2022-05-07 | Huron | Ohio | 39077 | 14567 | 222 |
2482281 | 2482281 | 2022-05-07 | Klamath | Oregon | 41035 | 14232 | 222 |
2483076 | 2483076 | 2022-05-07 | Shenandoah | Virginia | 51171 | 10895 | 222 |
2477788 | 2477788 | 2022-05-06 | Bullitt | Kentucky | 21029 | 21719 | 222 |
2478877 | 2478877 | 2022-05-06 | Huron | Ohio | 39077 | 14567 | 222 |
2479023 | 2479023 | 2022-05-06 | Klamath | Oregon | 41035 | 14232 | 222 |
2479818 | 2479818 | 2022-05-06 | Shenandoah | Virginia | 51171 | 10895 | 222 |
2474530 | 2474530 | 2022-05-05 | Bullitt | Kentucky | 21029 | 21719 | 222 |
2475619 | 2475619 | 2022-05-05 | Huron | Ohio | 39077 | 14567 | 222 |
2475765 | 2475765 | 2022-05-05 | Klamath | Oregon | 41035 | 14228 | 222 |
2476560 | 2476560 | 2022-05-05 | Shenandoah | Virginia | 51171 | 10882 | 222 |
2471273 | 2471273 | 2022-05-04 | Bullitt | Kentucky | 21029 | 21719 | 222 |
2472362 | 2472362 | 2022-05-04 | Huron | Ohio | 39077 | 14535 | 222 |
2472508 | 2472508 | 2022-05-04 | Klamath | Oregon | 41035 | 14222 | 222 |
2473302 | 2473302 | 2022-05-04 | Shenandoah | Virginia | 51171 | 10873 | 222 |
2468017 | 2468017 | 2022-05-03 | Bullitt | Kentucky | 21029 | 21719 | 222 |
2469106 | 2469106 | 2022-05-03 | Huron | Ohio | 39077 | 14535 | 222 |
2469252 | 2469252 | 2022-05-03 | Klamath | Oregon | 41035 | 14214 | 222 |
2470046 | 2470046 | 2022-05-03 | Shenandoah | Virginia | 51171 | 10867 | 222 |
2464762 | 2464762 | 2022-05-02 | Bullitt | Kentucky | 21029 | 21719 | 222 |
2465850 | 2465850 | 2022-05-02 | Huron | Ohio | 39077 | 14535 | 222 |
2465996 | 2465996 | 2022-05-02 | Klamath | Oregon | 41035 | 14213 | 222 |
2466790 | 2466790 | 2022-05-02 | Shenandoah | Virginia | 51171 | 10866 | 222 |
2462595 | 2462595 | 2022-05-01 | Huron | Ohio | 39077 | 14535 | 222 |
2462741 | 2462741 | 2022-05-01 | Klamath | Oregon | 41035 | 14203 | 222 |
2463535 | 2463535 | 2022-05-01 | Shenandoah | Virginia | 51171 | 10854 | 222 |
2459339 | 2459339 | 2022-04-30 | Huron | Ohio | 39077 | 14535 | 222 |
2459485 | 2459485 | 2022-04-30 | Klamath | Oregon | 41035 | 14203 | 222 |
2460279 | 2460279 | 2022-04-30 | Shenandoah | Virginia | 51171 | 10854 | 222 |
2456083 | 2456083 | 2022-04-29 | Huron | Ohio | 39077 | 14535 | 222 |
2456229 | 2456229 | 2022-04-29 | Klamath | Oregon | 41035 | 14203 | 222 |
2457023 | 2457023 | 2022-04-29 | Shenandoah | Virginia | 51171 | 10854 | 222 |
2452827 | 2452827 | 2022-04-28 | Huron | Ohio | 39077 | 14535 | 222 |
2452973 | 2452973 | 2022-04-28 | Klamath | Oregon | 41035 | 14197 | 222 |
2449717 | 2449717 | 2022-04-27 | Klamath | Oregon | 41035 | 14190 | 222 |
2443999 | 2443999 | 2022-04-25 | Shenandoah | Virginia | 51171 | 10836 | 222 |
2440743 | 2440743 | 2022-04-24 | Shenandoah | Virginia | 51171 | 10825 | 222 |
2437487 | 2437487 | 2022-04-23 | Shenandoah | Virginia | 51171 | 10825 | 222 |
2434231 | 2434231 | 2022-04-22 | Shenandoah | Virginia | 51171 | 10825 | 222 |
2430975 | 2430975 | 2022-04-21 | Shenandoah | Virginia | 51171 | 10823 | 222 |
2427719 | 2427719 | 2022-04-20 | Shenandoah | Virginia | 51171 | 10822 | 222 |
2424463 | 2424463 | 2022-04-19 | Shenandoah | Virginia | 51171 | 10822 | 222 |
2421207 | 2421207 | 2022-04-18 | Shenandoah | Virginia | 51171 | 10817 | 222 |
2417951 | 2417951 | 2022-04-17 | Shenandoah | Virginia | 51171 | 10806 | 222 |
2414695 | 2414695 | 2022-04-16 | Shenandoah | Virginia | 51171 | 10806 | 222 |
2411439 | 2411439 | 2022-04-15 | Shenandoah | Virginia | 51171 | 10806 | 222 |
2408183 | 2408183 | 2022-04-14 | Shenandoah | Virginia | 51171 | 10805 | 222 |
2404927 | 2404927 | 2022-04-13 | Shenandoah | Virginia | 51171 | 10801 | 222 |
2375029 | 2375029 | 2022-04-04 | Georgetown | South Carolina | 45043 | 15823 | 222 |
2371777 | 2371777 | 2022-04-03 | Georgetown | South Carolina | 45043 | 15823 | 222 |
2368524 | 2368524 | 2022-04-02 | Georgetown | South Carolina | 45043 | 15823 | 222 |
2365271 | 2365271 | 2022-04-01 | Georgetown | South Carolina | 45043 | 15823 | 222 |
2362018 | 2362018 | 2022-03-31 | Georgetown | South Carolina | 45043 | 15823 | 222 |
2358764 | 2358764 | 2022-03-30 | Georgetown | South Carolina | 45043 | 15823 | 222 |
2355488 | 2355488 | 2022-03-29 | Washington | Rhode Island | 44009 | 31941 | 222 |
2355510 | 2355510 | 2022-03-29 | Georgetown | South Carolina | 45043 | 15823 | 222 |
2352235 | 2352235 | 2022-03-28 | Washington | Rhode Island | 44009 | 31941 | 222 |
2348983 | 2348983 | 2022-03-27 | Washington | Rhode Island | 44009 | 31941 | 222 |
2345730 | 2345730 | 2022-03-26 | Washington | Rhode Island | 44009 | 31941 | 222 |
2342477 | 2342477 | 2022-03-25 | Washington | Rhode Island | 44009 | 31941 | 222 |
2339224 | 2339224 | 2022-03-24 | Washington | Rhode Island | 44009 | 31941 | 222 |
2333969 | 2333969 | 2022-03-23 | Clarke | Georgia | 13059 | 29562 | 222 |
2335970 | 2335970 | 2022-03-23 | Washington | Rhode Island | 44009 | 31941 | 222 |
2330715 | 2330715 | 2022-03-22 | Clarke | Georgia | 13059 | 29563 | 222 |
2331595 | 2331595 | 2022-03-22 | Midland | Michigan | 26111 | 18992 | 222 |
2327463 | 2327463 | 2022-03-21 | Clarke | Georgia | 13059 | 29561 | 222 |
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);