ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Elkhart" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054228 | 1054228 | 2021-02-22 | Elkhart | Indiana | 18039 | 25352 | 428 |
1050981 | 1050981 | 2021-02-21 | Elkhart | Indiana | 18039 | 25331 | 428 |
1047734 | 1047734 | 2021-02-20 | Elkhart | Indiana | 18039 | 25305 | 427 |
1044489 | 1044489 | 2021-02-19 | Elkhart | Indiana | 18039 | 25270 | 426 |
1041244 | 1041244 | 2021-02-18 | Elkhart | Indiana | 18039 | 25244 | 423 |
1037999 | 1037999 | 2021-02-17 | Elkhart | Indiana | 18039 | 25223 | 423 |
1034754 | 1034754 | 2021-02-16 | Elkhart | Indiana | 18039 | 25196 | 422 |
1031508 | 1031508 | 2021-02-15 | Elkhart | Indiana | 18039 | 25183 | 422 |
1028261 | 1028261 | 2021-02-14 | Elkhart | Indiana | 18039 | 25160 | 420 |
1025016 | 1025016 | 2021-02-13 | Elkhart | Indiana | 18039 | 25140 | 419 |
1021771 | 1021771 | 2021-02-12 | Elkhart | Indiana | 18039 | 25118 | 417 |
1018526 | 1018526 | 2021-02-11 | Elkhart | Indiana | 18039 | 25089 | 415 |
1015281 | 1015281 | 2021-02-10 | Elkhart | Indiana | 18039 | 25071 | 415 |
1012036 | 1012036 | 2021-02-09 | Elkhart | Indiana | 18039 | 25046 | 415 |
1008790 | 1008790 | 2021-02-08 | Elkhart | Indiana | 18039 | 25025 | 415 |
1005544 | 1005544 | 2021-02-07 | Elkhart | Indiana | 18039 | 25016 | 413 |
1002298 | 1002298 | 2021-02-06 | Elkhart | Indiana | 18039 | 24980 | 411 |
999052 | 999052 | 2021-02-05 | Elkhart | Indiana | 18039 | 24934 | 409 |
995806 | 995806 | 2021-02-04 | Elkhart | Indiana | 18039 | 24914 | 409 |
992560 | 992560 | 2021-02-03 | Elkhart | Indiana | 18039 | 24881 | 363 |
989314 | 989314 | 2021-02-02 | Elkhart | Indiana | 18039 | 24840 | 362 |
986067 | 986067 | 2021-02-01 | Elkhart | Indiana | 18039 | 24814 | 361 |
982820 | 982820 | 2021-01-31 | Elkhart | Indiana | 18039 | 24783 | 361 |
979574 | 979574 | 2021-01-30 | Elkhart | Indiana | 18039 | 24758 | 360 |
976328 | 976328 | 2021-01-29 | Elkhart | Indiana | 18039 | 24729 | 359 |
973083 | 973083 | 2021-01-28 | Elkhart | Indiana | 18039 | 24689 | 359 |
969838 | 969838 | 2021-01-27 | Elkhart | Indiana | 18039 | 24644 | 359 |
966594 | 966594 | 2021-01-26 | Elkhart | Indiana | 18039 | 24594 | 358 |
963349 | 963349 | 2021-01-25 | Elkhart | Indiana | 18039 | 24576 | 357 |
960104 | 960104 | 2021-01-24 | Elkhart | Indiana | 18039 | 24538 | 357 |
956858 | 956858 | 2021-01-23 | Elkhart | Indiana | 18039 | 24502 | 357 |
953613 | 953613 | 2021-01-22 | Elkhart | Indiana | 18039 | 24452 | 356 |
950368 | 950368 | 2021-01-21 | Elkhart | Indiana | 18039 | 24389 | 355 |
947122 | 947122 | 2021-01-20 | Elkhart | Indiana | 18039 | 24342 | 355 |
943875 | 943875 | 2021-01-19 | Elkhart | Indiana | 18039 | 24271 | 355 |
940630 | 940630 | 2021-01-18 | Elkhart | Indiana | 18039 | 24230 | 353 |
937385 | 937385 | 2021-01-17 | Elkhart | Indiana | 18039 | 24196 | 353 |
934140 | 934140 | 2021-01-16 | Elkhart | Indiana | 18039 | 24154 | 352 |
930895 | 930895 | 2021-01-15 | Elkhart | Indiana | 18039 | 24068 | 350 |
927650 | 927650 | 2021-01-14 | Elkhart | Indiana | 18039 | 23970 | 348 |
924404 | 924404 | 2021-01-13 | Elkhart | Indiana | 18039 | 23882 | 347 |
921159 | 921159 | 2021-01-12 | Elkhart | Indiana | 18039 | 23783 | 346 |
917914 | 917914 | 2021-01-11 | Elkhart | Indiana | 18039 | 23754 | 345 |
914669 | 914669 | 2021-01-10 | Elkhart | Indiana | 18039 | 23709 | 344 |
911424 | 911424 | 2021-01-09 | Elkhart | Indiana | 18039 | 23600 | 344 |
908179 | 908179 | 2021-01-08 | Elkhart | Indiana | 18039 | 23541 | 344 |
904933 | 904933 | 2021-01-07 | Elkhart | Indiana | 18039 | 23405 | 343 |
901688 | 901688 | 2021-01-06 | Elkhart | Indiana | 18039 | 23295 | 341 |
898443 | 898443 | 2021-01-05 | Elkhart | Indiana | 18039 | 23157 | 339 |
895198 | 895198 | 2021-01-04 | Elkhart | Indiana | 18039 | 23112 | 331 |
891951 | 891951 | 2021-01-03 | Elkhart | Indiana | 18039 | 23020 | 330 |
888705 | 888705 | 2021-01-02 | Elkhart | Indiana | 18039 | 22984 | 328 |
885459 | 885459 | 2021-01-01 | Elkhart | Indiana | 18039 | 22888 | 328 |
882214 | 882214 | 2020-12-31 | Elkhart | Indiana | 18039 | 22743 | 325 |
878969 | 878969 | 2020-12-30 | Elkhart | Indiana | 18039 | 22617 | 323 |
875724 | 875724 | 2020-12-29 | Elkhart | Indiana | 18039 | 22519 | 320 |
872479 | 872479 | 2020-12-28 | Elkhart | Indiana | 18039 | 22476 | 319 |
869234 | 869234 | 2020-12-27 | Elkhart | Indiana | 18039 | 22396 | 315 |
865989 | 865989 | 2020-12-26 | Elkhart | Indiana | 18039 | 22383 | 315 |
862744 | 862744 | 2020-12-25 | Elkhart | Indiana | 18039 | 22317 | 315 |
859499 | 859499 | 2020-12-24 | Elkhart | Indiana | 18039 | 22205 | 312 |
856254 | 856254 | 2020-12-23 | Elkhart | Indiana | 18039 | 22075 | 309 |
853009 | 853009 | 2020-12-22 | Elkhart | Indiana | 18039 | 21936 | 308 |
849764 | 849764 | 2020-12-21 | Elkhart | Indiana | 18039 | 21888 | 306 |
846519 | 846519 | 2020-12-20 | Elkhart | Indiana | 18039 | 21799 | 304 |
843273 | 843273 | 2020-12-19 | Elkhart | Indiana | 18039 | 21645 | 303 |
840028 | 840028 | 2020-12-18 | Elkhart | Indiana | 18039 | 21533 | 301 |
836783 | 836783 | 2020-12-17 | Elkhart | Indiana | 18039 | 21385 | 297 |
833537 | 833537 | 2020-12-16 | Elkhart | Indiana | 18039 | 21238 | 292 |
830290 | 830290 | 2020-12-15 | Elkhart | Indiana | 18039 | 21089 | 292 |
827044 | 827044 | 2020-12-14 | Elkhart | Indiana | 18039 | 20924 | 288 |
823797 | 823797 | 2020-12-13 | Elkhart | Indiana | 18039 | 20834 | 288 |
820551 | 820551 | 2020-12-12 | Elkhart | Indiana | 18039 | 20663 | 285 |
817305 | 817305 | 2020-12-11 | Elkhart | Indiana | 18039 | 20459 | 282 |
814059 | 814059 | 2020-12-10 | Elkhart | Indiana | 18039 | 20227 | 282 |
810814 | 810814 | 2020-12-09 | Elkhart | Indiana | 18039 | 20004 | 279 |
807569 | 807569 | 2020-12-08 | Elkhart | Indiana | 18039 | 19811 | 274 |
804324 | 804324 | 2020-12-07 | Elkhart | Indiana | 18039 | 19698 | 266 |
801079 | 801079 | 2020-12-06 | Elkhart | Indiana | 18039 | 19580 | 262 |
797834 | 797834 | 2020-12-05 | Elkhart | Indiana | 18039 | 19326 | 261 |
794589 | 794589 | 2020-12-04 | Elkhart | Indiana | 18039 | 19114 | 259 |
791344 | 791344 | 2020-12-03 | Elkhart | Indiana | 18039 | 18908 | 255 |
788099 | 788099 | 2020-12-02 | Elkhart | Indiana | 18039 | 18605 | 254 |
784855 | 784855 | 2020-12-01 | Elkhart | Indiana | 18039 | 18359 | 250 |
781610 | 781610 | 2020-11-30 | Elkhart | Indiana | 18039 | 18168 | 244 |
778364 | 778364 | 2020-11-29 | Elkhart | Indiana | 18039 | 18039 | 243 |
775119 | 775119 | 2020-11-28 | Elkhart | Indiana | 18039 | 17923 | 242 |
771874 | 771874 | 2020-11-27 | Elkhart | Indiana | 18039 | 17758 | 238 |
768629 | 768629 | 2020-11-26 | Elkhart | Indiana | 18039 | 17569 | 234 |
765383 | 765383 | 2020-11-25 | Elkhart | Indiana | 18039 | 17272 | 229 |
762138 | 762138 | 2020-11-24 | Elkhart | Indiana | 18039 | 17000 | 227 |
758893 | 758893 | 2020-11-23 | Elkhart | Indiana | 18039 | 16760 | 220 |
755646 | 755646 | 2020-11-22 | Elkhart | Indiana | 18039 | 16484 | 217 |
752400 | 752400 | 2020-11-21 | Elkhart | Indiana | 18039 | 16170 | 217 |
749154 | 749154 | 2020-11-20 | Elkhart | Indiana | 18039 | 15810 | 212 |
745908 | 745908 | 2020-11-19 | Elkhart | Indiana | 18039 | 15550 | 211 |
742661 | 742661 | 2020-11-18 | Elkhart | Indiana | 18039 | 15271 | 205 |
739414 | 739414 | 2020-11-17 | Elkhart | Indiana | 18039 | 14974 | 203 |
736170 | 736170 | 2020-11-16 | Elkhart | Indiana | 18039 | 14713 | 194 |
732924 | 732924 | 2020-11-15 | Elkhart | Indiana | 18039 | 14443 | 194 |
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);