ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 44003 and state = "Rhode Island" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419538 | 1419538 | 2021-06-14 | Kent | Rhode Island | 44003 | 18778 | 366 |
1416293 | 1416293 | 2021-06-13 | Kent | Rhode Island | 44003 | 18778 | 366 |
1413047 | 1413047 | 2021-06-12 | Kent | Rhode Island | 44003 | 18778 | 366 |
1409802 | 1409802 | 2021-06-11 | Kent | Rhode Island | 44003 | 18778 | 366 |
1406557 | 1406557 | 2021-06-10 | Kent | Rhode Island | 44003 | 18778 | 366 |
1403311 | 1403311 | 2021-06-09 | Kent | Rhode Island | 44003 | 18778 | 366 |
1400066 | 1400066 | 2021-06-08 | Kent | Rhode Island | 44003 | 18759 | 365 |
1396821 | 1396821 | 2021-06-07 | Kent | Rhode Island | 44003 | 18759 | 365 |
1393574 | 1393574 | 2021-06-06 | Kent | Rhode Island | 44003 | 18759 | 365 |
1390329 | 1390329 | 2021-06-05 | Kent | Rhode Island | 44003 | 18759 | 365 |
1387084 | 1387084 | 2021-06-04 | Kent | Rhode Island | 44003 | 18759 | 365 |
1383839 | 1383839 | 2021-06-03 | Kent | Rhode Island | 44003 | 18759 | 365 |
1380593 | 1380593 | 2021-06-02 | Kent | Rhode Island | 44003 | 18715 | 365 |
1377348 | 1377348 | 2021-06-01 | Kent | Rhode Island | 44003 | 18715 | 365 |
1374102 | 1374102 | 2021-05-31 | Kent | Rhode Island | 44003 | 18715 | 365 |
1370857 | 1370857 | 2021-05-30 | Kent | Rhode Island | 44003 | 18715 | 365 |
1367611 | 1367611 | 2021-05-29 | Kent | Rhode Island | 44003 | 18715 | 365 |
1364365 | 1364365 | 2021-05-28 | Kent | Rhode Island | 44003 | 18715 | 365 |
1361119 | 1361119 | 2021-05-27 | Kent | Rhode Island | 44003 | 18715 | 365 |
1357873 | 1357873 | 2021-05-26 | Kent | Rhode Island | 44003 | 18715 | 365 |
1354627 | 1354627 | 2021-05-25 | Kent | Rhode Island | 44003 | 18715 | 365 |
1351381 | 1351381 | 2021-05-24 | Kent | Rhode Island | 44003 | 18715 | 365 |
1348135 | 1348135 | 2021-05-23 | Kent | Rhode Island | 44003 | 18525 | 361 |
1344887 | 1344887 | 2021-05-22 | Kent | Rhode Island | 44003 | 18525 | 361 |
1341639 | 1341639 | 2021-05-21 | Kent | Rhode Island | 44003 | 18525 | 361 |
1338391 | 1338391 | 2021-05-20 | Kent | Rhode Island | 44003 | 18525 | 361 |
1335144 | 1335144 | 2021-05-19 | Kent | Rhode Island | 44003 | 18525 | 361 |
1331897 | 1331897 | 2021-05-18 | Kent | Rhode Island | 44003 | 18525 | 361 |
1328650 | 1328650 | 2021-05-17 | Kent | Rhode Island | 44003 | 18525 | 361 |
1325404 | 1325404 | 2021-05-16 | Kent | Rhode Island | 44003 | 18525 | 361 |
1322158 | 1322158 | 2021-05-15 | Kent | Rhode Island | 44003 | 18525 | 361 |
1318912 | 1318912 | 2021-05-14 | Kent | Rhode Island | 44003 | 18525 | 361 |
1315664 | 1315664 | 2021-05-13 | Kent | Rhode Island | 44003 | 18525 | 361 |
1312418 | 1312418 | 2021-05-12 | Kent | Rhode Island | 44003 | 18525 | 361 |
1309171 | 1309171 | 2021-05-11 | Kent | Rhode Island | 44003 | 18337 | 361 |
1305925 | 1305925 | 2021-05-10 | Kent | Rhode Island | 44003 | 18337 | 361 |
1302679 | 1302679 | 2021-05-09 | Kent | Rhode Island | 44003 | 18337 | 361 |
1299432 | 1299432 | 2021-05-08 | Kent | Rhode Island | 44003 | 18337 | 361 |
1296185 | 1296185 | 2021-05-07 | Kent | Rhode Island | 44003 | 18337 | 361 |
1292939 | 1292939 | 2021-05-06 | Kent | Rhode Island | 44003 | 18337 | 361 |
1289693 | 1289693 | 2021-05-05 | Kent | Rhode Island | 44003 | 18337 | 361 |
1286447 | 1286447 | 2021-05-04 | Kent | Rhode Island | 44003 | 18092 | 360 |
1283201 | 1283201 | 2021-05-03 | Kent | Rhode Island | 44003 | 18092 | 360 |
1279954 | 1279954 | 2021-05-02 | Kent | Rhode Island | 44003 | 18092 | 360 |
1276707 | 1276707 | 2021-05-01 | Kent | Rhode Island | 44003 | 18092 | 360 |
1273460 | 1273460 | 2021-04-30 | Kent | Rhode Island | 44003 | 18092 | 360 |
1270213 | 1270213 | 2021-04-29 | Kent | Rhode Island | 44003 | 18092 | 360 |
1266966 | 1266966 | 2021-04-28 | Kent | Rhode Island | 44003 | 18092 | 360 |
1263719 | 1263719 | 2021-04-27 | Kent | Rhode Island | 44003 | 17851 | 356 |
1260472 | 1260472 | 2021-04-26 | Kent | Rhode Island | 44003 | 17851 | 356 |
1257225 | 1257225 | 2021-04-25 | Kent | Rhode Island | 44003 | 17851 | 356 |
1253978 | 1253978 | 2021-04-24 | Kent | Rhode Island | 44003 | 17851 | 356 |
1250731 | 1250731 | 2021-04-23 | Kent | Rhode Island | 44003 | 17851 | 356 |
1247484 | 1247484 | 2021-04-22 | Kent | Rhode Island | 44003 | 17851 | 356 |
1244237 | 1244237 | 2021-04-21 | Kent | Rhode Island | 44003 | 17851 | 356 |
1240990 | 1240990 | 2021-04-20 | Kent | Rhode Island | 44003 | 17485 | 355 |
1237743 | 1237743 | 2021-04-19 | Kent | Rhode Island | 44003 | 17485 | 355 |
1234496 | 1234496 | 2021-04-18 | Kent | Rhode Island | 44003 | 17485 | 355 |
1231248 | 1231248 | 2021-04-17 | Kent | Rhode Island | 44003 | 17485 | 355 |
1228000 | 1228000 | 2021-04-16 | Kent | Rhode Island | 44003 | 17485 | 355 |
1224752 | 1224752 | 2021-04-15 | Kent | Rhode Island | 44003 | 17485 | 355 |
1221505 | 1221505 | 2021-04-14 | Kent | Rhode Island | 44003 | 17072 | 348 |
1218257 | 1218257 | 2021-04-13 | Kent | Rhode Island | 44003 | 17072 | 348 |
1215009 | 1215009 | 2021-04-12 | Kent | Rhode Island | 44003 | 17072 | 348 |
1211762 | 1211762 | 2021-04-11 | Kent | Rhode Island | 44003 | 17072 | 348 |
1208513 | 1208513 | 2021-04-10 | Kent | Rhode Island | 44003 | 17072 | 348 |
1205265 | 1205265 | 2021-04-09 | Kent | Rhode Island | 44003 | 17072 | 348 |
1202017 | 1202017 | 2021-04-08 | Kent | Rhode Island | 44003 | 17072 | 348 |
1198768 | 1198768 | 2021-04-07 | Kent | Rhode Island | 44003 | 17072 | 348 |
1195519 | 1195519 | 2021-04-06 | Kent | Rhode Island | 44003 | 16664 | 344 |
1192271 | 1192271 | 2021-04-05 | Kent | Rhode Island | 44003 | 16664 | 344 |
1189022 | 1189022 | 2021-04-04 | Kent | Rhode Island | 44003 | 16664 | 344 |
1185775 | 1185775 | 2021-04-03 | Kent | Rhode Island | 44003 | 16664 | 344 |
1182528 | 1182528 | 2021-04-02 | Kent | Rhode Island | 44003 | 16664 | 344 |
1179281 | 1179281 | 2021-04-01 | Kent | Rhode Island | 44003 | 16664 | 344 |
1176034 | 1176034 | 2021-03-31 | Kent | Rhode Island | 44003 | 16664 | 344 |
1172787 | 1172787 | 2021-03-30 | Kent | Rhode Island | 44003 | 16330 | 344 |
1169540 | 1169540 | 2021-03-29 | Kent | Rhode Island | 44003 | 16330 | 344 |
1166292 | 1166292 | 2021-03-28 | Kent | Rhode Island | 44003 | 16330 | 344 |
1163044 | 1163044 | 2021-03-27 | Kent | Rhode Island | 44003 | 16330 | 344 |
1159795 | 1159795 | 2021-03-26 | Kent | Rhode Island | 44003 | 16330 | 344 |
1156548 | 1156548 | 2021-03-25 | Kent | Rhode Island | 44003 | 16330 | 344 |
1153301 | 1153301 | 2021-03-24 | Kent | Rhode Island | 44003 | 16330 | 344 |
1150054 | 1150054 | 2021-03-23 | Kent | Rhode Island | 44003 | 16047 | 337 |
1146807 | 1146807 | 2021-03-22 | Kent | Rhode Island | 44003 | 16047 | 337 |
1143560 | 1143560 | 2021-03-21 | Kent | Rhode Island | 44003 | 16047 | 337 |
1140313 | 1140313 | 2021-03-20 | Kent | Rhode Island | 44003 | 16047 | 337 |
1137067 | 1137067 | 2021-03-19 | Kent | Rhode Island | 44003 | 16047 | 337 |
1133821 | 1133821 | 2021-03-18 | Kent | Rhode Island | 44003 | 16047 | 337 |
1130573 | 1130573 | 2021-03-17 | Kent | Rhode Island | 44003 | 16047 | 337 |
1127326 | 1127326 | 2021-03-16 | Kent | Rhode Island | 44003 | 15760 | 336 |
1124080 | 1124080 | 2021-03-15 | Kent | Rhode Island | 44003 | 15760 | 336 |
1120834 | 1120834 | 2021-03-14 | Kent | Rhode Island | 44003 | 15760 | 336 |
1117587 | 1117587 | 2021-03-13 | Kent | Rhode Island | 44003 | 15760 | 336 |
1114340 | 1114340 | 2021-03-12 | Kent | Rhode Island | 44003 | 15760 | 336 |
1111094 | 1111094 | 2021-03-11 | Kent | Rhode Island | 44003 | 15760 | 336 |
1107848 | 1107848 | 2021-03-10 | Kent | Rhode Island | 44003 | 15760 | 336 |
1104602 | 1104602 | 2021-03-09 | Kent | Rhode Island | 44003 | 15508 | 326 |
1101356 | 1101356 | 2021-03-08 | Kent | Rhode Island | 44003 | 15508 | 326 |
1098110 | 1098110 | 2021-03-07 | Kent | Rhode Island | 44003 | 15508 | 326 |
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);