ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where county = "Lyman", deaths = 10 and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1176126 | 1176126 | 2021-03-31 | Lyman | South Dakota | 46085 | 625 | 10 |
1172879 | 1172879 | 2021-03-30 | Lyman | South Dakota | 46085 | 624 | 10 |
1169632 | 1169632 | 2021-03-29 | Lyman | South Dakota | 46085 | 624 | 10 |
1166384 | 1166384 | 2021-03-28 | Lyman | South Dakota | 46085 | 624 | 10 |
1163136 | 1163136 | 2021-03-27 | Lyman | South Dakota | 46085 | 624 | 10 |
1159887 | 1159887 | 2021-03-26 | Lyman | South Dakota | 46085 | 621 | 10 |
1156640 | 1156640 | 2021-03-25 | Lyman | South Dakota | 46085 | 620 | 10 |
1153393 | 1153393 | 2021-03-24 | Lyman | South Dakota | 46085 | 614 | 10 |
1150146 | 1150146 | 2021-03-23 | Lyman | South Dakota | 46085 | 613 | 10 |
1146899 | 1146899 | 2021-03-22 | Lyman | South Dakota | 46085 | 613 | 10 |
1143652 | 1143652 | 2021-03-21 | Lyman | South Dakota | 46085 | 613 | 10 |
1140405 | 1140405 | 2021-03-20 | Lyman | South Dakota | 46085 | 610 | 10 |
1137159 | 1137159 | 2021-03-19 | Lyman | South Dakota | 46085 | 608 | 10 |
1133913 | 1133913 | 2021-03-18 | Lyman | South Dakota | 46085 | 608 | 10 |
1130665 | 1130665 | 2021-03-17 | Lyman | South Dakota | 46085 | 607 | 10 |
1127418 | 1127418 | 2021-03-16 | Lyman | South Dakota | 46085 | 607 | 10 |
1124172 | 1124172 | 2021-03-15 | Lyman | South Dakota | 46085 | 607 | 10 |
1120926 | 1120926 | 2021-03-14 | Lyman | South Dakota | 46085 | 607 | 10 |
1117679 | 1117679 | 2021-03-13 | Lyman | South Dakota | 46085 | 606 | 10 |
1114432 | 1114432 | 2021-03-12 | Lyman | South Dakota | 46085 | 606 | 10 |
1111186 | 1111186 | 2021-03-11 | Lyman | South Dakota | 46085 | 606 | 10 |
1107940 | 1107940 | 2021-03-10 | Lyman | South Dakota | 46085 | 605 | 10 |
1104694 | 1104694 | 2021-03-09 | Lyman | South Dakota | 46085 | 604 | 10 |
1101448 | 1101448 | 2021-03-08 | Lyman | South Dakota | 46085 | 603 | 10 |
1098202 | 1098202 | 2021-03-07 | Lyman | South Dakota | 46085 | 603 | 10 |
1094954 | 1094954 | 2021-03-06 | Lyman | South Dakota | 46085 | 603 | 10 |
1091708 | 1091708 | 2021-03-05 | Lyman | South Dakota | 46085 | 602 | 10 |
1088462 | 1088462 | 2021-03-04 | Lyman | South Dakota | 46085 | 602 | 10 |
1085217 | 1085217 | 2021-03-03 | Lyman | South Dakota | 46085 | 601 | 10 |
1081971 | 1081971 | 2021-03-02 | Lyman | South Dakota | 46085 | 600 | 10 |
1078725 | 1078725 | 2021-03-01 | Lyman | South Dakota | 46085 | 598 | 10 |
1075480 | 1075480 | 2021-02-28 | Lyman | South Dakota | 46085 | 598 | 10 |
1072234 | 1072234 | 2021-02-27 | Lyman | South Dakota | 46085 | 598 | 10 |
1068988 | 1068988 | 2021-02-26 | Lyman | South Dakota | 46085 | 598 | 10 |
1065743 | 1065743 | 2021-02-25 | Lyman | South Dakota | 46085 | 598 | 10 |
1062498 | 1062498 | 2021-02-24 | Lyman | South Dakota | 46085 | 597 | 10 |
1059253 | 1059253 | 2021-02-23 | Lyman | South Dakota | 46085 | 597 | 10 |
1056007 | 1056007 | 2021-02-22 | Lyman | South Dakota | 46085 | 597 | 10 |
1052761 | 1052761 | 2021-02-21 | Lyman | South Dakota | 46085 | 597 | 10 |
1049514 | 1049514 | 2021-02-20 | Lyman | South Dakota | 46085 | 597 | 10 |
1046267 | 1046267 | 2021-02-19 | Lyman | South Dakota | 46085 | 597 | 10 |
1043022 | 1043022 | 2021-02-18 | Lyman | South Dakota | 46085 | 597 | 10 |
1039777 | 1039777 | 2021-02-17 | Lyman | South Dakota | 46085 | 598 | 10 |
1036532 | 1036532 | 2021-02-16 | Lyman | South Dakota | 46085 | 598 | 10 |
1033287 | 1033287 | 2021-02-15 | Lyman | South Dakota | 46085 | 594 | 10 |
1030041 | 1030041 | 2021-02-14 | Lyman | South Dakota | 46085 | 594 | 10 |
1026794 | 1026794 | 2021-02-13 | Lyman | South Dakota | 46085 | 594 | 10 |
1023549 | 1023549 | 2021-02-12 | Lyman | South Dakota | 46085 | 593 | 10 |
1020304 | 1020304 | 2021-02-11 | Lyman | South Dakota | 46085 | 593 | 10 |
1017059 | 1017059 | 2021-02-10 | Lyman | South Dakota | 46085 | 592 | 10 |
1013814 | 1013814 | 2021-02-09 | Lyman | South Dakota | 46085 | 591 | 10 |
1010569 | 1010569 | 2021-02-08 | Lyman | South Dakota | 46085 | 591 | 10 |
1007323 | 1007323 | 2021-02-07 | Lyman | South Dakota | 46085 | 591 | 10 |
1004077 | 1004077 | 2021-02-06 | Lyman | South Dakota | 46085 | 590 | 10 |
1000831 | 1000831 | 2021-02-05 | Lyman | South Dakota | 46085 | 590 | 10 |
997585 | 997585 | 2021-02-04 | Lyman | South Dakota | 46085 | 590 | 10 |
994339 | 994339 | 2021-02-03 | Lyman | South Dakota | 46085 | 590 | 10 |
991093 | 991093 | 2021-02-02 | Lyman | South Dakota | 46085 | 590 | 10 |
987847 | 987847 | 2021-02-01 | Lyman | South Dakota | 46085 | 590 | 10 |
984600 | 984600 | 2021-01-31 | Lyman | South Dakota | 46085 | 590 | 10 |
981353 | 981353 | 2021-01-30 | Lyman | South Dakota | 46085 | 590 | 10 |
978107 | 978107 | 2021-01-29 | Lyman | South Dakota | 46085 | 588 | 10 |
974862 | 974862 | 2021-01-28 | Lyman | South Dakota | 46085 | 588 | 10 |
971617 | 971617 | 2021-01-27 | Lyman | South Dakota | 46085 | 588 | 10 |
968372 | 968372 | 2021-01-26 | Lyman | South Dakota | 46085 | 587 | 10 |
965128 | 965128 | 2021-01-25 | Lyman | South Dakota | 46085 | 587 | 10 |
961883 | 961883 | 2021-01-24 | Lyman | South Dakota | 46085 | 587 | 10 |
958638 | 958638 | 2021-01-23 | Lyman | South Dakota | 46085 | 585 | 10 |
955392 | 955392 | 2021-01-22 | Lyman | South Dakota | 46085 | 584 | 10 |
952147 | 952147 | 2021-01-21 | Lyman | South Dakota | 46085 | 584 | 10 |
948902 | 948902 | 2021-01-20 | Lyman | South Dakota | 46085 | 575 | 10 |
945656 | 945656 | 2021-01-19 | Lyman | South Dakota | 46085 | 574 | 10 |
942409 | 942409 | 2021-01-18 | Lyman | South Dakota | 46085 | 574 | 10 |
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);