ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,837 rows where deaths = 181 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 151
- North Carolina 147
- Ohio 128
- Georgia 122
- Texas 116
- Michigan 103
- Louisiana 92
- California 90
- Pennsylvania 70
- Tennessee 63
- Arkansas 55
- Alabama 52
- Minnesota 50
- Illinois 49
- Missouri 49
- Kentucky 45
- Virginia 43
- Mississippi 42
- Wisconsin 42
- New Mexico 39
- South Carolina 35
- New York 34
- Arizona 31
- West Virginia 27
- Maryland 24
- Rhode Island 15
- Oregon 13
- Washington 12
- Florida 11
- New Jersey 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499731 | 2499731 | 2022-05-13 | Miller | Arkansas | 5091 | 9596 | 181 |
2500620 | 2500620 | 2022-05-13 | Graves | Kentucky | 21083 | 11355 | 181 |
2500854 | 2500854 | 2022-05-13 | Ionia | Michigan | 26067 | 19843 | 181 |
2500974 | 2500974 | 2022-05-13 | Sherburne | Minnesota | 27141 | 27636 | 181 |
2496473 | 2496473 | 2022-05-12 | Miller | Arkansas | 5091 | 9595 | 181 |
2496558 | 2496558 | 2022-05-12 | Tuolumne | California | 6109 | 13661 | 181 |
2497362 | 2497362 | 2022-05-12 | Graves | Kentucky | 21083 | 11355 | 181 |
2497596 | 2497596 | 2022-05-12 | Ionia | Michigan | 26067 | 19843 | 181 |
2497716 | 2497716 | 2022-05-12 | Sherburne | Minnesota | 27141 | 27608 | 181 |
2493215 | 2493215 | 2022-05-11 | Miller | Arkansas | 5091 | 9595 | 181 |
2493300 | 2493300 | 2022-05-11 | Tuolumne | California | 6109 | 13661 | 181 |
2494104 | 2494104 | 2022-05-11 | Graves | Kentucky | 21083 | 11355 | 181 |
2494338 | 2494338 | 2022-05-11 | Ionia | Michigan | 26067 | 19843 | 181 |
2494458 | 2494458 | 2022-05-11 | Sherburne | Minnesota | 27141 | 27602 | 181 |
2489957 | 2489957 | 2022-05-10 | Miller | Arkansas | 5091 | 9593 | 181 |
2490042 | 2490042 | 2022-05-10 | Tuolumne | California | 6109 | 13661 | 181 |
2490846 | 2490846 | 2022-05-10 | Graves | Kentucky | 21083 | 11355 | 181 |
2491080 | 2491080 | 2022-05-10 | Ionia | Michigan | 26067 | 19720 | 181 |
2491200 | 2491200 | 2022-05-10 | Sherburne | Minnesota | 27141 | 27580 | 181 |
2486700 | 2486700 | 2022-05-09 | Miller | Arkansas | 5091 | 9591 | 181 |
2486785 | 2486785 | 2022-05-09 | Tuolumne | California | 6109 | 13661 | 181 |
2487589 | 2487589 | 2022-05-09 | Graves | Kentucky | 21083 | 11355 | 181 |
2487823 | 2487823 | 2022-05-09 | Ionia | Michigan | 26067 | 19720 | 181 |
2487943 | 2487943 | 2022-05-09 | Sherburne | Minnesota | 27141 | 27522 | 181 |
2483442 | 2483442 | 2022-05-08 | Miller | Arkansas | 5091 | 9591 | 181 |
2483527 | 2483527 | 2022-05-08 | Tuolumne | California | 6109 | 13661 | 181 |
2484565 | 2484565 | 2022-05-08 | Ionia | Michigan | 26067 | 19720 | 181 |
2484685 | 2484685 | 2022-05-08 | Sherburne | Minnesota | 27141 | 27496 | 181 |
2480184 | 2480184 | 2022-05-07 | Miller | Arkansas | 5091 | 9591 | 181 |
2480269 | 2480269 | 2022-05-07 | Tuolumne | California | 6109 | 13661 | 181 |
2481307 | 2481307 | 2022-05-07 | Ionia | Michigan | 26067 | 19720 | 181 |
2481427 | 2481427 | 2022-05-07 | Sherburne | Minnesota | 27141 | 27496 | 181 |
2476926 | 2476926 | 2022-05-06 | Miller | Arkansas | 5091 | 9591 | 181 |
2477011 | 2477011 | 2022-05-06 | Tuolumne | California | 6109 | 13661 | 181 |
2478049 | 2478049 | 2022-05-06 | Ionia | Michigan | 26067 | 19720 | 181 |
2478169 | 2478169 | 2022-05-06 | Sherburne | Minnesota | 27141 | 27496 | 181 |
2473668 | 2473668 | 2022-05-05 | Miller | Arkansas | 5091 | 9589 | 181 |
2473753 | 2473753 | 2022-05-05 | Tuolumne | California | 6109 | 13591 | 181 |
2474791 | 2474791 | 2022-05-05 | Ionia | Michigan | 26067 | 19720 | 181 |
2474911 | 2474911 | 2022-05-05 | Sherburne | Minnesota | 27141 | 27467 | 181 |
2470411 | 2470411 | 2022-05-04 | Miller | Arkansas | 5091 | 9588 | 181 |
2470496 | 2470496 | 2022-05-04 | Tuolumne | California | 6109 | 13591 | 181 |
2471534 | 2471534 | 2022-05-04 | Ionia | Michigan | 26067 | 19720 | 181 |
2471654 | 2471654 | 2022-05-04 | Sherburne | Minnesota | 27141 | 27449 | 181 |
2467155 | 2467155 | 2022-05-03 | Miller | Arkansas | 5091 | 9586 | 181 |
2467240 | 2467240 | 2022-05-03 | Tuolumne | California | 6109 | 13591 | 181 |
2468278 | 2468278 | 2022-05-03 | Ionia | Michigan | 26067 | 19643 | 181 |
2468398 | 2468398 | 2022-05-03 | Sherburne | Minnesota | 27141 | 27425 | 181 |
2463900 | 2463900 | 2022-05-02 | Miller | Arkansas | 5091 | 9586 | 181 |
2463985 | 2463985 | 2022-05-02 | Tuolumne | California | 6109 | 13591 | 181 |
2465023 | 2465023 | 2022-05-02 | Ionia | Michigan | 26067 | 19643 | 181 |
2465143 | 2465143 | 2022-05-02 | Sherburne | Minnesota | 27141 | 27404 | 181 |
2460644 | 2460644 | 2022-05-01 | Miller | Arkansas | 5091 | 9585 | 181 |
2460729 | 2460729 | 2022-05-01 | Tuolumne | California | 6109 | 13591 | 181 |
2461767 | 2461767 | 2022-05-01 | Ionia | Michigan | 26067 | 19643 | 181 |
2461887 | 2461887 | 2022-05-01 | Sherburne | Minnesota | 27141 | 27393 | 181 |
2457388 | 2457388 | 2022-04-30 | Miller | Arkansas | 5091 | 9585 | 181 |
2457473 | 2457473 | 2022-04-30 | Tuolumne | California | 6109 | 13591 | 181 |
2458511 | 2458511 | 2022-04-30 | Ionia | Michigan | 26067 | 19643 | 181 |
2458631 | 2458631 | 2022-04-30 | Sherburne | Minnesota | 27141 | 27393 | 181 |
2454217 | 2454217 | 2022-04-29 | Tuolumne | California | 6109 | 13591 | 181 |
2455255 | 2455255 | 2022-04-29 | Ionia | Michigan | 26067 | 19643 | 181 |
2455375 | 2455375 | 2022-04-29 | Sherburne | Minnesota | 27141 | 27393 | 181 |
2450961 | 2450961 | 2022-04-28 | Tuolumne | California | 6109 | 13520 | 181 |
2451999 | 2451999 | 2022-04-28 | Ionia | Michigan | 26067 | 19643 | 181 |
2452104 | 2452104 | 2022-04-28 | Olmsted | Minnesota | 27109 | 42109 | 181 |
2452119 | 2452119 | 2022-04-28 | Sherburne | Minnesota | 27141 | 27370 | 181 |
2447705 | 2447705 | 2022-04-27 | Tuolumne | California | 6109 | 13520 | 181 |
2448743 | 2448743 | 2022-04-27 | Ionia | Michigan | 26067 | 19643 | 181 |
2448848 | 2448848 | 2022-04-27 | Olmsted | Minnesota | 27109 | 42017 | 181 |
2448863 | 2448863 | 2022-04-27 | Sherburne | Minnesota | 27141 | 27366 | 181 |
2444449 | 2444449 | 2022-04-26 | Tuolumne | California | 6109 | 13520 | 181 |
2445487 | 2445487 | 2022-04-26 | Ionia | Michigan | 26067 | 19598 | 181 |
2445607 | 2445607 | 2022-04-26 | Sherburne | Minnesota | 27141 | 27353 | 181 |
2441193 | 2441193 | 2022-04-25 | Tuolumne | California | 6109 | 13520 | 181 |
2442231 | 2442231 | 2022-04-25 | Ionia | Michigan | 26067 | 19598 | 181 |
2442351 | 2442351 | 2022-04-25 | Sherburne | Minnesota | 27141 | 27330 | 181 |
2442594 | 2442594 | 2022-04-25 | Lewis and Clark | Montana | 30049 | 17623 | 181 |
2437937 | 2437937 | 2022-04-24 | Tuolumne | California | 6109 | 13520 | 181 |
2438975 | 2438975 | 2022-04-24 | Ionia | Michigan | 26067 | 19598 | 181 |
2439095 | 2439095 | 2022-04-24 | Sherburne | Minnesota | 27141 | 27315 | 181 |
2434681 | 2434681 | 2022-04-23 | Tuolumne | California | 6109 | 13520 | 181 |
2435719 | 2435719 | 2022-04-23 | Ionia | Michigan | 26067 | 19598 | 181 |
2435839 | 2435839 | 2022-04-23 | Sherburne | Minnesota | 27141 | 27315 | 181 |
2431425 | 2431425 | 2022-04-22 | Tuolumne | California | 6109 | 13520 | 181 |
2432463 | 2432463 | 2022-04-22 | Ionia | Michigan | 26067 | 19598 | 181 |
2432583 | 2432583 | 2022-04-22 | Sherburne | Minnesota | 27141 | 27315 | 181 |
2428169 | 2428169 | 2022-04-21 | Tuolumne | California | 6109 | 13493 | 181 |
2429207 | 2429207 | 2022-04-21 | Ionia | Michigan | 26067 | 19598 | 181 |
2429327 | 2429327 | 2022-04-21 | Sherburne | Minnesota | 27141 | 27299 | 181 |
2424913 | 2424913 | 2022-04-20 | Tuolumne | California | 6109 | 13493 | 181 |
2425951 | 2425951 | 2022-04-20 | Ionia | Michigan | 26067 | 19598 | 181 |
2426071 | 2426071 | 2022-04-20 | Sherburne | Minnesota | 27141 | 27300 | 181 |
2426778 | 2426778 | 2022-04-20 | Holmes | Ohio | 39075 | 5109 | 181 |
2421657 | 2421657 | 2022-04-19 | Tuolumne | California | 6109 | 13493 | 181 |
2422695 | 2422695 | 2022-04-19 | Ionia | Michigan | 26067 | 19563 | 181 |
2422815 | 2422815 | 2022-04-19 | Sherburne | Minnesota | 27141 | 27287 | 181 |
2423199 | 2423199 | 2022-04-19 | Unknown | Nevada | 7037 | 181 | |
2423522 | 2423522 | 2022-04-19 | Holmes | Ohio | 39075 | 5109 | 181 |
2418401 | 2418401 | 2022-04-18 | Tuolumne | California | 6109 | 13493 | 181 |
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);