ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 37059 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419061 | 1419061 | 2021-06-14 | Davie | North Carolina | 37059 | 4168 | 39 |
1415816 | 1415816 | 2021-06-13 | Davie | North Carolina | 37059 | 4163 | 39 |
1412570 | 1412570 | 2021-06-12 | Davie | North Carolina | 37059 | 4163 | 39 |
1409325 | 1409325 | 2021-06-11 | Davie | North Carolina | 37059 | 4163 | 39 |
1406080 | 1406080 | 2021-06-10 | Davie | North Carolina | 37059 | 4163 | 39 |
1402834 | 1402834 | 2021-06-09 | Davie | North Carolina | 37059 | 4163 | 39 |
1399589 | 1399589 | 2021-06-08 | Davie | North Carolina | 37059 | 4161 | 39 |
1396344 | 1396344 | 2021-06-07 | Davie | North Carolina | 37059 | 4159 | 39 |
1393097 | 1393097 | 2021-06-06 | Davie | North Carolina | 37059 | 4157 | 39 |
1389852 | 1389852 | 2021-06-05 | Davie | North Carolina | 37059 | 4157 | 39 |
1386607 | 1386607 | 2021-06-04 | Davie | North Carolina | 37059 | 4157 | 39 |
1383362 | 1383362 | 2021-06-03 | Davie | North Carolina | 37059 | 4155 | 39 |
1380116 | 1380116 | 2021-06-02 | Davie | North Carolina | 37059 | 4151 | 38 |
1376871 | 1376871 | 2021-06-01 | Davie | North Carolina | 37059 | 4151 | 38 |
1373625 | 1373625 | 2021-05-31 | Davie | North Carolina | 37059 | 4142 | 38 |
1370380 | 1370380 | 2021-05-30 | Davie | North Carolina | 37059 | 4142 | 38 |
1367134 | 1367134 | 2021-05-29 | Davie | North Carolina | 37059 | 4142 | 38 |
1363888 | 1363888 | 2021-05-28 | Davie | North Carolina | 37059 | 4142 | 38 |
1360642 | 1360642 | 2021-05-27 | Davie | North Carolina | 37059 | 4140 | 38 |
1357396 | 1357396 | 2021-05-26 | Davie | North Carolina | 37059 | 4135 | 38 |
1354150 | 1354150 | 2021-05-25 | Davie | North Carolina | 37059 | 4134 | 38 |
1350904 | 1350904 | 2021-05-24 | Davie | North Carolina | 37059 | 4134 | 38 |
1347658 | 1347658 | 2021-05-23 | Davie | North Carolina | 37059 | 4120 | 37 |
1344410 | 1344410 | 2021-05-22 | Davie | North Carolina | 37059 | 4120 | 37 |
1341162 | 1341162 | 2021-05-21 | Davie | North Carolina | 37059 | 4120 | 37 |
1337914 | 1337914 | 2021-05-20 | Davie | North Carolina | 37059 | 4110 | 37 |
1334667 | 1334667 | 2021-05-19 | Davie | North Carolina | 37059 | 4104 | 37 |
1331420 | 1331420 | 2021-05-18 | Davie | North Carolina | 37059 | 4098 | 37 |
1328173 | 1328173 | 2021-05-17 | Davie | North Carolina | 37059 | 4093 | 37 |
1324927 | 1324927 | 2021-05-16 | Davie | North Carolina | 37059 | 4078 | 37 |
1321681 | 1321681 | 2021-05-15 | Davie | North Carolina | 37059 | 4078 | 37 |
1318435 | 1318435 | 2021-05-14 | Davie | North Carolina | 37059 | 4078 | 37 |
1315187 | 1315187 | 2021-05-13 | Davie | North Carolina | 37059 | 4074 | 37 |
1311941 | 1311941 | 2021-05-12 | Davie | North Carolina | 37059 | 4069 | 37 |
1308694 | 1308694 | 2021-05-11 | Davie | North Carolina | 37059 | 4067 | 37 |
1305448 | 1305448 | 2021-05-10 | Davie | North Carolina | 37059 | 4067 | 37 |
1302202 | 1302202 | 2021-05-09 | Davie | North Carolina | 37059 | 4050 | 37 |
1298954 | 1298954 | 2021-05-08 | Davie | North Carolina | 37059 | 4050 | 37 |
1295708 | 1295708 | 2021-05-07 | Davie | North Carolina | 37059 | 4050 | 37 |
1292462 | 1292462 | 2021-05-06 | Davie | North Carolina | 37059 | 4040 | 37 |
1289216 | 1289216 | 2021-05-05 | Davie | North Carolina | 37059 | 4037 | 37 |
1285970 | 1285970 | 2021-05-04 | Davie | North Carolina | 37059 | 4032 | 37 |
1282724 | 1282724 | 2021-05-03 | Davie | North Carolina | 37059 | 4030 | 37 |
1279477 | 1279477 | 2021-05-02 | Davie | North Carolina | 37059 | 4011 | 37 |
1276230 | 1276230 | 2021-05-01 | Davie | North Carolina | 37059 | 4011 | 37 |
1272983 | 1272983 | 2021-04-30 | Davie | North Carolina | 37059 | 4011 | 37 |
1269736 | 1269736 | 2021-04-29 | Davie | North Carolina | 37059 | 4002 | 37 |
1266489 | 1266489 | 2021-04-28 | Davie | North Carolina | 37059 | 3992 | 37 |
1263242 | 1263242 | 2021-04-27 | Davie | North Carolina | 37059 | 3984 | 37 |
1259995 | 1259995 | 2021-04-26 | Davie | North Carolina | 37059 | 3974 | 37 |
1256748 | 1256748 | 2021-04-25 | Davie | North Carolina | 37059 | 3961 | 37 |
1253501 | 1253501 | 2021-04-24 | Davie | North Carolina | 37059 | 3961 | 37 |
1250254 | 1250254 | 2021-04-23 | Davie | North Carolina | 37059 | 3961 | 37 |
1247007 | 1247007 | 2021-04-22 | Davie | North Carolina | 37059 | 3954 | 37 |
1243760 | 1243760 | 2021-04-21 | Davie | North Carolina | 37059 | 3948 | 37 |
1240513 | 1240513 | 2021-04-20 | Davie | North Carolina | 37059 | 3944 | 37 |
1237266 | 1237266 | 2021-04-19 | Davie | North Carolina | 37059 | 3938 | 37 |
1234019 | 1234019 | 2021-04-18 | Davie | North Carolina | 37059 | 3917 | 37 |
1230771 | 1230771 | 2021-04-17 | Davie | North Carolina | 37059 | 3917 | 37 |
1227523 | 1227523 | 2021-04-16 | Davie | North Carolina | 37059 | 3917 | 37 |
1224275 | 1224275 | 2021-04-15 | Davie | North Carolina | 37059 | 3909 | 37 |
1221028 | 1221028 | 2021-04-14 | Davie | North Carolina | 37059 | 3899 | 37 |
1217780 | 1217780 | 2021-04-13 | Davie | North Carolina | 37059 | 3892 | 37 |
1214532 | 1214532 | 2021-04-12 | Davie | North Carolina | 37059 | 3886 | 36 |
1211285 | 1211285 | 2021-04-11 | Davie | North Carolina | 37059 | 3871 | 36 |
1208036 | 1208036 | 2021-04-10 | Davie | North Carolina | 37059 | 3871 | 36 |
1204788 | 1204788 | 2021-04-09 | Davie | North Carolina | 37059 | 3871 | 36 |
1201540 | 1201540 | 2021-04-08 | Davie | North Carolina | 37059 | 3861 | 36 |
1198291 | 1198291 | 2021-04-07 | Davie | North Carolina | 37059 | 3848 | 36 |
1195042 | 1195042 | 2021-04-06 | Davie | North Carolina | 37059 | 3841 | 36 |
1191794 | 1191794 | 2021-04-05 | Davie | North Carolina | 37059 | 3836 | 36 |
1188545 | 1188545 | 2021-04-04 | Davie | North Carolina | 37059 | 3797 | 36 |
1185298 | 1185298 | 2021-04-03 | Davie | North Carolina | 37059 | 3797 | 36 |
1182051 | 1182051 | 2021-04-02 | Davie | North Carolina | 37059 | 3797 | 36 |
1178804 | 1178804 | 2021-04-01 | Davie | North Carolina | 37059 | 3797 | 36 |
1175557 | 1175557 | 2021-03-31 | Davie | North Carolina | 37059 | 3794 | 36 |
1172310 | 1172310 | 2021-03-30 | Davie | North Carolina | 37059 | 3783 | 36 |
1169063 | 1169063 | 2021-03-29 | Davie | North Carolina | 37059 | 3776 | 36 |
1165815 | 1165815 | 2021-03-28 | Davie | North Carolina | 37059 | 3756 | 35 |
1162567 | 1162567 | 2021-03-27 | Davie | North Carolina | 37059 | 3756 | 35 |
1159318 | 1159318 | 2021-03-26 | Davie | North Carolina | 37059 | 3756 | 35 |
1156071 | 1156071 | 2021-03-25 | Davie | North Carolina | 37059 | 3740 | 35 |
1152824 | 1152824 | 2021-03-24 | Davie | North Carolina | 37059 | 3732 | 35 |
1149577 | 1149577 | 2021-03-23 | Davie | North Carolina | 37059 | 3717 | 35 |
1146330 | 1146330 | 2021-03-22 | Davie | North Carolina | 37059 | 3709 | 35 |
1143083 | 1143083 | 2021-03-21 | Davie | North Carolina | 37059 | 3697 | 35 |
1139836 | 1139836 | 2021-03-20 | Davie | North Carolina | 37059 | 3697 | 35 |
1136590 | 1136590 | 2021-03-19 | Davie | North Carolina | 37059 | 3684 | 35 |
1133344 | 1133344 | 2021-03-18 | Davie | North Carolina | 37059 | 3674 | 35 |
1130096 | 1130096 | 2021-03-17 | Davie | North Carolina | 37059 | 3658 | 35 |
1126849 | 1126849 | 2021-03-16 | Davie | North Carolina | 37059 | 3655 | 35 |
1123603 | 1123603 | 2021-03-15 | Davie | North Carolina | 37059 | 3653 | 35 |
1120357 | 1120357 | 2021-03-14 | Davie | North Carolina | 37059 | 3628 | 35 |
1117110 | 1117110 | 2021-03-13 | Davie | North Carolina | 37059 | 3628 | 35 |
1113863 | 1113863 | 2021-03-12 | Davie | North Carolina | 37059 | 3625 | 35 |
1110617 | 1110617 | 2021-03-11 | Davie | North Carolina | 37059 | 3618 | 35 |
1107371 | 1107371 | 2021-03-10 | Davie | North Carolina | 37059 | 3610 | 34 |
1104125 | 1104125 | 2021-03-09 | Davie | North Carolina | 37059 | 3601 | 34 |
1100879 | 1100879 | 2021-03-08 | Davie | North Carolina | 37059 | 3597 | 32 |
1097633 | 1097633 | 2021-03-07 | Davie | North Carolina | 37059 | 3583 | 31 |
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);