ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 27123 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387320 | 387320 | 2020-07-31 | Ramsey | Minnesota | 27123 | 6686 | 259 |
384102 | 384102 | 2020-07-30 | Ramsey | Minnesota | 27123 | 6607 | 258 |
380885 | 380885 | 2020-07-29 | Ramsey | Minnesota | 27123 | 6503 | 257 |
377668 | 377668 | 2020-07-28 | Ramsey | Minnesota | 27123 | 6416 | 254 |
374453 | 374453 | 2020-07-27 | Ramsey | Minnesota | 27123 | 6347 | 254 |
371241 | 371241 | 2020-07-26 | Ramsey | Minnesota | 27123 | 6253 | 254 |
368031 | 368031 | 2020-07-25 | Ramsey | Minnesota | 27123 | 6164 | 253 |
364823 | 364823 | 2020-07-24 | Ramsey | Minnesota | 27123 | 6070 | 253 |
361616 | 361616 | 2020-07-23 | Ramsey | Minnesota | 27123 | 5985 | 253 |
358411 | 358411 | 2020-07-22 | Ramsey | Minnesota | 27123 | 5890 | 251 |
355208 | 355208 | 2020-07-21 | Ramsey | Minnesota | 27123 | 5825 | 250 |
352006 | 352006 | 2020-07-20 | Ramsey | Minnesota | 27123 | 5719 | 249 |
348806 | 348806 | 2020-07-19 | Ramsey | Minnesota | 27123 | 5687 | 248 |
345605 | 345605 | 2020-07-18 | Ramsey | Minnesota | 27123 | 5585 | 247 |
342405 | 342405 | 2020-07-17 | Ramsey | Minnesota | 27123 | 5534 | 246 |
339209 | 339209 | 2020-07-16 | Ramsey | Minnesota | 27123 | 5470 | 246 |
336013 | 336013 | 2020-07-15 | Ramsey | Minnesota | 27123 | 5397 | 238 |
332820 | 332820 | 2020-07-14 | Ramsey | Minnesota | 27123 | 5357 | 237 |
329633 | 329633 | 2020-07-13 | Ramsey | Minnesota | 27123 | 5313 | 234 |
326447 | 326447 | 2020-07-12 | Ramsey | Minnesota | 27123 | 5256 | 233 |
323264 | 323264 | 2020-07-11 | Ramsey | Minnesota | 27123 | 5169 | 232 |
320085 | 320085 | 2020-07-10 | Ramsey | Minnesota | 27123 | 5127 | 233 |
316910 | 316910 | 2020-07-09 | Ramsey | Minnesota | 27123 | 5066 | 230 |
313736 | 313736 | 2020-07-08 | Ramsey | Minnesota | 27123 | 5013 | 230 |
310566 | 310566 | 2020-07-07 | Ramsey | Minnesota | 27123 | 4963 | 229 |
307398 | 307398 | 2020-07-06 | Ramsey | Minnesota | 27123 | 4911 | 228 |
304231 | 304231 | 2020-07-05 | Ramsey | Minnesota | 27123 | 4855 | 227 |
301067 | 301067 | 2020-07-04 | Ramsey | Minnesota | 27123 | 4805 | 226 |
297904 | 297904 | 2020-07-03 | Ramsey | Minnesota | 27123 | 4805 | 226 |
294746 | 294746 | 2020-07-02 | Ramsey | Minnesota | 27123 | 4777 | 222 |
291592 | 291592 | 2020-07-01 | Ramsey | Minnesota | 27123 | 4724 | 218 |
288441 | 288441 | 2020-06-30 | Ramsey | Minnesota | 27123 | 4685 | 217 |
285291 | 285291 | 2020-06-29 | Ramsey | Minnesota | 27123 | 4629 | 217 |
282146 | 282146 | 2020-06-28 | Ramsey | Minnesota | 27123 | 4610 | 217 |
278998 | 278998 | 2020-06-27 | Ramsey | Minnesota | 27123 | 4563 | 217 |
275850 | 275850 | 2020-06-26 | Ramsey | Minnesota | 27123 | 4508 | 217 |
272707 | 272707 | 2020-06-25 | Ramsey | Minnesota | 27123 | 4474 | 217 |
269570 | 269570 | 2020-06-24 | Ramsey | Minnesota | 27123 | 4424 | 215 |
266437 | 266437 | 2020-06-23 | Ramsey | Minnesota | 27123 | 4394 | 213 |
263311 | 263311 | 2020-06-22 | Ramsey | Minnesota | 27123 | 4352 | 211 |
260182 | 260182 | 2020-06-21 | Ramsey | Minnesota | 27123 | 4306 | 210 |
257056 | 257056 | 2020-06-20 | Ramsey | Minnesota | 27123 | 4244 | 209 |
253936 | 253936 | 2020-06-19 | Ramsey | Minnesota | 27123 | 4180 | 207 |
250821 | 250821 | 2020-06-18 | Ramsey | Minnesota | 27123 | 4128 | 205 |
247709 | 247709 | 2020-06-17 | Ramsey | Minnesota | 27123 | 4079 | 199 |
244596 | 244596 | 2020-06-16 | Ramsey | Minnesota | 27123 | 4033 | 192 |
241485 | 241485 | 2020-06-15 | Ramsey | Minnesota | 27123 | 3992 | 190 |
238376 | 238376 | 2020-06-14 | Ramsey | Minnesota | 27123 | 3936 | 190 |
235269 | 235269 | 2020-06-13 | Ramsey | Minnesota | 27123 | 3882 | 182 |
232163 | 232163 | 2020-06-12 | Ramsey | Minnesota | 27123 | 3813 | 180 |
229059 | 229059 | 2020-06-11 | Ramsey | Minnesota | 27123 | 3740 | 169 |
225957 | 225957 | 2020-06-10 | Ramsey | Minnesota | 27123 | 3680 | 167 |
222859 | 222859 | 2020-06-09 | Ramsey | Minnesota | 27123 | 3626 | 164 |
219764 | 219764 | 2020-06-08 | Ramsey | Minnesota | 27123 | 3553 | 158 |
216672 | 216672 | 2020-06-07 | Ramsey | Minnesota | 27123 | 3507 | 155 |
213584 | 213584 | 2020-06-06 | Ramsey | Minnesota | 27123 | 3445 | 152 |
210500 | 210500 | 2020-06-05 | Ramsey | Minnesota | 27123 | 3351 | 149 |
207419 | 207419 | 2020-06-04 | Ramsey | Minnesota | 27123 | 3252 | 140 |
204338 | 204338 | 2020-06-03 | Ramsey | Minnesota | 27123 | 3189 | 134 |
201261 | 201261 | 2020-06-02 | Ramsey | Minnesota | 27123 | 3128 | 133 |
198188 | 198188 | 2020-06-01 | Ramsey | Minnesota | 27123 | 3075 | 128 |
195117 | 195117 | 2020-05-31 | Ramsey | Minnesota | 27123 | 3019 | 124 |
192049 | 192049 | 2020-05-30 | Ramsey | Minnesota | 27123 | 2863 | 122 |
188985 | 188985 | 2020-05-29 | Ramsey | Minnesota | 27123 | 2790 | 115 |
185927 | 185927 | 2020-05-28 | Ramsey | Minnesota | 27123 | 2698 | 110 |
182872 | 182872 | 2020-05-27 | Ramsey | Minnesota | 27123 | 2610 | 103 |
179826 | 179826 | 2020-05-26 | Ramsey | Minnesota | 27123 | 2551 | 98 |
176782 | 176782 | 2020-05-25 | Ramsey | Minnesota | 27123 | 2437 | 97 |
173739 | 173739 | 2020-05-24 | Ramsey | Minnesota | 27123 | 2316 | 97 |
170697 | 170697 | 2020-05-23 | Ramsey | Minnesota | 27123 | 2164 | 94 |
167659 | 167659 | 2020-05-22 | Ramsey | Minnesota | 27123 | 2018 | 93 |
164623 | 164623 | 2020-05-21 | Ramsey | Minnesota | 27123 | 1925 | 86 |
161594 | 161594 | 2020-05-20 | Ramsey | Minnesota | 27123 | 1846 | 80 |
158568 | 158568 | 2020-05-19 | Ramsey | Minnesota | 27123 | 1720 | 74 |
155550 | 155550 | 2020-05-18 | Ramsey | Minnesota | 27123 | 1625 | 72 |
152536 | 152536 | 2020-05-17 | Ramsey | Minnesota | 27123 | 1530 | 71 |
149525 | 149525 | 2020-05-16 | Ramsey | Minnesota | 27123 | 1416 | 67 |
146520 | 146520 | 2020-05-15 | Ramsey | Minnesota | 27123 | 1287 | 61 |
143520 | 143520 | 2020-05-14 | Ramsey | Minnesota | 27123 | 1167 | 56 |
140525 | 140525 | 2020-05-13 | Ramsey | Minnesota | 27123 | 1052 | 49 |
137531 | 137531 | 2020-05-12 | Ramsey | Minnesota | 27123 | 1052 | 49 |
134541 | 134541 | 2020-05-11 | Ramsey | Minnesota | 27123 | 986 | 47 |
131550 | 131550 | 2020-05-10 | Ramsey | Minnesota | 27123 | 920 | 45 |
128560 | 128560 | 2020-05-09 | Ramsey | Minnesota | 27123 | 875 | 43 |
125573 | 125573 | 2020-05-08 | Ramsey | Minnesota | 27123 | 800 | 42 |
122591 | 122591 | 2020-05-07 | Ramsey | Minnesota | 27123 | 717 | 39 |
119617 | 119617 | 2020-05-06 | Ramsey | Minnesota | 27123 | 656 | 38 |
116657 | 116657 | 2020-05-05 | Ramsey | Minnesota | 27123 | 583 | 37 |
113775 | 113775 | 2020-05-04 | Ramsey | Minnesota | 27123 | 535 | 34 |
110896 | 110896 | 2020-05-03 | Ramsey | Minnesota | 27123 | 493 | 34 |
108025 | 108025 | 2020-05-02 | Ramsey | Minnesota | 27123 | 453 | 31 |
105160 | 105160 | 2020-05-01 | Ramsey | Minnesota | 27123 | 405 | 29 |
102299 | 102299 | 2020-04-30 | Ramsey | Minnesota | 27123 | 374 | 26 |
99447 | 99447 | 2020-04-29 | Ramsey | Minnesota | 27123 | 332 | 24 |
96601 | 96601 | 2020-04-28 | Ramsey | Minnesota | 27123 | 317 | 22 |
93766 | 93766 | 2020-04-27 | Ramsey | Minnesota | 27123 | 297 | 22 |
90945 | 90945 | 2020-04-26 | Ramsey | Minnesota | 27123 | 278 | 20 |
88129 | 88129 | 2020-04-25 | Ramsey | Minnesota | 27123 | 261 | 20 |
85319 | 85319 | 2020-04-24 | Ramsey | Minnesota | 27123 | 247 | 18 |
82515 | 82515 | 2020-04-23 | Ramsey | Minnesota | 27123 | 235 | 14 |
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);