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 318
- Bristol 294
- Kent 294
- Newport 294
- Providence 294
- Washington 294
state 1
- Rhode Island · 1,788 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922845 | 922845 | 2021-01-12 | Bristol | Rhode Island | 44001 | 2834 | 71 |
922846 | 922846 | 2021-01-12 | Kent | Rhode Island | 44003 | 10783 | 213 |
922847 | 922847 | 2021-01-12 | Newport | Rhode Island | 44005 | 3069 | 10 |
922848 | 922848 | 2021-01-12 | Providence | Rhode Island | 44007 | 62846 | 1435 |
922849 | 922849 | 2021-01-12 | Unknown | Rhode Island | 16867 | 120 | |
922850 | 922850 | 2021-01-12 | Washington | Rhode Island | 44009 | 4994 | 121 |
919600 | 919600 | 2021-01-11 | Bristol | Rhode Island | 44001 | 2834 | 71 |
919601 | 919601 | 2021-01-11 | Kent | Rhode Island | 44003 | 10783 | 213 |
919602 | 919602 | 2021-01-11 | Newport | Rhode Island | 44005 | 3069 | 10 |
919603 | 919603 | 2021-01-11 | Providence | Rhode Island | 44007 | 62846 | 1435 |
919604 | 919604 | 2021-01-11 | Unknown | Rhode Island | 16081 | 97 | |
919605 | 919605 | 2021-01-11 | Washington | Rhode Island | 44009 | 4994 | 121 |
916355 | 916355 | 2021-01-10 | Bristol | Rhode Island | 44001 | 2834 | 71 |
916356 | 916356 | 2021-01-10 | Kent | Rhode Island | 44003 | 10783 | 213 |
916357 | 916357 | 2021-01-10 | Newport | Rhode Island | 44005 | 3069 | 10 |
916358 | 916358 | 2021-01-10 | Providence | Rhode Island | 44007 | 62846 | 1435 |
916359 | 916359 | 2021-01-10 | Unknown | Rhode Island | 13088 | 66 | |
916360 | 916360 | 2021-01-10 | Washington | Rhode Island | 44009 | 4994 | 121 |
913110 | 913110 | 2021-01-09 | Bristol | Rhode Island | 44001 | 2834 | 71 |
913111 | 913111 | 2021-01-09 | Kent | Rhode Island | 44003 | 10783 | 213 |
913112 | 913112 | 2021-01-09 | Newport | Rhode Island | 44005 | 3069 | 10 |
913113 | 913113 | 2021-01-09 | Providence | Rhode Island | 44007 | 62846 | 1435 |
913114 | 913114 | 2021-01-09 | Unknown | Rhode Island | 13088 | 66 | |
913115 | 913115 | 2021-01-09 | Washington | Rhode Island | 44009 | 4994 | 121 |
909865 | 909865 | 2021-01-08 | Bristol | Rhode Island | 44001 | 2834 | 71 |
909866 | 909866 | 2021-01-08 | Kent | Rhode Island | 44003 | 10783 | 213 |
909867 | 909867 | 2021-01-08 | Newport | Rhode Island | 44005 | 3069 | 10 |
909868 | 909868 | 2021-01-08 | Providence | Rhode Island | 44007 | 62846 | 1435 |
909869 | 909869 | 2021-01-08 | Unknown | Rhode Island | 13088 | 66 | |
909870 | 909870 | 2021-01-08 | Washington | Rhode Island | 44009 | 4994 | 121 |
906620 | 906620 | 2021-01-07 | Bristol | Rhode Island | 44001 | 2834 | 71 |
906621 | 906621 | 2021-01-07 | Kent | Rhode Island | 44003 | 10783 | 213 |
906622 | 906622 | 2021-01-07 | Newport | Rhode Island | 44005 | 3069 | 10 |
906623 | 906623 | 2021-01-07 | Providence | Rhode Island | 44007 | 62846 | 1435 |
906624 | 906624 | 2021-01-07 | Unknown | Rhode Island | 12065 | 60 | |
906625 | 906625 | 2021-01-07 | Washington | Rhode Island | 44009 | 4994 | 121 |
903374 | 903374 | 2021-01-06 | Bristol | Rhode Island | 44001 | 2834 | 71 |
903375 | 903375 | 2021-01-06 | Kent | Rhode Island | 44003 | 10783 | 213 |
903376 | 903376 | 2021-01-06 | Newport | Rhode Island | 44005 | 3069 | 10 |
903377 | 903377 | 2021-01-06 | Providence | Rhode Island | 44007 | 62846 | 1435 |
903378 | 903378 | 2021-01-06 | Unknown | Rhode Island | 10937 | 40 | |
903379 | 903379 | 2021-01-06 | Washington | Rhode Island | 44009 | 4994 | 121 |
900129 | 900129 | 2021-01-05 | Bristol | Rhode Island | 44001 | 2403 | 54 |
900130 | 900130 | 2021-01-05 | Kent | Rhode Island | 44003 | 9901 | 194 |
900131 | 900131 | 2021-01-05 | Newport | Rhode Island | 44005 | 2595 | 9 |
900132 | 900132 | 2021-01-05 | Providence | Rhode Island | 44007 | 58946 | 1347 |
900133 | 900133 | 2021-01-05 | Unknown | Rhode Island | 15525 | 153 | |
900134 | 900134 | 2021-01-05 | Washington | Rhode Island | 44009 | 4482 | 113 |
896884 | 896884 | 2021-01-04 | Bristol | Rhode Island | 44001 | 2403 | 54 |
896885 | 896885 | 2021-01-04 | Kent | Rhode Island | 44003 | 9901 | 194 |
896886 | 896886 | 2021-01-04 | Newport | Rhode Island | 44005 | 2595 | 9 |
896887 | 896887 | 2021-01-04 | Providence | Rhode Island | 44007 | 58946 | 1347 |
896888 | 896888 | 2021-01-04 | Unknown | Rhode Island | 14381 | 138 | |
896889 | 896889 | 2021-01-04 | Washington | Rhode Island | 44009 | 4482 | 113 |
893638 | 893638 | 2021-01-03 | Bristol | Rhode Island | 44001 | 2403 | 54 |
893639 | 893639 | 2021-01-03 | Kent | Rhode Island | 44003 | 9901 | 194 |
893640 | 893640 | 2021-01-03 | Newport | Rhode Island | 44005 | 2595 | 9 |
893641 | 893641 | 2021-01-03 | Providence | Rhode Island | 44007 | 58946 | 1347 |
893642 | 893642 | 2021-01-03 | Unknown | Rhode Island | 9622 | 60 | |
893643 | 893643 | 2021-01-03 | Washington | Rhode Island | 44009 | 4482 | 113 |
890392 | 890392 | 2021-01-02 | Bristol | Rhode Island | 44001 | 2403 | 54 |
890393 | 890393 | 2021-01-02 | Kent | Rhode Island | 44003 | 9901 | 194 |
890394 | 890394 | 2021-01-02 | Newport | Rhode Island | 44005 | 2595 | 9 |
890395 | 890395 | 2021-01-02 | Providence | Rhode Island | 44007 | 58946 | 1347 |
890396 | 890396 | 2021-01-02 | Unknown | Rhode Island | 9622 | 60 | |
890397 | 890397 | 2021-01-02 | Washington | Rhode Island | 44009 | 4482 | 113 |
887145 | 887145 | 2021-01-01 | Bristol | Rhode Island | 44001 | 2403 | 54 |
887146 | 887146 | 2021-01-01 | Kent | Rhode Island | 44003 | 9901 | 194 |
887147 | 887147 | 2021-01-01 | Newport | Rhode Island | 44005 | 2595 | 9 |
887148 | 887148 | 2021-01-01 | Providence | Rhode Island | 44007 | 58946 | 1347 |
887149 | 887149 | 2021-01-01 | Unknown | Rhode Island | 9622 | 60 | |
887150 | 887150 | 2021-01-01 | Washington | Rhode Island | 44009 | 4482 | 113 |
883900 | 883900 | 2020-12-31 | Bristol | Rhode Island | 44001 | 2403 | 54 |
883901 | 883901 | 2020-12-31 | Kent | Rhode Island | 44003 | 9901 | 194 |
883902 | 883902 | 2020-12-31 | Newport | Rhode Island | 44005 | 2595 | 9 |
883903 | 883903 | 2020-12-31 | Providence | Rhode Island | 44007 | 58946 | 1347 |
883904 | 883904 | 2020-12-31 | Unknown | Rhode Island | 9622 | 60 | |
883905 | 883905 | 2020-12-31 | Washington | Rhode Island | 44009 | 4482 | 113 |
880655 | 880655 | 2020-12-30 | Bristol | Rhode Island | 44001 | 2403 | 54 |
880656 | 880656 | 2020-12-30 | Kent | Rhode Island | 44003 | 9901 | 194 |
880657 | 880657 | 2020-12-30 | Newport | Rhode Island | 44005 | 2595 | 9 |
880658 | 880658 | 2020-12-30 | Providence | Rhode Island | 44007 | 58946 | 1347 |
880659 | 880659 | 2020-12-30 | Unknown | Rhode Island | 9622 | 60 | |
880660 | 880660 | 2020-12-30 | Washington | Rhode Island | 44009 | 4482 | 113 |
877410 | 877410 | 2020-12-29 | Bristol | Rhode Island | 44001 | 2065 | 54 |
877411 | 877411 | 2020-12-29 | Kent | Rhode Island | 44003 | 9295 | 186 |
877412 | 877412 | 2020-12-29 | Newport | Rhode Island | 44005 | 2281 | 9 |
877413 | 877413 | 2020-12-29 | Providence | Rhode Island | 44007 | 55922 | 1276 |
877414 | 877414 | 2020-12-29 | Unknown | Rhode Island | 13091 | 129 | |
877415 | 877415 | 2020-12-29 | Washington | Rhode Island | 44009 | 4135 | 106 |
874165 | 874165 | 2020-12-28 | Bristol | Rhode Island | 44001 | 2065 | 54 |
874166 | 874166 | 2020-12-28 | Kent | Rhode Island | 44003 | 9295 | 186 |
874167 | 874167 | 2020-12-28 | Newport | Rhode Island | 44005 | 2281 | 9 |
874168 | 874168 | 2020-12-28 | Providence | Rhode Island | 44007 | 55922 | 1276 |
874169 | 874169 | 2020-12-28 | Unknown | Rhode Island | 11904 | 111 | |
874170 | 874170 | 2020-12-28 | Washington | Rhode Island | 44009 | 4135 | 106 |
870920 | 870920 | 2020-12-27 | Bristol | Rhode Island | 44001 | 2065 | 54 |
870921 | 870921 | 2020-12-27 | Kent | Rhode Island | 44003 | 9295 | 186 |
870922 | 870922 | 2020-12-27 | Newport | Rhode Island | 44005 | 2281 | 9 |
870923 | 870923 | 2020-12-27 | Providence | Rhode Island | 44007 | 55922 | 1276 |
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);