ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 32003 and state = "Nevada" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418893 | 1418893 | 2021-06-14 | Clark | Nevada | 32003 | 254376 | 4443 |
1415648 | 1415648 | 2021-06-13 | Clark | Nevada | 32003 | 253969 | 4440 |
1412402 | 1412402 | 2021-06-12 | Clark | Nevada | 32003 | 253969 | 4440 |
1409157 | 1409157 | 2021-06-11 | Clark | Nevada | 32003 | 253969 | 4440 |
1405912 | 1405912 | 2021-06-10 | Clark | Nevada | 32003 | 253754 | 4439 |
1402666 | 1402666 | 2021-06-09 | Clark | Nevada | 32003 | 253506 | 4435 |
1399421 | 1399421 | 2021-06-08 | Clark | Nevada | 32003 | 253297 | 4428 |
1396175 | 1396175 | 2021-06-07 | Clark | Nevada | 32003 | 253006 | 4424 |
1392929 | 1392929 | 2021-06-06 | Clark | Nevada | 32003 | 252450 | 4420 |
1389684 | 1389684 | 2021-06-05 | Clark | Nevada | 32003 | 252450 | 4420 |
1386439 | 1386439 | 2021-06-04 | Clark | Nevada | 32003 | 252450 | 4420 |
1383194 | 1383194 | 2021-06-03 | Clark | Nevada | 32003 | 252137 | 4419 |
1379948 | 1379948 | 2021-06-02 | Clark | Nevada | 32003 | 251809 | 4413 |
1376703 | 1376703 | 2021-06-01 | Clark | Nevada | 32003 | 251460 | 4410 |
1373457 | 1373457 | 2021-05-31 | Clark | Nevada | 32003 | 251012 | 4406 |
1370212 | 1370212 | 2021-05-30 | Clark | Nevada | 32003 | 251012 | 4406 |
1366966 | 1366966 | 2021-05-29 | Clark | Nevada | 32003 | 251012 | 4406 |
1363720 | 1363720 | 2021-05-28 | Clark | Nevada | 32003 | 251012 | 4406 |
1360474 | 1360474 | 2021-05-27 | Clark | Nevada | 32003 | 250785 | 4399 |
1357228 | 1357228 | 2021-05-26 | Clark | Nevada | 32003 | 250573 | 4393 |
1353982 | 1353982 | 2021-05-25 | Clark | Nevada | 32003 | 250386 | 4387 |
1350736 | 1350736 | 2021-05-24 | Clark | Nevada | 32003 | 250169 | 4383 |
1347490 | 1347490 | 2021-05-23 | Clark | Nevada | 32003 | 249831 | 4376 |
1344242 | 1344242 | 2021-05-22 | Clark | Nevada | 32003 | 249831 | 4376 |
1340994 | 1340994 | 2021-05-21 | Clark | Nevada | 32003 | 249831 | 4376 |
1337746 | 1337746 | 2021-05-20 | Clark | Nevada | 32003 | 249573 | 4375 |
1334499 | 1334499 | 2021-05-19 | Clark | Nevada | 32003 | 249295 | 4370 |
1331252 | 1331252 | 2021-05-18 | Clark | Nevada | 32003 | 249011 | 4366 |
1328005 | 1328005 | 2021-05-17 | Clark | Nevada | 32003 | 248793 | 4360 |
1324759 | 1324759 | 2021-05-16 | Clark | Nevada | 32003 | 248336 | 4358 |
1321513 | 1321513 | 2021-05-15 | Clark | Nevada | 32003 | 248336 | 4358 |
1318267 | 1318267 | 2021-05-14 | Clark | Nevada | 32003 | 248336 | 4358 |
1315019 | 1315019 | 2021-05-13 | Clark | Nevada | 32003 | 248006 | 4351 |
1311773 | 1311773 | 2021-05-12 | Clark | Nevada | 32003 | 247606 | 4345 |
1308526 | 1308526 | 2021-05-11 | Clark | Nevada | 32003 | 247186 | 4342 |
1305280 | 1305280 | 2021-05-10 | Clark | Nevada | 32003 | 246811 | 4339 |
1302034 | 1302034 | 2021-05-09 | Clark | Nevada | 32003 | 246106 | 4330 |
1298786 | 1298786 | 2021-05-08 | Clark | Nevada | 32003 | 246106 | 4330 |
1295540 | 1295540 | 2021-05-07 | Clark | Nevada | 32003 | 246106 | 4330 |
1292294 | 1292294 | 2021-05-06 | Clark | Nevada | 32003 | 245693 | 4323 |
1289048 | 1289048 | 2021-05-05 | Clark | Nevada | 32003 | 245358 | 4322 |
1285802 | 1285802 | 2021-05-04 | Clark | Nevada | 32003 | 245034 | 4315 |
1282556 | 1282556 | 2021-05-03 | Clark | Nevada | 32003 | 244647 | 4309 |
1279309 | 1279309 | 2021-05-02 | Clark | Nevada | 32003 | 243942 | 4300 |
1276062 | 1276062 | 2021-05-01 | Clark | Nevada | 32003 | 243942 | 4300 |
1272815 | 1272815 | 2021-04-30 | Clark | Nevada | 32003 | 243942 | 4300 |
1269568 | 1269568 | 2021-04-29 | Clark | Nevada | 32003 | 243550 | 4295 |
1266321 | 1266321 | 2021-04-28 | Clark | Nevada | 32003 | 243155 | 4284 |
1263074 | 1263074 | 2021-04-27 | Clark | Nevada | 32003 | 242819 | 4281 |
1259827 | 1259827 | 2021-04-26 | Clark | Nevada | 32003 | 242524 | 4271 |
1256580 | 1256580 | 2021-04-25 | Clark | Nevada | 32003 | 241814 | 4261 |
1253333 | 1253333 | 2021-04-24 | Clark | Nevada | 32003 | 241814 | 4261 |
1250086 | 1250086 | 2021-04-23 | Clark | Nevada | 32003 | 241814 | 4261 |
1246839 | 1246839 | 2021-04-22 | Clark | Nevada | 32003 | 241353 | 4239 |
1243592 | 1243592 | 2021-04-21 | Clark | Nevada | 32003 | 240909 | 4227 |
1240345 | 1240345 | 2021-04-20 | Clark | Nevada | 32003 | 240574 | 4218 |
1237098 | 1237098 | 2021-04-19 | Clark | Nevada | 32003 | 240307 | 4213 |
1233851 | 1233851 | 2021-04-18 | Clark | Nevada | 32003 | 239748 | 4211 |
1230603 | 1230603 | 2021-04-17 | Clark | Nevada | 32003 | 239748 | 4211 |
1227355 | 1227355 | 2021-04-16 | Clark | Nevada | 32003 | 239748 | 4211 |
1224107 | 1224107 | 2021-04-15 | Clark | Nevada | 32003 | 239293 | 4205 |
1220860 | 1220860 | 2021-04-14 | Clark | Nevada | 32003 | 238853 | 4198 |
1217612 | 1217612 | 2021-04-13 | Clark | Nevada | 32003 | 238555 | 4184 |
1214364 | 1214364 | 2021-04-12 | Clark | Nevada | 32003 | 238245 | 4178 |
1211117 | 1211117 | 2021-04-11 | Clark | Nevada | 32003 | 238008 | 4178 |
1207868 | 1207868 | 2021-04-10 | Clark | Nevada | 32003 | 237737 | 4178 |
1204620 | 1204620 | 2021-04-09 | Clark | Nevada | 32003 | 237037 | 4169 |
1201372 | 1201372 | 2021-04-08 | Clark | Nevada | 32003 | 236483 | 4161 |
1198123 | 1198123 | 2021-04-07 | Clark | Nevada | 32003 | 236130 | 4157 |
1194874 | 1194874 | 2021-04-06 | Clark | Nevada | 32003 | 235900 | 4146 |
1191625 | 1191625 | 2021-04-05 | Clark | Nevada | 32003 | 235695 | 4132 |
1188377 | 1188377 | 2021-04-04 | Clark | Nevada | 32003 | 235590 | 4132 |
1185130 | 1185130 | 2021-04-03 | Clark | Nevada | 32003 | 235444 | 4132 |
1181883 | 1181883 | 2021-04-02 | Clark | Nevada | 32003 | 235081 | 4119 |
1178636 | 1178636 | 2021-04-01 | Clark | Nevada | 32003 | 234803 | 4115 |
1175389 | 1175389 | 2021-03-31 | Clark | Nevada | 32003 | 234549 | 4108 |
1172142 | 1172142 | 2021-03-30 | Clark | Nevada | 32003 | 234300 | 4098 |
1168894 | 1168894 | 2021-03-29 | Clark | Nevada | 32003 | 234131 | 4097 |
1165646 | 1165646 | 2021-03-28 | Clark | Nevada | 32003 | 234031 | 4096 |
1162398 | 1162398 | 2021-03-27 | Clark | Nevada | 32003 | 233889 | 4095 |
1159150 | 1159150 | 2021-03-26 | Clark | Nevada | 32003 | 233671 | 4088 |
1155903 | 1155903 | 2021-03-25 | Clark | Nevada | 32003 | 233305 | 4079 |
1152656 | 1152656 | 2021-03-24 | Clark | Nevada | 32003 | 233110 | 4072 |
1149409 | 1149409 | 2021-03-23 | Clark | Nevada | 32003 | 232916 | 4062 |
1146162 | 1146162 | 2021-03-22 | Clark | Nevada | 32003 | 232808 | 4049 |
1142915 | 1142915 | 2021-03-21 | Clark | Nevada | 32003 | 232730 | 4048 |
1139668 | 1139668 | 2021-03-20 | Clark | Nevada | 32003 | 232595 | 4048 |
1136422 | 1136422 | 2021-03-19 | Clark | Nevada | 32003 | 232382 | 4043 |
1133176 | 1133176 | 2021-03-18 | Clark | Nevada | 32003 | 232174 | 4039 |
1129928 | 1129928 | 2021-03-17 | Clark | Nevada | 32003 | 231946 | 4032 |
1126681 | 1126681 | 2021-03-16 | Clark | Nevada | 32003 | 231710 | 4021 |
1123435 | 1123435 | 2021-03-15 | Clark | Nevada | 32003 | 231416 | 4007 |
1120188 | 1120188 | 2021-03-14 | Clark | Nevada | 32003 | 231277 | 4005 |
1116941 | 1116941 | 2021-03-13 | Clark | Nevada | 32003 | 231116 | 4005 |
1113695 | 1113695 | 2021-03-12 | Clark | Nevada | 32003 | 230758 | 3988 |
1110449 | 1110449 | 2021-03-11 | Clark | Nevada | 32003 | 229956 | 3971 |
1107203 | 1107203 | 2021-03-10 | Clark | Nevada | 32003 | 229415 | 3960 |
1103957 | 1103957 | 2021-03-09 | Clark | Nevada | 32003 | 229156 | 3947 |
1100711 | 1100711 | 2021-03-08 | Clark | Nevada | 32003 | 228806 | 3934 |
1097464 | 1097464 | 2021-03-07 | Clark | Nevada | 32003 | 228665 | 3931 |
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);