ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,079 rows where deaths = 242 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 110
- California 91
- Texas 67
- North Carolina 58
- New Jersey 54
- Pennsylvania 54
- Mississippi 48
- Virginia 43
- Alabama 38
- Wisconsin 37
- Tennessee 35
- Ohio 29
- Florida 27
- Arkansas 26
- South Carolina 26
- Indiana 24
- Michigan 24
- Kentucky 21
- Oklahoma 21
- Illinois 19
- Colorado 18
- Louisiana 16
- New Mexico 15
- Oregon 14
- Washington 14
- Minnesota 13
- Missouri 13
- Nebraska 13
- Iowa 11
- New York 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500641 | 2500641 | 2022-05-13 | Laurel | Kentucky | 21125 | 20315 | 242 |
2497383 | 2497383 | 2022-05-12 | Laurel | Kentucky | 21125 | 20315 | 242 |
2494125 | 2494125 | 2022-05-11 | Laurel | Kentucky | 21125 | 20315 | 242 |
2490867 | 2490867 | 2022-05-10 | Laurel | Kentucky | 21125 | 20315 | 242 |
2492991 | 2492991 | 2022-05-10 | Jefferson | Wisconsin | 55055 | 21923 | 242 |
2487610 | 2487610 | 2022-05-09 | Laurel | Kentucky | 21125 | 20315 | 242 |
2489733 | 2489733 | 2022-05-09 | Jefferson | Wisconsin | 55055 | 21904 | 242 |
2464726 | 2464726 | 2022-05-02 | Saline | Kansas | 20169 | 14124 | 242 |
2461470 | 2461470 | 2022-05-01 | Saline | Kansas | 20169 | 14124 | 242 |
2458214 | 2458214 | 2022-04-30 | Saline | Kansas | 20169 | 14124 | 242 |
2454958 | 2454958 | 2022-04-29 | Saline | Kansas | 20169 | 14124 | 242 |
2451702 | 2451702 | 2022-04-28 | Saline | Kansas | 20169 | 14118 | 242 |
2448446 | 2448446 | 2022-04-27 | Saline | Kansas | 20169 | 14118 | 242 |
2444633 | 2444633 | 2022-04-26 | Colquitt | Georgia | 13071 | 11716 | 242 |
2446148 | 2446148 | 2022-04-26 | Duplin | North Carolina | 37061 | 16839 | 242 |
2441377 | 2441377 | 2022-04-25 | Colquitt | Georgia | 13071 | 11716 | 242 |
2442893 | 2442893 | 2022-04-25 | Duplin | North Carolina | 37061 | 16839 | 242 |
2438121 | 2438121 | 2022-04-24 | Colquitt | Georgia | 13071 | 11712 | 242 |
2439637 | 2439637 | 2022-04-24 | Duplin | North Carolina | 37061 | 16839 | 242 |
2434865 | 2434865 | 2022-04-23 | Colquitt | Georgia | 13071 | 11712 | 242 |
2436381 | 2436381 | 2022-04-23 | Duplin | North Carolina | 37061 | 16839 | 242 |
2431609 | 2431609 | 2022-04-22 | Colquitt | Georgia | 13071 | 11712 | 242 |
2433125 | 2433125 | 2022-04-22 | Duplin | North Carolina | 37061 | 16839 | 242 |
2428353 | 2428353 | 2022-04-21 | Colquitt | Georgia | 13071 | 11712 | 242 |
2429869 | 2429869 | 2022-04-21 | Duplin | North Carolina | 37061 | 16839 | 242 |
2425097 | 2425097 | 2022-04-20 | Colquitt | Georgia | 13071 | 11712 | 242 |
2426613 | 2426613 | 2022-04-20 | Duplin | North Carolina | 37061 | 16839 | 242 |
2421841 | 2421841 | 2022-04-19 | Colquitt | Georgia | 13071 | 11715 | 242 |
2423357 | 2423357 | 2022-04-19 | Duplin | North Carolina | 37061 | 16832 | 242 |
2418164 | 2418164 | 2022-04-18 | Blount | Alabama | 1009 | 14959 | 242 |
2418585 | 2418585 | 2022-04-18 | Colquitt | Georgia | 13071 | 11715 | 242 |
2420100 | 2420100 | 2022-04-18 | Duplin | North Carolina | 37061 | 16832 | 242 |
2414908 | 2414908 | 2022-04-17 | Blount | Alabama | 1009 | 14959 | 242 |
2415329 | 2415329 | 2022-04-17 | Colquitt | Georgia | 13071 | 11719 | 242 |
2416845 | 2416845 | 2022-04-17 | Duplin | North Carolina | 37061 | 16832 | 242 |
2411652 | 2411652 | 2022-04-16 | Blount | Alabama | 1009 | 14959 | 242 |
2412073 | 2412073 | 2022-04-16 | Colquitt | Georgia | 13071 | 11719 | 242 |
2413589 | 2413589 | 2022-04-16 | Duplin | North Carolina | 37061 | 16832 | 242 |
2408396 | 2408396 | 2022-04-15 | Blount | Alabama | 1009 | 14959 | 242 |
2408817 | 2408817 | 2022-04-15 | Colquitt | Georgia | 13071 | 11719 | 242 |
2410333 | 2410333 | 2022-04-15 | Duplin | North Carolina | 37061 | 16832 | 242 |
2405561 | 2405561 | 2022-04-14 | Colquitt | Georgia | 13071 | 11720 | 242 |
2407077 | 2407077 | 2022-04-14 | Duplin | North Carolina | 37061 | 16832 | 242 |
2401904 | 2401904 | 2022-04-13 | Dallas | Alabama | 1047 | 8395 | 242 |
2402306 | 2402306 | 2022-04-13 | Colquitt | Georgia | 13071 | 11722 | 242 |
2403821 | 2403821 | 2022-04-13 | Duplin | North Carolina | 37061 | 16832 | 242 |
2403992 | 2403992 | 2022-04-13 | Lawrence | Ohio | 39087 | 17855 | 242 |
2404063 | 2404063 | 2022-04-13 | Grady | Oklahoma | 40051 | 13700 | 242 |
2398649 | 2398649 | 2022-04-12 | Dallas | Alabama | 1047 | 8395 | 242 |
2399051 | 2399051 | 2022-04-12 | Colquitt | Georgia | 13071 | 11723 | 242 |
2400737 | 2400737 | 2022-04-12 | Lawrence | Ohio | 39087 | 17855 | 242 |
2400808 | 2400808 | 2022-04-12 | Grady | Oklahoma | 40051 | 13700 | 242 |
2395394 | 2395394 | 2022-04-11 | Dallas | Alabama | 1047 | 8392 | 242 |
2395796 | 2395796 | 2022-04-11 | Colquitt | Georgia | 13071 | 11724 | 242 |
2397482 | 2397482 | 2022-04-11 | Lawrence | Ohio | 39087 | 17855 | 242 |
2397553 | 2397553 | 2022-04-11 | Grady | Oklahoma | 40051 | 13700 | 242 |
2392138 | 2392138 | 2022-04-10 | Dallas | Alabama | 1047 | 8392 | 242 |
2392540 | 2392540 | 2022-04-10 | Colquitt | Georgia | 13071 | 11725 | 242 |
2394227 | 2394227 | 2022-04-10 | Lawrence | Ohio | 39087 | 17855 | 242 |
2394298 | 2394298 | 2022-04-10 | Grady | Oklahoma | 40051 | 13700 | 242 |
2388882 | 2388882 | 2022-04-09 | Dallas | Alabama | 1047 | 8392 | 242 |
2389284 | 2389284 | 2022-04-09 | Colquitt | Georgia | 13071 | 11725 | 242 |
2390971 | 2390971 | 2022-04-09 | Lawrence | Ohio | 39087 | 17855 | 242 |
2391042 | 2391042 | 2022-04-09 | Grady | Oklahoma | 40051 | 13700 | 242 |
2385627 | 2385627 | 2022-04-08 | Dallas | Alabama | 1047 | 8392 | 242 |
2386029 | 2386029 | 2022-04-08 | Colquitt | Georgia | 13071 | 11725 | 242 |
2387715 | 2387715 | 2022-04-08 | Lawrence | Ohio | 39087 | 17855 | 242 |
2387786 | 2387786 | 2022-04-08 | Grady | Oklahoma | 40051 | 13700 | 242 |
2382372 | 2382372 | 2022-04-07 | Dallas | Alabama | 1047 | 8390 | 242 |
2382774 | 2382774 | 2022-04-07 | Colquitt | Georgia | 13071 | 11724 | 242 |
2384460 | 2384460 | 2022-04-07 | Lawrence | Ohio | 39087 | 17855 | 242 |
2384531 | 2384531 | 2022-04-07 | Grady | Oklahoma | 40051 | 13700 | 242 |
2379117 | 2379117 | 2022-04-06 | Dallas | Alabama | 1047 | 8390 | 242 |
2381276 | 2381276 | 2022-04-06 | Grady | Oklahoma | 40051 | 13690 | 242 |
2375863 | 2375863 | 2022-04-05 | Dallas | Alabama | 1047 | 8387 | 242 |
2378021 | 2378021 | 2022-04-05 | Grady | Oklahoma | 40051 | 13690 | 242 |
2372611 | 2372611 | 2022-04-04 | Dallas | Alabama | 1047 | 8386 | 242 |
2374767 | 2374767 | 2022-04-04 | Grady | Oklahoma | 40051 | 13690 | 242 |
2369358 | 2369358 | 2022-04-03 | Dallas | Alabama | 1047 | 8385 | 242 |
2371515 | 2371515 | 2022-04-03 | Grady | Oklahoma | 40051 | 13690 | 242 |
2366105 | 2366105 | 2022-04-02 | Dallas | Alabama | 1047 | 8385 | 242 |
2368262 | 2368262 | 2022-04-02 | Grady | Oklahoma | 40051 | 13690 | 242 |
2362852 | 2362852 | 2022-04-01 | Dallas | Alabama | 1047 | 8385 | 242 |
2365009 | 2365009 | 2022-04-01 | Grady | Oklahoma | 40051 | 13690 | 242 |
2359598 | 2359598 | 2022-03-31 | Dallas | Alabama | 1047 | 8384 | 242 |
2361756 | 2361756 | 2022-03-31 | Grady | Oklahoma | 40051 | 13690 | 242 |
2362552 | 2362552 | 2022-03-31 | Frederick | Virginia | 51069 | 20550 | 242 |
2356344 | 2356344 | 2022-03-30 | Dallas | Alabama | 1047 | 8382 | 242 |
2358621 | 2358621 | 2022-03-30 | Huntingdon | Pennsylvania | 42061 | 11484 | 242 |
2359298 | 2359298 | 2022-03-30 | Frederick | Virginia | 51069 | 20546 | 242 |
2353091 | 2353091 | 2022-03-29 | Dallas | Alabama | 1047 | 8382 | 242 |
2353221 | 2353221 | 2022-03-29 | Lonoke | Arkansas | 5085 | 19842 | 242 |
2355355 | 2355355 | 2022-03-29 | Columbia | Pennsylvania | 42037 | 15017 | 242 |
2355367 | 2355367 | 2022-03-29 | Huntingdon | Pennsylvania | 42061 | 11483 | 242 |
2349839 | 2349839 | 2022-03-28 | Dallas | Alabama | 1047 | 8382 | 242 |
2349969 | 2349969 | 2022-03-28 | Lonoke | Arkansas | 5085 | 19842 | 242 |
2352102 | 2352102 | 2022-03-28 | Columbia | Pennsylvania | 42037 | 15011 | 242 |
2352114 | 2352114 | 2022-03-28 | Huntingdon | Pennsylvania | 42061 | 11481 | 242 |
2346716 | 2346716 | 2022-03-27 | Lonoke | Arkansas | 5085 | 19842 | 242 |
2348850 | 2348850 | 2022-03-27 | Columbia | Pennsylvania | 42037 | 15009 | 242 |
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);