ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Fairfield" and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417438 | 1417438 | 2021-06-14 | Fairfield | Connecticut | 9001 | 100293 | 2201 |
1414192 | 1414192 | 2021-06-13 | Fairfield | Connecticut | 9001 | 100257 | 2201 |
1410947 | 1410947 | 2021-06-12 | Fairfield | Connecticut | 9001 | 100257 | 2201 |
1407702 | 1407702 | 2021-06-11 | Fairfield | Connecticut | 9001 | 100257 | 2201 |
1404456 | 1404456 | 2021-06-10 | Fairfield | Connecticut | 9001 | 100247 | 2201 |
1401211 | 1401211 | 2021-06-09 | Fairfield | Connecticut | 9001 | 100226 | 2201 |
1397966 | 1397966 | 2021-06-08 | Fairfield | Connecticut | 9001 | 100200 | 2201 |
1394719 | 1394719 | 2021-06-07 | Fairfield | Connecticut | 9001 | 100188 | 2200 |
1391474 | 1391474 | 2021-06-06 | Fairfield | Connecticut | 9001 | 100155 | 2198 |
1388229 | 1388229 | 2021-06-05 | Fairfield | Connecticut | 9001 | 100155 | 2198 |
1384984 | 1384984 | 2021-06-04 | Fairfield | Connecticut | 9001 | 100155 | 2198 |
1381738 | 1381738 | 2021-06-03 | Fairfield | Connecticut | 9001 | 100093 | 2198 |
1378493 | 1378493 | 2021-06-02 | Fairfield | Connecticut | 9001 | 100082 | 2199 |
1375247 | 1375247 | 2021-06-01 | Fairfield | Connecticut | 9001 | 100048 | 2197 |
1372002 | 1372002 | 2021-05-31 | Fairfield | Connecticut | 9001 | 99995 | 2196 |
1368757 | 1368757 | 2021-05-30 | Fairfield | Connecticut | 9001 | 99995 | 2196 |
1365511 | 1365511 | 2021-05-29 | Fairfield | Connecticut | 9001 | 99995 | 2196 |
1362265 | 1362265 | 2021-05-28 | Fairfield | Connecticut | 9001 | 99995 | 2196 |
1359018 | 1359018 | 2021-05-27 | Fairfield | Connecticut | 9001 | 99951 | 2196 |
1355772 | 1355772 | 2021-05-26 | Fairfield | Connecticut | 9001 | 99916 | 2195 |
1352526 | 1352526 | 2021-05-25 | Fairfield | Connecticut | 9001 | 99903 | 2193 |
1349280 | 1349280 | 2021-05-24 | Fairfield | Connecticut | 9001 | 99867 | 2192 |
1346033 | 1346033 | 2021-05-23 | Fairfield | Connecticut | 9001 | 99788 | 2187 |
1342785 | 1342785 | 2021-05-22 | Fairfield | Connecticut | 9001 | 99788 | 2187 |
1339537 | 1339537 | 2021-05-21 | Fairfield | Connecticut | 9001 | 99788 | 2187 |
1336290 | 1336290 | 2021-05-20 | Fairfield | Connecticut | 9001 | 99736 | 2186 |
1333043 | 1333043 | 2021-05-19 | Fairfield | Connecticut | 9001 | 99703 | 2185 |
1329796 | 1329796 | 2021-05-18 | Fairfield | Connecticut | 9001 | 99667 | 2182 |
1326549 | 1326549 | 2021-05-17 | Fairfield | Connecticut | 9001 | 99646 | 2181 |
1323303 | 1323303 | 2021-05-16 | Fairfield | Connecticut | 9001 | 99495 | 2176 |
1320057 | 1320057 | 2021-05-15 | Fairfield | Connecticut | 9001 | 99495 | 2176 |
1316810 | 1316810 | 2021-05-14 | Fairfield | Connecticut | 9001 | 99495 | 2176 |
1313563 | 1313563 | 2021-05-13 | Fairfield | Connecticut | 9001 | 99436 | 2176 |
1310316 | 1310316 | 2021-05-12 | Fairfield | Connecticut | 9001 | 99275 | 2176 |
1307070 | 1307070 | 2021-05-11 | Fairfield | Connecticut | 9001 | 99238 | 2175 |
1303824 | 1303824 | 2021-05-10 | Fairfield | Connecticut | 9001 | 99161 | 2174 |
1300577 | 1300577 | 2021-05-09 | Fairfield | Connecticut | 9001 | 98965 | 2173 |
1297330 | 1297330 | 2021-05-08 | Fairfield | Connecticut | 9001 | 98965 | 2173 |
1294084 | 1294084 | 2021-05-07 | Fairfield | Connecticut | 9001 | 98965 | 2173 |
1290838 | 1290838 | 2021-05-06 | Fairfield | Connecticut | 9001 | 98850 | 2169 |
1287592 | 1287592 | 2021-05-05 | Fairfield | Connecticut | 9001 | 98651 | 2168 |
1284346 | 1284346 | 2021-05-04 | Fairfield | Connecticut | 9001 | 98503 | 2168 |
1281099 | 1281099 | 2021-05-03 | Fairfield | Connecticut | 9001 | 98443 | 2167 |
1277852 | 1277852 | 2021-05-02 | Fairfield | Connecticut | 9001 | 98131 | 2165 |
1274605 | 1274605 | 2021-05-01 | Fairfield | Connecticut | 9001 | 98131 | 2165 |
1271358 | 1271358 | 2021-04-30 | Fairfield | Connecticut | 9001 | 98131 | 2165 |
1268111 | 1268111 | 2021-04-29 | Fairfield | Connecticut | 9001 | 97948 | 2160 |
1264864 | 1264864 | 2021-04-28 | Fairfield | Connecticut | 9001 | 97853 | 2159 |
1261617 | 1261617 | 2021-04-27 | Fairfield | Connecticut | 9001 | 97724 | 2157 |
1258370 | 1258370 | 2021-04-26 | Fairfield | Connecticut | 9001 | 97641 | 2157 |
1255123 | 1255123 | 2021-04-25 | Fairfield | Connecticut | 9001 | 97049 | 2154 |
1251876 | 1251876 | 2021-04-24 | Fairfield | Connecticut | 9001 | 97049 | 2154 |
1248629 | 1248629 | 2021-04-23 | Fairfield | Connecticut | 9001 | 97049 | 2154 |
1245382 | 1245382 | 2021-04-22 | Fairfield | Connecticut | 9001 | 96797 | 2152 |
1242135 | 1242135 | 2021-04-21 | Fairfield | Connecticut | 9001 | 96586 | 2149 |
1238888 | 1238888 | 2021-04-20 | Fairfield | Connecticut | 9001 | 96334 | 2148 |
1235641 | 1235641 | 2021-04-19 | Fairfield | Connecticut | 9001 | 96083 | 2147 |
1232394 | 1232394 | 2021-04-18 | Fairfield | Connecticut | 9001 | 95372 | 2142 |
1229145 | 1229145 | 2021-04-17 | Fairfield | Connecticut | 9001 | 95372 | 2142 |
1225897 | 1225897 | 2021-04-16 | Fairfield | Connecticut | 9001 | 95372 | 2142 |
1222650 | 1222650 | 2021-04-15 | Fairfield | Connecticut | 9001 | 95011 | 2141 |
1219402 | 1219402 | 2021-04-14 | Fairfield | Connecticut | 9001 | 94841 | 2140 |
1216154 | 1216154 | 2021-04-13 | Fairfield | Connecticut | 9001 | 94341 | 2139 |
1212907 | 1212907 | 2021-04-12 | Fairfield | Connecticut | 9001 | 93979 | 2133 |
1209659 | 1209659 | 2021-04-11 | Fairfield | Connecticut | 9001 | 92953 | 2130 |
1206410 | 1206410 | 2021-04-10 | Fairfield | Connecticut | 9001 | 92953 | 2130 |
1203162 | 1203162 | 2021-04-09 | Fairfield | Connecticut | 9001 | 92953 | 2130 |
1199914 | 1199914 | 2021-04-08 | Fairfield | Connecticut | 9001 | 92269 | 2129 |
1196665 | 1196665 | 2021-04-07 | Fairfield | Connecticut | 9001 | 91935 | 2127 |
1193417 | 1193417 | 2021-04-06 | Fairfield | Connecticut | 9001 | 91622 | 2126 |
1190167 | 1190167 | 2021-04-05 | Fairfield | Connecticut | 9001 | 91364 | 2125 |
1186920 | 1186920 | 2021-04-04 | Fairfield | Connecticut | 9001 | 90537 | 2117 |
1183673 | 1183673 | 2021-04-03 | Fairfield | Connecticut | 9001 | 90537 | 2117 |
1180426 | 1180426 | 2021-04-02 | Fairfield | Connecticut | 9001 | 90537 | 2117 |
1177179 | 1177179 | 2021-04-01 | Fairfield | Connecticut | 9001 | 90096 | 2115 |
1173932 | 1173932 | 2021-03-31 | Fairfield | Connecticut | 9001 | 89598 | 2111 |
1170685 | 1170685 | 2021-03-30 | Fairfield | Connecticut | 9001 | 89346 | 2109 |
1167437 | 1167437 | 2021-03-29 | Fairfield | Connecticut | 9001 | 88876 | 2108 |
1164189 | 1164189 | 2021-03-28 | Fairfield | Connecticut | 9001 | 87890 | 2106 |
1160941 | 1160941 | 2021-03-27 | Fairfield | Connecticut | 9001 | 87890 | 2106 |
1157693 | 1157693 | 2021-03-26 | Fairfield | Connecticut | 9001 | 87890 | 2106 |
1154446 | 1154446 | 2021-03-25 | Fairfield | Connecticut | 9001 | 87366 | 2104 |
1151199 | 1151199 | 2021-03-24 | Fairfield | Connecticut | 9001 | 86878 | 2101 |
1147952 | 1147952 | 2021-03-23 | Fairfield | Connecticut | 9001 | 86392 | 2098 |
1144705 | 1144705 | 2021-03-22 | Fairfield | Connecticut | 9001 | 86134 | 2098 |
1141458 | 1141458 | 2021-03-21 | Fairfield | Connecticut | 9001 | 85225 | 2097 |
1138212 | 1138212 | 2021-03-20 | Fairfield | Connecticut | 9001 | 85225 | 2097 |
1134966 | 1134966 | 2021-03-19 | Fairfield | Connecticut | 9001 | 85225 | 2097 |
1131719 | 1131719 | 2021-03-18 | Fairfield | Connecticut | 9001 | 84837 | 2098 |
1128471 | 1128471 | 2021-03-17 | Fairfield | Connecticut | 9001 | 84510 | 2097 |
1125225 | 1125225 | 2021-03-16 | Fairfield | Connecticut | 9001 | 84401 | 2093 |
1121979 | 1121979 | 2021-03-15 | Fairfield | Connecticut | 9001 | 84130 | 2089 |
1118732 | 1118732 | 2021-03-14 | Fairfield | Connecticut | 9001 | 83303 | 2085 |
1115485 | 1115485 | 2021-03-13 | Fairfield | Connecticut | 9001 | 83303 | 2085 |
1112239 | 1112239 | 2021-03-12 | Fairfield | Connecticut | 9001 | 83303 | 2085 |
1108993 | 1108993 | 2021-03-11 | Fairfield | Connecticut | 9001 | 82981 | 2085 |
1105747 | 1105747 | 2021-03-10 | Fairfield | Connecticut | 9001 | 82772 | 2085 |
1102501 | 1102501 | 2021-03-09 | Fairfield | Connecticut | 9001 | 82621 | 2081 |
1099255 | 1099255 | 2021-03-08 | Fairfield | Connecticut | 9001 | 82350 | 2079 |
1096007 | 1096007 | 2021-03-07 | Fairfield | Connecticut | 9001 | 81783 | 2074 |
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);