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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388327 | 388327 | 2020-07-31 | Unknown | Rhode Island | 1778 | 12 | |
385110 | 385110 | 2020-07-30 | Unknown | Rhode Island | 1706 | 12 | |
381892 | 381892 | 2020-07-29 | Unknown | Rhode Island | 1556 | 12 | |
378675 | 378675 | 2020-07-28 | Unknown | Rhode Island | 2112 | 18 | |
375459 | 375459 | 2020-07-27 | Unknown | Rhode Island | 1902 | 17 | |
372246 | 372246 | 2020-07-26 | Unknown | Rhode Island | 1611 | 15 | |
369034 | 369034 | 2020-07-25 | Unknown | Rhode Island | 1611 | 15 | |
365825 | 365825 | 2020-07-24 | Unknown | Rhode Island | 1611 | 15 | |
362619 | 362619 | 2020-07-23 | Unknown | Rhode Island | 1535 | 14 | |
359413 | 359413 | 2020-07-22 | Unknown | Rhode Island | 1449 | 10 | |
356209 | 356209 | 2020-07-21 | Unknown | Rhode Island | 1784 | 15 | |
353006 | 353006 | 2020-07-20 | Unknown | Rhode Island | 1702 | 14 | |
349803 | 349803 | 2020-07-19 | Unknown | Rhode Island | 1591 | 9 | |
346603 | 346603 | 2020-07-18 | Unknown | Rhode Island | 1591 | 9 | |
343403 | 343403 | 2020-07-17 | Unknown | Rhode Island | 1591 | 9 | |
340205 | 340205 | 2020-07-16 | Unknown | Rhode Island | 1509 | 7 | |
337008 | 337008 | 2020-07-15 | Unknown | Rhode Island | 1438 | 6 | |
333814 | 333814 | 2020-07-14 | Unknown | Rhode Island | 2085 | 30 | |
330622 | 330622 | 2020-07-13 | Unknown | Rhode Island | 1984 | 29 | |
327436 | 327436 | 2020-07-12 | Unknown | Rhode Island | 1809 | 21 | |
324251 | 324251 | 2020-07-11 | Unknown | Rhode Island | 1809 | 21 | |
321071 | 321071 | 2020-07-10 | Unknown | Rhode Island | 1809 | 21 | |
317893 | 317893 | 2020-07-09 | Unknown | Rhode Island | 1740 | 19 | |
314720 | 314720 | 2020-07-08 | Unknown | Rhode Island | 1701 | 16 | |
311548 | 311548 | 2020-07-07 | Unknown | Rhode Island | 1651 | 45 | |
308379 | 308379 | 2020-07-06 | Unknown | Rhode Island | 1488 | 36 | |
305212 | 305212 | 2020-07-05 | Unknown | Rhode Island | 1488 | 36 | |
302049 | 302049 | 2020-07-04 | Unknown | Rhode Island | 1488 | 36 | |
298885 | 298885 | 2020-07-03 | Unknown | Rhode Island | 1488 | 36 | |
295726 | 295726 | 2020-07-02 | Unknown | Rhode Island | 1712 | 35 | |
292570 | 292570 | 2020-07-01 | Unknown | Rhode Island | 1624 | 32 | |
289418 | 289418 | 2020-06-30 | Unknown | Rhode Island | 1584 | 26 | |
286267 | 286267 | 2020-06-29 | Unknown | Rhode Island | 1535 | 22 | |
283122 | 283122 | 2020-06-28 | Unknown | Rhode Island | 1716 | 3 | |
279976 | 279976 | 2020-06-27 | Unknown | Rhode Island | 1716 | 3 | |
276828 | 276828 | 2020-06-26 | Unknown | Rhode Island | 1716 | 3 | |
273681 | 273681 | 2020-06-25 | Unknown | Rhode Island | 1695 | 123 | |
270542 | 270542 | 2020-06-24 | Unknown | Rhode Island | 1661 | 115 | |
267408 | 267408 | 2020-06-23 | Unknown | Rhode Island | 1588 | 109 | |
264280 | 264280 | 2020-06-22 | Unknown | Rhode Island | 1514 | 106 | |
261152 | 261152 | 2020-06-21 | Unknown | Rhode Island | 1813 | 97 | |
258025 | 258025 | 2020-06-20 | Unknown | Rhode Island | 1813 | 97 | |
254899 | 254899 | 2020-06-19 | Unknown | Rhode Island | 1813 | 97 | |
251784 | 251784 | 2020-06-18 | Unknown | Rhode Island | 1745 | 88 | |
248669 | 248669 | 2020-06-17 | Unknown | Rhode Island | 1689 | 79 | |
245556 | 245556 | 2020-06-16 | Unknown | Rhode Island | 1640 | 68 | |
242444 | 242444 | 2020-06-15 | Unknown | Rhode Island | 1569 | 54 | |
239335 | 239335 | 2020-06-14 | Unknown | Rhode Island | 1870 | 36 | |
236227 | 236227 | 2020-06-13 | Unknown | Rhode Island | 1870 | 36 | |
233122 | 233122 | 2020-06-12 | Unknown | Rhode Island | 1870 | 36 | |
230017 | 230017 | 2020-06-11 | Unknown | Rhode Island | 1785 | 26 | |
226913 | 226913 | 2020-06-10 | Unknown | Rhode Island | 1679 | 15 | |
223813 | 223813 | 2020-06-09 | Unknown | Rhode Island | 1614 | 11 | |
220718 | 220718 | 2020-06-08 | Unknown | Rhode Island | 1565 | 2 | |
217626 | 217626 | 2020-06-07 | Unknown | Rhode Island | 2370 | 120 | |
214536 | 214536 | 2020-06-06 | Unknown | Rhode Island | 2370 | 120 | |
211450 | 211450 | 2020-06-05 | Unknown | Rhode Island | 2370 | 120 | |
208368 | 208368 | 2020-06-04 | Unknown | Rhode Island | 2254 | 104 | |
205287 | 205287 | 2020-06-03 | Unknown | Rhode Island | 2148 | 90 | |
202210 | 202210 | 2020-06-02 | Unknown | Rhode Island | 2041 | 80 | |
199135 | 199135 | 2020-06-01 | Unknown | Rhode Island | 1920 | 68 | |
196062 | 196062 | 2020-05-31 | Unknown | Rhode Island | 1857 | 66 | |
192993 | 192993 | 2020-05-30 | Unknown | Rhode Island | 1748 | 59 | |
189928 | 189928 | 2020-05-29 | Unknown | Rhode Island | 1564 | 41 | |
186866 | 186866 | 2020-05-28 | Unknown | Rhode Island | 1533 | 25 | |
183809 | 183809 | 2020-05-27 | Unknown | Rhode Island | 1496 | 3 | |
180759 | 180759 | 2020-05-26 | Unknown | Rhode Island | 1663 | 209 | |
177716 | 177716 | 2020-05-25 | Unknown | Rhode Island | 1518 | 183 | |
174672 | 174672 | 2020-05-24 | Unknown | Rhode Island | 1518 | 183 | |
171630 | 171630 | 2020-05-23 | Unknown | Rhode Island | 1504 | 172 | |
168591 | 168591 | 2020-05-22 | Unknown | Rhode Island | 1528 | 154 | |
165555 | 165555 | 2020-05-21 | Unknown | Rhode Island | 1553 | 131 | |
162526 | 162526 | 2020-05-20 | Unknown | Rhode Island | 1556 | 113 | |
159499 | 159499 | 2020-05-19 | Unknown | Rhode Island | 2162 | 107 | |
156478 | 156478 | 2020-05-18 | Unknown | Rhode Island | 2006 | 81 | |
153461 | 153461 | 2020-05-17 | Unknown | Rhode Island | 1885 | 74 | |
150450 | 150450 | 2020-05-16 | Unknown | Rhode Island | 1645 | 64 | |
147442 | 147442 | 2020-05-15 | Unknown | Rhode Island | 1430 | 54 | |
144441 | 144441 | 2020-05-14 | Unknown | Rhode Island | 1227 | 43 | |
141445 | 141445 | 2020-05-13 | Unknown | Rhode Island | 1046 | 37 | |
138449 | 138449 | 2020-05-12 | Unknown | Rhode Island | 1198 | 19 | |
135459 | 135459 | 2020-05-11 | Unknown | Rhode Island | 1158 | 5 | |
132468 | 132468 | 2020-05-10 | Unknown | Rhode Island | 2755 | 103 | |
129479 | 129479 | 2020-05-09 | Unknown | Rhode Island | 2470 | 99 | |
126490 | 126490 | 2020-05-08 | Unknown | Rhode Island | 2260 | 80 | |
123507 | 123507 | 2020-05-07 | Unknown | Rhode Island | 2011 | 69 | |
120529 | 120529 | 2020-05-06 | Unknown | Rhode Island | 1686 | 51 | |
117567 | 117567 | 2020-05-05 | Unknown | Rhode Island | 1414 | 36 | |
114611 | 114611 | 2020-05-04 | Unknown | Rhode Island | 1133 | 22 | |
111729 | 111729 | 2020-05-03 | Unknown | Rhode Island | 1086 | 1 | |
108855 | 108855 | 2020-05-02 | Unknown | Rhode Island | 1142 | 149 | |
105988 | 105988 | 2020-05-01 | Unknown | Rhode Island | 1104 | 132 | |
103125 | 103125 | 2020-04-30 | Unknown | Rhode Island | 1087 | 119 | |
100272 | 100272 | 2020-04-29 | Unknown | Rhode Island | 1065 | 104 | |
97423 | 97423 | 2020-04-28 | Unknown | Rhode Island | 1267 | 124 | |
94584 | 94584 | 2020-04-27 | Unknown | Rhode Island | 1378 | 118 | |
91757 | 91757 | 2020-04-26 | Unknown | Rhode Island | 1109 | 111 | |
88941 | 88941 | 2020-04-25 | Unknown | Rhode Island | 1198 | 96 | |
86127 | 86127 | 2020-04-24 | Unknown | Rhode Island | 1132 | 182 | |
83323 | 83323 | 2020-04-23 | Unknown | Rhode Island | 1756 | 169 |
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);