ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,384 rows where deaths = 200 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 113
- Indiana 81
- Ohio 80
- Texas 79
- Pennsylvania 74
- Oklahoma 72
- Alabama 71
- Illinois 68
- North Carolina 55
- Tennessee 52
- Louisiana 45
- Florida 41
- New Jersey 36
- California 35
- Virginia 35
- Iowa 34
- Oregon 34
- Michigan 30
- Missouri 29
- North Dakota 27
- Maine 25
- Arkansas 23
- South Carolina 23
- Wisconsin 23
- New York 21
- Minnesota 20
- New Mexico 20
- Washington 17
- Maryland 16
- Nevada 15
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467527 | 2467527 | 2022-05-03 | Toombs | Georgia | 13279 | 7099 | 200 |
2467620 | 2467620 | 2022-05-03 | DeKalb | Illinois | 17037 | 23967 | 200 |
2464272 | 2464272 | 2022-05-02 | Toombs | Georgia | 13279 | 7099 | 200 |
2464365 | 2464365 | 2022-05-02 | DeKalb | Illinois | 17037 | 23925 | 200 |
2461016 | 2461016 | 2022-05-01 | Toombs | Georgia | 13279 | 7097 | 200 |
2461109 | 2461109 | 2022-05-01 | DeKalb | Illinois | 17037 | 23837 | 200 |
2457760 | 2457760 | 2022-04-30 | Toombs | Georgia | 13279 | 7097 | 200 |
2457853 | 2457853 | 2022-04-30 | DeKalb | Illinois | 17037 | 23837 | 200 |
2454504 | 2454504 | 2022-04-29 | Toombs | Georgia | 13279 | 7097 | 200 |
2454597 | 2454597 | 2022-04-29 | DeKalb | Illinois | 17037 | 23837 | 200 |
2451248 | 2451248 | 2022-04-28 | Toombs | Georgia | 13279 | 7097 | 200 |
2451341 | 2451341 | 2022-04-28 | DeKalb | Illinois | 17037 | 23792 | 200 |
2447992 | 2447992 | 2022-04-27 | Toombs | Georgia | 13279 | 7097 | 200 |
2448085 | 2448085 | 2022-04-27 | DeKalb | Illinois | 17037 | 23750 | 200 |
2444829 | 2444829 | 2022-04-26 | DeKalb | Illinois | 17037 | 23718 | 200 |
2441573 | 2441573 | 2022-04-25 | DeKalb | Illinois | 17037 | 23684 | 200 |
2421802 | 2421802 | 2022-04-19 | Unknown | Florida | 25450 | 200 | |
2424001 | 2424001 | 2022-04-19 | Lawrence | Tennessee | 47099 | 14278 | 200 |
2418546 | 2418546 | 2022-04-18 | Unknown | Florida | 22404 | 200 | |
2420745 | 2420745 | 2022-04-18 | Lawrence | Tennessee | 47099 | 14278 | 200 |
2417489 | 2417489 | 2022-04-17 | Lawrence | Tennessee | 47099 | 14278 | 200 |
2414233 | 2414233 | 2022-04-16 | Lawrence | Tennessee | 47099 | 14278 | 200 |
2410671 | 2410671 | 2022-04-15 | Bradford | Pennsylvania | 42015 | 15311 | 200 |
2410977 | 2410977 | 2022-04-15 | Lawrence | Tennessee | 47099 | 14278 | 200 |
2405374 | 2405374 | 2022-04-14 | Tehama | California | 6103 | 14691 | 200 |
2407415 | 2407415 | 2022-04-14 | Bradford | Pennsylvania | 42015 | 15286 | 200 |
2407721 | 2407721 | 2022-04-14 | Lawrence | Tennessee | 47099 | 14278 | 200 |
2404159 | 2404159 | 2022-04-13 | Bradford | Pennsylvania | 42015 | 15267 | 200 |
2404465 | 2404465 | 2022-04-13 | Lawrence | Tennessee | 47099 | 14278 | 200 |
2399514 | 2399514 | 2022-04-12 | Wapello | Iowa | 19179 | 8969 | 200 |
2400904 | 2400904 | 2022-04-12 | Bradford | Pennsylvania | 42015 | 15239 | 200 |
2396258 | 2396258 | 2022-04-11 | Wapello | Iowa | 19179 | 8969 | 200 |
2397649 | 2397649 | 2022-04-11 | Bradford | Pennsylvania | 42015 | 15204 | 200 |
2393003 | 2393003 | 2022-04-10 | Wapello | Iowa | 19179 | 8969 | 200 |
2394394 | 2394394 | 2022-04-10 | Bradford | Pennsylvania | 42015 | 15194 | 200 |
2389747 | 2389747 | 2022-04-09 | Wapello | Iowa | 19179 | 8969 | 200 |
2391138 | 2391138 | 2022-04-09 | Bradford | Pennsylvania | 42015 | 15187 | 200 |
2386491 | 2386491 | 2022-04-08 | Wapello | Iowa | 19179 | 8969 | 200 |
2387882 | 2387882 | 2022-04-08 | Bradford | Pennsylvania | 42015 | 15176 | 200 |
2383237 | 2383237 | 2022-04-07 | Wapello | Iowa | 19179 | 8969 | 200 |
2384627 | 2384627 | 2022-04-07 | Bradford | Pennsylvania | 42015 | 15162 | 200 |
2379982 | 2379982 | 2022-04-06 | Wapello | Iowa | 19179 | 8969 | 200 |
2381271 | 2381271 | 2022-04-06 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2381372 | 2381372 | 2022-04-06 | Bradford | Pennsylvania | 42015 | 15154 | 200 |
2376181 | 2376181 | 2022-04-05 | Gadsden | Florida | 12039 | 13414 | 200 |
2377792 | 2377792 | 2022-04-05 | Haywood | North Carolina | 37087 | 12932 | 200 |
2378016 | 2378016 | 2022-04-05 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2378117 | 2378117 | 2022-04-05 | Bradford | Pennsylvania | 42015 | 15135 | 200 |
2372783 | 2372783 | 2022-04-04 | El Dorado | California | 6017 | 29944 | 200 |
2372929 | 2372929 | 2022-04-04 | Gadsden | Florida | 12039 | 13414 | 200 |
2374762 | 2374762 | 2022-04-04 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2374863 | 2374863 | 2022-04-04 | Bradford | Pennsylvania | 42015 | 15118 | 200 |
2369530 | 2369530 | 2022-04-03 | El Dorado | California | 6017 | 29944 | 200 |
2369676 | 2369676 | 2022-04-03 | Gadsden | Florida | 12039 | 13414 | 200 |
2371510 | 2371510 | 2022-04-03 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2371611 | 2371611 | 2022-04-03 | Bradford | Pennsylvania | 42015 | 15110 | 200 |
2366277 | 2366277 | 2022-04-02 | El Dorado | California | 6017 | 29944 | 200 |
2366423 | 2366423 | 2022-04-02 | Gadsden | Florida | 12039 | 13414 | 200 |
2368257 | 2368257 | 2022-04-02 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2368358 | 2368358 | 2022-04-02 | Bradford | Pennsylvania | 42015 | 15110 | 200 |
2363024 | 2363024 | 2022-04-01 | El Dorado | California | 6017 | 29944 | 200 |
2363170 | 2363170 | 2022-04-01 | Gadsden | Florida | 12039 | 13414 | 200 |
2365004 | 2365004 | 2022-04-01 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2365105 | 2365105 | 2022-04-01 | Bradford | Pennsylvania | 42015 | 15081 | 200 |
2359770 | 2359770 | 2022-03-31 | El Dorado | California | 6017 | 29934 | 200 |
2359916 | 2359916 | 2022-03-31 | Gadsden | Florida | 12039 | 13414 | 200 |
2361751 | 2361751 | 2022-03-31 | Delaware | Oklahoma | 40041 | 11049 | 200 |
2361852 | 2361852 | 2022-03-31 | Bradford | Pennsylvania | 42015 | 15069 | 200 |
2356516 | 2356516 | 2022-03-30 | El Dorado | California | 6017 | 29913 | 200 |
2356662 | 2356662 | 2022-03-30 | Gadsden | Florida | 12039 | 13414 | 200 |
2358598 | 2358598 | 2022-03-30 | Bradford | Pennsylvania | 42015 | 15056 | 200 |
2353263 | 2353263 | 2022-03-29 | El Dorado | California | 6017 | 29910 | 200 |
2353306 | 2353306 | 2022-03-29 | Tehama | California | 6103 | 14648 | 200 |
2353409 | 2353409 | 2022-03-29 | Gadsden | Florida | 12039 | 13414 | 200 |
2355344 | 2355344 | 2022-03-29 | Bradford | Pennsylvania | 42015 | 15055 | 200 |
2350011 | 2350011 | 2022-03-28 | El Dorado | California | 6017 | 29906 | 200 |
2350054 | 2350054 | 2022-03-28 | Tehama | California | 6103 | 14647 | 200 |
2350157 | 2350157 | 2022-03-28 | Gadsden | Florida | 12039 | 13414 | 200 |
2352091 | 2352091 | 2022-03-28 | Bradford | Pennsylvania | 42015 | 15042 | 200 |
2352764 | 2352764 | 2022-03-28 | Campbell | Virginia | 51031 | 11741 | 200 |
2346758 | 2346758 | 2022-03-27 | El Dorado | California | 6017 | 29881 | 200 |
2346904 | 2346904 | 2022-03-27 | Gadsden | Florida | 12039 | 13414 | 200 |
2348839 | 2348839 | 2022-03-27 | Bradford | Pennsylvania | 42015 | 15038 | 200 |
2343505 | 2343505 | 2022-03-26 | El Dorado | California | 6017 | 29881 | 200 |
2343651 | 2343651 | 2022-03-26 | Gadsden | Florida | 12039 | 13414 | 200 |
2345586 | 2345586 | 2022-03-26 | Bradford | Pennsylvania | 42015 | 15036 | 200 |
2340252 | 2340252 | 2022-03-25 | El Dorado | California | 6017 | 29881 | 200 |
2340398 | 2340398 | 2022-03-25 | Gadsden | Florida | 12039 | 13414 | 200 |
2342333 | 2342333 | 2022-03-25 | Bradford | Pennsylvania | 42015 | 15028 | 200 |
2336999 | 2336999 | 2022-03-24 | El Dorado | California | 6017 | 29877 | 200 |
2337145 | 2337145 | 2022-03-24 | Gadsden | Florida | 12039 | 13396 | 200 |
2339080 | 2339080 | 2022-03-24 | Bradford | Pennsylvania | 42015 | 15020 | 200 |
2333745 | 2333745 | 2022-03-23 | El Dorado | California | 6017 | 29864 | 200 |
2328616 | 2328616 | 2022-03-21 | Newton | Missouri | 29145 | 11707 | 200 |
2325364 | 2325364 | 2022-03-20 | Newton | Missouri | 29145 | 11700 | 200 |
2322110 | 2322110 | 2022-03-19 | Newton | Missouri | 29145 | 11700 | 200 |
2318856 | 2318856 | 2022-03-18 | Newton | Missouri | 29145 | 11700 | 200 |
2315603 | 2315603 | 2022-03-17 | Newton | Missouri | 29145 | 11697 | 200 |
2310945 | 2310945 | 2022-03-16 | Pope | Arkansas | 5115 | 18351 | 200 |
2312350 | 2312350 | 2022-03-16 | Newton | Missouri | 29145 | 11697 | 200 |
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);