ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where state = "District of Columbia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417451 | 1417451 | 2021-06-14 | District of Columbia | District of Columbia | 11001 | 49179 | 1138 |
1414205 | 1414205 | 2021-06-13 | District of Columbia | District of Columbia | 11001 | 49158 | 1137 |
1410960 | 1410960 | 2021-06-12 | District of Columbia | District of Columbia | 11001 | 49158 | 1137 |
1407715 | 1407715 | 2021-06-11 | District of Columbia | District of Columbia | 11001 | 49158 | 1137 |
1404469 | 1404469 | 2021-06-10 | District of Columbia | District of Columbia | 11001 | 49151 | 1137 |
1401224 | 1401224 | 2021-06-09 | District of Columbia | District of Columbia | 11001 | 49127 | 1137 |
1397979 | 1397979 | 2021-06-08 | District of Columbia | District of Columbia | 11001 | 49119 | 1137 |
1394732 | 1394732 | 2021-06-07 | District of Columbia | District of Columbia | 11001 | 49110 | 1136 |
1391487 | 1391487 | 2021-06-06 | District of Columbia | District of Columbia | 11001 | 49068 | 1136 |
1388242 | 1388242 | 2021-06-05 | District of Columbia | District of Columbia | 11001 | 49068 | 1136 |
1384997 | 1384997 | 2021-06-04 | District of Columbia | District of Columbia | 11001 | 49068 | 1136 |
1381751 | 1381751 | 2021-06-03 | District of Columbia | District of Columbia | 11001 | 49041 | 1136 |
1378506 | 1378506 | 2021-06-02 | District of Columbia | District of Columbia | 11001 | 49011 | 1135 |
1375260 | 1375260 | 2021-06-01 | District of Columbia | District of Columbia | 11001 | 49000 | 1134 |
1372015 | 1372015 | 2021-05-31 | District of Columbia | District of Columbia | 11001 | 48898 | 1132 |
1368770 | 1368770 | 2021-05-30 | District of Columbia | District of Columbia | 11001 | 48898 | 1132 |
1365524 | 1365524 | 2021-05-29 | District of Columbia | District of Columbia | 11001 | 48898 | 1132 |
1362278 | 1362278 | 2021-05-28 | District of Columbia | District of Columbia | 11001 | 48898 | 1132 |
1359031 | 1359031 | 2021-05-27 | District of Columbia | District of Columbia | 11001 | 48844 | 1132 |
1355785 | 1355785 | 2021-05-26 | District of Columbia | District of Columbia | 11001 | 48822 | 1131 |
1352539 | 1352539 | 2021-05-25 | District of Columbia | District of Columbia | 11001 | 48803 | 1130 |
1349293 | 1349293 | 2021-05-24 | District of Columbia | District of Columbia | 11001 | 48762 | 1130 |
1346046 | 1346046 | 2021-05-23 | District of Columbia | District of Columbia | 11001 | 48748 | 1127 |
1342798 | 1342798 | 2021-05-22 | District of Columbia | District of Columbia | 11001 | 48727 | 1125 |
1339550 | 1339550 | 2021-05-21 | District of Columbia | District of Columbia | 11001 | 48689 | 1125 |
1336303 | 1336303 | 2021-05-20 | District of Columbia | District of Columbia | 11001 | 48662 | 1125 |
1333056 | 1333056 | 2021-05-19 | District of Columbia | District of Columbia | 11001 | 48634 | 1124 |
1329809 | 1329809 | 2021-05-18 | District of Columbia | District of Columbia | 11001 | 48616 | 1122 |
1326562 | 1326562 | 2021-05-17 | District of Columbia | District of Columbia | 11001 | 48590 | 1122 |
1323316 | 1323316 | 2021-05-16 | District of Columbia | District of Columbia | 11001 | 48545 | 1120 |
1320070 | 1320070 | 2021-05-15 | District of Columbia | District of Columbia | 11001 | 48530 | 1118 |
1316823 | 1316823 | 2021-05-14 | District of Columbia | District of Columbia | 11001 | 48424 | 1116 |
1313576 | 1313576 | 2021-05-13 | District of Columbia | District of Columbia | 11001 | 48404 | 1115 |
1310329 | 1310329 | 2021-05-12 | District of Columbia | District of Columbia | 11001 | 48336 | 1115 |
1307083 | 1307083 | 2021-05-11 | District of Columbia | District of Columbia | 11001 | 48282 | 1113 |
1303837 | 1303837 | 2021-05-10 | District of Columbia | District of Columbia | 11001 | 48195 | 1110 |
1300590 | 1300590 | 2021-05-09 | District of Columbia | District of Columbia | 11001 | 48180 | 1110 |
1297343 | 1297343 | 2021-05-08 | District of Columbia | District of Columbia | 11001 | 48164 | 1110 |
1294097 | 1294097 | 2021-05-07 | District of Columbia | District of Columbia | 11001 | 48136 | 1110 |
1290851 | 1290851 | 2021-05-06 | District of Columbia | District of Columbia | 11001 | 48080 | 1110 |
1287605 | 1287605 | 2021-05-05 | District of Columbia | District of Columbia | 11001 | 48041 | 1109 |
1284359 | 1284359 | 2021-05-04 | District of Columbia | District of Columbia | 11001 | 47986 | 1106 |
1281112 | 1281112 | 2021-05-03 | District of Columbia | District of Columbia | 11001 | 47903 | 1106 |
1277865 | 1277865 | 2021-05-02 | District of Columbia | District of Columbia | 11001 | 47855 | 1106 |
1274618 | 1274618 | 2021-05-01 | District of Columbia | District of Columbia | 11001 | 47800 | 1106 |
1271371 | 1271371 | 2021-04-30 | District of Columbia | District of Columbia | 11001 | 47697 | 1105 |
1268124 | 1268124 | 2021-04-29 | District of Columbia | District of Columbia | 11001 | 47614 | 1105 |
1264877 | 1264877 | 2021-04-28 | District of Columbia | District of Columbia | 11001 | 47533 | 1104 |
1261630 | 1261630 | 2021-04-27 | District of Columbia | District of Columbia | 11001 | 47471 | 1100 |
1258383 | 1258383 | 2021-04-26 | District of Columbia | District of Columbia | 11001 | 47378 | 1099 |
1255136 | 1255136 | 2021-04-25 | District of Columbia | District of Columbia | 11001 | 47323 | 1099 |
1251889 | 1251889 | 2021-04-24 | District of Columbia | District of Columbia | 11001 | 47219 | 1099 |
1248642 | 1248642 | 2021-04-23 | District of Columbia | District of Columbia | 11001 | 47141 | 1099 |
1245395 | 1245395 | 2021-04-22 | District of Columbia | District of Columbia | 11001 | 47040 | 1098 |
1242148 | 1242148 | 2021-04-21 | District of Columbia | District of Columbia | 11001 | 46941 | 1097 |
1238901 | 1238901 | 2021-04-20 | District of Columbia | District of Columbia | 11001 | 46869 | 1097 |
1235654 | 1235654 | 2021-04-19 | District of Columbia | District of Columbia | 11001 | 46740 | 1096 |
1232407 | 1232407 | 2021-04-18 | District of Columbia | District of Columbia | 11001 | 46662 | 1096 |
1229158 | 1229158 | 2021-04-17 | District of Columbia | District of Columbia | 11001 | 46579 | 1095 |
1225910 | 1225910 | 2021-04-16 | District of Columbia | District of Columbia | 11001 | 46449 | 1093 |
1222663 | 1222663 | 2021-04-15 | District of Columbia | District of Columbia | 11001 | 46315 | 1090 |
1219415 | 1219415 | 2021-04-14 | District of Columbia | District of Columbia | 11001 | 46209 | 1088 |
1216167 | 1216167 | 2021-04-13 | District of Columbia | District of Columbia | 11001 | 46016 | 1085 |
1212920 | 1212920 | 2021-04-12 | District of Columbia | District of Columbia | 11001 | 45903 | 1084 |
1209672 | 1209672 | 2021-04-11 | District of Columbia | District of Columbia | 11001 | 45830 | 1081 |
1206423 | 1206423 | 2021-04-10 | District of Columbia | District of Columbia | 11001 | 45762 | 1081 |
1203175 | 1203175 | 2021-04-09 | District of Columbia | District of Columbia | 11001 | 45634 | 1079 |
1199927 | 1199927 | 2021-04-08 | District of Columbia | District of Columbia | 11001 | 45498 | 1077 |
1196678 | 1196678 | 2021-04-07 | District of Columbia | District of Columbia | 11001 | 45328 | 1076 |
1193430 | 1193430 | 2021-04-06 | District of Columbia | District of Columbia | 11001 | 45234 | 1074 |
1190180 | 1190180 | 2021-04-05 | District of Columbia | District of Columbia | 11001 | 45112 | 1072 |
1186933 | 1186933 | 2021-04-04 | District of Columbia | District of Columbia | 11001 | 45037 | 1070 |
1183686 | 1183686 | 2021-04-03 | District of Columbia | District of Columbia | 11001 | 44932 | 1070 |
1180439 | 1180439 | 2021-04-02 | District of Columbia | District of Columbia | 11001 | 44807 | 1069 |
1177192 | 1177192 | 2021-04-01 | District of Columbia | District of Columbia | 11001 | 44656 | 1066 |
1173945 | 1173945 | 2021-03-31 | District of Columbia | District of Columbia | 11001 | 44513 | 1064 |
1170698 | 1170698 | 2021-03-30 | District of Columbia | District of Columbia | 11001 | 44413 | 1061 |
1167450 | 1167450 | 2021-03-29 | District of Columbia | District of Columbia | 11001 | 44248 | 1059 |
1164202 | 1164202 | 2021-03-28 | District of Columbia | District of Columbia | 11001 | 44175 | 1056 |
1160954 | 1160954 | 2021-03-27 | District of Columbia | District of Columbia | 11001 | 44051 | 1056 |
1157706 | 1157706 | 2021-03-26 | District of Columbia | District of Columbia | 11001 | 43825 | 1055 |
1154459 | 1154459 | 2021-03-25 | District of Columbia | District of Columbia | 11001 | 43669 | 1053 |
1151212 | 1151212 | 2021-03-24 | District of Columbia | District of Columbia | 11001 | 43595 | 1053 |
1147965 | 1147965 | 2021-03-23 | District of Columbia | District of Columbia | 11001 | 43488 | 1051 |
1144718 | 1144718 | 2021-03-22 | District of Columbia | District of Columbia | 11001 | 43383 | 1050 |
1141471 | 1141471 | 2021-03-21 | District of Columbia | District of Columbia | 11001 | 43229 | 1050 |
1138225 | 1138225 | 2021-03-20 | District of Columbia | District of Columbia | 11001 | 43175 | 1049 |
1134979 | 1134979 | 2021-03-19 | District of Columbia | District of Columbia | 11001 | 43034 | 1047 |
1131732 | 1131732 | 2021-03-18 | District of Columbia | District of Columbia | 11001 | 42892 | 1046 |
1128484 | 1128484 | 2021-03-17 | District of Columbia | District of Columbia | 11001 | 42811 | 1044 |
1125238 | 1125238 | 2021-03-16 | District of Columbia | District of Columbia | 11001 | 42730 | 1042 |
1121992 | 1121992 | 2021-03-15 | District of Columbia | District of Columbia | 11001 | 42623 | 1042 |
1118745 | 1118745 | 2021-03-14 | District of Columbia | District of Columbia | 11001 | 42511 | 1041 |
1115498 | 1115498 | 2021-03-13 | District of Columbia | District of Columbia | 11001 | 42432 | 1040 |
1112252 | 1112252 | 2021-03-12 | District of Columbia | District of Columbia | 11001 | 42282 | 1038 |
1109006 | 1109006 | 2021-03-11 | District of Columbia | District of Columbia | 11001 | 42128 | 1038 |
1105760 | 1105760 | 2021-03-10 | District of Columbia | District of Columbia | 11001 | 42006 | 1037 |
1102514 | 1102514 | 2021-03-09 | District of Columbia | District of Columbia | 11001 | 41910 | 1036 |
1099268 | 1099268 | 2021-03-08 | District of Columbia | District of Columbia | 11001 | 41579 | 1035 |
1096020 | 1096020 | 2021-03-07 | District of Columbia | District of Columbia | 11001 | 41419 | 1030 |
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);