ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
345 rows where deaths = 450 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 54
- Connecticut 32
- Virginia 21
- Missouri 19
- Michigan 18
- Georgia 17
- Indiana 15
- North Carolina 15
- Pennsylvania 15
- California 14
- Ohio 11
- Colorado 10
- South Carolina 10
- Illinois 8
- New Mexico 8
- Louisiana 7
- Mississippi 7
- New York 7
- Rhode Island 7
- Tennessee 7
- Alabama 6
- Florida 6
- Arizona 4
- Arkansas 3
- New Hampshire 3
- New Jersey 3
- Washington 3
- Wisconsin 3
- Massachusetts 2
- Minnesota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501710 | 2501710 | 2022-05-13 | Portage | Ohio | 39133 | 35026 | 450 |
2502006 | 2502006 | 2022-05-13 | Berkeley | South Carolina | 45015 | 52240 | 450 |
2502390 | 2502390 | 2022-05-13 | Parker | Texas | 48367 | 34819 | 450 |
2496551 | 2496551 | 2022-05-12 | Solano | California | 6095 | 89142 | 450 |
2498452 | 2498452 | 2022-05-12 | Portage | Ohio | 39133 | 35026 | 450 |
2498748 | 2498748 | 2022-05-12 | Berkeley | South Carolina | 45015 | 52240 | 450 |
2499132 | 2499132 | 2022-05-12 | Parker | Texas | 48367 | 34806 | 450 |
2493293 | 2493293 | 2022-05-11 | Solano | California | 6095 | 89142 | 450 |
2495194 | 2495194 | 2022-05-11 | Portage | Ohio | 39133 | 34683 | 450 |
2495490 | 2495490 | 2022-05-11 | Berkeley | South Carolina | 45015 | 52240 | 450 |
2495874 | 2495874 | 2022-05-11 | Parker | Texas | 48367 | 34782 | 450 |
2490035 | 2490035 | 2022-05-10 | Solano | California | 6095 | 89142 | 450 |
2491093 | 2491093 | 2022-05-10 | Livingston | Michigan | 26093 | 47139 | 450 |
2491936 | 2491936 | 2022-05-10 | Portage | Ohio | 39133 | 34683 | 450 |
2492616 | 2492616 | 2022-05-10 | Parker | Texas | 48367 | 34774 | 450 |
2486778 | 2486778 | 2022-05-09 | Solano | California | 6095 | 88716 | 450 |
2487836 | 2487836 | 2022-05-09 | Livingston | Michigan | 26093 | 47139 | 450 |
2488678 | 2488678 | 2022-05-09 | Portage | Ohio | 39133 | 34683 | 450 |
2489358 | 2489358 | 2022-05-09 | Parker | Texas | 48367 | 34749 | 450 |
2483520 | 2483520 | 2022-05-08 | Solano | California | 6095 | 88716 | 450 |
2484578 | 2484578 | 2022-05-08 | Livingston | Michigan | 26093 | 47139 | 450 |
2485421 | 2485421 | 2022-05-08 | Portage | Ohio | 39133 | 34683 | 450 |
2486101 | 2486101 | 2022-05-08 | Parker | Texas | 48367 | 34740 | 450 |
2480262 | 2480262 | 2022-05-07 | Solano | California | 6095 | 88716 | 450 |
2481320 | 2481320 | 2022-05-07 | Livingston | Michigan | 26093 | 47139 | 450 |
2482163 | 2482163 | 2022-05-07 | Portage | Ohio | 39133 | 34683 | 450 |
2482843 | 2482843 | 2022-05-07 | Parker | Texas | 48367 | 34733 | 450 |
2477004 | 2477004 | 2022-05-06 | Solano | California | 6095 | 88716 | 450 |
2478062 | 2478062 | 2022-05-06 | Livingston | Michigan | 26093 | 47139 | 450 |
2478905 | 2478905 | 2022-05-06 | Portage | Ohio | 39133 | 34683 | 450 |
2479585 | 2479585 | 2022-05-06 | Parker | Texas | 48367 | 34700 | 450 |
2474804 | 2474804 | 2022-05-05 | Livingston | Michigan | 26093 | 47139 | 450 |
2475647 | 2475647 | 2022-05-05 | Portage | Ohio | 39133 | 34683 | 450 |
2476327 | 2476327 | 2022-05-05 | Parker | Texas | 48367 | 34688 | 450 |
2471547 | 2471547 | 2022-05-04 | Livingston | Michigan | 26093 | 47139 | 450 |
2473070 | 2473070 | 2022-05-04 | Parker | Texas | 48367 | 34671 | 450 |
2468291 | 2468291 | 2022-05-03 | Livingston | Michigan | 26093 | 46705 | 450 |
2469814 | 2469814 | 2022-05-03 | Parker | Texas | 48367 | 34661 | 450 |
2465036 | 2465036 | 2022-05-02 | Livingston | Michigan | 26093 | 46705 | 450 |
2466558 | 2466558 | 2022-05-02 | Parker | Texas | 48367 | 34656 | 450 |
2461780 | 2461780 | 2022-05-01 | Livingston | Michigan | 26093 | 46705 | 450 |
2463303 | 2463303 | 2022-05-01 | Parker | Texas | 48367 | 34653 | 450 |
2458524 | 2458524 | 2022-04-30 | Livingston | Michigan | 26093 | 46705 | 450 |
2460047 | 2460047 | 2022-04-30 | Parker | Texas | 48367 | 34649 | 450 |
2455268 | 2455268 | 2022-04-29 | Livingston | Michigan | 26093 | 46705 | 450 |
2456791 | 2456791 | 2022-04-29 | Parker | Texas | 48367 | 34634 | 450 |
2452012 | 2452012 | 2022-04-28 | Livingston | Michigan | 26093 | 46705 | 450 |
2453535 | 2453535 | 2022-04-28 | Parker | Texas | 48367 | 34623 | 450 |
2448756 | 2448756 | 2022-04-27 | Livingston | Michigan | 26093 | 46705 | 450 |
2450279 | 2450279 | 2022-04-27 | Parker | Texas | 48367 | 34606 | 450 |
2444265 | 2444265 | 2022-04-26 | Shelby | Alabama | 1117 | 60950 | 450 |
2447022 | 2447022 | 2022-04-26 | Parker | Texas | 48367 | 34597 | 450 |
2441009 | 2441009 | 2022-04-25 | Shelby | Alabama | 1117 | 60920 | 450 |
2443767 | 2443767 | 2022-04-25 | Parker | Texas | 48367 | 34588 | 450 |
2437753 | 2437753 | 2022-04-24 | Shelby | Alabama | 1117 | 60882 | 450 |
2440511 | 2440511 | 2022-04-24 | Parker | Texas | 48367 | 34586 | 450 |
2434497 | 2434497 | 2022-04-23 | Shelby | Alabama | 1117 | 60882 | 450 |
2437255 | 2437255 | 2022-04-23 | Parker | Texas | 48367 | 34584 | 450 |
2431241 | 2431241 | 2022-04-22 | Shelby | Alabama | 1117 | 60882 | 450 |
2433999 | 2433999 | 2022-04-22 | Parker | Texas | 48367 | 34558 | 450 |
2430743 | 2430743 | 2022-04-21 | Parker | Texas | 48367 | 34534 | 450 |
2402293 | 2402293 | 2022-04-13 | Carroll | Georgia | 13045 | 23769 | 450 |
2399038 | 2399038 | 2022-04-12 | Carroll | Georgia | 13045 | 23763 | 450 |
2379591 | 2379591 | 2022-04-06 | Newton | Georgia | 13217 | 24582 | 450 |
2376337 | 2376337 | 2022-04-05 | Newton | Georgia | 13217 | 24581 | 450 |
2338712 | 2338712 | 2022-03-24 | Alamance | North Carolina | 37001 | 46646 | 450 |
2335458 | 2335458 | 2022-03-23 | Alamance | North Carolina | 37001 | 46607 | 450 |
2332204 | 2332204 | 2022-03-22 | Alamance | North Carolina | 37001 | 46594 | 450 |
2333206 | 2333206 | 2022-03-22 | Washington | Utah | 49053 | 44654 | 450 |
2328951 | 2328951 | 2022-03-21 | Alamance | North Carolina | 37001 | 46595 | 450 |
2325699 | 2325699 | 2022-03-20 | Alamance | North Carolina | 37001 | 46565 | 450 |
2322446 | 2322446 | 2022-03-19 | Alamance | North Carolina | 37001 | 46565 | 450 |
2319192 | 2319192 | 2022-03-18 | Alamance | North Carolina | 37001 | 46565 | 450 |
2315938 | 2315938 | 2022-03-17 | Alamance | North Carolina | 37001 | 46564 | 450 |
2302466 | 2302466 | 2022-03-13 | Jackson | Mississippi | 28059 | 36768 | 450 |
2299214 | 2299214 | 2022-03-12 | Jackson | Mississippi | 28059 | 36768 | 450 |
2295962 | 2295962 | 2022-03-11 | Jackson | Mississippi | 28059 | 36768 | 450 |
2291576 | 2291576 | 2022-03-10 | Litchfield | Connecticut | 9005 | 31333 | 450 |
2292710 | 2292710 | 2022-03-10 | Jackson | Mississippi | 28059 | 36768 | 450 |
2288324 | 2288324 | 2022-03-09 | Litchfield | Connecticut | 9005 | 31324 | 450 |
2289458 | 2289458 | 2022-03-09 | Jackson | Mississippi | 28059 | 36768 | 450 |
2285073 | 2285073 | 2022-03-08 | Litchfield | Connecticut | 9005 | 31313 | 450 |
2286207 | 2286207 | 2022-03-08 | Jackson | Mississippi | 28059 | 36768 | 450 |
2287380 | 2287380 | 2022-03-08 | Unknown | Tennessee | 23804 | 450 | |
2261596 | 2261596 | 2022-02-28 | Tom Green | Texas | 48451 | 40803 | 450 |
2258345 | 2258345 | 2022-02-27 | Tom Green | Texas | 48451 | 40788 | 450 |
2258527 | 2258527 | 2022-02-27 | Richmond city | Virginia | 51760 | 43526 | 450 |
2255276 | 2255276 | 2022-02-26 | Richmond city | Virginia | 51760 | 43526 | 450 |
2252025 | 2252025 | 2022-02-25 | Richmond city | Virginia | 51760 | 43526 | 450 |
2248774 | 2248774 | 2022-02-24 | Richmond city | Virginia | 51760 | 43492 | 450 |
2197431 | 2197431 | 2022-02-09 | Houston | Georgia | 13153 | 38480 | 450 |
2198441 | 2198441 | 2022-02-09 | Rankin | Mississippi | 28121 | 35465 | 450 |
2199595 | 2199595 | 2022-02-09 | Angelina | Texas | 48005 | 15114 | 450 |
2196341 | 2196341 | 2022-02-08 | Angelina | Texas | 48005 | 15093 | 450 |
2193275 | 2193275 | 2022-02-07 | Randall | Texas | 48381 | 36749 | 450 |
2190021 | 2190021 | 2022-02-06 | Randall | Texas | 48381 | 36539 | 450 |
2186768 | 2186768 | 2022-02-05 | Randall | Texas | 48381 | 36539 | 450 |
2178857 | 2178857 | 2022-02-03 | Washington | Minnesota | 27163 | 63020 | 450 |
2171606 | 2171606 | 2022-02-01 | McHenry | Illinois | 17111 | 70258 | 450 |
2171943 | 2171943 | 2022-02-01 | Wyandotte | Kansas | 20209 | 44709 | 450 |
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);