ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 20091 and state = "Kansas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
241051 | 241051 | 2020-06-15 | Johnson | Kansas | 20091 | 1106 | 72 |
244162 | 244162 | 2020-06-16 | Johnson | Kansas | 20091 | 1106 | 72 |
247275 | 247275 | 2020-06-17 | Johnson | Kansas | 20091 | 1139 | 73 |
250387 | 250387 | 2020-06-18 | Johnson | Kansas | 20091 | 1150 | 76 |
253502 | 253502 | 2020-06-19 | Johnson | Kansas | 20091 | 1229 | 77 |
256622 | 256622 | 2020-06-20 | Johnson | Kansas | 20091 | 1236 | 79 |
259748 | 259748 | 2020-06-21 | Johnson | Kansas | 20091 | 1257 | 80 |
262875 | 262875 | 2020-06-22 | Johnson | Kansas | 20091 | 1310 | 80 |
266003 | 266003 | 2020-06-23 | Johnson | Kansas | 20091 | 1316 | 81 |
269133 | 269133 | 2020-06-24 | Johnson | Kansas | 20091 | 1409 | 81 |
272270 | 272270 | 2020-06-25 | Johnson | Kansas | 20091 | 1427 | 81 |
275413 | 275413 | 2020-06-26 | Johnson | Kansas | 20091 | 1545 | 83 |
278561 | 278561 | 2020-06-27 | Johnson | Kansas | 20091 | 1550 | 85 |
281709 | 281709 | 2020-06-28 | Johnson | Kansas | 20091 | 1613 | 86 |
284854 | 284854 | 2020-06-29 | Johnson | Kansas | 20091 | 1722 | 86 |
288003 | 288003 | 2020-06-30 | Johnson | Kansas | 20091 | 1722 | 86 |
291153 | 291153 | 2020-07-01 | Johnson | Kansas | 20091 | 1870 | 87 |
294307 | 294307 | 2020-07-02 | Johnson | Kansas | 20091 | 1870 | 88 |
297465 | 297465 | 2020-07-03 | Johnson | Kansas | 20091 | 2066 | 88 |
300627 | 300627 | 2020-07-04 | Johnson | Kansas | 20091 | 2111 | 88 |
303791 | 303791 | 2020-07-05 | Johnson | Kansas | 20091 | 2205 | 89 |
306957 | 306957 | 2020-07-06 | Johnson | Kansas | 20091 | 2349 | 90 |
310125 | 310125 | 2020-07-07 | Johnson | Kansas | 20091 | 2356 | 91 |
313295 | 313295 | 2020-07-08 | Johnson | Kansas | 20091 | 2565 | 91 |
316469 | 316469 | 2020-07-09 | Johnson | Kansas | 20091 | 2633 | 92 |
319642 | 319642 | 2020-07-10 | Johnson | Kansas | 20091 | 2804 | 92 |
322821 | 322821 | 2020-07-11 | Johnson | Kansas | 20091 | 2857 | 92 |
326004 | 326004 | 2020-07-12 | Johnson | Kansas | 20091 | 2967 | 93 |
329190 | 329190 | 2020-07-13 | Johnson | Kansas | 20091 | 3160 | 93 |
332377 | 332377 | 2020-07-14 | Johnson | Kansas | 20091 | 3160 | 93 |
335570 | 335570 | 2020-07-15 | Johnson | Kansas | 20091 | 3370 | 94 |
338766 | 338766 | 2020-07-16 | Johnson | Kansas | 20091 | 3422 | 95 |
341962 | 341962 | 2020-07-17 | Johnson | Kansas | 20091 | 3654 | 95 |
345162 | 345162 | 2020-07-18 | Johnson | Kansas | 20091 | 3667 | 96 |
348363 | 348363 | 2020-07-19 | Johnson | Kansas | 20091 | 3744 | 96 |
351563 | 351563 | 2020-07-20 | Johnson | Kansas | 20091 | 3933 | 96 |
354765 | 354765 | 2020-07-21 | Johnson | Kansas | 20091 | 3933 | 95 |
357967 | 357967 | 2020-07-22 | Johnson | Kansas | 20091 | 4158 | 96 |
361172 | 361172 | 2020-07-23 | Johnson | Kansas | 20091 | 4161 | 96 |
364379 | 364379 | 2020-07-24 | Johnson | Kansas | 20091 | 4381 | 92 |
367586 | 367586 | 2020-07-25 | Johnson | Kansas | 20091 | 4387 | 94 |
370796 | 370796 | 2020-07-26 | Johnson | Kansas | 20091 | 4455 | 94 |
374008 | 374008 | 2020-07-27 | Johnson | Kansas | 20091 | 4643 | 94 |
377223 | 377223 | 2020-07-28 | Johnson | Kansas | 20091 | 4643 | 96 |
380440 | 380440 | 2020-07-29 | Johnson | Kansas | 20091 | 4813 | 96 |
383657 | 383657 | 2020-07-30 | Johnson | Kansas | 20091 | 4813 | 98 |
386875 | 386875 | 2020-07-31 | Johnson | Kansas | 20091 | 4995 | 98 |
390092 | 390092 | 2020-08-01 | Johnson | Kansas | 20091 | 5014 | 98 |
393309 | 393309 | 2020-08-02 | Johnson | Kansas | 20091 | 5074 | 98 |
396525 | 396525 | 2020-08-03 | Johnson | Kansas | 20091 | 5252 | 98 |
399740 | 399740 | 2020-08-04 | Johnson | Kansas | 20091 | 5252 | 98 |
402957 | 402957 | 2020-08-05 | Johnson | Kansas | 20091 | 5434 | 98 |
406175 | 406175 | 2020-08-06 | Johnson | Kansas | 20091 | 5439 | 102 |
409394 | 409394 | 2020-08-07 | Johnson | Kansas | 20091 | 5637 | 102 |
412614 | 412614 | 2020-08-08 | Johnson | Kansas | 20091 | 5643 | 103 |
415834 | 415834 | 2020-08-09 | Johnson | Kansas | 20091 | 5703 | 103 |
419055 | 419055 | 2020-08-10 | Johnson | Kansas | 20091 | 5913 | 103 |
422278 | 422278 | 2020-08-11 | Johnson | Kansas | 20091 | 5913 | 105 |
425499 | 425499 | 2020-08-12 | Johnson | Kansas | 20091 | 6120 | 106 |
428723 | 428723 | 2020-08-13 | Johnson | Kansas | 20091 | 6127 | 106 |
431951 | 431951 | 2020-08-14 | Johnson | Kansas | 20091 | 6357 | 106 |
435176 | 435176 | 2020-08-15 | Johnson | Kansas | 20091 | 6383 | 108 |
438401 | 438401 | 2020-08-16 | Johnson | Kansas | 20091 | 6430 | 108 |
441628 | 441628 | 2020-08-17 | Johnson | Kansas | 20091 | 6615 | 108 |
444854 | 444854 | 2020-08-18 | Johnson | Kansas | 20091 | 6615 | 108 |
448081 | 448081 | 2020-08-19 | Johnson | Kansas | 20091 | 6788 | 108 |
451309 | 451309 | 2020-08-20 | Johnson | Kansas | 20091 | 6788 | 110 |
454537 | 454537 | 2020-08-21 | Johnson | Kansas | 20091 | 7058 | 110 |
457765 | 457765 | 2020-08-22 | Johnson | Kansas | 20091 | 7167 | 110 |
460992 | 460992 | 2020-08-23 | Johnson | Kansas | 20091 | 7236 | 110 |
464221 | 464221 | 2020-08-24 | Johnson | Kansas | 20091 | 7418 | 111 |
467450 | 467450 | 2020-08-25 | Johnson | Kansas | 20091 | 7418 | 112 |
470679 | 470679 | 2020-08-26 | Johnson | Kansas | 20091 | 7682 | 116 |
473911 | 473911 | 2020-08-27 | Johnson | Kansas | 20091 | 7682 | 116 |
477144 | 477144 | 2020-08-28 | Johnson | Kansas | 20091 | 7920 | 116 |
480377 | 480377 | 2020-08-29 | Johnson | Kansas | 20091 | 7974 | 116 |
483611 | 483611 | 2020-08-30 | Johnson | Kansas | 20091 | 8050 | 116 |
486846 | 486846 | 2020-08-31 | Johnson | Kansas | 20091 | 8240 | 116 |
490079 | 490079 | 2020-09-01 | Johnson | Kansas | 20091 | 8240 | 117 |
493312 | 493312 | 2020-09-02 | Johnson | Kansas | 20091 | 8495 | 118 |
496546 | 496546 | 2020-09-03 | Johnson | Kansas | 20091 | 8495 | 118 |
499779 | 499779 | 2020-09-04 | Johnson | Kansas | 20091 | 8695 | 120 |
503013 | 503013 | 2020-09-05 | Johnson | Kansas | 20091 | 8695 | 121 |
506247 | 506247 | 2020-09-06 | Johnson | Kansas | 20091 | 8776 | 121 |
509479 | 509479 | 2020-09-07 | Johnson | Kansas | 20091 | 9047 | 121 |
512712 | 512712 | 2020-09-08 | Johnson | Kansas | 20091 | 9047 | 121 |
515945 | 515945 | 2020-09-09 | Johnson | Kansas | 20091 | 9147 | 126 |
519180 | 519180 | 2020-09-10 | Johnson | Kansas | 20091 | 9147 | 128 |
522417 | 522417 | 2020-09-11 | Johnson | Kansas | 20091 | 9350 | 128 |
525653 | 525653 | 2020-09-12 | Johnson | Kansas | 20091 | 9350 | 134 |
528889 | 528889 | 2020-09-13 | Johnson | Kansas | 20091 | 9354 | 134 |
532126 | 532126 | 2020-09-14 | Johnson | Kansas | 20091 | 9687 | 134 |
535361 | 535361 | 2020-09-15 | Johnson | Kansas | 20091 | 9687 | 138 |
538597 | 538597 | 2020-09-16 | Johnson | Kansas | 20091 | 9917 | 138 |
541834 | 541834 | 2020-09-17 | Johnson | Kansas | 20091 | 9917 | 140 |
545070 | 545070 | 2020-09-18 | Johnson | Kansas | 20091 | 10178 | 141 |
548308 | 548308 | 2020-09-19 | Johnson | Kansas | 20091 | 10178 | 141 |
551547 | 551547 | 2020-09-20 | Johnson | Kansas | 20091 | 10178 | 141 |
554786 | 554786 | 2020-09-21 | Johnson | Kansas | 20091 | 10462 | 141 |
558023 | 558023 | 2020-09-22 | Johnson | Kansas | 20091 | 10462 | 143 |
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);