ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
722 rows where deaths = 323 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 61
- Mississippi 54
- Tennessee 53
- Texas 52
- Pennsylvania 50
- North Carolina 45
- Illinois 34
- California 31
- Georgia 31
- New York 22
- Virginia 21
- Michigan 20
- New Mexico 18
- Alabama 17
- Massachusetts 16
- South Carolina 15
- Florida 14
- Indiana 14
- Minnesota 14
- Oregon 13
- Delaware 12
- Montana 11
- Colorado 10
- Louisiana 10
- Ohio 10
- Washington 8
- Oklahoma 7
- Wisconsin 7
- Idaho 6
- Arizona 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491774 | 2491774 | 2022-05-10 | Moore | North Carolina | 37125 | 24449 | 323 |
2488516 | 2488516 | 2022-05-09 | Moore | North Carolina | 37125 | 24449 | 323 |
2485259 | 2485259 | 2022-05-08 | Moore | North Carolina | 37125 | 24449 | 323 |
2482001 | 2482001 | 2022-05-07 | Moore | North Carolina | 37125 | 24449 | 323 |
2478743 | 2478743 | 2022-05-06 | Moore | North Carolina | 37125 | 24449 | 323 |
2475485 | 2475485 | 2022-05-05 | Moore | North Carolina | 37125 | 24449 | 323 |
2472228 | 2472228 | 2022-05-04 | Moore | North Carolina | 37125 | 24449 | 323 |
2469940 | 2469940 | 2022-05-03 | Arlington | Virginia | 51013 | 44502 | 323 |
2466684 | 2466684 | 2022-05-02 | Arlington | Virginia | 51013 | 44427 | 323 |
2463429 | 2463429 | 2022-05-01 | Arlington | Virginia | 51013 | 44070 | 323 |
2460173 | 2460173 | 2022-04-30 | Arlington | Virginia | 51013 | 44070 | 323 |
2456917 | 2456917 | 2022-04-29 | Arlington | Virginia | 51013 | 44070 | 323 |
2453661 | 2453661 | 2022-04-28 | Arlington | Virginia | 51013 | 43943 | 323 |
2449285 | 2449285 | 2022-04-27 | Chaves | New Mexico | 35005 | 21729 | 323 |
2450405 | 2450405 | 2022-04-27 | Arlington | Virginia | 51013 | 43805 | 323 |
2446028 | 2446028 | 2022-04-26 | Chaves | New Mexico | 35005 | 21729 | 323 |
2447148 | 2447148 | 2022-04-26 | Arlington | Virginia | 51013 | 43666 | 323 |
2442773 | 2442773 | 2022-04-25 | Chaves | New Mexico | 35005 | 21729 | 323 |
2443893 | 2443893 | 2022-04-25 | Arlington | Virginia | 51013 | 43584 | 323 |
2439320 | 2439320 | 2022-04-24 | Cascade | Montana | 30013 | 25157 | 323 |
2439517 | 2439517 | 2022-04-24 | Chaves | New Mexico | 35005 | 21725 | 323 |
2440637 | 2440637 | 2022-04-24 | Arlington | Virginia | 51013 | 43329 | 323 |
2436064 | 2436064 | 2022-04-23 | Cascade | Montana | 30013 | 25157 | 323 |
2436261 | 2436261 | 2022-04-23 | Chaves | New Mexico | 35005 | 21725 | 323 |
2437381 | 2437381 | 2022-04-23 | Arlington | Virginia | 51013 | 43329 | 323 |
2432808 | 2432808 | 2022-04-22 | Cascade | Montana | 30013 | 25157 | 323 |
2433005 | 2433005 | 2022-04-22 | Chaves | New Mexico | 35005 | 21725 | 323 |
2434125 | 2434125 | 2022-04-22 | Arlington | Virginia | 51013 | 43329 | 323 |
2429552 | 2429552 | 2022-04-21 | Cascade | Montana | 30013 | 25155 | 323 |
2429749 | 2429749 | 2022-04-21 | Chaves | New Mexico | 35005 | 21723 | 323 |
2426296 | 2426296 | 2022-04-20 | Cascade | Montana | 30013 | 25156 | 323 |
2426493 | 2426493 | 2022-04-20 | Chaves | New Mexico | 35005 | 21722 | 323 |
2423040 | 2423040 | 2022-04-19 | Cascade | Montana | 30013 | 25152 | 323 |
2423237 | 2423237 | 2022-04-19 | Chaves | New Mexico | 35005 | 21723 | 323 |
2419783 | 2419783 | 2022-04-18 | Cascade | Montana | 30013 | 25145 | 323 |
2419980 | 2419980 | 2022-04-18 | Chaves | New Mexico | 35005 | 21720 | 323 |
2416528 | 2416528 | 2022-04-17 | Cascade | Montana | 30013 | 25142 | 323 |
2416725 | 2416725 | 2022-04-17 | Chaves | New Mexico | 35005 | 21710 | 323 |
2413272 | 2413272 | 2022-04-16 | Cascade | Montana | 30013 | 25142 | 323 |
2413469 | 2413469 | 2022-04-16 | Chaves | New Mexico | 35005 | 21710 | 323 |
2410016 | 2410016 | 2022-04-15 | Cascade | Montana | 30013 | 25142 | 323 |
2410213 | 2410213 | 2022-04-15 | Chaves | New Mexico | 35005 | 21710 | 323 |
2411015 | 2411015 | 2022-04-15 | Unknown | Tennessee | 18830 | 323 | |
2406760 | 2406760 | 2022-04-14 | Cascade | Montana | 30013 | 25136 | 323 |
2406957 | 2406957 | 2022-04-14 | Chaves | New Mexico | 35005 | 21709 | 323 |
2396568 | 2396568 | 2022-04-11 | Penobscot | Maine | 23019 | 27554 | 323 |
2393313 | 2393313 | 2022-04-10 | Penobscot | Maine | 23019 | 27554 | 323 |
2390057 | 2390057 | 2022-04-09 | Penobscot | Maine | 23019 | 27554 | 323 |
2386801 | 2386801 | 2022-04-08 | Penobscot | Maine | 23019 | 27528 | 323 |
2383546 | 2383546 | 2022-04-07 | Penobscot | Maine | 23019 | 27496 | 323 |
2385337 | 2385337 | 2022-04-07 | Hampton city | Virginia | 51650 | 27581 | 323 |
2378374 | 2378374 | 2022-04-05 | Anderson | Tennessee | 47001 | 22060 | 323 |
2375120 | 2375120 | 2022-04-04 | Anderson | Tennessee | 47001 | 22060 | 323 |
2371868 | 2371868 | 2022-04-03 | Anderson | Tennessee | 47001 | 22060 | 323 |
2368615 | 2368615 | 2022-04-02 | Anderson | Tennessee | 47001 | 22060 | 323 |
2365362 | 2365362 | 2022-04-01 | Anderson | Tennessee | 47001 | 22060 | 323 |
2362109 | 2362109 | 2022-03-31 | Anderson | Tennessee | 47001 | 22060 | 323 |
2358855 | 2358855 | 2022-03-30 | Anderson | Tennessee | 47001 | 22060 | 323 |
2354357 | 2354357 | 2022-03-29 | Lenawee | Michigan | 26091 | 25883 | 323 |
2354898 | 2354898 | 2022-03-29 | Lea | New Mexico | 35025 | 20119 | 323 |
2351105 | 2351105 | 2022-03-28 | Lenawee | Michigan | 26091 | 25883 | 323 |
2346587 | 2346587 | 2022-03-27 | DeKalb | Alabama | 1049 | 18735 | 323 |
2343334 | 2343334 | 2022-03-26 | DeKalb | Alabama | 1049 | 18735 | 323 |
2340081 | 2340081 | 2022-03-25 | DeKalb | Alabama | 1049 | 18735 | 323 |
2336828 | 2336828 | 2022-03-24 | DeKalb | Alabama | 1049 | 18734 | 323 |
2338694 | 2338694 | 2022-03-24 | Saratoga | New York | 36091 | 45762 | 323 |
2333574 | 2333574 | 2022-03-23 | DeKalb | Alabama | 1049 | 18733 | 323 |
2335440 | 2335440 | 2022-03-23 | Saratoga | New York | 36091 | 45734 | 323 |
2330320 | 2330320 | 2022-03-22 | DeKalb | Alabama | 1049 | 18730 | 323 |
2332186 | 2332186 | 2022-03-22 | Saratoga | New York | 36091 | 45679 | 323 |
2332838 | 2332838 | 2022-03-22 | Carter | Tennessee | 47019 | 16416 | 323 |
2327068 | 2327068 | 2022-03-21 | DeKalb | Alabama | 1049 | 18730 | 323 |
2328933 | 2328933 | 2022-03-21 | Saratoga | New York | 36091 | 45661 | 323 |
2329585 | 2329585 | 2022-03-21 | Carter | Tennessee | 47019 | 16416 | 323 |
2325251 | 2325251 | 2022-03-20 | Madison | Mississippi | 28089 | 23930 | 323 |
2325681 | 2325681 | 2022-03-20 | Saratoga | New York | 36091 | 45648 | 323 |
2326333 | 2326333 | 2022-03-20 | Carter | Tennessee | 47019 | 16416 | 323 |
2321997 | 2321997 | 2022-03-19 | Madison | Mississippi | 28089 | 23930 | 323 |
2322428 | 2322428 | 2022-03-19 | Saratoga | New York | 36091 | 45629 | 323 |
2323080 | 2323080 | 2022-03-19 | Carter | Tennessee | 47019 | 16416 | 323 |
2318743 | 2318743 | 2022-03-18 | Madison | Mississippi | 28089 | 23930 | 323 |
2319174 | 2319174 | 2022-03-18 | Saratoga | New York | 36091 | 45609 | 323 |
2319826 | 2319826 | 2022-03-18 | Carter | Tennessee | 47019 | 16416 | 323 |
2315490 | 2315490 | 2022-03-17 | Madison | Mississippi | 28089 | 23930 | 323 |
2315920 | 2315920 | 2022-03-17 | Saratoga | New York | 36091 | 45580 | 323 |
2316572 | 2316572 | 2022-03-17 | Carter | Tennessee | 47019 | 16416 | 323 |
2312237 | 2312237 | 2022-03-16 | Madison | Mississippi | 28089 | 23930 | 323 |
2312667 | 2312667 | 2022-03-16 | Saratoga | New York | 36091 | 45527 | 323 |
2312982 | 2312982 | 2022-03-16 | Muskogee | Oklahoma | 40101 | 19865 | 323 |
2313319 | 2313319 | 2022-03-16 | Carter | Tennessee | 47019 | 16416 | 323 |
2307696 | 2307696 | 2022-03-15 | Saline | Arkansas | 5125 | 30684 | 323 |
2308984 | 2308984 | 2022-03-15 | Madison | Mississippi | 28089 | 23930 | 323 |
2309414 | 2309414 | 2022-03-15 | Saratoga | New York | 36091 | 45492 | 323 |
2309729 | 2309729 | 2022-03-15 | Muskogee | Oklahoma | 40101 | 19865 | 323 |
2310748 | 2310748 | 2022-03-15 | Washington | Wisconsin | 55131 | 37825 | 323 |
2304399 | 2304399 | 2022-03-14 | Craighead | Arkansas | 5031 | 37021 | 323 |
2304938 | 2304938 | 2022-03-14 | McLean | Illinois | 17113 | 49218 | 323 |
2305733 | 2305733 | 2022-03-14 | Madison | Mississippi | 28089 | 23930 | 323 |
2306161 | 2306161 | 2022-03-14 | Saratoga | New York | 36091 | 45478 | 323 |
2306476 | 2306476 | 2022-03-14 | Muskogee | Oklahoma | 40101 | 19865 | 323 |
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);