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 592
- Bristol 568
- Kent 568
- Newport 568
- Providence 568
- Washington 568
state 1
- Rhode Island · 3,432 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812528 | 1812528 | 2021-10-13 | Bristol | Rhode Island | 44001 | 5930 | 149 |
1812529 | 1812529 | 2021-10-13 | Kent | Rhode Island | 44003 | 22129 | 389 |
1812530 | 1812530 | 2021-10-13 | Newport | Rhode Island | 44005 | 8560 | 52 |
1812531 | 1812531 | 2021-10-13 | Providence | Rhode Island | 44007 | 112799 | 2082 |
1812532 | 1812532 | 2021-10-13 | Unknown | Rhode Island | 12613 | 9 | |
1812533 | 1812533 | 2021-10-13 | Washington | Rhode Island | 44009 | 13746 | 176 |
1809279 | 1809279 | 2021-10-12 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1809280 | 1809280 | 2021-10-12 | Kent | Rhode Island | 44003 | 21881 | 384 |
1809281 | 1809281 | 2021-10-12 | Newport | Rhode Island | 44005 | 8404 | 51 |
1809282 | 1809282 | 2021-10-12 | Providence | Rhode Island | 44007 | 111666 | 2075 |
1809283 | 1809283 | 2021-10-12 | Unknown | Rhode Island | 14078 | 21 | |
1809284 | 1809284 | 2021-10-12 | Washington | Rhode Island | 44009 | 13601 | 176 |
1806029 | 1806029 | 2021-10-11 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1806030 | 1806030 | 2021-10-11 | Kent | Rhode Island | 44003 | 21881 | 384 |
1806031 | 1806031 | 2021-10-11 | Newport | Rhode Island | 44005 | 8404 | 51 |
1806032 | 1806032 | 2021-10-11 | Providence | Rhode Island | 44007 | 111666 | 2075 |
1806033 | 1806033 | 2021-10-11 | Unknown | Rhode Island | 13161 | 19 | |
1806034 | 1806034 | 2021-10-11 | Washington | Rhode Island | 44009 | 13601 | 176 |
1802779 | 1802779 | 2021-10-10 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1802780 | 1802780 | 2021-10-10 | Kent | Rhode Island | 44003 | 21881 | 384 |
1802781 | 1802781 | 2021-10-10 | Newport | Rhode Island | 44005 | 8404 | 51 |
1802782 | 1802782 | 2021-10-10 | Providence | Rhode Island | 44007 | 111666 | 2075 |
1802783 | 1802783 | 2021-10-10 | Unknown | Rhode Island | 13161 | 19 | |
1802784 | 1802784 | 2021-10-10 | Washington | Rhode Island | 44009 | 13601 | 176 |
1799530 | 1799530 | 2021-10-09 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1799531 | 1799531 | 2021-10-09 | Kent | Rhode Island | 44003 | 21881 | 384 |
1799532 | 1799532 | 2021-10-09 | Newport | Rhode Island | 44005 | 8404 | 51 |
1799533 | 1799533 | 2021-10-09 | Providence | Rhode Island | 44007 | 111666 | 2075 |
1799534 | 1799534 | 2021-10-09 | Unknown | Rhode Island | 13161 | 19 | |
1799535 | 1799535 | 2021-10-09 | Washington | Rhode Island | 44009 | 13601 | 176 |
1796281 | 1796281 | 2021-10-08 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1796282 | 1796282 | 2021-10-08 | Kent | Rhode Island | 44003 | 21881 | 384 |
1796283 | 1796283 | 2021-10-08 | Newport | Rhode Island | 44005 | 8404 | 51 |
1796284 | 1796284 | 2021-10-08 | Providence | Rhode Island | 44007 | 111666 | 2075 |
1796285 | 1796285 | 2021-10-08 | Unknown | Rhode Island | 13161 | 19 | |
1796286 | 1796286 | 2021-10-08 | Washington | Rhode Island | 44009 | 13601 | 176 |
1793032 | 1793032 | 2021-10-07 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1793033 | 1793033 | 2021-10-07 | Kent | Rhode Island | 44003 | 21881 | 384 |
1793034 | 1793034 | 2021-10-07 | Newport | Rhode Island | 44005 | 8404 | 51 |
1793035 | 1793035 | 2021-10-07 | Providence | Rhode Island | 44007 | 111666 | 2075 |
1793036 | 1793036 | 2021-10-07 | Unknown | Rhode Island | 12762 | 17 | |
1793037 | 1793037 | 2021-10-07 | Washington | Rhode Island | 44009 | 13601 | 176 |
1789783 | 1789783 | 2021-10-06 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1789784 | 1789784 | 2021-10-06 | Kent | Rhode Island | 44003 | 21881 | 384 |
1789785 | 1789785 | 2021-10-06 | Newport | Rhode Island | 44005 | 8404 | 51 |
1789786 | 1789786 | 2021-10-06 | Providence | Rhode Island | 44007 | 111666 | 2075 |
1789787 | 1789787 | 2021-10-06 | Unknown | Rhode Island | 12528 | 13 | |
1789788 | 1789788 | 2021-10-06 | Washington | Rhode Island | 44009 | 13601 | 176 |
1786535 | 1786535 | 2021-10-05 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1786536 | 1786536 | 2021-10-05 | Kent | Rhode Island | 44003 | 21591 | 383 |
1786537 | 1786537 | 2021-10-05 | Newport | Rhode Island | 44005 | 8255 | 50 |
1786538 | 1786538 | 2021-10-05 | Providence | Rhode Island | 44007 | 110567 | 2065 |
1786539 | 1786539 | 2021-10-05 | Unknown | Rhode Island | 14065 | 22 | |
1786540 | 1786540 | 2021-10-05 | Washington | Rhode Island | 44009 | 13385 | 176 |
1783286 | 1783286 | 2021-10-04 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1783287 | 1783287 | 2021-10-04 | Kent | Rhode Island | 44003 | 21591 | 383 |
1783288 | 1783288 | 2021-10-04 | Newport | Rhode Island | 44005 | 8255 | 50 |
1783289 | 1783289 | 2021-10-04 | Providence | Rhode Island | 44007 | 110567 | 2065 |
1783290 | 1783290 | 2021-10-04 | Unknown | Rhode Island | 13819 | 20 | |
1783291 | 1783291 | 2021-10-04 | Washington | Rhode Island | 44009 | 13385 | 176 |
1780037 | 1780037 | 2021-10-03 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1780038 | 1780038 | 2021-10-03 | Kent | Rhode Island | 44003 | 21591 | 383 |
1780039 | 1780039 | 2021-10-03 | Newport | Rhode Island | 44005 | 8255 | 50 |
1780040 | 1780040 | 2021-10-03 | Providence | Rhode Island | 44007 | 110567 | 2065 |
1780041 | 1780041 | 2021-10-03 | Unknown | Rhode Island | 13181 | 15 | |
1780042 | 1780042 | 2021-10-03 | Washington | Rhode Island | 44009 | 13385 | 176 |
1776787 | 1776787 | 2021-10-02 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1776788 | 1776788 | 2021-10-02 | Kent | Rhode Island | 44003 | 21591 | 383 |
1776789 | 1776789 | 2021-10-02 | Newport | Rhode Island | 44005 | 8255 | 50 |
1776790 | 1776790 | 2021-10-02 | Providence | Rhode Island | 44007 | 110567 | 2065 |
1776791 | 1776791 | 2021-10-02 | Unknown | Rhode Island | 13181 | 15 | |
1776792 | 1776792 | 2021-10-02 | Washington | Rhode Island | 44009 | 13385 | 176 |
1773537 | 1773537 | 2021-10-01 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1773538 | 1773538 | 2021-10-01 | Kent | Rhode Island | 44003 | 21591 | 383 |
1773539 | 1773539 | 2021-10-01 | Newport | Rhode Island | 44005 | 8255 | 50 |
1773540 | 1773540 | 2021-10-01 | Providence | Rhode Island | 44007 | 110567 | 2065 |
1773541 | 1773541 | 2021-10-01 | Unknown | Rhode Island | 13181 | 15 | |
1773542 | 1773542 | 2021-10-01 | Washington | Rhode Island | 44009 | 13385 | 176 |
1770287 | 1770287 | 2021-09-30 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1770288 | 1770288 | 2021-09-30 | Kent | Rhode Island | 44003 | 21591 | 383 |
1770289 | 1770289 | 2021-09-30 | Newport | Rhode Island | 44005 | 8255 | 50 |
1770290 | 1770290 | 2021-09-30 | Providence | Rhode Island | 44007 | 110567 | 2065 |
1770291 | 1770291 | 2021-09-30 | Unknown | Rhode Island | 12823 | 15 | |
1770292 | 1770292 | 2021-09-30 | Washington | Rhode Island | 44009 | 13385 | 176 |
1767038 | 1767038 | 2021-09-29 | Bristol | Rhode Island | 44001 | 5740 | 149 |
1767039 | 1767039 | 2021-09-29 | Kent | Rhode Island | 44003 | 21591 | 383 |
1767040 | 1767040 | 2021-09-29 | Newport | Rhode Island | 44005 | 8255 | 50 |
1767041 | 1767041 | 2021-09-29 | Providence | Rhode Island | 44007 | 110567 | 2065 |
1767042 | 1767042 | 2021-09-29 | Unknown | Rhode Island | 12526 | 13 | |
1767043 | 1767043 | 2021-09-29 | Washington | Rhode Island | 44009 | 13385 | 176 |
1763789 | 1763789 | 2021-09-28 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1763790 | 1763790 | 2021-09-28 | Kent | Rhode Island | 44003 | 21259 | 380 |
1763791 | 1763791 | 2021-09-28 | Newport | Rhode Island | 44005 | 8152 | 50 |
1763792 | 1763792 | 2021-09-28 | Providence | Rhode Island | 44007 | 109360 | 2055 |
1763793 | 1763793 | 2021-09-28 | Unknown | Rhode Island | 14155 | 26 | |
1763794 | 1763794 | 2021-09-28 | Washington | Rhode Island | 44009 | 13133 | 174 |
1760540 | 1760540 | 2021-09-27 | Bristol | Rhode Island | 44001 | 5692 | 149 |
1760541 | 1760541 | 2021-09-27 | Kent | Rhode Island | 44003 | 21259 | 380 |
1760542 | 1760542 | 2021-09-27 | Newport | Rhode Island | 44005 | 8152 | 50 |
1760543 | 1760543 | 2021-09-27 | Providence | Rhode Island | 44007 | 109360 | 2055 |
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);