ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
824 rows where deaths = 306 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 112
- Ohio 66
- Texas 61
- North Carolina 48
- Louisiana 43
- Alabama 39
- Georgia 39
- Virginia 39
- Pennsylvania 31
- Michigan 30
- Iowa 25
- South Carolina 24
- Oklahoma 21
- Tennessee 20
- California 18
- Indiana 18
- Illinois 17
- Missouri 17
- Mississippi 16
- Kentucky 15
- Arizona 12
- Arkansas 11
- Oregon 11
- New Mexico 9
- Wisconsin 9
- Colorado 8
- Kansas 7
- Minnesota 6
- Nebraska 6
- South Dakota 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502198 | 2502198 | 2022-05-13 | Unknown | Tennessee | 19465 | 306 | |
2351332 | 2351332 | 2022-03-28 | Cass | Missouri | 29037 | 24935 | 306 |
2348080 | 2348080 | 2022-03-27 | Cass | Missouri | 29037 | 24918 | 306 |
2344827 | 2344827 | 2022-03-26 | Cass | Missouri | 29037 | 24918 | 306 |
2341574 | 2341574 | 2022-03-25 | Cass | Missouri | 29037 | 24918 | 306 |
2342677 | 2342677 | 2022-03-25 | Unknown | Tennessee | 18929 | 306 | |
2328560 | 2328560 | 2022-03-21 | Cass | Missouri | 29037 | 24877 | 306 |
2322356 | 2322356 | 2022-03-19 | Chaves | New Mexico | 35005 | 21678 | 306 |
2319102 | 2319102 | 2022-03-18 | Chaves | New Mexico | 35005 | 21678 | 306 |
2315849 | 2315849 | 2022-03-17 | Chaves | New Mexico | 35005 | 21678 | 306 |
2307970 | 2307970 | 2022-03-15 | Fayette | Georgia | 13113 | 22128 | 306 |
2301715 | 2301715 | 2022-03-13 | Vermilion | Illinois | 17183 | 27832 | 306 |
2302937 | 2302937 | 2022-03-13 | Brunswick | North Carolina | 37019 | 29531 | 306 |
2298463 | 2298463 | 2022-03-12 | Vermilion | Illinois | 17183 | 27832 | 306 |
2299685 | 2299685 | 2022-03-12 | Brunswick | North Carolina | 37019 | 29531 | 306 |
2295211 | 2295211 | 2022-03-11 | Vermilion | Illinois | 17183 | 27832 | 306 |
2296433 | 2296433 | 2022-03-11 | Brunswick | North Carolina | 37019 | 29531 | 306 |
2293181 | 2293181 | 2022-03-10 | Brunswick | North Carolina | 37019 | 29514 | 306 |
2293370 | 2293370 | 2022-03-10 | Jefferson | Ohio | 39081 | 14633 | 306 |
2288146 | 2288146 | 2022-03-09 | Faulkner | Arkansas | 5045 | 34827 | 306 |
2288256 | 2288256 | 2022-03-09 | Yolo | California | 6113 | 39055 | 306 |
2290118 | 2290118 | 2022-03-09 | Jefferson | Ohio | 39081 | 14625 | 306 |
2285005 | 2285005 | 2022-03-08 | Yolo | California | 6113 | 39043 | 306 |
2286866 | 2286866 | 2022-03-08 | Jefferson | Ohio | 39081 | 14622 | 306 |
2281753 | 2281753 | 2022-03-07 | Yolo | California | 6113 | 38991 | 306 |
2278500 | 2278500 | 2022-03-06 | Yolo | California | 6113 | 38965 | 306 |
2279690 | 2279690 | 2022-03-06 | Forrest | Mississippi | 28035 | 21900 | 306 |
2275247 | 2275247 | 2022-03-05 | Yolo | California | 6113 | 38965 | 306 |
2276437 | 2276437 | 2022-03-05 | Forrest | Mississippi | 28035 | 21900 | 306 |
2271994 | 2271994 | 2022-03-04 | Yolo | California | 6113 | 38965 | 306 |
2273184 | 2273184 | 2022-03-04 | Forrest | Mississippi | 28035 | 21900 | 306 |
2269932 | 2269932 | 2022-03-03 | Forrest | Mississippi | 28035 | 21896 | 306 |
2266679 | 2266679 | 2022-03-02 | Forrest | Mississippi | 28035 | 21892 | 306 |
2268416 | 2268416 | 2022-03-02 | Dodge | Wisconsin | 55027 | 26887 | 306 |
2262507 | 2262507 | 2022-03-01 | Rockdale | Georgia | 13247 | 18231 | 306 |
2264165 | 2264165 | 2022-03-01 | Creek | Oklahoma | 40037 | 17986 | 306 |
2265163 | 2265163 | 2022-03-01 | Dodge | Wisconsin | 55027 | 26873 | 306 |
2260915 | 2260915 | 2022-02-28 | Creek | Oklahoma | 40037 | 17986 | 306 |
2261769 | 2261769 | 2022-02-28 | Portsmouth city | Virginia | 51740 | 20587 | 306 |
2255665 | 2255665 | 2022-02-27 | Saline | Arkansas | 5125 | 30397 | 306 |
2257664 | 2257664 | 2022-02-27 | Creek | Oklahoma | 40037 | 17986 | 306 |
2258518 | 2258518 | 2022-02-27 | Portsmouth city | Virginia | 51740 | 20572 | 306 |
2254413 | 2254413 | 2022-02-26 | Creek | Oklahoma | 40037 | 17986 | 306 |
2255267 | 2255267 | 2022-02-26 | Portsmouth city | Virginia | 51740 | 20572 | 306 |
2251162 | 2251162 | 2022-02-25 | Creek | Oklahoma | 40037 | 17986 | 306 |
2252016 | 2252016 | 2022-02-25 | Portsmouth city | Virginia | 51740 | 20572 | 306 |
2245780 | 2245780 | 2022-02-24 | Lee | Alabama | 1081 | 37484 | 306 |
2245866 | 2245866 | 2022-02-24 | Craighead | Arkansas | 5031 | 36401 | 306 |
2247688 | 2247688 | 2022-02-24 | Harnett | North Carolina | 37085 | 31754 | 306 |
2247911 | 2247911 | 2022-02-24 | Creek | Oklahoma | 40037 | 17986 | 306 |
2248765 | 2248765 | 2022-02-24 | Portsmouth city | Virginia | 51740 | 20543 | 306 |
2242615 | 2242615 | 2022-02-23 | Craighead | Arkansas | 5031 | 36376 | 306 |
2244437 | 2244437 | 2022-02-23 | Harnett | North Carolina | 37085 | 31730 | 306 |
2244660 | 2244660 | 2022-02-23 | Creek | Oklahoma | 40037 | 17986 | 306 |
2239364 | 2239364 | 2022-02-22 | Craighead | Arkansas | 5031 | 36267 | 306 |
2241229 | 2241229 | 2022-02-22 | Surry | North Carolina | 37171 | 20669 | 306 |
2241441 | 2241441 | 2022-02-22 | Muskogee | Oklahoma | 40101 | 19679 | 306 |
2236113 | 2236113 | 2022-02-21 | Craighead | Arkansas | 5031 | 36209 | 306 |
2238190 | 2238190 | 2022-02-21 | Muskogee | Oklahoma | 40101 | 19679 | 306 |
2232862 | 2232862 | 2022-02-20 | Craighead | Arkansas | 5031 | 36177 | 306 |
2234939 | 2234939 | 2022-02-20 | Muskogee | Oklahoma | 40101 | 19679 | 306 |
2235672 | 2235672 | 2022-02-20 | Arlington | Virginia | 51013 | 39749 | 306 |
2229611 | 2229611 | 2022-02-19 | Craighead | Arkansas | 5031 | 36149 | 306 |
2231688 | 2231688 | 2022-02-19 | Muskogee | Oklahoma | 40101 | 19679 | 306 |
2232421 | 2232421 | 2022-02-19 | Arlington | Virginia | 51013 | 39749 | 306 |
2226360 | 2226360 | 2022-02-18 | Craighead | Arkansas | 5031 | 36099 | 306 |
2228437 | 2228437 | 2022-02-18 | Muskogee | Oklahoma | 40101 | 19679 | 306 |
2229170 | 2229170 | 2022-02-18 | Arlington | Virginia | 51013 | 39749 | 306 |
2225186 | 2225186 | 2022-02-17 | Muskogee | Oklahoma | 40101 | 19679 | 306 |
2225919 | 2225919 | 2022-02-17 | Arlington | Virginia | 51013 | 39629 | 306 |
2221935 | 2221935 | 2022-02-16 | Muskogee | Oklahoma | 40101 | 19679 | 306 |
2222668 | 2222668 | 2022-02-16 | Arlington | Virginia | 51013 | 39583 | 306 |
2219417 | 2219417 | 2022-02-15 | Arlington | Virginia | 51013 | 39508 | 306 |
2216167 | 2216167 | 2022-02-14 | Arlington | Virginia | 51013 | 39449 | 306 |
2201408 | 2201408 | 2022-02-10 | Cumberland | Maine | 23005 | 38586 | 306 |
2198154 | 2198154 | 2022-02-09 | Cumberland | Maine | 23005 | 38343 | 306 |
2200003 | 2200003 | 2022-02-09 | Roanoke city | Virginia | 51770 | 20284 | 306 |
2200121 | 2200121 | 2022-02-09 | Wood | West Virginia | 54107 | 21064 | 306 |
2194900 | 2194900 | 2022-02-08 | Cumberland | Maine | 23005 | 38153 | 306 |
2195539 | 2195539 | 2022-02-08 | Lea | New Mexico | 35025 | 19777 | 306 |
2192285 | 2192285 | 2022-02-07 | Lea | New Mexico | 35025 | 19734 | 306 |
2189032 | 2189032 | 2022-02-06 | Lea | New Mexico | 35025 | 19647 | 306 |
2185779 | 2185779 | 2022-02-05 | Lea | New Mexico | 35025 | 19647 | 306 |
2182527 | 2182527 | 2022-02-04 | Lea | New Mexico | 35025 | 19647 | 306 |
2178113 | 2178113 | 2022-02-03 | McLean | Illinois | 17113 | 47237 | 306 |
2179275 | 2179275 | 2022-02-03 | Lea | New Mexico | 35025 | 19599 | 306 |
2174860 | 2174860 | 2022-02-02 | McLean | Illinois | 17113 | 47237 | 306 |
2176084 | 2176084 | 2022-02-02 | Saratoga | New York | 36091 | 43365 | 306 |
2173504 | 2173504 | 2022-02-01 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2169210 | 2169210 | 2022-01-31 | Clay | Missouri | 29047 | 24758 | 306 |
2170252 | 2170252 | 2022-01-31 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2165955 | 2165955 | 2022-01-30 | Clay | Missouri | 29047 | 24715 | 306 |
2166407 | 2166407 | 2022-01-30 | Onslow | North Carolina | 37133 | 44927 | 306 |
2166952 | 2166952 | 2022-01-30 | Pennington | South Dakota | 46103 | 30904 | 306 |
2166998 | 2166998 | 2022-01-30 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2162700 | 2162700 | 2022-01-29 | Clay | Missouri | 29047 | 24652 | 306 |
2163152 | 2163152 | 2022-01-29 | Onslow | North Carolina | 37133 | 44927 | 306 |
2163697 | 2163697 | 2022-01-29 | Pennington | South Dakota | 46103 | 30904 | 306 |
2163743 | 2163743 | 2022-01-29 | Hamblen | Tennessee | 47063 | 17330 | 306 |
2159445 | 2159445 | 2022-01-28 | Clay | Missouri | 29047 | 24487 | 306 |
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);