ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Meade" 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 |
---|---|---|---|---|---|---|---|
1094958 | 1094958 | 2021-03-06 | Meade | South Dakota | 46093 | 2614 | 31 |
1091712 | 1091712 | 2021-03-05 | Meade | South Dakota | 46093 | 2610 | 31 |
1088466 | 1088466 | 2021-03-04 | Meade | South Dakota | 46093 | 2605 | 31 |
1085221 | 1085221 | 2021-03-03 | Meade | South Dakota | 46093 | 2600 | 31 |
1081975 | 1081975 | 2021-03-02 | Meade | South Dakota | 46093 | 2596 | 31 |
1078729 | 1078729 | 2021-03-01 | Meade | South Dakota | 46093 | 2592 | 31 |
1075484 | 1075484 | 2021-02-28 | Meade | South Dakota | 46093 | 2590 | 31 |
1072238 | 1072238 | 2021-02-27 | Meade | South Dakota | 46093 | 2588 | 31 |
1068992 | 1068992 | 2021-02-26 | Meade | South Dakota | 46093 | 2583 | 31 |
1065747 | 1065747 | 2021-02-25 | Meade | South Dakota | 46093 | 2577 | 31 |
1062502 | 1062502 | 2021-02-24 | Meade | South Dakota | 46093 | 2572 | 31 |
1059257 | 1059257 | 2021-02-23 | Meade | South Dakota | 46093 | 2563 | 31 |
1056011 | 1056011 | 2021-02-22 | Meade | South Dakota | 46093 | 2558 | 31 |
1052765 | 1052765 | 2021-02-21 | Meade | South Dakota | 46093 | 2558 | 31 |
1049518 | 1049518 | 2021-02-20 | Meade | South Dakota | 46093 | 2557 | 31 |
1046271 | 1046271 | 2021-02-19 | Meade | South Dakota | 46093 | 2553 | 31 |
1043026 | 1043026 | 2021-02-18 | Meade | South Dakota | 46093 | 2549 | 31 |
1039781 | 1039781 | 2021-02-17 | Meade | South Dakota | 46093 | 2542 | 31 |
1036536 | 1036536 | 2021-02-16 | Meade | South Dakota | 46093 | 2535 | 31 |
1033291 | 1033291 | 2021-02-15 | Meade | South Dakota | 46093 | 2524 | 31 |
1030045 | 1030045 | 2021-02-14 | Meade | South Dakota | 46093 | 2525 | 31 |
1026798 | 1026798 | 2021-02-13 | Meade | South Dakota | 46093 | 2524 | 31 |
1023553 | 1023553 | 2021-02-12 | Meade | South Dakota | 46093 | 2523 | 31 |
1020308 | 1020308 | 2021-02-11 | Meade | South Dakota | 46093 | 2516 | 31 |
1017063 | 1017063 | 2021-02-10 | Meade | South Dakota | 46093 | 2510 | 31 |
1013818 | 1013818 | 2021-02-09 | Meade | South Dakota | 46093 | 2507 | 31 |
1010573 | 1010573 | 2021-02-08 | Meade | South Dakota | 46093 | 2498 | 31 |
1007327 | 1007327 | 2021-02-07 | Meade | South Dakota | 46093 | 2496 | 31 |
1004081 | 1004081 | 2021-02-06 | Meade | South Dakota | 46093 | 2494 | 31 |
1000835 | 1000835 | 2021-02-05 | Meade | South Dakota | 46093 | 2488 | 31 |
997589 | 997589 | 2021-02-04 | Meade | South Dakota | 46093 | 2486 | 31 |
994343 | 994343 | 2021-02-03 | Meade | South Dakota | 46093 | 2483 | 30 |
991097 | 991097 | 2021-02-02 | Meade | South Dakota | 46093 | 2480 | 30 |
987851 | 987851 | 2021-02-01 | Meade | South Dakota | 46093 | 2478 | 30 |
984604 | 984604 | 2021-01-31 | Meade | South Dakota | 46093 | 2476 | 30 |
981357 | 981357 | 2021-01-30 | Meade | South Dakota | 46093 | 2473 | 30 |
978111 | 978111 | 2021-01-29 | Meade | South Dakota | 46093 | 2465 | 28 |
974866 | 974866 | 2021-01-28 | Meade | South Dakota | 46093 | 2462 | 28 |
971621 | 971621 | 2021-01-27 | Meade | South Dakota | 46093 | 2459 | 28 |
968376 | 968376 | 2021-01-26 | Meade | South Dakota | 46093 | 2456 | 28 |
965132 | 965132 | 2021-01-25 | Meade | South Dakota | 46093 | 2446 | 28 |
961887 | 961887 | 2021-01-24 | Meade | South Dakota | 46093 | 2445 | 28 |
958642 | 958642 | 2021-01-23 | Meade | South Dakota | 46093 | 2440 | 28 |
955396 | 955396 | 2021-01-22 | Meade | South Dakota | 46093 | 2433 | 28 |
952151 | 952151 | 2021-01-21 | Meade | South Dakota | 46093 | 2428 | 27 |
948906 | 948906 | 2021-01-20 | Meade | South Dakota | 46093 | 2416 | 26 |
945660 | 945660 | 2021-01-19 | Meade | South Dakota | 46093 | 2413 | 26 |
942413 | 942413 | 2021-01-18 | Meade | South Dakota | 46093 | 2412 | 26 |
939168 | 939168 | 2021-01-17 | Meade | South Dakota | 46093 | 2411 | 26 |
935923 | 935923 | 2021-01-16 | Meade | South Dakota | 46093 | 2400 | 26 |
932678 | 932678 | 2021-01-15 | Meade | South Dakota | 46093 | 2390 | 26 |
929433 | 929433 | 2021-01-14 | Meade | South Dakota | 46093 | 2385 | 26 |
926188 | 926188 | 2021-01-13 | Meade | South Dakota | 46093 | 2378 | 26 |
922942 | 922942 | 2021-01-12 | Meade | South Dakota | 46093 | 2365 | 24 |
919697 | 919697 | 2021-01-11 | Meade | South Dakota | 46093 | 2355 | 24 |
916452 | 916452 | 2021-01-10 | Meade | South Dakota | 46093 | 2350 | 24 |
913207 | 913207 | 2021-01-09 | Meade | South Dakota | 46093 | 2337 | 24 |
909962 | 909962 | 2021-01-08 | Meade | South Dakota | 46093 | 2326 | 24 |
906717 | 906717 | 2021-01-07 | Meade | South Dakota | 46093 | 2315 | 24 |
903471 | 903471 | 2021-01-06 | Meade | South Dakota | 46093 | 2309 | 24 |
900226 | 900226 | 2021-01-05 | Meade | South Dakota | 46093 | 2298 | 24 |
896981 | 896981 | 2021-01-04 | Meade | South Dakota | 46093 | 2290 | 24 |
893735 | 893735 | 2021-01-03 | Meade | South Dakota | 46093 | 2288 | 24 |
890489 | 890489 | 2021-01-02 | Meade | South Dakota | 46093 | 2262 | 24 |
887242 | 887242 | 2021-01-01 | Meade | South Dakota | 46093 | 2231 | 24 |
883997 | 883997 | 2020-12-31 | Meade | South Dakota | 46093 | 2231 | 24 |
880752 | 880752 | 2020-12-30 | Meade | South Dakota | 46093 | 2222 | 24 |
877507 | 877507 | 2020-12-29 | Meade | South Dakota | 46093 | 2202 | 24 |
874262 | 874262 | 2020-12-28 | Meade | South Dakota | 46093 | 2186 | 24 |
871017 | 871017 | 2020-12-27 | Meade | South Dakota | 46093 | 2180 | 24 |
867772 | 867772 | 2020-12-26 | Meade | South Dakota | 46093 | 2172 | 24 |
864527 | 864527 | 2020-12-25 | Meade | South Dakota | 46093 | 2160 | 24 |
861282 | 861282 | 2020-12-24 | Meade | South Dakota | 46093 | 2160 | 24 |
858037 | 858037 | 2020-12-23 | Meade | South Dakota | 46093 | 2149 | 22 |
854792 | 854792 | 2020-12-22 | Meade | South Dakota | 46093 | 2129 | 22 |
851547 | 851547 | 2020-12-21 | Meade | South Dakota | 46093 | 2119 | 22 |
848302 | 848302 | 2020-12-20 | Meade | South Dakota | 46093 | 2113 | 21 |
845057 | 845057 | 2020-12-19 | Meade | South Dakota | 46093 | 2111 | 21 |
841811 | 841811 | 2020-12-18 | Meade | South Dakota | 46093 | 2097 | 20 |
838566 | 838566 | 2020-12-17 | Meade | South Dakota | 46093 | 2088 | 20 |
835320 | 835320 | 2020-12-16 | Meade | South Dakota | 46093 | 2074 | 20 |
832074 | 832074 | 2020-12-15 | Meade | South Dakota | 46093 | 2042 | 20 |
828827 | 828827 | 2020-12-14 | Meade | South Dakota | 46093 | 2037 | 20 |
825581 | 825581 | 2020-12-13 | Meade | South Dakota | 46093 | 2028 | 20 |
822334 | 822334 | 2020-12-12 | Meade | South Dakota | 46093 | 2017 | 18 |
819088 | 819088 | 2020-12-11 | Meade | South Dakota | 46093 | 1994 | 18 |
815842 | 815842 | 2020-12-10 | Meade | South Dakota | 46093 | 1967 | 17 |
812596 | 812596 | 2020-12-09 | Meade | South Dakota | 46093 | 1951 | 17 |
809352 | 809352 | 2020-12-08 | Meade | South Dakota | 46093 | 1914 | 16 |
806107 | 806107 | 2020-12-07 | Meade | South Dakota | 46093 | 1908 | 16 |
802862 | 802862 | 2020-12-06 | Meade | South Dakota | 46093 | 1897 | 16 |
799617 | 799617 | 2020-12-05 | Meade | South Dakota | 46093 | 1880 | 15 |
796372 | 796372 | 2020-12-04 | Meade | South Dakota | 46093 | 1853 | 14 |
793127 | 793127 | 2020-12-03 | Meade | South Dakota | 46093 | 1832 | 14 |
789882 | 789882 | 2020-12-02 | Meade | South Dakota | 46093 | 1809 | 13 |
786637 | 786637 | 2020-12-01 | Meade | South Dakota | 46093 | 1763 | 13 |
783393 | 783393 | 2020-11-30 | Meade | South Dakota | 46093 | 1753 | 13 |
780148 | 780148 | 2020-11-29 | Meade | South Dakota | 46093 | 1737 | 13 |
776902 | 776902 | 2020-11-28 | Meade | South Dakota | 46093 | 1715 | 13 |
773657 | 773657 | 2020-11-27 | Meade | South Dakota | 46093 | 1698 | 13 |
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);