ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
634 rows where deaths = 319 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 64
- Alabama 35
- Florida 35
- North Carolina 35
- Oklahoma 30
- Pennsylvania 30
- Texas 28
- Colorado 27
- Indiana 27
- Wisconsin 22
- Louisiana 21
- Illinois 20
- Ohio 20
- Michigan 18
- South Carolina 18
- Virginia 17
- Tennessee 15
- Iowa 13
- Minnesota 12
- Kentucky 11
- Maryland 11
- New Mexico 11
- California 10
- New Jersey 9
- Mississippi 8
- Montana 8
- New York 8
- Arizona 7
- Arkansas 7
- Idaho 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500450 | 2500450 | 2022-05-13 | Pottawattamie | Iowa | 19155 | 24382 | 319 |
2502796 | 2502796 | 2022-05-13 | Sheboygan | Wisconsin | 55117 | 33090 | 319 |
2497192 | 2497192 | 2022-05-12 | Pottawattamie | Iowa | 19155 | 24382 | 319 |
2493934 | 2493934 | 2022-05-11 | Pottawattamie | Iowa | 19155 | 24382 | 319 |
2490247 | 2490247 | 2022-05-10 | Fayette | Georgia | 13113 | 22691 | 319 |
2493022 | 2493022 | 2022-05-10 | Sheboygan | Wisconsin | 55117 | 32963 | 319 |
2486990 | 2486990 | 2022-05-09 | Fayette | Georgia | 13113 | 22691 | 319 |
2483732 | 2483732 | 2022-05-08 | Fayette | Georgia | 13113 | 22689 | 319 |
2480474 | 2480474 | 2022-05-07 | Fayette | Georgia | 13113 | 22689 | 319 |
2477216 | 2477216 | 2022-05-06 | Fayette | Georgia | 13113 | 22689 | 319 |
2473958 | 2473958 | 2022-05-05 | Fayette | Georgia | 13113 | 22689 | 319 |
2470701 | 2470701 | 2022-05-04 | Fayette | Georgia | 13113 | 22689 | 319 |
2472364 | 2472364 | 2022-05-04 | Jefferson | Ohio | 39081 | 14777 | 319 |
2467445 | 2467445 | 2022-05-03 | Fayette | Georgia | 13113 | 22592 | 319 |
2468972 | 2468972 | 2022-05-03 | Moore | North Carolina | 37125 | 24350 | 319 |
2469108 | 2469108 | 2022-05-03 | Jefferson | Ohio | 39081 | 14777 | 319 |
2464190 | 2464190 | 2022-05-02 | Fayette | Georgia | 13113 | 22592 | 319 |
2465716 | 2465716 | 2022-05-02 | Moore | North Carolina | 37125 | 24350 | 319 |
2465852 | 2465852 | 2022-05-02 | Jefferson | Ohio | 39081 | 14777 | 319 |
2460934 | 2460934 | 2022-05-01 | Fayette | Georgia | 13113 | 22592 | 319 |
2462461 | 2462461 | 2022-05-01 | Moore | North Carolina | 37125 | 24350 | 319 |
2462597 | 2462597 | 2022-05-01 | Jefferson | Ohio | 39081 | 14777 | 319 |
2457678 | 2457678 | 2022-04-30 | Fayette | Georgia | 13113 | 22592 | 319 |
2459205 | 2459205 | 2022-04-30 | Moore | North Carolina | 37125 | 24350 | 319 |
2459341 | 2459341 | 2022-04-30 | Jefferson | Ohio | 39081 | 14777 | 319 |
2454422 | 2454422 | 2022-04-29 | Fayette | Georgia | 13113 | 22592 | 319 |
2455949 | 2455949 | 2022-04-29 | Moore | North Carolina | 37125 | 24350 | 319 |
2456085 | 2456085 | 2022-04-29 | Jefferson | Ohio | 39081 | 14777 | 319 |
2451166 | 2451166 | 2022-04-28 | Fayette | Georgia | 13113 | 22592 | 319 |
2452693 | 2452693 | 2022-04-28 | Moore | North Carolina | 37125 | 24350 | 319 |
2452829 | 2452829 | 2022-04-28 | Jefferson | Ohio | 39081 | 14777 | 319 |
2447910 | 2447910 | 2022-04-27 | Fayette | Georgia | 13113 | 22592 | 319 |
2449437 | 2449437 | 2022-04-27 | Moore | North Carolina | 37125 | 24350 | 319 |
2421928 | 2421928 | 2022-04-19 | Rockdale | Georgia | 13247 | 18526 | 319 |
2418672 | 2418672 | 2022-04-18 | Rockdale | Georgia | 13247 | 18526 | 319 |
2415416 | 2415416 | 2022-04-17 | Rockdale | Georgia | 13247 | 18526 | 319 |
2412160 | 2412160 | 2022-04-16 | Rockdale | Georgia | 13247 | 18526 | 319 |
2408904 | 2408904 | 2022-04-15 | Rockdale | Georgia | 13247 | 18526 | 319 |
2405648 | 2405648 | 2022-04-14 | Rockdale | Georgia | 13247 | 18521 | 319 |
2402393 | 2402393 | 2022-04-13 | Rockdale | Georgia | 13247 | 18510 | 319 |
2399138 | 2399138 | 2022-04-12 | Rockdale | Georgia | 13247 | 18503 | 319 |
2395883 | 2395883 | 2022-04-11 | Rockdale | Georgia | 13247 | 18499 | 319 |
2397191 | 2397191 | 2022-04-11 | Chaves | New Mexico | 35005 | 21708 | 319 |
2392627 | 2392627 | 2022-04-10 | Rockdale | Georgia | 13247 | 18457 | 319 |
2393936 | 2393936 | 2022-04-10 | Chaves | New Mexico | 35005 | 21707 | 319 |
2389371 | 2389371 | 2022-04-09 | Rockdale | Georgia | 13247 | 18457 | 319 |
2390680 | 2390680 | 2022-04-09 | Chaves | New Mexico | 35005 | 21707 | 319 |
2386116 | 2386116 | 2022-04-08 | Rockdale | Georgia | 13247 | 18457 | 319 |
2387424 | 2387424 | 2022-04-08 | Chaves | New Mexico | 35005 | 21707 | 319 |
2385378 | 2385378 | 2022-04-07 | Portsmouth city | Virginia | 51740 | 20827 | 319 |
2359308 | 2359308 | 2022-03-30 | Hampton city | Virginia | 51650 | 27516 | 319 |
2356054 | 2356054 | 2022-03-29 | Hampton city | Virginia | 51650 | 27513 | 319 |
2352801 | 2352801 | 2022-03-28 | Hampton city | Virginia | 51650 | 27504 | 319 |
2348812 | 2348812 | 2022-03-27 | Josephine | Oregon | 41033 | 16281 | 319 |
2349549 | 2349549 | 2022-03-27 | Hampton city | Virginia | 51650 | 27490 | 319 |
2345559 | 2345559 | 2022-03-26 | Josephine | Oregon | 41033 | 16281 | 319 |
2346296 | 2346296 | 2022-03-26 | Hampton city | Virginia | 51650 | 27490 | 319 |
2342306 | 2342306 | 2022-03-25 | Josephine | Oregon | 41033 | 16281 | 319 |
2343043 | 2343043 | 2022-03-25 | Hampton city | Virginia | 51650 | 27490 | 319 |
2332846 | 2332846 | 2022-03-22 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2328240 | 2328240 | 2022-03-21 | Penobscot | Maine | 23019 | 27021 | 319 |
2329593 | 2329593 | 2022-03-21 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2324987 | 2324987 | 2022-03-20 | Penobscot | Maine | 23019 | 27021 | 319 |
2326341 | 2326341 | 2022-03-20 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2321733 | 2321733 | 2022-03-19 | Penobscot | Maine | 23019 | 27021 | 319 |
2322367 | 2322367 | 2022-03-19 | Lea | New Mexico | 35025 | 20103 | 319 |
2323088 | 2323088 | 2022-03-19 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2318479 | 2318479 | 2022-03-18 | Penobscot | Maine | 23019 | 26992 | 319 |
2319113 | 2319113 | 2022-03-18 | Lea | New Mexico | 35025 | 20103 | 319 |
2319834 | 2319834 | 2022-03-18 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2315226 | 2315226 | 2022-03-17 | Penobscot | Maine | 23019 | 27034 | 319 |
2315860 | 2315860 | 2022-03-17 | Lea | New Mexico | 35025 | 20103 | 319 |
2316580 | 2316580 | 2022-03-17 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2311973 | 2311973 | 2022-03-16 | Penobscot | Maine | 23019 | 27010 | 319 |
2312399 | 2312399 | 2022-03-16 | Cascade | Montana | 30013 | 25063 | 319 |
2312607 | 2312607 | 2022-03-16 | Lea | New Mexico | 35025 | 20101 | 319 |
2312950 | 2312950 | 2022-03-16 | Creek | Oklahoma | 40037 | 18079 | 319 |
2313327 | 2313327 | 2022-03-16 | Cumberland | Tennessee | 47035 | 16061 | 319 |
2308813 | 2308813 | 2022-03-15 | Lenawee | Michigan | 26091 | 25798 | 319 |
2309146 | 2309146 | 2022-03-15 | Cascade | Montana | 30013 | 25058 | 319 |
2309354 | 2309354 | 2022-03-15 | Lea | New Mexico | 35025 | 20098 | 319 |
2309697 | 2309697 | 2022-03-15 | Creek | Oklahoma | 40037 | 18079 | 319 |
2305562 | 2305562 | 2022-03-14 | Lenawee | Michigan | 26091 | 25798 | 319 |
2305894 | 2305894 | 2022-03-14 | Cascade | Montana | 30013 | 25051 | 319 |
2306101 | 2306101 | 2022-03-14 | Lea | New Mexico | 35025 | 20097 | 319 |
2306444 | 2306444 | 2022-03-14 | Creek | Oklahoma | 40037 | 18079 | 319 |
2307442 | 2307442 | 2022-03-14 | Dodge | Wisconsin | 55027 | 26952 | 319 |
2302310 | 2302310 | 2022-03-13 | Lenawee | Michigan | 26091 | 25780 | 319 |
2302643 | 2302643 | 2022-03-13 | Cascade | Montana | 30013 | 25044 | 319 |
2303193 | 2303193 | 2022-03-13 | Creek | Oklahoma | 40037 | 18079 | 319 |
2304191 | 2304191 | 2022-03-13 | Dodge | Wisconsin | 55027 | 26945 | 319 |
2297941 | 2297941 | 2022-03-12 | Saline | Arkansas | 5125 | 30646 | 319 |
2299058 | 2299058 | 2022-03-12 | Lenawee | Michigan | 26091 | 25780 | 319 |
2299391 | 2299391 | 2022-03-12 | Cascade | Montana | 30013 | 25044 | 319 |
2299941 | 2299941 | 2022-03-12 | Creek | Oklahoma | 40037 | 18079 | 319 |
2300939 | 2300939 | 2022-03-12 | Dodge | Wisconsin | 55027 | 26945 | 319 |
2294689 | 2294689 | 2022-03-11 | Saline | Arkansas | 5125 | 30613 | 319 |
2295806 | 2295806 | 2022-03-11 | Lenawee | Michigan | 26091 | 25780 | 319 |
2296139 | 2296139 | 2022-03-11 | Cascade | Montana | 30013 | 25044 | 319 |
2296689 | 2296689 | 2022-03-11 | Creek | Oklahoma | 40037 | 18079 | 319 |
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);