ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,712 rows where deaths = 136 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 183
- Georgia 181
- Illinois 167
- Pennsylvania 154
- Ohio 145
- Mississippi 142
- Wisconsin 131
- South Carolina 108
- Indiana 102
- New York 92
- California 87
- North Carolina 79
- Florida 78
- Tennessee 77
- Louisiana 75
- Virginia 75
- Missouri 70
- Michigan 69
- Kentucky 63
- Wyoming 49
- Oklahoma 45
- Alabama 42
- Iowa 40
- Arkansas 38
- West Virginia 34
- Colorado 33
- Kansas 31
- Maryland 31
- Idaho 30
- Minnesota 27
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499715 | 2499715 | 2022-05-13 | Hot Spring | Arkansas | 5059 | 11237 | 136 |
2500247 | 2500247 | 2022-05-13 | Ogle | Illinois | 17141 | 14285 | 136 |
2500929 | 2500929 | 2022-05-13 | Goodhue | Minnesota | 27049 | 13600 | 136 |
2501692 | 2501692 | 2022-05-13 | Madison | Ohio | 39097 | 9754 | 136 |
2501739 | 2501739 | 2022-05-13 | Bryan | Oklahoma | 40013 | 13672 | 136 |
2502793 | 2502793 | 2022-05-13 | Sauk | Wisconsin | 55111 | 16479 | 136 |
2496457 | 2496457 | 2022-05-12 | Hot Spring | Arkansas | 5059 | 11227 | 136 |
2496989 | 2496989 | 2022-05-12 | Ogle | Illinois | 17141 | 14277 | 136 |
2497671 | 2497671 | 2022-05-12 | Goodhue | Minnesota | 27049 | 13565 | 136 |
2498434 | 2498434 | 2022-05-12 | Madison | Ohio | 39097 | 9754 | 136 |
2498481 | 2498481 | 2022-05-12 | Bryan | Oklahoma | 40013 | 13672 | 136 |
2499535 | 2499535 | 2022-05-12 | Sauk | Wisconsin | 55111 | 16447 | 136 |
2493199 | 2493199 | 2022-05-11 | Hot Spring | Arkansas | 5059 | 11222 | 136 |
2493731 | 2493731 | 2022-05-11 | Ogle | Illinois | 17141 | 14258 | 136 |
2494413 | 2494413 | 2022-05-11 | Goodhue | Minnesota | 27049 | 13546 | 136 |
2495223 | 2495223 | 2022-05-11 | Bryan | Oklahoma | 40013 | 13598 | 136 |
2496277 | 2496277 | 2022-05-11 | Sauk | Wisconsin | 55111 | 16421 | 136 |
2489941 | 2489941 | 2022-05-10 | Hot Spring | Arkansas | 5059 | 11218 | 136 |
2490231 | 2490231 | 2022-05-10 | Crisp | Georgia | 13081 | 4679 | 136 |
2490473 | 2490473 | 2022-05-10 | Ogle | Illinois | 17141 | 14239 | 136 |
2491155 | 2491155 | 2022-05-10 | Goodhue | Minnesota | 27049 | 13536 | 136 |
2491965 | 2491965 | 2022-05-10 | Bryan | Oklahoma | 40013 | 13598 | 136 |
2493019 | 2493019 | 2022-05-10 | Sauk | Wisconsin | 55111 | 16376 | 136 |
2486684 | 2486684 | 2022-05-09 | Hot Spring | Arkansas | 5059 | 11216 | 136 |
2486974 | 2486974 | 2022-05-09 | Crisp | Georgia | 13081 | 4679 | 136 |
2487216 | 2487216 | 2022-05-09 | Ogle | Illinois | 17141 | 14226 | 136 |
2488707 | 2488707 | 2022-05-09 | Bryan | Oklahoma | 40013 | 13598 | 136 |
2489761 | 2489761 | 2022-05-09 | Sauk | Wisconsin | 55111 | 16341 | 136 |
2483426 | 2483426 | 2022-05-08 | Hot Spring | Arkansas | 5059 | 11216 | 136 |
2483716 | 2483716 | 2022-05-08 | Crisp | Georgia | 13081 | 4678 | 136 |
2483958 | 2483958 | 2022-05-08 | Ogle | Illinois | 17141 | 14183 | 136 |
2485450 | 2485450 | 2022-05-08 | Bryan | Oklahoma | 40013 | 13598 | 136 |
2480168 | 2480168 | 2022-05-07 | Hot Spring | Arkansas | 5059 | 11216 | 136 |
2480458 | 2480458 | 2022-05-07 | Crisp | Georgia | 13081 | 4678 | 136 |
2480700 | 2480700 | 2022-05-07 | Ogle | Illinois | 17141 | 14183 | 136 |
2482192 | 2482192 | 2022-05-07 | Bryan | Oklahoma | 40013 | 13598 | 136 |
2477200 | 2477200 | 2022-05-06 | Crisp | Georgia | 13081 | 4678 | 136 |
2477442 | 2477442 | 2022-05-06 | Ogle | Illinois | 17141 | 14183 | 136 |
2478934 | 2478934 | 2022-05-06 | Bryan | Oklahoma | 40013 | 13598 | 136 |
2473942 | 2473942 | 2022-05-05 | Crisp | Georgia | 13081 | 4678 | 136 |
2474184 | 2474184 | 2022-05-05 | Ogle | Illinois | 17141 | 14166 | 136 |
2474748 | 2474748 | 2022-05-05 | Franklin | Massachusetts | 25011 | 11163 | 136 |
2475676 | 2475676 | 2022-05-05 | Bryan | Oklahoma | 40013 | 13598 | 136 |
2470685 | 2470685 | 2022-05-04 | Crisp | Georgia | 13081 | 4678 | 136 |
2470927 | 2470927 | 2022-05-04 | Ogle | Illinois | 17141 | 14154 | 136 |
2467429 | 2467429 | 2022-05-03 | Crisp | Georgia | 13081 | 4675 | 136 |
2467671 | 2467671 | 2022-05-03 | Ogle | Illinois | 17141 | 14135 | 136 |
2468235 | 2468235 | 2022-05-03 | Franklin | Massachusetts | 25011 | 11105 | 136 |
2470143 | 2470143 | 2022-05-03 | Preston | West Virginia | 54077 | 9317 | 136 |
2464033 | 2464033 | 2022-05-02 | Morgan | Colorado | 8087 | 5689 | 136 |
2464174 | 2464174 | 2022-05-02 | Crisp | Georgia | 13081 | 4675 | 136 |
2464416 | 2464416 | 2022-05-02 | Ogle | Illinois | 17141 | 14127 | 136 |
2464980 | 2464980 | 2022-05-02 | Franklin | Massachusetts | 25011 | 11099 | 136 |
2466887 | 2466887 | 2022-05-02 | Preston | West Virginia | 54077 | 9313 | 136 |
2460777 | 2460777 | 2022-05-01 | Morgan | Colorado | 8087 | 5688 | 136 |
2460918 | 2460918 | 2022-05-01 | Crisp | Georgia | 13081 | 4675 | 136 |
2461160 | 2461160 | 2022-05-01 | Ogle | Illinois | 17141 | 14104 | 136 |
2461724 | 2461724 | 2022-05-01 | Franklin | Massachusetts | 25011 | 11035 | 136 |
2463632 | 2463632 | 2022-05-01 | Preston | West Virginia | 54077 | 9307 | 136 |
2457521 | 2457521 | 2022-04-30 | Morgan | Colorado | 8087 | 5688 | 136 |
2457662 | 2457662 | 2022-04-30 | Crisp | Georgia | 13081 | 4675 | 136 |
2457904 | 2457904 | 2022-04-30 | Ogle | Illinois | 17141 | 14104 | 136 |
2458468 | 2458468 | 2022-04-30 | Franklin | Massachusetts | 25011 | 11035 | 136 |
2460376 | 2460376 | 2022-04-30 | Preston | West Virginia | 54077 | 9307 | 136 |
2454265 | 2454265 | 2022-04-29 | Morgan | Colorado | 8087 | 5688 | 136 |
2454406 | 2454406 | 2022-04-29 | Crisp | Georgia | 13081 | 4675 | 136 |
2454648 | 2454648 | 2022-04-29 | Ogle | Illinois | 17141 | 14104 | 136 |
2455212 | 2455212 | 2022-04-29 | Franklin | Massachusetts | 25011 | 11035 | 136 |
2457120 | 2457120 | 2022-04-29 | Preston | West Virginia | 54077 | 9307 | 136 |
2451009 | 2451009 | 2022-04-28 | Morgan | Colorado | 8087 | 5688 | 136 |
2451150 | 2451150 | 2022-04-28 | Crisp | Georgia | 13081 | 4675 | 136 |
2451392 | 2451392 | 2022-04-28 | Ogle | Illinois | 17141 | 14091 | 136 |
2451956 | 2451956 | 2022-04-28 | Franklin | Massachusetts | 25011 | 11012 | 136 |
2453864 | 2453864 | 2022-04-28 | Preston | West Virginia | 54077 | 9303 | 136 |
2447753 | 2447753 | 2022-04-27 | Morgan | Colorado | 8087 | 5688 | 136 |
2447894 | 2447894 | 2022-04-27 | Crisp | Georgia | 13081 | 4675 | 136 |
2448136 | 2448136 | 2022-04-27 | Ogle | Illinois | 17141 | 14077 | 136 |
2448700 | 2448700 | 2022-04-27 | Franklin | Massachusetts | 25011 | 10980 | 136 |
2450608 | 2450608 | 2022-04-27 | Preston | West Virginia | 54077 | 9303 | 136 |
2444497 | 2444497 | 2022-04-26 | Morgan | Colorado | 8087 | 5688 | 136 |
2444638 | 2444638 | 2022-04-26 | Crisp | Georgia | 13081 | 4673 | 136 |
2444880 | 2444880 | 2022-04-26 | Ogle | Illinois | 17141 | 14063 | 136 |
2445444 | 2445444 | 2022-04-26 | Franklin | Massachusetts | 25011 | 10956 | 136 |
2441241 | 2441241 | 2022-04-25 | Morgan | Colorado | 8087 | 5686 | 136 |
2441382 | 2441382 | 2022-04-25 | Crisp | Georgia | 13081 | 4673 | 136 |
2441624 | 2441624 | 2022-04-25 | Ogle | Illinois | 17141 | 14055 | 136 |
2442188 | 2442188 | 2022-04-25 | Franklin | Massachusetts | 25011 | 10946 | 136 |
2437985 | 2437985 | 2022-04-24 | Morgan | Colorado | 8087 | 5680 | 136 |
2438126 | 2438126 | 2022-04-24 | Crisp | Georgia | 13081 | 4670 | 136 |
2438368 | 2438368 | 2022-04-24 | Ogle | Illinois | 17141 | 14036 | 136 |
2434729 | 2434729 | 2022-04-23 | Morgan | Colorado | 8087 | 5680 | 136 |
2434870 | 2434870 | 2022-04-23 | Crisp | Georgia | 13081 | 4670 | 136 |
2435112 | 2435112 | 2022-04-23 | Ogle | Illinois | 17141 | 14036 | 136 |
2431473 | 2431473 | 2022-04-22 | Morgan | Colorado | 8087 | 5680 | 136 |
2431614 | 2431614 | 2022-04-22 | Crisp | Georgia | 13081 | 4670 | 136 |
2431856 | 2431856 | 2022-04-22 | Ogle | Illinois | 17141 | 14036 | 136 |
2428358 | 2428358 | 2022-04-21 | Crisp | Georgia | 13081 | 4670 | 136 |
2428600 | 2428600 | 2022-04-21 | Ogle | Illinois | 17141 | 14024 | 136 |
2425102 | 2425102 | 2022-04-20 | Crisp | Georgia | 13081 | 4670 | 136 |
2425344 | 2425344 | 2022-04-20 | Ogle | Illinois | 17141 | 14019 | 136 |
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);