ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28123 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279019 | 1279019 | 2021-05-02 | Scott | Mississippi | 28123 | 3139 | 73 |
1275772 | 1275772 | 2021-05-01 | Scott | Mississippi | 28123 | 3139 | 73 |
1272525 | 1272525 | 2021-04-30 | Scott | Mississippi | 28123 | 3139 | 73 |
1269278 | 1269278 | 2021-04-29 | Scott | Mississippi | 28123 | 3138 | 73 |
1266031 | 1266031 | 2021-04-28 | Scott | Mississippi | 28123 | 3138 | 73 |
1262784 | 1262784 | 2021-04-27 | Scott | Mississippi | 28123 | 3134 | 73 |
1259537 | 1259537 | 2021-04-26 | Scott | Mississippi | 28123 | 3134 | 73 |
1256290 | 1256290 | 2021-04-25 | Scott | Mississippi | 28123 | 3129 | 73 |
1253043 | 1253043 | 2021-04-24 | Scott | Mississippi | 28123 | 3129 | 73 |
1249796 | 1249796 | 2021-04-23 | Scott | Mississippi | 28123 | 3129 | 73 |
1246549 | 1246549 | 2021-04-22 | Scott | Mississippi | 28123 | 3124 | 73 |
1243302 | 1243302 | 2021-04-21 | Scott | Mississippi | 28123 | 3123 | 73 |
1240055 | 1240055 | 2021-04-20 | Scott | Mississippi | 28123 | 3121 | 73 |
1236808 | 1236808 | 2021-04-19 | Scott | Mississippi | 28123 | 3119 | 73 |
1233561 | 1233561 | 2021-04-18 | Scott | Mississippi | 28123 | 3119 | 73 |
1230313 | 1230313 | 2021-04-17 | Scott | Mississippi | 28123 | 3115 | 73 |
1227065 | 1227065 | 2021-04-16 | Scott | Mississippi | 28123 | 3114 | 72 |
1223817 | 1223817 | 2021-04-15 | Scott | Mississippi | 28123 | 3112 | 72 |
1220570 | 1220570 | 2021-04-14 | Scott | Mississippi | 28123 | 3109 | 72 |
1217322 | 1217322 | 2021-04-13 | Scott | Mississippi | 28123 | 3108 | 72 |
1214075 | 1214075 | 2021-04-12 | Scott | Mississippi | 28123 | 3105 | 72 |
1210827 | 1210827 | 2021-04-11 | Scott | Mississippi | 28123 | 3105 | 72 |
1207578 | 1207578 | 2021-04-10 | Scott | Mississippi | 28123 | 3104 | 72 |
1204330 | 1204330 | 2021-04-09 | Scott | Mississippi | 28123 | 3101 | 72 |
1201082 | 1201082 | 2021-04-08 | Scott | Mississippi | 28123 | 3096 | 72 |
1197833 | 1197833 | 2021-04-07 | Scott | Mississippi | 28123 | 3093 | 72 |
1194584 | 1194584 | 2021-04-06 | Scott | Mississippi | 28123 | 3090 | 72 |
1191335 | 1191335 | 2021-04-05 | Scott | Mississippi | 28123 | 3086 | 72 |
1188087 | 1188087 | 2021-04-04 | Scott | Mississippi | 28123 | 3083 | 72 |
1184840 | 1184840 | 2021-04-03 | Scott | Mississippi | 28123 | 3080 | 72 |
1181594 | 1181594 | 2021-04-02 | Scott | Mississippi | 28123 | 3080 | 72 |
1178347 | 1178347 | 2021-04-01 | Scott | Mississippi | 28123 | 3073 | 72 |
1175100 | 1175100 | 2021-03-31 | Scott | Mississippi | 28123 | 3070 | 72 |
1171853 | 1171853 | 2021-03-30 | Scott | Mississippi | 28123 | 3069 | 72 |
1168605 | 1168605 | 2021-03-29 | Scott | Mississippi | 28123 | 3068 | 72 |
1165357 | 1165357 | 2021-03-28 | Scott | Mississippi | 28123 | 3068 | 72 |
1162109 | 1162109 | 2021-03-27 | Scott | Mississippi | 28123 | 3063 | 72 |
1158861 | 1158861 | 2021-03-26 | Scott | Mississippi | 28123 | 3061 | 72 |
1155614 | 1155614 | 2021-03-25 | Scott | Mississippi | 28123 | 3053 | 72 |
1152367 | 1152367 | 2021-03-24 | Scott | Mississippi | 28123 | 3047 | 72 |
1149120 | 1149120 | 2021-03-23 | Scott | Mississippi | 28123 | 3044 | 72 |
1145873 | 1145873 | 2021-03-22 | Scott | Mississippi | 28123 | 3038 | 71 |
1142626 | 1142626 | 2021-03-21 | Scott | Mississippi | 28123 | 3036 | 71 |
1139379 | 1139379 | 2021-03-20 | Scott | Mississippi | 28123 | 3032 | 71 |
1136133 | 1136133 | 2021-03-19 | Scott | Mississippi | 28123 | 3027 | 71 |
1132887 | 1132887 | 2021-03-18 | Scott | Mississippi | 28123 | 3019 | 71 |
1129639 | 1129639 | 2021-03-17 | Scott | Mississippi | 28123 | 3015 | 71 |
1126392 | 1126392 | 2021-03-16 | Scott | Mississippi | 28123 | 3003 | 71 |
1123146 | 1123146 | 2021-03-15 | Scott | Mississippi | 28123 | 3000 | 71 |
1119899 | 1119899 | 2021-03-14 | Scott | Mississippi | 28123 | 2999 | 71 |
1116652 | 1116652 | 2021-03-13 | Scott | Mississippi | 28123 | 2993 | 71 |
1113406 | 1113406 | 2021-03-12 | Scott | Mississippi | 28123 | 2986 | 71 |
1110160 | 1110160 | 2021-03-11 | Scott | Mississippi | 28123 | 2980 | 71 |
1106914 | 1106914 | 2021-03-10 | Scott | Mississippi | 28123 | 2973 | 71 |
1103668 | 1103668 | 2021-03-09 | Scott | Mississippi | 28123 | 2971 | 71 |
1100422 | 1100422 | 2021-03-08 | Scott | Mississippi | 28123 | 2968 | 71 |
1097175 | 1097175 | 2021-03-07 | Scott | Mississippi | 28123 | 2967 | 71 |
1093928 | 1093928 | 2021-03-06 | Scott | Mississippi | 28123 | 2961 | 71 |
1090682 | 1090682 | 2021-03-05 | Scott | Mississippi | 28123 | 2957 | 71 |
1087437 | 1087437 | 2021-03-04 | Scott | Mississippi | 28123 | 2952 | 71 |
1084192 | 1084192 | 2021-03-03 | Scott | Mississippi | 28123 | 2945 | 70 |
1080946 | 1080946 | 2021-03-02 | Scott | Mississippi | 28123 | 2939 | 70 |
1077700 | 1077700 | 2021-03-01 | Scott | Mississippi | 28123 | 2938 | 70 |
1074454 | 1074454 | 2021-02-28 | Scott | Mississippi | 28123 | 2936 | 70 |
1071208 | 1071208 | 2021-02-27 | Scott | Mississippi | 28123 | 2931 | 70 |
1067963 | 1067963 | 2021-02-26 | Scott | Mississippi | 28123 | 2928 | 68 |
1064718 | 1064718 | 2021-02-25 | Scott | Mississippi | 28123 | 2925 | 67 |
1061474 | 1061474 | 2021-02-24 | Scott | Mississippi | 28123 | 2918 | 67 |
1058228 | 1058228 | 2021-02-23 | Scott | Mississippi | 28123 | 2913 | 67 |
1054982 | 1054982 | 2021-02-22 | Scott | Mississippi | 28123 | 2912 | 66 |
1051735 | 1051735 | 2021-02-21 | Scott | Mississippi | 28123 | 2911 | 66 |
1048488 | 1048488 | 2021-02-20 | Scott | Mississippi | 28123 | 2900 | 66 |
1045242 | 1045242 | 2021-02-19 | Scott | Mississippi | 28123 | 2900 | 66 |
1041997 | 1041997 | 2021-02-18 | Scott | Mississippi | 28123 | 2898 | 66 |
1038752 | 1038752 | 2021-02-17 | Scott | Mississippi | 28123 | 2898 | 66 |
1035507 | 1035507 | 2021-02-16 | Scott | Mississippi | 28123 | 2891 | 66 |
1032262 | 1032262 | 2021-02-15 | Scott | Mississippi | 28123 | 2886 | 66 |
1029015 | 1029015 | 2021-02-14 | Scott | Mississippi | 28123 | 2877 | 66 |
1025769 | 1025769 | 2021-02-13 | Scott | Mississippi | 28123 | 2872 | 66 |
1022524 | 1022524 | 2021-02-12 | Scott | Mississippi | 28123 | 2864 | 66 |
1019279 | 1019279 | 2021-02-11 | Scott | Mississippi | 28123 | 2854 | 65 |
1016034 | 1016034 | 2021-02-10 | Scott | Mississippi | 28123 | 2839 | 65 |
1012789 | 1012789 | 2021-02-09 | Scott | Mississippi | 28123 | 2834 | 64 |
1009544 | 1009544 | 2021-02-08 | Scott | Mississippi | 28123 | 2827 | 60 |
1006297 | 1006297 | 2021-02-07 | Scott | Mississippi | 28123 | 2823 | 60 |
1003051 | 1003051 | 2021-02-06 | Scott | Mississippi | 28123 | 2812 | 60 |
999806 | 999806 | 2021-02-05 | Scott | Mississippi | 28123 | 2800 | 59 |
996560 | 996560 | 2021-02-04 | Scott | Mississippi | 28123 | 2786 | 58 |
993314 | 993314 | 2021-02-03 | Scott | Mississippi | 28123 | 2769 | 58 |
990068 | 990068 | 2021-02-02 | Scott | Mississippi | 28123 | 2759 | 58 |
986821 | 986821 | 2021-02-01 | Scott | Mississippi | 28123 | 2746 | 56 |
983574 | 983574 | 2021-01-31 | Scott | Mississippi | 28123 | 2742 | 56 |
980328 | 980328 | 2021-01-30 | Scott | Mississippi | 28123 | 2734 | 56 |
977082 | 977082 | 2021-01-29 | Scott | Mississippi | 28123 | 2720 | 55 |
973837 | 973837 | 2021-01-28 | Scott | Mississippi | 28123 | 2690 | 55 |
970592 | 970592 | 2021-01-27 | Scott | Mississippi | 28123 | 2680 | 55 |
967347 | 967347 | 2021-01-26 | Scott | Mississippi | 28123 | 2640 | 55 |
964103 | 964103 | 2021-01-25 | Scott | Mississippi | 28123 | 2608 | 49 |
960858 | 960858 | 2021-01-24 | Scott | Mississippi | 28123 | 2600 | 48 |
957612 | 957612 | 2021-01-23 | Scott | Mississippi | 28123 | 2596 | 48 |
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);