ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
468 rows where deaths = 390 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Carolina 40
- Pennsylvania 35
- Ohio 32
- Indiana 30
- Georgia 24
- Oklahoma 23
- Texas 23
- Colorado 22
- Alabama 19
- Florida 19
- Michigan 19
- Louisiana 18
- Oregon 17
- North Carolina 16
- Maryland 13
- Wisconsin 11
- New York 10
- California 9
- Illinois 9
- Tennessee 9
- Virginia 9
- Utah 8
- Kentucky 7
- New Mexico 7
- Mississippi 6
- Arizona 5
- Arkansas 5
- Minnesota 5
- Montana 4
- Washington 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500001 | 2500001 | 2022-05-13 | Columbia | Georgia | 13073 | 36344 | 390 |
2501741 | 2501741 | 2022-05-13 | Canadian | Oklahoma | 40017 | 39889 | 390 |
2496743 | 2496743 | 2022-05-12 | Columbia | Georgia | 13073 | 36344 | 390 |
2498483 | 2498483 | 2022-05-12 | Canadian | Oklahoma | 40017 | 39889 | 390 |
2493485 | 2493485 | 2022-05-11 | Columbia | Georgia | 13073 | 36344 | 390 |
2495225 | 2495225 | 2022-05-11 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2490052 | 2490052 | 2022-05-10 | Boulder | Colorado | 8013 | 66988 | 390 |
2491967 | 2491967 | 2022-05-10 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2486795 | 2486795 | 2022-05-09 | Boulder | Colorado | 8013 | 66988 | 390 |
2488709 | 2488709 | 2022-05-09 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2484319 | 2484319 | 2022-05-08 | Daviess | Kentucky | 21059 | 31142 | 390 |
2485452 | 2485452 | 2022-05-08 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2481061 | 2481061 | 2022-05-07 | Daviess | Kentucky | 21059 | 31142 | 390 |
2482194 | 2482194 | 2022-05-07 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2477803 | 2477803 | 2022-05-06 | Daviess | Kentucky | 21059 | 31142 | 390 |
2478936 | 2478936 | 2022-05-06 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2474545 | 2474545 | 2022-05-05 | Daviess | Kentucky | 21059 | 31142 | 390 |
2475678 | 2475678 | 2022-05-05 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2471288 | 2471288 | 2022-05-04 | Daviess | Kentucky | 21059 | 31142 | 390 |
2468032 | 2468032 | 2022-05-03 | Daviess | Kentucky | 21059 | 31142 | 390 |
2464777 | 2464777 | 2022-05-02 | Daviess | Kentucky | 21059 | 31142 | 390 |
2449930 | 2449930 | 2022-04-27 | Sumter | South Carolina | 45085 | 27844 | 390 |
2446452 | 2446452 | 2022-04-26 | Douglas | Oregon | 41019 | 19806 | 390 |
2446673 | 2446673 | 2022-04-26 | Sumter | South Carolina | 45085 | 27844 | 390 |
2443197 | 2443197 | 2022-04-25 | Douglas | Oregon | 41019 | 19799 | 390 |
2443418 | 2443418 | 2022-04-25 | Sumter | South Carolina | 45085 | 27844 | 390 |
2439941 | 2439941 | 2022-04-24 | Douglas | Oregon | 41019 | 19796 | 390 |
2440162 | 2440162 | 2022-04-24 | Sumter | South Carolina | 45085 | 27844 | 390 |
2436685 | 2436685 | 2022-04-23 | Douglas | Oregon | 41019 | 19796 | 390 |
2436906 | 2436906 | 2022-04-23 | Sumter | South Carolina | 45085 | 27844 | 390 |
2433429 | 2433429 | 2022-04-22 | Douglas | Oregon | 41019 | 19796 | 390 |
2433650 | 2433650 | 2022-04-22 | Sumter | South Carolina | 45085 | 27844 | 390 |
2430173 | 2430173 | 2022-04-21 | Douglas | Oregon | 41019 | 19792 | 390 |
2430394 | 2430394 | 2022-04-21 | Sumter | South Carolina | 45085 | 27844 | 390 |
2426845 | 2426845 | 2022-04-20 | Comanche | Oklahoma | 40031 | 33062 | 390 |
2426917 | 2426917 | 2022-04-20 | Douglas | Oregon | 41019 | 19783 | 390 |
2427138 | 2427138 | 2022-04-20 | Sumter | South Carolina | 45085 | 27844 | 390 |
2421463 | 2421463 | 2022-04-19 | Marshall | Alabama | 1095 | 27354 | 390 |
2423589 | 2423589 | 2022-04-19 | Comanche | Oklahoma | 40031 | 33062 | 390 |
2423661 | 2423661 | 2022-04-19 | Douglas | Oregon | 41019 | 19775 | 390 |
2423882 | 2423882 | 2022-04-19 | Sumter | South Carolina | 45085 | 27844 | 390 |
2418207 | 2418207 | 2022-04-18 | Marshall | Alabama | 1095 | 27347 | 390 |
2420332 | 2420332 | 2022-04-18 | Comanche | Oklahoma | 40031 | 33062 | 390 |
2420626 | 2420626 | 2022-04-18 | Sumter | South Carolina | 45085 | 27811 | 390 |
2414951 | 2414951 | 2022-04-17 | Marshall | Alabama | 1095 | 27347 | 390 |
2417077 | 2417077 | 2022-04-17 | Comanche | Oklahoma | 40031 | 33062 | 390 |
2417370 | 2417370 | 2022-04-17 | Sumter | South Carolina | 45085 | 27811 | 390 |
2411695 | 2411695 | 2022-04-16 | Marshall | Alabama | 1095 | 27347 | 390 |
2413821 | 2413821 | 2022-04-16 | Comanche | Oklahoma | 40031 | 33062 | 390 |
2414114 | 2414114 | 2022-04-16 | Sumter | South Carolina | 45085 | 27811 | 390 |
2408439 | 2408439 | 2022-04-15 | Marshall | Alabama | 1095 | 27347 | 390 |
2410565 | 2410565 | 2022-04-15 | Comanche | Oklahoma | 40031 | 33062 | 390 |
2410858 | 2410858 | 2022-04-15 | Sumter | South Carolina | 45085 | 27811 | 390 |
2407309 | 2407309 | 2022-04-14 | Comanche | Oklahoma | 40031 | 33062 | 390 |
2407602 | 2407602 | 2022-04-14 | Sumter | South Carolina | 45085 | 27811 | 390 |
2404346 | 2404346 | 2022-04-13 | Sumter | South Carolina | 45085 | 27811 | 390 |
2398664 | 2398664 | 2022-04-12 | Lauderdale | Alabama | 1077 | 24099 | 390 |
2401091 | 2401091 | 2022-04-12 | Sumter | South Carolina | 45085 | 27811 | 390 |
2395409 | 2395409 | 2022-04-11 | Lauderdale | Alabama | 1077 | 24097 | 390 |
2397836 | 2397836 | 2022-04-11 | Sumter | South Carolina | 45085 | 27801 | 390 |
2392153 | 2392153 | 2022-04-10 | Lauderdale | Alabama | 1077 | 24094 | 390 |
2394581 | 2394581 | 2022-04-10 | Sumter | South Carolina | 45085 | 27801 | 390 |
2388897 | 2388897 | 2022-04-09 | Lauderdale | Alabama | 1077 | 24094 | 390 |
2391325 | 2391325 | 2022-04-09 | Sumter | South Carolina | 45085 | 27801 | 390 |
2385642 | 2385642 | 2022-04-08 | Lauderdale | Alabama | 1077 | 24094 | 390 |
2388069 | 2388069 | 2022-04-08 | Sumter | South Carolina | 45085 | 27801 | 390 |
2382387 | 2382387 | 2022-04-07 | Lauderdale | Alabama | 1077 | 24081 | 390 |
2384814 | 2384814 | 2022-04-07 | Sumter | South Carolina | 45085 | 27801 | 390 |
2379132 | 2379132 | 2022-04-06 | Lauderdale | Alabama | 1077 | 24081 | 390 |
2379542 | 2379542 | 2022-04-06 | Forsyth | Georgia | 13117 | 55430 | 390 |
2381559 | 2381559 | 2022-04-06 | Sumter | South Carolina | 45085 | 27801 | 390 |
2375878 | 2375878 | 2022-04-05 | Lauderdale | Alabama | 1077 | 24076 | 390 |
2376174 | 2376174 | 2022-04-05 | Columbia | Florida | 12023 | 21131 | 390 |
2378304 | 2378304 | 2022-04-05 | Sumter | South Carolina | 45085 | 27801 | 390 |
2372922 | 2372922 | 2022-04-04 | Columbia | Florida | 12023 | 21131 | 390 |
2369586 | 2369586 | 2022-04-03 | Boulder | Colorado | 8013 | 63465 | 390 |
2369669 | 2369669 | 2022-04-03 | Columbia | Florida | 12023 | 21131 | 390 |
2366333 | 2366333 | 2022-04-02 | Boulder | Colorado | 8013 | 63465 | 390 |
2366416 | 2366416 | 2022-04-02 | Columbia | Florida | 12023 | 21131 | 390 |
2363080 | 2363080 | 2022-04-01 | Boulder | Colorado | 8013 | 63465 | 390 |
2363163 | 2363163 | 2022-04-01 | Columbia | Florida | 12023 | 21131 | 390 |
2359826 | 2359826 | 2022-03-31 | Boulder | Colorado | 8013 | 63376 | 390 |
2359909 | 2359909 | 2022-03-31 | Columbia | Florida | 12023 | 21131 | 390 |
2360013 | 2360013 | 2022-03-31 | Douglas | Georgia | 13097 | 34820 | 390 |
2356572 | 2356572 | 2022-03-30 | Boulder | Colorado | 8013 | 63179 | 390 |
2356655 | 2356655 | 2022-03-30 | Columbia | Florida | 12023 | 21131 | 390 |
2359337 | 2359337 | 2022-03-30 | Newport News city | Virginia | 51700 | 36104 | 390 |
2353319 | 2353319 | 2022-03-29 | Boulder | Colorado | 8013 | 62941 | 390 |
2350067 | 2350067 | 2022-03-28 | Boulder | Colorado | 8013 | 62872 | 390 |
2331010 | 2331010 | 2022-03-22 | Clark | Indiana | 18019 | 31024 | 390 |
2327758 | 2327758 | 2022-03-21 | Clark | Indiana | 18019 | 31022 | 390 |
2329931 | 2329931 | 2022-03-21 | Davis | Utah | 49011 | 100039 | 390 |
2324505 | 2324505 | 2022-03-20 | Clark | Indiana | 18019 | 31015 | 390 |
2326993 | 2326993 | 2022-03-20 | Outagamie | Wisconsin | 55087 | 54082 | 390 |
2321251 | 2321251 | 2022-03-19 | Clark | Indiana | 18019 | 31015 | 390 |
2322379 | 2322379 | 2022-03-19 | Sandoval | New Mexico | 35043 | 33257 | 390 |
2323740 | 2323740 | 2022-03-19 | Outagamie | Wisconsin | 55087 | 54082 | 390 |
2317997 | 2317997 | 2022-03-18 | Clark | Indiana | 18019 | 31015 | 390 |
2319125 | 2319125 | 2022-03-18 | Sandoval | New Mexico | 35043 | 33257 | 390 |
2320486 | 2320486 | 2022-03-18 | Outagamie | Wisconsin | 55087 | 54082 | 390 |
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);