ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "Unknown" and state = "Rhode Island" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
419 | 419 | 2020-03-01 | Unknown | Rhode Island | 2 | 0 | |
451 | 451 | 2020-03-02 | Unknown | Rhode Island | 2 | 0 | |
486 | 486 | 2020-03-03 | Unknown | Rhode Island | 2 | 0 | |
523 | 523 | 2020-03-04 | Unknown | Rhode Island | 2 | 0 | |
570 | 570 | 2020-03-05 | Unknown | Rhode Island | 2 | 0 | |
637 | 637 | 2020-03-06 | Unknown | Rhode Island | 3 | 0 | |
729 | 729 | 2020-03-07 | Unknown | Rhode Island | 3 | 0 | |
838 | 838 | 2020-03-08 | Unknown | Rhode Island | 3 | 0 | |
967 | 967 | 2020-03-09 | Unknown | Rhode Island | 3 | 0 | |
1120 | 1120 | 2020-03-10 | Unknown | Rhode Island | 5 | 0 | |
1314 | 1314 | 2020-03-11 | Unknown | Rhode Island | 5 | 0 | |
1560 | 1560 | 2020-03-12 | Unknown | Rhode Island | 5 | 0 | |
1860 | 1860 | 2020-03-13 | Unknown | Rhode Island | 20 | 0 | |
2222 | 2222 | 2020-03-14 | Unknown | Rhode Island | 20 | 0 | |
2644 | 2644 | 2020-03-15 | Unknown | Rhode Island | 20 | 0 | |
3109 | 3109 | 2020-03-16 | Unknown | Rhode Island | 21 | 0 | |
3639 | 3639 | 2020-03-17 | Unknown | Rhode Island | 23 | 0 | |
4258 | 4258 | 2020-03-18 | Unknown | Rhode Island | 33 | 0 | |
5000 | 5000 | 2020-03-19 | Unknown | Rhode Island | 44 | 0 | |
5873 | 5873 | 2020-03-20 | Unknown | Rhode Island | 44 | 0 | |
6877 | 6877 | 2020-03-21 | Unknown | Rhode Island | 66 | 0 | |
7997 | 7997 | 2020-03-22 | Unknown | Rhode Island | 83 | 0 | |
9208 | 9208 | 2020-03-23 | Unknown | Rhode Island | 106 | 0 | |
10533 | 10533 | 2020-03-24 | Unknown | Rhode Island | 124 | 0 | |
12003 | 12003 | 2020-03-25 | Unknown | Rhode Island | 66 | 0 | |
13625 | 13625 | 2020-03-26 | Unknown | Rhode Island | 94 | 0 | |
15372 | 15372 | 2020-03-27 | Unknown | Rhode Island | 132 | 0 | |
111729 | 111729 | 2020-05-03 | Unknown | Rhode Island | 1086 | 1 | |
17226 | 17226 | 2020-03-28 | Unknown | Rhode Island | 168 | 2 | |
220718 | 220718 | 2020-06-08 | Unknown | Rhode Island | 1565 | 2 | |
19166 | 19166 | 2020-03-29 | Unknown | Rhode Island | 69 | 3 | |
183809 | 183809 | 2020-05-27 | Unknown | Rhode Island | 1496 | 3 | |
276828 | 276828 | 2020-06-26 | Unknown | Rhode Island | 1716 | 3 | |
279976 | 279976 | 2020-06-27 | Unknown | Rhode Island | 1716 | 3 | |
283122 | 283122 | 2020-06-28 | Unknown | Rhode Island | 1716 | 3 | |
21217 | 21217 | 2020-03-30 | Unknown | Rhode Island | 99 | 4 | |
135459 | 135459 | 2020-05-11 | Unknown | Rhode Island | 1158 | 5 | |
1351384 | 1351384 | 2021-05-24 | Unknown | Rhode Island | 11925 | 5 | |
1494196 | 1494196 | 2021-07-07 | Unknown | Rhode Island | 11953 | 5 | |
1497443 | 1497443 | 2021-07-08 | Unknown | Rhode Island | 11963 | 5 | |
1500689 | 1500689 | 2021-07-09 | Unknown | Rhode Island | 11944 | 5 | |
1503935 | 1503935 | 2021-07-10 | Unknown | Rhode Island | 11944 | 5 | |
1507181 | 1507181 | 2021-07-11 | Unknown | Rhode Island | 11944 | 5 | |
1562384 | 1562384 | 2021-07-28 | Unknown | Rhode Island | 12116 | 5 | |
1565632 | 1565632 | 2021-07-29 | Unknown | Rhode Island | 12315 | 5 | |
1607866 | 1607866 | 2021-08-11 | Unknown | Rhode Island | 12573 | 5 | |
1611114 | 1611114 | 2021-08-12 | Unknown | Rhode Island | 12937 | 5 | |
1614363 | 1614363 | 2021-08-13 | Unknown | Rhode Island | 13338 | 5 | |
1617611 | 1617611 | 2021-08-14 | Unknown | Rhode Island | 13338 | 5 | |
1620859 | 1620859 | 2021-08-15 | Unknown | Rhode Island | 13338 | 5 | |
2404302 | 2404302 | 2022-04-13 | Unknown | Rhode Island | 27523 | 5 | |
2407558 | 2407558 | 2022-04-14 | Unknown | Rhode Island | 28062 | 5 | |
2410814 | 2410814 | 2022-04-15 | Unknown | Rhode Island | 28394 | 5 | |
2414070 | 2414070 | 2022-04-16 | Unknown | Rhode Island | 28394 | 5 | |
2417326 | 2417326 | 2022-04-17 | Unknown | Rhode Island | 28394 | 5 | |
337008 | 337008 | 2020-07-15 | Unknown | Rhode Island | 1438 | 6 | |
1426034 | 1426034 | 2021-06-16 | Unknown | Rhode Island | 11994 | 6 | |
1510428 | 1510428 | 2021-07-12 | Unknown | Rhode Island | 12034 | 6 | |
1513674 | 1513674 | 2021-07-13 | Unknown | Rhode Island | 12057 | 6 | |
1516921 | 1516921 | 2021-07-14 | Unknown | Rhode Island | 11925 | 6 | |
1539653 | 1539653 | 2021-07-21 | Unknown | Rhode Island | 12013 | 6 | |
1568880 | 1568880 | 2021-07-30 | Unknown | Rhode Island | 12501 | 6 | |
1572128 | 1572128 | 2021-07-31 | Unknown | Rhode Island | 12501 | 6 | |
1575376 | 1575376 | 2021-08-01 | Unknown | Rhode Island | 12501 | 6 | |
1578624 | 1578624 | 2021-08-02 | Unknown | Rhode Island | 12952 | 6 | |
1581873 | 1581873 | 2021-08-03 | Unknown | Rhode Island | 13147 | 6 | |
1630600 | 1630600 | 2021-08-18 | Unknown | Rhode Island | 13091 | 6 | |
2358741 | 2358741 | 2022-03-30 | Unknown | Rhode Island | 26991 | 6 | |
2361995 | 2361995 | 2022-03-31 | Unknown | Rhode Island | 27294 | 6 | |
2365248 | 2365248 | 2022-04-01 | Unknown | Rhode Island | 27540 | 6 | |
2368501 | 2368501 | 2022-04-02 | Unknown | Rhode Island | 27540 | 6 | |
2371754 | 2371754 | 2022-04-03 | Unknown | Rhode Island | 27540 | 6 | |
2375006 | 2375006 | 2022-04-04 | Unknown | Rhode Island | 28032 | 6 | |
2472677 | 2472677 | 2022-05-04 | Unknown | Rhode Island | 28432 | 6 | |
25551 | 25551 | 2020-04-01 | Unknown | Rhode Island | 37 | 7 | |
30159 | 30159 | 2020-04-03 | Unknown | Rhode Island | 146 | 7 | |
340205 | 340205 | 2020-07-16 | Unknown | Rhode Island | 1509 | 7 | |
1354630 | 1354630 | 2021-05-25 | Unknown | Rhode Island | 11987 | 7 | |
1429279 | 1429279 | 2021-06-17 | Unknown | Rhode Island | 12020 | 7 | |
1432525 | 1432525 | 2021-06-18 | Unknown | Rhode Island | 12044 | 7 | |
1435772 | 1435772 | 2021-06-19 | Unknown | Rhode Island | 12044 | 7 | |
1439019 | 1439019 | 2021-06-20 | Unknown | Rhode Island | 12044 | 7 | |
1442264 | 1442264 | 2021-06-21 | Unknown | Rhode Island | 12090 | 7 | |
1448754 | 1448754 | 2021-06-23 | Unknown | Rhode Island | 11994 | 7 | |
1471470 | 1471470 | 2021-06-30 | Unknown | Rhode Island | 11978 | 7 | |
1474716 | 1474716 | 2021-07-01 | Unknown | Rhode Island | 11983 | 7 | |
1477962 | 1477962 | 2021-07-02 | Unknown | Rhode Island | 12008 | 7 | |
1481209 | 1481209 | 2021-07-03 | Unknown | Rhode Island | 12008 | 7 | |
1484455 | 1484455 | 2021-07-04 | Unknown | Rhode Island | 12008 | 7 | |
1487702 | 1487702 | 2021-07-05 | Unknown | Rhode Island | 12008 | 7 | |
1490949 | 1490949 | 2021-07-06 | Unknown | Rhode Island | 12063 | 7 | |
1542901 | 1542901 | 2021-07-22 | Unknown | Rhode Island | 12099 | 7 | |
1546148 | 1546148 | 2021-07-23 | Unknown | Rhode Island | 12191 | 7 | |
1549395 | 1549395 | 2021-07-24 | Unknown | Rhode Island | 12191 | 7 | |
1552642 | 1552642 | 2021-07-25 | Unknown | Rhode Island | 12191 | 7 | |
1555889 | 1555889 | 2021-07-26 | Unknown | Rhode Island | 12441 | 7 | |
1559136 | 1559136 | 2021-07-27 | Unknown | Rhode Island | 12546 | 7 | |
2290431 | 2290431 | 2022-03-09 | Unknown | Rhode Island | 27956 | 7 | |
2378260 | 2378260 | 2022-04-05 | Unknown | Rhode Island | 28299 | 7 | |
2420582 | 2420582 | 2022-04-18 | Unknown | Rhode Island | 29254 | 7 |
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);