ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,575 rows where deaths = 191 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 177
- Georgia 113
- Virginia 110
- Tennessee 100
- Alabama 87
- Louisiana 76
- South Carolina 72
- North Carolina 71
- Pennsylvania 62
- Indiana 52
- Kentucky 47
- New York 42
- Michigan 39
- Ohio 39
- Wisconsin 34
- Missouri 33
- California 30
- North Dakota 30
- Connecticut 29
- Oklahoma 29
- New Jersey 26
- Mississippi 23
- Utah 22
- Illinois 20
- Arizona 19
- Montana 19
- Washington 18
- New Mexico 15
- Arkansas 14
- West Virginia 14
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500757 | 2500757 | 2022-05-13 | Vernon | Louisiana | 22115 | 9939 | 191 |
2500849 | 2500849 | 2022-05-13 | Gratiot | Michigan | 26057 | 13864 | 191 |
2501473 | 2501473 | 2022-05-13 | St. Lawrence | New York | 36089 | 22454 | 191 |
2502011 | 2502011 | 2022-05-13 | Chesterfield | South Carolina | 45025 | 11836 | 191 |
2497499 | 2497499 | 2022-05-12 | Vernon | Louisiana | 22115 | 9938 | 191 |
2497591 | 2497591 | 2022-05-12 | Gratiot | Michigan | 26057 | 13864 | 191 |
2498215 | 2498215 | 2022-05-12 | St. Lawrence | New York | 36089 | 22454 | 191 |
2498753 | 2498753 | 2022-05-12 | Chesterfield | South Carolina | 45025 | 11836 | 191 |
2494241 | 2494241 | 2022-05-11 | Vernon | Louisiana | 22115 | 9936 | 191 |
2494333 | 2494333 | 2022-05-11 | Gratiot | Michigan | 26057 | 13864 | 191 |
2494957 | 2494957 | 2022-05-11 | St. Lawrence | New York | 36089 | 22424 | 191 |
2495495 | 2495495 | 2022-05-11 | Chesterfield | South Carolina | 45025 | 11836 | 191 |
2490983 | 2490983 | 2022-05-10 | Vernon | Louisiana | 22115 | 9935 | 191 |
2491699 | 2491699 | 2022-05-10 | St. Lawrence | New York | 36089 | 22385 | 191 |
2492237 | 2492237 | 2022-05-10 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2487726 | 2487726 | 2022-05-09 | Vernon | Louisiana | 22115 | 9933 | 191 |
2488416 | 2488416 | 2022-05-09 | Herkimer | New York | 36043 | 14741 | 191 |
2488441 | 2488441 | 2022-05-09 | St. Lawrence | New York | 36089 | 22373 | 191 |
2488979 | 2488979 | 2022-05-09 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2484468 | 2484468 | 2022-05-08 | Vernon | Louisiana | 22115 | 9933 | 191 |
2485159 | 2485159 | 2022-05-08 | Herkimer | New York | 36043 | 14723 | 191 |
2485184 | 2485184 | 2022-05-08 | St. Lawrence | New York | 36089 | 22363 | 191 |
2485722 | 2485722 | 2022-05-08 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2481210 | 2481210 | 2022-05-07 | Vernon | Louisiana | 22115 | 9933 | 191 |
2481901 | 2481901 | 2022-05-07 | Herkimer | New York | 36043 | 14697 | 191 |
2481916 | 2481916 | 2022-05-07 | Oswego | New York | 36075 | 28604 | 191 |
2482464 | 2482464 | 2022-05-07 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2477952 | 2477952 | 2022-05-06 | Vernon | Louisiana | 22115 | 9933 | 191 |
2478643 | 2478643 | 2022-05-06 | Herkimer | New York | 36043 | 14665 | 191 |
2478658 | 2478658 | 2022-05-06 | Oswego | New York | 36075 | 28535 | 191 |
2479206 | 2479206 | 2022-05-06 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2474694 | 2474694 | 2022-05-05 | Vernon | Louisiana | 22115 | 9933 | 191 |
2475400 | 2475400 | 2022-05-05 | Oswego | New York | 36075 | 28469 | 191 |
2475948 | 2475948 | 2022-05-05 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2472143 | 2472143 | 2022-05-04 | Oswego | New York | 36075 | 28375 | 191 |
2472691 | 2472691 | 2022-05-04 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2468887 | 2468887 | 2022-05-03 | Oswego | New York | 36075 | 28317 | 191 |
2469435 | 2469435 | 2022-05-03 | Chesterfield | South Carolina | 45025 | 11821 | 191 |
2465631 | 2465631 | 2022-05-02 | Oswego | New York | 36075 | 28289 | 191 |
2461609 | 2461609 | 2022-05-01 | Whitley | Kentucky | 21235 | 14394 | 191 |
2462312 | 2462312 | 2022-05-01 | Curry | New Mexico | 35009 | 12723 | 191 |
2458353 | 2458353 | 2022-04-30 | Whitley | Kentucky | 21235 | 14394 | 191 |
2459056 | 2459056 | 2022-04-30 | Curry | New Mexico | 35009 | 12723 | 191 |
2455097 | 2455097 | 2022-04-29 | Whitley | Kentucky | 21235 | 14394 | 191 |
2455800 | 2455800 | 2022-04-29 | Curry | New Mexico | 35009 | 12723 | 191 |
2451841 | 2451841 | 2022-04-28 | Whitley | Kentucky | 21235 | 14394 | 191 |
2452544 | 2452544 | 2022-04-28 | Curry | New Mexico | 35009 | 12717 | 191 |
2448585 | 2448585 | 2022-04-27 | Whitley | Kentucky | 21235 | 14394 | 191 |
2448646 | 2448646 | 2022-04-27 | Vernon | Louisiana | 22115 | 9933 | 191 |
2449923 | 2449923 | 2022-04-27 | Newberry | South Carolina | 45071 | 13281 | 191 |
2444713 | 2444713 | 2022-04-26 | Polk | Georgia | 13233 | 11883 | 191 |
2445329 | 2445329 | 2022-04-26 | Whitley | Kentucky | 21235 | 14394 | 191 |
2445390 | 2445390 | 2022-04-26 | Vernon | Louisiana | 22115 | 9933 | 191 |
2445527 | 2445527 | 2022-04-26 | Sanilac | Michigan | 26151 | 8702 | 191 |
2446666 | 2446666 | 2022-04-26 | Newberry | South Carolina | 45071 | 13281 | 191 |
2441457 | 2441457 | 2022-04-25 | Polk | Georgia | 13233 | 11883 | 191 |
2442073 | 2442073 | 2022-04-25 | Whitley | Kentucky | 21235 | 14394 | 191 |
2442134 | 2442134 | 2022-04-25 | Vernon | Louisiana | 22115 | 9932 | 191 |
2442271 | 2442271 | 2022-04-25 | Sanilac | Michigan | 26151 | 8702 | 191 |
2443411 | 2443411 | 2022-04-25 | Newberry | South Carolina | 45071 | 13281 | 191 |
2438201 | 2438201 | 2022-04-24 | Polk | Georgia | 13233 | 11881 | 191 |
2438878 | 2438878 | 2022-04-24 | Vernon | Louisiana | 22115 | 9932 | 191 |
2439015 | 2439015 | 2022-04-24 | Sanilac | Michigan | 26151 | 8702 | 191 |
2440155 | 2440155 | 2022-04-24 | Newberry | South Carolina | 45071 | 13281 | 191 |
2434945 | 2434945 | 2022-04-23 | Polk | Georgia | 13233 | 11881 | 191 |
2435622 | 2435622 | 2022-04-23 | Vernon | Louisiana | 22115 | 9932 | 191 |
2435759 | 2435759 | 2022-04-23 | Sanilac | Michigan | 26151 | 8702 | 191 |
2436899 | 2436899 | 2022-04-23 | Newberry | South Carolina | 45071 | 13281 | 191 |
2431689 | 2431689 | 2022-04-22 | Polk | Georgia | 13233 | 11881 | 191 |
2432366 | 2432366 | 2022-04-22 | Vernon | Louisiana | 22115 | 9932 | 191 |
2432503 | 2432503 | 2022-04-22 | Sanilac | Michigan | 26151 | 8702 | 191 |
2433643 | 2433643 | 2022-04-22 | Newberry | South Carolina | 45071 | 13281 | 191 |
2428433 | 2428433 | 2022-04-21 | Polk | Georgia | 13233 | 11881 | 191 |
2429110 | 2429110 | 2022-04-21 | Vernon | Louisiana | 22115 | 9932 | 191 |
2429247 | 2429247 | 2022-04-21 | Sanilac | Michigan | 26151 | 8702 | 191 |
2430387 | 2430387 | 2022-04-21 | Newberry | South Carolina | 45071 | 13281 | 191 |
2425177 | 2425177 | 2022-04-20 | Polk | Georgia | 13233 | 11881 | 191 |
2425854 | 2425854 | 2022-04-20 | Vernon | Louisiana | 22115 | 9931 | 191 |
2425991 | 2425991 | 2022-04-20 | Sanilac | Michigan | 26151 | 8702 | 191 |
2427131 | 2427131 | 2022-04-20 | Newberry | South Carolina | 45071 | 13281 | 191 |
2421921 | 2421921 | 2022-04-19 | Polk | Georgia | 13233 | 11874 | 191 |
2422598 | 2422598 | 2022-04-19 | Vernon | Louisiana | 22115 | 9931 | 191 |
2422735 | 2422735 | 2022-04-19 | Sanilac | Michigan | 26151 | 8684 | 191 |
2423875 | 2423875 | 2022-04-19 | Newberry | South Carolina | 45071 | 13281 | 191 |
2418665 | 2418665 | 2022-04-18 | Polk | Georgia | 13233 | 11874 | 191 |
2419342 | 2419342 | 2022-04-18 | Vernon | Louisiana | 22115 | 9931 | 191 |
2419479 | 2419479 | 2022-04-18 | Sanilac | Michigan | 26151 | 8684 | 191 |
2420619 | 2420619 | 2022-04-18 | Newberry | South Carolina | 45071 | 13270 | 191 |
2421399 | 2421399 | 2022-04-18 | Fremont | Wyoming | 56013 | 13760 | 191 |
2415409 | 2415409 | 2022-04-17 | Polk | Georgia | 13233 | 11874 | 191 |
2415943 | 2415943 | 2022-04-17 | Floyd | Kentucky | 21071 | 12519 | 191 |
2416086 | 2416086 | 2022-04-17 | Vernon | Louisiana | 22115 | 9928 | 191 |
2416223 | 2416223 | 2022-04-17 | Sanilac | Michigan | 26151 | 8684 | 191 |
2417363 | 2417363 | 2022-04-17 | Newberry | South Carolina | 45071 | 13270 | 191 |
2418143 | 2418143 | 2022-04-17 | Fremont | Wyoming | 56013 | 13760 | 191 |
2412153 | 2412153 | 2022-04-16 | Polk | Georgia | 13233 | 11874 | 191 |
2412687 | 2412687 | 2022-04-16 | Floyd | Kentucky | 21071 | 12519 | 191 |
2412830 | 2412830 | 2022-04-16 | Vernon | Louisiana | 22115 | 9928 | 191 |
2412967 | 2412967 | 2022-04-16 | Sanilac | Michigan | 26151 | 8684 | 191 |
2414107 | 2414107 | 2022-04-16 | Newberry | South Carolina | 45071 | 13270 | 191 |
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);