ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
230 rows where cases = 2776 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 38
- Florida 30
- Texas 17
- Indiana 15
- Kentucky 11
- Virginia 10
- Colorado 9
- Georgia 9
- Minnesota 8
- Illinois 7
- Iowa 7
- Arkansas 6
- Louisiana 6
- Missouri 5
- Arizona 4
- Ohio 4
- Tennessee 4
- California 3
- South Dakota 3
- West Virginia 3
- Idaho 2
- Maryland 2
- Michigan 2
- Nebraska 2
- Nevada 2
- New Mexico 2
- New York 2
- North Carolina 2
- Oregon 2
- Pennsylvania 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473631 | 2473631 | 2022-05-05 | Chicot | Arkansas | 5017 | 2776 | 60 |
2472443 | 2472443 | 2022-05-04 | Haskell | Oklahoma | 40061 | 2776 | 41 |
2469187 | 2469187 | 2022-05-03 | Haskell | Oklahoma | 40061 | 2776 | 41 |
2465931 | 2465931 | 2022-05-02 | Haskell | Oklahoma | 40061 | 2776 | 41 |
2462676 | 2462676 | 2022-05-01 | Haskell | Oklahoma | 40061 | 2776 | 41 |
2459420 | 2459420 | 2022-04-30 | Haskell | Oklahoma | 40061 | 2776 | 41 |
2456164 | 2456164 | 2022-04-29 | Haskell | Oklahoma | 40061 | 2776 | 41 |
2452908 | 2452908 | 2022-04-28 | Haskell | Oklahoma | 40061 | 2776 | 41 |
2428283 | 2428283 | 2022-04-21 | Lafayette | Florida | 12067 | 2776 | 61 |
2425027 | 2425027 | 2022-04-20 | Lafayette | Florida | 12067 | 2776 | 61 |
2426860 | 2426860 | 2022-04-20 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2421771 | 2421771 | 2022-04-19 | Lafayette | Florida | 12067 | 2776 | 61 |
2423604 | 2423604 | 2022-04-19 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2418515 | 2418515 | 2022-04-18 | Lafayette | Florida | 12067 | 2776 | 61 |
2420347 | 2420347 | 2022-04-18 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2415259 | 2415259 | 2022-04-17 | Lafayette | Florida | 12067 | 2776 | 61 |
2417092 | 2417092 | 2022-04-17 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2412003 | 2412003 | 2022-04-16 | Lafayette | Florida | 12067 | 2776 | 61 |
2413836 | 2413836 | 2022-04-16 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2408747 | 2408747 | 2022-04-15 | Lafayette | Florida | 12067 | 2776 | 61 |
2410580 | 2410580 | 2022-04-15 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2405491 | 2405491 | 2022-04-14 | Lafayette | Florida | 12067 | 2776 | 61 |
2407324 | 2407324 | 2022-04-14 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2402236 | 2402236 | 2022-04-13 | Lafayette | Florida | 12067 | 2776 | 61 |
2398981 | 2398981 | 2022-04-12 | Lafayette | Florida | 12067 | 2776 | 60 |
2395726 | 2395726 | 2022-04-11 | Lafayette | Florida | 12067 | 2776 | 60 |
2392470 | 2392470 | 2022-04-10 | Lafayette | Florida | 12067 | 2776 | 60 |
2389214 | 2389214 | 2022-04-09 | Lafayette | Florida | 12067 | 2776 | 60 |
2385959 | 2385959 | 2022-04-08 | Lafayette | Florida | 12067 | 2776 | 60 |
2382704 | 2382704 | 2022-04-07 | Lafayette | Florida | 12067 | 2776 | 60 |
2382830 | 2382830 | 2022-04-07 | Long | Georgia | 13183 | 2776 | 34 |
2379449 | 2379449 | 2022-04-06 | Lafayette | Florida | 12067 | 2776 | 60 |
2381281 | 2381281 | 2022-04-06 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2376195 | 2376195 | 2022-04-05 | Lafayette | Florida | 12067 | 2776 | 59 |
2376321 | 2376321 | 2022-04-05 | Long | Georgia | 13183 | 2776 | 34 |
2378026 | 2378026 | 2022-04-05 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2372943 | 2372943 | 2022-04-04 | Lafayette | Florida | 12067 | 2776 | 59 |
2374772 | 2374772 | 2022-04-04 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2369690 | 2369690 | 2022-04-03 | Lafayette | Florida | 12067 | 2776 | 59 |
2371520 | 2371520 | 2022-04-03 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2366437 | 2366437 | 2022-04-02 | Lafayette | Florida | 12067 | 2776 | 59 |
2368267 | 2368267 | 2022-04-02 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2363184 | 2363184 | 2022-04-01 | Lafayette | Florida | 12067 | 2776 | 59 |
2365014 | 2365014 | 2022-04-01 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2359930 | 2359930 | 2022-03-31 | Lafayette | Florida | 12067 | 2776 | 59 |
2361761 | 2361761 | 2022-03-31 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2356676 | 2356676 | 2022-03-30 | Lafayette | Florida | 12067 | 2776 | 59 |
2353423 | 2353423 | 2022-03-29 | Lafayette | Florida | 12067 | 2776 | 58 |
2350171 | 2350171 | 2022-03-28 | Lafayette | Florida | 12067 | 2776 | 58 |
2346918 | 2346918 | 2022-03-27 | Lafayette | Florida | 12067 | 2776 | 58 |
2343665 | 2343665 | 2022-03-26 | Lafayette | Florida | 12067 | 2776 | 58 |
2340412 | 2340412 | 2022-03-25 | Lafayette | Florida | 12067 | 2776 | 58 |
2330588 | 2330588 | 2022-03-22 | Park | Colorado | 8093 | 2776 | 20 |
2312962 | 2312962 | 2022-03-16 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2312984 | 2312984 | 2022-03-16 | Nowata | Oklahoma | 40105 | 2776 | 36 |
2309709 | 2309709 | 2022-03-15 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2309731 | 2309731 | 2022-03-15 | Nowata | Oklahoma | 40105 | 2776 | 36 |
2306456 | 2306456 | 2022-03-14 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2306478 | 2306478 | 2022-03-14 | Nowata | Oklahoma | 40105 | 2776 | 36 |
2303205 | 2303205 | 2022-03-13 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2303227 | 2303227 | 2022-03-13 | Nowata | Oklahoma | 40105 | 2776 | 36 |
2299953 | 2299953 | 2022-03-12 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2299975 | 2299975 | 2022-03-12 | Nowata | Oklahoma | 40105 | 2776 | 36 |
2296701 | 2296701 | 2022-03-11 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2296723 | 2296723 | 2022-03-11 | Nowata | Oklahoma | 40105 | 2776 | 36 |
2293449 | 2293449 | 2022-03-10 | Haskell | Oklahoma | 40061 | 2776 | 39 |
2293471 | 2293471 | 2022-03-10 | Nowata | Oklahoma | 40105 | 2776 | 36 |
2290707 | 2290707 | 2022-03-09 | Eastland | Texas | 48133 | 2776 | 111 |
2258151 | 2258151 | 2022-02-27 | Camp | Texas | 48063 | 2776 | 72 |
2254900 | 2254900 | 2022-02-26 | Camp | Texas | 48063 | 2776 | 72 |
2205861 | 2205861 | 2022-02-11 | Orocovis | Puerto Rico | 72107 | 2776 | |
2197213 | 2197213 | 2022-02-09 | Archuleta | Colorado | 8007 | 2776 | 11 |
2193774 | 2193774 | 2022-02-08 | Wilcox | Alabama | 1131 | 2776 | 40 |
2167907 | 2167907 | 2022-01-31 | Plumas | California | 6063 | 2776 | 12 |
2169028 | 2169028 | 2022-01-31 | Chippewa | Minnesota | 27023 | 2776 | 46 |
2164583 | 2164583 | 2022-01-30 | Lee | Arkansas | 5077 | 2776 | 54 |
2161328 | 2161328 | 2022-01-29 | Lee | Arkansas | 5077 | 2776 | 54 |
2158072 | 2158072 | 2022-01-28 | Lee | Arkansas | 5077 | 2776 | 54 |
2156908 | 2156908 | 2022-01-27 | Curry | Oregon | 41015 | 2776 | 41 |
2157080 | 2157080 | 2022-01-27 | Villalba | Puerto Rico | 72149 | 2776 | |
2150010 | 2150010 | 2022-01-25 | Torrance | New Mexico | 35057 | 2776 | 44 |
2134774 | 2134774 | 2022-01-20 | Zapata | Texas | 48505 | 2776 | 47 |
2106912 | 2106912 | 2022-01-12 | Estill | Kentucky | 21065 | 2776 | 38 |
2104011 | 2104011 | 2022-01-11 | Pennington | Minnesota | 27113 | 2776 | 33 |
2080702 | 2080702 | 2022-01-04 | Hamilton | Iowa | 19079 | 2776 | 60 |
2077450 | 2077450 | 2022-01-03 | Hamilton | Iowa | 19079 | 2776 | 60 |
2074030 | 2074030 | 2022-01-02 | Mercer | Illinois | 17131 | 2776 | 38 |
2074130 | 2074130 | 2022-01-02 | Pike | Indiana | 18125 | 2776 | 46 |
2074199 | 2074199 | 2022-01-02 | Hamilton | Iowa | 19079 | 2776 | 60 |
2070779 | 2070779 | 2022-01-01 | Mercer | Illinois | 17131 | 2776 | 38 |
2070879 | 2070879 | 2022-01-01 | Pike | Indiana | 18125 | 2776 | 46 |
2070948 | 2070948 | 2022-01-01 | Hamilton | Iowa | 19079 | 2776 | 60 |
2067528 | 2067528 | 2021-12-31 | Mercer | Illinois | 17131 | 2776 | 38 |
2067628 | 2067628 | 2021-12-31 | Pike | Indiana | 18125 | 2776 | 46 |
2067697 | 2067697 | 2021-12-31 | Hamilton | Iowa | 19079 | 2776 | 60 |
2064277 | 2064277 | 2021-12-30 | Mercer | Illinois | 17131 | 2776 | 38 |
2064377 | 2064377 | 2021-12-30 | Pike | Indiana | 18125 | 2776 | 46 |
2064446 | 2064446 | 2021-12-30 | Hamilton | Iowa | 19079 | 2776 | 60 |
2061196 | 2061196 | 2021-12-29 | Hamilton | Iowa | 19079 | 2776 | 60 |
2011762 | 2011762 | 2021-12-14 | Madison | Arkansas | 5087 | 2776 | 44 |
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);