ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,051 rows where deaths = 235 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 88
- Georgia 85
- Ohio 57
- North Carolina 56
- Texas 51
- Pennsylvania 50
- Mississippi 45
- Virginia 44
- Indiana 43
- Florida 34
- South Carolina 34
- Alabama 33
- Kentucky 32
- California 28
- Arkansas 26
- Colorado 24
- Louisiana 22
- Missouri 22
- Nebraska 21
- New Jersey 19
- Montana 18
- Oklahoma 18
- Illinois 17
- Wisconsin 17
- Michigan 16
- New York 16
- Kansas 15
- North Dakota 15
- Wyoming 14
- Washington 13
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500111 | 2500111 | 2022-05-13 | Upson | Georgia | 13293 | 7803 | 235 |
2501879 | 2501879 | 2022-05-13 | Jefferson | Pennsylvania | 42065 | 9121 | 235 |
2496853 | 2496853 | 2022-05-12 | Upson | Georgia | 13293 | 7803 | 235 |
2498621 | 2498621 | 2022-05-12 | Jefferson | Pennsylvania | 42065 | 9121 | 235 |
2493595 | 2493595 | 2022-05-11 | Upson | Georgia | 13293 | 7803 | 235 |
2495363 | 2495363 | 2022-05-11 | Jefferson | Pennsylvania | 42065 | 9121 | 235 |
2464719 | 2464719 | 2022-05-02 | Reno | Kansas | 20155 | 18594 | 235 |
2461463 | 2461463 | 2022-05-01 | Reno | Kansas | 20155 | 18594 | 235 |
2461554 | 2461554 | 2022-05-01 | Laurel | Kentucky | 21125 | 20260 | 235 |
2458207 | 2458207 | 2022-04-30 | Reno | Kansas | 20155 | 18594 | 235 |
2458298 | 2458298 | 2022-04-30 | Laurel | Kentucky | 21125 | 20260 | 235 |
2454951 | 2454951 | 2022-04-29 | Reno | Kansas | 20155 | 18594 | 235 |
2455042 | 2455042 | 2022-04-29 | Laurel | Kentucky | 21125 | 20260 | 235 |
2451695 | 2451695 | 2022-04-28 | Reno | Kansas | 20155 | 18585 | 235 |
2451786 | 2451786 | 2022-04-28 | Laurel | Kentucky | 21125 | 20260 | 235 |
2448439 | 2448439 | 2022-04-27 | Reno | Kansas | 20155 | 18585 | 235 |
2448530 | 2448530 | 2022-04-27 | Laurel | Kentucky | 21125 | 20260 | 235 |
2449631 | 2449631 | 2022-04-27 | Carter | Oklahoma | 40019 | 14329 | 235 |
2445274 | 2445274 | 2022-04-26 | Laurel | Kentucky | 21125 | 20260 | 235 |
2446374 | 2446374 | 2022-04-26 | Carter | Oklahoma | 40019 | 14329 | 235 |
2442018 | 2442018 | 2022-04-25 | Laurel | Kentucky | 21125 | 20260 | 235 |
2443119 | 2443119 | 2022-04-25 | Carter | Oklahoma | 40019 | 14329 | 235 |
2439863 | 2439863 | 2022-04-24 | Carter | Oklahoma | 40019 | 14329 | 235 |
2436607 | 2436607 | 2022-04-23 | Carter | Oklahoma | 40019 | 14329 | 235 |
2433351 | 2433351 | 2022-04-22 | Carter | Oklahoma | 40019 | 14329 | 235 |
2430095 | 2430095 | 2022-04-21 | Carter | Oklahoma | 40019 | 14329 | 235 |
2422610 | 2422610 | 2022-04-19 | Kennebec | Maine | 23011 | 23302 | 235 |
2423953 | 2423953 | 2022-04-19 | Bedford | Tennessee | 47003 | 14954 | 235 |
2419354 | 2419354 | 2022-04-18 | Kennebec | Maine | 23011 | 23302 | 235 |
2420697 | 2420697 | 2022-04-18 | Bedford | Tennessee | 47003 | 14954 | 235 |
2416098 | 2416098 | 2022-04-17 | Kennebec | Maine | 23011 | 23302 | 235 |
2417441 | 2417441 | 2022-04-17 | Bedford | Tennessee | 47003 | 14954 | 235 |
2412842 | 2412842 | 2022-04-16 | Kennebec | Maine | 23011 | 23302 | 235 |
2414185 | 2414185 | 2022-04-16 | Bedford | Tennessee | 47003 | 14954 | 235 |
2409586 | 2409586 | 2022-04-15 | Kennebec | Maine | 23011 | 23269 | 235 |
2410929 | 2410929 | 2022-04-15 | Bedford | Tennessee | 47003 | 14954 | 235 |
2406330 | 2406330 | 2022-04-14 | Kennebec | Maine | 23011 | 23223 | 235 |
2407673 | 2407673 | 2022-04-14 | Bedford | Tennessee | 47003 | 14954 | 235 |
2403074 | 2403074 | 2022-04-13 | Kennebec | Maine | 23011 | 23191 | 235 |
2404417 | 2404417 | 2022-04-13 | Bedford | Tennessee | 47003 | 14954 | 235 |
2399820 | 2399820 | 2022-04-12 | Kennebec | Maine | 23011 | 23113 | 235 |
2401569 | 2401569 | 2022-04-12 | Bedford | Virginia | 51019 | 16933 | 235 |
2378435 | 2378435 | 2022-04-05 | Monroe | Tennessee | 47123 | 14490 | 235 |
2373125 | 2373125 | 2022-04-04 | Walker | Georgia | 13295 | 16810 | 235 |
2375181 | 2375181 | 2022-04-04 | Monroe | Tennessee | 47123 | 14490 | 235 |
2375216 | 2375216 | 2022-04-04 | Anderson | Texas | 48001 | 9530 | 235 |
2371929 | 2371929 | 2022-04-03 | Monroe | Tennessee | 47123 | 14490 | 235 |
2371964 | 2371964 | 2022-04-03 | Anderson | Texas | 48001 | 9530 | 235 |
2368676 | 2368676 | 2022-04-02 | Monroe | Tennessee | 47123 | 14490 | 235 |
2368711 | 2368711 | 2022-04-02 | Anderson | Texas | 48001 | 9530 | 235 |
2368721 | 2368721 | 2022-04-02 | Bastrop | Texas | 48021 | 21703 | 235 |
2365423 | 2365423 | 2022-04-01 | Monroe | Tennessee | 47123 | 14490 | 235 |
2365458 | 2365458 | 2022-04-01 | Anderson | Texas | 48001 | 9529 | 235 |
2365468 | 2365468 | 2022-04-01 | Bastrop | Texas | 48021 | 21700 | 235 |
2360556 | 2360556 | 2022-03-31 | Saline | Kansas | 20169 | 14106 | 235 |
2362170 | 2362170 | 2022-03-31 | Monroe | Tennessee | 47123 | 14490 | 235 |
2362205 | 2362205 | 2022-03-31 | Anderson | Texas | 48001 | 9529 | 235 |
2362215 | 2362215 | 2022-03-31 | Bastrop | Texas | 48021 | 21686 | 235 |
2357302 | 2357302 | 2022-03-30 | Saline | Kansas | 20169 | 14106 | 235 |
2358916 | 2358916 | 2022-03-30 | Monroe | Tennessee | 47123 | 14490 | 235 |
2358951 | 2358951 | 2022-03-30 | Anderson | Texas | 48001 | 9526 | 235 |
2354049 | 2354049 | 2022-03-29 | Saline | Kansas | 20169 | 14106 | 235 |
2355662 | 2355662 | 2022-03-29 | Monroe | Tennessee | 47123 | 14482 | 235 |
2355697 | 2355697 | 2022-03-29 | Anderson | Texas | 48001 | 9525 | 235 |
2349820 | 2349820 | 2022-03-28 | Blount | Alabama | 1009 | 14898 | 235 |
2349851 | 2349851 | 2022-03-28 | Jackson | Alabama | 1071 | 15019 | 235 |
2350797 | 2350797 | 2022-03-28 | Saline | Kansas | 20169 | 14108 | 235 |
2352409 | 2352409 | 2022-03-28 | Monroe | Tennessee | 47123 | 14482 | 235 |
2352444 | 2352444 | 2022-03-28 | Anderson | Texas | 48001 | 9525 | 235 |
2347544 | 2347544 | 2022-03-27 | Saline | Kansas | 20169 | 14108 | 235 |
2349157 | 2349157 | 2022-03-27 | Monroe | Tennessee | 47123 | 14482 | 235 |
2349192 | 2349192 | 2022-03-27 | Anderson | Texas | 48001 | 9525 | 235 |
2344291 | 2344291 | 2022-03-26 | Saline | Kansas | 20169 | 14108 | 235 |
2345904 | 2345904 | 2022-03-26 | Monroe | Tennessee | 47123 | 14482 | 235 |
2345939 | 2345939 | 2022-03-26 | Anderson | Texas | 48001 | 9525 | 235 |
2341038 | 2341038 | 2022-03-25 | Saline | Kansas | 20169 | 14108 | 235 |
2342651 | 2342651 | 2022-03-25 | Monroe | Tennessee | 47123 | 14482 | 235 |
2337551 | 2337551 | 2022-03-24 | Kosciusko | Indiana | 18085 | 19733 | 235 |
2339398 | 2339398 | 2022-03-24 | Monroe | Tennessee | 47123 | 14482 | 235 |
2339989 | 2339989 | 2022-03-24 | Jefferson | Wisconsin | 55055 | 21398 | 235 |
2334297 | 2334297 | 2022-03-23 | Kosciusko | Indiana | 18085 | 19732 | 235 |
2336144 | 2336144 | 2022-03-23 | Monroe | Tennessee | 47123 | 14482 | 235 |
2331043 | 2331043 | 2022-03-22 | Kosciusko | Indiana | 18085 | 19731 | 235 |
2332074 | 2332074 | 2022-03-22 | Nye | Nevada | 32023 | 7441 | 235 |
2327791 | 2327791 | 2022-03-21 | Kosciusko | Indiana | 18085 | 19730 | 235 |
2328821 | 2328821 | 2022-03-21 | Nye | Nevada | 32023 | 7441 | 235 |
2324538 | 2324538 | 2022-03-20 | Kosciusko | Indiana | 18085 | 19724 | 235 |
2325250 | 2325250 | 2022-03-20 | Lowndes | Mississippi | 28087 | 17474 | 235 |
2325569 | 2325569 | 2022-03-20 | Nye | Nevada | 32023 | 7441 | 235 |
2321284 | 2321284 | 2022-03-19 | Kosciusko | Indiana | 18085 | 19724 | 235 |
2321996 | 2321996 | 2022-03-19 | Lowndes | Mississippi | 28087 | 17474 | 235 |
2322315 | 2322315 | 2022-03-19 | Nye | Nevada | 32023 | 7441 | 235 |
2318030 | 2318030 | 2022-03-18 | Kosciusko | Indiana | 18085 | 19724 | 235 |
2318742 | 2318742 | 2022-03-18 | Lowndes | Mississippi | 28087 | 17474 | 235 |
2319061 | 2319061 | 2022-03-18 | Nye | Nevada | 32023 | 7441 | 235 |
2314777 | 2314777 | 2022-03-17 | Kosciusko | Indiana | 18085 | 19721 | 235 |
2315489 | 2315489 | 2022-03-17 | Lowndes | Mississippi | 28087 | 17474 | 235 |
2315808 | 2315808 | 2022-03-17 | Nye | Nevada | 32023 | 7441 | 235 |
2311202 | 2311202 | 2022-03-16 | Colquitt | Georgia | 13071 | 11620 | 235 |
2311379 | 2311379 | 2022-03-16 | Adams | Illinois | 17001 | 22258 | 235 |
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);