ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Deuel" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091685 | 1091685 | 2021-03-05 | Deuel | South Dakota | 46039 | 474 | 8 |
1088439 | 1088439 | 2021-03-04 | Deuel | South Dakota | 46039 | 474 | 8 |
1085194 | 1085194 | 2021-03-03 | Deuel | South Dakota | 46039 | 474 | 8 |
1081948 | 1081948 | 2021-03-02 | Deuel | South Dakota | 46039 | 474 | 8 |
1078702 | 1078702 | 2021-03-01 | Deuel | South Dakota | 46039 | 473 | 8 |
1075457 | 1075457 | 2021-02-28 | Deuel | South Dakota | 46039 | 473 | 8 |
1072211 | 1072211 | 2021-02-27 | Deuel | South Dakota | 46039 | 473 | 8 |
1068965 | 1068965 | 2021-02-26 | Deuel | South Dakota | 46039 | 472 | 8 |
1065720 | 1065720 | 2021-02-25 | Deuel | South Dakota | 46039 | 472 | 8 |
1062475 | 1062475 | 2021-02-24 | Deuel | South Dakota | 46039 | 472 | 8 |
1059230 | 1059230 | 2021-02-23 | Deuel | South Dakota | 46039 | 471 | 8 |
1055984 | 1055984 | 2021-02-22 | Deuel | South Dakota | 46039 | 471 | 8 |
1052738 | 1052738 | 2021-02-21 | Deuel | South Dakota | 46039 | 471 | 8 |
1049491 | 1049491 | 2021-02-20 | Deuel | South Dakota | 46039 | 471 | 8 |
1046244 | 1046244 | 2021-02-19 | Deuel | South Dakota | 46039 | 471 | 8 |
1042999 | 1042999 | 2021-02-18 | Deuel | South Dakota | 46039 | 471 | 8 |
1039754 | 1039754 | 2021-02-17 | Deuel | South Dakota | 46039 | 471 | 8 |
1036509 | 1036509 | 2021-02-16 | Deuel | South Dakota | 46039 | 469 | 8 |
1033264 | 1033264 | 2021-02-15 | Deuel | South Dakota | 46039 | 466 | 8 |
1030018 | 1030018 | 2021-02-14 | Deuel | South Dakota | 46039 | 466 | 8 |
1026771 | 1026771 | 2021-02-13 | Deuel | South Dakota | 46039 | 465 | 8 |
1023526 | 1023526 | 2021-02-12 | Deuel | South Dakota | 46039 | 464 | 8 |
1020281 | 1020281 | 2021-02-11 | Deuel | South Dakota | 46039 | 464 | 8 |
1017036 | 1017036 | 2021-02-10 | Deuel | South Dakota | 46039 | 461 | 8 |
1013791 | 1013791 | 2021-02-09 | Deuel | South Dakota | 46039 | 460 | 8 |
1010546 | 1010546 | 2021-02-08 | Deuel | South Dakota | 46039 | 460 | 8 |
1007300 | 1007300 | 2021-02-07 | Deuel | South Dakota | 46039 | 460 | 8 |
1004054 | 1004054 | 2021-02-06 | Deuel | South Dakota | 46039 | 460 | 8 |
1000808 | 1000808 | 2021-02-05 | Deuel | South Dakota | 46039 | 459 | 8 |
997562 | 997562 | 2021-02-04 | Deuel | South Dakota | 46039 | 458 | 8 |
994316 | 994316 | 2021-02-03 | Deuel | South Dakota | 46039 | 458 | 8 |
991070 | 991070 | 2021-02-02 | Deuel | South Dakota | 46039 | 458 | 8 |
987824 | 987824 | 2021-02-01 | Deuel | South Dakota | 46039 | 458 | 8 |
984577 | 984577 | 2021-01-31 | Deuel | South Dakota | 46039 | 458 | 8 |
981330 | 981330 | 2021-01-30 | Deuel | South Dakota | 46039 | 457 | 8 |
978084 | 978084 | 2021-01-29 | Deuel | South Dakota | 46039 | 457 | 8 |
974839 | 974839 | 2021-01-28 | Deuel | South Dakota | 46039 | 457 | 8 |
971594 | 971594 | 2021-01-27 | Deuel | South Dakota | 46039 | 457 | 8 |
968349 | 968349 | 2021-01-26 | Deuel | South Dakota | 46039 | 455 | 7 |
965105 | 965105 | 2021-01-25 | Deuel | South Dakota | 46039 | 453 | 7 |
961860 | 961860 | 2021-01-24 | Deuel | South Dakota | 46039 | 453 | 7 |
958615 | 958615 | 2021-01-23 | Deuel | South Dakota | 46039 | 452 | 7 |
955369 | 955369 | 2021-01-22 | Deuel | South Dakota | 46039 | 451 | 7 |
952124 | 952124 | 2021-01-21 | Deuel | South Dakota | 46039 | 450 | 7 |
948879 | 948879 | 2021-01-20 | Deuel | South Dakota | 46039 | 450 | 7 |
945633 | 945633 | 2021-01-19 | Deuel | South Dakota | 46039 | 449 | 7 |
942386 | 942386 | 2021-01-18 | Deuel | South Dakota | 46039 | 449 | 7 |
939141 | 939141 | 2021-01-17 | Deuel | South Dakota | 46039 | 449 | 7 |
935896 | 935896 | 2021-01-16 | Deuel | South Dakota | 46039 | 447 | 7 |
932651 | 932651 | 2021-01-15 | Deuel | South Dakota | 46039 | 447 | 7 |
929406 | 929406 | 2021-01-14 | Deuel | South Dakota | 46039 | 444 | 7 |
926161 | 926161 | 2021-01-13 | Deuel | South Dakota | 46039 | 444 | 7 |
922915 | 922915 | 2021-01-12 | Deuel | South Dakota | 46039 | 439 | 7 |
919670 | 919670 | 2021-01-11 | Deuel | South Dakota | 46039 | 438 | 7 |
916425 | 916425 | 2021-01-10 | Deuel | South Dakota | 46039 | 437 | 7 |
913180 | 913180 | 2021-01-09 | Deuel | South Dakota | 46039 | 433 | 7 |
909935 | 909935 | 2021-01-08 | Deuel | South Dakota | 46039 | 429 | 7 |
906690 | 906690 | 2021-01-07 | Deuel | South Dakota | 46039 | 428 | 7 |
903444 | 903444 | 2021-01-06 | Deuel | South Dakota | 46039 | 425 | 7 |
900199 | 900199 | 2021-01-05 | Deuel | South Dakota | 46039 | 422 | 7 |
896954 | 896954 | 2021-01-04 | Deuel | South Dakota | 46039 | 417 | 7 |
893708 | 893708 | 2021-01-03 | Deuel | South Dakota | 46039 | 417 | 7 |
890462 | 890462 | 2021-01-02 | Deuel | South Dakota | 46039 | 413 | 7 |
887215 | 887215 | 2021-01-01 | Deuel | South Dakota | 46039 | 412 | 7 |
883970 | 883970 | 2020-12-31 | Deuel | South Dakota | 46039 | 412 | 7 |
880725 | 880725 | 2020-12-30 | Deuel | South Dakota | 46039 | 411 | 7 |
877480 | 877480 | 2020-12-29 | Deuel | South Dakota | 46039 | 405 | 6 |
874235 | 874235 | 2020-12-28 | Deuel | South Dakota | 46039 | 404 | 6 |
870990 | 870990 | 2020-12-27 | Deuel | South Dakota | 46039 | 404 | 6 |
867745 | 867745 | 2020-12-26 | Deuel | South Dakota | 46039 | 402 | 6 |
864500 | 864500 | 2020-12-25 | Deuel | South Dakota | 46039 | 399 | 6 |
861255 | 861255 | 2020-12-24 | Deuel | South Dakota | 46039 | 399 | 6 |
858010 | 858010 | 2020-12-23 | Deuel | South Dakota | 46039 | 397 | 6 |
854765 | 854765 | 2020-12-22 | Deuel | South Dakota | 46039 | 397 | 6 |
851520 | 851520 | 2020-12-21 | Deuel | South Dakota | 46039 | 395 | 6 |
848275 | 848275 | 2020-12-20 | Deuel | South Dakota | 46039 | 394 | 6 |
845030 | 845030 | 2020-12-19 | Deuel | South Dakota | 46039 | 391 | 6 |
841784 | 841784 | 2020-12-18 | Deuel | South Dakota | 46039 | 385 | 6 |
838539 | 838539 | 2020-12-17 | Deuel | South Dakota | 46039 | 383 | 6 |
835293 | 835293 | 2020-12-16 | Deuel | South Dakota | 46039 | 381 | 6 |
832047 | 832047 | 2020-12-15 | Deuel | South Dakota | 46039 | 376 | 5 |
828800 | 828800 | 2020-12-14 | Deuel | South Dakota | 46039 | 372 | 5 |
825554 | 825554 | 2020-12-13 | Deuel | South Dakota | 46039 | 372 | 5 |
822307 | 822307 | 2020-12-12 | Deuel | South Dakota | 46039 | 371 | 5 |
819061 | 819061 | 2020-12-11 | Deuel | South Dakota | 46039 | 367 | 5 |
815815 | 815815 | 2020-12-10 | Deuel | South Dakota | 46039 | 365 | 5 |
812569 | 812569 | 2020-12-09 | Deuel | South Dakota | 46039 | 359 | 4 |
809325 | 809325 | 2020-12-08 | Deuel | South Dakota | 46039 | 353 | 3 |
806080 | 806080 | 2020-12-07 | Deuel | South Dakota | 46039 | 349 | 3 |
802835 | 802835 | 2020-12-06 | Deuel | South Dakota | 46039 | 347 | 3 |
799590 | 799590 | 2020-12-05 | Deuel | South Dakota | 46039 | 344 | 3 |
796345 | 796345 | 2020-12-04 | Deuel | South Dakota | 46039 | 335 | 2 |
793100 | 793100 | 2020-12-03 | Deuel | South Dakota | 46039 | 332 | 2 |
789855 | 789855 | 2020-12-02 | Deuel | South Dakota | 46039 | 326 | 2 |
786610 | 786610 | 2020-12-01 | Deuel | South Dakota | 46039 | 311 | 2 |
783366 | 783366 | 2020-11-30 | Deuel | South Dakota | 46039 | 311 | 2 |
780121 | 780121 | 2020-11-29 | Deuel | South Dakota | 46039 | 306 | 2 |
776875 | 776875 | 2020-11-28 | Deuel | South Dakota | 46039 | 302 | 2 |
773630 | 773630 | 2020-11-27 | Deuel | South Dakota | 46039 | 297 | 2 |
770385 | 770385 | 2020-11-26 | Deuel | South Dakota | 46039 | 292 | 2 |
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);