ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,294 rows where state = "Kansas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 20091 798
- 20209 793
- 20015 792
- 20059 791
- 20045 788
- 20057 788
- 20103 787
- 20021 786
- 20107 786
- 20127 786
- 20173 786
- 20155 785
- 20161 785
- 20085 783
- 20123 783
- 20011 782
- 20111 782
- 20043 781
- 20149 781
- 20207 781
- 20037 780
- 20133 780
- 20177 780
- 20087 779
- 20191 779
- 20027 778
- 20031 778
- 20063 778
- 20079 778
- 20113 778
- …
county >30
- Johnson 798
- Wyandotte 793
- Butler 792
- Franklin 791
- Douglas 788
- Ford 788
- Leavenworth 787
- Cherokee 786
- Linn 786
- Morris 786
- Sedgwick 786
- Reno 785
- Riley 785
- Jackson 783
- Mitchell 783
- Bourbon 782
- Lyon 782
- Doniphan 781
- Pottawatomie 781
- Woodson 781
- Crawford 780
- Neosho 780
- Shawnee 780
- Jefferson 779
- Sumner 779
- Clay 778
- Coffey 778
- Gove 778
- Harvey 778
- McPherson 778
- …
state 1
- Kansas · 79,294 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
241010 | 241010 | 2020-06-15 | Allen | Kansas | 20001 | 1 | 0 |
244121 | 244121 | 2020-06-16 | Allen | Kansas | 20001 | 1 | 0 |
247234 | 247234 | 2020-06-17 | Allen | Kansas | 20001 | 1 | 0 |
250346 | 250346 | 2020-06-18 | Allen | Kansas | 20001 | 1 | 0 |
253461 | 253461 | 2020-06-19 | Allen | Kansas | 20001 | 1 | 0 |
256581 | 256581 | 2020-06-20 | Allen | Kansas | 20001 | 1 | 0 |
259707 | 259707 | 2020-06-21 | Allen | Kansas | 20001 | 1 | 0 |
262834 | 262834 | 2020-06-22 | Allen | Kansas | 20001 | 1 | 0 |
265962 | 265962 | 2020-06-23 | Allen | Kansas | 20001 | 1 | 0 |
269092 | 269092 | 2020-06-24 | Allen | Kansas | 20001 | 1 | 0 |
272229 | 272229 | 2020-06-25 | Allen | Kansas | 20001 | 1 | 0 |
275371 | 275371 | 2020-06-26 | Allen | Kansas | 20001 | 4 | 0 |
278519 | 278519 | 2020-06-27 | Allen | Kansas | 20001 | 4 | 0 |
281667 | 281667 | 2020-06-28 | Allen | Kansas | 20001 | 5 | 0 |
284812 | 284812 | 2020-06-29 | Allen | Kansas | 20001 | 5 | 0 |
287961 | 287961 | 2020-06-30 | Allen | Kansas | 20001 | 5 | 0 |
291111 | 291111 | 2020-07-01 | Allen | Kansas | 20001 | 5 | 0 |
294265 | 294265 | 2020-07-02 | Allen | Kansas | 20001 | 5 | 0 |
297423 | 297423 | 2020-07-03 | Allen | Kansas | 20001 | 5 | 0 |
300585 | 300585 | 2020-07-04 | Allen | Kansas | 20001 | 5 | 0 |
303749 | 303749 | 2020-07-05 | Allen | Kansas | 20001 | 5 | 0 |
306914 | 306914 | 2020-07-06 | Allen | Kansas | 20001 | 5 | 0 |
310082 | 310082 | 2020-07-07 | Allen | Kansas | 20001 | 5 | 0 |
313252 | 313252 | 2020-07-08 | Allen | Kansas | 20001 | 5 | 0 |
316426 | 316426 | 2020-07-09 | Allen | Kansas | 20001 | 5 | 0 |
319599 | 319599 | 2020-07-10 | Allen | Kansas | 20001 | 6 | 0 |
322778 | 322778 | 2020-07-11 | Allen | Kansas | 20001 | 6 | 0 |
325959 | 325959 | 2020-07-12 | Allen | Kansas | 20001 | 6 | 0 |
329145 | 329145 | 2020-07-13 | Allen | Kansas | 20001 | 8 | 0 |
332332 | 332332 | 2020-07-14 | Allen | Kansas | 20001 | 8 | 0 |
335525 | 335525 | 2020-07-15 | Allen | Kansas | 20001 | 8 | 0 |
338721 | 338721 | 2020-07-16 | Allen | Kansas | 20001 | 8 | 0 |
341917 | 341917 | 2020-07-17 | Allen | Kansas | 20001 | 10 | 0 |
345117 | 345117 | 2020-07-18 | Allen | Kansas | 20001 | 10 | 0 |
348318 | 348318 | 2020-07-19 | Allen | Kansas | 20001 | 10 | 0 |
351518 | 351518 | 2020-07-20 | Allen | Kansas | 20001 | 10 | 0 |
354720 | 354720 | 2020-07-21 | Allen | Kansas | 20001 | 11 | 0 |
357922 | 357922 | 2020-07-22 | Allen | Kansas | 20001 | 12 | 0 |
361127 | 361127 | 2020-07-23 | Allen | Kansas | 20001 | 12 | 0 |
364334 | 364334 | 2020-07-24 | Allen | Kansas | 20001 | 12 | 0 |
367541 | 367541 | 2020-07-25 | Allen | Kansas | 20001 | 12 | 0 |
370751 | 370751 | 2020-07-26 | Allen | Kansas | 20001 | 14 | 0 |
373963 | 373963 | 2020-07-27 | Allen | Kansas | 20001 | 14 | 0 |
377178 | 377178 | 2020-07-28 | Allen | Kansas | 20001 | 14 | 0 |
380395 | 380395 | 2020-07-29 | Allen | Kansas | 20001 | 14 | 0 |
383612 | 383612 | 2020-07-30 | Allen | Kansas | 20001 | 14 | 0 |
386830 | 386830 | 2020-07-31 | Allen | Kansas | 20001 | 14 | 0 |
390047 | 390047 | 2020-08-01 | Allen | Kansas | 20001 | 14 | 0 |
393264 | 393264 | 2020-08-02 | Allen | Kansas | 20001 | 14 | 0 |
396480 | 396480 | 2020-08-03 | Allen | Kansas | 20001 | 15 | 0 |
399695 | 399695 | 2020-08-04 | Allen | Kansas | 20001 | 15 | 0 |
402912 | 402912 | 2020-08-05 | Allen | Kansas | 20001 | 16 | 0 |
406130 | 406130 | 2020-08-06 | Allen | Kansas | 20001 | 16 | 0 |
409349 | 409349 | 2020-08-07 | Allen | Kansas | 20001 | 17 | 0 |
412569 | 412569 | 2020-08-08 | Allen | Kansas | 20001 | 17 | 0 |
415789 | 415789 | 2020-08-09 | Allen | Kansas | 20001 | 17 | 0 |
419010 | 419010 | 2020-08-10 | Allen | Kansas | 20001 | 20 | 0 |
422233 | 422233 | 2020-08-11 | Allen | Kansas | 20001 | 20 | 0 |
425454 | 425454 | 2020-08-12 | Allen | Kansas | 20001 | 20 | 0 |
428678 | 428678 | 2020-08-13 | Allen | Kansas | 20001 | 20 | 0 |
431906 | 431906 | 2020-08-14 | Allen | Kansas | 20001 | 22 | 0 |
435131 | 435131 | 2020-08-15 | Allen | Kansas | 20001 | 22 | 0 |
438356 | 438356 | 2020-08-16 | Allen | Kansas | 20001 | 22 | 0 |
441583 | 441583 | 2020-08-17 | Allen | Kansas | 20001 | 23 | 0 |
444809 | 444809 | 2020-08-18 | Allen | Kansas | 20001 | 23 | 0 |
448036 | 448036 | 2020-08-19 | Allen | Kansas | 20001 | 23 | 0 |
451264 | 451264 | 2020-08-20 | Allen | Kansas | 20001 | 23 | 0 |
454492 | 454492 | 2020-08-21 | Allen | Kansas | 20001 | 23 | 0 |
457720 | 457720 | 2020-08-22 | Allen | Kansas | 20001 | 23 | 0 |
460947 | 460947 | 2020-08-23 | Allen | Kansas | 20001 | 23 | 0 |
464176 | 464176 | 2020-08-24 | Allen | Kansas | 20001 | 23 | 0 |
467405 | 467405 | 2020-08-25 | Allen | Kansas | 20001 | 23 | 0 |
470634 | 470634 | 2020-08-26 | Allen | Kansas | 20001 | 23 | 0 |
473866 | 473866 | 2020-08-27 | Allen | Kansas | 20001 | 23 | 0 |
477099 | 477099 | 2020-08-28 | Allen | Kansas | 20001 | 24 | 0 |
480332 | 480332 | 2020-08-29 | Allen | Kansas | 20001 | 24 | 0 |
483566 | 483566 | 2020-08-30 | Allen | Kansas | 20001 | 24 | 0 |
486801 | 486801 | 2020-08-31 | Allen | Kansas | 20001 | 28 | 0 |
490034 | 490034 | 2020-09-01 | Allen | Kansas | 20001 | 28 | 0 |
493267 | 493267 | 2020-09-02 | Allen | Kansas | 20001 | 32 | 0 |
496501 | 496501 | 2020-09-03 | Allen | Kansas | 20001 | 32 | 0 |
499734 | 499734 | 2020-09-04 | Allen | Kansas | 20001 | 31 | 0 |
502968 | 502968 | 2020-09-05 | Allen | Kansas | 20001 | 31 | 0 |
506202 | 506202 | 2020-09-06 | Allen | Kansas | 20001 | 31 | 0 |
509434 | 509434 | 2020-09-07 | Allen | Kansas | 20001 | 34 | 0 |
512667 | 512667 | 2020-09-08 | Allen | Kansas | 20001 | 34 | 0 |
515900 | 515900 | 2020-09-09 | Allen | Kansas | 20001 | 34 | 0 |
519135 | 519135 | 2020-09-10 | Allen | Kansas | 20001 | 34 | 0 |
522372 | 522372 | 2020-09-11 | Allen | Kansas | 20001 | 35 | 0 |
525608 | 525608 | 2020-09-12 | Allen | Kansas | 20001 | 35 | 0 |
528844 | 528844 | 2020-09-13 | Allen | Kansas | 20001 | 35 | 0 |
532081 | 532081 | 2020-09-14 | Allen | Kansas | 20001 | 39 | 0 |
535316 | 535316 | 2020-09-15 | Allen | Kansas | 20001 | 39 | 0 |
538552 | 538552 | 2020-09-16 | Allen | Kansas | 20001 | 42 | 0 |
541789 | 541789 | 2020-09-17 | Allen | Kansas | 20001 | 42 | 0 |
545025 | 545025 | 2020-09-18 | Allen | Kansas | 20001 | 42 | 0 |
548263 | 548263 | 2020-09-19 | Allen | Kansas | 20001 | 42 | 0 |
551502 | 551502 | 2020-09-20 | Allen | Kansas | 20001 | 42 | 0 |
554741 | 554741 | 2020-09-21 | Allen | Kansas | 20001 | 42 | 0 |
557978 | 557978 | 2020-09-22 | Allen | Kansas | 20001 | 57 | 0 |
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);