ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
712 rows where deaths = 305 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Carolina 60
- Pennsylvania 59
- Minnesota 47
- North Carolina 46
- Texas 38
- Ohio 36
- Illinois 33
- Florida 30
- Georgia 30
- Tennessee 27
- Michigan 26
- Iowa 24
- Virginia 24
- Alabama 20
- Maryland 20
- Wisconsin 19
- Missouri 18
- Washington 18
- Louisiana 16
- Oklahoma 14
- Arizona 11
- New Jersey 11
- New Mexico 11
- Colorado 9
- New York 9
- Oregon 8
- California 7
- Idaho 7
- Indiana 7
- Mississippi 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499892 | 2499892 | 2022-05-13 | Windham | Connecticut | 9015 | 26643 | 305 |
2500991 | 2500991 | 2022-05-13 | Wright | Minnesota | 27171 | 37182 | 305 |
2501469 | 2501469 | 2022-05-13 | Schenectady | New York | 36093 | 35317 | 305 |
2502022 | 2502022 | 2022-05-13 | Greenwood | South Carolina | 45047 | 22607 | 305 |
2502184 | 2502184 | 2022-05-13 | Robertson | Tennessee | 47147 | 21626 | 305 |
2496634 | 2496634 | 2022-05-12 | Windham | Connecticut | 9015 | 26594 | 305 |
2497733 | 2497733 | 2022-05-12 | Wright | Minnesota | 27171 | 37142 | 305 |
2498211 | 2498211 | 2022-05-12 | Schenectady | New York | 36093 | 35317 | 305 |
2498764 | 2498764 | 2022-05-12 | Greenwood | South Carolina | 45047 | 22607 | 305 |
2498926 | 2498926 | 2022-05-12 | Robertson | Tennessee | 47147 | 21626 | 305 |
2493376 | 2493376 | 2022-05-11 | Windham | Connecticut | 9015 | 26526 | 305 |
2494475 | 2494475 | 2022-05-11 | Wright | Minnesota | 27171 | 37090 | 305 |
2494953 | 2494953 | 2022-05-11 | Schenectady | New York | 36093 | 35186 | 305 |
2495506 | 2495506 | 2022-05-11 | Greenwood | South Carolina | 45047 | 22607 | 305 |
2495668 | 2495668 | 2022-05-11 | Robertson | Tennessee | 47147 | 21626 | 305 |
2490118 | 2490118 | 2022-05-10 | Windham | Connecticut | 9015 | 26461 | 305 |
2491217 | 2491217 | 2022-05-10 | Wright | Minnesota | 27171 | 37060 | 305 |
2491695 | 2491695 | 2022-05-10 | Schenectady | New York | 36093 | 35099 | 305 |
2492248 | 2492248 | 2022-05-10 | Greenwood | South Carolina | 45047 | 22593 | 305 |
2492410 | 2492410 | 2022-05-10 | Robertson | Tennessee | 47147 | 21592 | 305 |
2487960 | 2487960 | 2022-05-09 | Wright | Minnesota | 27171 | 36972 | 305 |
2488990 | 2488990 | 2022-05-09 | Greenwood | South Carolina | 45047 | 22593 | 305 |
2489152 | 2489152 | 2022-05-09 | Robertson | Tennessee | 47147 | 21592 | 305 |
2484702 | 2484702 | 2022-05-08 | Wright | Minnesota | 27171 | 36938 | 305 |
2485733 | 2485733 | 2022-05-08 | Greenwood | South Carolina | 45047 | 22593 | 305 |
2485895 | 2485895 | 2022-05-08 | Robertson | Tennessee | 47147 | 21592 | 305 |
2481444 | 2481444 | 2022-05-07 | Wright | Minnesota | 27171 | 36938 | 305 |
2482475 | 2482475 | 2022-05-07 | Greenwood | South Carolina | 45047 | 22593 | 305 |
2482637 | 2482637 | 2022-05-07 | Robertson | Tennessee | 47147 | 21592 | 305 |
2478186 | 2478186 | 2022-05-06 | Wright | Minnesota | 27171 | 36938 | 305 |
2479217 | 2479217 | 2022-05-06 | Greenwood | South Carolina | 45047 | 22593 | 305 |
2479379 | 2479379 | 2022-05-06 | Robertson | Tennessee | 47147 | 21592 | 305 |
2474928 | 2474928 | 2022-05-05 | Wright | Minnesota | 27171 | 36905 | 305 |
2475959 | 2475959 | 2022-05-05 | Greenwood | South Carolina | 45047 | 22593 | 305 |
2476121 | 2476121 | 2022-05-05 | Robertson | Tennessee | 47147 | 21592 | 305 |
2471671 | 2471671 | 2022-05-04 | Wright | Minnesota | 27171 | 36880 | 305 |
2472702 | 2472702 | 2022-05-04 | Greenwood | South Carolina | 45047 | 22593 | 305 |
2472864 | 2472864 | 2022-05-04 | Robertson | Tennessee | 47147 | 21592 | 305 |
2468415 | 2468415 | 2022-05-03 | Wright | Minnesota | 27171 | 36832 | 305 |
2469446 | 2469446 | 2022-05-03 | Greenwood | South Carolina | 45047 | 22593 | 305 |
2465160 | 2465160 | 2022-05-02 | Wright | Minnesota | 27171 | 36798 | 305 |
2461904 | 2461904 | 2022-05-01 | Wright | Minnesota | 27171 | 36777 | 305 |
2458648 | 2458648 | 2022-04-30 | Wright | Minnesota | 27171 | 36777 | 305 |
2455392 | 2455392 | 2022-04-29 | Wright | Minnesota | 27171 | 36777 | 305 |
2452136 | 2452136 | 2022-04-28 | Wright | Minnesota | 27171 | 36752 | 305 |
2448880 | 2448880 | 2022-04-27 | Wright | Minnesota | 27171 | 36728 | 305 |
2445624 | 2445624 | 2022-04-26 | Wright | Minnesota | 27171 | 36708 | 305 |
2442368 | 2442368 | 2022-04-25 | Wright | Minnesota | 27171 | 36682 | 305 |
2439112 | 2439112 | 2022-04-24 | Wright | Minnesota | 27171 | 36668 | 305 |
2435856 | 2435856 | 2022-04-23 | Wright | Minnesota | 27171 | 36668 | 305 |
2432600 | 2432600 | 2022-04-22 | Wright | Minnesota | 27171 | 36668 | 305 |
2429344 | 2429344 | 2022-04-21 | Wright | Minnesota | 27171 | 36646 | 305 |
2426088 | 2426088 | 2022-04-20 | Wright | Minnesota | 27171 | 36625 | 305 |
2426747 | 2426747 | 2022-04-20 | Belmont | Ohio | 39013 | 15688 | 305 |
2422832 | 2422832 | 2022-04-19 | Wright | Minnesota | 27171 | 36614 | 305 |
2423491 | 2423491 | 2022-04-19 | Belmont | Ohio | 39013 | 15688 | 305 |
2419576 | 2419576 | 2022-04-18 | Wright | Minnesota | 27171 | 36583 | 305 |
2420234 | 2420234 | 2022-04-18 | Belmont | Ohio | 39013 | 15688 | 305 |
2416320 | 2416320 | 2022-04-17 | Wright | Minnesota | 27171 | 36579 | 305 |
2416979 | 2416979 | 2022-04-17 | Belmont | Ohio | 39013 | 15688 | 305 |
2413064 | 2413064 | 2022-04-16 | Wright | Minnesota | 27171 | 36579 | 305 |
2413723 | 2413723 | 2022-04-16 | Belmont | Ohio | 39013 | 15688 | 305 |
2409808 | 2409808 | 2022-04-15 | Wright | Minnesota | 27171 | 36579 | 305 |
2410467 | 2410467 | 2022-04-15 | Belmont | Ohio | 39013 | 15688 | 305 |
2406552 | 2406552 | 2022-04-14 | Wright | Minnesota | 27171 | 36572 | 305 |
2407211 | 2407211 | 2022-04-14 | Belmont | Ohio | 39013 | 15688 | 305 |
2403296 | 2403296 | 2022-04-13 | Wright | Minnesota | 27171 | 36551 | 305 |
2378410 | 2378410 | 2022-04-05 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2375023 | 2375023 | 2022-04-04 | Darlington | South Carolina | 45031 | 18874 | 305 |
2375156 | 2375156 | 2022-04-04 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2371771 | 2371771 | 2022-04-03 | Darlington | South Carolina | 45031 | 18874 | 305 |
2371904 | 2371904 | 2022-04-03 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2368518 | 2368518 | 2022-04-02 | Darlington | South Carolina | 45031 | 18874 | 305 |
2368651 | 2368651 | 2022-04-02 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2365265 | 2365265 | 2022-04-01 | Darlington | South Carolina | 45031 | 18874 | 305 |
2365398 | 2365398 | 2022-04-01 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2362012 | 2362012 | 2022-03-31 | Darlington | South Carolina | 45031 | 18874 | 305 |
2362145 | 2362145 | 2022-03-31 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2358758 | 2358758 | 2022-03-30 | Darlington | South Carolina | 45031 | 18874 | 305 |
2358891 | 2358891 | 2022-03-30 | Hawkins | Tennessee | 47073 | 16615 | 305 |
2355504 | 2355504 | 2022-03-29 | Darlington | South Carolina | 45031 | 18874 | 305 |
2338321 | 2338321 | 2022-03-24 | Cass | Missouri | 29037 | 24913 | 305 |
2335067 | 2335067 | 2022-03-23 | Cass | Missouri | 29037 | 24854 | 305 |
2331813 | 2331813 | 2022-03-22 | Cass | Missouri | 29037 | 24900 | 305 |
2328552 | 2328552 | 2022-03-21 | Buchanan | Missouri | 29021 | 24774 | 305 |
2325300 | 2325300 | 2022-03-20 | Buchanan | Missouri | 29021 | 24774 | 305 |
2322046 | 2322046 | 2022-03-19 | Buchanan | Missouri | 29021 | 24774 | 305 |
2318792 | 2318792 | 2022-03-18 | Buchanan | Missouri | 29021 | 24774 | 305 |
2315539 | 2315539 | 2022-03-17 | Buchanan | Missouri | 29021 | 24774 | 305 |
2312286 | 2312286 | 2022-03-16 | Buchanan | Missouri | 29021 | 24754 | 305 |
2312596 | 2312596 | 2022-03-16 | Chaves | New Mexico | 35005 | 21676 | 305 |
2309033 | 2309033 | 2022-03-15 | Buchanan | Missouri | 29021 | 24754 | 305 |
2309343 | 2309343 | 2022-03-15 | Chaves | New Mexico | 35005 | 21675 | 305 |
2304719 | 2304719 | 2022-03-14 | Fayette | Georgia | 13113 | 22124 | 305 |
2301467 | 2301467 | 2022-03-13 | Fayette | Georgia | 13113 | 22108 | 305 |
2298215 | 2298215 | 2022-03-12 | Fayette | Georgia | 13113 | 22108 | 305 |
2294963 | 2294963 | 2022-03-11 | Fayette | Georgia | 13113 | 22108 | 305 |
2291959 | 2291959 | 2022-03-10 | Vermilion | Illinois | 17183 | 27831 | 305 |
2288707 | 2288707 | 2022-03-09 | Vermilion | Illinois | 17183 | 27832 | 305 |
2289929 | 2289929 | 2022-03-09 | Brunswick | North Carolina | 37019 | 29487 | 305 |
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);