ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
684 rows where county = "Rush" and state = "Kansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
284888 | 284888 | 2020-06-29 | Rush | Kansas | 20165 | 1 | 0 |
288037 | 288037 | 2020-06-30 | Rush | Kansas | 20165 | 1 | 0 |
291187 | 291187 | 2020-07-01 | Rush | Kansas | 20165 | 1 | 0 |
294341 | 294341 | 2020-07-02 | Rush | Kansas | 20165 | 1 | 0 |
297499 | 297499 | 2020-07-03 | Rush | Kansas | 20165 | 1 | 0 |
300661 | 300661 | 2020-07-04 | Rush | Kansas | 20165 | 1 | 0 |
303825 | 303825 | 2020-07-05 | Rush | Kansas | 20165 | 1 | 0 |
306992 | 306992 | 2020-07-06 | Rush | Kansas | 20165 | 1 | 0 |
310160 | 310160 | 2020-07-07 | Rush | Kansas | 20165 | 1 | 0 |
313330 | 313330 | 2020-07-08 | Rush | Kansas | 20165 | 2 | 0 |
316504 | 316504 | 2020-07-09 | Rush | Kansas | 20165 | 2 | 0 |
319678 | 319678 | 2020-07-10 | Rush | Kansas | 20165 | 3 | 0 |
322857 | 322857 | 2020-07-11 | Rush | Kansas | 20165 | 3 | 0 |
326040 | 326040 | 2020-07-12 | Rush | Kansas | 20165 | 3 | 0 |
329226 | 329226 | 2020-07-13 | Rush | Kansas | 20165 | 4 | 0 |
332413 | 332413 | 2020-07-14 | Rush | Kansas | 20165 | 4 | 0 |
335606 | 335606 | 2020-07-15 | Rush | Kansas | 20165 | 4 | 0 |
338802 | 338802 | 2020-07-16 | Rush | Kansas | 20165 | 4 | 0 |
341998 | 341998 | 2020-07-17 | Rush | Kansas | 20165 | 4 | 0 |
345198 | 345198 | 2020-07-18 | Rush | Kansas | 20165 | 4 | 0 |
348399 | 348399 | 2020-07-19 | Rush | Kansas | 20165 | 4 | 0 |
351599 | 351599 | 2020-07-20 | Rush | Kansas | 20165 | 4 | 0 |
354801 | 354801 | 2020-07-21 | Rush | Kansas | 20165 | 4 | 0 |
358003 | 358003 | 2020-07-22 | Rush | Kansas | 20165 | 5 | 0 |
361208 | 361208 | 2020-07-23 | Rush | Kansas | 20165 | 5 | 0 |
364415 | 364415 | 2020-07-24 | Rush | Kansas | 20165 | 5 | 0 |
367622 | 367622 | 2020-07-25 | Rush | Kansas | 20165 | 5 | 0 |
370832 | 370832 | 2020-07-26 | Rush | Kansas | 20165 | 5 | 0 |
374044 | 374044 | 2020-07-27 | Rush | Kansas | 20165 | 5 | 0 |
377259 | 377259 | 2020-07-28 | Rush | Kansas | 20165 | 5 | 0 |
380476 | 380476 | 2020-07-29 | Rush | Kansas | 20165 | 5 | 0 |
383693 | 383693 | 2020-07-30 | Rush | Kansas | 20165 | 5 | 0 |
386911 | 386911 | 2020-07-31 | Rush | Kansas | 20165 | 6 | 0 |
390128 | 390128 | 2020-08-01 | Rush | Kansas | 20165 | 6 | 0 |
393345 | 393345 | 2020-08-02 | Rush | Kansas | 20165 | 6 | 0 |
396561 | 396561 | 2020-08-03 | Rush | Kansas | 20165 | 7 | 0 |
399776 | 399776 | 2020-08-04 | Rush | Kansas | 20165 | 7 | 0 |
402993 | 402993 | 2020-08-05 | Rush | Kansas | 20165 | 9 | 0 |
406211 | 406211 | 2020-08-06 | Rush | Kansas | 20165 | 9 | 0 |
409430 | 409430 | 2020-08-07 | Rush | Kansas | 20165 | 9 | 0 |
412650 | 412650 | 2020-08-08 | Rush | Kansas | 20165 | 9 | 0 |
415870 | 415870 | 2020-08-09 | Rush | Kansas | 20165 | 9 | 0 |
419091 | 419091 | 2020-08-10 | Rush | Kansas | 20165 | 9 | 0 |
422314 | 422314 | 2020-08-11 | Rush | Kansas | 20165 | 9 | 0 |
425535 | 425535 | 2020-08-12 | Rush | Kansas | 20165 | 10 | 0 |
428759 | 428759 | 2020-08-13 | Rush | Kansas | 20165 | 10 | 0 |
431987 | 431987 | 2020-08-14 | Rush | Kansas | 20165 | 10 | 0 |
435212 | 435212 | 2020-08-15 | Rush | Kansas | 20165 | 10 | 0 |
438437 | 438437 | 2020-08-16 | Rush | Kansas | 20165 | 10 | 0 |
441664 | 441664 | 2020-08-17 | Rush | Kansas | 20165 | 11 | 0 |
444890 | 444890 | 2020-08-18 | Rush | Kansas | 20165 | 11 | 0 |
448117 | 448117 | 2020-08-19 | Rush | Kansas | 20165 | 13 | 0 |
451345 | 451345 | 2020-08-20 | Rush | Kansas | 20165 | 13 | 0 |
454573 | 454573 | 2020-08-21 | Rush | Kansas | 20165 | 15 | 0 |
457801 | 457801 | 2020-08-22 | Rush | Kansas | 20165 | 15 | 0 |
461028 | 461028 | 2020-08-23 | Rush | Kansas | 20165 | 15 | 0 |
464258 | 464258 | 2020-08-24 | Rush | Kansas | 20165 | 16 | 0 |
467487 | 467487 | 2020-08-25 | Rush | Kansas | 20165 | 16 | 0 |
470716 | 470716 | 2020-08-26 | Rush | Kansas | 20165 | 17 | 0 |
473948 | 473948 | 2020-08-27 | Rush | Kansas | 20165 | 17 | 0 |
477181 | 477181 | 2020-08-28 | Rush | Kansas | 20165 | 18 | 0 |
480414 | 480414 | 2020-08-29 | Rush | Kansas | 20165 | 18 | 0 |
483648 | 483648 | 2020-08-30 | Rush | Kansas | 20165 | 18 | 0 |
486883 | 486883 | 2020-08-31 | Rush | Kansas | 20165 | 20 | 0 |
490116 | 490116 | 2020-09-01 | Rush | Kansas | 20165 | 20 | 0 |
493349 | 493349 | 2020-09-02 | Rush | Kansas | 20165 | 27 | 0 |
496583 | 496583 | 2020-09-03 | Rush | Kansas | 20165 | 27 | 0 |
499816 | 499816 | 2020-09-04 | Rush | Kansas | 20165 | 30 | 0 |
503050 | 503050 | 2020-09-05 | Rush | Kansas | 20165 | 30 | 0 |
506284 | 506284 | 2020-09-06 | Rush | Kansas | 20165 | 30 | 0 |
509516 | 509516 | 2020-09-07 | Rush | Kansas | 20165 | 34 | 0 |
512749 | 512749 | 2020-09-08 | Rush | Kansas | 20165 | 34 | 0 |
515982 | 515982 | 2020-09-09 | Rush | Kansas | 20165 | 35 | 0 |
519217 | 519217 | 2020-09-10 | Rush | Kansas | 20165 | 35 | 0 |
522454 | 522454 | 2020-09-11 | Rush | Kansas | 20165 | 36 | 0 |
525690 | 525690 | 2020-09-12 | Rush | Kansas | 20165 | 36 | 0 |
528926 | 528926 | 2020-09-13 | Rush | Kansas | 20165 | 36 | 0 |
532163 | 532163 | 2020-09-14 | Rush | Kansas | 20165 | 41 | 0 |
535398 | 535398 | 2020-09-15 | Rush | Kansas | 20165 | 41 | 0 |
538634 | 538634 | 2020-09-16 | Rush | Kansas | 20165 | 41 | 0 |
541871 | 541871 | 2020-09-17 | Rush | Kansas | 20165 | 41 | 0 |
545107 | 545107 | 2020-09-18 | Rush | Kansas | 20165 | 43 | 0 |
548345 | 548345 | 2020-09-19 | Rush | Kansas | 20165 | 43 | 0 |
551584 | 551584 | 2020-09-20 | Rush | Kansas | 20165 | 43 | 0 |
554823 | 554823 | 2020-09-21 | Rush | Kansas | 20165 | 50 | 0 |
558060 | 558060 | 2020-09-22 | Rush | Kansas | 20165 | 50 | 0 |
561296 | 561296 | 2020-09-23 | Rush | Kansas | 20165 | 53 | 0 |
564536 | 564536 | 2020-09-24 | Rush | Kansas | 20165 | 53 | 0 |
567776 | 567776 | 2020-09-25 | Rush | Kansas | 20165 | 53 | 0 |
571018 | 571018 | 2020-09-26 | Rush | Kansas | 20165 | 53 | 0 |
574261 | 574261 | 2020-09-27 | Rush | Kansas | 20165 | 53 | 0 |
577503 | 577503 | 2020-09-28 | Rush | Kansas | 20165 | 62 | 0 |
580744 | 580744 | 2020-09-29 | Rush | Kansas | 20165 | 62 | 0 |
583983 | 583983 | 2020-09-30 | Rush | Kansas | 20165 | 66 | 0 |
587223 | 587223 | 2020-10-01 | Rush | Kansas | 20165 | 66 | 0 |
590464 | 590464 | 2020-10-02 | Rush | Kansas | 20165 | 73 | 0 |
593705 | 593705 | 2020-10-03 | Rush | Kansas | 20165 | 73 | 0 |
596947 | 596947 | 2020-10-04 | Rush | Kansas | 20165 | 73 | 0 |
600189 | 600189 | 2020-10-05 | Rush | Kansas | 20165 | 75 | 0 |
603432 | 603432 | 2020-10-06 | Rush | Kansas | 20165 | 75 | 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);