ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,335 rows where county = "Perkins" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 351 ✖
- 359 87
- 284 70
- 278 46
- 682 41
- 530 36
- 6 26
- 353 20
- 293 16
- 348 16
- 418 16
- 680 16
- 683 14
- 360 13
- 4 12
- 34 12
- 33 11
- 264 11
- 351 11
- 518 11
- 256 10
- 261 10
- 285 10
- 330 10
- 367 10
- 517 10
- 24 9
- 279 9
- 355 9
- 362 9
- 532 9
- 677 9
- 321 8
- 338 8
- 339 8
- 408 8
- 417 8
- 29 7
- 32 7
- 36 7
- 257 7
- 273 7
- 288 7
- 289 7
- 352 7
- 358 7
- 389 7
- 395 7
- 540 7
- 8 6
- 19 6
- 31 6
- 255 6
- 294 6
- 436 6
- 541 6
- 1 5
- 17 5
- 28 5
- 30 5
- 40 5
- 52 5
- 274 5
- 344 5
- 370 5
- 373 5
- 374 5
- 377 5
- 397 5
- 421 5
- 460 5
- 509 5
- 529 5
- 539 5
- 548 5
- 555 5
- 27 4
- 37 4
- 44 4
- 47 4
- 230 4
- 247 4
- 271 4
- 275 4
- 282 4
- 328 4
- 347 4
- 371 4
- 384 4
- 415 4
- 419 4
- 513 4
- 536 4
- 564 4
- 676 4
- 9 3
- 16 3
- 18 3
- 23 3
- 25 3
- 42 3
- 43 3
- 56 3
- 74 3
- 80 3
- 103 3
- 136 3
- 179 3
- 193 3
- 201 3
- 217 3
- 232 3
- 243 3
- 263 3
- 283 3
- 323 3
- 325 3
- 329 3
- 354 3
- 405 3
- 429 3
- 430 3
- 445 3
- 447 3
- 476 3
- 486 3
- 494 3
- 521 3
- 527 3
- 531 3
- 596 3
- 645 3
- 670 3
- 679 3
- 684 3
- 10 2
- 13 2
- 14 2
- 15 2
- 21 2
- 39 2
- 41 2
- 45 2
- 51 2
- 54 2
- 59 2
- 82 2
- 84 2
- 99 2
- 100 2
- 108 2
- 119 2
- 142 2
- 187 2
- 208 2
- 210 2
- 228 2
- 238 2
- 244 2
- 251 2
- 253 2
- 258 2
- 259 2
- 262 2
- 270 2
- 280 2
- 281 2
- 307 2
- 315 2
- 319 2
- 331 2
- 343 2
- 345 2
- 349 2
- 357 2
- 366 2
- 368 2
- 375 2
- 376 2
- 386 2
- 402 2
- 411 2
- 412 2
- 422 2
- 424 2
- 439 2
- 478 2
- 496 2
- 538 2
- 553 2
- 561 2
- 669 2
- 3 1
- 7 1
- 11 1
- 12 1
- 22 1
- 38 1
- 46 1
- 48 1
- 57 1
- 58 1
- 60 1
- 61 1
- 62 1
- 64 1
- 67 1
- 69 1
- 71 1
- 73 1
- 78 1
- 81 1
- 85 1
- 86 1
- 88 1
- 91 1
- 94 1
- 97 1
- 98 1
- 101 1
- 104 1
- 109 1
- 113 1
- 114 1
- 118 1
- 120 1
- 126 1
- 127 1
- 128 1
- 129 1
- 134 1
- 137 1
- 139 1
- 149 1
- 153 1
- 160 1
- 161 1
- 163 1
- 170 1
- 171 1
- 172 1
- 174 1
- 177 1
- 186 1
- 188 1
- 191 1
- 195 1
- 197 1
- 199 1
- 204 1
- 205 1
- 206 1
- 207 1
- 213 1
- 214 1
- 215 1
- 216 1
- 218 1
- 224 1
- 229 1
- 231 1
- 233 1
- 236 1
- 237 1
- 250 1
- 254 1
- 265 1
- 268 1
- 269 1
- 286 1
- 287 1
- 290 1
- 291 1
- 292 1
- 298 1
- 299 1
- 301 1
- 302 1
- 303 1
- 310 1
- 311 1
- 317 1
- 320 1
- 324 1
- 332 1
- 333 1
- 340 1
- 341 1
- 342 1
- 346 1
- 356 1
- 361 1
- 365 1
- 379 1
- 382 1
- 385 1
- 387 1
- 392 1
- 393 1
- 394 1
- 399 1
- 403 1
- 410 1
- 416 1
- 427 1
- 432 1
- 433 1
- 435 1
- 437 1
- 438 1
- 443 1
- 444 1
- 449 1
- 454 1
- 455 1
- 459 1
- 462 1
- 463 1
- 467 1
- 471 1
- 475 1
- 483 1
- 487 1
- 490 1
- 491 1
- 493 1
- 506 1
- 511 1
- 512 1
- 515 1
- 516 1
- 528 1
- 534 1
- 535 1
- 545 1
- 547 1
- 557 1
- 566 1
- 573 1
- 582 1
- 607 1
- 624 1
- 632 1
- 643 1
- 652 1
- 661 1
- 666 1
- 671 1
- 674 1
- 675 1
- 678 1
- 681 1
state 2
- South Dakota 672
- Nebraska 663
county 1
- Perkins · 1,335 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501316 | 2501316 | 2022-05-13 | Perkins | Nebraska | 31135 | 527 | 12 |
2502097 | 2502097 | 2022-05-13 | Perkins | South Dakota | 46105 | 684 | 18 |
2498058 | 2498058 | 2022-05-12 | Perkins | Nebraska | 31135 | 527 | 12 |
2498839 | 2498839 | 2022-05-12 | Perkins | South Dakota | 46105 | 684 | 18 |
2494800 | 2494800 | 2022-05-11 | Perkins | Nebraska | 31135 | 527 | 12 |
2495581 | 2495581 | 2022-05-11 | Perkins | South Dakota | 46105 | 684 | 18 |
2491542 | 2491542 | 2022-05-10 | Perkins | Nebraska | 31135 | 541 | 12 |
2492323 | 2492323 | 2022-05-10 | Perkins | South Dakota | 46105 | 683 | 18 |
2488284 | 2488284 | 2022-05-09 | Perkins | Nebraska | 31135 | 541 | 12 |
2489065 | 2489065 | 2022-05-09 | Perkins | South Dakota | 46105 | 683 | 18 |
2485027 | 2485027 | 2022-05-08 | Perkins | Nebraska | 31135 | 541 | 12 |
2485808 | 2485808 | 2022-05-08 | Perkins | South Dakota | 46105 | 683 | 18 |
2481769 | 2481769 | 2022-05-07 | Perkins | Nebraska | 31135 | 541 | 12 |
2482550 | 2482550 | 2022-05-07 | Perkins | South Dakota | 46105 | 683 | 18 |
2478511 | 2478511 | 2022-05-06 | Perkins | Nebraska | 31135 | 541 | 12 |
2479292 | 2479292 | 2022-05-06 | Perkins | South Dakota | 46105 | 683 | 18 |
2475253 | 2475253 | 2022-05-05 | Perkins | Nebraska | 31135 | 541 | 12 |
2476034 | 2476034 | 2022-05-05 | Perkins | South Dakota | 46105 | 683 | 18 |
2471996 | 2471996 | 2022-05-04 | Perkins | Nebraska | 31135 | 539 | 12 |
2472777 | 2472777 | 2022-05-04 | Perkins | South Dakota | 46105 | 683 | 18 |
2468740 | 2468740 | 2022-05-03 | Perkins | Nebraska | 31135 | 538 | 12 |
2469521 | 2469521 | 2022-05-03 | Perkins | South Dakota | 46105 | 683 | 18 |
2465484 | 2465484 | 2022-05-02 | Perkins | Nebraska | 31135 | 540 | 12 |
2466265 | 2466265 | 2022-05-02 | Perkins | South Dakota | 46105 | 683 | 18 |
2462229 | 2462229 | 2022-05-01 | Perkins | Nebraska | 31135 | 539 | 12 |
2463010 | 2463010 | 2022-05-01 | Perkins | South Dakota | 46105 | 683 | 18 |
2458973 | 2458973 | 2022-04-30 | Perkins | Nebraska | 31135 | 539 | 12 |
2459754 | 2459754 | 2022-04-30 | Perkins | South Dakota | 46105 | 683 | 18 |
2455717 | 2455717 | 2022-04-29 | Perkins | Nebraska | 31135 | 539 | 12 |
2456498 | 2456498 | 2022-04-29 | Perkins | South Dakota | 46105 | 683 | 18 |
2452461 | 2452461 | 2022-04-28 | Perkins | Nebraska | 31135 | 540 | 12 |
2453242 | 2453242 | 2022-04-28 | Perkins | South Dakota | 46105 | 683 | 18 |
2449205 | 2449205 | 2022-04-27 | Perkins | Nebraska | 31135 | 540 | 12 |
2449986 | 2449986 | 2022-04-27 | Perkins | South Dakota | 46105 | 683 | 18 |
2445948 | 2445948 | 2022-04-26 | Perkins | Nebraska | 31135 | 539 | 12 |
2446729 | 2446729 | 2022-04-26 | Perkins | South Dakota | 46105 | 682 | 18 |
2442693 | 2442693 | 2022-04-25 | Perkins | Nebraska | 31135 | 540 | 12 |
2443474 | 2443474 | 2022-04-25 | Perkins | South Dakota | 46105 | 682 | 18 |
2439437 | 2439437 | 2022-04-24 | Perkins | Nebraska | 31135 | 540 | 12 |
2440218 | 2440218 | 2022-04-24 | Perkins | South Dakota | 46105 | 682 | 18 |
2436181 | 2436181 | 2022-04-23 | Perkins | Nebraska | 31135 | 540 | 12 |
2436962 | 2436962 | 2022-04-23 | Perkins | South Dakota | 46105 | 682 | 18 |
2432925 | 2432925 | 2022-04-22 | Perkins | Nebraska | 31135 | 540 | 12 |
2433706 | 2433706 | 2022-04-22 | Perkins | South Dakota | 46105 | 682 | 18 |
2429669 | 2429669 | 2022-04-21 | Perkins | Nebraska | 31135 | 532 | 12 |
2430450 | 2430450 | 2022-04-21 | Perkins | South Dakota | 46105 | 682 | 18 |
2426413 | 2426413 | 2022-04-20 | Perkins | Nebraska | 31135 | 532 | 12 |
2427194 | 2427194 | 2022-04-20 | Perkins | South Dakota | 46105 | 682 | 18 |
2423157 | 2423157 | 2022-04-19 | Perkins | Nebraska | 31135 | 532 | 12 |
2423938 | 2423938 | 2022-04-19 | Perkins | South Dakota | 46105 | 682 | 18 |
2419900 | 2419900 | 2022-04-18 | Perkins | Nebraska | 31135 | 532 | 12 |
2420682 | 2420682 | 2022-04-18 | Perkins | South Dakota | 46105 | 682 | 18 |
2416645 | 2416645 | 2022-04-17 | Perkins | Nebraska | 31135 | 532 | 12 |
2417426 | 2417426 | 2022-04-17 | Perkins | South Dakota | 46105 | 682 | 18 |
2413389 | 2413389 | 2022-04-16 | Perkins | Nebraska | 31135 | 532 | 12 |
2414170 | 2414170 | 2022-04-16 | Perkins | South Dakota | 46105 | 682 | 18 |
2410133 | 2410133 | 2022-04-15 | Perkins | Nebraska | 31135 | 532 | 12 |
2410914 | 2410914 | 2022-04-15 | Perkins | South Dakota | 46105 | 682 | 18 |
2406877 | 2406877 | 2022-04-14 | Perkins | Nebraska | 31135 | 532 | 12 |
2407658 | 2407658 | 2022-04-14 | Perkins | South Dakota | 46105 | 682 | 18 |
2403621 | 2403621 | 2022-04-13 | Perkins | Nebraska | 31135 | 532 | 12 |
2404402 | 2404402 | 2022-04-13 | Perkins | South Dakota | 46105 | 682 | 18 |
2400366 | 2400366 | 2022-04-12 | Perkins | Nebraska | 31135 | 530 | 12 |
2401147 | 2401147 | 2022-04-12 | Perkins | South Dakota | 46105 | 682 | 18 |
2397111 | 2397111 | 2022-04-11 | Perkins | Nebraska | 31135 | 530 | 12 |
2397892 | 2397892 | 2022-04-11 | Perkins | South Dakota | 46105 | 682 | 18 |
2393856 | 2393856 | 2022-04-10 | Perkins | Nebraska | 31135 | 530 | 12 |
2394637 | 2394637 | 2022-04-10 | Perkins | South Dakota | 46105 | 682 | 18 |
2390600 | 2390600 | 2022-04-09 | Perkins | Nebraska | 31135 | 530 | 12 |
2391381 | 2391381 | 2022-04-09 | Perkins | South Dakota | 46105 | 682 | 18 |
2387344 | 2387344 | 2022-04-08 | Perkins | Nebraska | 31135 | 530 | 12 |
2388125 | 2388125 | 2022-04-08 | Perkins | South Dakota | 46105 | 682 | 18 |
2384089 | 2384089 | 2022-04-07 | Perkins | Nebraska | 31135 | 530 | 12 |
2384870 | 2384870 | 2022-04-07 | Perkins | South Dakota | 46105 | 682 | 18 |
2380834 | 2380834 | 2022-04-06 | Perkins | Nebraska | 31135 | 530 | 12 |
2381615 | 2381615 | 2022-04-06 | Perkins | South Dakota | 46105 | 682 | 18 |
2377579 | 2377579 | 2022-04-05 | Perkins | Nebraska | 31135 | 530 | 12 |
2378360 | 2378360 | 2022-04-05 | Perkins | South Dakota | 46105 | 682 | 18 |
2374326 | 2374326 | 2022-04-04 | Perkins | Nebraska | 31135 | 530 | 12 |
2375106 | 2375106 | 2022-04-04 | Perkins | South Dakota | 46105 | 682 | 18 |
2371074 | 2371074 | 2022-04-03 | Perkins | Nebraska | 31135 | 530 | 12 |
2371854 | 2371854 | 2022-04-03 | Perkins | South Dakota | 46105 | 682 | 18 |
2367821 | 2367821 | 2022-04-02 | Perkins | Nebraska | 31135 | 530 | 12 |
2368601 | 2368601 | 2022-04-02 | Perkins | South Dakota | 46105 | 682 | 18 |
2364568 | 2364568 | 2022-04-01 | Perkins | Nebraska | 31135 | 530 | 12 |
2365348 | 2365348 | 2022-04-01 | Perkins | South Dakota | 46105 | 682 | 18 |
2361314 | 2361314 | 2022-03-31 | Perkins | Nebraska | 31135 | 530 | 12 |
2362095 | 2362095 | 2022-03-31 | Perkins | South Dakota | 46105 | 682 | 18 |
2358060 | 2358060 | 2022-03-30 | Perkins | Nebraska | 31135 | 530 | 12 |
2358841 | 2358841 | 2022-03-30 | Perkins | South Dakota | 46105 | 682 | 18 |
2354807 | 2354807 | 2022-03-29 | Perkins | Nebraska | 31135 | 530 | 12 |
2355587 | 2355587 | 2022-03-29 | Perkins | South Dakota | 46105 | 682 | 18 |
2351554 | 2351554 | 2022-03-28 | Perkins | Nebraska | 31135 | 530 | 12 |
2352334 | 2352334 | 2022-03-28 | Perkins | South Dakota | 46105 | 682 | 18 |
2348302 | 2348302 | 2022-03-27 | Perkins | Nebraska | 31135 | 530 | 12 |
2349082 | 2349082 | 2022-03-27 | Perkins | South Dakota | 46105 | 682 | 18 |
2345049 | 2345049 | 2022-03-26 | Perkins | Nebraska | 31135 | 530 | 12 |
2345829 | 2345829 | 2022-03-26 | Perkins | South Dakota | 46105 | 682 | 18 |
2341796 | 2341796 | 2022-03-25 | Perkins | Nebraska | 31135 | 530 | 12 |
2342576 | 2342576 | 2022-03-25 | Perkins | South Dakota | 46105 | 682 | 18 |
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);