ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Nevada" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417344 | 1417344 | 2021-06-14 | Nevada | California | 6057 | 4883 | 75 |
1414098 | 1414098 | 2021-06-13 | Nevada | California | 6057 | 4878 | 75 |
1410853 | 1410853 | 2021-06-12 | Nevada | California | 6057 | 4873 | 75 |
1407608 | 1407608 | 2021-06-11 | Nevada | California | 6057 | 4866 | 75 |
1404362 | 1404362 | 2021-06-10 | Nevada | California | 6057 | 4865 | 75 |
1401117 | 1401117 | 2021-06-09 | Nevada | California | 6057 | 4861 | 75 |
1397872 | 1397872 | 2021-06-08 | Nevada | California | 6057 | 4860 | 75 |
1394625 | 1394625 | 2021-06-07 | Nevada | California | 6057 | 4854 | 75 |
1391380 | 1391380 | 2021-06-06 | Nevada | California | 6057 | 4849 | 75 |
1388135 | 1388135 | 2021-06-05 | Nevada | California | 6057 | 4844 | 75 |
1384890 | 1384890 | 2021-06-04 | Nevada | California | 6057 | 4837 | 75 |
1381644 | 1381644 | 2021-06-03 | Nevada | California | 6057 | 4833 | 75 |
1378399 | 1378399 | 2021-06-02 | Nevada | California | 6057 | 4825 | 75 |
1375153 | 1375153 | 2021-06-01 | Nevada | California | 6057 | 4823 | 75 |
1371908 | 1371908 | 2021-05-31 | Nevada | California | 6057 | 4818 | 75 |
1368663 | 1368663 | 2021-05-30 | Nevada | California | 6057 | 4816 | 75 |
1365417 | 1365417 | 2021-05-29 | Nevada | California | 6057 | 4813 | 75 |
1362171 | 1362171 | 2021-05-28 | Nevada | California | 6057 | 4807 | 75 |
1358924 | 1358924 | 2021-05-27 | Nevada | California | 6057 | 4803 | 75 |
1355678 | 1355678 | 2021-05-26 | Nevada | California | 6057 | 4795 | 75 |
1352432 | 1352432 | 2021-05-25 | Nevada | California | 6057 | 4790 | 75 |
1349186 | 1349186 | 2021-05-24 | Nevada | California | 6057 | 4790 | 75 |
1345939 | 1345939 | 2021-05-23 | Nevada | California | 6057 | 4787 | 75 |
1342691 | 1342691 | 2021-05-22 | Nevada | California | 6057 | 4779 | 75 |
1339443 | 1339443 | 2021-05-21 | Nevada | California | 6057 | 4775 | 75 |
1336196 | 1336196 | 2021-05-20 | Nevada | California | 6057 | 4769 | 75 |
1332949 | 1332949 | 2021-05-19 | Nevada | California | 6057 | 4765 | 75 |
1329702 | 1329702 | 2021-05-18 | Nevada | California | 6057 | 4761 | 75 |
1326455 | 1326455 | 2021-05-17 | Nevada | California | 6057 | 4755 | 75 |
1323209 | 1323209 | 2021-05-16 | Nevada | California | 6057 | 4755 | 75 |
1319963 | 1319963 | 2021-05-15 | Nevada | California | 6057 | 4745 | 75 |
1316716 | 1316716 | 2021-05-14 | Nevada | California | 6057 | 4743 | 75 |
1313469 | 1313469 | 2021-05-13 | Nevada | California | 6057 | 4739 | 75 |
1310222 | 1310222 | 2021-05-12 | Nevada | California | 6057 | 4739 | 75 |
1306976 | 1306976 | 2021-05-11 | Nevada | California | 6057 | 4736 | 75 |
1303730 | 1303730 | 2021-05-10 | Nevada | California | 6057 | 4727 | 75 |
1300483 | 1300483 | 2021-05-09 | Nevada | California | 6057 | 4716 | 75 |
1297236 | 1297236 | 2021-05-08 | Nevada | California | 6057 | 4704 | 75 |
1293990 | 1293990 | 2021-05-07 | Nevada | California | 6057 | 4687 | 75 |
1290744 | 1290744 | 2021-05-06 | Nevada | California | 6057 | 4666 | 75 |
1287498 | 1287498 | 2021-05-05 | Nevada | California | 6057 | 4656 | 75 |
1284252 | 1284252 | 2021-05-04 | Nevada | California | 6057 | 4650 | 75 |
1281005 | 1281005 | 2021-05-03 | Nevada | California | 6057 | 4635 | 75 |
1277758 | 1277758 | 2021-05-02 | Nevada | California | 6057 | 4625 | 75 |
1274511 | 1274511 | 2021-05-01 | Nevada | California | 6057 | 4608 | 75 |
1271264 | 1271264 | 2021-04-30 | Nevada | California | 6057 | 4590 | 75 |
1268017 | 1268017 | 2021-04-29 | Nevada | California | 6057 | 4570 | 75 |
1264770 | 1264770 | 2021-04-28 | Nevada | California | 6057 | 4557 | 75 |
1261523 | 1261523 | 2021-04-27 | Nevada | California | 6057 | 4548 | 75 |
1258276 | 1258276 | 2021-04-26 | Nevada | California | 6057 | 4536 | 75 |
1255029 | 1255029 | 2021-04-25 | Nevada | California | 6057 | 4522 | 75 |
1251782 | 1251782 | 2021-04-24 | Nevada | California | 6057 | 4510 | 75 |
1248535 | 1248535 | 2021-04-23 | Nevada | California | 6057 | 4504 | 75 |
1245288 | 1245288 | 2021-04-22 | Nevada | California | 6057 | 4499 | 75 |
1242041 | 1242041 | 2021-04-21 | Nevada | California | 6057 | 4485 | 75 |
1238794 | 1238794 | 2021-04-20 | Nevada | California | 6057 | 4477 | 75 |
1235547 | 1235547 | 2021-04-19 | Nevada | California | 6057 | 4464 | 75 |
1232300 | 1232300 | 2021-04-18 | Nevada | California | 6057 | 4457 | 75 |
1229051 | 1229051 | 2021-04-17 | Nevada | California | 6057 | 4447 | 75 |
1225803 | 1225803 | 2021-04-16 | Nevada | California | 6057 | 4447 | 75 |
1222556 | 1222556 | 2021-04-15 | Nevada | California | 6057 | 4437 | 75 |
1219308 | 1219308 | 2021-04-14 | Nevada | California | 6057 | 4425 | 75 |
1216060 | 1216060 | 2021-04-13 | Nevada | California | 6057 | 4418 | 75 |
1212813 | 1212813 | 2021-04-12 | Nevada | California | 6057 | 4411 | 75 |
1209565 | 1209565 | 2021-04-11 | Nevada | California | 6057 | 4379 | 75 |
1206316 | 1206316 | 2021-04-10 | Nevada | California | 6057 | 4379 | 75 |
1203068 | 1203068 | 2021-04-09 | Nevada | California | 6057 | 4379 | 75 |
1199820 | 1199820 | 2021-04-08 | Nevada | California | 6057 | 4373 | 75 |
1196571 | 1196571 | 2021-04-07 | Nevada | California | 6057 | 4370 | 75 |
1193323 | 1193323 | 2021-04-06 | Nevada | California | 6057 | 4361 | 75 |
1190073 | 1190073 | 2021-04-05 | Nevada | California | 6057 | 4352 | 74 |
1186826 | 1186826 | 2021-04-04 | Nevada | California | 6057 | 4323 | 74 |
1183579 | 1183579 | 2021-04-03 | Nevada | California | 6057 | 4323 | 74 |
1180332 | 1180332 | 2021-04-02 | Nevada | California | 6057 | 4316 | 74 |
1177085 | 1177085 | 2021-04-01 | Nevada | California | 6057 | 4294 | 74 |
1173838 | 1173838 | 2021-03-31 | Nevada | California | 6057 | 4281 | 74 |
1170591 | 1170591 | 2021-03-30 | Nevada | California | 6057 | 4272 | 74 |
1167343 | 1167343 | 2021-03-29 | Nevada | California | 6057 | 4256 | 74 |
1164095 | 1164095 | 2021-03-28 | Nevada | California | 6057 | 4231 | 74 |
1160847 | 1160847 | 2021-03-27 | Nevada | California | 6057 | 4222 | 83 |
1157599 | 1157599 | 2021-03-26 | Nevada | California | 6057 | 4219 | 84 |
1154352 | 1154352 | 2021-03-25 | Nevada | California | 6057 | 4203 | 85 |
1151105 | 1151105 | 2021-03-24 | Nevada | California | 6057 | 4197 | 89 |
1147858 | 1147858 | 2021-03-23 | Nevada | California | 6057 | 4188 | 89 |
1144611 | 1144611 | 2021-03-22 | Nevada | California | 6057 | 4179 | 89 |
1141364 | 1141364 | 2021-03-21 | Nevada | California | 6057 | 4164 | 89 |
1138118 | 1138118 | 2021-03-20 | Nevada | California | 6057 | 4162 | 88 |
1134872 | 1134872 | 2021-03-19 | Nevada | California | 6057 | 4162 | 74 |
1131625 | 1131625 | 2021-03-18 | Nevada | California | 6057 | 4160 | 74 |
1128377 | 1128377 | 2021-03-17 | Nevada | California | 6057 | 4143 | 74 |
1125131 | 1125131 | 2021-03-16 | Nevada | California | 6057 | 4136 | 74 |
1121885 | 1121885 | 2021-03-15 | Nevada | California | 6057 | 4125 | 74 |
1118638 | 1118638 | 2021-03-14 | Nevada | California | 6057 | 4111 | 74 |
1115391 | 1115391 | 2021-03-13 | Nevada | California | 6057 | 4101 | 74 |
1112145 | 1112145 | 2021-03-12 | Nevada | California | 6057 | 4097 | 74 |
1108899 | 1108899 | 2021-03-11 | Nevada | California | 6057 | 4086 | 74 |
1105653 | 1105653 | 2021-03-10 | Nevada | California | 6057 | 4070 | 74 |
1102407 | 1102407 | 2021-03-09 | Nevada | California | 6057 | 4066 | 74 |
1099161 | 1099161 | 2021-03-08 | Nevada | California | 6057 | 4060 | 74 |
1095913 | 1095913 | 2021-03-07 | Nevada | California | 6057 | 4044 | 74 |
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);