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 |
---|---|---|---|---|---|---|---|
1193831 | 1193831 | 2021-04-06 | Elkhart | Indiana | 18039 | 26680 | 444 |
1190581 | 1190581 | 2021-04-05 | Elkhart | Indiana | 18039 | 26654 | 444 |
1187334 | 1187334 | 2021-04-04 | Elkhart | Indiana | 18039 | 26630 | 444 |
1184087 | 1184087 | 2021-04-03 | Elkhart | Indiana | 18039 | 26583 | 444 |
1180840 | 1180840 | 2021-04-02 | Elkhart | Indiana | 18039 | 26533 | 443 |
1177593 | 1177593 | 2021-04-01 | Elkhart | Indiana | 18039 | 26477 | 443 |
1174346 | 1174346 | 2021-03-31 | Elkhart | Indiana | 18039 | 26416 | 443 |
1171099 | 1171099 | 2021-03-30 | Elkhart | Indiana | 18039 | 26362 | 443 |
1167851 | 1167851 | 2021-03-29 | Elkhart | Indiana | 18039 | 26335 | 442 |
1164603 | 1164603 | 2021-03-28 | Elkhart | Indiana | 18039 | 26296 | 442 |
1161355 | 1161355 | 2021-03-27 | Elkhart | Indiana | 18039 | 26249 | 442 |
1158107 | 1158107 | 2021-03-26 | Elkhart | Indiana | 18039 | 26220 | 442 |
1154860 | 1154860 | 2021-03-25 | Elkhart | Indiana | 18039 | 26176 | 442 |
1151613 | 1151613 | 2021-03-24 | Elkhart | Indiana | 18039 | 26135 | 442 |
1148366 | 1148366 | 2021-03-23 | Elkhart | Indiana | 18039 | 26089 | 442 |
1145119 | 1145119 | 2021-03-22 | Elkhart | Indiana | 18039 | 26072 | 441 |
1141872 | 1141872 | 2021-03-21 | Elkhart | Indiana | 18039 | 26055 | 441 |
1138626 | 1138626 | 2021-03-20 | Elkhart | Indiana | 18039 | 26021 | 441 |
1135380 | 1135380 | 2021-03-19 | Elkhart | Indiana | 18039 | 25994 | 441 |
1132133 | 1132133 | 2021-03-18 | Elkhart | Indiana | 18039 | 25966 | 440 |
1128885 | 1128885 | 2021-03-17 | Elkhart | Indiana | 18039 | 25926 | 439 |
1125639 | 1125639 | 2021-03-16 | Elkhart | Indiana | 18039 | 25872 | 438 |
1122393 | 1122393 | 2021-03-15 | Elkhart | Indiana | 18039 | 25855 | 438 |
1119146 | 1119146 | 2021-03-14 | Elkhart | Indiana | 18039 | 25839 | 438 |
1115899 | 1115899 | 2021-03-13 | Elkhart | Indiana | 18039 | 25798 | 436 |
1112653 | 1112653 | 2021-03-12 | Elkhart | Indiana | 18039 | 25770 | 435 |
1109407 | 1109407 | 2021-03-11 | Elkhart | Indiana | 18039 | 25728 | 435 |
1106161 | 1106161 | 2021-03-10 | Elkhart | Indiana | 18039 | 25706 | 435 |
1102915 | 1102915 | 2021-03-09 | Elkhart | Indiana | 18039 | 25668 | 435 |
1099669 | 1099669 | 2021-03-08 | Elkhart | Indiana | 18039 | 25646 | 435 |
1096421 | 1096421 | 2021-03-07 | Elkhart | Indiana | 18039 | 25634 | 435 |
1093175 | 1093175 | 2021-03-06 | Elkhart | Indiana | 18039 | 25608 | 435 |
1089929 | 1089929 | 2021-03-05 | Elkhart | Indiana | 18039 | 25582 | 435 |
1086684 | 1086684 | 2021-03-04 | Elkhart | Indiana | 18039 | 25553 | 434 |
1083438 | 1083438 | 2021-03-03 | Elkhart | Indiana | 18039 | 25523 | 432 |
1080192 | 1080192 | 2021-03-02 | Elkhart | Indiana | 18039 | 25503 | 432 |
1076947 | 1076947 | 2021-03-01 | Elkhart | Indiana | 18039 | 25487 | 431 |
1073701 | 1073701 | 2021-02-28 | Elkhart | Indiana | 18039 | 25477 | 430 |
1070455 | 1070455 | 2021-02-27 | Elkhart | Indiana | 18039 | 25451 | 430 |
1067210 | 1067210 | 2021-02-26 | Elkhart | Indiana | 18039 | 25434 | 429 |
1063965 | 1063965 | 2021-02-25 | Elkhart | Indiana | 18039 | 25409 | 429 |
1060720 | 1060720 | 2021-02-24 | Elkhart | Indiana | 18039 | 25393 | 429 |
1057474 | 1057474 | 2021-02-23 | Elkhart | Indiana | 18039 | 25363 | 429 |
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 |
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);