ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
833 rows where fips = 25025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1493022 | 1493022 | 2021-07-07 | Suffolk | Massachusetts | 25025 | 93206 | 1850 |
1489775 | 1489775 | 2021-07-06 | Suffolk | Massachusetts | 25025 | 93199 | 1850 |
1486528 | 1486528 | 2021-07-05 | Suffolk | Massachusetts | 25025 | 93172 | 1849 |
1483282 | 1483282 | 2021-07-04 | Suffolk | Massachusetts | 25025 | 93172 | 1849 |
1480036 | 1480036 | 2021-07-03 | Suffolk | Massachusetts | 25025 | 93172 | 1849 |
1476789 | 1476789 | 2021-07-02 | Suffolk | Massachusetts | 25025 | 93172 | 1849 |
1473543 | 1473543 | 2021-07-01 | Suffolk | Massachusetts | 25025 | 93159 | 1849 |
1470297 | 1470297 | 2021-06-30 | Suffolk | Massachusetts | 25025 | 93146 | 1848 |
1467052 | 1467052 | 2021-06-29 | Suffolk | Massachusetts | 25025 | 93134 | 1848 |
1463807 | 1463807 | 2021-06-28 | Suffolk | Massachusetts | 25025 | 93128 | 1848 |
1460562 | 1460562 | 2021-06-27 | Suffolk | Massachusetts | 25025 | 93119 | 1847 |
1457317 | 1457317 | 2021-06-26 | Suffolk | Massachusetts | 25025 | 93114 | 1847 |
1454072 | 1454072 | 2021-06-25 | Suffolk | Massachusetts | 25025 | 93102 | 1847 |
1450827 | 1450827 | 2021-06-24 | Suffolk | Massachusetts | 25025 | 93091 | 1847 |
1447581 | 1447581 | 2021-06-23 | Suffolk | Massachusetts | 25025 | 93078 | 1847 |
1444336 | 1444336 | 2021-06-22 | Suffolk | Massachusetts | 25025 | 93068 | 1847 |
1441091 | 1441091 | 2021-06-21 | Suffolk | Massachusetts | 25025 | 93060 | 1847 |
1437845 | 1437845 | 2021-06-20 | Suffolk | Massachusetts | 25025 | 93057 | 1847 |
1434598 | 1434598 | 2021-06-19 | Suffolk | Massachusetts | 25025 | 93051 | 1846 |
1431351 | 1431351 | 2021-06-18 | Suffolk | Massachusetts | 25025 | 93039 | 1845 |
1428106 | 1428106 | 2021-06-17 | Suffolk | Massachusetts | 25025 | 93028 | 1845 |
1424861 | 1424861 | 2021-06-16 | Suffolk | Massachusetts | 25025 | 93019 | 1845 |
1421613 | 1421613 | 2021-06-15 | Suffolk | Massachusetts | 25025 | 93011 | 1845 |
1418368 | 1418368 | 2021-06-14 | Suffolk | Massachusetts | 25025 | 93002 | 1845 |
1415123 | 1415123 | 2021-06-13 | Suffolk | Massachusetts | 25025 | 92991 | 1845 |
1411877 | 1411877 | 2021-06-12 | Suffolk | Massachusetts | 25025 | 92989 | 1845 |
1408632 | 1408632 | 2021-06-11 | Suffolk | Massachusetts | 25025 | 92983 | 1844 |
1405387 | 1405387 | 2021-06-10 | Suffolk | Massachusetts | 25025 | 92958 | 1844 |
1402141 | 1402141 | 2021-06-09 | Suffolk | Massachusetts | 25025 | 92948 | 1842 |
1398896 | 1398896 | 2021-06-08 | Suffolk | Massachusetts | 25025 | 92925 | 1842 |
1395650 | 1395650 | 2021-06-07 | Suffolk | Massachusetts | 25025 | 92917 | 1842 |
1392404 | 1392404 | 2021-06-06 | Suffolk | Massachusetts | 25025 | 92894 | 1842 |
1389159 | 1389159 | 2021-06-05 | Suffolk | Massachusetts | 25025 | 92866 | 1842 |
1385914 | 1385914 | 2021-06-04 | Suffolk | Massachusetts | 25025 | 92831 | 1841 |
1382669 | 1382669 | 2021-06-03 | Suffolk | Massachusetts | 25025 | 92800 | 1838 |
1379423 | 1379423 | 2021-06-02 | Suffolk | Massachusetts | 25025 | 92769 | 1838 |
1376178 | 1376178 | 2021-06-01 | Suffolk | Massachusetts | 25025 | 92763 | 1838 |
1372932 | 1372932 | 2021-05-31 | Suffolk | Massachusetts | 25025 | 92743 | 1838 |
1369687 | 1369687 | 2021-05-30 | Suffolk | Massachusetts | 25025 | 92743 | 1838 |
1366441 | 1366441 | 2021-05-29 | Suffolk | Massachusetts | 25025 | 92735 | 1838 |
1363195 | 1363195 | 2021-05-28 | Suffolk | Massachusetts | 25025 | 92705 | 1836 |
1359948 | 1359948 | 2021-05-27 | Suffolk | Massachusetts | 25025 | 92659 | 1835 |
1356702 | 1356702 | 2021-05-26 | Suffolk | Massachusetts | 25025 | 92625 | 1835 |
1353456 | 1353456 | 2021-05-25 | Suffolk | Massachusetts | 25025 | 92571 | 1834 |
1350210 | 1350210 | 2021-05-24 | Suffolk | Massachusetts | 25025 | 92556 | 1834 |
1346964 | 1346964 | 2021-05-23 | Suffolk | Massachusetts | 25025 | 92529 | 1833 |
1343716 | 1343716 | 2021-05-22 | Suffolk | Massachusetts | 25025 | 92499 | 1833 |
1340467 | 1340467 | 2021-05-21 | Suffolk | Massachusetts | 25025 | 92436 | 1833 |
1337220 | 1337220 | 2021-05-20 | Suffolk | Massachusetts | 25025 | 92378 | 1833 |
1333973 | 1333973 | 2021-05-19 | Suffolk | Massachusetts | 25025 | 92313 | 1834 |
1330726 | 1330726 | 2021-05-18 | Suffolk | Massachusetts | 25025 | 92264 | 1834 |
1327479 | 1327479 | 2021-05-17 | Suffolk | Massachusetts | 25025 | 92228 | 1834 |
1324233 | 1324233 | 2021-05-16 | Suffolk | Massachusetts | 25025 | 92192 | 1831 |
1320987 | 1320987 | 2021-05-15 | Suffolk | Massachusetts | 25025 | 92137 | 1830 |
1317741 | 1317741 | 2021-05-14 | Suffolk | Massachusetts | 25025 | 92035 | 1829 |
1314493 | 1314493 | 2021-05-13 | Suffolk | Massachusetts | 25025 | 91997 | 1827 |
1311247 | 1311247 | 2021-05-12 | Suffolk | Massachusetts | 25025 | 91910 | 1826 |
1308000 | 1308000 | 2021-05-11 | Suffolk | Massachusetts | 25025 | 91792 | 1823 |
1304754 | 1304754 | 2021-05-10 | Suffolk | Massachusetts | 25025 | 91767 | 1823 |
1301508 | 1301508 | 2021-05-09 | Suffolk | Massachusetts | 25025 | 91727 | 1822 |
1298260 | 1298260 | 2021-05-08 | Suffolk | Massachusetts | 25025 | 91650 | 1822 |
1295014 | 1295014 | 2021-05-07 | Suffolk | Massachusetts | 25025 | 91545 | 1820 |
1291768 | 1291768 | 2021-05-06 | Suffolk | Massachusetts | 25025 | 91439 | 1820 |
1288522 | 1288522 | 2021-05-05 | Suffolk | Massachusetts | 25025 | 91321 | 1820 |
1285276 | 1285276 | 2021-05-04 | Suffolk | Massachusetts | 25025 | 91216 | 1820 |
1282030 | 1282030 | 2021-05-03 | Suffolk | Massachusetts | 25025 | 91138 | 1820 |
1278783 | 1278783 | 2021-05-02 | Suffolk | Massachusetts | 25025 | 91087 | 1820 |
1275536 | 1275536 | 2021-05-01 | Suffolk | Massachusetts | 25025 | 90988 | 1819 |
1272289 | 1272289 | 2021-04-30 | Suffolk | Massachusetts | 25025 | 90871 | 1817 |
1269042 | 1269042 | 2021-04-29 | Suffolk | Massachusetts | 25025 | 90736 | 1814 |
1265795 | 1265795 | 2021-04-28 | Suffolk | Massachusetts | 25025 | 90585 | 1813 |
1262548 | 1262548 | 2021-04-27 | Suffolk | Massachusetts | 25025 | 90448 | 1813 |
1259301 | 1259301 | 2021-04-26 | Suffolk | Massachusetts | 25025 | 90356 | 1812 |
1256054 | 1256054 | 2021-04-25 | Suffolk | Massachusetts | 25025 | 90245 | 1811 |
1252807 | 1252807 | 2021-04-24 | Suffolk | Massachusetts | 25025 | 90111 | 1811 |
1249560 | 1249560 | 2021-04-23 | Suffolk | Massachusetts | 25025 | 89957 | 1811 |
1246313 | 1246313 | 2021-04-22 | Suffolk | Massachusetts | 25025 | 89784 | 1811 |
1243066 | 1243066 | 2021-04-21 | Suffolk | Massachusetts | 25025 | 89605 | 1810 |
1239819 | 1239819 | 2021-04-20 | Suffolk | Massachusetts | 25025 | 89442 | 1810 |
1236572 | 1236572 | 2021-04-19 | Suffolk | Massachusetts | 25025 | 89379 | 1810 |
1233325 | 1233325 | 2021-04-18 | Suffolk | Massachusetts | 25025 | 89213 | 1809 |
1230077 | 1230077 | 2021-04-17 | Suffolk | Massachusetts | 25025 | 89050 | 1808 |
1226829 | 1226829 | 2021-04-16 | Suffolk | Massachusetts | 25025 | 88820 | 1808 |
1223581 | 1223581 | 2021-04-15 | Suffolk | Massachusetts | 25025 | 88588 | 1808 |
1220334 | 1220334 | 2021-04-14 | Suffolk | Massachusetts | 25025 | 88340 | 1807 |
1217086 | 1217086 | 2021-04-13 | Suffolk | Massachusetts | 25025 | 88116 | 1804 |
1213839 | 1213839 | 2021-04-12 | Suffolk | Massachusetts | 25025 | 87965 | 1804 |
1210591 | 1210591 | 2021-04-11 | Suffolk | Massachusetts | 25025 | 87782 | 1802 |
1207342 | 1207342 | 2021-04-10 | Suffolk | Massachusetts | 25025 | 87583 | 1802 |
1204094 | 1204094 | 2021-04-09 | Suffolk | Massachusetts | 25025 | 87274 | 1802 |
1200846 | 1200846 | 2021-04-08 | Suffolk | Massachusetts | 25025 | 86957 | 1801 |
1197597 | 1197597 | 2021-04-07 | Suffolk | Massachusetts | 25025 | 86699 | 1801 |
1194348 | 1194348 | 2021-04-06 | Suffolk | Massachusetts | 25025 | 86365 | 1801 |
1191099 | 1191099 | 2021-04-05 | Suffolk | Massachusetts | 25025 | 86144 | 1799 |
1187851 | 1187851 | 2021-04-04 | Suffolk | Massachusetts | 25025 | 85736 | 1795 |
1184604 | 1184604 | 2021-04-03 | Suffolk | Massachusetts | 25025 | 85736 | 1795 |
1181358 | 1181358 | 2021-04-02 | Suffolk | Massachusetts | 25025 | 85406 | 1794 |
1178111 | 1178111 | 2021-04-01 | Suffolk | Massachusetts | 25025 | 85036 | 1791 |
1174864 | 1174864 | 2021-03-31 | Suffolk | Massachusetts | 25025 | 84646 | 1788 |
1171617 | 1171617 | 2021-03-30 | Suffolk | Massachusetts | 25025 | 84399 | 1784 |
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);