ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Calvert" and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418335 | 1418335 | 2021-06-14 | Calvert | Maryland | 24009 | 4234 | 85 |
1415090 | 1415090 | 2021-06-13 | Calvert | Maryland | 24009 | 4232 | 85 |
1411844 | 1411844 | 2021-06-12 | Calvert | Maryland | 24009 | 4231 | 85 |
1408599 | 1408599 | 2021-06-11 | Calvert | Maryland | 24009 | 4231 | 85 |
1405354 | 1405354 | 2021-06-10 | Calvert | Maryland | 24009 | 4228 | 85 |
1402108 | 1402108 | 2021-06-09 | Calvert | Maryland | 24009 | 4228 | 85 |
1398863 | 1398863 | 2021-06-08 | Calvert | Maryland | 24009 | 4226 | 85 |
1395617 | 1395617 | 2021-06-07 | Calvert | Maryland | 24009 | 4226 | 85 |
1392371 | 1392371 | 2021-06-06 | Calvert | Maryland | 24009 | 4223 | 85 |
1389126 | 1389126 | 2021-06-05 | Calvert | Maryland | 24009 | 4223 | 85 |
1385881 | 1385881 | 2021-06-04 | Calvert | Maryland | 24009 | 4222 | 85 |
1382636 | 1382636 | 2021-06-03 | Calvert | Maryland | 24009 | 4221 | 85 |
1379390 | 1379390 | 2021-06-02 | Calvert | Maryland | 24009 | 4220 | 85 |
1376145 | 1376145 | 2021-06-01 | Calvert | Maryland | 24009 | 4219 | 85 |
1372899 | 1372899 | 2021-05-31 | Calvert | Maryland | 24009 | 4218 | 85 |
1369654 | 1369654 | 2021-05-30 | Calvert | Maryland | 24009 | 4217 | 85 |
1366408 | 1366408 | 2021-05-29 | Calvert | Maryland | 24009 | 4216 | 85 |
1363162 | 1363162 | 2021-05-28 | Calvert | Maryland | 24009 | 4216 | 85 |
1359915 | 1359915 | 2021-05-27 | Calvert | Maryland | 24009 | 4215 | 85 |
1356669 | 1356669 | 2021-05-26 | Calvert | Maryland | 24009 | 4210 | 78 |
1353423 | 1353423 | 2021-05-25 | Calvert | Maryland | 24009 | 4210 | 78 |
1350177 | 1350177 | 2021-05-24 | Calvert | Maryland | 24009 | 4209 | 78 |
1346931 | 1346931 | 2021-05-23 | Calvert | Maryland | 24009 | 4208 | 78 |
1343683 | 1343683 | 2021-05-22 | Calvert | Maryland | 24009 | 4204 | 78 |
1340434 | 1340434 | 2021-05-21 | Calvert | Maryland | 24009 | 4200 | 78 |
1337187 | 1337187 | 2021-05-20 | Calvert | Maryland | 24009 | 4200 | 78 |
1333940 | 1333940 | 2021-05-19 | Calvert | Maryland | 24009 | 4198 | 78 |
1330693 | 1330693 | 2021-05-18 | Calvert | Maryland | 24009 | 4198 | 78 |
1327446 | 1327446 | 2021-05-17 | Calvert | Maryland | 24009 | 4198 | 78 |
1324200 | 1324200 | 2021-05-16 | Calvert | Maryland | 24009 | 4195 | 78 |
1320954 | 1320954 | 2021-05-15 | Calvert | Maryland | 24009 | 4192 | 78 |
1317708 | 1317708 | 2021-05-14 | Calvert | Maryland | 24009 | 4190 | 78 |
1314460 | 1314460 | 2021-05-13 | Calvert | Maryland | 24009 | 4185 | 78 |
1311214 | 1311214 | 2021-05-12 | Calvert | Maryland | 24009 | 4184 | 78 |
1307967 | 1307967 | 2021-05-11 | Calvert | Maryland | 24009 | 4182 | 78 |
1304721 | 1304721 | 2021-05-10 | Calvert | Maryland | 24009 | 4181 | 78 |
1301475 | 1301475 | 2021-05-09 | Calvert | Maryland | 24009 | 4180 | 78 |
1298227 | 1298227 | 2021-05-08 | Calvert | Maryland | 24009 | 4178 | 78 |
1294981 | 1294981 | 2021-05-07 | Calvert | Maryland | 24009 | 4176 | 78 |
1291735 | 1291735 | 2021-05-06 | Calvert | Maryland | 24009 | 4171 | 78 |
1288489 | 1288489 | 2021-05-05 | Calvert | Maryland | 24009 | 4170 | 78 |
1285243 | 1285243 | 2021-05-04 | Calvert | Maryland | 24009 | 4164 | 78 |
1281997 | 1281997 | 2021-05-03 | Calvert | Maryland | 24009 | 4162 | 78 |
1278750 | 1278750 | 2021-05-02 | Calvert | Maryland | 24009 | 4161 | 78 |
1275503 | 1275503 | 2021-05-01 | Calvert | Maryland | 24009 | 4155 | 78 |
1272256 | 1272256 | 2021-04-30 | Calvert | Maryland | 24009 | 4149 | 78 |
1269009 | 1269009 | 2021-04-29 | Calvert | Maryland | 24009 | 4140 | 78 |
1265762 | 1265762 | 2021-04-28 | Calvert | Maryland | 24009 | 4139 | 77 |
1262515 | 1262515 | 2021-04-27 | Calvert | Maryland | 24009 | 4135 | 77 |
1259268 | 1259268 | 2021-04-26 | Calvert | Maryland | 24009 | 4131 | 77 |
1256021 | 1256021 | 2021-04-25 | Calvert | Maryland | 24009 | 4122 | 77 |
1252774 | 1252774 | 2021-04-24 | Calvert | Maryland | 24009 | 4116 | 77 |
1249527 | 1249527 | 2021-04-23 | Calvert | Maryland | 24009 | 4103 | 77 |
1246280 | 1246280 | 2021-04-22 | Calvert | Maryland | 24009 | 4092 | 77 |
1243033 | 1243033 | 2021-04-21 | Calvert | Maryland | 24009 | 4082 | 76 |
1239786 | 1239786 | 2021-04-20 | Calvert | Maryland | 24009 | 4079 | 75 |
1236539 | 1236539 | 2021-04-19 | Calvert | Maryland | 24009 | 4067 | 75 |
1233292 | 1233292 | 2021-04-18 | Calvert | Maryland | 24009 | 4054 | 75 |
1230044 | 1230044 | 2021-04-17 | Calvert | Maryland | 24009 | 4048 | 75 |
1226796 | 1226796 | 2021-04-16 | Calvert | Maryland | 24009 | 4036 | 75 |
1223548 | 1223548 | 2021-04-15 | Calvert | Maryland | 24009 | 4027 | 75 |
1220301 | 1220301 | 2021-04-14 | Calvert | Maryland | 24009 | 4017 | 75 |
1217053 | 1217053 | 2021-04-13 | Calvert | Maryland | 24009 | 4010 | 74 |
1213806 | 1213806 | 2021-04-12 | Calvert | Maryland | 24009 | 4004 | 74 |
1210558 | 1210558 | 2021-04-11 | Calvert | Maryland | 24009 | 3995 | 74 |
1207309 | 1207309 | 2021-04-10 | Calvert | Maryland | 24009 | 3985 | 74 |
1204061 | 1204061 | 2021-04-09 | Calvert | Maryland | 24009 | 3978 | 74 |
1200813 | 1200813 | 2021-04-08 | Calvert | Maryland | 24009 | 3968 | 74 |
1197564 | 1197564 | 2021-04-07 | Calvert | Maryland | 24009 | 3961 | 74 |
1194315 | 1194315 | 2021-04-06 | Calvert | Maryland | 24009 | 3954 | 74 |
1191066 | 1191066 | 2021-04-05 | Calvert | Maryland | 24009 | 3952 | 74 |
1187818 | 1187818 | 2021-04-04 | Calvert | Maryland | 24009 | 3945 | 74 |
1184571 | 1184571 | 2021-04-03 | Calvert | Maryland | 24009 | 3933 | 74 |
1181325 | 1181325 | 2021-04-02 | Calvert | Maryland | 24009 | 3926 | 74 |
1178078 | 1178078 | 2021-04-01 | Calvert | Maryland | 24009 | 3924 | 74 |
1174831 | 1174831 | 2021-03-31 | Calvert | Maryland | 24009 | 3908 | 74 |
1171584 | 1171584 | 2021-03-30 | Calvert | Maryland | 24009 | 3904 | 74 |
1168336 | 1168336 | 2021-03-29 | Calvert | Maryland | 24009 | 3899 | 74 |
1165088 | 1165088 | 2021-03-28 | Calvert | Maryland | 24009 | 3892 | 74 |
1161840 | 1161840 | 2021-03-27 | Calvert | Maryland | 24009 | 3884 | 74 |
1158592 | 1158592 | 2021-03-26 | Calvert | Maryland | 24009 | 3870 | 74 |
1155345 | 1155345 | 2021-03-25 | Calvert | Maryland | 24009 | 3856 | 74 |
1152098 | 1152098 | 2021-03-24 | Calvert | Maryland | 24009 | 3844 | 74 |
1148851 | 1148851 | 2021-03-23 | Calvert | Maryland | 24009 | 3830 | 74 |
1145604 | 1145604 | 2021-03-22 | Calvert | Maryland | 24009 | 3822 | 74 |
1142357 | 1142357 | 2021-03-21 | Calvert | Maryland | 24009 | 3817 | 74 |
1139110 | 1139110 | 2021-03-20 | Calvert | Maryland | 24009 | 3806 | 74 |
1135864 | 1135864 | 2021-03-19 | Calvert | Maryland | 24009 | 3792 | 74 |
1132618 | 1132618 | 2021-03-18 | Calvert | Maryland | 24009 | 3784 | 73 |
1129370 | 1129370 | 2021-03-17 | Calvert | Maryland | 24009 | 3774 | 73 |
1126123 | 1126123 | 2021-03-16 | Calvert | Maryland | 24009 | 3768 | 73 |
1122877 | 1122877 | 2021-03-15 | Calvert | Maryland | 24009 | 3758 | 73 |
1119630 | 1119630 | 2021-03-14 | Calvert | Maryland | 24009 | 3756 | 73 |
1116383 | 1116383 | 2021-03-13 | Calvert | Maryland | 24009 | 3748 | 73 |
1113137 | 1113137 | 2021-03-12 | Calvert | Maryland | 24009 | 3742 | 73 |
1109891 | 1109891 | 2021-03-11 | Calvert | Maryland | 24009 | 3737 | 73 |
1106645 | 1106645 | 2021-03-10 | Calvert | Maryland | 24009 | 3719 | 73 |
1103399 | 1103399 | 2021-03-09 | Calvert | Maryland | 24009 | 3715 | 73 |
1100153 | 1100153 | 2021-03-08 | Calvert | Maryland | 24009 | 3711 | 72 |
1096906 | 1096906 | 2021-03-07 | Calvert | Maryland | 24009 | 3702 | 72 |
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);