ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Orange" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417499 | 1417499 | 2021-06-14 | Orange | Florida | 12095 | 141941 | 1310 |
1414253 | 1414253 | 2021-06-13 | Orange | Florida | 12095 | 141941 | 1310 |
1411008 | 1411008 | 2021-06-12 | Orange | Florida | 12095 | 141941 | 1310 |
1407763 | 1407763 | 2021-06-11 | Orange | Florida | 12095 | 141941 | 1310 |
1404517 | 1404517 | 2021-06-10 | Orange | Florida | 12095 | 141041 | 1309 |
1401272 | 1401272 | 2021-06-09 | Orange | Florida | 12095 | 141041 | 1309 |
1398027 | 1398027 | 2021-06-08 | Orange | Florida | 12095 | 141041 | 1309 |
1394780 | 1394780 | 2021-06-07 | Orange | Florida | 12095 | 141041 | 1309 |
1391535 | 1391535 | 2021-06-06 | Orange | Florida | 12095 | 141041 | 1309 |
1388290 | 1388290 | 2021-06-05 | Orange | Florida | 12095 | 141041 | 1309 |
1385045 | 1385045 | 2021-06-04 | Orange | Florida | 12095 | 141041 | 1309 |
1381799 | 1381799 | 2021-06-03 | Orange | Florida | 12095 | 143197 | 1309 |
1378554 | 1378554 | 2021-06-02 | Orange | Florida | 12095 | 143050 | 1309 |
1375308 | 1375308 | 2021-06-01 | Orange | Florida | 12095 | 143000 | 1308 |
1372063 | 1372063 | 2021-05-31 | Orange | Florida | 12095 | 142540 | 1301 |
1368818 | 1368818 | 2021-05-30 | Orange | Florida | 12095 | 142540 | 1301 |
1365572 | 1365572 | 2021-05-29 | Orange | Florida | 12095 | 142540 | 1301 |
1362326 | 1362326 | 2021-05-28 | Orange | Florida | 12095 | 142540 | 1301 |
1359079 | 1359079 | 2021-05-27 | Orange | Florida | 12095 | 142369 | 1299 |
1355833 | 1355833 | 2021-05-26 | Orange | Florida | 12095 | 142216 | 1299 |
1352587 | 1352587 | 2021-05-25 | Orange | Florida | 12095 | 142019 | 1293 |
1349341 | 1349341 | 2021-05-24 | Orange | Florida | 12095 | 141855 | 1292 |
1346094 | 1346094 | 2021-05-23 | Orange | Florida | 12095 | 141736 | 1292 |
1342846 | 1342846 | 2021-05-22 | Orange | Florida | 12095 | 141617 | 1291 |
1339598 | 1339598 | 2021-05-21 | Orange | Florida | 12095 | 141374 | 1290 |
1336351 | 1336351 | 2021-05-20 | Orange | Florida | 12095 | 141232 | 1288 |
1333104 | 1333104 | 2021-05-19 | Orange | Florida | 12095 | 141055 | 1287 |
1329857 | 1329857 | 2021-05-18 | Orange | Florida | 12095 | 140872 | 1282 |
1326610 | 1326610 | 2021-05-17 | Orange | Florida | 12095 | 140673 | 1282 |
1323364 | 1323364 | 2021-05-16 | Orange | Florida | 12095 | 140534 | 1282 |
1320118 | 1320118 | 2021-05-15 | Orange | Florida | 12095 | 140371 | 1282 |
1316871 | 1316871 | 2021-05-14 | Orange | Florida | 12095 | 140131 | 1281 |
1313624 | 1313624 | 2021-05-13 | Orange | Florida | 12095 | 139842 | 1278 |
1310377 | 1310377 | 2021-05-12 | Orange | Florida | 12095 | 139507 | 1277 |
1307131 | 1307131 | 2021-05-11 | Orange | Florida | 12095 | 139338 | 1273 |
1303885 | 1303885 | 2021-05-10 | Orange | Florida | 12095 | 139135 | 1274 |
1300638 | 1300638 | 2021-05-09 | Orange | Florida | 12095 | 138988 | 1269 |
1297391 | 1297391 | 2021-05-08 | Orange | Florida | 12095 | 138734 | 1269 |
1294145 | 1294145 | 2021-05-07 | Orange | Florida | 12095 | 138413 | 1269 |
1290899 | 1290899 | 2021-05-06 | Orange | Florida | 12095 | 138097 | 1267 |
1287653 | 1287653 | 2021-05-05 | Orange | Florida | 12095 | 137734 | 1260 |
1284407 | 1284407 | 2021-05-04 | Orange | Florida | 12095 | 137433 | 1252 |
1281160 | 1281160 | 2021-05-03 | Orange | Florida | 12095 | 137156 | 1251 |
1277913 | 1277913 | 2021-05-02 | Orange | Florida | 12095 | 136966 | 1251 |
1274666 | 1274666 | 2021-05-01 | Orange | Florida | 12095 | 136672 | 1248 |
1271419 | 1271419 | 2021-04-30 | Orange | Florida | 12095 | 136326 | 1245 |
1268172 | 1268172 | 2021-04-29 | Orange | Florida | 12095 | 135931 | 1245 |
1264925 | 1264925 | 2021-04-28 | Orange | Florida | 12095 | 135543 | 1238 |
1261678 | 1261678 | 2021-04-27 | Orange | Florida | 12095 | 135127 | 1238 |
1258431 | 1258431 | 2021-04-26 | Orange | Florida | 12095 | 134776 | 1237 |
1255184 | 1255184 | 2021-04-25 | Orange | Florida | 12095 | 134551 | 1230 |
1251937 | 1251937 | 2021-04-24 | Orange | Florida | 12095 | 134168 | 1230 |
1248690 | 1248690 | 2021-04-23 | Orange | Florida | 12095 | 133573 | 1231 |
1245443 | 1245443 | 2021-04-22 | Orange | Florida | 12095 | 133210 | 1230 |
1242196 | 1242196 | 2021-04-21 | Orange | Florida | 12095 | 132715 | 1230 |
1238949 | 1238949 | 2021-04-20 | Orange | Florida | 12095 | 132354 | 1230 |
1235702 | 1235702 | 2021-04-19 | Orange | Florida | 12095 | 132052 | 1227 |
1232455 | 1232455 | 2021-04-18 | Orange | Florida | 12095 | 131737 | 1223 |
1229206 | 1229206 | 2021-04-17 | Orange | Florida | 12095 | 131311 | 1223 |
1225958 | 1225958 | 2021-04-16 | Orange | Florida | 12095 | 130888 | 1222 |
1222711 | 1222711 | 2021-04-15 | Orange | Florida | 12095 | 130365 | 1220 |
1219463 | 1219463 | 2021-04-14 | Orange | Florida | 12095 | 129838 | 1215 |
1216215 | 1216215 | 2021-04-13 | Orange | Florida | 12095 | 129365 | 1213 |
1212968 | 1212968 | 2021-04-12 | Orange | Florida | 12095 | 128699 | 1213 |
1209720 | 1209720 | 2021-04-11 | Orange | Florida | 12095 | 128563 | 1213 |
1206471 | 1206471 | 2021-04-10 | Orange | Florida | 12095 | 128194 | 1212 |
1203223 | 1203223 | 2021-04-09 | Orange | Florida | 12095 | 127690 | 1209 |
1199975 | 1199975 | 2021-04-08 | Orange | Florida | 12095 | 127152 | 1205 |
1196726 | 1196726 | 2021-04-07 | Orange | Florida | 12095 | 126467 | 1197 |
1193478 | 1193478 | 2021-04-06 | Orange | Florida | 12095 | 126043 | 1197 |
1190228 | 1190228 | 2021-04-05 | Orange | Florida | 12095 | 125660 | 1197 |
1186981 | 1186981 | 2021-04-04 | Orange | Florida | 12095 | 125413 | 1189 |
1183734 | 1183734 | 2021-04-03 | Orange | Florida | 12095 | 125107 | 1189 |
1180487 | 1180487 | 2021-04-02 | Orange | Florida | 12095 | 124686 | 1188 |
1177240 | 1177240 | 2021-04-01 | Orange | Florida | 12095 | 124226 | 1188 |
1173993 | 1173993 | 2021-03-31 | Orange | Florida | 12095 | 123682 | 1185 |
1170746 | 1170746 | 2021-03-30 | Orange | Florida | 12095 | 123351 | 1184 |
1167498 | 1167498 | 2021-03-29 | Orange | Florida | 12095 | 123017 | 1181 |
1164250 | 1164250 | 2021-03-28 | Orange | Florida | 12095 | 122799 | 1174 |
1161002 | 1161002 | 2021-03-27 | Orange | Florida | 12095 | 122409 | 1173 |
1157754 | 1157754 | 2021-03-26 | Orange | Florida | 12095 | 121979 | 1172 |
1154507 | 1154507 | 2021-03-25 | Orange | Florida | 12095 | 121573 | 1172 |
1151260 | 1151260 | 2021-03-24 | Orange | Florida | 12095 | 121172 | 1168 |
1148013 | 1148013 | 2021-03-23 | Orange | Florida | 12095 | 120794 | 1169 |
1144766 | 1144766 | 2021-03-22 | Orange | Florida | 12095 | 120411 | 1168 |
1141519 | 1141519 | 2021-03-21 | Orange | Florida | 12095 | 120182 | 1160 |
1138273 | 1138273 | 2021-03-20 | Orange | Florida | 12095 | 119870 | 1160 |
1135027 | 1135027 | 2021-03-19 | Orange | Florida | 12095 | 119542 | 1158 |
1131780 | 1131780 | 2021-03-18 | Orange | Florida | 12095 | 119223 | 1157 |
1128532 | 1128532 | 2021-03-17 | Orange | Florida | 12095 | 118901 | 1149 |
1125286 | 1125286 | 2021-03-16 | Orange | Florida | 12095 | 118626 | 1148 |
1122040 | 1122040 | 2021-03-15 | Orange | Florida | 12095 | 118320 | 1146 |
1118793 | 1118793 | 2021-03-14 | Orange | Florida | 12095 | 118153 | 1140 |
1115546 | 1115546 | 2021-03-13 | Orange | Florida | 12095 | 117905 | 1139 |
1112300 | 1112300 | 2021-03-12 | Orange | Florida | 12095 | 117596 | 1138 |
1109054 | 1109054 | 2021-03-11 | Orange | Florida | 12095 | 117307 | 1137 |
1105808 | 1105808 | 2021-03-10 | Orange | Florida | 12095 | 117030 | 1126 |
1102562 | 1102562 | 2021-03-09 | Orange | Florida | 12095 | 116773 | 1127 |
1099316 | 1099316 | 2021-03-08 | Orange | Florida | 12095 | 116528 | 1125 |
1096068 | 1096068 | 2021-03-07 | Orange | Florida | 12095 | 116366 | 1125 |
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);