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 date
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 | |
17226 | 17226 | 2020-03-28 | Unknown | Rhode Island | 168 | 2 | |
19166 | 19166 | 2020-03-29 | Unknown | Rhode Island | 69 | 3 | |
21217 | 21217 | 2020-03-30 | Unknown | Rhode Island | 99 | 4 | |
23354 | 23354 | 2020-03-31 | Unknown | Rhode Island | 72 | 8 | |
25551 | 25551 | 2020-04-01 | Unknown | Rhode Island | 37 | 7 | |
27824 | 27824 | 2020-04-02 | Unknown | Rhode Island | 92 | 9 | |
30159 | 30159 | 2020-04-03 | Unknown | Rhode Island | 146 | 7 | |
32550 | 32550 | 2020-04-04 | Unknown | Rhode Island | 122 | 10 | |
34986 | 34986 | 2020-04-05 | Unknown | Rhode Island | 172 | 18 | |
37461 | 37461 | 2020-04-06 | Unknown | Rhode Island | 332 | 20 | |
39984 | 39984 | 2020-04-07 | Unknown | Rhode Island | 223 | 13 | |
42544 | 42544 | 2020-04-08 | Unknown | Rhode Island | 297 | 15 | |
45130 | 45130 | 2020-04-09 | Unknown | Rhode Island | 424 | 23 | |
47747 | 47747 | 2020-04-10 | Unknown | Rhode Island | 712 | 29 | |
50404 | 50404 | 2020-04-11 | Unknown | Rhode Island | 673 | 36 | |
53077 | 53077 | 2020-04-12 | Unknown | Rhode Island | 989 | 43 | |
55762 | 55762 | 2020-04-13 | Unknown | Rhode Island | 1300 | 53 | |
58465 | 58465 | 2020-04-14 | Unknown | Rhode Island | 756 | 60 | |
61180 | 61180 | 2020-04-15 | Unknown | Rhode Island | 1034 | 67 | |
63906 | 63906 | 2020-04-16 | Unknown | Rhode Island | 840 | 85 | |
66652 | 66652 | 2020-04-17 | Unknown | Rhode Island | 832 | 98 | |
69410 | 69410 | 2020-04-18 | Unknown | Rhode Island | 815 | 117 | |
72177 | 72177 | 2020-04-19 | Unknown | Rhode Island | 715 | 130 | |
74952 | 74952 | 2020-04-20 | Unknown | Rhode Island | 861 | 135 | |
77734 | 77734 | 2020-04-21 | Unknown | Rhode Island | 1000 | 151 | |
80524 | 80524 | 2020-04-22 | Unknown | Rhode Island | 1341 | 161 | |
83323 | 83323 | 2020-04-23 | Unknown | Rhode Island | 1756 | 169 | |
86127 | 86127 | 2020-04-24 | Unknown | Rhode Island | 1132 | 182 | |
88941 | 88941 | 2020-04-25 | Unknown | Rhode Island | 1198 | 96 | |
91757 | 91757 | 2020-04-26 | Unknown | Rhode Island | 1109 | 111 | |
94584 | 94584 | 2020-04-27 | Unknown | Rhode Island | 1378 | 118 | |
97423 | 97423 | 2020-04-28 | Unknown | Rhode Island | 1267 | 124 | |
100272 | 100272 | 2020-04-29 | Unknown | Rhode Island | 1065 | 104 | |
103125 | 103125 | 2020-04-30 | Unknown | Rhode Island | 1087 | 119 | |
105988 | 105988 | 2020-05-01 | Unknown | Rhode Island | 1104 | 132 | |
108855 | 108855 | 2020-05-02 | Unknown | Rhode Island | 1142 | 149 | |
111729 | 111729 | 2020-05-03 | Unknown | Rhode Island | 1086 | 1 | |
114611 | 114611 | 2020-05-04 | Unknown | Rhode Island | 1133 | 22 | |
117567 | 117567 | 2020-05-05 | Unknown | Rhode Island | 1414 | 36 | |
120529 | 120529 | 2020-05-06 | Unknown | Rhode Island | 1686 | 51 | |
123507 | 123507 | 2020-05-07 | Unknown | Rhode Island | 2011 | 69 | |
126490 | 126490 | 2020-05-08 | Unknown | Rhode Island | 2260 | 80 | |
129479 | 129479 | 2020-05-09 | Unknown | Rhode Island | 2470 | 99 | |
132468 | 132468 | 2020-05-10 | Unknown | Rhode Island | 2755 | 103 | |
135459 | 135459 | 2020-05-11 | Unknown | Rhode Island | 1158 | 5 | |
138449 | 138449 | 2020-05-12 | Unknown | Rhode Island | 1198 | 19 | |
141445 | 141445 | 2020-05-13 | Unknown | Rhode Island | 1046 | 37 | |
144441 | 144441 | 2020-05-14 | Unknown | Rhode Island | 1227 | 43 | |
147442 | 147442 | 2020-05-15 | Unknown | Rhode Island | 1430 | 54 | |
150450 | 150450 | 2020-05-16 | Unknown | Rhode Island | 1645 | 64 | |
153461 | 153461 | 2020-05-17 | Unknown | Rhode Island | 1885 | 74 | |
156478 | 156478 | 2020-05-18 | Unknown | Rhode Island | 2006 | 81 | |
159499 | 159499 | 2020-05-19 | Unknown | Rhode Island | 2162 | 107 | |
162526 | 162526 | 2020-05-20 | Unknown | Rhode Island | 1556 | 113 | |
165555 | 165555 | 2020-05-21 | Unknown | Rhode Island | 1553 | 131 | |
168591 | 168591 | 2020-05-22 | Unknown | Rhode Island | 1528 | 154 | |
171630 | 171630 | 2020-05-23 | Unknown | Rhode Island | 1504 | 172 | |
174672 | 174672 | 2020-05-24 | Unknown | Rhode Island | 1518 | 183 | |
177716 | 177716 | 2020-05-25 | Unknown | Rhode Island | 1518 | 183 | |
180759 | 180759 | 2020-05-26 | Unknown | Rhode Island | 1663 | 209 | |
183809 | 183809 | 2020-05-27 | Unknown | Rhode Island | 1496 | 3 | |
186866 | 186866 | 2020-05-28 | Unknown | Rhode Island | 1533 | 25 | |
189928 | 189928 | 2020-05-29 | Unknown | Rhode Island | 1564 | 41 | |
192993 | 192993 | 2020-05-30 | Unknown | Rhode Island | 1748 | 59 | |
196062 | 196062 | 2020-05-31 | Unknown | Rhode Island | 1857 | 66 | |
199135 | 199135 | 2020-06-01 | Unknown | Rhode Island | 1920 | 68 | |
202210 | 202210 | 2020-06-02 | Unknown | Rhode Island | 2041 | 80 | |
205287 | 205287 | 2020-06-03 | Unknown | Rhode Island | 2148 | 90 | |
208368 | 208368 | 2020-06-04 | Unknown | Rhode Island | 2254 | 104 | |
211450 | 211450 | 2020-06-05 | Unknown | Rhode Island | 2370 | 120 | |
214536 | 214536 | 2020-06-06 | Unknown | Rhode Island | 2370 | 120 | |
217626 | 217626 | 2020-06-07 | Unknown | Rhode Island | 2370 | 120 | |
220718 | 220718 | 2020-06-08 | Unknown | Rhode Island | 1565 | 2 |
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);