ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,704 rows where state = "Rhode Island" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 6
- Unknown 471
- Bristol 447
- Kent 447
- Newport 447
- Providence 447
- Washington 447
state 1
- Rhode Island · 2,706 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419537 | 1419537 | 2021-06-14 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1419538 | 1419538 | 2021-06-14 | Kent | Rhode Island | 44003 | 18778 | 366 |
1419539 | 1419539 | 2021-06-14 | Newport | Rhode Island | 44005 | 6941 | 42 |
1419540 | 1419540 | 2021-06-14 | Providence | Rhode Island | 44007 | 99179 | 1987 |
1419541 | 1419541 | 2021-06-14 | Unknown | Rhode Island | 12120 | 10 | |
1419542 | 1419542 | 2021-06-14 | Washington | Rhode Island | 44009 | 10080 | 172 |
1416292 | 1416292 | 2021-06-13 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1416293 | 1416293 | 2021-06-13 | Kent | Rhode Island | 44003 | 18778 | 366 |
1416294 | 1416294 | 2021-06-13 | Newport | Rhode Island | 44005 | 6941 | 42 |
1416295 | 1416295 | 2021-06-13 | Providence | Rhode Island | 44007 | 99179 | 1987 |
1416296 | 1416296 | 2021-06-13 | Unknown | Rhode Island | 12060 | 10 | |
1416297 | 1416297 | 2021-06-13 | Washington | Rhode Island | 44009 | 10080 | 172 |
1413046 | 1413046 | 2021-06-12 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1413047 | 1413047 | 2021-06-12 | Kent | Rhode Island | 44003 | 18778 | 366 |
1413048 | 1413048 | 2021-06-12 | Newport | Rhode Island | 44005 | 6941 | 42 |
1413049 | 1413049 | 2021-06-12 | Providence | Rhode Island | 44007 | 99179 | 1987 |
1413050 | 1413050 | 2021-06-12 | Unknown | Rhode Island | 12060 | 10 | |
1413051 | 1413051 | 2021-06-12 | Washington | Rhode Island | 44009 | 10080 | 172 |
1409801 | 1409801 | 2021-06-11 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1409802 | 1409802 | 2021-06-11 | Kent | Rhode Island | 44003 | 18778 | 366 |
1409803 | 1409803 | 2021-06-11 | Newport | Rhode Island | 44005 | 6941 | 42 |
1409804 | 1409804 | 2021-06-11 | Providence | Rhode Island | 44007 | 99179 | 1987 |
1409805 | 1409805 | 2021-06-11 | Unknown | Rhode Island | 12060 | 10 | |
1409806 | 1409806 | 2021-06-11 | Washington | Rhode Island | 44009 | 10080 | 172 |
1406556 | 1406556 | 2021-06-10 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1406557 | 1406557 | 2021-06-10 | Kent | Rhode Island | 44003 | 18778 | 366 |
1406558 | 1406558 | 2021-06-10 | Newport | Rhode Island | 44005 | 6941 | 42 |
1406559 | 1406559 | 2021-06-10 | Providence | Rhode Island | 44007 | 99179 | 1987 |
1406560 | 1406560 | 2021-06-10 | Unknown | Rhode Island | 12034 | 10 | |
1406561 | 1406561 | 2021-06-10 | Washington | Rhode Island | 44009 | 10080 | 172 |
1403310 | 1403310 | 2021-06-09 | Bristol | Rhode Island | 44001 | 5175 | 145 |
1403311 | 1403311 | 2021-06-09 | Kent | Rhode Island | 44003 | 18778 | 366 |
1403312 | 1403312 | 2021-06-09 | Newport | Rhode Island | 44005 | 6941 | 42 |
1403313 | 1403313 | 2021-06-09 | Providence | Rhode Island | 44007 | 99179 | 1987 |
1403314 | 1403314 | 2021-06-09 | Unknown | Rhode Island | 12000 | 10 | |
1403315 | 1403315 | 2021-06-09 | Washington | Rhode Island | 44009 | 10080 | 172 |
1400065 | 1400065 | 2021-06-08 | Bristol | Rhode Island | 44001 | 5170 | 144 |
1400066 | 1400066 | 2021-06-08 | Kent | Rhode Island | 44003 | 18759 | 365 |
1400067 | 1400067 | 2021-06-08 | Newport | Rhode Island | 44005 | 6924 | 42 |
1400068 | 1400068 | 2021-06-08 | Providence | Rhode Island | 44007 | 99011 | 1983 |
1400069 | 1400069 | 2021-06-08 | Unknown | Rhode Island | 12183 | 13 | |
1400070 | 1400070 | 2021-06-08 | Washington | Rhode Island | 44009 | 10059 | 172 |
1396820 | 1396820 | 2021-06-07 | Bristol | Rhode Island | 44001 | 5170 | 144 |
1396821 | 1396821 | 2021-06-07 | Kent | Rhode Island | 44003 | 18759 | 365 |
1396822 | 1396822 | 2021-06-07 | Newport | Rhode Island | 44005 | 6924 | 42 |
1396823 | 1396823 | 2021-06-07 | Providence | Rhode Island | 44007 | 99011 | 1983 |
1396824 | 1396824 | 2021-06-07 | Unknown | Rhode Island | 12151 | 11 | |
1396825 | 1396825 | 2021-06-07 | Washington | Rhode Island | 44009 | 10059 | 172 |
1393573 | 1393573 | 2021-06-06 | Bristol | Rhode Island | 44001 | 5170 | 144 |
1393574 | 1393574 | 2021-06-06 | Kent | Rhode Island | 44003 | 18759 | 365 |
1393575 | 1393575 | 2021-06-06 | Newport | Rhode Island | 44005 | 6924 | 42 |
1393576 | 1393576 | 2021-06-06 | Providence | Rhode Island | 44007 | 99011 | 1983 |
1393577 | 1393577 | 2021-06-06 | Unknown | Rhode Island | 12069 | 11 | |
1393578 | 1393578 | 2021-06-06 | Washington | Rhode Island | 44009 | 10059 | 172 |
1390328 | 1390328 | 2021-06-05 | Bristol | Rhode Island | 44001 | 5170 | 144 |
1390329 | 1390329 | 2021-06-05 | Kent | Rhode Island | 44003 | 18759 | 365 |
1390330 | 1390330 | 2021-06-05 | Newport | Rhode Island | 44005 | 6924 | 42 |
1390331 | 1390331 | 2021-06-05 | Providence | Rhode Island | 44007 | 99011 | 1983 |
1390332 | 1390332 | 2021-06-05 | Unknown | Rhode Island | 12069 | 11 | |
1390333 | 1390333 | 2021-06-05 | Washington | Rhode Island | 44009 | 10059 | 172 |
1387083 | 1387083 | 2021-06-04 | Bristol | Rhode Island | 44001 | 5170 | 144 |
1387084 | 1387084 | 2021-06-04 | Kent | Rhode Island | 44003 | 18759 | 365 |
1387085 | 1387085 | 2021-06-04 | Newport | Rhode Island | 44005 | 6924 | 42 |
1387086 | 1387086 | 2021-06-04 | Providence | Rhode Island | 44007 | 99011 | 1983 |
1387087 | 1387087 | 2021-06-04 | Unknown | Rhode Island | 12069 | 11 | |
1387088 | 1387088 | 2021-06-04 | Washington | Rhode Island | 44009 | 10059 | 172 |
1383838 | 1383838 | 2021-06-03 | Bristol | Rhode Island | 44001 | 5170 | 144 |
1383839 | 1383839 | 2021-06-03 | Kent | Rhode Island | 44003 | 18759 | 365 |
1383840 | 1383840 | 2021-06-03 | Newport | Rhode Island | 44005 | 6924 | 42 |
1383841 | 1383841 | 2021-06-03 | Providence | Rhode Island | 44007 | 99011 | 1983 |
1383842 | 1383842 | 2021-06-03 | Unknown | Rhode Island | 12013 | 9 | |
1383843 | 1383843 | 2021-06-03 | Washington | Rhode Island | 44009 | 10059 | 172 |
1380592 | 1380592 | 2021-06-02 | Bristol | Rhode Island | 44001 | 5153 | 144 |
1380593 | 1380593 | 2021-06-02 | Kent | Rhode Island | 44003 | 18715 | 365 |
1380594 | 1380594 | 2021-06-02 | Newport | Rhode Island | 44005 | 6891 | 42 |
1380595 | 1380595 | 2021-06-02 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1380596 | 1380596 | 2021-06-02 | Unknown | Rhode Island | 12380 | 12 | |
1380597 | 1380597 | 2021-06-02 | Washington | Rhode Island | 44009 | 10032 | 171 |
1377347 | 1377347 | 2021-06-01 | Bristol | Rhode Island | 44001 | 5153 | 144 |
1377348 | 1377348 | 2021-06-01 | Kent | Rhode Island | 44003 | 18715 | 365 |
1377349 | 1377349 | 2021-06-01 | Newport | Rhode Island | 44005 | 6891 | 42 |
1377350 | 1377350 | 2021-06-01 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1377351 | 1377351 | 2021-06-01 | Unknown | Rhode Island | 12329 | 12 | |
1377352 | 1377352 | 2021-06-01 | Washington | Rhode Island | 44009 | 10032 | 171 |
1374101 | 1374101 | 2021-05-31 | Bristol | Rhode Island | 44001 | 5153 | 144 |
1374102 | 1374102 | 2021-05-31 | Kent | Rhode Island | 44003 | 18715 | 365 |
1374103 | 1374103 | 2021-05-31 | Newport | Rhode Island | 44005 | 6891 | 42 |
1374104 | 1374104 | 2021-05-31 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1374105 | 1374105 | 2021-05-31 | Unknown | Rhode Island | 12228 | 8 | |
1374106 | 1374106 | 2021-05-31 | Washington | Rhode Island | 44009 | 10032 | 171 |
1370856 | 1370856 | 2021-05-30 | Bristol | Rhode Island | 44001 | 5153 | 144 |
1370857 | 1370857 | 2021-05-30 | Kent | Rhode Island | 44003 | 18715 | 365 |
1370858 | 1370858 | 2021-05-30 | Newport | Rhode Island | 44005 | 6891 | 42 |
1370859 | 1370859 | 2021-05-30 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1370860 | 1370860 | 2021-05-30 | Unknown | Rhode Island | 12228 | 8 | |
1370861 | 1370861 | 2021-05-30 | Washington | Rhode Island | 44009 | 10032 | 171 |
1367610 | 1367610 | 2021-05-29 | Bristol | Rhode Island | 44001 | 5153 | 144 |
1367611 | 1367611 | 2021-05-29 | Kent | Rhode Island | 44003 | 18715 | 365 |
1367612 | 1367612 | 2021-05-29 | Newport | Rhode Island | 44005 | 6891 | 42 |
1367613 | 1367613 | 2021-05-29 | Providence | Rhode Island | 44007 | 98724 | 1978 |
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);