ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
670 rows where deaths = 317 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 52
- Ohio 50
- Texas 48
- Louisiana 41
- North Carolina 35
- Missouri 33
- Michigan 28
- Mississippi 28
- South Carolina 27
- Georgia 25
- California 24
- Florida 24
- Alabama 21
- Wisconsin 21
- Tennessee 20
- Illinois 18
- Kentucky 18
- Indiana 17
- Virginia 14
- Iowa 12
- Washington 12
- Arizona 11
- Oregon 10
- New Jersey 9
- New York 9
- Colorado 8
- Delaware 7
- Massachusetts 6
- West Virginia 6
- Maryland 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501124 | 2501124 | 2022-05-13 | Jasper | Missouri | 29097 | 20879 | 317 |
2497828 | 2497828 | 2022-05-12 | Buchanan | Missouri | 29021 | 24863 | 317 |
2497866 | 2497866 | 2022-05-12 | Jasper | Missouri | 29097 | 20847 | 317 |
2494570 | 2494570 | 2022-05-11 | Buchanan | Missouri | 29021 | 24863 | 317 |
2494608 | 2494608 | 2022-05-11 | Jasper | Missouri | 29097 | 20847 | 317 |
2490676 | 2490676 | 2022-05-10 | Pottawattamie | Iowa | 19155 | 24347 | 317 |
2491312 | 2491312 | 2022-05-10 | Buchanan | Missouri | 29021 | 24863 | 317 |
2491350 | 2491350 | 2022-05-10 | Jasper | Missouri | 29097 | 20847 | 317 |
2487419 | 2487419 | 2022-05-09 | Pottawattamie | Iowa | 19155 | 24347 | 317 |
2488054 | 2488054 | 2022-05-09 | Buchanan | Missouri | 29021 | 24863 | 317 |
2488092 | 2488092 | 2022-05-09 | Jasper | Missouri | 29097 | 20847 | 317 |
2484161 | 2484161 | 2022-05-08 | Pottawattamie | Iowa | 19155 | 24347 | 317 |
2484797 | 2484797 | 2022-05-08 | Buchanan | Missouri | 29021 | 24863 | 317 |
2484835 | 2484835 | 2022-05-08 | Jasper | Missouri | 29097 | 20847 | 317 |
2480903 | 2480903 | 2022-05-07 | Pottawattamie | Iowa | 19155 | 24347 | 317 |
2481539 | 2481539 | 2022-05-07 | Buchanan | Missouri | 29021 | 24863 | 317 |
2481577 | 2481577 | 2022-05-07 | Jasper | Missouri | 29097 | 20847 | 317 |
2477645 | 2477645 | 2022-05-06 | Pottawattamie | Iowa | 19155 | 24347 | 317 |
2478281 | 2478281 | 2022-05-06 | Buchanan | Missouri | 29021 | 24863 | 317 |
2478319 | 2478319 | 2022-05-06 | Jasper | Missouri | 29097 | 20847 | 317 |
2474387 | 2474387 | 2022-05-05 | Pottawattamie | Iowa | 19155 | 24347 | 317 |
2475023 | 2475023 | 2022-05-05 | Buchanan | Missouri | 29021 | 24863 | 317 |
2471130 | 2471130 | 2022-05-04 | Pottawattamie | Iowa | 19155 | 24347 | 317 |
2470218 | 2470218 | 2022-05-03 | Sheboygan | Wisconsin | 55117 | 32808 | 317 |
2466962 | 2466962 | 2022-05-02 | Sheboygan | Wisconsin | 55117 | 32804 | 317 |
2463707 | 2463707 | 2022-05-01 | Sheboygan | Wisconsin | 55117 | 32747 | 317 |
2460451 | 2460451 | 2022-04-30 | Sheboygan | Wisconsin | 55117 | 32747 | 317 |
2457195 | 2457195 | 2022-04-29 | Sheboygan | Wisconsin | 55117 | 32747 | 317 |
2453939 | 2453939 | 2022-04-28 | Sheboygan | Wisconsin | 55117 | 32723 | 317 |
2444171 | 2444171 | 2022-04-25 | Sheboygan | Wisconsin | 55117 | 32635 | 317 |
2440915 | 2440915 | 2022-04-24 | Sheboygan | Wisconsin | 55117 | 32593 | 317 |
2437659 | 2437659 | 2022-04-23 | Sheboygan | Wisconsin | 55117 | 32593 | 317 |
2434403 | 2434403 | 2022-04-22 | Sheboygan | Wisconsin | 55117 | 32593 | 317 |
2431147 | 2431147 | 2022-04-21 | Sheboygan | Wisconsin | 55117 | 32579 | 317 |
2426781 | 2426781 | 2022-04-20 | Jefferson | Ohio | 39081 | 14710 | 317 |
2427891 | 2427891 | 2022-04-20 | Sheboygan | Wisconsin | 55117 | 32561 | 317 |
2423525 | 2423525 | 2022-04-19 | Jefferson | Ohio | 39081 | 14710 | 317 |
2420268 | 2420268 | 2022-04-18 | Jefferson | Ohio | 39081 | 14710 | 317 |
2420451 | 2420451 | 2022-04-18 | Crawford | Pennsylvania | 42039 | 19803 | 317 |
2417013 | 2417013 | 2022-04-17 | Jefferson | Ohio | 39081 | 14710 | 317 |
2417195 | 2417195 | 2022-04-17 | Crawford | Pennsylvania | 42039 | 19803 | 317 |
2413757 | 2413757 | 2022-04-16 | Jefferson | Ohio | 39081 | 14710 | 317 |
2413939 | 2413939 | 2022-04-16 | Crawford | Pennsylvania | 42039 | 19802 | 317 |
2410501 | 2410501 | 2022-04-15 | Jefferson | Ohio | 39081 | 14710 | 317 |
2410683 | 2410683 | 2022-04-15 | Crawford | Pennsylvania | 42039 | 19796 | 317 |
2405582 | 2405582 | 2022-04-14 | Fayette | Georgia | 13113 | 22459 | 317 |
2407245 | 2407245 | 2022-04-14 | Jefferson | Ohio | 39081 | 14710 | 317 |
2403989 | 2403989 | 2022-04-13 | Jefferson | Ohio | 39081 | 14700 | 317 |
2400734 | 2400734 | 2022-04-12 | Jefferson | Ohio | 39081 | 14700 | 317 |
2397479 | 2397479 | 2022-04-11 | Jefferson | Ohio | 39081 | 14700 | 317 |
2394224 | 2394224 | 2022-04-10 | Jefferson | Ohio | 39081 | 14700 | 317 |
2390968 | 2390968 | 2022-04-09 | Jefferson | Ohio | 39081 | 14700 | 317 |
2387712 | 2387712 | 2022-04-08 | Jefferson | Ohio | 39081 | 14700 | 317 |
2384457 | 2384457 | 2022-04-07 | Jefferson | Ohio | 39081 | 14700 | 317 |
2379606 | 2379606 | 2022-04-06 | Rockdale | Georgia | 13247 | 18450 | 317 |
2381202 | 2381202 | 2022-04-06 | Jefferson | Ohio | 39081 | 14684 | 317 |
2376352 | 2376352 | 2022-04-05 | Rockdale | Georgia | 13247 | 18447 | 317 |
2377947 | 2377947 | 2022-04-05 | Jefferson | Ohio | 39081 | 14684 | 317 |
2374693 | 2374693 | 2022-04-04 | Jefferson | Ohio | 39081 | 14684 | 317 |
2375614 | 2375614 | 2022-04-04 | Portsmouth city | Virginia | 51740 | 20766 | 317 |
2371441 | 2371441 | 2022-04-03 | Jefferson | Ohio | 39081 | 14684 | 317 |
2372362 | 2372362 | 2022-04-03 | Portsmouth city | Virginia | 51740 | 20738 | 317 |
2368188 | 2368188 | 2022-04-02 | Jefferson | Ohio | 39081 | 14684 | 317 |
2369109 | 2369109 | 2022-04-02 | Portsmouth city | Virginia | 51740 | 20738 | 317 |
2364935 | 2364935 | 2022-04-01 | Jefferson | Ohio | 39081 | 14684 | 317 |
2365856 | 2365856 | 2022-04-01 | Portsmouth city | Virginia | 51740 | 20738 | 317 |
2361682 | 2361682 | 2022-03-31 | Jefferson | Ohio | 39081 | 14684 | 317 |
2362603 | 2362603 | 2022-03-31 | Portsmouth city | Virginia | 51740 | 20728 | 317 |
2332829 | 2332829 | 2022-03-22 | Anderson | Tennessee | 47001 | 22027 | 317 |
2333323 | 2333323 | 2022-03-22 | Portsmouth city | Virginia | 51740 | 20679 | 317 |
2329576 | 2329576 | 2022-03-21 | Anderson | Tennessee | 47001 | 22027 | 317 |
2330070 | 2330070 | 2022-03-21 | Portsmouth city | Virginia | 51740 | 20679 | 317 |
2326324 | 2326324 | 2022-03-20 | Anderson | Tennessee | 47001 | 22027 | 317 |
2326777 | 2326777 | 2022-03-20 | Hampton city | Virginia | 51650 | 27471 | 317 |
2323071 | 2323071 | 2022-03-19 | Anderson | Tennessee | 47001 | 22027 | 317 |
2323524 | 2323524 | 2022-03-19 | Hampton city | Virginia | 51650 | 27471 | 317 |
2319817 | 2319817 | 2022-03-18 | Anderson | Tennessee | 47001 | 22027 | 317 |
2320270 | 2320270 | 2022-03-18 | Hampton city | Virginia | 51650 | 27471 | 317 |
2316279 | 2316279 | 2022-03-17 | Josephine | Oregon | 41033 | 16242 | 317 |
2316563 | 2316563 | 2022-03-17 | Anderson | Tennessee | 47001 | 22027 | 317 |
2317016 | 2317016 | 2022-03-17 | Hampton city | Virginia | 51650 | 27468 | 317 |
2313310 | 2313310 | 2022-03-16 | Anderson | Tennessee | 47001 | 22027 | 317 |
2309494 | 2309494 | 2022-03-15 | Moore | North Carolina | 37125 | 24054 | 317 |
2306241 | 2306241 | 2022-03-14 | Moore | North Carolina | 37125 | 24050 | 317 |
2302970 | 2302970 | 2022-03-13 | Harnett | North Carolina | 37085 | 32326 | 317 |
2299718 | 2299718 | 2022-03-12 | Harnett | North Carolina | 37085 | 32326 | 317 |
2296466 | 2296466 | 2022-03-11 | Harnett | North Carolina | 37085 | 32326 | 317 |
2293214 | 2293214 | 2022-03-10 | Harnett | North Carolina | 37085 | 32257 | 317 |
2294435 | 2294435 | 2022-03-10 | Dodge | Wisconsin | 55027 | 26937 | 317 |
2289842 | 2289842 | 2022-03-09 | Lea | New Mexico | 35025 | 20085 | 317 |
2286590 | 2286590 | 2022-03-08 | Lea | New Mexico | 35025 | 20076 | 317 |
2278296 | 2278296 | 2022-03-06 | Lee | Alabama | 1081 | 37544 | 317 |
2275043 | 2275043 | 2022-03-05 | Lee | Alabama | 1081 | 37544 | 317 |
2271790 | 2271790 | 2022-03-04 | Lee | Alabama | 1081 | 37544 | 317 |
2259971 | 2259971 | 2022-02-28 | Wicomico | Maryland | 24045 | 19455 | 317 |
2244022 | 2244022 | 2022-02-23 | Franklin | Missouri | 29071 | 22456 | 317 |
2240771 | 2240771 | 2022-02-22 | Franklin | Missouri | 29071 | 22435 | 317 |
2237520 | 2237520 | 2022-02-21 | Franklin | Missouri | 29071 | 22370 | 317 |
2233287 | 2233287 | 2022-02-20 | Unknown | Guam | 43513 | 317 | |
2234269 | 2234269 | 2022-02-20 | Franklin | Missouri | 29071 | 22370 | 317 |
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);