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 230
- Bristol 206
- Kent 206
- Newport 206
- Providence 206
- Washington 206
state 1
- Rhode Island · 1,260 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637292 | 637292 | 2020-10-16 | Bristol | Rhode Island | 44001 | 461 | 17 |
637293 | 637293 | 2020-10-16 | Kent | Rhode Island | 44003 | 2145 | 116 |
637294 | 637294 | 2020-10-16 | Newport | Rhode Island | 44005 | 582 | 8 |
637295 | 637295 | 2020-10-16 | Providence | Rhode Island | 44007 | 20439 | 909 |
637296 | 637296 | 2020-10-16 | Unknown | Rhode Island | 2945 | 27 | |
637297 | 637297 | 2020-10-16 | Washington | Rhode Island | 44009 | 1119 | 75 |
634046 | 634046 | 2020-10-15 | Bristol | Rhode Island | 44001 | 461 | 17 |
634047 | 634047 | 2020-10-15 | Kent | Rhode Island | 44003 | 2145 | 116 |
634048 | 634048 | 2020-10-15 | Newport | Rhode Island | 44005 | 582 | 8 |
634049 | 634049 | 2020-10-15 | Providence | Rhode Island | 44007 | 20439 | 909 |
634050 | 634050 | 2020-10-15 | Unknown | Rhode Island | 2692 | 24 | |
634051 | 634051 | 2020-10-15 | Washington | Rhode Island | 44009 | 1119 | 75 |
630801 | 630801 | 2020-10-14 | Bristol | Rhode Island | 44001 | 461 | 17 |
630802 | 630802 | 2020-10-14 | Kent | Rhode Island | 44003 | 2145 | 116 |
630803 | 630803 | 2020-10-14 | Newport | Rhode Island | 44005 | 582 | 8 |
630804 | 630804 | 2020-10-14 | Providence | Rhode Island | 44007 | 20439 | 909 |
630805 | 630805 | 2020-10-14 | Unknown | Rhode Island | 2418 | 22 | |
630806 | 630806 | 2020-10-14 | Washington | Rhode Island | 44009 | 1119 | 75 |
627557 | 627557 | 2020-10-13 | Bristol | Rhode Island | 44001 | 430 | 16 |
627558 | 627558 | 2020-10-13 | Kent | Rhode Island | 44003 | 2018 | 113 |
627559 | 627559 | 2020-10-13 | Newport | Rhode Island | 44005 | 545 | 8 |
627560 | 627560 | 2020-10-13 | Providence | Rhode Island | 44007 | 19636 | 902 |
627561 | 627561 | 2020-10-13 | Unknown | Rhode Island | 3376 | 26 | |
627562 | 627562 | 2020-10-13 | Washington | Rhode Island | 44009 | 955 | 74 |
624315 | 624315 | 2020-10-12 | Bristol | Rhode Island | 44001 | 430 | 16 |
624316 | 624316 | 2020-10-12 | Kent | Rhode Island | 44003 | 2018 | 113 |
624317 | 624317 | 2020-10-12 | Newport | Rhode Island | 44005 | 545 | 8 |
624318 | 624318 | 2020-10-12 | Providence | Rhode Island | 44007 | 19636 | 902 |
624319 | 624319 | 2020-10-12 | Unknown | Rhode Island | 2710 | 17 | |
624320 | 624320 | 2020-10-12 | Washington | Rhode Island | 44009 | 955 | 74 |
621072 | 621072 | 2020-10-11 | Bristol | Rhode Island | 44001 | 430 | 16 |
621073 | 621073 | 2020-10-11 | Kent | Rhode Island | 44003 | 2018 | 113 |
621074 | 621074 | 2020-10-11 | Newport | Rhode Island | 44005 | 545 | 8 |
621075 | 621075 | 2020-10-11 | Providence | Rhode Island | 44007 | 19636 | 902 |
621076 | 621076 | 2020-10-11 | Unknown | Rhode Island | 2710 | 17 | |
621077 | 621077 | 2020-10-11 | Washington | Rhode Island | 44009 | 955 | 74 |
617829 | 617829 | 2020-10-10 | Bristol | Rhode Island | 44001 | 430 | 16 |
617830 | 617830 | 2020-10-10 | Kent | Rhode Island | 44003 | 2018 | 113 |
617831 | 617831 | 2020-10-10 | Newport | Rhode Island | 44005 | 545 | 8 |
617832 | 617832 | 2020-10-10 | Providence | Rhode Island | 44007 | 19636 | 902 |
617833 | 617833 | 2020-10-10 | Unknown | Rhode Island | 2710 | 17 | |
617834 | 617834 | 2020-10-10 | Washington | Rhode Island | 44009 | 955 | 74 |
614587 | 614587 | 2020-10-09 | Bristol | Rhode Island | 44001 | 430 | 16 |
614588 | 614588 | 2020-10-09 | Kent | Rhode Island | 44003 | 2018 | 113 |
614589 | 614589 | 2020-10-09 | Newport | Rhode Island | 44005 | 545 | 8 |
614590 | 614590 | 2020-10-09 | Providence | Rhode Island | 44007 | 19636 | 902 |
614591 | 614591 | 2020-10-09 | Unknown | Rhode Island | 2710 | 17 | |
614592 | 614592 | 2020-10-09 | Washington | Rhode Island | 44009 | 955 | 74 |
611346 | 611346 | 2020-10-08 | Bristol | Rhode Island | 44001 | 430 | 16 |
611347 | 611347 | 2020-10-08 | Kent | Rhode Island | 44003 | 2018 | 113 |
611348 | 611348 | 2020-10-08 | Newport | Rhode Island | 44005 | 545 | 8 |
611349 | 611349 | 2020-10-08 | Providence | Rhode Island | 44007 | 19636 | 902 |
611350 | 611350 | 2020-10-08 | Unknown | Rhode Island | 2461 | 14 | |
611351 | 611351 | 2020-10-08 | Washington | Rhode Island | 44009 | 955 | 74 |
608104 | 608104 | 2020-10-07 | Bristol | Rhode Island | 44001 | 430 | 16 |
608105 | 608105 | 2020-10-07 | Kent | Rhode Island | 44003 | 2018 | 113 |
608106 | 608106 | 2020-10-07 | Newport | Rhode Island | 44005 | 545 | 8 |
608107 | 608107 | 2020-10-07 | Providence | Rhode Island | 44007 | 19636 | 902 |
608108 | 608108 | 2020-10-07 | Unknown | Rhode Island | 2192 | 13 | |
608109 | 608109 | 2020-10-07 | Washington | Rhode Island | 44009 | 955 | 74 |
604861 | 604861 | 2020-10-06 | Bristol | Rhode Island | 44001 | 414 | 16 |
604862 | 604862 | 2020-10-06 | Kent | Rhode Island | 44003 | 1945 | 111 |
604863 | 604863 | 2020-10-06 | Newport | Rhode Island | 44005 | 530 | 8 |
604864 | 604864 | 2020-10-06 | Providence | Rhode Island | 44007 | 18927 | 894 |
604865 | 604865 | 2020-10-06 | Unknown | Rhode Island | 2903 | 24 | |
604866 | 604866 | 2020-10-06 | Washington | Rhode Island | 44009 | 877 | 72 |
601619 | 601619 | 2020-10-05 | Bristol | Rhode Island | 44001 | 414 | 16 |
601620 | 601620 | 2020-10-05 | Kent | Rhode Island | 44003 | 1945 | 111 |
601621 | 601621 | 2020-10-05 | Newport | Rhode Island | 44005 | 530 | 8 |
601622 | 601622 | 2020-10-05 | Providence | Rhode Island | 44007 | 18927 | 894 |
601623 | 601623 | 2020-10-05 | Unknown | Rhode Island | 2726 | 20 | |
601624 | 601624 | 2020-10-05 | Washington | Rhode Island | 44009 | 877 | 72 |
598376 | 598376 | 2020-10-04 | Bristol | Rhode Island | 44001 | 414 | 16 |
598377 | 598377 | 2020-10-04 | Kent | Rhode Island | 44003 | 1945 | 111 |
598378 | 598378 | 2020-10-04 | Newport | Rhode Island | 44005 | 530 | 8 |
598379 | 598379 | 2020-10-04 | Providence | Rhode Island | 44007 | 18927 | 894 |
598380 | 598380 | 2020-10-04 | Unknown | Rhode Island | 2383 | 17 | |
598381 | 598381 | 2020-10-04 | Washington | Rhode Island | 44009 | 877 | 72 |
595133 | 595133 | 2020-10-03 | Bristol | Rhode Island | 44001 | 414 | 16 |
595134 | 595134 | 2020-10-03 | Kent | Rhode Island | 44003 | 1945 | 111 |
595135 | 595135 | 2020-10-03 | Newport | Rhode Island | 44005 | 530 | 8 |
595136 | 595136 | 2020-10-03 | Providence | Rhode Island | 44007 | 18927 | 894 |
595137 | 595137 | 2020-10-03 | Unknown | Rhode Island | 2383 | 17 | |
595138 | 595138 | 2020-10-03 | Washington | Rhode Island | 44009 | 877 | 72 |
591892 | 591892 | 2020-10-02 | Bristol | Rhode Island | 44001 | 414 | 16 |
591893 | 591893 | 2020-10-02 | Kent | Rhode Island | 44003 | 1945 | 111 |
591894 | 591894 | 2020-10-02 | Newport | Rhode Island | 44005 | 530 | 8 |
591895 | 591895 | 2020-10-02 | Providence | Rhode Island | 44007 | 18927 | 894 |
591896 | 591896 | 2020-10-02 | Unknown | Rhode Island | 2383 | 17 | |
591897 | 591897 | 2020-10-02 | Washington | Rhode Island | 44009 | 877 | 72 |
588651 | 588651 | 2020-10-01 | Bristol | Rhode Island | 44001 | 414 | 16 |
588652 | 588652 | 2020-10-01 | Kent | Rhode Island | 44003 | 1945 | 111 |
588653 | 588653 | 2020-10-01 | Newport | Rhode Island | 44005 | 530 | 8 |
588654 | 588654 | 2020-10-01 | Providence | Rhode Island | 44007 | 18927 | 894 |
588655 | 588655 | 2020-10-01 | Unknown | Rhode Island | 2221 | 16 | |
588656 | 588656 | 2020-10-01 | Washington | Rhode Island | 44009 | 877 | 72 |
585411 | 585411 | 2020-09-30 | Bristol | Rhode Island | 44001 | 414 | 16 |
585412 | 585412 | 2020-09-30 | Kent | Rhode Island | 44003 | 1945 | 111 |
585413 | 585413 | 2020-09-30 | Newport | Rhode Island | 44005 | 530 | 8 |
585414 | 585414 | 2020-09-30 | Providence | Rhode Island | 44007 | 18927 | 894 |
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);