ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Brown" 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 |
---|---|---|---|---|---|---|---|
1273516 | 1273516 | 2021-04-30 | Brown | South Dakota | 46013 | 5509 | 91 |
1270269 | 1270269 | 2021-04-29 | Brown | South Dakota | 46013 | 5499 | 91 |
1267022 | 1267022 | 2021-04-28 | Brown | South Dakota | 46013 | 5494 | 91 |
1263775 | 1263775 | 2021-04-27 | Brown | South Dakota | 46013 | 5475 | 91 |
1260528 | 1260528 | 2021-04-26 | Brown | South Dakota | 46013 | 5467 | 91 |
1257281 | 1257281 | 2021-04-25 | Brown | South Dakota | 46013 | 5463 | 91 |
1254034 | 1254034 | 2021-04-24 | Brown | South Dakota | 46013 | 5463 | 91 |
1250787 | 1250787 | 2021-04-23 | Brown | South Dakota | 46013 | 5459 | 91 |
1247540 | 1247540 | 2021-04-22 | Brown | South Dakota | 46013 | 5450 | 91 |
1244293 | 1244293 | 2021-04-21 | Brown | South Dakota | 46013 | 5445 | 91 |
1241046 | 1241046 | 2021-04-20 | Brown | South Dakota | 46013 | 5442 | 91 |
1237799 | 1237799 | 2021-04-19 | Brown | South Dakota | 46013 | 5433 | 91 |
1234552 | 1234552 | 2021-04-18 | Brown | South Dakota | 46013 | 5429 | 91 |
1231304 | 1231304 | 2021-04-17 | Brown | South Dakota | 46013 | 5429 | 91 |
1228056 | 1228056 | 2021-04-16 | Brown | South Dakota | 46013 | 5426 | 91 |
1224808 | 1224808 | 2021-04-15 | Brown | South Dakota | 46013 | 5422 | 91 |
1221561 | 1221561 | 2021-04-14 | Brown | South Dakota | 46013 | 5418 | 91 |
1218313 | 1218313 | 2021-04-13 | Brown | South Dakota | 46013 | 5409 | 91 |
1215065 | 1215065 | 2021-04-12 | Brown | South Dakota | 46013 | 5395 | 91 |
1211818 | 1211818 | 2021-04-11 | Brown | South Dakota | 46013 | 5387 | 91 |
1208569 | 1208569 | 2021-04-10 | Brown | South Dakota | 46013 | 5387 | 91 |
1205321 | 1205321 | 2021-04-09 | Brown | South Dakota | 46013 | 5376 | 91 |
1202073 | 1202073 | 2021-04-08 | Brown | South Dakota | 46013 | 5366 | 91 |
1198824 | 1198824 | 2021-04-07 | Brown | South Dakota | 46013 | 5356 | 91 |
1195575 | 1195575 | 2021-04-06 | Brown | South Dakota | 46013 | 5343 | 91 |
1192327 | 1192327 | 2021-04-05 | Brown | South Dakota | 46013 | 5337 | 91 |
1189078 | 1189078 | 2021-04-04 | Brown | South Dakota | 46013 | 5331 | 91 |
1185831 | 1185831 | 2021-04-03 | Brown | South Dakota | 46013 | 5331 | 91 |
1182584 | 1182584 | 2021-04-02 | Brown | South Dakota | 46013 | 5322 | 91 |
1179337 | 1179337 | 2021-04-01 | Brown | South Dakota | 46013 | 5314 | 91 |
1176090 | 1176090 | 2021-03-31 | Brown | South Dakota | 46013 | 5304 | 91 |
1172843 | 1172843 | 2021-03-30 | Brown | South Dakota | 46013 | 5290 | 91 |
1169596 | 1169596 | 2021-03-29 | Brown | South Dakota | 46013 | 5286 | 91 |
1166348 | 1166348 | 2021-03-28 | Brown | South Dakota | 46013 | 5281 | 91 |
1163100 | 1163100 | 2021-03-27 | Brown | South Dakota | 46013 | 5276 | 91 |
1159851 | 1159851 | 2021-03-26 | Brown | South Dakota | 46013 | 5264 | 91 |
1156604 | 1156604 | 2021-03-25 | Brown | South Dakota | 46013 | 5258 | 91 |
1153357 | 1153357 | 2021-03-24 | Brown | South Dakota | 46013 | 5253 | 91 |
1150110 | 1150110 | 2021-03-23 | Brown | South Dakota | 46013 | 5244 | 91 |
1146863 | 1146863 | 2021-03-22 | Brown | South Dakota | 46013 | 5242 | 91 |
1143616 | 1143616 | 2021-03-21 | Brown | South Dakota | 46013 | 5240 | 91 |
1140369 | 1140369 | 2021-03-20 | Brown | South Dakota | 46013 | 5238 | 90 |
1137123 | 1137123 | 2021-03-19 | Brown | South Dakota | 46013 | 5233 | 90 |
1133877 | 1133877 | 2021-03-18 | Brown | South Dakota | 46013 | 5229 | 90 |
1130629 | 1130629 | 2021-03-17 | Brown | South Dakota | 46013 | 5224 | 90 |
1127382 | 1127382 | 2021-03-16 | Brown | South Dakota | 46013 | 5212 | 89 |
1124136 | 1124136 | 2021-03-15 | Brown | South Dakota | 46013 | 5207 | 89 |
1120890 | 1120890 | 2021-03-14 | Brown | South Dakota | 46013 | 5206 | 89 |
1117643 | 1117643 | 2021-03-13 | Brown | South Dakota | 46013 | 5200 | 89 |
1114396 | 1114396 | 2021-03-12 | Brown | South Dakota | 46013 | 5192 | 89 |
1111150 | 1111150 | 2021-03-11 | Brown | South Dakota | 46013 | 5186 | 89 |
1107904 | 1107904 | 2021-03-10 | Brown | South Dakota | 46013 | 5183 | 89 |
1104658 | 1104658 | 2021-03-09 | Brown | South Dakota | 46013 | 5179 | 89 |
1101412 | 1101412 | 2021-03-08 | Brown | South Dakota | 46013 | 5175 | 89 |
1098166 | 1098166 | 2021-03-07 | Brown | South Dakota | 46013 | 5175 | 89 |
1094918 | 1094918 | 2021-03-06 | Brown | South Dakota | 46013 | 5167 | 89 |
1091672 | 1091672 | 2021-03-05 | Brown | South Dakota | 46013 | 5161 | 89 |
1088426 | 1088426 | 2021-03-04 | Brown | South Dakota | 46013 | 5157 | 89 |
1085181 | 1085181 | 2021-03-03 | Brown | South Dakota | 46013 | 5147 | 89 |
1081935 | 1081935 | 2021-03-02 | Brown | South Dakota | 46013 | 5142 | 88 |
1078689 | 1078689 | 2021-03-01 | Brown | South Dakota | 46013 | 5132 | 88 |
1075444 | 1075444 | 2021-02-28 | Brown | South Dakota | 46013 | 5129 | 88 |
1072198 | 1072198 | 2021-02-27 | Brown | South Dakota | 46013 | 5126 | 88 |
1068952 | 1068952 | 2021-02-26 | Brown | South Dakota | 46013 | 5117 | 88 |
1065707 | 1065707 | 2021-02-25 | Brown | South Dakota | 46013 | 5110 | 88 |
1062462 | 1062462 | 2021-02-24 | Brown | South Dakota | 46013 | 5107 | 85 |
1059217 | 1059217 | 2021-02-23 | Brown | South Dakota | 46013 | 5095 | 85 |
1055971 | 1055971 | 2021-02-22 | Brown | South Dakota | 46013 | 5090 | 85 |
1052725 | 1052725 | 2021-02-21 | Brown | South Dakota | 46013 | 5085 | 85 |
1049478 | 1049478 | 2021-02-20 | Brown | South Dakota | 46013 | 5084 | 85 |
1046231 | 1046231 | 2021-02-19 | Brown | South Dakota | 46013 | 5080 | 84 |
1042986 | 1042986 | 2021-02-18 | Brown | South Dakota | 46013 | 5076 | 84 |
1039741 | 1039741 | 2021-02-17 | Brown | South Dakota | 46013 | 5071 | 83 |
1036496 | 1036496 | 2021-02-16 | Brown | South Dakota | 46013 | 5070 | 83 |
1033251 | 1033251 | 2021-02-15 | Brown | South Dakota | 46013 | 5066 | 83 |
1030005 | 1030005 | 2021-02-14 | Brown | South Dakota | 46013 | 5062 | 83 |
1026758 | 1026758 | 2021-02-13 | Brown | South Dakota | 46013 | 5055 | 81 |
1023513 | 1023513 | 2021-02-12 | Brown | South Dakota | 46013 | 5052 | 80 |
1020268 | 1020268 | 2021-02-11 | Brown | South Dakota | 46013 | 5038 | 80 |
1017023 | 1017023 | 2021-02-10 | Brown | South Dakota | 46013 | 5027 | 79 |
1013778 | 1013778 | 2021-02-09 | Brown | South Dakota | 46013 | 5018 | 79 |
1010533 | 1010533 | 2021-02-08 | Brown | South Dakota | 46013 | 5017 | 79 |
1007287 | 1007287 | 2021-02-07 | Brown | South Dakota | 46013 | 5016 | 79 |
1004041 | 1004041 | 2021-02-06 | Brown | South Dakota | 46013 | 5008 | 79 |
1000795 | 1000795 | 2021-02-05 | Brown | South Dakota | 46013 | 4992 | 79 |
997549 | 997549 | 2021-02-04 | Brown | South Dakota | 46013 | 4986 | 80 |
994303 | 994303 | 2021-02-03 | Brown | South Dakota | 46013 | 4966 | 80 |
991057 | 991057 | 2021-02-02 | Brown | South Dakota | 46013 | 4952 | 80 |
987811 | 987811 | 2021-02-01 | Brown | South Dakota | 46013 | 4940 | 80 |
984564 | 984564 | 2021-01-31 | Brown | South Dakota | 46013 | 4937 | 80 |
981317 | 981317 | 2021-01-30 | Brown | South Dakota | 46013 | 4925 | 79 |
978071 | 978071 | 2021-01-29 | Brown | South Dakota | 46013 | 4915 | 79 |
974826 | 974826 | 2021-01-28 | Brown | South Dakota | 46013 | 4899 | 79 |
971581 | 971581 | 2021-01-27 | Brown | South Dakota | 46013 | 4879 | 77 |
968336 | 968336 | 2021-01-26 | Brown | South Dakota | 46013 | 4860 | 75 |
965092 | 965092 | 2021-01-25 | Brown | South Dakota | 46013 | 4846 | 75 |
961847 | 961847 | 2021-01-24 | Brown | South Dakota | 46013 | 4844 | 75 |
958602 | 958602 | 2021-01-23 | Brown | South Dakota | 46013 | 4832 | 75 |
955356 | 955356 | 2021-01-22 | Brown | South Dakota | 46013 | 4825 | 75 |
952111 | 952111 | 2021-01-21 | Brown | South Dakota | 46013 | 4811 | 75 |
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);