ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
719 rows where deaths = 310 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 77
- Wisconsin 50
- North Carolina 49
- Missouri 44
- Iowa 38
- Alabama 37
- Louisiana 36
- South Carolina 36
- Pennsylvania 28
- Indiana 27
- Ohio 26
- Tennessee 26
- California 22
- Michigan 22
- Georgia 19
- Illinois 18
- Mississippi 18
- Florida 16
- Oregon 16
- Minnesota 12
- Virginia 11
- Washington 11
- Maryland 10
- New Mexico 9
- Arkansas 7
- Colorado 7
- Kentucky 7
- Delaware 5
- New York 5
- South Dakota 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492240 | 2492240 | 2022-05-10 | Darlington | South Carolina | 45031 | 18916 | 310 |
2488982 | 2488982 | 2022-05-09 | Darlington | South Carolina | 45031 | 18916 | 310 |
2485725 | 2485725 | 2022-05-08 | Darlington | South Carolina | 45031 | 18916 | 310 |
2482467 | 2482467 | 2022-05-07 | Darlington | South Carolina | 45031 | 18916 | 310 |
2479209 | 2479209 | 2022-05-06 | Darlington | South Carolina | 45031 | 18916 | 310 |
2475951 | 2475951 | 2022-05-05 | Darlington | South Carolina | 45031 | 18916 | 310 |
2471804 | 2471804 | 2022-05-04 | Jasper | Missouri | 29097 | 20862 | 310 |
2472694 | 2472694 | 2022-05-04 | Darlington | South Carolina | 45031 | 18916 | 310 |
2468548 | 2468548 | 2022-05-03 | Jasper | Missouri | 29097 | 20862 | 310 |
2469438 | 2469438 | 2022-05-03 | Darlington | South Carolina | 45031 | 18916 | 310 |
2465292 | 2465292 | 2022-05-02 | Jasper | Missouri | 29097 | 20862 | 310 |
2466182 | 2466182 | 2022-05-02 | Darlington | South Carolina | 45031 | 18899 | 310 |
2462037 | 2462037 | 2022-05-01 | Jasper | Missouri | 29097 | 20862 | 310 |
2462927 | 2462927 | 2022-05-01 | Darlington | South Carolina | 45031 | 18899 | 310 |
2458781 | 2458781 | 2022-04-30 | Jasper | Missouri | 29097 | 20862 | 310 |
2459671 | 2459671 | 2022-04-30 | Darlington | South Carolina | 45031 | 18899 | 310 |
2455525 | 2455525 | 2022-04-29 | Jasper | Missouri | 29097 | 20862 | 310 |
2456415 | 2456415 | 2022-04-29 | Darlington | South Carolina | 45031 | 18899 | 310 |
2452269 | 2452269 | 2022-04-28 | Jasper | Missouri | 29097 | 20862 | 310 |
2453159 | 2453159 | 2022-04-28 | Darlington | South Carolina | 45031 | 18899 | 310 |
2449013 | 2449013 | 2022-04-27 | Jasper | Missouri | 29097 | 20862 | 310 |
2449903 | 2449903 | 2022-04-27 | Darlington | South Carolina | 45031 | 18891 | 310 |
2445756 | 2445756 | 2022-04-26 | Jasper | Missouri | 29097 | 20862 | 310 |
2446646 | 2446646 | 2022-04-26 | Darlington | South Carolina | 45031 | 18891 | 310 |
2442501 | 2442501 | 2022-04-25 | Jasper | Missouri | 29097 | 20862 | 310 |
2443391 | 2443391 | 2022-04-25 | Darlington | South Carolina | 45031 | 18891 | 310 |
2439245 | 2439245 | 2022-04-24 | Jasper | Missouri | 29097 | 20862 | 310 |
2440135 | 2440135 | 2022-04-24 | Darlington | South Carolina | 45031 | 18891 | 310 |
2435989 | 2435989 | 2022-04-23 | Jasper | Missouri | 29097 | 20862 | 310 |
2436879 | 2436879 | 2022-04-23 | Darlington | South Carolina | 45031 | 18891 | 310 |
2432733 | 2432733 | 2022-04-22 | Jasper | Missouri | 29097 | 20862 | 310 |
2433623 | 2433623 | 2022-04-22 | Darlington | South Carolina | 45031 | 18891 | 310 |
2429477 | 2429477 | 2022-04-21 | Jasper | Missouri | 29097 | 20862 | 310 |
2430367 | 2430367 | 2022-04-21 | Darlington | South Carolina | 45031 | 18891 | 310 |
2426221 | 2426221 | 2022-04-20 | Jasper | Missouri | 29097 | 20862 | 310 |
2427111 | 2427111 | 2022-04-20 | Darlington | South Carolina | 45031 | 18891 | 310 |
2422965 | 2422965 | 2022-04-19 | Jasper | Missouri | 29097 | 20862 | 310 |
2423855 | 2423855 | 2022-04-19 | Darlington | South Carolina | 45031 | 18891 | 310 |
2419708 | 2419708 | 2022-04-18 | Jasper | Missouri | 29097 | 20862 | 310 |
2416453 | 2416453 | 2022-04-17 | Jasper | Missouri | 29097 | 20862 | 310 |
2413197 | 2413197 | 2022-04-16 | Jasper | Missouri | 29097 | 20862 | 310 |
2409941 | 2409941 | 2022-04-15 | Jasper | Missouri | 29097 | 20862 | 310 |
2406685 | 2406685 | 2022-04-14 | Jasper | Missouri | 29097 | 20862 | 310 |
2403429 | 2403429 | 2022-04-13 | Jasper | Missouri | 29097 | 20862 | 310 |
2400174 | 2400174 | 2022-04-12 | Jasper | Missouri | 29097 | 20862 | 310 |
2401197 | 2401197 | 2022-04-12 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2396919 | 2396919 | 2022-04-11 | Jasper | Missouri | 29097 | 20862 | 310 |
2397942 | 2397942 | 2022-04-11 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2393664 | 2393664 | 2022-04-10 | Jasper | Missouri | 29097 | 20862 | 310 |
2394687 | 2394687 | 2022-04-10 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2390408 | 2390408 | 2022-04-09 | Jasper | Missouri | 29097 | 20862 | 310 |
2391431 | 2391431 | 2022-04-09 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2387152 | 2387152 | 2022-04-08 | Jasper | Missouri | 29097 | 20862 | 310 |
2388175 | 2388175 | 2022-04-08 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2383897 | 2383897 | 2022-04-07 | Jasper | Missouri | 29097 | 20862 | 310 |
2384920 | 2384920 | 2022-04-07 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2380642 | 2380642 | 2022-04-06 | Jasper | Missouri | 29097 | 20862 | 310 |
2381665 | 2381665 | 2022-04-06 | Hawkins | Tennessee | 47073 | 16636 | 310 |
2377387 | 2377387 | 2022-04-05 | Jasper | Missouri | 29097 | 20862 | 310 |
2374134 | 2374134 | 2022-04-04 | Jasper | Missouri | 29097 | 20862 | 310 |
2370882 | 2370882 | 2022-04-03 | Jasper | Missouri | 29097 | 20862 | 310 |
2367629 | 2367629 | 2022-04-02 | Jasper | Missouri | 29097 | 20862 | 310 |
2364376 | 2364376 | 2022-04-01 | Jasper | Missouri | 29097 | 20862 | 310 |
2361122 | 2361122 | 2022-03-31 | Jasper | Missouri | 29097 | 20862 | 310 |
2357868 | 2357868 | 2022-03-30 | Jasper | Missouri | 29097 | 20851 | 310 |
2354615 | 2354615 | 2022-03-29 | Jasper | Missouri | 29097 | 20848 | 310 |
2351634 | 2351634 | 2022-03-28 | Chaves | New Mexico | 35005 | 21692 | 310 |
2347009 | 2347009 | 2022-03-27 | Fayette | Georgia | 13113 | 22195 | 310 |
2348480 | 2348480 | 2022-03-27 | Brunswick | North Carolina | 37019 | 29709 | 310 |
2349779 | 2349779 | 2022-03-27 | Sheboygan | Wisconsin | 55117 | 32354 | 310 |
2343756 | 2343756 | 2022-03-26 | Fayette | Georgia | 13113 | 22195 | 310 |
2345227 | 2345227 | 2022-03-26 | Brunswick | North Carolina | 37019 | 29709 | 310 |
2346526 | 2346526 | 2022-03-26 | Sheboygan | Wisconsin | 55117 | 32354 | 310 |
2340503 | 2340503 | 2022-03-25 | Fayette | Georgia | 13113 | 22195 | 310 |
2341974 | 2341974 | 2022-03-25 | Brunswick | North Carolina | 37019 | 29709 | 310 |
2343273 | 2343273 | 2022-03-25 | Sheboygan | Wisconsin | 55117 | 32354 | 310 |
2337498 | 2337498 | 2022-03-24 | Vermilion | Illinois | 17183 | 27833 | 310 |
2338721 | 2338721 | 2022-03-24 | Brunswick | North Carolina | 37019 | 29699 | 310 |
2334244 | 2334244 | 2022-03-23 | Vermilion | Illinois | 17183 | 27836 | 310 |
2335467 | 2335467 | 2022-03-23 | Brunswick | North Carolina | 37019 | 29695 | 310 |
2330990 | 2330990 | 2022-03-22 | Vermilion | Illinois | 17183 | 27835 | 310 |
2331170 | 2331170 | 2022-03-22 | Pottawattamie | Iowa | 19155 | 24179 | 310 |
2327918 | 2327918 | 2022-03-21 | Pottawattamie | Iowa | 19155 | 24179 | 310 |
2324665 | 2324665 | 2022-03-20 | Pottawattamie | Iowa | 19155 | 24179 | 310 |
2325224 | 2325224 | 2022-03-20 | Forrest | Mississippi | 28035 | 21922 | 310 |
2321411 | 2321411 | 2022-03-19 | Pottawattamie | Iowa | 19155 | 24179 | 310 |
2321970 | 2321970 | 2022-03-19 | Forrest | Mississippi | 28035 | 21922 | 310 |
2318157 | 2318157 | 2022-03-18 | Pottawattamie | Iowa | 19155 | 24179 | 310 |
2318716 | 2318716 | 2022-03-18 | Forrest | Mississippi | 28035 | 21922 | 310 |
2314163 | 2314163 | 2022-03-17 | Faulkner | Arkansas | 5045 | 34924 | 310 |
2314904 | 2314904 | 2022-03-17 | Pottawattamie | Iowa | 19155 | 24179 | 310 |
2315463 | 2315463 | 2022-03-17 | Forrest | Mississippi | 28035 | 21922 | 310 |
2310910 | 2310910 | 2022-03-16 | Faulkner | Arkansas | 5045 | 34912 | 310 |
2311651 | 2311651 | 2022-03-16 | Pottawattamie | Iowa | 19155 | 24179 | 310 |
2312210 | 2312210 | 2022-03-16 | Forrest | Mississippi | 28035 | 21922 | 310 |
2307657 | 2307657 | 2022-03-15 | Faulkner | Arkansas | 5045 | 34903 | 310 |
2308957 | 2308957 | 2022-03-15 | Forrest | Mississippi | 28035 | 21922 | 310 |
2310074 | 2310074 | 2022-03-15 | Cumberland | Tennessee | 47035 | 16042 | 310 |
2304406 | 2304406 | 2022-03-14 | Faulkner | Arkansas | 5045 | 34895 | 310 |
2305706 | 2305706 | 2022-03-14 | Forrest | Mississippi | 28035 | 21922 | 310 |
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);