ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Charlotte" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1391495 | 1391495 | 2021-06-06 | Charlotte | Florida | 12015 | 13235 | 437 |
1388250 | 1388250 | 2021-06-05 | Charlotte | Florida | 12015 | 13235 | 437 |
1385005 | 1385005 | 2021-06-04 | Charlotte | Florida | 12015 | 13235 | 437 |
1381759 | 1381759 | 2021-06-03 | Charlotte | Florida | 12015 | 13437 | 437 |
1378514 | 1378514 | 2021-06-02 | Charlotte | Florida | 12015 | 13425 | 437 |
1375268 | 1375268 | 2021-06-01 | Charlotte | Florida | 12015 | 13413 | 437 |
1372023 | 1372023 | 2021-05-31 | Charlotte | Florida | 12015 | 13361 | 436 |
1368778 | 1368778 | 2021-05-30 | Charlotte | Florida | 12015 | 13361 | 436 |
1365532 | 1365532 | 2021-05-29 | Charlotte | Florida | 12015 | 13361 | 436 |
1362286 | 1362286 | 2021-05-28 | Charlotte | Florida | 12015 | 13361 | 436 |
1359039 | 1359039 | 2021-05-27 | Charlotte | Florida | 12015 | 13335 | 437 |
1355793 | 1355793 | 2021-05-26 | Charlotte | Florida | 12015 | 13321 | 437 |
1352547 | 1352547 | 2021-05-25 | Charlotte | Florida | 12015 | 13301 | 437 |
1349301 | 1349301 | 2021-05-24 | Charlotte | Florida | 12015 | 13289 | 429 |
1346054 | 1346054 | 2021-05-23 | Charlotte | Florida | 12015 | 13278 | 429 |
1342806 | 1342806 | 2021-05-22 | Charlotte | Florida | 12015 | 13265 | 428 |
1339558 | 1339558 | 2021-05-21 | Charlotte | Florida | 12015 | 13237 | 428 |
1336311 | 1336311 | 2021-05-20 | Charlotte | Florida | 12015 | 13209 | 427 |
1333064 | 1333064 | 2021-05-19 | Charlotte | Florida | 12015 | 13184 | 427 |
1329817 | 1329817 | 2021-05-18 | Charlotte | Florida | 12015 | 13163 | 426 |
1326570 | 1326570 | 2021-05-17 | Charlotte | Florida | 12015 | 13144 | 426 |
1323324 | 1323324 | 2021-05-16 | Charlotte | Florida | 12015 | 13131 | 425 |
1320078 | 1320078 | 2021-05-15 | Charlotte | Florida | 12015 | 13112 | 425 |
1316831 | 1316831 | 2021-05-14 | Charlotte | Florida | 12015 | 13079 | 425 |
1313584 | 1313584 | 2021-05-13 | Charlotte | Florida | 12015 | 13049 | 425 |
1310337 | 1310337 | 2021-05-12 | Charlotte | Florida | 12015 | 13024 | 425 |
1307091 | 1307091 | 2021-05-11 | Charlotte | Florida | 12015 | 12991 | 424 |
1303845 | 1303845 | 2021-05-10 | Charlotte | Florida | 12015 | 12973 | 423 |
1300598 | 1300598 | 2021-05-09 | Charlotte | Florida | 12015 | 12957 | 421 |
1297351 | 1297351 | 2021-05-08 | Charlotte | Florida | 12015 | 12934 | 420 |
1294105 | 1294105 | 2021-05-07 | Charlotte | Florida | 12015 | 12907 | 418 |
1290859 | 1290859 | 2021-05-06 | Charlotte | Florida | 12015 | 12875 | 418 |
1287613 | 1287613 | 2021-05-05 | Charlotte | Florida | 12015 | 12836 | 418 |
1284367 | 1284367 | 2021-05-04 | Charlotte | Florida | 12015 | 12815 | 418 |
1281120 | 1281120 | 2021-05-03 | Charlotte | Florida | 12015 | 12795 | 418 |
1277873 | 1277873 | 2021-05-02 | Charlotte | Florida | 12015 | 12775 | 417 |
1274626 | 1274626 | 2021-05-01 | Charlotte | Florida | 12015 | 12750 | 416 |
1271379 | 1271379 | 2021-04-30 | Charlotte | Florida | 12015 | 12716 | 416 |
1268132 | 1268132 | 2021-04-29 | Charlotte | Florida | 12015 | 12691 | 416 |
1264885 | 1264885 | 2021-04-28 | Charlotte | Florida | 12015 | 12658 | 414 |
1261638 | 1261638 | 2021-04-27 | Charlotte | Florida | 12015 | 12624 | 413 |
1258391 | 1258391 | 2021-04-26 | Charlotte | Florida | 12015 | 12587 | 411 |
1255144 | 1255144 | 2021-04-25 | Charlotte | Florida | 12015 | 12564 | 410 |
1251897 | 1251897 | 2021-04-24 | Charlotte | Florida | 12015 | 12536 | 409 |
1248650 | 1248650 | 2021-04-23 | Charlotte | Florida | 12015 | 12484 | 409 |
1245403 | 1245403 | 2021-04-22 | Charlotte | Florida | 12015 | 12463 | 406 |
1242156 | 1242156 | 2021-04-21 | Charlotte | Florida | 12015 | 12426 | 406 |
1238909 | 1238909 | 2021-04-20 | Charlotte | Florida | 12015 | 12391 | 404 |
1235662 | 1235662 | 2021-04-19 | Charlotte | Florida | 12015 | 12358 | 404 |
1232415 | 1232415 | 2021-04-18 | Charlotte | Florida | 12015 | 12331 | 404 |
1229166 | 1229166 | 2021-04-17 | Charlotte | Florida | 12015 | 12297 | 404 |
1225918 | 1225918 | 2021-04-16 | Charlotte | Florida | 12015 | 12272 | 402 |
1222671 | 1222671 | 2021-04-15 | Charlotte | Florida | 12015 | 12227 | 400 |
1219423 | 1219423 | 2021-04-14 | Charlotte | Florida | 12015 | 12178 | 400 |
1216175 | 1216175 | 2021-04-13 | Charlotte | Florida | 12015 | 12138 | 400 |
1212928 | 1212928 | 2021-04-12 | Charlotte | Florida | 12015 | 12085 | 399 |
1209680 | 1209680 | 2021-04-11 | Charlotte | Florida | 12015 | 12075 | 399 |
1206431 | 1206431 | 2021-04-10 | Charlotte | Florida | 12015 | 12034 | 396 |
1203183 | 1203183 | 2021-04-09 | Charlotte | Florida | 12015 | 11982 | 395 |
1199935 | 1199935 | 2021-04-08 | Charlotte | Florida | 12015 | 11933 | 395 |
1196686 | 1196686 | 2021-04-07 | Charlotte | Florida | 12015 | 11882 | 393 |
1193438 | 1193438 | 2021-04-06 | Charlotte | Florida | 12015 | 11842 | 393 |
1190188 | 1190188 | 2021-04-05 | Charlotte | Florida | 12015 | 11796 | 393 |
1186941 | 1186941 | 2021-04-04 | Charlotte | Florida | 12015 | 11766 | 392 |
1183694 | 1183694 | 2021-04-03 | Charlotte | Florida | 12015 | 11714 | 392 |
1180447 | 1180447 | 2021-04-02 | Charlotte | Florida | 12015 | 11668 | 392 |
1177200 | 1177200 | 2021-04-01 | Charlotte | Florida | 12015 | 11605 | 392 |
1173953 | 1173953 | 2021-03-31 | Charlotte | Florida | 12015 | 11556 | 392 |
1170706 | 1170706 | 2021-03-30 | Charlotte | Florida | 12015 | 11508 | 391 |
1167458 | 1167458 | 2021-03-29 | Charlotte | Florida | 12015 | 11475 | 391 |
1164210 | 1164210 | 2021-03-28 | Charlotte | Florida | 12015 | 11436 | 390 |
1160962 | 1160962 | 2021-03-27 | Charlotte | Florida | 12015 | 11402 | 390 |
1157714 | 1157714 | 2021-03-26 | Charlotte | Florida | 12015 | 11355 | 389 |
1154467 | 1154467 | 2021-03-25 | Charlotte | Florida | 12015 | 11313 | 389 |
1151220 | 1151220 | 2021-03-24 | Charlotte | Florida | 12015 | 11274 | 389 |
1147973 | 1147973 | 2021-03-23 | Charlotte | Florida | 12015 | 11241 | 389 |
1144726 | 1144726 | 2021-03-22 | Charlotte | Florida | 12015 | 11209 | 389 |
1141479 | 1141479 | 2021-03-21 | Charlotte | Florida | 12015 | 11187 | 389 |
1138233 | 1138233 | 2021-03-20 | Charlotte | Florida | 12015 | 11155 | 388 |
1134987 | 1134987 | 2021-03-19 | Charlotte | Florida | 12015 | 11119 | 388 |
1131740 | 1131740 | 2021-03-18 | Charlotte | Florida | 12015 | 11096 | 388 |
1128492 | 1128492 | 2021-03-17 | Charlotte | Florida | 12015 | 11074 | 388 |
1125246 | 1125246 | 2021-03-16 | Charlotte | Florida | 12015 | 11037 | 388 |
1122000 | 1122000 | 2021-03-15 | Charlotte | Florida | 12015 | 11015 | 388 |
1118753 | 1118753 | 2021-03-14 | Charlotte | Florida | 12015 | 11001 | 385 |
1115506 | 1115506 | 2021-03-13 | Charlotte | Florida | 12015 | 10978 | 383 |
1112260 | 1112260 | 2021-03-12 | Charlotte | Florida | 12015 | 10959 | 381 |
1109014 | 1109014 | 2021-03-11 | Charlotte | Florida | 12015 | 10934 | 381 |
1105768 | 1105768 | 2021-03-10 | Charlotte | Florida | 12015 | 10907 | 379 |
1102522 | 1102522 | 2021-03-09 | Charlotte | Florida | 12015 | 10884 | 376 |
1099276 | 1099276 | 2021-03-08 | Charlotte | Florida | 12015 | 10862 | 376 |
1096028 | 1096028 | 2021-03-07 | Charlotte | Florida | 12015 | 10836 | 373 |
1092782 | 1092782 | 2021-03-06 | Charlotte | Florida | 12015 | 10823 | 373 |
1089536 | 1089536 | 2021-03-05 | Charlotte | Florida | 12015 | 10801 | 373 |
1086291 | 1086291 | 2021-03-04 | Charlotte | Florida | 12015 | 10781 | 372 |
1083045 | 1083045 | 2021-03-03 | Charlotte | Florida | 12015 | 10751 | 372 |
1079799 | 1079799 | 2021-03-02 | Charlotte | Florida | 12015 | 10725 | 372 |
1076554 | 1076554 | 2021-03-01 | Charlotte | Florida | 12015 | 10698 | 370 |
1073308 | 1073308 | 2021-02-28 | Charlotte | Florida | 12015 | 10684 | 366 |
1070062 | 1070062 | 2021-02-27 | Charlotte | Florida | 12015 | 10662 | 359 |
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);