ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 36059 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419001 | 1419001 | 2021-06-14 | Nassau | New York | 36059 | 183624 | 3175 |
1415756 | 1415756 | 2021-06-13 | Nassau | New York | 36059 | 183601 | 3174 |
1412510 | 1412510 | 2021-06-12 | Nassau | New York | 36059 | 183578 | 3174 |
1409265 | 1409265 | 2021-06-11 | Nassau | New York | 36059 | 183545 | 3174 |
1406020 | 1406020 | 2021-06-10 | Nassau | New York | 36059 | 183511 | 3174 |
1402774 | 1402774 | 2021-06-09 | Nassau | New York | 36059 | 183468 | 3173 |
1399529 | 1399529 | 2021-06-08 | Nassau | New York | 36059 | 183449 | 3173 |
1396284 | 1396284 | 2021-06-07 | Nassau | New York | 36059 | 183422 | 3173 |
1393037 | 1393037 | 2021-06-06 | Nassau | New York | 36059 | 183392 | 3173 |
1389792 | 1389792 | 2021-06-05 | Nassau | New York | 36059 | 183360 | 3172 |
1386547 | 1386547 | 2021-06-04 | Nassau | New York | 36059 | 183309 | 3171 |
1383302 | 1383302 | 2021-06-03 | Nassau | New York | 36059 | 183266 | 3170 |
1380056 | 1380056 | 2021-06-02 | Nassau | New York | 36059 | 183233 | 3169 |
1376811 | 1376811 | 2021-06-01 | Nassau | New York | 36059 | 183212 | 3169 |
1373565 | 1373565 | 2021-05-31 | Nassau | New York | 36059 | 183195 | 3169 |
1370320 | 1370320 | 2021-05-30 | Nassau | New York | 36059 | 183169 | 3168 |
1367074 | 1367074 | 2021-05-29 | Nassau | New York | 36059 | 183145 | 3168 |
1363828 | 1363828 | 2021-05-28 | Nassau | New York | 36059 | 183108 | 3168 |
1360582 | 1360582 | 2021-05-27 | Nassau | New York | 36059 | 183056 | 3167 |
1357336 | 1357336 | 2021-05-26 | Nassau | New York | 36059 | 183001 | 3167 |
1354090 | 1354090 | 2021-05-25 | Nassau | New York | 36059 | 182945 | 3167 |
1350844 | 1350844 | 2021-05-24 | Nassau | New York | 36059 | 182902 | 3167 |
1347598 | 1347598 | 2021-05-23 | Nassau | New York | 36059 | 182859 | 3167 |
1344350 | 1344350 | 2021-05-22 | Nassau | New York | 36059 | 182810 | 3167 |
1341102 | 1341102 | 2021-05-21 | Nassau | New York | 36059 | 182739 | 3167 |
1337854 | 1337854 | 2021-05-20 | Nassau | New York | 36059 | 182656 | 3166 |
1334607 | 1334607 | 2021-05-19 | Nassau | New York | 36059 | 182565 | 3163 |
1331360 | 1331360 | 2021-05-18 | Nassau | New York | 36059 | 182491 | 3163 |
1328113 | 1328113 | 2021-05-17 | Nassau | New York | 36059 | 182422 | 3163 |
1324867 | 1324867 | 2021-05-16 | Nassau | New York | 36059 | 182343 | 3162 |
1321621 | 1321621 | 2021-05-15 | Nassau | New York | 36059 | 182253 | 3161 |
1318375 | 1318375 | 2021-05-14 | Nassau | New York | 36059 | 182139 | 3161 |
1315127 | 1315127 | 2021-05-13 | Nassau | New York | 36059 | 182027 | 3160 |
1311881 | 1311881 | 2021-05-12 | Nassau | New York | 36059 | 181920 | 3159 |
1308634 | 1308634 | 2021-05-11 | Nassau | New York | 36059 | 181804 | 3159 |
1305388 | 1305388 | 2021-05-10 | Nassau | New York | 36059 | 181727 | 3159 |
1302142 | 1302142 | 2021-05-09 | Nassau | New York | 36059 | 181639 | 3159 |
1298894 | 1298894 | 2021-05-08 | Nassau | New York | 36059 | 181553 | 3159 |
1295648 | 1295648 | 2021-05-07 | Nassau | New York | 36059 | 181375 | 3158 |
1292402 | 1292402 | 2021-05-06 | Nassau | New York | 36059 | 181253 | 3156 |
1289156 | 1289156 | 2021-05-05 | Nassau | New York | 36059 | 181108 | 3154 |
1285910 | 1285910 | 2021-05-04 | Nassau | New York | 36059 | 180992 | 3153 |
1282664 | 1282664 | 2021-05-03 | Nassau | New York | 36059 | 180860 | 3150 |
1279417 | 1279417 | 2021-05-02 | Nassau | New York | 36059 | 180730 | 3144 |
1276170 | 1276170 | 2021-05-01 | Nassau | New York | 36059 | 180605 | 3144 |
1272923 | 1272923 | 2021-04-30 | Nassau | New York | 36059 | 180373 | 3144 |
1269676 | 1269676 | 2021-04-29 | Nassau | New York | 36059 | 180144 | 3140 |
1266429 | 1266429 | 2021-04-28 | Nassau | New York | 36059 | 179895 | 3139 |
1263182 | 1263182 | 2021-04-27 | Nassau | New York | 36059 | 179724 | 3135 |
1259935 | 1259935 | 2021-04-26 | Nassau | New York | 36059 | 179572 | 3132 |
1256688 | 1256688 | 2021-04-25 | Nassau | New York | 36059 | 179350 | 3127 |
1253441 | 1253441 | 2021-04-24 | Nassau | New York | 36059 | 179117 | 3123 |
1250194 | 1250194 | 2021-04-23 | Nassau | New York | 36059 | 178834 | 3123 |
1246947 | 1246947 | 2021-04-22 | Nassau | New York | 36059 | 178512 | 3121 |
1243700 | 1243700 | 2021-04-21 | Nassau | New York | 36059 | 178235 | 3121 |
1240453 | 1240453 | 2021-04-20 | Nassau | New York | 36059 | 177933 | 3120 |
1237206 | 1237206 | 2021-04-19 | Nassau | New York | 36059 | 177656 | 3118 |
1233959 | 1233959 | 2021-04-18 | Nassau | New York | 36059 | 177344 | 3116 |
1230711 | 1230711 | 2021-04-17 | Nassau | New York | 36059 | 177001 | 3116 |
1227463 | 1227463 | 2021-04-16 | Nassau | New York | 36059 | 176399 | 3111 |
1224215 | 1224215 | 2021-04-15 | Nassau | New York | 36059 | 175919 | 3106 |
1220968 | 1220968 | 2021-04-14 | Nassau | New York | 36059 | 175392 | 3102 |
1217720 | 1217720 | 2021-04-13 | Nassau | New York | 36059 | 175023 | 3097 |
1214472 | 1214472 | 2021-04-12 | Nassau | New York | 36059 | 174673 | 3095 |
1211225 | 1211225 | 2021-04-11 | Nassau | New York | 36059 | 174279 | 3092 |
1207976 | 1207976 | 2021-04-10 | Nassau | New York | 36059 | 173772 | 3087 |
1204728 | 1204728 | 2021-04-09 | Nassau | New York | 36059 | 173216 | 3085 |
1201480 | 1201480 | 2021-04-08 | Nassau | New York | 36059 | 172548 | 3078 |
1198231 | 1198231 | 2021-04-07 | Nassau | New York | 36059 | 171738 | 3074 |
1194982 | 1194982 | 2021-04-06 | Nassau | New York | 36059 | 171185 | 3069 |
1191734 | 1191734 | 2021-04-05 | Nassau | New York | 36059 | 170680 | 3066 |
1188485 | 1188485 | 2021-04-04 | Nassau | New York | 36059 | 170179 | 3061 |
1185238 | 1185238 | 2021-04-03 | Nassau | New York | 36059 | 169535 | 3061 |
1181991 | 1181991 | 2021-04-02 | Nassau | New York | 36059 | 168884 | 3057 |
1178744 | 1178744 | 2021-04-01 | Nassau | New York | 36059 | 168246 | 3055 |
1175497 | 1175497 | 2021-03-31 | Nassau | New York | 36059 | 167557 | 3051 |
1172250 | 1172250 | 2021-03-30 | Nassau | New York | 36059 | 166881 | 3046 |
1169003 | 1169003 | 2021-03-29 | Nassau | New York | 36059 | 166365 | 3038 |
1165755 | 1165755 | 2021-03-28 | Nassau | New York | 36059 | 165785 | 3034 |
1162507 | 1162507 | 2021-03-27 | Nassau | New York | 36059 | 165095 | 3032 |
1159258 | 1159258 | 2021-03-26 | Nassau | New York | 36059 | 164481 | 3029 |
1156011 | 1156011 | 2021-03-25 | Nassau | New York | 36059 | 163785 | 3029 |
1152764 | 1152764 | 2021-03-24 | Nassau | New York | 36059 | 163084 | 3026 |
1149517 | 1149517 | 2021-03-23 | Nassau | New York | 36059 | 162481 | 3021 |
1146270 | 1146270 | 2021-03-22 | Nassau | New York | 36059 | 161948 | 3017 |
1143023 | 1143023 | 2021-03-21 | Nassau | New York | 36059 | 161408 | 3017 |
1139776 | 1139776 | 2021-03-20 | Nassau | New York | 36059 | 160800 | 3012 |
1136530 | 1136530 | 2021-03-19 | Nassau | New York | 36059 | 160103 | 3006 |
1133284 | 1133284 | 2021-03-18 | Nassau | New York | 36059 | 159401 | 3000 |
1130036 | 1130036 | 2021-03-17 | Nassau | New York | 36059 | 158769 | 2998 |
1126789 | 1126789 | 2021-03-16 | Nassau | New York | 36059 | 157985 | 2992 |
1123543 | 1123543 | 2021-03-15 | Nassau | New York | 36059 | 157362 | 2987 |
1120297 | 1120297 | 2021-03-14 | Nassau | New York | 36059 | 156822 | 2986 |
1117050 | 1117050 | 2021-03-13 | Nassau | New York | 36059 | 156309 | 2981 |
1113803 | 1113803 | 2021-03-12 | Nassau | New York | 36059 | 155646 | 2977 |
1110557 | 1110557 | 2021-03-11 | Nassau | New York | 36059 | 154867 | 2974 |
1107311 | 1107311 | 2021-03-10 | Nassau | New York | 36059 | 154288 | 2971 |
1104065 | 1104065 | 2021-03-09 | Nassau | New York | 36059 | 153711 | 2967 |
1100819 | 1100819 | 2021-03-08 | Nassau | New York | 36059 | 153099 | 2962 |
1097573 | 1097573 | 2021-03-07 | Nassau | New York | 36059 | 152646 | 2956 |
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);