johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6,090 rows where province_or_state = "Rhode Island" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: admin2, latitude, combined_key, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
339779 | 339779 | 2020-03-21 | US | Rhode Island | 66 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-21T19:43:03 | ||||
1177028 | 1177028 | 2020-03-18 | US | Rhode Island | 33 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-18T19:33:03 | ||||
1463599 | 1463599 | 2020-03-15 | US | Rhode Island | 20 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-14T18:53:03 | ||||
1527026 | 1527026 | 2020-03-19 | US | Rhode Island | 44 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-19T23:43:04 | ||||
2111215 | 2111215 | 2020-03-14 | US | Rhode Island | 20 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-14T18:53:03 | ||||
2127583 | 2127583 | 2020-03-11 | US | Rhode Island | 5 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-11T03:13:08 | ||||
2255260 | 2255260 | 2020-03-16 | US | Rhode Island | 21 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-16T18:14:12 | ||||
2283017 | 2283017 | 2020-03-12 | US | Rhode Island | 5 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-11T03:13:08 | ||||
3734071 | 3734071 | 2020-03-20 | US | Rhode Island | 54 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-20T19:43:03 | ||||
3752966 | 3752966 | 2020-03-10 | US | Rhode Island | 3 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-10T03:13:17 | ||||
3765493 | 3765493 | 2020-03-13 | US | Rhode Island | 14 | 0 | 0 | 41.680893 | -71.51178 | 2020-03-11T20:00:00 | ||||
3891466 | 3891466 | 2020-03-17 | US | Rhode Island | 23 | 0 | 0 | 41.6809 | -71.5118 | 2020-03-17T20:53:02 | ||||
3124 | 3124 | 2021-12-02 | US | Rhode Island | Bristol | 44001 | 6630 | 150 | 0 | 41.71018079 | -71.28652315 | 2021-12-03 04:23:05 | Bristol, Rhode Island, US | |
7139 | 7139 | 2021-10-28 | US | Rhode Island | Bristol | 44001 | 6073 | 149 | 0 | 41.71018079 | -71.28652315 | 2021-10-29 04:22:03 | Bristol, Rhode Island, US | |
11111 | 11111 | 2020-10-25 | US | Rhode Island | Bristol | 44001 | 498 | 18 | 0 | 480 | 41.71018079 | -71.28652315 | 2020-10-26 04:25:02 | Bristol, Rhode Island, US |
15124 | 15124 | 2021-01-26 | US | Rhode Island | Bristol | 44001 | 3499 | 97 | 0 | 3402 | 41.71018079 | -71.28652315 | 2021-01-27 05:23:41 | Bristol, Rhode Island, US |
19146 | 19146 | 2021-09-18 | US | Rhode Island | Bristol | 44001 | 5609 | 149 | 0 | 41.71018079 | -71.28652315 | 2021-09-19 04:21:34 | Bristol, Rhode Island, US | |
23157 | 23157 | 2021-05-28 | US | Rhode Island | Bristol | 44001 | 5153 | 144 | 0 | 41.71018079 | -71.28652315 | 2021-05-29 04:20:41 | Bristol, Rhode Island, US | |
27195 | 27195 | 2022-03-20 | US | Rhode Island | Bristol | 44001 | 13298 | 166 | 0 | 41.71018079 | -71.28652315 | 2022-03-21 04:20:50 | Bristol, Rhode Island, US | |
31210 | 31210 | 2021-11-11 | US | Rhode Island | Bristol | 44001 | 6212 | 149 | 0 | 41.71018079 | -71.28652315 | 2021-11-12 04:22:01 | Bristol, Rhode Island, US | |
35206 | 35206 | 2021-08-25 | US | Rhode Island | Bristol | 44001 | 5421 | 147 | 0 | 41.71018079 | -71.28652315 | 2021-08-26 04:21:28 | Bristol, Rhode Island, US | |
39216 | 39216 | 2021-04-12 | US | Rhode Island | Bristol | 44001 | 4722 | 140 | 0 | 41.71018079 | -71.28652315 | 2021-04-13 04:20:37 | Bristol, Rhode Island, US | |
40573 | 40573 | 2020-04-13 | US | Rhode Island | Bristol | 44001 | 39 | 0 | 0 | 39 | 41.71018079 | -71.28652315 | 2020-04-13 23:07:54 | Bristol, Rhode Island, US |
46502 | 46502 | 2021-11-02 | US | Rhode Island | Bristol | 44001 | 6073 | 149 | 0 | 41.71018079 | -71.28652315 | 2021-11-03 06:22:09 | Bristol, Rhode Island, US | |
47634 | 47634 | 2020-04-17 | US | Rhode Island | Bristol | 44001 | 57 | 0 | 0 | 57 | 41.71018079 | -71.28652315 | 2020-04-17 23:30:52 | Bristol, Rhode Island, US |
53578 | 53578 | 2021-05-29 | US | Rhode Island | Bristol | 44001 | 5153 | 144 | 0 | 41.71018079 | -71.28652315 | 2021-05-30 04:20:55 | Bristol, Rhode Island, US | |
57589 | 57589 | 2021-03-07 | US | Rhode Island | Bristol | 44001 | 4247 | 134 | 0 | 41.71018079 | -71.28652315 | 2021-03-08 05:24:48 | Bristol, Rhode Island, US | |
58787 | 58787 | 2020-07-23 | US | Rhode Island | Bristol | 44001 | 290 | 15 | 0 | 275 | 41.71018079 | -71.28652315 | 2020-07-24 05:30:40 | Bristol, Rhode Island, US |
65860 | 65860 | 2022-11-12 | US | Rhode Island | Bristol | 44001 | 16850 | 190 | 0 | 41.71018079 | -71.28652315 | 2022-11-13 04:21:14 | Bristol, Rhode Island, US | |
69851 | 69851 | 2021-09-01 | US | Rhode Island | Bristol | 44001 | 5470 | 147 | 0 | 41.71018079 | -71.28652315 | 2021-09-02 04:21:15 | Bristol, Rhode Island, US | |
73885 | 73885 | 2022-02-07 | US | Rhode Island | Bristol | 44001 | 12482 | 164 | 0 | 41.71018079 | -71.28652315 | 2022-02-08 04:21:15 | Bristol, Rhode Island, US | |
77871 | 77871 | 2020-12-03 | US | Rhode Island | Bristol | 44001 | 1369 | 48 | 0 | 1321 | 41.71018079 | -71.28652315 | 2020-12-04 05:27:27 | Bristol, Rhode Island, US |
81865 | 81865 | 2020-10-14 | US | Rhode Island | Bristol | 44001 | 461 | 17 | 0 | 444 | 41.71018079 | -71.28652315 | 2020-10-15 04:24:28 | Bristol, Rhode Island, US |
85881 | 85881 | 2021-05-25 | US | Rhode Island | Bristol | 44001 | 5153 | 144 | 0 | 41.71018079 | -71.28652315 | 2021-05-26 04:20:35 | Bristol, Rhode Island, US | |
89919 | 89919 | 2021-11-09 | US | Rhode Island | Bristol | 44001 | 6149 | 149 | 0 | 41.71018079 | -71.28652315 | 2021-11-10 04:21:38 | Bristol, Rhode Island, US | |
93937 | 93937 | 2022-07-23 | US | Rhode Island | Bristol | 44001 | 15749 | 178 | 0 | 41.71018079 | -71.28652315 | 2022-07-24 04:20:47 | Bristol, Rhode Island, US | |
95109 | 95109 | 2020-08-04 | US | Rhode Island | Bristol | 44001 | 304 | 15 | 0 | 289 | 41.71018079 | -71.28652315 | 2020-08-05 04:34:43 | Bristol, Rhode Island, US |
102120 | 102120 | 2022-01-14 | US | Rhode Island | Bristol | 44001 | 10009 | 159 | 0 | 41.71018079 | -71.28652315 | 2022-01-15 04:21:07 | Bristol, Rhode Island, US | |
106116 | 106116 | 2021-08-15 | US | Rhode Island | Bristol | 44001 | 5318 | 146 | 0 | 41.71018079 | -71.28652315 | 2021-08-16 04:21:31 | Bristol, Rhode Island, US | |
110240 | 110240 | 2021-06-19 | US | Rhode Island | Bristol | 44001 | 5181 | 145 | 0 | 41.71018079 | -71.28652315 | 2021-06-20 04:21:48 | Bristol, Rhode Island, US | |
111400 | 111400 | 2020-05-08 | US | Rhode Island | Bristol | 44001 | 154 | 0 | 0 | 154 | 41.71018079 | -71.28652315 | 2020-05-09 02:32:35 | Bristol, Rhode Island, US |
117547 | 117547 | 2022-09-06 | US | Rhode Island | Bristol | 44001 | 16161 | 181 | 0 | 41.71018079 | -71.28652315 | 2022-09-07 04:20:59 | Bristol, Rhode Island, US | |
118717 | 118717 | 2020-07-19 | US | Rhode Island | Bristol | 44001 | 283 | 15 | 0 | 268 | 41.71018079 | -71.28652315 | 2020-07-20 05:34:40 | Bristol, Rhode Island, US |
125486 | 125486 | 2020-11-18 | US | Rhode Island | Bristol | 44001 | 1044 | 26 | 0 | 1018 | 41.71018079 | -71.28652315 | 2020-11-19 05:25:23 | Bristol, Rhode Island, US |
129527 | 129527 | 2022-01-09 | US | Rhode Island | Bristol | 44001 | 8547 | 157 | 0 | 41.71018079 | -71.28652315 | 2022-01-10 04:22:07 | Bristol, Rhode Island, US | |
133548 | 133548 | 2022-10-04 | US | Rhode Island | Bristol | 44001 | 16390 | 184 | 0 | 41.71018079 | -71.28652315 | 2022-10-05 04:23:06 | Bristol, Rhode Island, US | |
134677 | 134677 | 2020-04-29 | US | Rhode Island | Bristol | 44001 | 145 | 0 | 0 | 145 | 41.71018079 | -71.28652315 | 2020-04-30 02:32:27 | Bristol, Rhode Island, US |
140765 | 140765 | 2021-12-04 | US | Rhode Island | Bristol | 44001 | 6630 | 150 | 0 | 41.71018079 | -71.28652315 | 2021-12-05 04:22:25 | Bristol, Rhode Island, US | |
144783 | 144783 | 2022-07-09 | US | Rhode Island | Bristol | 44001 | 15606 | 177 | 0 | 41.71018079 | -71.28652315 | 2022-07-10 04:20:54 | Bristol, Rhode Island, US | |
148738 | 148738 | 2020-08-15 | US | Rhode Island | Bristol | 44001 | 322 | 15 | 0 | 307 | 41.71018079 | -71.28652315 | 2020-08-16 04:27:42 | Bristol, Rhode Island, US |
152778 | 152778 | 2021-11-29 | US | Rhode Island | Bristol | 44001 | 6488 | 150 | 0 | 41.71018079 | -71.28652315 | 2021-11-30 04:22:53 | Bristol, Rhode Island, US | |
156765 | 156765 | 2021-01-08 | US | Rhode Island | Bristol | 44001 | 2834 | 71 | 0 | 2763 | 41.71018079 | -71.28652315 | 2021-01-09 05:22:18 | Bristol, Rhode Island, US |
160807 | 160807 | 2022-03-29 | US | Rhode Island | Bristol | 44001 | 13381 | 166 | 0 | 41.71018079 | -71.28652315 | 2022-03-30 04:20:45 | Bristol, Rhode Island, US | |
164822 | 164822 | 2021-11-19 | US | Rhode Island | Bristol | 44001 | 6329 | 149 | 0 | 41.71018079 | -71.28652315 | 2021-11-20 04:22:17 | Bristol, Rhode Island, US | |
168840 | 168840 | 2022-06-21 | US | Rhode Island | Bristol | 44001 | 15370 | 173 | 0 | 41.71018079 | -71.28652315 | 2022-06-22 04:20:54 | Bristol, Rhode Island, US | |
172830 | 172830 | 2021-04-16 | US | Rhode Island | Bristol | 44001 | 4817 | 141 | 0 | 41.71018079 | -71.28652315 | 2021-04-17 04:20:40 | Bristol, Rhode Island, US | |
174026 | 174026 | 2020-07-27 | US | Rhode Island | Bristol | 44001 | 290 | 15 | 0 | 275 | 41.71018079 | -71.28652315 | 2020-07-28 04:58:43 | Bristol, Rhode Island, US |
180816 | 180816 | 2021-09-02 | US | Rhode Island | Bristol | 44001 | 5470 | 147 | 0 | 41.71018079 | -71.28652315 | 2021-09-03 04:21:20 | Bristol, Rhode Island, US | |
184824 | 184824 | 2021-02-21 | US | Rhode Island | Bristol | 44001 | 4115 | 123 | 0 | 3992 | 41.71018079 | -71.28652315 | 2021-02-22 05:24:21 | Bristol, Rhode Island, US |
188865 | 188865 | 2022-02-13 | US | Rhode Island | Bristol | 44001 | 12739 | 166 | 0 | 41.71018079 | -71.28652315 | 2022-02-14 04:20:51 | Bristol, Rhode Island, US | |
192851 | 192851 | 2021-01-11 | US | Rhode Island | Bristol | 44001 | 2834 | 71 | 0 | 2763 | 41.71018079 | -71.28652315 | 2021-01-12 05:22:15 | Bristol, Rhode Island, US |
196842 | 196842 | 2020-08-31 | US | Rhode Island | Bristol | 44001 | 349 | 16 | 0 | 333 | 41.71018079 | -71.28652315 | 2020-09-01 04:28:31 | Bristol, Rhode Island, US |
201057 | 201057 | 2022-10-19 | US | Rhode Island | Bristol | 44001 | 16522 | 186 | 0 | 41.71018079 | -71.28652315 | 2022-10-20 04:22:59 | Bristol, Rhode Island, US | |
205038 | 205038 | 2020-12-25 | US | Rhode Island | Bristol | 44001 | 2065 | 58 | 0 | 2007 | 41.71018079 | -71.28652315 | 2020-12-26 05:22:28 | Bristol, Rhode Island, US |
209024 | 209024 | 2020-08-19 | US | Rhode Island | Bristol | 44001 | 329 | 15 | 0 | 314 | 41.71018079 | -71.28652315 | 2020-08-20 04:27:43 | Bristol, Rhode Island, US |
213020 | 213020 | 2020-10-29 | US | Rhode Island | Bristol | 44001 | 558 | 19 | 0 | 539 | 41.71018079 | -71.28652315 | 2020-10-30 04:24:49 | Bristol, Rhode Island, US |
214195 | 214195 | 2020-06-08 | US | Rhode Island | Bristol | 44001 | 231 | 13 | 0 | 218 | 41.71018079 | -71.28652315 | 2020-06-09 03:33:03 | Bristol, Rhode Island, US |
220778 | 220778 | 2022-12-26 | US | Rhode Island | Bristol | 44001 | 17171 | 190 | 0 | 41.71018079 | -71.28652315 | 2022-12-27 04:21:07 | Bristol, Rhode Island, US | |
224790 | 224790 | 2022-05-09 | US | Rhode Island | Bristol | 44001 | 14076 | 169 | 0 | 41.71018079 | -71.28652315 | 2022-05-10 04:20:50 | Bristol, Rhode Island, US | |
225923 | 225923 | 2020-04-30 | US | Rhode Island | Bristol | 44001 | 143 | 0 | 0 | 143 | 41.71018079 | -71.28652315 | 2020-05-01 02:32:28 | Bristol, Rhode Island, US |
232022 | 232022 | 2022-05-31 | US | Rhode Island | Bristol | 44001 | 14935 | 170 | 0 | 41.71018079 | -71.28652315 | 2022-06-01 04:20:55 | Bristol, Rhode Island, US | |
236037 | 236037 | 2022-02-11 | US | Rhode Island | Bristol | 44001 | 12739 | 166 | 0 | 41.71018079 | -71.28652315 | 2022-02-12 04:21:06 | Bristol, Rhode Island, US | |
240024 | 240024 | 2021-01-18 | US | Rhode Island | Bristol | 44001 | 3251 | 78 | 0 | 3173 | 41.71018079 | -71.28652315 | 2021-01-19 05:22:15 | Bristol, Rhode Island, US |
244041 | 244041 | 2021-04-02 | US | Rhode Island | Bristol | 44001 | 4591 | 140 | 0 | 41.71018079 | -71.28652315 | 2021-04-03 04:20:44 | Bristol, Rhode Island, US | |
248059 | 248059 | 2021-08-17 | US | Rhode Island | Bristol | 44001 | 5318 | 146 | 0 | 41.71018079 | -71.28652315 | 2021-08-18 04:21:35 | Bristol, Rhode Island, US | |
252073 | 252073 | 2021-09-04 | US | Rhode Island | Bristol | 44001 | 5470 | 147 | 0 | 41.71018079 | -71.28652315 | 2021-09-05 04:21:33 | Bristol, Rhode Island, US | |
256109 | 256109 | 2022-09-08 | US | Rhode Island | Bristol | 44001 | 16210 | 183 | 0 | 41.71018079 | -71.28652315 | 2022-09-09 04:21:11 | Bristol, Rhode Island, US | |
260128 | 260128 | 2022-12-10 | US | Rhode Island | Bristol | 44001 | 17031 | 192 | 0 | 41.71018079 | -71.28652315 | 2022-12-11 04:20:50 | Bristol, Rhode Island, US | |
264327 | 264327 | 2022-03-15 | US | Rhode Island | Bristol | 44001 | 13228 | 166 | 0 | 41.71018079 | -71.28652315 | 2022-03-16 04:20:50 | Bristol, Rhode Island, US | |
265473 | 265473 | 2020-05-21 | US | Rhode Island | Bristol | 44001 | 204 | 0 | 0 | 204 | 41.71018079 | -71.28652315 | 2020-05-22 02:36:51 | Bristol, Rhode Island, US |
268896 | 268896 | 2020-04-28 | US | Rhode Island | Bristol | 44001 | 115 | 0 | 0 | 115 | 41.71018079 | -71.28652315 | 2020-04-29 02:32:29 | Bristol, Rhode Island, US |
274936 | 274936 | 2020-11-10 | US | Rhode Island | Bristol | 44001 | 661 | 20 | 0 | 641 | 41.71018079 | -71.28652315 | 2020-11-11 05:25:30 | Bristol, Rhode Island, US |
278977 | 278977 | 2021-11-03 | US | Rhode Island | Bristol | 44001 | 6149 | 149 | 0 | 41.71018079 | -71.28652315 | 2021-11-04 04:22:20 | Bristol, Rhode Island, US | |
282967 | 282967 | 2021-02-24 | US | Rhode Island | Bristol | 44001 | 4172 | 130 | 0 | 4042 | 41.71018079 | -71.28652315 | 2021-02-25 05:24:57 | Bristol, Rhode Island, US |
284146 | 284146 | 2020-06-15 | US | Rhode Island | Bristol | 44001 | 240 | 14 | 0 | 226 | 41.71018079 | -71.28652315 | 2020-06-16 04:33:09 | Bristol, Rhode Island, US |
290789 | 290789 | 2021-10-31 | US | Rhode Island | Bristol | 44001 | 6073 | 149 | 0 | 41.71018079 | -71.28652315 | 2021-11-01 04:22:01 | Bristol, Rhode Island, US | |
294811 | 294811 | 2022-11-15 | US | Rhode Island | Bristol | 44001 | 16850 | 190 | 0 | 41.71018079 | -71.28652315 | 2022-11-16 04:21:09 | Bristol, Rhode Island, US | |
298802 | 298802 | 2021-07-15 | US | Rhode Island | Bristol | 44001 | 5192 | 146 | 0 | 41.71018079 | -71.28652315 | 2021-07-16 04:21:22 | Bristol, Rhode Island, US | |
299979 | 299979 | 2020-07-01 | US | Rhode Island | Bristol | 44001 | 253 | 15 | 0 | 238 | 41.71018079 | -71.28652315 | 2020-07-02 04:33:46 | Bristol, Rhode Island, US |
306663 | 306663 | 2022-04-16 | US | Rhode Island | Bristol | 44001 | 13655 | 169 | 0 | 41.71018079 | -71.28652315 | 2022-04-17 04:20:59 | Bristol, Rhode Island, US | |
310683 | 310683 | 2022-12-13 | US | Rhode Island | Bristol | 44001 | 17031 | 192 | 0 | 41.71018079 | -71.28652315 | 2022-12-14 04:21:04 | Bristol, Rhode Island, US | |
314699 | 314699 | 2022-11-13 | US | Rhode Island | Bristol | 44001 | 16850 | 190 | 0 | 41.71018079 | -71.28652315 | 2022-11-14 04:21:09 | Bristol, Rhode Island, US | |
318711 | 318711 | 2022-02-12 | US | Rhode Island | Bristol | 44001 | 12739 | 166 | 0 | 41.71018079 | -71.28652315 | 2022-02-13 04:21:00 | Bristol, Rhode Island, US | |
322731 | 322731 | 2022-10-30 | US | Rhode Island | Bristol | 44001 | 16673 | 188 | 0 | 41.71018079 | -71.28652315 | 2022-10-31 04:21:36 | Bristol, Rhode Island, US | |
323891 | 323891 | 2020-07-20 | US | Rhode Island | Bristol | 44001 | 283 | 15 | 0 | 268 | 41.71018079 | -71.28652315 | 2020-07-21 04:38:46 | Bristol, Rhode Island, US |
330705 | 330705 | 2022-12-27 | US | Rhode Island | Bristol | 44001 | 17171 | 190 | 0 | 41.71018079 | -71.28652315 | 2022-12-28 04:21:04 | Bristol, Rhode Island, US | |
334696 | 334696 | 2021-08-04 | US | Rhode Island | Bristol | 44001 | 5268 | 146 | 0 | 41.71018079 | -71.28652315 | 2021-08-05 04:21:51 | Bristol, Rhode Island, US | |
338731 | 338731 | 2022-03-18 | US | Rhode Island | Bristol | 44001 | 13298 | 166 | 0 | 41.71018079 | -71.28652315 | 2022-03-19 04:20:47 | Bristol, Rhode Island, US | |
343059 | 343059 | 2021-02-03 | US | Rhode Island | Bristol | 44001 | 3890 | 114 | 0 | 3776 | 41.71018079 | -71.28652315 | 2021-02-04 05:22:26 | Bristol, Rhode Island, US |
347050 | 347050 | 2020-09-14 | US | Rhode Island | Bristol | 44001 | 369 | 16 | 0 | 353 | 41.71018079 | -71.28652315 | 2020-09-15 03:22:50 | Bristol, Rhode Island, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);