ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20063 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 145 ✖
- 1 98
- 385 54
- 785 52
- 386 39
- 786 28
- 387 24
- 2 21
- 3 19
- 389 18
- 374 14
- 376 12
- 391 12
- 388 11
- 5 7
- 329 7
- 392 7
- 7 5
- 19 5
- 42 5
- 148 5
- 171 5
- 335 5
- 395 5
- 397 5
- 402 5
- 434 5
- 456 5
- 469 5
- 477 5
- 548 5
- 616 5
- 625 5
- 664 5
- 776 5
- 11 4
- 20 4
- 28 4
- 136 4
- 452 4
- 787 4
- 10 3
- 13 3
- 24 3
- 101 3
- 130 3
- 199 3
- 226 3
- 247 3
- 272 3
- 297 3
- 309 3
- 314 3
- 325 3
- 341 3
- 356 3
- 359 3
- 370 3
- 390 3
- 419 3
- 444 3
- 449 3
- 461 3
- 488 3
- 504 3
- 526 3
- 574 3
- 594 3
- 611 3
- 642 3
- 717 3
- 747 3
- 771 3
- 6 2
- 9 2
- 18 2
- 76 2
- 85 2
- 115 2
- 162 2
- 182 2
- 211 2
- 219 2
- 233 2
- 246 2
- 251 2
- 260 2
- 278 2
- 294 2
- 301 2
- 308 2
- 312 2
- 313 2
- 315 2
- 316 2
- 326 2
- 332 2
- 337 2
- 342 2
- 351 2
- 355 2
- 357 2
- 361 2
- 365 2
- 372 2
- 375 2
- 393 2
- 396 2
- 401 2
- 413 2
- 422 2
- 428 2
- 437 2
- 445 2
- 447 2
- 459 2
- 465 2
- 472 2
- 474 2
- 482 2
- 491 2
- 498 2
- 507 2
- 511 2
- 539 2
- 553 2
- 562 2
- 580 2
- 585 2
- 595 2
- 602 2
- 613 2
- 622 2
- 635 2
- 640 2
- 644 2
- 655 2
- 698 2
- 722 2
- 732 2
- 749 2
- 758 2
- 772 2
- 781 2
- 784 2
- 790 1
state 1
- Kansas · 778 ✖
fips 1
- 20063 · 778 ✖
county 1
- Gove 778
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500504 | 2500504 | 2022-05-13 | Gove | Kansas | 20063 | 790 | 23 |
2497246 | 2497246 | 2022-05-12 | Gove | Kansas | 20063 | 786 | 23 |
2493988 | 2493988 | 2022-05-11 | Gove | Kansas | 20063 | 786 | 23 |
2490730 | 2490730 | 2022-05-10 | Gove | Kansas | 20063 | 786 | 23 |
2487473 | 2487473 | 2022-05-09 | Gove | Kansas | 20063 | 786 | 23 |
2484215 | 2484215 | 2022-05-08 | Gove | Kansas | 20063 | 786 | 23 |
2480957 | 2480957 | 2022-05-07 | Gove | Kansas | 20063 | 786 | 23 |
2477699 | 2477699 | 2022-05-06 | Gove | Kansas | 20063 | 786 | 23 |
2474441 | 2474441 | 2022-05-05 | Gove | Kansas | 20063 | 786 | 23 |
2471184 | 2471184 | 2022-05-04 | Gove | Kansas | 20063 | 786 | 23 |
2467928 | 2467928 | 2022-05-03 | Gove | Kansas | 20063 | 786 | 23 |
2464673 | 2464673 | 2022-05-02 | Gove | Kansas | 20063 | 786 | 23 |
2461417 | 2461417 | 2022-05-01 | Gove | Kansas | 20063 | 786 | 23 |
2458161 | 2458161 | 2022-04-30 | Gove | Kansas | 20063 | 786 | 23 |
2454905 | 2454905 | 2022-04-29 | Gove | Kansas | 20063 | 786 | 23 |
2451649 | 2451649 | 2022-04-28 | Gove | Kansas | 20063 | 786 | 23 |
2448393 | 2448393 | 2022-04-27 | Gove | Kansas | 20063 | 786 | 23 |
2445137 | 2445137 | 2022-04-26 | Gove | Kansas | 20063 | 786 | 23 |
2441881 | 2441881 | 2022-04-25 | Gove | Kansas | 20063 | 786 | 23 |
2438625 | 2438625 | 2022-04-24 | Gove | Kansas | 20063 | 786 | 23 |
2435369 | 2435369 | 2022-04-23 | Gove | Kansas | 20063 | 786 | 23 |
2432113 | 2432113 | 2022-04-22 | Gove | Kansas | 20063 | 786 | 23 |
2428857 | 2428857 | 2022-04-21 | Gove | Kansas | 20063 | 786 | 23 |
2425601 | 2425601 | 2022-04-20 | Gove | Kansas | 20063 | 786 | 23 |
2422345 | 2422345 | 2022-04-19 | Gove | Kansas | 20063 | 786 | 23 |
2419089 | 2419089 | 2022-04-18 | Gove | Kansas | 20063 | 786 | 23 |
2415833 | 2415833 | 2022-04-17 | Gove | Kansas | 20063 | 786 | 23 |
2412577 | 2412577 | 2022-04-16 | Gove | Kansas | 20063 | 786 | 23 |
2409321 | 2409321 | 2022-04-15 | Gove | Kansas | 20063 | 786 | 23 |
2406065 | 2406065 | 2022-04-14 | Gove | Kansas | 20063 | 785 | 23 |
2402809 | 2402809 | 2022-04-13 | Gove | Kansas | 20063 | 785 | 23 |
2399555 | 2399555 | 2022-04-12 | Gove | Kansas | 20063 | 785 | 23 |
2396299 | 2396299 | 2022-04-11 | Gove | Kansas | 20063 | 785 | 23 |
2393044 | 2393044 | 2022-04-10 | Gove | Kansas | 20063 | 785 | 23 |
2389788 | 2389788 | 2022-04-09 | Gove | Kansas | 20063 | 785 | 23 |
2386532 | 2386532 | 2022-04-08 | Gove | Kansas | 20063 | 785 | 23 |
2383278 | 2383278 | 2022-04-07 | Gove | Kansas | 20063 | 785 | 23 |
2380023 | 2380023 | 2022-04-06 | Gove | Kansas | 20063 | 785 | 23 |
2376768 | 2376768 | 2022-04-05 | Gove | Kansas | 20063 | 785 | 23 |
2373516 | 2373516 | 2022-04-04 | Gove | Kansas | 20063 | 785 | 23 |
2370263 | 2370263 | 2022-04-03 | Gove | Kansas | 20063 | 785 | 23 |
2367010 | 2367010 | 2022-04-02 | Gove | Kansas | 20063 | 785 | 23 |
2363757 | 2363757 | 2022-04-01 | Gove | Kansas | 20063 | 785 | 23 |
2360503 | 2360503 | 2022-03-31 | Gove | Kansas | 20063 | 785 | 23 |
2357249 | 2357249 | 2022-03-30 | Gove | Kansas | 20063 | 785 | 23 |
2353996 | 2353996 | 2022-03-29 | Gove | Kansas | 20063 | 785 | 23 |
2350744 | 2350744 | 2022-03-28 | Gove | Kansas | 20063 | 785 | 23 |
2347491 | 2347491 | 2022-03-27 | Gove | Kansas | 20063 | 785 | 23 |
2344238 | 2344238 | 2022-03-26 | Gove | Kansas | 20063 | 785 | 23 |
2340985 | 2340985 | 2022-03-25 | Gove | Kansas | 20063 | 785 | 23 |
2337732 | 2337732 | 2022-03-24 | Gove | Kansas | 20063 | 785 | 23 |
2334478 | 2334478 | 2022-03-23 | Gove | Kansas | 20063 | 785 | 23 |
2331224 | 2331224 | 2022-03-22 | Gove | Kansas | 20063 | 785 | 23 |
2327972 | 2327972 | 2022-03-21 | Gove | Kansas | 20063 | 785 | 23 |
2324719 | 2324719 | 2022-03-20 | Gove | Kansas | 20063 | 785 | 23 |
2321465 | 2321465 | 2022-03-19 | Gove | Kansas | 20063 | 785 | 23 |
2318211 | 2318211 | 2022-03-18 | Gove | Kansas | 20063 | 785 | 23 |
2314958 | 2314958 | 2022-03-17 | Gove | Kansas | 20063 | 785 | 23 |
2311705 | 2311705 | 2022-03-16 | Gove | Kansas | 20063 | 785 | 23 |
2308452 | 2308452 | 2022-03-15 | Gove | Kansas | 20063 | 785 | 23 |
2305201 | 2305201 | 2022-03-14 | Gove | Kansas | 20063 | 785 | 23 |
2301949 | 2301949 | 2022-03-13 | Gove | Kansas | 20063 | 785 | 23 |
2298697 | 2298697 | 2022-03-12 | Gove | Kansas | 20063 | 785 | 23 |
2295445 | 2295445 | 2022-03-11 | Gove | Kansas | 20063 | 785 | 23 |
2292193 | 2292193 | 2022-03-10 | Gove | Kansas | 20063 | 785 | 23 |
2288941 | 2288941 | 2022-03-09 | Gove | Kansas | 20063 | 785 | 23 |
2285690 | 2285690 | 2022-03-08 | Gove | Kansas | 20063 | 785 | 23 |
2282438 | 2282438 | 2022-03-07 | Gove | Kansas | 20063 | 785 | 23 |
2279185 | 2279185 | 2022-03-06 | Gove | Kansas | 20063 | 785 | 23 |
2275932 | 2275932 | 2022-03-05 | Gove | Kansas | 20063 | 785 | 23 |
2272679 | 2272679 | 2022-03-04 | Gove | Kansas | 20063 | 785 | 23 |
2269427 | 2269427 | 2022-03-03 | Gove | Kansas | 20063 | 785 | 23 |
2266174 | 2266174 | 2022-03-02 | Gove | Kansas | 20063 | 785 | 23 |
2262923 | 2262923 | 2022-03-01 | Gove | Kansas | 20063 | 785 | 23 |
2259672 | 2259672 | 2022-02-28 | Gove | Kansas | 20063 | 785 | 23 |
2256421 | 2256421 | 2022-02-27 | Gove | Kansas | 20063 | 785 | 23 |
2253170 | 2253170 | 2022-02-26 | Gove | Kansas | 20063 | 785 | 23 |
2249919 | 2249919 | 2022-02-25 | Gove | Kansas | 20063 | 785 | 23 |
2246668 | 2246668 | 2022-02-24 | Gove | Kansas | 20063 | 787 | 23 |
2243417 | 2243417 | 2022-02-23 | Gove | Kansas | 20063 | 787 | 23 |
2240166 | 2240166 | 2022-02-22 | Gove | Kansas | 20063 | 787 | 23 |
2236915 | 2236915 | 2022-02-21 | Gove | Kansas | 20063 | 787 | 23 |
2233664 | 2233664 | 2022-02-20 | Gove | Kansas | 20063 | 785 | 23 |
2230413 | 2230413 | 2022-02-19 | Gove | Kansas | 20063 | 785 | 23 |
2227162 | 2227162 | 2022-02-18 | Gove | Kansas | 20063 | 785 | 23 |
2223911 | 2223911 | 2022-02-17 | Gove | Kansas | 20063 | 784 | 23 |
2220660 | 2220660 | 2022-02-16 | Gove | Kansas | 20063 | 784 | 23 |
2217409 | 2217409 | 2022-02-15 | Gove | Kansas | 20063 | 781 | 23 |
2214158 | 2214158 | 2022-02-14 | Gove | Kansas | 20063 | 781 | 23 |
2210906 | 2210906 | 2022-02-13 | Gove | Kansas | 20063 | 776 | 23 |
2207653 | 2207653 | 2022-02-12 | Gove | Kansas | 20063 | 776 | 23 |
2204400 | 2204400 | 2022-02-11 | Gove | Kansas | 20063 | 776 | 23 |
2201147 | 2201147 | 2022-02-10 | Gove | Kansas | 20063 | 776 | 23 |
2197893 | 2197893 | 2022-02-09 | Gove | Kansas | 20063 | 776 | 23 |
2194639 | 2194639 | 2022-02-08 | Gove | Kansas | 20063 | 772 | 23 |
2191385 | 2191385 | 2022-02-07 | Gove | Kansas | 20063 | 772 | 23 |
2188132 | 2188132 | 2022-02-06 | Gove | Kansas | 20063 | 771 | 23 |
2184879 | 2184879 | 2022-02-05 | Gove | Kansas | 20063 | 771 | 23 |
2181627 | 2181627 | 2022-02-04 | Gove | Kansas | 20063 | 771 | 23 |
2178376 | 2178376 | 2022-02-03 | Gove | Kansas | 20063 | 758 | 23 |
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);