ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
5,173 rows where deaths = 95 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 375
- Texas 333
- Michigan 287
- Mississippi 276
- Georgia 274
- Illinois 264
- Tennessee 256
- North Carolina 224
- Indiana 197
- Ohio 168
- Louisiana 167
- Kentucky 150
- Missouri 149
- Alabama 147
- Minnesota 140
- Pennsylvania 137
- Iowa 136
- South Dakota 135
- Arkansas 129
- Wisconsin 127
- New York 114
- West Virginia 110
- Oklahoma 106
- South Carolina 97
- Nebraska 71
- California 60
- Florida 51
- Kansas 51
- Colorado 49
- Montana 44
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499699 | 2499699 | 2022-05-13 | Columbia | Arkansas | 5027 | 5438 | 95 |
2500415 | 2500415 | 2022-05-13 | Harrison | Iowa | 19085 | 3437 | 95 |
2501815 | 2501815 | 2022-05-13 | Columbia | Oregon | 41009 | 7987 | 95 |
2502029 | 2502029 | 2022-05-13 | Lee | South Carolina | 45061 | 4272 | 95 |
2502156 | 2502156 | 2022-05-13 | Johnson | Tennessee | 47091 | 5181 | 95 |
2502731 | 2502731 | 2022-05-13 | Upshur | West Virginia | 54097 | 6928 | 95 |
2496441 | 2496441 | 2022-05-12 | Columbia | Arkansas | 5027 | 5436 | 95 |
2497157 | 2497157 | 2022-05-12 | Harrison | Iowa | 19085 | 3437 | 95 |
2497936 | 2497936 | 2022-05-12 | Big Horn | Montana | 30003 | 4976 | 95 |
2498557 | 2498557 | 2022-05-12 | Columbia | Oregon | 41009 | 7967 | 95 |
2498771 | 2498771 | 2022-05-12 | Lee | South Carolina | 45061 | 4272 | 95 |
2498898 | 2498898 | 2022-05-12 | Johnson | Tennessee | 47091 | 5181 | 95 |
2499473 | 2499473 | 2022-05-12 | Upshur | West Virginia | 54097 | 6918 | 95 |
2493183 | 2493183 | 2022-05-11 | Columbia | Arkansas | 5027 | 5430 | 95 |
2493899 | 2493899 | 2022-05-11 | Harrison | Iowa | 19085 | 3437 | 95 |
2494678 | 2494678 | 2022-05-11 | Big Horn | Montana | 30003 | 4976 | 95 |
2495299 | 2495299 | 2022-05-11 | Columbia | Oregon | 41009 | 7940 | 95 |
2495513 | 2495513 | 2022-05-11 | Lee | South Carolina | 45061 | 4272 | 95 |
2495640 | 2495640 | 2022-05-11 | Johnson | Tennessee | 47091 | 5181 | 95 |
2496215 | 2496215 | 2022-05-11 | Upshur | West Virginia | 54097 | 6907 | 95 |
2489925 | 2489925 | 2022-05-10 | Columbia | Arkansas | 5027 | 5430 | 95 |
2490641 | 2490641 | 2022-05-10 | Harrison | Iowa | 19085 | 3435 | 95 |
2491420 | 2491420 | 2022-05-10 | Big Horn | Montana | 30003 | 4976 | 95 |
2492041 | 2492041 | 2022-05-10 | Columbia | Oregon | 41009 | 7919 | 95 |
2492255 | 2492255 | 2022-05-10 | Lee | South Carolina | 45061 | 4266 | 95 |
2492382 | 2492382 | 2022-05-10 | Johnson | Tennessee | 47091 | 5174 | 95 |
2492957 | 2492957 | 2022-05-10 | Upshur | West Virginia | 54097 | 6890 | 95 |
2486668 | 2486668 | 2022-05-09 | Columbia | Arkansas | 5027 | 5430 | 95 |
2487384 | 2487384 | 2022-05-09 | Harrison | Iowa | 19085 | 3435 | 95 |
2488162 | 2488162 | 2022-05-09 | Big Horn | Montana | 30003 | 4976 | 95 |
2488783 | 2488783 | 2022-05-09 | Columbia | Oregon | 41009 | 7897 | 95 |
2488997 | 2488997 | 2022-05-09 | Lee | South Carolina | 45061 | 4266 | 95 |
2489124 | 2489124 | 2022-05-09 | Johnson | Tennessee | 47091 | 5174 | 95 |
2489699 | 2489699 | 2022-05-09 | Upshur | West Virginia | 54097 | 6890 | 95 |
2483410 | 2483410 | 2022-05-08 | Columbia | Arkansas | 5027 | 5430 | 95 |
2484126 | 2484126 | 2022-05-08 | Harrison | Iowa | 19085 | 3435 | 95 |
2484905 | 2484905 | 2022-05-08 | Big Horn | Montana | 30003 | 4976 | 95 |
2485740 | 2485740 | 2022-05-08 | Lee | South Carolina | 45061 | 4266 | 95 |
2485867 | 2485867 | 2022-05-08 | Johnson | Tennessee | 47091 | 5174 | 95 |
2486442 | 2486442 | 2022-05-08 | Upshur | West Virginia | 54097 | 6878 | 95 |
2480152 | 2480152 | 2022-05-07 | Columbia | Arkansas | 5027 | 5429 | 95 |
2480868 | 2480868 | 2022-05-07 | Harrison | Iowa | 19085 | 3435 | 95 |
2481647 | 2481647 | 2022-05-07 | Big Horn | Montana | 30003 | 4976 | 95 |
2482482 | 2482482 | 2022-05-07 | Lee | South Carolina | 45061 | 4266 | 95 |
2482609 | 2482609 | 2022-05-07 | Johnson | Tennessee | 47091 | 5174 | 95 |
2483184 | 2483184 | 2022-05-07 | Upshur | West Virginia | 54097 | 6878 | 95 |
2476894 | 2476894 | 2022-05-06 | Columbia | Arkansas | 5027 | 5428 | 95 |
2477610 | 2477610 | 2022-05-06 | Harrison | Iowa | 19085 | 3435 | 95 |
2478389 | 2478389 | 2022-05-06 | Big Horn | Montana | 30003 | 4976 | 95 |
2479224 | 2479224 | 2022-05-06 | Lee | South Carolina | 45061 | 4266 | 95 |
2479351 | 2479351 | 2022-05-06 | Johnson | Tennessee | 47091 | 5174 | 95 |
2479680 | 2479680 | 2022-05-06 | Unknown | Utah | 4212 | 95 | |
2479926 | 2479926 | 2022-05-06 | Upshur | West Virginia | 54097 | 6878 | 95 |
2473636 | 2473636 | 2022-05-05 | Columbia | Arkansas | 5027 | 5428 | 95 |
2474352 | 2474352 | 2022-05-05 | Harrison | Iowa | 19085 | 3435 | 95 |
2475131 | 2475131 | 2022-05-05 | Big Horn | Montana | 30003 | 4975 | 95 |
2475966 | 2475966 | 2022-05-05 | Lee | South Carolina | 45061 | 4266 | 95 |
2476093 | 2476093 | 2022-05-05 | Johnson | Tennessee | 47091 | 5174 | 95 |
2476422 | 2476422 | 2022-05-05 | Unknown | Utah | 4212 | 95 | |
2476668 | 2476668 | 2022-05-05 | Upshur | West Virginia | 54097 | 6872 | 95 |
2470379 | 2470379 | 2022-05-04 | Columbia | Arkansas | 5027 | 5427 | 95 |
2471095 | 2471095 | 2022-05-04 | Harrison | Iowa | 19085 | 3435 | 95 |
2471792 | 2471792 | 2022-05-04 | Gasconade | Missouri | 29073 | 3334 | 95 |
2471874 | 2471874 | 2022-05-04 | Big Horn | Montana | 30003 | 4975 | 95 |
2472709 | 2472709 | 2022-05-04 | Lee | South Carolina | 45061 | 4266 | 95 |
2472836 | 2472836 | 2022-05-04 | Johnson | Tennessee | 47091 | 5174 | 95 |
2473410 | 2473410 | 2022-05-04 | Upshur | West Virginia | 54097 | 6867 | 95 |
2467123 | 2467123 | 2022-05-03 | Columbia | Arkansas | 5027 | 5427 | 95 |
2467839 | 2467839 | 2022-05-03 | Harrison | Iowa | 19085 | 3435 | 95 |
2468297 | 2468297 | 2022-05-03 | Mason | Michigan | 26105 | 6793 | 95 |
2468536 | 2468536 | 2022-05-03 | Gasconade | Missouri | 29073 | 3334 | 95 |
2468618 | 2468618 | 2022-05-03 | Big Horn | Montana | 30003 | 4971 | 95 |
2468840 | 2468840 | 2022-05-03 | Roosevelt | New Mexico | 35041 | 5016 | 95 |
2469453 | 2469453 | 2022-05-03 | Lee | South Carolina | 45061 | 4266 | 95 |
2470153 | 2470153 | 2022-05-03 | Upshur | West Virginia | 54097 | 6864 | 95 |
2463868 | 2463868 | 2022-05-02 | Columbia | Arkansas | 5027 | 5427 | 95 |
2464584 | 2464584 | 2022-05-02 | Harrison | Iowa | 19085 | 3435 | 95 |
2465042 | 2465042 | 2022-05-02 | Mason | Michigan | 26105 | 6793 | 95 |
2465280 | 2465280 | 2022-05-02 | Gasconade | Missouri | 29073 | 3334 | 95 |
2465362 | 2465362 | 2022-05-02 | Big Horn | Montana | 30003 | 4969 | 95 |
2466197 | 2466197 | 2022-05-02 | Lee | South Carolina | 45061 | 4254 | 95 |
2466897 | 2466897 | 2022-05-02 | Upshur | West Virginia | 54097 | 6861 | 95 |
2460612 | 2460612 | 2022-05-01 | Columbia | Arkansas | 5027 | 5427 | 95 |
2461328 | 2461328 | 2022-05-01 | Harrison | Iowa | 19085 | 3435 | 95 |
2461786 | 2461786 | 2022-05-01 | Mason | Michigan | 26105 | 6793 | 95 |
2462025 | 2462025 | 2022-05-01 | Gasconade | Missouri | 29073 | 3334 | 95 |
2462107 | 2462107 | 2022-05-01 | Big Horn | Montana | 30003 | 4969 | 95 |
2462942 | 2462942 | 2022-05-01 | Lee | South Carolina | 45061 | 4254 | 95 |
2463398 | 2463398 | 2022-05-01 | Unknown | Utah | 4214 | 95 | |
2463642 | 2463642 | 2022-05-01 | Upshur | West Virginia | 54097 | 6852 | 95 |
2457356 | 2457356 | 2022-04-30 | Columbia | Arkansas | 5027 | 5427 | 95 |
2458072 | 2458072 | 2022-04-30 | Harrison | Iowa | 19085 | 3435 | 95 |
2458530 | 2458530 | 2022-04-30 | Mason | Michigan | 26105 | 6793 | 95 |
2458769 | 2458769 | 2022-04-30 | Gasconade | Missouri | 29073 | 3334 | 95 |
2458851 | 2458851 | 2022-04-30 | Big Horn | Montana | 30003 | 4969 | 95 |
2459686 | 2459686 | 2022-04-30 | Lee | South Carolina | 45061 | 4254 | 95 |
2460142 | 2460142 | 2022-04-30 | Unknown | Utah | 4223 | 95 | |
2460386 | 2460386 | 2022-04-30 | Upshur | West Virginia | 54097 | 6852 | 95 |
2454100 | 2454100 | 2022-04-29 | Columbia | Arkansas | 5027 | 5426 | 95 |
2454816 | 2454816 | 2022-04-29 | Harrison | Iowa | 19085 | 3435 | 95 |
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);