ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,399 rows where deaths = 194 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 148
- Alabama 101
- Ohio 81
- Virginia 80
- Georgia 73
- Indiana 60
- North Carolina 60
- Tennessee 50
- Pennsylvania 48
- Maryland 47
- Kentucky 44
- North Dakota 44
- Missouri 42
- Illinois 39
- New York 39
- Wisconsin 36
- Michigan 34
- California 33
- Arkansas 31
- South Carolina 30
- Louisiana 28
- Oregon 27
- New Jersey 25
- New Mexico 19
- Connecticut 17
- West Virginia 17
- Oklahoma 16
- Mississippi 14
- Washington 13
- Florida 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501463 | 2501463 | 2022-05-13 | Oswego | New York | 36075 | 28826 | 194 |
2498205 | 2498205 | 2022-05-12 | Oswego | New York | 36075 | 28826 | 194 |
2494947 | 2494947 | 2022-05-11 | Oswego | New York | 36075 | 28774 | 194 |
2490242 | 2490242 | 2022-05-10 | Effingham | Georgia | 13103 | 13272 | 194 |
2491689 | 2491689 | 2022-05-10 | Oswego | New York | 36075 | 28719 | 194 |
2492260 | 2492260 | 2022-05-10 | Newberry | South Carolina | 45071 | 13318 | 194 |
2486985 | 2486985 | 2022-05-09 | Effingham | Georgia | 13103 | 13272 | 194 |
2488431 | 2488431 | 2022-05-09 | Oswego | New York | 36075 | 28687 | 194 |
2489002 | 2489002 | 2022-05-09 | Newberry | South Carolina | 45071 | 13318 | 194 |
2483727 | 2483727 | 2022-05-08 | Effingham | Georgia | 13103 | 13271 | 194 |
2485110 | 2485110 | 2022-05-08 | Curry | New Mexico | 35009 | 12763 | 194 |
2485745 | 2485745 | 2022-05-08 | Newberry | South Carolina | 45071 | 13318 | 194 |
2480469 | 2480469 | 2022-05-07 | Effingham | Georgia | 13103 | 13271 | 194 |
2481852 | 2481852 | 2022-05-07 | Curry | New Mexico | 35009 | 12763 | 194 |
2482487 | 2482487 | 2022-05-07 | Newberry | South Carolina | 45071 | 13318 | 194 |
2477211 | 2477211 | 2022-05-06 | Effingham | Georgia | 13103 | 13271 | 194 |
2478594 | 2478594 | 2022-05-06 | Curry | New Mexico | 35009 | 12763 | 194 |
2479229 | 2479229 | 2022-05-06 | Newberry | South Carolina | 45071 | 13318 | 194 |
2473953 | 2473953 | 2022-05-05 | Effingham | Georgia | 13103 | 13271 | 194 |
2475971 | 2475971 | 2022-05-05 | Newberry | South Carolina | 45071 | 13318 | 194 |
2470696 | 2470696 | 2022-05-04 | Effingham | Georgia | 13103 | 13271 | 194 |
2472714 | 2472714 | 2022-05-04 | Newberry | South Carolina | 45071 | 13318 | 194 |
2467440 | 2467440 | 2022-05-03 | Effingham | Georgia | 13103 | 13218 | 194 |
2469458 | 2469458 | 2022-05-03 | Newberry | South Carolina | 45071 | 13318 | 194 |
2464185 | 2464185 | 2022-05-02 | Effingham | Georgia | 13103 | 13218 | 194 |
2460929 | 2460929 | 2022-05-01 | Effingham | Georgia | 13103 | 13217 | 194 |
2461527 | 2461527 | 2022-05-01 | Floyd | Kentucky | 21071 | 12535 | 194 |
2457673 | 2457673 | 2022-04-30 | Effingham | Georgia | 13103 | 13217 | 194 |
2458271 | 2458271 | 2022-04-30 | Floyd | Kentucky | 21071 | 12535 | 194 |
2454417 | 2454417 | 2022-04-29 | Effingham | Georgia | 13103 | 13217 | 194 |
2455015 | 2455015 | 2022-04-29 | Floyd | Kentucky | 21071 | 12535 | 194 |
2451161 | 2451161 | 2022-04-28 | Effingham | Georgia | 13103 | 13217 | 194 |
2451759 | 2451759 | 2022-04-28 | Floyd | Kentucky | 21071 | 12535 | 194 |
2447905 | 2447905 | 2022-04-27 | Effingham | Georgia | 13103 | 13217 | 194 |
2448503 | 2448503 | 2022-04-27 | Floyd | Kentucky | 21071 | 12535 | 194 |
2445247 | 2445247 | 2022-04-26 | Floyd | Kentucky | 21071 | 12535 | 194 |
2446808 | 2446808 | 2022-04-26 | Obion | Tennessee | 47131 | 10765 | 194 |
2441991 | 2441991 | 2022-04-25 | Floyd | Kentucky | 21071 | 12535 | 194 |
2443553 | 2443553 | 2022-04-25 | Obion | Tennessee | 47131 | 10765 | 194 |
2440297 | 2440297 | 2022-04-24 | Obion | Tennessee | 47131 | 10765 | 194 |
2437041 | 2437041 | 2022-04-23 | Obion | Tennessee | 47131 | 10765 | 194 |
2433785 | 2433785 | 2022-04-22 | Obion | Tennessee | 47131 | 10765 | 194 |
2430529 | 2430529 | 2022-04-21 | Obion | Tennessee | 47131 | 10765 | 194 |
2427273 | 2427273 | 2022-04-20 | Obion | Tennessee | 47131 | 10765 | 194 |
2424393 | 2424393 | 2022-04-19 | Franklin | Virginia | 51067 | 10802 | 194 |
2421137 | 2421137 | 2022-04-18 | Franklin | Virginia | 51067 | 10800 | 194 |
2417881 | 2417881 | 2022-04-17 | Franklin | Virginia | 51067 | 10792 | 194 |
2414625 | 2414625 | 2022-04-16 | Franklin | Virginia | 51067 | 10792 | 194 |
2411369 | 2411369 | 2022-04-15 | Franklin | Virginia | 51067 | 10792 | 194 |
2408113 | 2408113 | 2022-04-14 | Franklin | Virginia | 51067 | 10782 | 194 |
2404908 | 2404908 | 2022-04-13 | Pittsylvania | Virginia | 51143 | 14022 | 194 |
2395179 | 2395179 | 2022-04-10 | Wise | Virginia | 51195 | 10243 | 194 |
2391923 | 2391923 | 2022-04-09 | Wise | Virginia | 51195 | 10243 | 194 |
2388667 | 2388667 | 2022-04-08 | Wise | Virginia | 51195 | 10243 | 194 |
2385412 | 2385412 | 2022-04-07 | Wise | Virginia | 51195 | 10244 | 194 |
2382157 | 2382157 | 2022-04-06 | Wise | Virginia | 51195 | 10242 | 194 |
2378866 | 2378866 | 2022-04-05 | Pittsylvania | Virginia | 51143 | 13940 | 194 |
2378902 | 2378902 | 2022-04-05 | Wise | Virginia | 51195 | 10240 | 194 |
2375612 | 2375612 | 2022-04-04 | Pittsylvania | Virginia | 51143 | 13911 | 194 |
2375648 | 2375648 | 2022-04-04 | Wise | Virginia | 51195 | 10239 | 194 |
2372360 | 2372360 | 2022-04-03 | Pittsylvania | Virginia | 51143 | 13901 | 194 |
2372396 | 2372396 | 2022-04-03 | Wise | Virginia | 51195 | 10237 | 194 |
2369107 | 2369107 | 2022-04-02 | Pittsylvania | Virginia | 51143 | 13901 | 194 |
2369143 | 2369143 | 2022-04-02 | Wise | Virginia | 51195 | 10237 | 194 |
2365854 | 2365854 | 2022-04-01 | Pittsylvania | Virginia | 51143 | 13901 | 194 |
2365890 | 2365890 | 2022-04-01 | Wise | Virginia | 51195 | 10237 | 194 |
2362601 | 2362601 | 2022-03-31 | Pittsylvania | Virginia | 51143 | 13891 | 194 |
2362637 | 2362637 | 2022-03-31 | Wise | Virginia | 51195 | 10237 | 194 |
2359383 | 2359383 | 2022-03-30 | Wise | Virginia | 51195 | 10234 | 194 |
2355730 | 2355730 | 2022-03-29 | Cass | Texas | 48067 | 7200 | 194 |
2356129 | 2356129 | 2022-03-29 | Wise | Virginia | 51195 | 10237 | 194 |
2352477 | 2352477 | 2022-03-28 | Cass | Texas | 48067 | 7200 | 194 |
2352876 | 2352876 | 2022-03-28 | Wise | Virginia | 51195 | 10238 | 194 |
2348495 | 2348495 | 2022-03-27 | Craven | North Carolina | 37049 | 24089 | 194 |
2349225 | 2349225 | 2022-03-27 | Cass | Texas | 48067 | 7200 | 194 |
2349624 | 2349624 | 2022-03-27 | Wise | Virginia | 51195 | 10235 | 194 |
2345242 | 2345242 | 2022-03-26 | Craven | North Carolina | 37049 | 24089 | 194 |
2345972 | 2345972 | 2022-03-26 | Cass | Texas | 48067 | 7200 | 194 |
2346371 | 2346371 | 2022-03-26 | Wise | Virginia | 51195 | 10235 | 194 |
2341989 | 2341989 | 2022-03-25 | Craven | North Carolina | 37049 | 24089 | 194 |
2342719 | 2342719 | 2022-03-25 | Cass | Texas | 48067 | 7198 | 194 |
2343118 | 2343118 | 2022-03-25 | Wise | Virginia | 51195 | 10235 | 194 |
2338736 | 2338736 | 2022-03-24 | Craven | North Carolina | 37049 | 24067 | 194 |
2339466 | 2339466 | 2022-03-24 | Cass | Texas | 48067 | 7196 | 194 |
2339865 | 2339865 | 2022-03-24 | Wise | Virginia | 51195 | 10232 | 194 |
2339916 | 2339916 | 2022-03-24 | Fayette | West Virginia | 54019 | 13026 | 194 |
2335482 | 2335482 | 2022-03-23 | Craven | North Carolina | 37049 | 24052 | 194 |
2335683 | 2335683 | 2022-03-23 | Preble | Ohio | 39135 | 9437 | 194 |
2336212 | 2336212 | 2022-03-23 | Cass | Texas | 48067 | 7193 | 194 |
2336612 | 2336612 | 2022-03-23 | Wise | Virginia | 51195 | 10229 | 194 |
2332429 | 2332429 | 2022-03-22 | Preble | Ohio | 39135 | 9437 | 194 |
2332958 | 2332958 | 2022-03-22 | Cass | Texas | 48067 | 7185 | 194 |
2329176 | 2329176 | 2022-03-21 | Preble | Ohio | 39135 | 9437 | 194 |
2325924 | 2325924 | 2022-03-20 | Preble | Ohio | 39135 | 9437 | 194 |
2322671 | 2322671 | 2022-03-19 | Preble | Ohio | 39135 | 9437 | 194 |
2319417 | 2319417 | 2022-03-18 | Preble | Ohio | 39135 | 9437 | 194 |
2315962 | 2315962 | 2022-03-17 | Craven | North Carolina | 37049 | 23983 | 194 |
2316163 | 2316163 | 2022-03-17 | Preble | Ohio | 39135 | 9437 | 194 |
2317107 | 2317107 | 2022-03-17 | Grays Harbor | Washington | 53027 | 16110 | 194 |
2317122 | 2317122 | 2022-03-17 | Skagit | Washington | 53057 | 21886 | 194 |
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);