ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 27171 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 194 ✖
- 1 50
- 5 41
- 305 31
- 0 29
- 6 26
- 304 26
- 2 23
- 7 19
- 153 19
- 151 15
- 4 13
- 149 12
- 120 10
- 114 9
- 163 9
- 14 8
- 16 8
- 108 8
- 143 8
- 157 8
- 171 8
- 123 7
- 150 7
- 155 7
- 168 7
- 300 7
- 303 7
- 113 6
- 116 6
- 119 6
- 135 6
- 142 6
- 148 6
- 156 6
- 159 6
- 161 6
- 294 6
- 298 6
- 299 6
- 10 5
- 124 5
- 139 5
- 167 5
- 191 5
- 278 5
- 8 4
- 27 4
- 36 4
- 50 4
- 90 4
- 104 4
- 107 4
- 115 4
- 121 4
- 127 4
- 140 4
- 146 4
- 169 4
- 170 4
- 251 4
- 259 4
- 271 4
- 292 4
- 3 3
- 15 3
- 88 3
- 111 3
- 125 3
- 131 3
- 141 3
- 165 3
- 174 3
- 181 3
- 197 3
- 211 3
- 226 3
- 237 3
- 245 3
- 263 3
- 285 3
- 9 2
- 13 2
- 30 2
- 34 2
- 43 2
- 48 2
- 69 2
- 81 2
- 83 2
- 98 2
- 99 2
- 102 2
- 106 2
- 109 2
- 110 2
- 118 2
- 130 2
- 132 2
- 137 2
- 147 2
- 154 2
- 166 2
- 179 2
- 206 2
- 216 2
- 235 2
- 254 2
- 260 2
- 262 2
- 287 2
- 295 2
- 11 1
- 12 1
- 18 1
- 20 1
- 21 1
- 22 1
- 23 1
- 24 1
- 25 1
- 28 1
- 35 1
- 38 1
- 39 1
- 44 1
- 45 1
- 54 1
- 55 1
- 59 1
- 60 1
- 65 1
- 66 1
- 68 1
- 71 1
- 72 1
- 75 1
- 76 1
- 78 1
- 79 1
- 82 1
- 84 1
- 92 1
- 94 1
- 95 1
- 97 1
- 101 1
- 112 1
- 122 1
- 126 1
- 128 1
- 134 1
- 136 1
- 144 1
- 152 1
- 160 1
- 172 1
- 173 1
- 176 1
- 180 1
- 182 1
- 184 1
- 187 1
- 192 1
- 193 1
- 195 1
- 198 1
- 201 1
- 217 1
- 223 1
- 229 1
- 230 1
- 238 1
- 240 1
- 241 1
- 242 1
- 247 1
- 248 1
- 250 1
- 257 1
- 266 1
- 267 1
- 269 1
- 270 1
- 273 1
- 274 1
- 280 1
- 282 1
- 284 1
- 288 1
- 291 1
- 296 1
- 297 1
- 301 1
- 302 1
state 1
- Minnesota 792
fips 1
- 27171 · 792 ✖
county 1
- Wright 792
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500991 | 2500991 | 2022-05-13 | Wright | Minnesota | 27171 | 37182 | 305 |
2497733 | 2497733 | 2022-05-12 | Wright | Minnesota | 27171 | 37142 | 305 |
2494475 | 2494475 | 2022-05-11 | Wright | Minnesota | 27171 | 37090 | 305 |
2491217 | 2491217 | 2022-05-10 | Wright | Minnesota | 27171 | 37060 | 305 |
2487960 | 2487960 | 2022-05-09 | Wright | Minnesota | 27171 | 36972 | 305 |
2484702 | 2484702 | 2022-05-08 | Wright | Minnesota | 27171 | 36938 | 305 |
2481444 | 2481444 | 2022-05-07 | Wright | Minnesota | 27171 | 36938 | 305 |
2478186 | 2478186 | 2022-05-06 | Wright | Minnesota | 27171 | 36938 | 305 |
2474928 | 2474928 | 2022-05-05 | Wright | Minnesota | 27171 | 36905 | 305 |
2471671 | 2471671 | 2022-05-04 | Wright | Minnesota | 27171 | 36880 | 305 |
2468415 | 2468415 | 2022-05-03 | Wright | Minnesota | 27171 | 36832 | 305 |
2465160 | 2465160 | 2022-05-02 | Wright | Minnesota | 27171 | 36798 | 305 |
2461904 | 2461904 | 2022-05-01 | Wright | Minnesota | 27171 | 36777 | 305 |
2458648 | 2458648 | 2022-04-30 | Wright | Minnesota | 27171 | 36777 | 305 |
2455392 | 2455392 | 2022-04-29 | Wright | Minnesota | 27171 | 36777 | 305 |
2452136 | 2452136 | 2022-04-28 | Wright | Minnesota | 27171 | 36752 | 305 |
2448880 | 2448880 | 2022-04-27 | Wright | Minnesota | 27171 | 36728 | 305 |
2445624 | 2445624 | 2022-04-26 | Wright | Minnesota | 27171 | 36708 | 305 |
2442368 | 2442368 | 2022-04-25 | Wright | Minnesota | 27171 | 36682 | 305 |
2439112 | 2439112 | 2022-04-24 | Wright | Minnesota | 27171 | 36668 | 305 |
2435856 | 2435856 | 2022-04-23 | Wright | Minnesota | 27171 | 36668 | 305 |
2432600 | 2432600 | 2022-04-22 | Wright | Minnesota | 27171 | 36668 | 305 |
2429344 | 2429344 | 2022-04-21 | Wright | Minnesota | 27171 | 36646 | 305 |
2426088 | 2426088 | 2022-04-20 | Wright | Minnesota | 27171 | 36625 | 305 |
2422832 | 2422832 | 2022-04-19 | Wright | Minnesota | 27171 | 36614 | 305 |
2419576 | 2419576 | 2022-04-18 | Wright | Minnesota | 27171 | 36583 | 305 |
2416320 | 2416320 | 2022-04-17 | Wright | Minnesota | 27171 | 36579 | 305 |
2413064 | 2413064 | 2022-04-16 | Wright | Minnesota | 27171 | 36579 | 305 |
2409808 | 2409808 | 2022-04-15 | Wright | Minnesota | 27171 | 36579 | 305 |
2406552 | 2406552 | 2022-04-14 | Wright | Minnesota | 27171 | 36572 | 305 |
2403296 | 2403296 | 2022-04-13 | Wright | Minnesota | 27171 | 36551 | 305 |
2400042 | 2400042 | 2022-04-12 | Wright | Minnesota | 27171 | 36533 | 304 |
2396786 | 2396786 | 2022-04-11 | Wright | Minnesota | 27171 | 36517 | 304 |
2393531 | 2393531 | 2022-04-10 | Wright | Minnesota | 27171 | 36509 | 304 |
2390275 | 2390275 | 2022-04-09 | Wright | Minnesota | 27171 | 36509 | 304 |
2387019 | 2387019 | 2022-04-08 | Wright | Minnesota | 27171 | 36509 | 304 |
2383764 | 2383764 | 2022-04-07 | Wright | Minnesota | 27171 | 36501 | 304 |
2380509 | 2380509 | 2022-04-06 | Wright | Minnesota | 27171 | 36494 | 304 |
2377254 | 2377254 | 2022-04-05 | Wright | Minnesota | 27171 | 36485 | 304 |
2374002 | 2374002 | 2022-04-04 | Wright | Minnesota | 27171 | 36469 | 304 |
2370749 | 2370749 | 2022-04-03 | Wright | Minnesota | 27171 | 36463 | 304 |
2367496 | 2367496 | 2022-04-02 | Wright | Minnesota | 27171 | 36463 | 304 |
2364243 | 2364243 | 2022-04-01 | Wright | Minnesota | 27171 | 36463 | 304 |
2360989 | 2360989 | 2022-03-31 | Wright | Minnesota | 27171 | 36453 | 304 |
2357735 | 2357735 | 2022-03-30 | Wright | Minnesota | 27171 | 36445 | 304 |
2354482 | 2354482 | 2022-03-29 | Wright | Minnesota | 27171 | 36437 | 304 |
2351230 | 2351230 | 2022-03-28 | Wright | Minnesota | 27171 | 36430 | 304 |
2347977 | 2347977 | 2022-03-27 | Wright | Minnesota | 27171 | 36423 | 304 |
2344724 | 2344724 | 2022-03-26 | Wright | Minnesota | 27171 | 36423 | 304 |
2341471 | 2341471 | 2022-03-25 | Wright | Minnesota | 27171 | 36423 | 304 |
2338218 | 2338218 | 2022-03-24 | Wright | Minnesota | 27171 | 36417 | 304 |
2334964 | 2334964 | 2022-03-23 | Wright | Minnesota | 27171 | 36415 | 304 |
2331710 | 2331710 | 2022-03-22 | Wright | Minnesota | 27171 | 36412 | 304 |
2328458 | 2328458 | 2022-03-21 | Wright | Minnesota | 27171 | 36395 | 304 |
2325205 | 2325205 | 2022-03-20 | Wright | Minnesota | 27171 | 36393 | 304 |
2321951 | 2321951 | 2022-03-19 | Wright | Minnesota | 27171 | 36393 | 304 |
2318697 | 2318697 | 2022-03-18 | Wright | Minnesota | 27171 | 36393 | 304 |
2315444 | 2315444 | 2022-03-17 | Wright | Minnesota | 27171 | 36380 | 303 |
2312191 | 2312191 | 2022-03-16 | Wright | Minnesota | 27171 | 36373 | 303 |
2308938 | 2308938 | 2022-03-15 | Wright | Minnesota | 27171 | 36357 | 303 |
2305687 | 2305687 | 2022-03-14 | Wright | Minnesota | 27171 | 36344 | 303 |
2302435 | 2302435 | 2022-03-13 | Wright | Minnesota | 27171 | 36343 | 303 |
2299183 | 2299183 | 2022-03-12 | Wright | Minnesota | 27171 | 36343 | 303 |
2295931 | 2295931 | 2022-03-11 | Wright | Minnesota | 27171 | 36343 | 303 |
2292679 | 2292679 | 2022-03-10 | Wright | Minnesota | 27171 | 36234 | 302 |
2289427 | 2289427 | 2022-03-09 | Wright | Minnesota | 27171 | 36224 | 301 |
2286176 | 2286176 | 2022-03-08 | Wright | Minnesota | 27171 | 36214 | 300 |
2282924 | 2282924 | 2022-03-07 | Wright | Minnesota | 27171 | 36190 | 300 |
2279671 | 2279671 | 2022-03-06 | Wright | Minnesota | 27171 | 36178 | 300 |
2276418 | 2276418 | 2022-03-05 | Wright | Minnesota | 27171 | 36178 | 300 |
2273165 | 2273165 | 2022-03-04 | Wright | Minnesota | 27171 | 36178 | 300 |
2269913 | 2269913 | 2022-03-03 | Wright | Minnesota | 27171 | 36169 | 300 |
2266660 | 2266660 | 2022-03-02 | Wright | Minnesota | 27171 | 36145 | 300 |
2263409 | 2263409 | 2022-03-01 | Wright | Minnesota | 27171 | 36133 | 299 |
2260158 | 2260158 | 2022-02-28 | Wright | Minnesota | 27171 | 36079 | 299 |
2256907 | 2256907 | 2022-02-27 | Wright | Minnesota | 27171 | 36067 | 299 |
2253656 | 2253656 | 2022-02-26 | Wright | Minnesota | 27171 | 36067 | 299 |
2250405 | 2250405 | 2022-02-25 | Wright | Minnesota | 27171 | 36067 | 299 |
2247154 | 2247154 | 2022-02-24 | Wright | Minnesota | 27171 | 36055 | 299 |
2243903 | 2243903 | 2022-02-23 | Wright | Minnesota | 27171 | 36038 | 298 |
2240652 | 2240652 | 2022-02-22 | Wright | Minnesota | 27171 | 35973 | 298 |
2237401 | 2237401 | 2022-02-21 | Wright | Minnesota | 27171 | 35932 | 298 |
2234150 | 2234150 | 2022-02-20 | Wright | Minnesota | 27171 | 35932 | 298 |
2230899 | 2230899 | 2022-02-19 | Wright | Minnesota | 27171 | 35932 | 298 |
2227648 | 2227648 | 2022-02-18 | Wright | Minnesota | 27171 | 35932 | 298 |
2224397 | 2224397 | 2022-02-17 | Wright | Minnesota | 27171 | 35817 | 297 |
2221146 | 2221146 | 2022-02-16 | Wright | Minnesota | 27171 | 35781 | 296 |
2217895 | 2217895 | 2022-02-15 | Wright | Minnesota | 27171 | 35753 | 295 |
2214644 | 2214644 | 2022-02-14 | Wright | Minnesota | 27171 | 35633 | 295 |
2211392 | 2211392 | 2022-02-13 | Wright | Minnesota | 27171 | 35545 | 294 |
2208139 | 2208139 | 2022-02-12 | Wright | Minnesota | 27171 | 35545 | 294 |
2204886 | 2204886 | 2022-02-11 | Wright | Minnesota | 27171 | 35545 | 294 |
2201633 | 2201633 | 2022-02-10 | Wright | Minnesota | 27171 | 35482 | 294 |
2198379 | 2198379 | 2022-02-09 | Wright | Minnesota | 27171 | 35398 | 294 |
2195125 | 2195125 | 2022-02-08 | Wright | Minnesota | 27171 | 35282 | 294 |
2191871 | 2191871 | 2022-02-07 | Wright | Minnesota | 27171 | 35096 | 292 |
2188618 | 2188618 | 2022-02-06 | Wright | Minnesota | 27171 | 34937 | 292 |
2185365 | 2185365 | 2022-02-05 | Wright | Minnesota | 27171 | 34937 | 292 |
2182113 | 2182113 | 2022-02-04 | Wright | Minnesota | 27171 | 34937 | 292 |
2178861 | 2178861 | 2022-02-03 | Wright | Minnesota | 27171 | 34806 | 291 |
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);