ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where deaths = 813 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- California 23
- Texas 16
- Georgia 12
- Colorado 7
- Pennsylvania 7
- Rhode Island 7
- South Carolina 6
- Illinois 5
- Florida 4
- Indiana 4
- New Jersey 4
- Ohio 4
- Kansas 3
- Maryland 3
- Michigan 3
- New York 3
- Massachusetts 2
- Arizona 1
- Arkansas 1
- District of Columbia 1
- Minnesota 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- New Mexico 1
- Puerto Rico 1
- Utah 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421912 | 2421912 | 2022-04-19 | Muscogee | Georgia | 13215 | 38195 | 813 |
2418656 | 2418656 | 2022-04-18 | Muscogee | Georgia | 13215 | 38195 | 813 |
2415400 | 2415400 | 2022-04-17 | Muscogee | Georgia | 13215 | 38193 | 813 |
2412144 | 2412144 | 2022-04-16 | Muscogee | Georgia | 13215 | 38193 | 813 |
2408888 | 2408888 | 2022-04-15 | Muscogee | Georgia | 13215 | 38193 | 813 |
2405632 | 2405632 | 2022-04-14 | Muscogee | Georgia | 13215 | 38182 | 813 |
2402377 | 2402377 | 2022-04-13 | Muscogee | Georgia | 13215 | 38178 | 813 |
2404937 | 2404937 | 2022-04-13 | Virginia Beach city | Virginia | 51810 | 89590 | 813 |
2372798 | 2372798 | 2022-04-04 | Merced | California | 6047 | 72027 | 813 |
2369545 | 2369545 | 2022-04-03 | Merced | California | 6047 | 71977 | 813 |
2366292 | 2366292 | 2022-04-02 | Merced | California | 6047 | 71977 | 813 |
2363039 | 2363039 | 2022-04-01 | Merced | California | 6047 | 71977 | 813 |
2359785 | 2359785 | 2022-03-31 | Merced | California | 6047 | 71952 | 813 |
2356531 | 2356531 | 2022-03-30 | Merced | California | 6047 | 71914 | 813 |
2290763 | 2290763 | 2022-03-09 | Jefferson | Texas | 48245 | 44724 | 813 |
2197623 | 2197623 | 2022-02-09 | Madison | Illinois | 17119 | 68566 | 813 |
2187982 | 2187982 | 2022-02-06 | St. Joseph | Indiana | 18141 | 69076 | 813 |
2184729 | 2184729 | 2022-02-05 | St. Joseph | Indiana | 18141 | 69076 | 813 |
2181477 | 2181477 | 2022-02-04 | St. Joseph | Indiana | 18141 | 69076 | 813 |
2175792 | 2175792 | 2022-02-02 | St. Charles | Missouri | 29183 | 98715 | 813 |
2176983 | 2176983 | 2022-02-02 | McLennan | Texas | 48309 | 53771 | 813 |
2173229 | 2173229 | 2022-02-01 | Cumberland | Pennsylvania | 42041 | 48467 | 813 |
2133682 | 2133682 | 2022-01-20 | Hillsborough | New Hampshire | 33011 | 83790 | 813 |
2129063 | 2129063 | 2022-01-19 | Clayton | Georgia | 13063 | 55579 | 813 |
2119305 | 2119305 | 2022-01-16 | Clayton | Georgia | 13063 | 54356 | 813 |
2116053 | 2116053 | 2022-01-15 | Clayton | Georgia | 13063 | 54356 | 813 |
2112802 | 2112802 | 2022-01-14 | Clayton | Georgia | 13063 | 54356 | 813 |
2109328 | 2109328 | 2022-01-13 | Imperial | California | 6025 | 47613 | 813 |
2088257 | 2088257 | 2022-01-06 | Rockland | New York | 36087 | 74264 | 813 |
2026493 | 2026493 | 2021-12-18 | Orange | New York | 36071 | 66809 | 813 |
1958228 | 1958228 | 2021-11-27 | Onondaga | New York | 36067 | 58942 | 813 |
1948909 | 1948909 | 2021-11-24 | Northampton | Pennsylvania | 42095 | 47741 | 813 |
1859547 | 1859547 | 2021-10-28 | Unknown | Illinois | 0 | 813 | |
1811815 | 1811815 | 2021-10-13 | Douglas | Nebraska | 31055 | 85220 | 813 |
1804323 | 1804323 | 2021-10-11 | Allen | Indiana | 18003 | 56483 | 813 |
1680327 | 1680327 | 2021-09-03 | Pulaski | Arkansas | 5119 | 54643 | 813 |
1647117 | 1647117 | 2021-08-23 | Denton | Texas | 48121 | 86481 | 813 |
1617972 | 1617972 | 2021-08-14 | Lubbock | Texas | 48303 | 53078 | 813 |
1612051 | 1612051 | 2021-08-13 | Mohave | Arizona | 4015 | 26641 | 813 |
1614724 | 1614724 | 2021-08-13 | Lubbock | Texas | 48303 | 53078 | 813 |
1596687 | 1596687 | 2021-08-08 | Sedgwick | Kansas | 20173 | 60963 | 813 |
1593438 | 1593438 | 2021-08-07 | Sedgwick | Kansas | 20173 | 60963 | 813 |
1590189 | 1590189 | 2021-08-06 | Sedgwick | Kansas | 20173 | 60963 | 813 |
1560244 | 1560244 | 2021-07-28 | Jefferson | Colorado | 8059 | 50039 | 813 |
1453026 | 1453026 | 2021-06-25 | Contra Costa | California | 6013 | 70945 | 813 |
1449780 | 1449780 | 2021-06-24 | Contra Costa | California | 6013 | 70882 | 813 |
1446535 | 1446535 | 2021-06-23 | Contra Costa | California | 6013 | 70818 | 813 |
1443290 | 1443290 | 2021-06-22 | Contra Costa | California | 6013 | 70770 | 813 |
1440045 | 1440045 | 2021-06-21 | Contra Costa | California | 6013 | 70730 | 813 |
1436798 | 1436798 | 2021-06-20 | Contra Costa | California | 6013 | 70691 | 813 |
1433551 | 1433551 | 2021-06-19 | Contra Costa | California | 6013 | 70624 | 813 |
1420621 | 1420621 | 2021-06-15 | Arapahoe | Colorado | 8005 | 63437 | 813 |
1417376 | 1417376 | 2021-06-14 | Arapahoe | Colorado | 8005 | 63437 | 813 |
1414130 | 1414130 | 2021-06-13 | Arapahoe | Colorado | 8005 | 63437 | 813 |
1410885 | 1410885 | 2021-06-12 | Arapahoe | Colorado | 8005 | 63395 | 813 |
1406254 | 1406254 | 2021-06-10 | Lucas | Ohio | 39095 | 43269 | 813 |
1403008 | 1403008 | 2021-06-09 | Lucas | Ohio | 39095 | 43248 | 813 |
1399763 | 1399763 | 2021-06-08 | Lucas | Ohio | 39095 | 43234 | 813 |
1378377 | 1378377 | 2021-06-02 | Contra Costa | California | 6013 | 69745 | 813 |
1380485 | 1380485 | 2021-06-02 | Luzerne | Pennsylvania | 42079 | 31823 | 813 |
1380512 | 1380512 | 2021-06-02 | York | Pennsylvania | 42133 | 46429 | 813 |
1375131 | 1375131 | 2021-06-01 | Contra Costa | California | 6013 | 69693 | 813 |
1371886 | 1371886 | 2021-05-31 | Contra Costa | California | 6013 | 69676 | 813 |
1368641 | 1368641 | 2021-05-30 | Contra Costa | California | 6013 | 69663 | 813 |
1365395 | 1365395 | 2021-05-29 | Contra Costa | California | 6013 | 69635 | 813 |
1362149 | 1362149 | 2021-05-28 | Contra Costa | California | 6013 | 69574 | 813 |
1364232 | 1364232 | 2021-05-28 | Chester | Pennsylvania | 42029 | 40594 | 813 |
1338781 | 1338781 | 2021-05-20 | Nueces | Texas | 48355 | 39270 | 813 |
1335190 | 1335190 | 2021-05-19 | Spartanburg | South Carolina | 45083 | 41560 | 813 |
1335534 | 1335534 | 2021-05-19 | Nueces | Texas | 48355 | 39248 | 813 |
1331943 | 1331943 | 2021-05-18 | Spartanburg | South Carolina | 45083 | 41530 | 813 |
1332287 | 1332287 | 2021-05-18 | Nueces | Texas | 48355 | 39239 | 813 |
1327522 | 1327522 | 2021-05-17 | Kent | Michigan | 26081 | 71508 | 813 |
1328696 | 1328696 | 2021-05-17 | Spartanburg | South Carolina | 45083 | 41525 | 813 |
1329040 | 1329040 | 2021-05-17 | Nueces | Texas | 48355 | 39194 | 813 |
1324276 | 1324276 | 2021-05-16 | Kent | Michigan | 26081 | 71197 | 813 |
1325450 | 1325450 | 2021-05-16 | Spartanburg | South Carolina | 45083 | 41490 | 813 |
1320135 | 1320135 | 2021-05-15 | Volusia | Florida | 12127 | 43953 | 813 |
1321030 | 1321030 | 2021-05-15 | Kent | Michigan | 26081 | 71197 | 813 |
1316762 | 1316762 | 2021-05-14 | Denver | Colorado | 8031 | 72212 | 813 |
1316766 | 1316766 | 2021-05-14 | El Paso | Colorado | 8041 | 67407 | 813 |
1316888 | 1316888 | 2021-05-14 | Volusia | Florida | 12127 | 43877 | 813 |
1268447 | 1268447 | 2021-04-29 | Kane | Illinois | 17089 | 57071 | 813 |
1258706 | 1258706 | 2021-04-26 | Kane | Illinois | 17089 | 56640 | 813 |
1255459 | 1255459 | 2021-04-25 | Kane | Illinois | 17089 | 56516 | 813 |
1250986 | 1250986 | 2021-04-23 | Collin | Texas | 48085 | 89051 | 813 |
1224135 | 1224135 | 2021-04-15 | Burlington | New Jersey | 34005 | 42374 | 813 |
1224150 | 1224150 | 2021-04-15 | Somerset | New Jersey | 34035 | 28485 | 813 |
1220903 | 1220903 | 2021-04-14 | Somerset | New Jersey | 34035 | 28365 | 813 |
1180444 | 1180444 | 2021-04-02 | Brevard | Florida | 12009 | 37451 | 813 |
1164120 | 1164120 | 2021-03-28 | Tulare | California | 6107 | 48960 | 813 |
1160872 | 1160872 | 2021-03-27 | Tulare | California | 6107 | 48960 | 813 |
1157000 | 1157000 | 2021-03-25 | Webb | Texas | 48479 | 43047 | 813 |
1153753 | 1153753 | 2021-03-24 | Webb | Texas | 48479 | 43047 | 813 |
1153785 | 1153785 | 2021-03-24 | Salt Lake | Utah | 49035 | 142677 | 813 |
1150506 | 1150506 | 2021-03-23 | Webb | Texas | 48479 | 43047 | 813 |
1147259 | 1147259 | 2021-03-22 | Webb | Texas | 48479 | 43047 | 813 |
1049861 | 1049861 | 2021-02-20 | Travis | Texas | 48453 | 73538 | 813 |
1042656 | 1042656 | 2021-02-18 | Stark | Ohio | 39151 | 28627 | 813 |
1036467 | 1036467 | 2021-02-16 | Greenville | South Carolina | 45045 | 61269 | 813 |
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);