ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 12105 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277918 | 1277918 | 2021-05-02 | Polk | Florida | 12105 | 67979 | 1310 |
1274671 | 1274671 | 2021-05-01 | Polk | Florida | 12105 | 67819 | 1310 |
1271424 | 1271424 | 2021-04-30 | Polk | Florida | 12105 | 67607 | 1309 |
1268177 | 1268177 | 2021-04-29 | Polk | Florida | 12105 | 67355 | 1304 |
1264930 | 1264930 | 2021-04-28 | Polk | Florida | 12105 | 67107 | 1302 |
1261683 | 1261683 | 2021-04-27 | Polk | Florida | 12105 | 66922 | 1301 |
1258436 | 1258436 | 2021-04-26 | Polk | Florida | 12105 | 66692 | 1297 |
1255189 | 1255189 | 2021-04-25 | Polk | Florida | 12105 | 66558 | 1296 |
1251942 | 1251942 | 2021-04-24 | Polk | Florida | 12105 | 66312 | 1295 |
1248695 | 1248695 | 2021-04-23 | Polk | Florida | 12105 | 66001 | 1294 |
1245448 | 1245448 | 2021-04-22 | Polk | Florida | 12105 | 65791 | 1292 |
1242201 | 1242201 | 2021-04-21 | Polk | Florida | 12105 | 65521 | 1296 |
1238954 | 1238954 | 2021-04-20 | Polk | Florida | 12105 | 65317 | 1291 |
1235707 | 1235707 | 2021-04-19 | Polk | Florida | 12105 | 65084 | 1283 |
1232460 | 1232460 | 2021-04-18 | Polk | Florida | 12105 | 64922 | 1283 |
1229211 | 1229211 | 2021-04-17 | Polk | Florida | 12105 | 64706 | 1283 |
1225963 | 1225963 | 2021-04-16 | Polk | Florida | 12105 | 64447 | 1285 |
1222716 | 1222716 | 2021-04-15 | Polk | Florida | 12105 | 64189 | 1276 |
1219468 | 1219468 | 2021-04-14 | Polk | Florida | 12105 | 63919 | 1275 |
1216220 | 1216220 | 2021-04-13 | Polk | Florida | 12105 | 63633 | 1275 |
1212973 | 1212973 | 2021-04-12 | Polk | Florida | 12105 | 63319 | 1273 |
1209725 | 1209725 | 2021-04-11 | Polk | Florida | 12105 | 63240 | 1273 |
1206476 | 1206476 | 2021-04-10 | Polk | Florida | 12105 | 63044 | 1275 |
1203228 | 1203228 | 2021-04-09 | Polk | Florida | 12105 | 62807 | 1271 |
1199980 | 1199980 | 2021-04-08 | Polk | Florida | 12105 | 62606 | 1292 |
1196731 | 1196731 | 2021-04-07 | Polk | Florida | 12105 | 62402 | 1284 |
1193483 | 1193483 | 2021-04-06 | Polk | Florida | 12105 | 62197 | 1284 |
1190233 | 1190233 | 2021-04-05 | Polk | Florida | 12105 | 61995 | 1267 |
1186986 | 1186986 | 2021-04-04 | Polk | Florida | 12105 | 61888 | 1267 |
1183739 | 1183739 | 2021-04-03 | Polk | Florida | 12105 | 61747 | 1267 |
1180492 | 1180492 | 2021-04-02 | Polk | Florida | 12105 | 61574 | 1267 |
1177245 | 1177245 | 2021-04-01 | Polk | Florida | 12105 | 61390 | 1260 |
1173998 | 1173998 | 2021-03-31 | Polk | Florida | 12105 | 61175 | 1254 |
1170751 | 1170751 | 2021-03-30 | Polk | Florida | 12105 | 61019 | 1247 |
1167503 | 1167503 | 2021-03-29 | Polk | Florida | 12105 | 60852 | 1237 |
1164255 | 1164255 | 2021-03-28 | Polk | Florida | 12105 | 60765 | 1237 |
1161007 | 1161007 | 2021-03-27 | Polk | Florida | 12105 | 60602 | 1237 |
1157759 | 1157759 | 2021-03-26 | Polk | Florida | 12105 | 60449 | 1236 |
1154512 | 1154512 | 2021-03-25 | Polk | Florida | 12105 | 60278 | 1221 |
1151265 | 1151265 | 2021-03-24 | Polk | Florida | 12105 | 60115 | 1221 |
1148018 | 1148018 | 2021-03-23 | Polk | Florida | 12105 | 59991 | 1221 |
1144771 | 1144771 | 2021-03-22 | Polk | Florida | 12105 | 59834 | 1220 |
1141524 | 1141524 | 2021-03-21 | Polk | Florida | 12105 | 59767 | 1218 |
1138278 | 1138278 | 2021-03-20 | Polk | Florida | 12105 | 59654 | 1218 |
1135032 | 1135032 | 2021-03-19 | Polk | Florida | 12105 | 59542 | 1219 |
1131785 | 1131785 | 2021-03-18 | Polk | Florida | 12105 | 59400 | 1209 |
1128537 | 1128537 | 2021-03-17 | Polk | Florida | 12105 | 59264 | 1203 |
1125291 | 1125291 | 2021-03-16 | Polk | Florida | 12105 | 59111 | 1204 |
1122045 | 1122045 | 2021-03-15 | Polk | Florida | 12105 | 58991 | 1194 |
1118798 | 1118798 | 2021-03-14 | Polk | Florida | 12105 | 58920 | 1193 |
1115551 | 1115551 | 2021-03-13 | Polk | Florida | 12105 | 58820 | 1194 |
1112305 | 1112305 | 2021-03-12 | Polk | Florida | 12105 | 58691 | 1191 |
1109059 | 1109059 | 2021-03-11 | Polk | Florida | 12105 | 58567 | 1191 |
1105813 | 1105813 | 2021-03-10 | Polk | Florida | 12105 | 58434 | 1183 |
1102567 | 1102567 | 2021-03-09 | Polk | Florida | 12105 | 58306 | 1181 |
1099321 | 1099321 | 2021-03-08 | Polk | Florida | 12105 | 58205 | 1176 |
1096073 | 1096073 | 2021-03-07 | Polk | Florida | 12105 | 58116 | 1175 |
1092827 | 1092827 | 2021-03-06 | Polk | Florida | 12105 | 58008 | 1174 |
1089581 | 1089581 | 2021-03-05 | Polk | Florida | 12105 | 57852 | 1164 |
1086336 | 1086336 | 2021-03-04 | Polk | Florida | 12105 | 57655 | 1164 |
1083090 | 1083090 | 2021-03-03 | Polk | Florida | 12105 | 57496 | 1152 |
1079844 | 1079844 | 2021-03-02 | Polk | Florida | 12105 | 57339 | 1150 |
1076599 | 1076599 | 2021-03-01 | Polk | Florida | 12105 | 57150 | 1140 |
1073353 | 1073353 | 2021-02-28 | Polk | Florida | 12105 | 57096 | 1139 |
1070107 | 1070107 | 2021-02-27 | Polk | Florida | 12105 | 56954 | 1139 |
1066862 | 1066862 | 2021-02-26 | Polk | Florida | 12105 | 56759 | 1137 |
1063617 | 1063617 | 2021-02-25 | Polk | Florida | 12105 | 56583 | 1131 |
1060372 | 1060372 | 2021-02-24 | Polk | Florida | 12105 | 56409 | 1133 |
1057126 | 1057126 | 2021-02-23 | Polk | Florida | 12105 | 56153 | 1116 |
1053880 | 1053880 | 2021-02-22 | Polk | Florida | 12105 | 55986 | 1108 |
1050633 | 1050633 | 2021-02-21 | Polk | Florida | 12105 | 55861 | 1107 |
1047386 | 1047386 | 2021-02-20 | Polk | Florida | 12105 | 55694 | 1107 |
1044141 | 1044141 | 2021-02-19 | Polk | Florida | 12105 | 55473 | 1101 |
1040896 | 1040896 | 2021-02-18 | Polk | Florida | 12105 | 55269 | 1094 |
1037651 | 1037651 | 2021-02-17 | Polk | Florida | 12105 | 55058 | 1087 |
1034406 | 1034406 | 2021-02-16 | Polk | Florida | 12105 | 54829 | 1077 |
1031160 | 1031160 | 2021-02-15 | Polk | Florida | 12105 | 54573 | 1057 |
1027913 | 1027913 | 2021-02-14 | Polk | Florida | 12105 | 54435 | 1056 |
1024668 | 1024668 | 2021-02-13 | Polk | Florida | 12105 | 54235 | 1056 |
1021423 | 1021423 | 2021-02-12 | Polk | Florida | 12105 | 53925 | 1050 |
1018178 | 1018178 | 2021-02-11 | Polk | Florida | 12105 | 53651 | 1050 |
1014933 | 1014933 | 2021-02-10 | Polk | Florida | 12105 | 53316 | 1030 |
1011688 | 1011688 | 2021-02-09 | Polk | Florida | 12105 | 53005 | 1029 |
1008442 | 1008442 | 2021-02-08 | Polk | Florida | 12105 | 52731 | 1008 |
1005196 | 1005196 | 2021-02-07 | Polk | Florida | 12105 | 52533 | 1008 |
1001950 | 1001950 | 2021-02-06 | Polk | Florida | 12105 | 52275 | 1008 |
998704 | 998704 | 2021-02-05 | Polk | Florida | 12105 | 52029 | 1008 |
995458 | 995458 | 2021-02-04 | Polk | Florida | 12105 | 51630 | 991 |
992212 | 992212 | 2021-02-03 | Polk | Florida | 12105 | 51297 | 979 |
988966 | 988966 | 2021-02-02 | Polk | Florida | 12105 | 51050 | 977 |
985719 | 985719 | 2021-02-01 | Polk | Florida | 12105 | 50702 | 967 |
982472 | 982472 | 2021-01-31 | Polk | Florida | 12105 | 50474 | 967 |
979226 | 979226 | 2021-01-30 | Polk | Florida | 12105 | 50201 | 967 |
975981 | 975981 | 2021-01-29 | Polk | Florida | 12105 | 49692 | 964 |
972736 | 972736 | 2021-01-28 | Polk | Florida | 12105 | 49348 | 960 |
969491 | 969491 | 2021-01-27 | Polk | Florida | 12105 | 48974 | 953 |
966247 | 966247 | 2021-01-26 | Polk | Florida | 12105 | 48656 | 942 |
963002 | 963002 | 2021-01-25 | Polk | Florida | 12105 | 48371 | 929 |
959757 | 959757 | 2021-01-24 | Polk | Florida | 12105 | 48119 | 929 |
956511 | 956511 | 2021-01-23 | Polk | Florida | 12105 | 47795 | 928 |
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);