ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Dodge" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199524 | 1199524 | 2021-04-07 | Dodge | Wisconsin | 55027 | 12462 | 182 |
1196275 | 1196275 | 2021-04-06 | Dodge | Wisconsin | 55027 | 12451 | 182 |
1193027 | 1193027 | 2021-04-05 | Dodge | Wisconsin | 55027 | 12436 | 183 |
1189777 | 1189777 | 2021-04-04 | Dodge | Wisconsin | 55027 | 12436 | 183 |
1186530 | 1186530 | 2021-04-03 | Dodge | Wisconsin | 55027 | 12434 | 183 |
1183283 | 1183283 | 2021-04-02 | Dodge | Wisconsin | 55027 | 12428 | 183 |
1180036 | 1180036 | 2021-04-01 | Dodge | Wisconsin | 55027 | 12421 | 183 |
1176789 | 1176789 | 2021-03-31 | Dodge | Wisconsin | 55027 | 12413 | 183 |
1173542 | 1173542 | 2021-03-30 | Dodge | Wisconsin | 55027 | 12407 | 182 |
1170295 | 1170295 | 2021-03-29 | Dodge | Wisconsin | 55027 | 12400 | 182 |
1167047 | 1167047 | 2021-03-28 | Dodge | Wisconsin | 55027 | 12397 | 182 |
1163799 | 1163799 | 2021-03-27 | Dodge | Wisconsin | 55027 | 12395 | 182 |
1160551 | 1160551 | 2021-03-26 | Dodge | Wisconsin | 55027 | 12392 | 182 |
1157303 | 1157303 | 2021-03-25 | Dodge | Wisconsin | 55027 | 12381 | 182 |
1154056 | 1154056 | 2021-03-24 | Dodge | Wisconsin | 55027 | 12367 | 182 |
1150809 | 1150809 | 2021-03-23 | Dodge | Wisconsin | 55027 | 12348 | 182 |
1147562 | 1147562 | 2021-03-22 | Dodge | Wisconsin | 55027 | 12348 | 182 |
1144315 | 1144315 | 2021-03-21 | Dodge | Wisconsin | 55027 | 12342 | 182 |
1141068 | 1141068 | 2021-03-20 | Dodge | Wisconsin | 55027 | 12340 | 182 |
1137822 | 1137822 | 2021-03-19 | Dodge | Wisconsin | 55027 | 12326 | 182 |
1134576 | 1134576 | 2021-03-18 | Dodge | Wisconsin | 55027 | 12323 | 182 |
1131328 | 1131328 | 2021-03-17 | Dodge | Wisconsin | 55027 | 12309 | 182 |
1128081 | 1128081 | 2021-03-16 | Dodge | Wisconsin | 55027 | 12301 | 182 |
1124835 | 1124835 | 2021-03-15 | Dodge | Wisconsin | 55027 | 12298 | 182 |
1121589 | 1121589 | 2021-03-14 | Dodge | Wisconsin | 55027 | 12295 | 181 |
1118342 | 1118342 | 2021-03-13 | Dodge | Wisconsin | 55027 | 12291 | 181 |
1115095 | 1115095 | 2021-03-12 | Dodge | Wisconsin | 55027 | 12289 | 181 |
1111849 | 1111849 | 2021-03-11 | Dodge | Wisconsin | 55027 | 12276 | 180 |
1108603 | 1108603 | 2021-03-10 | Dodge | Wisconsin | 55027 | 12266 | 179 |
1105357 | 1105357 | 2021-03-09 | Dodge | Wisconsin | 55027 | 12253 | 179 |
1102111 | 1102111 | 2021-03-08 | Dodge | Wisconsin | 55027 | 12245 | 179 |
1098865 | 1098865 | 2021-03-07 | Dodge | Wisconsin | 55027 | 12240 | 179 |
1095617 | 1095617 | 2021-03-06 | Dodge | Wisconsin | 55027 | 12239 | 179 |
1092371 | 1092371 | 2021-03-05 | Dodge | Wisconsin | 55027 | 12230 | 177 |
1089125 | 1089125 | 2021-03-04 | Dodge | Wisconsin | 55027 | 12219 | 177 |
1085880 | 1085880 | 2021-03-03 | Dodge | Wisconsin | 55027 | 12217 | 176 |
1082634 | 1082634 | 2021-03-02 | Dodge | Wisconsin | 55027 | 12204 | 176 |
1079388 | 1079388 | 2021-03-01 | Dodge | Wisconsin | 55027 | 12190 | 176 |
1076143 | 1076143 | 2021-02-28 | Dodge | Wisconsin | 55027 | 12184 | 176 |
1072897 | 1072897 | 2021-02-27 | Dodge | Wisconsin | 55027 | 12190 | 176 |
1069651 | 1069651 | 2021-02-26 | Dodge | Wisconsin | 55027 | 12175 | 176 |
1066406 | 1066406 | 2021-02-25 | Dodge | Wisconsin | 55027 | 12164 | 176 |
1063161 | 1063161 | 2021-02-24 | Dodge | Wisconsin | 55027 | 12143 | 176 |
1059916 | 1059916 | 2021-02-23 | Dodge | Wisconsin | 55027 | 12133 | 176 |
1056670 | 1056670 | 2021-02-22 | Dodge | Wisconsin | 55027 | 12131 | 176 |
1053424 | 1053424 | 2021-02-21 | Dodge | Wisconsin | 55027 | 12127 | 176 |
1050177 | 1050177 | 2021-02-20 | Dodge | Wisconsin | 55027 | 12124 | 176 |
1046930 | 1046930 | 2021-02-19 | Dodge | Wisconsin | 55027 | 12111 | 176 |
1043685 | 1043685 | 2021-02-18 | Dodge | Wisconsin | 55027 | 12096 | 175 |
1040440 | 1040440 | 2021-02-17 | Dodge | Wisconsin | 55027 | 12089 | 175 |
1037195 | 1037195 | 2021-02-16 | Dodge | Wisconsin | 55027 | 12075 | 175 |
1033950 | 1033950 | 2021-02-15 | Dodge | Wisconsin | 55027 | 12064 | 175 |
1030704 | 1030704 | 2021-02-14 | Dodge | Wisconsin | 55027 | 12061 | 175 |
1027457 | 1027457 | 2021-02-13 | Dodge | Wisconsin | 55027 | 12057 | 175 |
1024212 | 1024212 | 2021-02-12 | Dodge | Wisconsin | 55027 | 12047 | 175 |
1020967 | 1020967 | 2021-02-11 | Dodge | Wisconsin | 55027 | 12041 | 175 |
1017722 | 1017722 | 2021-02-10 | Dodge | Wisconsin | 55027 | 12019 | 175 |
1014477 | 1014477 | 2021-02-09 | Dodge | Wisconsin | 55027 | 11999 | 175 |
1011232 | 1011232 | 2021-02-08 | Dodge | Wisconsin | 55027 | 11982 | 175 |
1007986 | 1007986 | 2021-02-07 | Dodge | Wisconsin | 55027 | 11973 | 174 |
1004740 | 1004740 | 2021-02-06 | Dodge | Wisconsin | 55027 | 11964 | 174 |
1001494 | 1001494 | 2021-02-05 | Dodge | Wisconsin | 55027 | 11948 | 171 |
998248 | 998248 | 2021-02-04 | Dodge | Wisconsin | 55027 | 11928 | 166 |
995002 | 995002 | 2021-02-03 | Dodge | Wisconsin | 55027 | 11909 | 165 |
991756 | 991756 | 2021-02-02 | Dodge | Wisconsin | 55027 | 11897 | 165 |
988510 | 988510 | 2021-02-01 | Dodge | Wisconsin | 55027 | 11880 | 165 |
985263 | 985263 | 2021-01-31 | Dodge | Wisconsin | 55027 | 11871 | 165 |
982016 | 982016 | 2021-01-30 | Dodge | Wisconsin | 55027 | 11860 | 164 |
978770 | 978770 | 2021-01-29 | Dodge | Wisconsin | 55027 | 11848 | 162 |
975525 | 975525 | 2021-01-28 | Dodge | Wisconsin | 55027 | 11828 | 161 |
972280 | 972280 | 2021-01-27 | Dodge | Wisconsin | 55027 | 11806 | 161 |
969035 | 969035 | 2021-01-26 | Dodge | Wisconsin | 55027 | 11772 | 160 |
965791 | 965791 | 2021-01-25 | Dodge | Wisconsin | 55027 | 11747 | 156 |
962546 | 962546 | 2021-01-24 | Dodge | Wisconsin | 55027 | 11734 | 156 |
959301 | 959301 | 2021-01-23 | Dodge | Wisconsin | 55027 | 11727 | 156 |
956055 | 956055 | 2021-01-22 | Dodge | Wisconsin | 55027 | 11693 | 150 |
952810 | 952810 | 2021-01-21 | Dodge | Wisconsin | 55027 | 11672 | 150 |
949565 | 949565 | 2021-01-20 | Dodge | Wisconsin | 55027 | 11638 | 150 |
946319 | 946319 | 2021-01-19 | Dodge | Wisconsin | 55027 | 11623 | 150 |
943072 | 943072 | 2021-01-18 | Dodge | Wisconsin | 55027 | 11608 | 146 |
939827 | 939827 | 2021-01-17 | Dodge | Wisconsin | 55027 | 11595 | 146 |
936582 | 936582 | 2021-01-16 | Dodge | Wisconsin | 55027 | 11572 | 146 |
933337 | 933337 | 2021-01-15 | Dodge | Wisconsin | 55027 | 11543 | 146 |
930092 | 930092 | 2021-01-14 | Dodge | Wisconsin | 55027 | 11499 | 146 |
926847 | 926847 | 2021-01-13 | Dodge | Wisconsin | 55027 | 11476 | 144 |
923601 | 923601 | 2021-01-12 | Dodge | Wisconsin | 55027 | 11417 | 144 |
920356 | 920356 | 2021-01-11 | Dodge | Wisconsin | 55027 | 11388 | 143 |
917111 | 917111 | 2021-01-10 | Dodge | Wisconsin | 55027 | 11360 | 143 |
913866 | 913866 | 2021-01-09 | Dodge | Wisconsin | 55027 | 11336 | 143 |
910621 | 910621 | 2021-01-08 | Dodge | Wisconsin | 55027 | 11288 | 143 |
907376 | 907376 | 2021-01-07 | Dodge | Wisconsin | 55027 | 11232 | 143 |
904130 | 904130 | 2021-01-06 | Dodge | Wisconsin | 55027 | 11178 | 143 |
900885 | 900885 | 2021-01-05 | Dodge | Wisconsin | 55027 | 11121 | 143 |
897640 | 897640 | 2021-01-04 | Dodge | Wisconsin | 55027 | 11101 | 142 |
894394 | 894394 | 2021-01-03 | Dodge | Wisconsin | 55027 | 11084 | 142 |
891148 | 891148 | 2021-01-02 | Dodge | Wisconsin | 55027 | 11067 | 142 |
887901 | 887901 | 2021-01-01 | Dodge | Wisconsin | 55027 | 11054 | 142 |
884656 | 884656 | 2020-12-31 | Dodge | Wisconsin | 55027 | 10999 | 137 |
881411 | 881411 | 2020-12-30 | Dodge | Wisconsin | 55027 | 10964 | 136 |
878166 | 878166 | 2020-12-29 | Dodge | Wisconsin | 55027 | 10913 | 135 |
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);