ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,360 rows where deaths = 211 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 122
- Ohio 110
- Georgia 86
- Washington 86
- South Carolina 79
- Virginia 71
- Michigan 62
- Alabama 47
- North Carolina 44
- Wisconsin 44
- Iowa 43
- Maryland 42
- Pennsylvania 42
- Kentucky 37
- Missouri 34
- Illinois 33
- Tennessee 32
- Mississippi 30
- California 29
- Florida 29
- Indiana 28
- Louisiana 20
- New Jersey 20
- Oregon 20
- Arkansas 17
- Connecticut 17
- Oklahoma 17
- Utah 13
- New Hampshire 11
- New York 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500626 | 2500626 | 2022-05-13 | Harlan | Kentucky | 21095 | 9222 | 211 |
2500857 | 2500857 | 2022-05-13 | Isabella | Michigan | 26073 | 15890 | 211 |
2501793 | 2501793 | 2022-05-13 | Pittsburg | Oklahoma | 40121 | 10780 | 211 |
2502256 | 2502256 | 2022-05-13 | Coryell | Texas | 48099 | 17626 | 211 |
2497368 | 2497368 | 2022-05-12 | Harlan | Kentucky | 21095 | 9222 | 211 |
2497599 | 2497599 | 2022-05-12 | Isabella | Michigan | 26073 | 15890 | 211 |
2498535 | 2498535 | 2022-05-12 | Pittsburg | Oklahoma | 40121 | 10780 | 211 |
2498998 | 2498998 | 2022-05-12 | Coryell | Texas | 48099 | 17625 | 211 |
2494110 | 2494110 | 2022-05-11 | Harlan | Kentucky | 21095 | 9222 | 211 |
2494341 | 2494341 | 2022-05-11 | Isabella | Michigan | 26073 | 15890 | 211 |
2495277 | 2495277 | 2022-05-11 | Pittsburg | Oklahoma | 40121 | 10774 | 211 |
2495740 | 2495740 | 2022-05-11 | Coryell | Texas | 48099 | 17622 | 211 |
2490852 | 2490852 | 2022-05-10 | Harlan | Kentucky | 21095 | 9222 | 211 |
2492019 | 2492019 | 2022-05-10 | Pittsburg | Oklahoma | 40121 | 10774 | 211 |
2492482 | 2492482 | 2022-05-10 | Coryell | Texas | 48099 | 17619 | 211 |
2487595 | 2487595 | 2022-05-09 | Harlan | Kentucky | 21095 | 9222 | 211 |
2488761 | 2488761 | 2022-05-09 | Pittsburg | Oklahoma | 40121 | 10774 | 211 |
2489224 | 2489224 | 2022-05-09 | Coryell | Texas | 48099 | 17616 | 211 |
2485504 | 2485504 | 2022-05-08 | Pittsburg | Oklahoma | 40121 | 10774 | 211 |
2485967 | 2485967 | 2022-05-08 | Coryell | Texas | 48099 | 17616 | 211 |
2482246 | 2482246 | 2022-05-07 | Pittsburg | Oklahoma | 40121 | 10774 | 211 |
2482709 | 2482709 | 2022-05-07 | Coryell | Texas | 48099 | 17614 | 211 |
2478988 | 2478988 | 2022-05-06 | Pittsburg | Oklahoma | 40121 | 10774 | 211 |
2479451 | 2479451 | 2022-05-06 | Coryell | Texas | 48099 | 17611 | 211 |
2475730 | 2475730 | 2022-05-05 | Pittsburg | Oklahoma | 40121 | 10774 | 211 |
2476193 | 2476193 | 2022-05-05 | Coryell | Texas | 48099 | 17610 | 211 |
2472473 | 2472473 | 2022-05-04 | Pittsburg | Oklahoma | 40121 | 10773 | 211 |
2472936 | 2472936 | 2022-05-04 | Coryell | Texas | 48099 | 17598 | 211 |
2469217 | 2469217 | 2022-05-03 | Pittsburg | Oklahoma | 40121 | 10773 | 211 |
2469680 | 2469680 | 2022-05-03 | Coryell | Texas | 48099 | 17598 | 211 |
2465961 | 2465961 | 2022-05-02 | Pittsburg | Oklahoma | 40121 | 10773 | 211 |
2466424 | 2466424 | 2022-05-02 | Coryell | Texas | 48099 | 17596 | 211 |
2462706 | 2462706 | 2022-05-01 | Pittsburg | Oklahoma | 40121 | 10773 | 211 |
2463169 | 2463169 | 2022-05-01 | Coryell | Texas | 48099 | 17595 | 211 |
2457374 | 2457374 | 2022-04-30 | Independence | Arkansas | 5063 | 10615 | 211 |
2459450 | 2459450 | 2022-04-30 | Pittsburg | Oklahoma | 40121 | 10773 | 211 |
2459913 | 2459913 | 2022-04-30 | Coryell | Texas | 48099 | 17594 | 211 |
2454118 | 2454118 | 2022-04-29 | Independence | Arkansas | 5063 | 10615 | 211 |
2456194 | 2456194 | 2022-04-29 | Pittsburg | Oklahoma | 40121 | 10773 | 211 |
2456657 | 2456657 | 2022-04-29 | Coryell | Texas | 48099 | 17587 | 211 |
2452938 | 2452938 | 2022-04-28 | Pittsburg | Oklahoma | 40121 | 10773 | 211 |
2453401 | 2453401 | 2022-04-28 | Coryell | Texas | 48099 | 17582 | 211 |
2450145 | 2450145 | 2022-04-27 | Coryell | Texas | 48099 | 17580 | 211 |
2446888 | 2446888 | 2022-04-26 | Coryell | Texas | 48099 | 17575 | 211 |
2443633 | 2443633 | 2022-04-25 | Coryell | Texas | 48099 | 17575 | 211 |
2440377 | 2440377 | 2022-04-24 | Coryell | Texas | 48099 | 17574 | 211 |
2437121 | 2437121 | 2022-04-23 | Coryell | Texas | 48099 | 17574 | 211 |
2433865 | 2433865 | 2022-04-22 | Coryell | Texas | 48099 | 17568 | 211 |
2430609 | 2430609 | 2022-04-21 | Coryell | Texas | 48099 | 17554 | 211 |
2427353 | 2427353 | 2022-04-20 | Coryell | Texas | 48099 | 17547 | 211 |
2424097 | 2424097 | 2022-04-19 | Coryell | Texas | 48099 | 17546 | 211 |
2420841 | 2420841 | 2022-04-18 | Coryell | Texas | 48099 | 17539 | 211 |
2417856 | 2417856 | 2022-04-17 | Campbell | Virginia | 51031 | 12162 | 211 |
2414600 | 2414600 | 2022-04-16 | Campbell | Virginia | 51031 | 12162 | 211 |
2411344 | 2411344 | 2022-04-15 | Campbell | Virginia | 51031 | 12162 | 211 |
2408088 | 2408088 | 2022-04-14 | Campbell | Virginia | 51031 | 12114 | 211 |
2404832 | 2404832 | 2022-04-13 | Campbell | Virginia | 51031 | 12104 | 211 |
2401577 | 2401577 | 2022-04-12 | Campbell | Virginia | 51031 | 12105 | 211 |
2401702 | 2401702 | 2022-04-12 | Franklin | Washington | 53021 | 32472 | 211 |
2398242 | 2398242 | 2022-04-11 | Wharton | Texas | 48481 | 9109 | 211 |
2398322 | 2398322 | 2022-04-11 | Campbell | Virginia | 51031 | 12103 | 211 |
2398447 | 2398447 | 2022-04-11 | Franklin | Washington | 53021 | 32472 | 211 |
2394987 | 2394987 | 2022-04-10 | Wharton | Texas | 48481 | 9109 | 211 |
2395057 | 2395057 | 2022-04-10 | Augusta | Virginia | 51015 | 18958 | 211 |
2395192 | 2395192 | 2022-04-10 | Franklin | Washington | 53021 | 32472 | 211 |
2391731 | 2391731 | 2022-04-09 | Wharton | Texas | 48481 | 9108 | 211 |
2391801 | 2391801 | 2022-04-09 | Augusta | Virginia | 51015 | 18958 | 211 |
2391936 | 2391936 | 2022-04-09 | Franklin | Washington | 53021 | 32472 | 211 |
2388470 | 2388470 | 2022-04-08 | Walker | Texas | 48471 | 18431 | 211 |
2388545 | 2388545 | 2022-04-08 | Augusta | Virginia | 51015 | 18958 | 211 |
2388680 | 2388680 | 2022-04-08 | Franklin | Washington | 53021 | 32472 | 211 |
2385215 | 2385215 | 2022-04-07 | Walker | Texas | 48471 | 18425 | 211 |
2385290 | 2385290 | 2022-04-07 | Augusta | Virginia | 51015 | 18951 | 211 |
2385425 | 2385425 | 2022-04-07 | Franklin | Washington | 53021 | 32459 | 211 |
2381960 | 2381960 | 2022-04-06 | Walker | Texas | 48471 | 18420 | 211 |
2382035 | 2382035 | 2022-04-06 | Augusta | Virginia | 51015 | 18949 | 211 |
2382170 | 2382170 | 2022-04-06 | Franklin | Washington | 53021 | 32459 | 211 |
2378705 | 2378705 | 2022-04-05 | Walker | Texas | 48471 | 18417 | 211 |
2378780 | 2378780 | 2022-04-05 | Augusta | Virginia | 51015 | 18942 | 211 |
2378915 | 2378915 | 2022-04-05 | Franklin | Washington | 53021 | 32455 | 211 |
2375451 | 2375451 | 2022-04-04 | Walker | Texas | 48471 | 18415 | 211 |
2375526 | 2375526 | 2022-04-04 | Augusta | Virginia | 51015 | 18939 | 211 |
2375661 | 2375661 | 2022-04-04 | Franklin | Washington | 53021 | 32455 | 211 |
2369335 | 2369335 | 2022-04-03 | Autauga | Alabama | 1001 | 15659 | 211 |
2370351 | 2370351 | 2022-04-03 | Bullitt | Kentucky | 21029 | 21176 | 211 |
2371603 | 2371603 | 2022-04-03 | Yamhill | Oregon | 41071 | 17722 | 211 |
2372199 | 2372199 | 2022-04-03 | Walker | Texas | 48471 | 18413 | 211 |
2372274 | 2372274 | 2022-04-03 | Augusta | Virginia | 51015 | 18932 | 211 |
2372409 | 2372409 | 2022-04-03 | Franklin | Washington | 53021 | 32446 | 211 |
2366082 | 2366082 | 2022-04-02 | Autauga | Alabama | 1001 | 15659 | 211 |
2367098 | 2367098 | 2022-04-02 | Bullitt | Kentucky | 21029 | 21176 | 211 |
2368350 | 2368350 | 2022-04-02 | Yamhill | Oregon | 41071 | 17722 | 211 |
2368946 | 2368946 | 2022-04-02 | Walker | Texas | 48471 | 18412 | 211 |
2369021 | 2369021 | 2022-04-02 | Augusta | Virginia | 51015 | 18932 | 211 |
2369156 | 2369156 | 2022-04-02 | Franklin | Washington | 53021 | 32446 | 211 |
2362829 | 2362829 | 2022-04-01 | Autauga | Alabama | 1001 | 15659 | 211 |
2363845 | 2363845 | 2022-04-01 | Bullitt | Kentucky | 21029 | 21176 | 211 |
2365097 | 2365097 | 2022-04-01 | Yamhill | Oregon | 41071 | 17722 | 211 |
2365693 | 2365693 | 2022-04-01 | Walker | Texas | 48471 | 18410 | 211 |
2365768 | 2365768 | 2022-04-01 | Augusta | Virginia | 51015 | 18932 | 211 |
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);