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 359
- Bristol 335
- Kent 335
- Newport 335
- Providence 335
- Washington 335
state 1
- Rhode Island · 2,034 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055914 | 1055914 | 2021-02-22 | Bristol | Rhode Island | 44001 | 4115 | 123 |
1055915 | 1055915 | 2021-02-22 | Kent | Rhode Island | 44003 | 14896 | 291 |
1055916 | 1055916 | 2021-02-22 | Newport | Rhode Island | 44005 | 5015 | 25 |
1055917 | 1055917 | 2021-02-22 | Providence | Rhode Island | 44007 | 80264 | 1730 |
1055918 | 1055918 | 2021-02-22 | Unknown | Rhode Island | 12345 | 152 | |
1055919 | 1055919 | 2021-02-22 | Washington | Rhode Island | 44009 | 7345 | 145 |
1052668 | 1052668 | 2021-02-21 | Bristol | Rhode Island | 44001 | 4115 | 123 |
1052669 | 1052669 | 2021-02-21 | Kent | Rhode Island | 44003 | 14896 | 291 |
1052670 | 1052670 | 2021-02-21 | Newport | Rhode Island | 44005 | 5015 | 25 |
1052671 | 1052671 | 2021-02-21 | Providence | Rhode Island | 44007 | 80264 | 1730 |
1052672 | 1052672 | 2021-02-21 | Unknown | Rhode Island | 11510 | 62 | |
1052673 | 1052673 | 2021-02-21 | Washington | Rhode Island | 44009 | 7345 | 145 |
1049421 | 1049421 | 2021-02-20 | Bristol | Rhode Island | 44001 | 4115 | 123 |
1049422 | 1049422 | 2021-02-20 | Kent | Rhode Island | 44003 | 14896 | 291 |
1049423 | 1049423 | 2021-02-20 | Newport | Rhode Island | 44005 | 5015 | 25 |
1049424 | 1049424 | 2021-02-20 | Providence | Rhode Island | 44007 | 80264 | 1730 |
1049425 | 1049425 | 2021-02-20 | Unknown | Rhode Island | 11510 | 62 | |
1049426 | 1049426 | 2021-02-20 | Washington | Rhode Island | 44009 | 7345 | 145 |
1046174 | 1046174 | 2021-02-19 | Bristol | Rhode Island | 44001 | 4115 | 123 |
1046175 | 1046175 | 2021-02-19 | Kent | Rhode Island | 44003 | 14896 | 291 |
1046176 | 1046176 | 2021-02-19 | Newport | Rhode Island | 44005 | 5015 | 25 |
1046177 | 1046177 | 2021-02-19 | Providence | Rhode Island | 44007 | 80264 | 1730 |
1046178 | 1046178 | 2021-02-19 | Unknown | Rhode Island | 11510 | 62 | |
1046179 | 1046179 | 2021-02-19 | Washington | Rhode Island | 44009 | 7345 | 145 |
1042929 | 1042929 | 2021-02-18 | Bristol | Rhode Island | 44001 | 4115 | 123 |
1042930 | 1042930 | 2021-02-18 | Kent | Rhode Island | 44003 | 14896 | 291 |
1042931 | 1042931 | 2021-02-18 | Newport | Rhode Island | 44005 | 5015 | 25 |
1042932 | 1042932 | 2021-02-18 | Providence | Rhode Island | 44007 | 80264 | 1730 |
1042933 | 1042933 | 2021-02-18 | Unknown | Rhode Island | 11224 | 53 | |
1042934 | 1042934 | 2021-02-18 | Washington | Rhode Island | 44009 | 7345 | 145 |
1039684 | 1039684 | 2021-02-17 | Bristol | Rhode Island | 44001 | 4115 | 123 |
1039685 | 1039685 | 2021-02-17 | Kent | Rhode Island | 44003 | 14896 | 291 |
1039686 | 1039686 | 2021-02-17 | Newport | Rhode Island | 44005 | 5015 | 25 |
1039687 | 1039687 | 2021-02-17 | Providence | Rhode Island | 44007 | 80264 | 1730 |
1039688 | 1039688 | 2021-02-17 | Unknown | Rhode Island | 10805 | 38 | |
1039689 | 1039689 | 2021-02-17 | Washington | Rhode Island | 44009 | 7345 | 145 |
1036439 | 1036439 | 2021-02-16 | Bristol | Rhode Island | 44001 | 4019 | 117 |
1036440 | 1036440 | 2021-02-16 | Kent | Rhode Island | 44003 | 14542 | 272 |
1036441 | 1036441 | 2021-02-16 | Newport | Rhode Island | 44005 | 4851 | 20 |
1036442 | 1036442 | 2021-02-16 | Providence | Rhode Island | 44007 | 78666 | 1673 |
1036443 | 1036443 | 2021-02-16 | Unknown | Rhode Island | 12952 | 124 | |
1036444 | 1036444 | 2021-02-16 | Washington | Rhode Island | 44009 | 7042 | 138 |
1033194 | 1033194 | 2021-02-15 | Bristol | Rhode Island | 44001 | 4019 | 117 |
1033195 | 1033195 | 2021-02-15 | Kent | Rhode Island | 44003 | 14542 | 272 |
1033196 | 1033196 | 2021-02-15 | Newport | Rhode Island | 44005 | 4851 | 20 |
1033197 | 1033197 | 2021-02-15 | Providence | Rhode Island | 44007 | 78666 | 1673 |
1033198 | 1033198 | 2021-02-15 | Unknown | Rhode Island | 12667 | 114 | |
1033199 | 1033199 | 2021-02-15 | Washington | Rhode Island | 44009 | 7042 | 138 |
1029948 | 1029948 | 2021-02-14 | Bristol | Rhode Island | 44001 | 4019 | 117 |
1029949 | 1029949 | 2021-02-14 | Kent | Rhode Island | 44003 | 14542 | 272 |
1029950 | 1029950 | 2021-02-14 | Newport | Rhode Island | 44005 | 4851 | 20 |
1029951 | 1029951 | 2021-02-14 | Providence | Rhode Island | 44007 | 78666 | 1673 |
1029952 | 1029952 | 2021-02-14 | Unknown | Rhode Island | 11701 | 70 | |
1029953 | 1029953 | 2021-02-14 | Washington | Rhode Island | 44009 | 7042 | 138 |
1026701 | 1026701 | 2021-02-13 | Bristol | Rhode Island | 44001 | 4019 | 117 |
1026702 | 1026702 | 2021-02-13 | Kent | Rhode Island | 44003 | 14542 | 272 |
1026703 | 1026703 | 2021-02-13 | Newport | Rhode Island | 44005 | 4851 | 20 |
1026704 | 1026704 | 2021-02-13 | Providence | Rhode Island | 44007 | 78666 | 1673 |
1026705 | 1026705 | 2021-02-13 | Unknown | Rhode Island | 11701 | 70 | |
1026706 | 1026706 | 2021-02-13 | Washington | Rhode Island | 44009 | 7042 | 138 |
1023456 | 1023456 | 2021-02-12 | Bristol | Rhode Island | 44001 | 4019 | 117 |
1023457 | 1023457 | 2021-02-12 | Kent | Rhode Island | 44003 | 14542 | 272 |
1023458 | 1023458 | 2021-02-12 | Newport | Rhode Island | 44005 | 4851 | 20 |
1023459 | 1023459 | 2021-02-12 | Providence | Rhode Island | 44007 | 78666 | 1673 |
1023460 | 1023460 | 2021-02-12 | Unknown | Rhode Island | 11701 | 70 | |
1023461 | 1023461 | 2021-02-12 | Washington | Rhode Island | 44009 | 7042 | 138 |
1020211 | 1020211 | 2021-02-11 | Bristol | Rhode Island | 44001 | 4019 | 117 |
1020212 | 1020212 | 2021-02-11 | Kent | Rhode Island | 44003 | 14542 | 272 |
1020213 | 1020213 | 2021-02-11 | Newport | Rhode Island | 44005 | 4851 | 20 |
1020214 | 1020214 | 2021-02-11 | Providence | Rhode Island | 44007 | 78666 | 1673 |
1020215 | 1020215 | 2021-02-11 | Unknown | Rhode Island | 11261 | 54 | |
1020216 | 1020216 | 2021-02-11 | Washington | Rhode Island | 44009 | 7042 | 138 |
1016966 | 1016966 | 2021-02-10 | Bristol | Rhode Island | 44001 | 4019 | 117 |
1016967 | 1016967 | 2021-02-10 | Kent | Rhode Island | 44003 | 14542 | 272 |
1016968 | 1016968 | 2021-02-10 | Newport | Rhode Island | 44005 | 4851 | 20 |
1016969 | 1016969 | 2021-02-10 | Providence | Rhode Island | 44007 | 78666 | 1673 |
1016970 | 1016970 | 2021-02-10 | Unknown | Rhode Island | 10773 | 39 | |
1016971 | 1016971 | 2021-02-10 | Washington | Rhode Island | 44009 | 7042 | 138 |
1013721 | 1013721 | 2021-02-09 | Bristol | Rhode Island | 44001 | 3890 | 114 |
1013722 | 1013722 | 2021-02-09 | Kent | Rhode Island | 44003 | 14129 | 256 |
1013723 | 1013723 | 2021-02-09 | Newport | Rhode Island | 44005 | 4631 | 16 |
1013724 | 1013724 | 2021-02-09 | Providence | Rhode Island | 44007 | 76727 | 1631 |
1013725 | 1013725 | 2021-02-09 | Unknown | Rhode Island | 13292 | 94 | |
1013726 | 1013726 | 2021-02-09 | Washington | Rhode Island | 44009 | 6765 | 137 |
1010476 | 1010476 | 2021-02-08 | Bristol | Rhode Island | 44001 | 3890 | 114 |
1010477 | 1010477 | 2021-02-08 | Kent | Rhode Island | 44003 | 14129 | 256 |
1010478 | 1010478 | 2021-02-08 | Newport | Rhode Island | 44005 | 4631 | 16 |
1010479 | 1010479 | 2021-02-08 | Providence | Rhode Island | 44007 | 76727 | 1631 |
1010480 | 1010480 | 2021-02-08 | Unknown | Rhode Island | 12962 | 82 | |
1010481 | 1010481 | 2021-02-08 | Washington | Rhode Island | 44009 | 6765 | 137 |
1007230 | 1007230 | 2021-02-07 | Bristol | Rhode Island | 44001 | 3890 | 114 |
1007231 | 1007231 | 2021-02-07 | Kent | Rhode Island | 44003 | 14129 | 256 |
1007232 | 1007232 | 2021-02-07 | Newport | Rhode Island | 44005 | 4631 | 16 |
1007233 | 1007233 | 2021-02-07 | Providence | Rhode Island | 44007 | 76727 | 1631 |
1007234 | 1007234 | 2021-02-07 | Unknown | Rhode Island | 11749 | 58 | |
1007235 | 1007235 | 2021-02-07 | Washington | Rhode Island | 44009 | 6765 | 137 |
1003984 | 1003984 | 2021-02-06 | Bristol | Rhode Island | 44001 | 3890 | 114 |
1003985 | 1003985 | 2021-02-06 | Kent | Rhode Island | 44003 | 14129 | 256 |
1003986 | 1003986 | 2021-02-06 | Newport | Rhode Island | 44005 | 4631 | 16 |
1003987 | 1003987 | 2021-02-06 | Providence | Rhode Island | 44007 | 76727 | 1631 |
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);