ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Ramsey" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
79719 | 79719 | 2020-04-22 | Ramsey | Minnesota | 27123 | 219 | 11 |
76934 | 76934 | 2020-04-21 | Ramsey | Minnesota | 27123 | 215 | 11 |
74153 | 74153 | 2020-04-20 | Ramsey | Minnesota | 27123 | 202 | 10 |
71380 | 71380 | 2020-04-19 | Ramsey | Minnesota | 27123 | 196 | 9 |
68614 | 68614 | 2020-04-18 | Ramsey | Minnesota | 27123 | 192 | 9 |
65862 | 65862 | 2020-04-17 | Ramsey | Minnesota | 27123 | 178 | 9 |
63123 | 63123 | 2020-04-16 | Ramsey | Minnesota | 27123 | 177 | 9 |
60400 | 60400 | 2020-04-15 | Ramsey | Minnesota | 27123 | 164 | 7 |
57689 | 57689 | 2020-04-14 | Ramsey | Minnesota | 27123 | 153 | 7 |
54991 | 54991 | 2020-04-13 | Ramsey | Minnesota | 27123 | 152 | 6 |
52309 | 52309 | 2020-04-12 | Ramsey | Minnesota | 27123 | 152 | 6 |
49639 | 49639 | 2020-04-11 | Ramsey | Minnesota | 27123 | 132 | 6 |
46994 | 46994 | 2020-04-10 | Ramsey | Minnesota | 27123 | 124 | 5 |
44384 | 44384 | 2020-04-09 | Ramsey | Minnesota | 27123 | 121 | 5 |
41808 | 41808 | 2020-04-08 | Ramsey | Minnesota | 27123 | 112 | 3 |
39254 | 39254 | 2020-04-07 | Ramsey | Minnesota | 27123 | 101 | 3 |
36745 | 36745 | 2020-04-06 | Ramsey | Minnesota | 27123 | 96 | 3 |
34284 | 34284 | 2020-04-05 | Ramsey | Minnesota | 27123 | 91 | 2 |
31857 | 31857 | 2020-04-04 | Ramsey | Minnesota | 27123 | 79 | 2 |
29477 | 29477 | 2020-04-03 | Ramsey | Minnesota | 27123 | 71 | 2 |
27158 | 27158 | 2020-04-02 | Ramsey | Minnesota | 27123 | 67 | 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);