ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Sedgwick" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054487 | 1054487 | 2021-02-22 | Sedgwick | Kansas | 20173 | 53235 | 483 |
1051240 | 1051240 | 2021-02-21 | Sedgwick | Kansas | 20173 | 53047 | 483 |
1047993 | 1047993 | 2021-02-20 | Sedgwick | Kansas | 20173 | 53047 | 483 |
1044748 | 1044748 | 2021-02-19 | Sedgwick | Kansas | 20173 | 53047 | 483 |
1041503 | 1041503 | 2021-02-18 | Sedgwick | Kansas | 20173 | 52832 | 483 |
1038258 | 1038258 | 2021-02-17 | Sedgwick | Kansas | 20173 | 52832 | 454 |
1035013 | 1035013 | 2021-02-16 | Sedgwick | Kansas | 20173 | 52633 | 454 |
1031767 | 1031767 | 2021-02-15 | Sedgwick | Kansas | 20173 | 52633 | 445 |
1028520 | 1028520 | 2021-02-14 | Sedgwick | Kansas | 20173 | 52423 | 445 |
1025275 | 1025275 | 2021-02-13 | Sedgwick | Kansas | 20173 | 52423 | 445 |
1022030 | 1022030 | 2021-02-12 | Sedgwick | Kansas | 20173 | 52423 | 445 |
1018785 | 1018785 | 2021-02-11 | Sedgwick | Kansas | 20173 | 52198 | 445 |
1015540 | 1015540 | 2021-02-10 | Sedgwick | Kansas | 20173 | 52198 | 423 |
1012295 | 1012295 | 2021-02-09 | Sedgwick | Kansas | 20173 | 51836 | 423 |
1009049 | 1009049 | 2021-02-08 | Sedgwick | Kansas | 20173 | 51836 | 393 |
1005803 | 1005803 | 2021-02-07 | Sedgwick | Kansas | 20173 | 51518 | 393 |
1002557 | 1002557 | 2021-02-06 | Sedgwick | Kansas | 20173 | 51518 | 393 |
999311 | 999311 | 2021-02-05 | Sedgwick | Kansas | 20173 | 51518 | 393 |
996065 | 996065 | 2021-02-04 | Sedgwick | Kansas | 20173 | 50800 | 393 |
992819 | 992819 | 2021-02-03 | Sedgwick | Kansas | 20173 | 50800 | 383 |
989573 | 989573 | 2021-02-02 | Sedgwick | Kansas | 20173 | 50270 | 383 |
986326 | 986326 | 2021-02-01 | Sedgwick | Kansas | 20173 | 50270 | 375 |
983079 | 983079 | 2021-01-31 | Sedgwick | Kansas | 20173 | 49884 | 375 |
979833 | 979833 | 2021-01-30 | Sedgwick | Kansas | 20173 | 49884 | 375 |
976587 | 976587 | 2021-01-29 | Sedgwick | Kansas | 20173 | 49884 | 375 |
973342 | 973342 | 2021-01-28 | Sedgwick | Kansas | 20173 | 49435 | 375 |
970097 | 970097 | 2021-01-27 | Sedgwick | Kansas | 20173 | 49435 | 362 |
966853 | 966853 | 2021-01-26 | Sedgwick | Kansas | 20173 | 48970 | 362 |
963608 | 963608 | 2021-01-25 | Sedgwick | Kansas | 20173 | 48970 | 352 |
960363 | 960363 | 2021-01-24 | Sedgwick | Kansas | 20173 | 48224 | 352 |
957117 | 957117 | 2021-01-23 | Sedgwick | Kansas | 20173 | 48224 | 352 |
953872 | 953872 | 2021-01-22 | Sedgwick | Kansas | 20173 | 48224 | 352 |
950627 | 950627 | 2021-01-21 | Sedgwick | Kansas | 20173 | 47532 | 352 |
947381 | 947381 | 2021-01-20 | Sedgwick | Kansas | 20173 | 47532 | 345 |
944134 | 944134 | 2021-01-19 | Sedgwick | Kansas | 20173 | 47003 | 345 |
940889 | 940889 | 2021-01-18 | Sedgwick | Kansas | 20173 | 47003 | 340 |
937644 | 937644 | 2021-01-17 | Sedgwick | Kansas | 20173 | 46446 | 340 |
934399 | 934399 | 2021-01-16 | Sedgwick | Kansas | 20173 | 46446 | 340 |
931154 | 931154 | 2021-01-15 | Sedgwick | Kansas | 20173 | 46446 | 340 |
927909 | 927909 | 2021-01-14 | Sedgwick | Kansas | 20173 | 45337 | 340 |
924663 | 924663 | 2021-01-13 | Sedgwick | Kansas | 20173 | 45337 | 329 |
921418 | 921418 | 2021-01-12 | Sedgwick | Kansas | 20173 | 44604 | 329 |
918173 | 918173 | 2021-01-11 | Sedgwick | Kansas | 20173 | 44604 | 309 |
914928 | 914928 | 2021-01-10 | Sedgwick | Kansas | 20173 | 43349 | 309 |
911683 | 911683 | 2021-01-09 | Sedgwick | Kansas | 20173 | 43349 | 309 |
908438 | 908438 | 2021-01-08 | Sedgwick | Kansas | 20173 | 43349 | 309 |
905192 | 905192 | 2021-01-07 | Sedgwick | Kansas | 20173 | 42336 | 309 |
901947 | 901947 | 2021-01-06 | Sedgwick | Kansas | 20173 | 42336 | 291 |
898702 | 898702 | 2021-01-05 | Sedgwick | Kansas | 20173 | 41361 | 291 |
895457 | 895457 | 2021-01-04 | Sedgwick | Kansas | 20173 | 41361 | 282 |
892210 | 892210 | 2021-01-03 | Sedgwick | Kansas | 20173 | 40608 | 282 |
888964 | 888964 | 2021-01-02 | Sedgwick | Kansas | 20173 | 40608 | 282 |
885718 | 885718 | 2021-01-01 | Sedgwick | Kansas | 20173 | 40608 | 282 |
882473 | 882473 | 2020-12-31 | Sedgwick | Kansas | 20173 | 39423 | 282 |
879228 | 879228 | 2020-12-30 | Sedgwick | Kansas | 20173 | 39423 | 266 |
875983 | 875983 | 2020-12-29 | Sedgwick | Kansas | 20173 | 38023 | 266 |
872738 | 872738 | 2020-12-28 | Sedgwick | Kansas | 20173 | 38023 | 256 |
869493 | 869493 | 2020-12-27 | Sedgwick | Kansas | 20173 | 36975 | 256 |
866248 | 866248 | 2020-12-26 | Sedgwick | Kansas | 20173 | 36975 | 256 |
863003 | 863003 | 2020-12-25 | Sedgwick | Kansas | 20173 | 36975 | 256 |
859758 | 859758 | 2020-12-24 | Sedgwick | Kansas | 20173 | 36975 | 256 |
856513 | 856513 | 2020-12-23 | Sedgwick | Kansas | 20173 | 36975 | 251 |
853268 | 853268 | 2020-12-22 | Sedgwick | Kansas | 20173 | 35723 | 251 |
850023 | 850023 | 2020-12-21 | Sedgwick | Kansas | 20173 | 35723 | 236 |
846778 | 846778 | 2020-12-20 | Sedgwick | Kansas | 20173 | 35106 | 236 |
843532 | 843532 | 2020-12-19 | Sedgwick | Kansas | 20173 | 35106 | 236 |
840287 | 840287 | 2020-12-18 | Sedgwick | Kansas | 20173 | 35106 | 236 |
837042 | 837042 | 2020-12-17 | Sedgwick | Kansas | 20173 | 34248 | 236 |
833796 | 833796 | 2020-12-16 | Sedgwick | Kansas | 20173 | 34248 | 220 |
830549 | 830549 | 2020-12-15 | Sedgwick | Kansas | 20173 | 33554 | 220 |
827303 | 827303 | 2020-12-14 | Sedgwick | Kansas | 20173 | 33554 | 199 |
824056 | 824056 | 2020-12-13 | Sedgwick | Kansas | 20173 | 32709 | 199 |
820810 | 820810 | 2020-12-12 | Sedgwick | Kansas | 20173 | 32709 | 199 |
817564 | 817564 | 2020-12-11 | Sedgwick | Kansas | 20173 | 32709 | 199 |
814318 | 814318 | 2020-12-10 | Sedgwick | Kansas | 20173 | 31748 | 199 |
811073 | 811073 | 2020-12-09 | Sedgwick | Kansas | 20173 | 31748 | 193 |
807828 | 807828 | 2020-12-08 | Sedgwick | Kansas | 20173 | 30881 | 193 |
804583 | 804583 | 2020-12-07 | Sedgwick | Kansas | 20173 | 30881 | 172 |
801338 | 801338 | 2020-12-06 | Sedgwick | Kansas | 20173 | 29764 | 172 |
798093 | 798093 | 2020-12-05 | Sedgwick | Kansas | 20173 | 29764 | 172 |
794848 | 794848 | 2020-12-04 | Sedgwick | Kansas | 20173 | 29764 | 172 |
791603 | 791603 | 2020-12-03 | Sedgwick | Kansas | 20173 | 28617 | 172 |
788358 | 788358 | 2020-12-02 | Sedgwick | Kansas | 20173 | 28617 | 172 |
785114 | 785114 | 2020-12-01 | Sedgwick | Kansas | 20173 | 27966 | 150 |
781869 | 781869 | 2020-11-30 | Sedgwick | Kansas | 20173 | 27966 | 150 |
778623 | 778623 | 2020-11-29 | Sedgwick | Kansas | 20173 | 27049 | 150 |
775378 | 775378 | 2020-11-28 | Sedgwick | Kansas | 20173 | 27049 | 150 |
772133 | 772133 | 2020-11-27 | Sedgwick | Kansas | 20173 | 27049 | 150 |
768888 | 768888 | 2020-11-26 | Sedgwick | Kansas | 20173 | 26095 | 149 |
765642 | 765642 | 2020-11-25 | Sedgwick | Kansas | 20173 | 26095 | 149 |
762397 | 762397 | 2020-11-24 | Sedgwick | Kansas | 20173 | 25157 | 149 |
759152 | 759152 | 2020-11-23 | Sedgwick | Kansas | 20173 | 25157 | 149 |
755905 | 755905 | 2020-11-22 | Sedgwick | Kansas | 20173 | 23476 | 149 |
752659 | 752659 | 2020-11-21 | Sedgwick | Kansas | 20173 | 23476 | 149 |
749413 | 749413 | 2020-11-20 | Sedgwick | Kansas | 20173 | 23476 | 141 |
746167 | 746167 | 2020-11-19 | Sedgwick | Kansas | 20173 | 22390 | 141 |
742920 | 742920 | 2020-11-18 | Sedgwick | Kansas | 20173 | 22390 | 141 |
739673 | 739673 | 2020-11-17 | Sedgwick | Kansas | 20173 | 21255 | 140 |
736429 | 736429 | 2020-11-16 | Sedgwick | Kansas | 20173 | 21255 | 140 |
733183 | 733183 | 2020-11-15 | Sedgwick | Kansas | 20173 | 19504 | 140 |
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);