ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
690 rows where deaths = 330 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 47
- Alabama 45
- Indiana 44
- North Carolina 38
- Arizona 35
- California 34
- Michigan 34
- Texas 33
- Illinois 32
- Georgia 30
- Florida 29
- Wisconsin 26
- Tennessee 25
- Virginia 25
- Ohio 16
- Arkansas 15
- Louisiana 15
- New York 15
- Iowa 14
- Oklahoma 14
- New Jersey 13
- South Carolina 12
- Massachusetts 11
- Minnesota 8
- Washington 8
- Missouri 7
- Colorado 6
- Delaware 6
- Idaho 6
- Maryland 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499599 | 2499599 | 2022-05-13 | DeKalb | Alabama | 1049 | 18799 | 330 |
2500240 | 2500240 | 2022-05-13 | McLean | Illinois | 17113 | 52348 | 330 |
2502565 | 2502565 | 2022-05-13 | Hampton city | Virginia | 51650 | 28527 | 330 |
2496982 | 2496982 | 2022-05-12 | McLean | Illinois | 17113 | 52186 | 330 |
2499307 | 2499307 | 2022-05-12 | Hampton city | Virginia | 51650 | 28488 | 330 |
2493724 | 2493724 | 2022-05-11 | McLean | Illinois | 17113 | 52074 | 330 |
2496049 | 2496049 | 2022-05-11 | Hampton city | Virginia | 51650 | 28453 | 330 |
2490466 | 2490466 | 2022-05-10 | McLean | Illinois | 17113 | 51967 | 330 |
2491092 | 2491092 | 2022-05-10 | Lenawee | Michigan | 26091 | 26296 | 330 |
2492791 | 2492791 | 2022-05-10 | Hampton city | Virginia | 51650 | 28427 | 330 |
2487209 | 2487209 | 2022-05-09 | McLean | Illinois | 17113 | 51894 | 330 |
2487835 | 2487835 | 2022-05-09 | Lenawee | Michigan | 26091 | 26296 | 330 |
2489533 | 2489533 | 2022-05-09 | Hampton city | Virginia | 51650 | 28400 | 330 |
2483951 | 2483951 | 2022-05-08 | McLean | Illinois | 17113 | 51682 | 330 |
2484577 | 2484577 | 2022-05-08 | Lenawee | Michigan | 26091 | 26296 | 330 |
2486276 | 2486276 | 2022-05-08 | Hampton city | Virginia | 51650 | 28327 | 330 |
2480693 | 2480693 | 2022-05-07 | McLean | Illinois | 17113 | 51682 | 330 |
2481319 | 2481319 | 2022-05-07 | Lenawee | Michigan | 26091 | 26296 | 330 |
2483018 | 2483018 | 2022-05-07 | Hampton city | Virginia | 51650 | 28327 | 330 |
2477435 | 2477435 | 2022-05-06 | McLean | Illinois | 17113 | 51682 | 330 |
2478061 | 2478061 | 2022-05-06 | Lenawee | Michigan | 26091 | 26296 | 330 |
2479760 | 2479760 | 2022-05-06 | Hampton city | Virginia | 51650 | 28327 | 330 |
2474803 | 2474803 | 2022-05-05 | Lenawee | Michigan | 26091 | 26296 | 330 |
2476502 | 2476502 | 2022-05-05 | Hampton city | Virginia | 51650 | 28302 | 330 |
2471546 | 2471546 | 2022-05-04 | Lenawee | Michigan | 26091 | 26296 | 330 |
2473244 | 2473244 | 2022-05-04 | Hampton city | Virginia | 51650 | 28269 | 330 |
2468290 | 2468290 | 2022-05-03 | Lenawee | Michigan | 26091 | 26146 | 330 |
2469988 | 2469988 | 2022-05-03 | Hampton city | Virginia | 51650 | 28212 | 330 |
2465035 | 2465035 | 2022-05-02 | Lenawee | Michigan | 26091 | 26146 | 330 |
2465636 | 2465636 | 2022-05-02 | Saratoga | New York | 36091 | 48520 | 330 |
2466732 | 2466732 | 2022-05-02 | Hampton city | Virginia | 51650 | 28158 | 330 |
2461779 | 2461779 | 2022-05-01 | Lenawee | Michigan | 26091 | 26146 | 330 |
2462381 | 2462381 | 2022-05-01 | Saratoga | New York | 36091 | 48435 | 330 |
2463477 | 2463477 | 2022-05-01 | Hampton city | Virginia | 51650 | 28106 | 330 |
2458523 | 2458523 | 2022-04-30 | Lenawee | Michigan | 26091 | 26146 | 330 |
2459125 | 2459125 | 2022-04-30 | Saratoga | New York | 36091 | 48317 | 330 |
2460221 | 2460221 | 2022-04-30 | Hampton city | Virginia | 51650 | 28106 | 330 |
2455267 | 2455267 | 2022-04-29 | Lenawee | Michigan | 26091 | 26146 | 330 |
2455869 | 2455869 | 2022-04-29 | Saratoga | New York | 36091 | 48181 | 330 |
2456965 | 2456965 | 2022-04-29 | Hampton city | Virginia | 51650 | 28106 | 330 |
2452011 | 2452011 | 2022-04-28 | Lenawee | Michigan | 26091 | 26146 | 330 |
2452613 | 2452613 | 2022-04-28 | Saratoga | New York | 36091 | 48038 | 330 |
2453709 | 2453709 | 2022-04-28 | Hampton city | Virginia | 51650 | 28037 | 330 |
2448755 | 2448755 | 2022-04-27 | Lenawee | Michigan | 26091 | 26146 | 330 |
2449357 | 2449357 | 2022-04-27 | Saratoga | New York | 36091 | 47889 | 330 |
2450453 | 2450453 | 2022-04-27 | Hampton city | Virginia | 51650 | 27956 | 330 |
2446100 | 2446100 | 2022-04-26 | Saratoga | New York | 36091 | 47759 | 330 |
2442845 | 2442845 | 2022-04-25 | Saratoga | New York | 36091 | 47667 | 330 |
2439589 | 2439589 | 2022-04-24 | Saratoga | New York | 36091 | 47557 | 330 |
2436333 | 2436333 | 2022-04-23 | Saratoga | New York | 36091 | 47467 | 330 |
2433077 | 2433077 | 2022-04-22 | Saratoga | New York | 36091 | 47372 | 330 |
2406968 | 2406968 | 2022-04-14 | Lea | New Mexico | 35025 | 20144 | 330 |
2403712 | 2403712 | 2022-04-13 | Lea | New Mexico | 35025 | 20134 | 330 |
2398798 | 2398798 | 2022-04-12 | Saline | Arkansas | 5125 | 30846 | 330 |
2400457 | 2400457 | 2022-04-12 | Lea | New Mexico | 35025 | 20134 | 330 |
2395543 | 2395543 | 2022-04-11 | Saline | Arkansas | 5125 | 30836 | 330 |
2392287 | 2392287 | 2022-04-10 | Saline | Arkansas | 5125 | 30833 | 330 |
2389031 | 2389031 | 2022-04-09 | Saline | Arkansas | 5125 | 30832 | 330 |
2385776 | 2385776 | 2022-04-08 | Saline | Arkansas | 5125 | 30828 | 330 |
2382521 | 2382521 | 2022-04-07 | Saline | Arkansas | 5125 | 30822 | 330 |
2379266 | 2379266 | 2022-04-06 | Saline | Arkansas | 5125 | 30819 | 330 |
2376012 | 2376012 | 2022-04-05 | Saline | Arkansas | 5125 | 30814 | 330 |
2355658 | 2355658 | 2022-03-29 | Maury | Tennessee | 47119 | 28867 | 330 |
2352405 | 2352405 | 2022-03-28 | Maury | Tennessee | 47119 | 28867 | 330 |
2349153 | 2349153 | 2022-03-27 | Maury | Tennessee | 47119 | 28867 | 330 |
2349734 | 2349734 | 2022-03-27 | Dodge | Wisconsin | 55027 | 27031 | 330 |
2345900 | 2345900 | 2022-03-26 | Maury | Tennessee | 47119 | 28867 | 330 |
2346481 | 2346481 | 2022-03-26 | Dodge | Wisconsin | 55027 | 27031 | 330 |
2342647 | 2342647 | 2022-03-25 | Maury | Tennessee | 47119 | 28867 | 330 |
2343228 | 2343228 | 2022-03-25 | Dodge | Wisconsin | 55027 | 27031 | 330 |
2336844 | 2336844 | 2022-03-24 | Lee | Alabama | 1081 | 37609 | 330 |
2338797 | 2338797 | 2022-03-24 | Surry | North Carolina | 37171 | 20988 | 330 |
2339394 | 2339394 | 2022-03-24 | Maury | Tennessee | 47119 | 28867 | 330 |
2333590 | 2333590 | 2022-03-23 | Lee | Alabama | 1081 | 37608 | 330 |
2335543 | 2335543 | 2022-03-23 | Surry | North Carolina | 37171 | 20981 | 330 |
2336140 | 2336140 | 2022-03-23 | Maury | Tennessee | 47119 | 28867 | 330 |
2332289 | 2332289 | 2022-03-22 | Surry | North Carolina | 37171 | 20977 | 330 |
2326872 | 2326872 | 2022-03-20 | Kitsap | Washington | 53035 | 38949 | 330 |
2323619 | 2323619 | 2022-03-19 | Kitsap | Washington | 53035 | 38949 | 330 |
2320365 | 2320365 | 2022-03-18 | Kitsap | Washington | 53035 | 38949 | 330 |
2314823 | 2314823 | 2022-03-17 | Wayne | Indiana | 18177 | 19188 | 330 |
2311570 | 2311570 | 2022-03-16 | Wayne | Indiana | 18177 | 19184 | 330 |
2308317 | 2308317 | 2022-03-15 | Wayne | Indiana | 18177 | 19181 | 330 |
2305066 | 2305066 | 2022-03-14 | Wayne | Indiana | 18177 | 19178 | 330 |
2301814 | 2301814 | 2022-03-13 | Wayne | Indiana | 18177 | 19172 | 330 |
2298562 | 2298562 | 2022-03-12 | Wayne | Indiana | 18177 | 19172 | 330 |
2295310 | 2295310 | 2022-03-11 | Wayne | Indiana | 18177 | 19172 | 330 |
2292058 | 2292058 | 2022-03-10 | Wayne | Indiana | 18177 | 19166 | 330 |
2288806 | 2288806 | 2022-03-09 | Wayne | Indiana | 18177 | 19166 | 330 |
2285555 | 2285555 | 2022-03-08 | Wayne | Indiana | 18177 | 19159 | 330 |
2282303 | 2282303 | 2022-03-07 | Wayne | Indiana | 18177 | 19152 | 330 |
2283524 | 2283524 | 2022-03-07 | Cass | North Dakota | 38017 | 58634 | 330 |
2283793 | 2283793 | 2022-03-07 | Clearfield | Pennsylvania | 42033 | 19126 | 330 |
2278281 | 2278281 | 2022-03-06 | Elmore | Alabama | 1051 | 22898 | 330 |
2279050 | 2279050 | 2022-03-06 | Wayne | Indiana | 18177 | 19146 | 330 |
2280272 | 2280272 | 2022-03-06 | Cass | North Dakota | 38017 | 58625 | 330 |
2280541 | 2280541 | 2022-03-06 | Clearfield | Pennsylvania | 42033 | 19121 | 330 |
2281294 | 2281294 | 2022-03-06 | Roanoke city | Virginia | 51770 | 20560 | 330 |
2275028 | 2275028 | 2022-03-05 | Elmore | Alabama | 1051 | 22898 | 330 |
2275797 | 2275797 | 2022-03-05 | Wayne | Indiana | 18177 | 19146 | 330 |
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);