ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
463 rows where deaths = 475 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 91
- Missouri 44
- Florida 26
- Georgia 24
- Minnesota 23
- Texas 23
- Virginia 23
- New Jersey 22
- California 19
- Michigan 18
- Louisiana 16
- Pennsylvania 16
- Tennessee 15
- Illinois 13
- Indiana 13
- South Carolina 13
- New York 9
- Iowa 7
- Montana 7
- Idaho 5
- Wisconsin 5
- Arkansas 4
- Oregon 4
- Alabama 3
- Delaware 3
- Nebraska 3
- Washington 3
- North Carolina 2
- Arizona 1
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500878 | 2500878 | 2022-05-13 | Monroe | Michigan | 26115 | 39169 | 475 |
2501688 | 2501688 | 2022-05-13 | Licking | Ohio | 39089 | 42276 | 475 |
2497620 | 2497620 | 2022-05-12 | Monroe | Michigan | 26115 | 39169 | 475 |
2498430 | 2498430 | 2022-05-12 | Licking | Ohio | 39089 | 42276 | 475 |
2494362 | 2494362 | 2022-05-11 | Monroe | Michigan | 26115 | 39169 | 475 |
2494874 | 2494874 | 2022-05-11 | Sussex | New Jersey | 34037 | 35296 | 475 |
2495172 | 2495172 | 2022-05-11 | Licking | Ohio | 39089 | 42060 | 475 |
2496079 | 2496079 | 2022-05-11 | Norfolk city | Virginia | 51710 | 43012 | 475 |
2491104 | 2491104 | 2022-05-10 | Monroe | Michigan | 26115 | 38646 | 475 |
2491616 | 2491616 | 2022-05-10 | Sussex | New Jersey | 34037 | 35223 | 475 |
2491914 | 2491914 | 2022-05-10 | Licking | Ohio | 39089 | 42060 | 475 |
2492821 | 2492821 | 2022-05-10 | Norfolk city | Virginia | 51710 | 42976 | 475 |
2487847 | 2487847 | 2022-05-09 | Monroe | Michigan | 26115 | 38646 | 475 |
2488358 | 2488358 | 2022-05-09 | Sussex | New Jersey | 34037 | 35162 | 475 |
2488656 | 2488656 | 2022-05-09 | Licking | Ohio | 39089 | 42060 | 475 |
2489563 | 2489563 | 2022-05-09 | Norfolk city | Virginia | 51710 | 42945 | 475 |
2484589 | 2484589 | 2022-05-08 | Monroe | Michigan | 26115 | 38646 | 475 |
2485101 | 2485101 | 2022-05-08 | Sussex | New Jersey | 34037 | 35129 | 475 |
2485399 | 2485399 | 2022-05-08 | Licking | Ohio | 39089 | 42060 | 475 |
2486306 | 2486306 | 2022-05-08 | Norfolk city | Virginia | 51710 | 42864 | 475 |
2481331 | 2481331 | 2022-05-07 | Monroe | Michigan | 26115 | 38646 | 475 |
2481843 | 2481843 | 2022-05-07 | Sussex | New Jersey | 34037 | 35075 | 475 |
2482141 | 2482141 | 2022-05-07 | Licking | Ohio | 39089 | 42060 | 475 |
2483048 | 2483048 | 2022-05-07 | Norfolk city | Virginia | 51710 | 42864 | 475 |
2478073 | 2478073 | 2022-05-06 | Monroe | Michigan | 26115 | 38646 | 475 |
2478585 | 2478585 | 2022-05-06 | Sussex | New Jersey | 34037 | 35026 | 475 |
2478883 | 2478883 | 2022-05-06 | Licking | Ohio | 39089 | 42060 | 475 |
2479790 | 2479790 | 2022-05-06 | Norfolk city | Virginia | 51710 | 42864 | 475 |
2474815 | 2474815 | 2022-05-05 | Monroe | Michigan | 26115 | 38646 | 475 |
2475327 | 2475327 | 2022-05-05 | Sussex | New Jersey | 34037 | 34966 | 475 |
2475625 | 2475625 | 2022-05-05 | Licking | Ohio | 39089 | 42060 | 475 |
2476532 | 2476532 | 2022-05-05 | Norfolk city | Virginia | 51710 | 42831 | 475 |
2471558 | 2471558 | 2022-05-04 | Monroe | Michigan | 26115 | 38646 | 475 |
2472070 | 2472070 | 2022-05-04 | Sussex | New Jersey | 34037 | 34891 | 475 |
2472368 | 2472368 | 2022-05-04 | Licking | Ohio | 39089 | 41913 | 475 |
2473274 | 2473274 | 2022-05-04 | Norfolk city | Virginia | 51710 | 42781 | 475 |
2468814 | 2468814 | 2022-05-03 | Sussex | New Jersey | 34037 | 34844 | 475 |
2469112 | 2469112 | 2022-05-03 | Licking | Ohio | 39089 | 41913 | 475 |
2470018 | 2470018 | 2022-05-03 | Norfolk city | Virginia | 51710 | 42738 | 475 |
2465558 | 2465558 | 2022-05-02 | Sussex | New Jersey | 34037 | 34808 | 475 |
2465856 | 2465856 | 2022-05-02 | Licking | Ohio | 39089 | 41913 | 475 |
2466762 | 2466762 | 2022-05-02 | Norfolk city | Virginia | 51710 | 42723 | 475 |
2462303 | 2462303 | 2022-05-01 | Sussex | New Jersey | 34037 | 34756 | 475 |
2462601 | 2462601 | 2022-05-01 | Licking | Ohio | 39089 | 41913 | 475 |
2463507 | 2463507 | 2022-05-01 | Norfolk city | Virginia | 51710 | 42568 | 475 |
2459047 | 2459047 | 2022-04-30 | Sussex | New Jersey | 34037 | 34731 | 475 |
2459345 | 2459345 | 2022-04-30 | Licking | Ohio | 39089 | 41913 | 475 |
2460251 | 2460251 | 2022-04-30 | Norfolk city | Virginia | 51710 | 42568 | 475 |
2455791 | 2455791 | 2022-04-29 | Sussex | New Jersey | 34037 | 34673 | 475 |
2456089 | 2456089 | 2022-04-29 | Licking | Ohio | 39089 | 41913 | 475 |
2456995 | 2456995 | 2022-04-29 | Norfolk city | Virginia | 51710 | 42568 | 475 |
2452535 | 2452535 | 2022-04-28 | Sussex | New Jersey | 34037 | 34630 | 475 |
2452833 | 2452833 | 2022-04-28 | Licking | Ohio | 39089 | 41913 | 475 |
2453739 | 2453739 | 2022-04-28 | Norfolk city | Virginia | 51710 | 42510 | 475 |
2449279 | 2449279 | 2022-04-27 | Sussex | New Jersey | 34037 | 34594 | 475 |
2449577 | 2449577 | 2022-04-27 | Licking | Ohio | 39089 | 41793 | 475 |
2450483 | 2450483 | 2022-04-27 | Norfolk city | Virginia | 51710 | 42483 | 475 |
2445012 | 2445012 | 2022-04-26 | Black Hawk | Iowa | 19013 | 32802 | 475 |
2446022 | 2446022 | 2022-04-26 | Sussex | New Jersey | 34037 | 34547 | 475 |
2446320 | 2446320 | 2022-04-26 | Licking | Ohio | 39089 | 41793 | 475 |
2447226 | 2447226 | 2022-04-26 | Norfolk city | Virginia | 51710 | 42470 | 475 |
2441756 | 2441756 | 2022-04-25 | Black Hawk | Iowa | 19013 | 32802 | 475 |
2442767 | 2442767 | 2022-04-25 | Sussex | New Jersey | 34037 | 34513 | 475 |
2443065 | 2443065 | 2022-04-25 | Licking | Ohio | 39089 | 41793 | 475 |
2443971 | 2443971 | 2022-04-25 | Norfolk city | Virginia | 51710 | 42452 | 475 |
2438500 | 2438500 | 2022-04-24 | Black Hawk | Iowa | 19013 | 32802 | 475 |
2439809 | 2439809 | 2022-04-24 | Licking | Ohio | 39089 | 41793 | 475 |
2440715 | 2440715 | 2022-04-24 | Norfolk city | Virginia | 51710 | 42400 | 475 |
2435244 | 2435244 | 2022-04-23 | Black Hawk | Iowa | 19013 | 32802 | 475 |
2436553 | 2436553 | 2022-04-23 | Licking | Ohio | 39089 | 41793 | 475 |
2437459 | 2437459 | 2022-04-23 | Norfolk city | Virginia | 51710 | 42400 | 475 |
2431988 | 2431988 | 2022-04-22 | Black Hawk | Iowa | 19013 | 32802 | 475 |
2433297 | 2433297 | 2022-04-22 | Licking | Ohio | 39089 | 41793 | 475 |
2434203 | 2434203 | 2022-04-22 | Norfolk city | Virginia | 51710 | 42400 | 475 |
2428732 | 2428732 | 2022-04-21 | Black Hawk | Iowa | 19013 | 32802 | 475 |
2430041 | 2430041 | 2022-04-21 | Licking | Ohio | 39089 | 41793 | 475 |
2430947 | 2430947 | 2022-04-21 | Norfolk city | Virginia | 51710 | 42366 | 475 |
2425476 | 2425476 | 2022-04-20 | Black Hawk | Iowa | 19013 | 32802 | 475 |
2426785 | 2426785 | 2022-04-20 | Licking | Ohio | 39089 | 41726 | 475 |
2423529 | 2423529 | 2022-04-19 | Licking | Ohio | 39089 | 41726 | 475 |
2420272 | 2420272 | 2022-04-18 | Licking | Ohio | 39089 | 41726 | 475 |
2417017 | 2417017 | 2022-04-17 | Licking | Ohio | 39089 | 41726 | 475 |
2413761 | 2413761 | 2022-04-16 | Licking | Ohio | 39089 | 41726 | 475 |
2410505 | 2410505 | 2022-04-15 | Licking | Ohio | 39089 | 41726 | 475 |
2407249 | 2407249 | 2022-04-14 | Licking | Ohio | 39089 | 41726 | 475 |
2403993 | 2403993 | 2022-04-13 | Licking | Ohio | 39089 | 41662 | 475 |
2400738 | 2400738 | 2022-04-12 | Licking | Ohio | 39089 | 41662 | 475 |
2397483 | 2397483 | 2022-04-11 | Licking | Ohio | 39089 | 41662 | 475 |
2394228 | 2394228 | 2022-04-10 | Licking | Ohio | 39089 | 41662 | 475 |
2390972 | 2390972 | 2022-04-09 | Licking | Ohio | 39089 | 41662 | 475 |
2387716 | 2387716 | 2022-04-08 | Licking | Ohio | 39089 | 41662 | 475 |
2382575 | 2382575 | 2022-04-07 | San Luis Obispo | California | 6079 | 56337 | 475 |
2384461 | 2384461 | 2022-04-07 | Licking | Ohio | 39089 | 41662 | 475 |
2379320 | 2379320 | 2022-04-06 | San Luis Obispo | California | 6079 | 56337 | 475 |
2379522 | 2379522 | 2022-04-06 | Coweta | Georgia | 13077 | 32921 | 475 |
2381206 | 2381206 | 2022-04-06 | Licking | Ohio | 39089 | 41601 | 475 |
2376066 | 2376066 | 2022-04-05 | San Luis Obispo | California | 6079 | 56337 | 475 |
2377951 | 2377951 | 2022-04-05 | Licking | Ohio | 39089 | 41601 | 475 |
2372814 | 2372814 | 2022-04-04 | San Luis Obispo | California | 6079 | 56292 | 475 |
2374697 | 2374697 | 2022-04-04 | Licking | Ohio | 39089 | 41601 | 475 |
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);