ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
404 rows where deaths = 388 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 39
- Alabama 35
- North Carolina 33
- Pennsylvania 32
- Georgia 28
- Indiana 27
- Florida 20
- South Carolina 16
- Oklahoma 14
- Ohio 12
- Maryland 11
- Mississippi 11
- Wisconsin 10
- Connecticut 9
- New Jersey 8
- Oregon 8
- Tennessee 8
- California 7
- Colorado 7
- Missouri 7
- New York 7
- Virginia 7
- Hawaii 6
- Kansas 6
- Illinois 4
- Louisiana 4
- Massachusetts 4
- Arizona 3
- Delaware 3
- New Mexico 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490227 | 2490227 | 2022-05-10 | Columbia | Georgia | 13073 | 36247 | 388 |
2486970 | 2486970 | 2022-05-09 | Columbia | Georgia | 13073 | 36247 | 388 |
2483712 | 2483712 | 2022-05-08 | Columbia | Georgia | 13073 | 36246 | 388 |
2480454 | 2480454 | 2022-05-07 | Columbia | Georgia | 13073 | 36246 | 388 |
2477196 | 2477196 | 2022-05-06 | Columbia | Georgia | 13073 | 36246 | 388 |
2473938 | 2473938 | 2022-05-05 | Columbia | Georgia | 13073 | 36246 | 388 |
2470681 | 2470681 | 2022-05-04 | Columbia | Georgia | 13073 | 36246 | 388 |
2472421 | 2472421 | 2022-05-04 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2468974 | 2468974 | 2022-05-03 | New Hanover | North Carolina | 37129 | 50916 | 388 |
2469165 | 2469165 | 2022-05-03 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2465718 | 2465718 | 2022-05-02 | New Hanover | North Carolina | 37129 | 50916 | 388 |
2465909 | 2465909 | 2022-05-02 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2462463 | 2462463 | 2022-05-01 | New Hanover | North Carolina | 37129 | 50916 | 388 |
2462654 | 2462654 | 2022-05-01 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2459207 | 2459207 | 2022-04-30 | New Hanover | North Carolina | 37129 | 50916 | 388 |
2459398 | 2459398 | 2022-04-30 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2455951 | 2455951 | 2022-04-29 | New Hanover | North Carolina | 37129 | 50916 | 388 |
2456142 | 2456142 | 2022-04-29 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2450971 | 2450971 | 2022-04-28 | Boulder | Colorado | 8013 | 65750 | 388 |
2452695 | 2452695 | 2022-04-28 | New Hanover | North Carolina | 37129 | 50916 | 388 |
2452886 | 2452886 | 2022-04-28 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2447715 | 2447715 | 2022-04-27 | Boulder | Colorado | 8013 | 65404 | 388 |
2449439 | 2449439 | 2022-04-27 | New Hanover | North Carolina | 37129 | 50916 | 388 |
2446182 | 2446182 | 2022-04-26 | New Hanover | North Carolina | 37129 | 50729 | 388 |
2442927 | 2442927 | 2022-04-25 | New Hanover | North Carolina | 37129 | 50729 | 388 |
2439671 | 2439671 | 2022-04-24 | New Hanover | North Carolina | 37129 | 50729 | 388 |
2436415 | 2436415 | 2022-04-23 | New Hanover | North Carolina | 37129 | 50729 | 388 |
2433159 | 2433159 | 2022-04-22 | New Hanover | North Carolina | 37129 | 50729 | 388 |
2429903 | 2429903 | 2022-04-21 | New Hanover | North Carolina | 37129 | 50729 | 388 |
2424923 | 2424923 | 2022-04-20 | Boulder | Colorado | 8013 | 65019 | 388 |
2426647 | 2426647 | 2022-04-20 | New Hanover | North Carolina | 37129 | 50729 | 388 |
2423391 | 2423391 | 2022-04-19 | New Hanover | North Carolina | 37129 | 50622 | 388 |
2420134 | 2420134 | 2022-04-18 | New Hanover | North Carolina | 37129 | 50622 | 388 |
2416879 | 2416879 | 2022-04-17 | New Hanover | North Carolina | 37129 | 50622 | 388 |
2413623 | 2413623 | 2022-04-16 | New Hanover | North Carolina | 37129 | 50622 | 388 |
2410367 | 2410367 | 2022-04-15 | New Hanover | North Carolina | 37129 | 50622 | 388 |
2407111 | 2407111 | 2022-04-14 | New Hanover | North Carolina | 37129 | 50622 | 388 |
2403855 | 2403855 | 2022-04-13 | New Hanover | North Carolina | 37129 | 50622 | 388 |
2404053 | 2404053 | 2022-04-13 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2400798 | 2400798 | 2022-04-12 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2397543 | 2397543 | 2022-04-11 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2394288 | 2394288 | 2022-04-10 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2391032 | 2391032 | 2022-04-09 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2387776 | 2387776 | 2022-04-08 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2382831 | 2382831 | 2022-04-07 | Lowndes | Georgia | 13185 | 30975 | 388 |
2384521 | 2384521 | 2022-04-07 | Comanche | Oklahoma | 40031 | 33004 | 388 |
2385562 | 2385562 | 2022-04-07 | Rock | Wisconsin | 55105 | 42887 | 388 |
2379576 | 2379576 | 2022-04-06 | Lowndes | Georgia | 13185 | 30975 | 388 |
2382307 | 2382307 | 2022-04-06 | Rock | Wisconsin | 55105 | 42864 | 388 |
2379052 | 2379052 | 2022-04-05 | Rock | Wisconsin | 55105 | 42845 | 388 |
2372626 | 2372626 | 2022-04-04 | Lauderdale | Alabama | 1077 | 24075 | 388 |
2373036 | 2373036 | 2022-04-04 | Forsyth | Georgia | 13117 | 55433 | 388 |
2369373 | 2369373 | 2022-04-03 | Lauderdale | Alabama | 1077 | 24071 | 388 |
2366120 | 2366120 | 2022-04-02 | Lauderdale | Alabama | 1077 | 24071 | 388 |
2362867 | 2362867 | 2022-04-01 | Lauderdale | Alabama | 1077 | 24071 | 388 |
2359613 | 2359613 | 2022-03-31 | Lauderdale | Alabama | 1077 | 24070 | 388 |
2356359 | 2356359 | 2022-03-30 | Lauderdale | Alabama | 1077 | 24068 | 388 |
2353106 | 2353106 | 2022-03-29 | Lauderdale | Alabama | 1077 | 24068 | 388 |
2349863 | 2349863 | 2022-03-28 | Marshall | Alabama | 1095 | 27328 | 388 |
2352830 | 2352830 | 2022-03-28 | Newport News city | Virginia | 51700 | 36090 | 388 |
2346610 | 2346610 | 2022-03-27 | Marshall | Alabama | 1095 | 27323 | 388 |
2347001 | 2347001 | 2022-03-27 | Douglas | Georgia | 13097 | 34724 | 388 |
2349578 | 2349578 | 2022-03-27 | Newport News city | Virginia | 51700 | 36073 | 388 |
2343357 | 2343357 | 2022-03-26 | Marshall | Alabama | 1095 | 27323 | 388 |
2343748 | 2343748 | 2022-03-26 | Douglas | Georgia | 13097 | 34724 | 388 |
2346325 | 2346325 | 2022-03-26 | Newport News city | Virginia | 51700 | 36073 | 388 |
2340104 | 2340104 | 2022-03-25 | Marshall | Alabama | 1095 | 27323 | 388 |
2340495 | 2340495 | 2022-03-25 | Douglas | Georgia | 13097 | 34724 | 388 |
2343072 | 2343072 | 2022-03-25 | Newport News city | Virginia | 51700 | 36073 | 388 |
2336851 | 2336851 | 2022-03-24 | Marshall | Alabama | 1095 | 27323 | 388 |
2337055 | 2337055 | 2022-03-24 | Boulder | Colorado | 8013 | 62618 | 388 |
2337242 | 2337242 | 2022-03-24 | Douglas | Georgia | 13097 | 34718 | 388 |
2333597 | 2333597 | 2022-03-23 | Marshall | Alabama | 1095 | 27324 | 388 |
2333801 | 2333801 | 2022-03-23 | Boulder | Colorado | 8013 | 62532 | 388 |
2333988 | 2333988 | 2022-03-23 | Douglas | Georgia | 13097 | 34713 | 388 |
2330343 | 2330343 | 2022-03-22 | Marshall | Alabama | 1095 | 27324 | 388 |
2326679 | 2326679 | 2022-03-20 | Davis | Utah | 49011 | 100000 | 388 |
2323426 | 2323426 | 2022-03-19 | Davis | Utah | 49011 | 100000 | 388 |
2320172 | 2320172 | 2022-03-18 | Davis | Utah | 49011 | 100000 | 388 |
2311560 | 2311560 | 2022-03-16 | Tippecanoe | Indiana | 18157 | 49771 | 388 |
2301735 | 2301735 | 2022-03-13 | Clark | Indiana | 18019 | 30956 | 388 |
2298483 | 2298483 | 2022-03-12 | Clark | Indiana | 18019 | 30956 | 388 |
2295231 | 2295231 | 2022-03-11 | Clark | Indiana | 18019 | 30956 | 388 |
2293106 | 2293106 | 2022-03-10 | Sandoval | New Mexico | 35043 | 33153 | 388 |
2289854 | 2289854 | 2022-03-09 | Sandoval | New Mexico | 35043 | 33122 | 388 |
2274472 | 2274472 | 2022-03-04 | Guadalupe | Texas | 48187 | 36820 | 388 |
2270433 | 2270433 | 2022-03-03 | Davidson | North Carolina | 37057 | 42676 | 388 |
2267181 | 2267181 | 2022-03-02 | Davidson | North Carolina | 37057 | 42657 | 388 |
2263929 | 2263929 | 2022-03-01 | Davidson | North Carolina | 37057 | 42638 | 388 |
2255946 | 2255946 | 2022-02-27 | Glynn | Georgia | 13127 | 22751 | 388 |
2256703 | 2256703 | 2022-02-27 | Carroll | Maryland | 24013 | 21025 | 388 |
2252695 | 2252695 | 2022-02-26 | Glynn | Georgia | 13127 | 22751 | 388 |
2253452 | 2253452 | 2022-02-26 | Carroll | Maryland | 24013 | 21010 | 388 |
2249444 | 2249444 | 2022-02-25 | Glynn | Georgia | 13127 | 22751 | 388 |
2250201 | 2250201 | 2022-02-25 | Carroll | Maryland | 24013 | 20987 | 388 |
2246193 | 2246193 | 2022-02-24 | Glynn | Georgia | 13127 | 22720 | 388 |
2246950 | 2246950 | 2022-02-24 | Carroll | Maryland | 24013 | 20966 | 388 |
2243699 | 2243699 | 2022-02-23 | Carroll | Maryland | 24013 | 20949 | 388 |
2244475 | 2244475 | 2022-02-23 | Rutherford | North Carolina | 37161 | 17188 | 388 |
2229006 | 2229006 | 2022-02-18 | Liberty | Texas | 48291 | 17263 | 388 |
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);