ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28113 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1623162 | 1623162 | 2021-08-16 | Pike | Mississippi | 28113 | 4190 | 116 |
1619915 | 1619915 | 2021-08-15 | Pike | Mississippi | 28113 | 4075 | 116 |
1616667 | 1616667 | 2021-08-14 | Pike | Mississippi | 28113 | 4075 | 116 |
1613419 | 1613419 | 2021-08-13 | Pike | Mississippi | 28113 | 4075 | 116 |
1610170 | 1610170 | 2021-08-12 | Pike | Mississippi | 28113 | 4008 | 116 |
1606922 | 1606922 | 2021-08-11 | Pike | Mississippi | 28113 | 3978 | 116 |
1603673 | 1603673 | 2021-08-10 | Pike | Mississippi | 28113 | 3934 | 116 |
1600424 | 1600424 | 2021-08-09 | Pike | Mississippi | 28113 | 3887 | 115 |
1597176 | 1597176 | 2021-08-08 | Pike | Mississippi | 28113 | 3814 | 115 |
1593927 | 1593927 | 2021-08-07 | Pike | Mississippi | 28113 | 3814 | 115 |
1590678 | 1590678 | 2021-08-06 | Pike | Mississippi | 28113 | 3814 | 115 |
1587429 | 1587429 | 2021-08-05 | Pike | Mississippi | 28113 | 3797 | 115 |
1584178 | 1584178 | 2021-08-04 | Pike | Mississippi | 28113 | 3771 | 114 |
1580929 | 1580929 | 2021-08-03 | Pike | Mississippi | 28113 | 3739 | 114 |
1577680 | 1577680 | 2021-08-02 | Pike | Mississippi | 28113 | 3711 | 113 |
1574432 | 1574432 | 2021-08-01 | Pike | Mississippi | 28113 | 3667 | 113 |
1571184 | 1571184 | 2021-07-31 | Pike | Mississippi | 28113 | 3667 | 113 |
1567936 | 1567936 | 2021-07-30 | Pike | Mississippi | 28113 | 3667 | 113 |
1564688 | 1564688 | 2021-07-29 | Pike | Mississippi | 28113 | 3650 | 113 |
1561440 | 1561440 | 2021-07-28 | Pike | Mississippi | 28113 | 3624 | 113 |
1558192 | 1558192 | 2021-07-27 | Pike | Mississippi | 28113 | 3605 | 113 |
1554945 | 1554945 | 2021-07-26 | Pike | Mississippi | 28113 | 3592 | 112 |
1551698 | 1551698 | 2021-07-25 | Pike | Mississippi | 28113 | 3530 | 112 |
1548451 | 1548451 | 2021-07-24 | Pike | Mississippi | 28113 | 3530 | 112 |
1545204 | 1545204 | 2021-07-23 | Pike | Mississippi | 28113 | 3530 | 112 |
1541956 | 1541956 | 2021-07-22 | Pike | Mississippi | 28113 | 3511 | 111 |
1538709 | 1538709 | 2021-07-21 | Pike | Mississippi | 28113 | 3488 | 111 |
1535462 | 1535462 | 2021-07-20 | Pike | Mississippi | 28113 | 3477 | 111 |
1532214 | 1532214 | 2021-07-19 | Pike | Mississippi | 28113 | 3466 | 111 |
1528967 | 1528967 | 2021-07-18 | Pike | Mississippi | 28113 | 3436 | 111 |
1525720 | 1525720 | 2021-07-17 | Pike | Mississippi | 28113 | 3436 | 111 |
1522473 | 1522473 | 2021-07-16 | Pike | Mississippi | 28113 | 3436 | 111 |
1519224 | 1519224 | 2021-07-15 | Pike | Mississippi | 28113 | 3430 | 111 |
1515977 | 1515977 | 2021-07-14 | Pike | Mississippi | 28113 | 3422 | 111 |
1512731 | 1512731 | 2021-07-13 | Pike | Mississippi | 28113 | 3407 | 111 |
1509484 | 1509484 | 2021-07-12 | Pike | Mississippi | 28113 | 3406 | 111 |
1506238 | 1506238 | 2021-07-11 | Pike | Mississippi | 28113 | 3403 | 111 |
1502992 | 1502992 | 2021-07-10 | Pike | Mississippi | 28113 | 3403 | 111 |
1499746 | 1499746 | 2021-07-09 | Pike | Mississippi | 28113 | 3403 | 111 |
1496500 | 1496500 | 2021-07-08 | Pike | Mississippi | 28113 | 3399 | 111 |
1493253 | 1493253 | 2021-07-07 | Pike | Mississippi | 28113 | 3398 | 111 |
1490006 | 1490006 | 2021-07-06 | Pike | Mississippi | 28113 | 3395 | 111 |
1486759 | 1486759 | 2021-07-05 | Pike | Mississippi | 28113 | 3392 | 111 |
1483513 | 1483513 | 2021-07-04 | Pike | Mississippi | 28113 | 3392 | 111 |
1480267 | 1480267 | 2021-07-03 | Pike | Mississippi | 28113 | 3392 | 111 |
1477020 | 1477020 | 2021-07-02 | Pike | Mississippi | 28113 | 3392 | 111 |
1473774 | 1473774 | 2021-07-01 | Pike | Mississippi | 28113 | 3382 | 111 |
1470528 | 1470528 | 2021-06-30 | Pike | Mississippi | 28113 | 3380 | 111 |
1467283 | 1467283 | 2021-06-29 | Pike | Mississippi | 28113 | 3377 | 111 |
1464038 | 1464038 | 2021-06-28 | Pike | Mississippi | 28113 | 3377 | 111 |
1460793 | 1460793 | 2021-06-27 | Pike | Mississippi | 28113 | 3376 | 111 |
1457548 | 1457548 | 2021-06-26 | Pike | Mississippi | 28113 | 3376 | 111 |
1454303 | 1454303 | 2021-06-25 | Pike | Mississippi | 28113 | 3376 | 111 |
1451058 | 1451058 | 2021-06-24 | Pike | Mississippi | 28113 | 3375 | 111 |
1447812 | 1447812 | 2021-06-23 | Pike | Mississippi | 28113 | 3374 | 111 |
1444567 | 1444567 | 2021-06-22 | Pike | Mississippi | 28113 | 3373 | 111 |
1441322 | 1441322 | 2021-06-21 | Pike | Mississippi | 28113 | 3372 | 111 |
1438076 | 1438076 | 2021-06-20 | Pike | Mississippi | 28113 | 3371 | 111 |
1434829 | 1434829 | 2021-06-19 | Pike | Mississippi | 28113 | 3371 | 111 |
1431582 | 1431582 | 2021-06-18 | Pike | Mississippi | 28113 | 3371 | 111 |
1428337 | 1428337 | 2021-06-17 | Pike | Mississippi | 28113 | 3369 | 111 |
1425092 | 1425092 | 2021-06-16 | Pike | Mississippi | 28113 | 3368 | 111 |
1421844 | 1421844 | 2021-06-15 | Pike | Mississippi | 28113 | 3368 | 111 |
1418599 | 1418599 | 2021-06-14 | Pike | Mississippi | 28113 | 3366 | 110 |
1415354 | 1415354 | 2021-06-13 | Pike | Mississippi | 28113 | 3366 | 110 |
1412108 | 1412108 | 2021-06-12 | Pike | Mississippi | 28113 | 3366 | 110 |
1408863 | 1408863 | 2021-06-11 | Pike | Mississippi | 28113 | 3366 | 110 |
1405618 | 1405618 | 2021-06-10 | Pike | Mississippi | 28113 | 3365 | 109 |
1402372 | 1402372 | 2021-06-09 | Pike | Mississippi | 28113 | 3363 | 108 |
1399127 | 1399127 | 2021-06-08 | Pike | Mississippi | 28113 | 3362 | 108 |
1395881 | 1395881 | 2021-06-07 | Pike | Mississippi | 28113 | 3359 | 107 |
1392635 | 1392635 | 2021-06-06 | Pike | Mississippi | 28113 | 3356 | 107 |
1389390 | 1389390 | 2021-06-05 | Pike | Mississippi | 28113 | 3356 | 107 |
1386145 | 1386145 | 2021-06-04 | Pike | Mississippi | 28113 | 3356 | 107 |
1382900 | 1382900 | 2021-06-03 | Pike | Mississippi | 28113 | 3355 | 107 |
1379654 | 1379654 | 2021-06-02 | Pike | Mississippi | 28113 | 3354 | 107 |
1376409 | 1376409 | 2021-06-01 | Pike | Mississippi | 28113 | 3354 | 107 |
1373163 | 1373163 | 2021-05-31 | Pike | Mississippi | 28113 | 3353 | 107 |
1369918 | 1369918 | 2021-05-30 | Pike | Mississippi | 28113 | 3352 | 107 |
1366672 | 1366672 | 2021-05-29 | Pike | Mississippi | 28113 | 3352 | 107 |
1363426 | 1363426 | 2021-05-28 | Pike | Mississippi | 28113 | 3352 | 107 |
1360179 | 1360179 | 2021-05-27 | Pike | Mississippi | 28113 | 3351 | 106 |
1356933 | 1356933 | 2021-05-26 | Pike | Mississippi | 28113 | 3350 | 106 |
1353687 | 1353687 | 2021-05-25 | Pike | Mississippi | 28113 | 3347 | 106 |
1350441 | 1350441 | 2021-05-24 | Pike | Mississippi | 28113 | 3347 | 106 |
1347195 | 1347195 | 2021-05-23 | Pike | Mississippi | 28113 | 3338 | 106 |
1343947 | 1343947 | 2021-05-22 | Pike | Mississippi | 28113 | 3338 | 106 |
1340698 | 1340698 | 2021-05-21 | Pike | Mississippi | 28113 | 3338 | 106 |
1337451 | 1337451 | 2021-05-20 | Pike | Mississippi | 28113 | 3337 | 106 |
1334204 | 1334204 | 2021-05-19 | Pike | Mississippi | 28113 | 3334 | 105 |
1330957 | 1330957 | 2021-05-18 | Pike | Mississippi | 28113 | 3331 | 105 |
1327710 | 1327710 | 2021-05-17 | Pike | Mississippi | 28113 | 3330 | 105 |
1324464 | 1324464 | 2021-05-16 | Pike | Mississippi | 28113 | 3327 | 105 |
1321218 | 1321218 | 2021-05-15 | Pike | Mississippi | 28113 | 3327 | 105 |
1317972 | 1317972 | 2021-05-14 | Pike | Mississippi | 28113 | 3327 | 105 |
1314724 | 1314724 | 2021-05-13 | Pike | Mississippi | 28113 | 3325 | 105 |
1311478 | 1311478 | 2021-05-12 | Pike | Mississippi | 28113 | 3321 | 105 |
1308231 | 1308231 | 2021-05-11 | Pike | Mississippi | 28113 | 3316 | 105 |
1304985 | 1304985 | 2021-05-10 | Pike | Mississippi | 28113 | 3310 | 105 |
1301739 | 1301739 | 2021-05-09 | Pike | Mississippi | 28113 | 3301 | 105 |
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);