ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,352 rows where county = "Douglas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1283958 | 1283958 | 2021-05-03 | Douglas | Wisconsin | 55031 | 4767 | 51 |
1277806 | 1277806 | 2021-05-02 | Douglas | Colorado | 8035 | 28493 | 253 |
1277981 | 1277981 | 2021-05-02 | Douglas | Georgia | 13097 | 15089 | 215 |
1278164 | 1278164 | 2021-05-02 | Douglas | Illinois | 17041 | 2568 | 41 |
1278461 | 1278461 | 2021-05-02 | Douglas | Kansas | 20045 | 9205 | 87 |
1278890 | 1278890 | 2021-05-02 | Douglas | Minnesota | 27041 | 4573 | 74 |
1279073 | 1279073 | 2021-05-02 | Douglas | Missouri | 29067 | 906 | 27 |
1279240 | 1279240 | 2021-05-02 | Douglas | Nebraska | 31055 | 70727 | 700 |
1279310 | 1279310 | 2021-05-02 | Douglas | Nevada | 32005 | 2807 | 35 |
1279780 | 1279780 | 2021-05-02 | Douglas | Oregon | 41019 | 3164 | 69 |
1280025 | 1280025 | 2021-05-02 | Douglas | South Dakota | 46043 | 454 | 9 |
1280610 | 1280610 | 2021-05-02 | Douglas | Washington | 53017 | 3622 | 23 |
1280711 | 1280711 | 2021-05-02 | Douglas | Wisconsin | 55031 | 4740 | 51 |
1274559 | 1274559 | 2021-05-01 | Douglas | Colorado | 8035 | 28385 | 253 |
1274734 | 1274734 | 2021-05-01 | Douglas | Georgia | 13097 | 15075 | 215 |
1274917 | 1274917 | 2021-05-01 | Douglas | Illinois | 17041 | 2568 | 41 |
1275214 | 1275214 | 2021-05-01 | Douglas | Kansas | 20045 | 9205 | 87 |
1275643 | 1275643 | 2021-05-01 | Douglas | Minnesota | 27041 | 4559 | 74 |
1275826 | 1275826 | 2021-05-01 | Douglas | Missouri | 29067 | 903 | 27 |
1275993 | 1275993 | 2021-05-01 | Douglas | Nebraska | 31055 | 70687 | 700 |
1276063 | 1276063 | 2021-05-01 | Douglas | Nevada | 32005 | 2807 | 35 |
1276533 | 1276533 | 2021-05-01 | Douglas | Oregon | 41019 | 3153 | 69 |
1276778 | 1276778 | 2021-05-01 | Douglas | South Dakota | 46043 | 454 | 9 |
1277363 | 1277363 | 2021-05-01 | Douglas | Washington | 53017 | 3622 | 23 |
1277464 | 1277464 | 2021-05-01 | Douglas | Wisconsin | 55031 | 4741 | 51 |
1271312 | 1271312 | 2021-04-30 | Douglas | Colorado | 8035 | 28385 | 253 |
1271487 | 1271487 | 2021-04-30 | Douglas | Georgia | 13097 | 15050 | 215 |
1271670 | 1271670 | 2021-04-30 | Douglas | Illinois | 17041 | 2565 | 41 |
1271967 | 1271967 | 2021-04-30 | Douglas | Kansas | 20045 | 9205 | 87 |
1272396 | 1272396 | 2021-04-30 | Douglas | Minnesota | 27041 | 4543 | 74 |
1272579 | 1272579 | 2021-04-30 | Douglas | Missouri | 29067 | 901 | 27 |
1272746 | 1272746 | 2021-04-30 | Douglas | Nebraska | 31055 | 70687 | 700 |
1272816 | 1272816 | 2021-04-30 | Douglas | Nevada | 32005 | 2807 | 35 |
1273286 | 1273286 | 2021-04-30 | Douglas | Oregon | 41019 | 3144 | 69 |
1273531 | 1273531 | 2021-04-30 | Douglas | South Dakota | 46043 | 454 | 9 |
1274116 | 1274116 | 2021-04-30 | Douglas | Washington | 53017 | 3622 | 23 |
1274217 | 1274217 | 2021-04-30 | Douglas | Wisconsin | 55031 | 4730 | 51 |
1268065 | 1268065 | 2021-04-29 | Douglas | Colorado | 8035 | 28246 | 252 |
1268240 | 1268240 | 2021-04-29 | Douglas | Georgia | 13097 | 15030 | 215 |
1268423 | 1268423 | 2021-04-29 | Douglas | Illinois | 17041 | 2563 | 41 |
1268720 | 1268720 | 2021-04-29 | Douglas | Kansas | 20045 | 9194 | 87 |
1269149 | 1269149 | 2021-04-29 | Douglas | Minnesota | 27041 | 4530 | 73 |
1269332 | 1269332 | 2021-04-29 | Douglas | Missouri | 29067 | 898 | 27 |
1269499 | 1269499 | 2021-04-29 | Douglas | Nebraska | 31055 | 70586 | 699 |
1269569 | 1269569 | 2021-04-29 | Douglas | Nevada | 32005 | 2801 | 35 |
1270039 | 1270039 | 2021-04-29 | Douglas | Oregon | 41019 | 3137 | 69 |
1270284 | 1270284 | 2021-04-29 | Douglas | South Dakota | 46043 | 454 | 9 |
1270869 | 1270869 | 2021-04-29 | Douglas | Washington | 53017 | 3617 | 23 |
1270970 | 1270970 | 2021-04-29 | Douglas | Wisconsin | 55031 | 4722 | 51 |
1264818 | 1264818 | 2021-04-28 | Douglas | Colorado | 8035 | 27976 | 252 |
1264993 | 1264993 | 2021-04-28 | Douglas | Georgia | 13097 | 15014 | 214 |
1265176 | 1265176 | 2021-04-28 | Douglas | Illinois | 17041 | 2562 | 41 |
1265473 | 1265473 | 2021-04-28 | Douglas | Kansas | 20045 | 9194 | 87 |
1265902 | 1265902 | 2021-04-28 | Douglas | Minnesota | 27041 | 4519 | 73 |
1266085 | 1266085 | 2021-04-28 | Douglas | Missouri | 29067 | 897 | 27 |
1266252 | 1266252 | 2021-04-28 | Douglas | Nebraska | 31055 | 70415 | 696 |
1266322 | 1266322 | 2021-04-28 | Douglas | Nevada | 32005 | 2797 | 35 |
1266792 | 1266792 | 2021-04-28 | Douglas | Oregon | 41019 | 3120 | 69 |
1267037 | 1267037 | 2021-04-28 | Douglas | South Dakota | 46043 | 454 | 9 |
1267622 | 1267622 | 2021-04-28 | Douglas | Washington | 53017 | 3610 | 23 |
1267723 | 1267723 | 2021-04-28 | Douglas | Wisconsin | 55031 | 4719 | 51 |
1261571 | 1261571 | 2021-04-27 | Douglas | Colorado | 8035 | 27976 | 252 |
1261746 | 1261746 | 2021-04-27 | Douglas | Georgia | 13097 | 14984 | 214 |
1261929 | 1261929 | 2021-04-27 | Douglas | Illinois | 17041 | 2560 | 41 |
1262226 | 1262226 | 2021-04-27 | Douglas | Kansas | 20045 | 9181 | 87 |
1262655 | 1262655 | 2021-04-27 | Douglas | Minnesota | 27041 | 4508 | 73 |
1262838 | 1262838 | 2021-04-27 | Douglas | Missouri | 29067 | 895 | 27 |
1263005 | 1263005 | 2021-04-27 | Douglas | Nebraska | 31055 | 70415 | 696 |
1263075 | 1263075 | 2021-04-27 | Douglas | Nevada | 32005 | 2794 | 35 |
1263545 | 1263545 | 2021-04-27 | Douglas | Oregon | 41019 | 3112 | 69 |
1263790 | 1263790 | 2021-04-27 | Douglas | South Dakota | 46043 | 454 | 9 |
1264375 | 1264375 | 2021-04-27 | Douglas | Washington | 53017 | 3588 | 23 |
1264476 | 1264476 | 2021-04-27 | Douglas | Wisconsin | 55031 | 4708 | 51 |
1258324 | 1258324 | 2021-04-26 | Douglas | Colorado | 8035 | 27810 | 252 |
1258499 | 1258499 | 2021-04-26 | Douglas | Georgia | 13097 | 14968 | 211 |
1258682 | 1258682 | 2021-04-26 | Douglas | Illinois | 17041 | 2564 | 41 |
1258979 | 1258979 | 2021-04-26 | Douglas | Kansas | 20045 | 9181 | 87 |
1259408 | 1259408 | 2021-04-26 | Douglas | Minnesota | 27041 | 4504 | 73 |
1259591 | 1259591 | 2021-04-26 | Douglas | Missouri | 29067 | 895 | 27 |
1259758 | 1259758 | 2021-04-26 | Douglas | Nebraska | 31055 | 70325 | 696 |
1259828 | 1259828 | 2021-04-26 | Douglas | Nevada | 32005 | 2778 | 35 |
1260298 | 1260298 | 2021-04-26 | Douglas | Oregon | 41019 | 3097 | 69 |
1260543 | 1260543 | 2021-04-26 | Douglas | South Dakota | 46043 | 454 | 9 |
1261128 | 1261128 | 2021-04-26 | Douglas | Washington | 53017 | 3588 | 23 |
1261229 | 1261229 | 2021-04-26 | Douglas | Wisconsin | 55031 | 4701 | 50 |
1255077 | 1255077 | 2021-04-25 | Douglas | Colorado | 8035 | 27558 | 252 |
1255252 | 1255252 | 2021-04-25 | Douglas | Georgia | 13097 | 14954 | 211 |
1255435 | 1255435 | 2021-04-25 | Douglas | Illinois | 17041 | 2563 | 41 |
1255732 | 1255732 | 2021-04-25 | Douglas | Kansas | 20045 | 9152 | 87 |
1256161 | 1256161 | 2021-04-25 | Douglas | Minnesota | 27041 | 4497 | 73 |
1256344 | 1256344 | 2021-04-25 | Douglas | Missouri | 29067 | 895 | 27 |
1256511 | 1256511 | 2021-04-25 | Douglas | Nebraska | 31055 | 70184 | 696 |
1256581 | 1256581 | 2021-04-25 | Douglas | Nevada | 32005 | 2778 | 35 |
1257051 | 1257051 | 2021-04-25 | Douglas | Oregon | 41019 | 3093 | 68 |
1257296 | 1257296 | 2021-04-25 | Douglas | South Dakota | 46043 | 454 | 9 |
1257881 | 1257881 | 2021-04-25 | Douglas | Washington | 53017 | 3588 | 23 |
1257982 | 1257982 | 2021-04-25 | Douglas | Wisconsin | 55031 | 4696 | 50 |
1251830 | 1251830 | 2021-04-24 | Douglas | Colorado | 8035 | 27372 | 251 |
1252005 | 1252005 | 2021-04-24 | Douglas | Georgia | 13097 | 14934 | 211 |
1252188 | 1252188 | 2021-04-24 | Douglas | Illinois | 17041 | 2561 | 41 |
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);