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 402
- Bristol 378
- Kent 378
- Newport 378
- Providence 378
- Washington 378
state 1
- Rhode Island · 2,292 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195518 | 1195518 | 2021-04-06 | Bristol | Rhode Island | 44001 | 4591 | 140 |
1195519 | 1195519 | 2021-04-06 | Kent | Rhode Island | 44003 | 16664 | 344 |
1195520 | 1195520 | 2021-04-06 | Newport | Rhode Island | 44005 | 5785 | 40 |
1195521 | 1195521 | 2021-04-06 | Providence | Rhode Island | 44007 | 88787 | 1909 |
1195522 | 1195522 | 2021-04-06 | Unknown | Rhode Island | 14620 | 33 | |
1195523 | 1195523 | 2021-04-06 | Washington | Rhode Island | 44009 | 9102 | 166 |
1192270 | 1192270 | 2021-04-05 | Bristol | Rhode Island | 44001 | 4591 | 140 |
1192271 | 1192271 | 2021-04-05 | Kent | Rhode Island | 44003 | 16664 | 344 |
1192272 | 1192272 | 2021-04-05 | Newport | Rhode Island | 44005 | 5785 | 40 |
1192273 | 1192273 | 2021-04-05 | Providence | Rhode Island | 44007 | 88787 | 1909 |
1192274 | 1192274 | 2021-04-05 | Unknown | Rhode Island | 14244 | 30 | |
1192275 | 1192275 | 2021-04-05 | Washington | Rhode Island | 44009 | 9102 | 166 |
1189021 | 1189021 | 2021-04-04 | Bristol | Rhode Island | 44001 | 4591 | 140 |
1189022 | 1189022 | 2021-04-04 | Kent | Rhode Island | 44003 | 16664 | 344 |
1189023 | 1189023 | 2021-04-04 | Newport | Rhode Island | 44005 | 5785 | 40 |
1189024 | 1189024 | 2021-04-04 | Providence | Rhode Island | 44007 | 88787 | 1909 |
1189025 | 1189025 | 2021-04-04 | Unknown | Rhode Island | 13326 | 31 | |
1189026 | 1189026 | 2021-04-04 | Washington | Rhode Island | 44009 | 9102 | 166 |
1185774 | 1185774 | 2021-04-03 | Bristol | Rhode Island | 44001 | 4591 | 140 |
1185775 | 1185775 | 2021-04-03 | Kent | Rhode Island | 44003 | 16664 | 344 |
1185776 | 1185776 | 2021-04-03 | Newport | Rhode Island | 44005 | 5785 | 40 |
1185777 | 1185777 | 2021-04-03 | Providence | Rhode Island | 44007 | 88787 | 1909 |
1185778 | 1185778 | 2021-04-03 | Unknown | Rhode Island | 13326 | 31 | |
1185779 | 1185779 | 2021-04-03 | Washington | Rhode Island | 44009 | 9102 | 166 |
1182527 | 1182527 | 2021-04-02 | Bristol | Rhode Island | 44001 | 4591 | 140 |
1182528 | 1182528 | 2021-04-02 | Kent | Rhode Island | 44003 | 16664 | 344 |
1182529 | 1182529 | 2021-04-02 | Newport | Rhode Island | 44005 | 5785 | 40 |
1182530 | 1182530 | 2021-04-02 | Providence | Rhode Island | 44007 | 88787 | 1909 |
1182531 | 1182531 | 2021-04-02 | Unknown | Rhode Island | 13326 | 31 | |
1182532 | 1182532 | 2021-04-02 | Washington | Rhode Island | 44009 | 9102 | 166 |
1179280 | 1179280 | 2021-04-01 | Bristol | Rhode Island | 44001 | 4591 | 140 |
1179281 | 1179281 | 2021-04-01 | Kent | Rhode Island | 44003 | 16664 | 344 |
1179282 | 1179282 | 2021-04-01 | Newport | Rhode Island | 44005 | 5785 | 40 |
1179283 | 1179283 | 2021-04-01 | Providence | Rhode Island | 44007 | 88787 | 1909 |
1179284 | 1179284 | 2021-04-01 | Unknown | Rhode Island | 12919 | 25 | |
1179285 | 1179285 | 2021-04-01 | Washington | Rhode Island | 44009 | 9102 | 166 |
1176033 | 1176033 | 2021-03-31 | Bristol | Rhode Island | 44001 | 4591 | 140 |
1176034 | 1176034 | 2021-03-31 | Kent | Rhode Island | 44003 | 16664 | 344 |
1176035 | 1176035 | 2021-03-31 | Newport | Rhode Island | 44005 | 5785 | 40 |
1176036 | 1176036 | 2021-03-31 | Providence | Rhode Island | 44007 | 88787 | 1909 |
1176037 | 1176037 | 2021-03-31 | Unknown | Rhode Island | 12400 | 20 | |
1176038 | 1176038 | 2021-03-31 | Washington | Rhode Island | 44009 | 9102 | 166 |
1172786 | 1172786 | 2021-03-30 | Bristol | Rhode Island | 44001 | 4492 | 140 |
1172787 | 1172787 | 2021-03-30 | Kent | Rhode Island | 44003 | 16330 | 344 |
1172788 | 1172788 | 2021-03-30 | Newport | Rhode Island | 44005 | 5625 | 40 |
1172789 | 1172789 | 2021-03-30 | Providence | Rhode Island | 44007 | 87520 | 1902 |
1172790 | 1172790 | 2021-03-30 | Unknown | Rhode Island | 13899 | 28 | |
1172791 | 1172791 | 2021-03-30 | Washington | Rhode Island | 44009 | 8899 | 164 |
1169539 | 1169539 | 2021-03-29 | Bristol | Rhode Island | 44001 | 4492 | 140 |
1169540 | 1169540 | 2021-03-29 | Kent | Rhode Island | 44003 | 16330 | 344 |
1169541 | 1169541 | 2021-03-29 | Newport | Rhode Island | 44005 | 5625 | 40 |
1169542 | 1169542 | 2021-03-29 | Providence | Rhode Island | 44007 | 87520 | 1902 |
1169543 | 1169543 | 2021-03-29 | Unknown | Rhode Island | 13553 | 23 | |
1169544 | 1169544 | 2021-03-29 | Washington | Rhode Island | 44009 | 8899 | 164 |
1166291 | 1166291 | 2021-03-28 | Bristol | Rhode Island | 44001 | 4492 | 140 |
1166292 | 1166292 | 2021-03-28 | Kent | Rhode Island | 44003 | 16330 | 344 |
1166293 | 1166293 | 2021-03-28 | Newport | Rhode Island | 44005 | 5625 | 40 |
1166294 | 1166294 | 2021-03-28 | Providence | Rhode Island | 44007 | 87520 | 1902 |
1166295 | 1166295 | 2021-03-28 | Unknown | Rhode Island | 12909 | 18 | |
1166296 | 1166296 | 2021-03-28 | Washington | Rhode Island | 44009 | 8899 | 164 |
1163043 | 1163043 | 2021-03-27 | Bristol | Rhode Island | 44001 | 4492 | 140 |
1163044 | 1163044 | 2021-03-27 | Kent | Rhode Island | 44003 | 16330 | 344 |
1163045 | 1163045 | 2021-03-27 | Newport | Rhode Island | 44005 | 5625 | 40 |
1163046 | 1163046 | 2021-03-27 | Providence | Rhode Island | 44007 | 87520 | 1902 |
1163047 | 1163047 | 2021-03-27 | Unknown | Rhode Island | 12909 | 18 | |
1163048 | 1163048 | 2021-03-27 | Washington | Rhode Island | 44009 | 8899 | 164 |
1159794 | 1159794 | 2021-03-26 | Bristol | Rhode Island | 44001 | 4492 | 140 |
1159795 | 1159795 | 2021-03-26 | Kent | Rhode Island | 44003 | 16330 | 344 |
1159796 | 1159796 | 2021-03-26 | Newport | Rhode Island | 44005 | 5625 | 40 |
1159797 | 1159797 | 2021-03-26 | Providence | Rhode Island | 44007 | 87520 | 1902 |
1159798 | 1159798 | 2021-03-26 | Unknown | Rhode Island | 12909 | 18 | |
1159799 | 1159799 | 2021-03-26 | Washington | Rhode Island | 44009 | 8899 | 164 |
1156547 | 1156547 | 2021-03-25 | Bristol | Rhode Island | 44001 | 4492 | 140 |
1156548 | 1156548 | 2021-03-25 | Kent | Rhode Island | 44003 | 16330 | 344 |
1156549 | 1156549 | 2021-03-25 | Newport | Rhode Island | 44005 | 5625 | 40 |
1156550 | 1156550 | 2021-03-25 | Providence | Rhode Island | 44007 | 87520 | 1902 |
1156551 | 1156551 | 2021-03-25 | Unknown | Rhode Island | 12424 | 17 | |
1156552 | 1156552 | 2021-03-25 | Washington | Rhode Island | 44009 | 8899 | 164 |
1153300 | 1153300 | 2021-03-24 | Bristol | Rhode Island | 44001 | 4492 | 140 |
1153301 | 1153301 | 2021-03-24 | Kent | Rhode Island | 44003 | 16330 | 344 |
1153302 | 1153302 | 2021-03-24 | Newport | Rhode Island | 44005 | 5625 | 40 |
1153303 | 1153303 | 2021-03-24 | Providence | Rhode Island | 44007 | 87520 | 1902 |
1153304 | 1153304 | 2021-03-24 | Unknown | Rhode Island | 11941 | 16 | |
1153305 | 1153305 | 2021-03-24 | Washington | Rhode Island | 44009 | 8899 | 164 |
1150053 | 1150053 | 2021-03-23 | Bristol | Rhode Island | 44001 | 4404 | 139 |
1150054 | 1150054 | 2021-03-23 | Kent | Rhode Island | 44003 | 16047 | 337 |
1150055 | 1150055 | 2021-03-23 | Newport | Rhode Island | 44005 | 5471 | 39 |
1150056 | 1150056 | 2021-03-23 | Providence | Rhode Island | 44007 | 86088 | 1882 |
1150057 | 1150057 | 2021-03-23 | Unknown | Rhode Island | 13752 | 46 | |
1150058 | 1150058 | 2021-03-23 | Washington | Rhode Island | 44009 | 8574 | 163 |
1146806 | 1146806 | 2021-03-22 | Bristol | Rhode Island | 44001 | 4404 | 139 |
1146807 | 1146807 | 2021-03-22 | Kent | Rhode Island | 44003 | 16047 | 337 |
1146808 | 1146808 | 2021-03-22 | Newport | Rhode Island | 44005 | 5471 | 39 |
1146809 | 1146809 | 2021-03-22 | Providence | Rhode Island | 44007 | 86088 | 1882 |
1146810 | 1146810 | 2021-03-22 | Unknown | Rhode Island | 13455 | 44 | |
1146811 | 1146811 | 2021-03-22 | Washington | Rhode Island | 44009 | 8574 | 163 |
1143559 | 1143559 | 2021-03-21 | Bristol | Rhode Island | 44001 | 4404 | 139 |
1143560 | 1143560 | 2021-03-21 | Kent | Rhode Island | 44003 | 16047 | 337 |
1143561 | 1143561 | 2021-03-21 | Newport | Rhode Island | 44005 | 5471 | 39 |
1143562 | 1143562 | 2021-03-21 | Providence | Rhode Island | 44007 | 86088 | 1882 |
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);