ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,759 rows where deaths = 137 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 226
- Georgia 187
- Louisiana 157
- Texas 137
- Virginia 137
- New York 131
- North Carolina 130
- Missouri 125
- Illinois 119
- Alabama 112
- Mississippi 106
- Indiana 100
- Tennessee 93
- Michigan 92
- Pennsylvania 70
- Oklahoma 67
- South Carolina 67
- Kentucky 59
- Kansas 54
- West Virginia 52
- Iowa 48
- Nebraska 46
- Minnesota 41
- Nevada 41
- Arkansas 39
- Washington 36
- Wisconsin 36
- Florida 35
- Guam 32
- California 24
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499778 | 2499778 | 2022-05-13 | Lake | California | 6033 | 11699 | 137 |
2500005 | 2500005 | 2022-05-13 | Crisp | Georgia | 13081 | 4678 | 137 |
2500116 | 2500116 | 2022-05-13 | Washington | Georgia | 13303 | 4411 | 137 |
2500571 | 2500571 | 2022-05-13 | Unknown | Kansas | 0 | 137 | |
2500647 | 2500647 | 2022-05-13 | Lincoln | Kentucky | 21137 | 6487 | 137 |
2501779 | 2501779 | 2022-05-13 | McClain | Oklahoma | 40087 | 11773 | 137 |
2502721 | 2502721 | 2022-05-13 | Preston | West Virginia | 54077 | 9367 | 137 |
2496520 | 2496520 | 2022-05-12 | Lake | California | 6033 | 11693 | 137 |
2496747 | 2496747 | 2022-05-12 | Crisp | Georgia | 13081 | 4678 | 137 |
2496858 | 2496858 | 2022-05-12 | Washington | Georgia | 13303 | 4411 | 137 |
2497389 | 2497389 | 2022-05-12 | Lincoln | Kentucky | 21137 | 6487 | 137 |
2498521 | 2498521 | 2022-05-12 | McClain | Oklahoma | 40087 | 11773 | 137 |
2499463 | 2499463 | 2022-05-12 | Preston | West Virginia | 54077 | 9362 | 137 |
2493262 | 2493262 | 2022-05-11 | Lake | California | 6033 | 11693 | 137 |
2493489 | 2493489 | 2022-05-11 | Crisp | Georgia | 13081 | 4678 | 137 |
2493600 | 2493600 | 2022-05-11 | Washington | Georgia | 13303 | 4411 | 137 |
2494131 | 2494131 | 2022-05-11 | Lincoln | Kentucky | 21137 | 6487 | 137 |
2494933 | 2494933 | 2022-05-11 | Jefferson | New York | 36045 | 21358 | 137 |
2496205 | 2496205 | 2022-05-11 | Preston | West Virginia | 54077 | 9354 | 137 |
2490004 | 2490004 | 2022-05-10 | Lake | California | 6033 | 11693 | 137 |
2490342 | 2490342 | 2022-05-10 | Washington | Georgia | 13303 | 4401 | 137 |
2490873 | 2490873 | 2022-05-10 | Lincoln | Kentucky | 21137 | 6487 | 137 |
2491675 | 2491675 | 2022-05-10 | Jefferson | New York | 36045 | 21305 | 137 |
2492947 | 2492947 | 2022-05-10 | Preston | West Virginia | 54077 | 9346 | 137 |
2486747 | 2486747 | 2022-05-09 | Lake | California | 6033 | 11673 | 137 |
2487085 | 2487085 | 2022-05-09 | Washington | Georgia | 13303 | 4401 | 137 |
2487616 | 2487616 | 2022-05-09 | Lincoln | Kentucky | 21137 | 6487 | 137 |
2488417 | 2488417 | 2022-05-09 | Jefferson | New York | 36045 | 21244 | 137 |
2489689 | 2489689 | 2022-05-09 | Preston | West Virginia | 54077 | 9346 | 137 |
2483489 | 2483489 | 2022-05-08 | Lake | California | 6033 | 11673 | 137 |
2483827 | 2483827 | 2022-05-08 | Washington | Georgia | 13303 | 4401 | 137 |
2484522 | 2484522 | 2022-05-08 | Franklin | Massachusetts | 25011 | 11197 | 137 |
2485160 | 2485160 | 2022-05-08 | Jefferson | New York | 36045 | 21218 | 137 |
2486432 | 2486432 | 2022-05-08 | Preston | West Virginia | 54077 | 9332 | 137 |
2480231 | 2480231 | 2022-05-07 | Lake | California | 6033 | 11673 | 137 |
2480569 | 2480569 | 2022-05-07 | Washington | Georgia | 13303 | 4401 | 137 |
2481264 | 2481264 | 2022-05-07 | Franklin | Massachusetts | 25011 | 11197 | 137 |
2481902 | 2481902 | 2022-05-07 | Jefferson | New York | 36045 | 21184 | 137 |
2483174 | 2483174 | 2022-05-07 | Preston | West Virginia | 54077 | 9332 | 137 |
2476973 | 2476973 | 2022-05-06 | Lake | California | 6033 | 11673 | 137 |
2477311 | 2477311 | 2022-05-06 | Washington | Georgia | 13303 | 4401 | 137 |
2478006 | 2478006 | 2022-05-06 | Franklin | Massachusetts | 25011 | 11197 | 137 |
2478644 | 2478644 | 2022-05-06 | Jefferson | New York | 36045 | 21128 | 137 |
2479916 | 2479916 | 2022-05-06 | Preston | West Virginia | 54077 | 9332 | 137 |
2473715 | 2473715 | 2022-05-05 | Lake | California | 6033 | 11665 | 137 |
2474053 | 2474053 | 2022-05-05 | Washington | Georgia | 13303 | 4401 | 137 |
2475386 | 2475386 | 2022-05-05 | Jefferson | New York | 36045 | 21074 | 137 |
2476658 | 2476658 | 2022-05-05 | Preston | West Virginia | 54077 | 9327 | 137 |
2470458 | 2470458 | 2022-05-04 | Lake | California | 6033 | 11665 | 137 |
2470796 | 2470796 | 2022-05-04 | Washington | Georgia | 13303 | 4401 | 137 |
2471491 | 2471491 | 2022-05-04 | Franklin | Massachusetts | 25011 | 11133 | 137 |
2471814 | 2471814 | 2022-05-04 | Lincoln | Missouri | 29113 | 15127 | 137 |
2471868 | 2471868 | 2022-05-04 | Washington | Missouri | 29221 | 5983 | 137 |
2472129 | 2472129 | 2022-05-04 | Jefferson | New York | 36045 | 21020 | 137 |
2473400 | 2473400 | 2022-05-04 | Preston | West Virginia | 54077 | 9322 | 137 |
2467202 | 2467202 | 2022-05-03 | Lake | California | 6033 | 11665 | 137 |
2468558 | 2468558 | 2022-05-03 | Lincoln | Missouri | 29113 | 15127 | 137 |
2468612 | 2468612 | 2022-05-03 | Washington | Missouri | 29221 | 5983 | 137 |
2468873 | 2468873 | 2022-05-03 | Jefferson | New York | 36045 | 20968 | 137 |
2470034 | 2470034 | 2022-05-03 | Pulaski | Virginia | 51155 | 7269 | 137 |
2463947 | 2463947 | 2022-05-02 | Lake | California | 6033 | 11649 | 137 |
2464664 | 2464664 | 2022-05-02 | Douglas | Kansas | 20045 | 26689 | 137 |
2465302 | 2465302 | 2022-05-02 | Lincoln | Missouri | 29113 | 15127 | 137 |
2465356 | 2465356 | 2022-05-02 | Washington | Missouri | 29221 | 5983 | 137 |
2465617 | 2465617 | 2022-05-02 | Jefferson | New York | 36045 | 20925 | 137 |
2466778 | 2466778 | 2022-05-02 | Pulaski | Virginia | 51155 | 7269 | 137 |
2460691 | 2460691 | 2022-05-01 | Lake | California | 6033 | 11649 | 137 |
2461408 | 2461408 | 2022-05-01 | Douglas | Kansas | 20045 | 26689 | 137 |
2461548 | 2461548 | 2022-05-01 | Jessamine | Kentucky | 21113 | 15205 | 137 |
2462047 | 2462047 | 2022-05-01 | Lincoln | Missouri | 29113 | 15127 | 137 |
2462101 | 2462101 | 2022-05-01 | Washington | Missouri | 29221 | 5983 | 137 |
2462362 | 2462362 | 2022-05-01 | Jefferson | New York | 36045 | 20894 | 137 |
2463523 | 2463523 | 2022-05-01 | Pulaski | Virginia | 51155 | 7256 | 137 |
2457435 | 2457435 | 2022-04-30 | Lake | California | 6033 | 11649 | 137 |
2458152 | 2458152 | 2022-04-30 | Douglas | Kansas | 20045 | 26689 | 137 |
2458292 | 2458292 | 2022-04-30 | Jessamine | Kentucky | 21113 | 15205 | 137 |
2458791 | 2458791 | 2022-04-30 | Lincoln | Missouri | 29113 | 15127 | 137 |
2458845 | 2458845 | 2022-04-30 | Washington | Missouri | 29221 | 5983 | 137 |
2459106 | 2459106 | 2022-04-30 | Jefferson | New York | 36045 | 20855 | 137 |
2460267 | 2460267 | 2022-04-30 | Pulaski | Virginia | 51155 | 7256 | 137 |
2454179 | 2454179 | 2022-04-29 | Lake | California | 6033 | 11649 | 137 |
2454896 | 2454896 | 2022-04-29 | Douglas | Kansas | 20045 | 26689 | 137 |
2455036 | 2455036 | 2022-04-29 | Jessamine | Kentucky | 21113 | 15205 | 137 |
2455535 | 2455535 | 2022-04-29 | Lincoln | Missouri | 29113 | 15127 | 137 |
2455589 | 2455589 | 2022-04-29 | Washington | Missouri | 29221 | 5983 | 137 |
2455850 | 2455850 | 2022-04-29 | Jefferson | New York | 36045 | 20806 | 137 |
2457011 | 2457011 | 2022-04-29 | Pulaski | Virginia | 51155 | 7256 | 137 |
2451640 | 2451640 | 2022-04-28 | Douglas | Kansas | 20045 | 26689 | 137 |
2451780 | 2451780 | 2022-04-28 | Jessamine | Kentucky | 21113 | 15205 | 137 |
2452279 | 2452279 | 2022-04-28 | Lincoln | Missouri | 29113 | 15127 | 137 |
2452333 | 2452333 | 2022-04-28 | Washington | Missouri | 29221 | 5983 | 137 |
2452594 | 2452594 | 2022-04-28 | Jefferson | New York | 36045 | 20760 | 137 |
2453755 | 2453755 | 2022-04-28 | Pulaski | Virginia | 51155 | 7253 | 137 |
2448524 | 2448524 | 2022-04-27 | Jessamine | Kentucky | 21113 | 15205 | 137 |
2449023 | 2449023 | 2022-04-27 | Lincoln | Missouri | 29113 | 15127 | 137 |
2449077 | 2449077 | 2022-04-27 | Washington | Missouri | 29221 | 5983 | 137 |
2449338 | 2449338 | 2022-04-27 | Jefferson | New York | 36045 | 20708 | 137 |
2450499 | 2450499 | 2022-04-27 | Pulaski | Virginia | 51155 | 7248 | 137 |
2445268 | 2445268 | 2022-04-26 | Jessamine | Kentucky | 21113 | 15205 | 137 |
2445766 | 2445766 | 2022-04-26 | Lincoln | Missouri | 29113 | 15127 | 137 |
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);