ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 38017 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1487300 | 1487300 | 2021-07-05 | Cass | North Dakota | 38017 | 24792 | 210 |
1484054 | 1484054 | 2021-07-04 | Cass | North Dakota | 38017 | 24791 | 210 |
1480808 | 1480808 | 2021-07-03 | Cass | North Dakota | 38017 | 24791 | 210 |
1477561 | 1477561 | 2021-07-02 | Cass | North Dakota | 38017 | 24792 | 210 |
1474315 | 1474315 | 2021-07-01 | Cass | North Dakota | 38017 | 24791 | 210 |
1471069 | 1471069 | 2021-06-30 | Cass | North Dakota | 38017 | 24788 | 210 |
1467824 | 1467824 | 2021-06-29 | Cass | North Dakota | 38017 | 24785 | 210 |
1464579 | 1464579 | 2021-06-28 | Cass | North Dakota | 38017 | 24782 | 210 |
1461334 | 1461334 | 2021-06-27 | Cass | North Dakota | 38017 | 24782 | 210 |
1458089 | 1458089 | 2021-06-26 | Cass | North Dakota | 38017 | 24782 | 210 |
1454844 | 1454844 | 2021-06-25 | Cass | North Dakota | 38017 | 24779 | 209 |
1451599 | 1451599 | 2021-06-24 | Cass | North Dakota | 38017 | 24775 | 209 |
1448353 | 1448353 | 2021-06-23 | Cass | North Dakota | 38017 | 24774 | 209 |
1445108 | 1445108 | 2021-06-22 | Cass | North Dakota | 38017 | 24769 | 209 |
1441863 | 1441863 | 2021-06-21 | Cass | North Dakota | 38017 | 24760 | 209 |
1438618 | 1438618 | 2021-06-20 | Cass | North Dakota | 38017 | 24759 | 209 |
1435371 | 1435371 | 2021-06-19 | Cass | North Dakota | 38017 | 24759 | 209 |
1432124 | 1432124 | 2021-06-18 | Cass | North Dakota | 38017 | 24755 | 209 |
1428878 | 1428878 | 2021-06-17 | Cass | North Dakota | 38017 | 24750 | 209 |
1425633 | 1425633 | 2021-06-16 | Cass | North Dakota | 38017 | 24744 | 209 |
1422386 | 1422386 | 2021-06-15 | Cass | North Dakota | 38017 | 24743 | 209 |
1419140 | 1419140 | 2021-06-14 | Cass | North Dakota | 38017 | 24735 | 209 |
1415895 | 1415895 | 2021-06-13 | Cass | North Dakota | 38017 | 24733 | 209 |
1412649 | 1412649 | 2021-06-12 | Cass | North Dakota | 38017 | 24732 | 209 |
1409404 | 1409404 | 2021-06-11 | Cass | North Dakota | 38017 | 24723 | 209 |
1406159 | 1406159 | 2021-06-10 | Cass | North Dakota | 38017 | 24720 | 209 |
1402913 | 1402913 | 2021-06-09 | Cass | North Dakota | 38017 | 24714 | 209 |
1399668 | 1399668 | 2021-06-08 | Cass | North Dakota | 38017 | 24705 | 209 |
1396423 | 1396423 | 2021-06-07 | Cass | North Dakota | 38017 | 24697 | 209 |
1393176 | 1393176 | 2021-06-06 | Cass | North Dakota | 38017 | 24695 | 209 |
1389931 | 1389931 | 2021-06-05 | Cass | North Dakota | 38017 | 24695 | 209 |
1386686 | 1386686 | 2021-06-04 | Cass | North Dakota | 38017 | 24691 | 209 |
1383441 | 1383441 | 2021-06-03 | Cass | North Dakota | 38017 | 24684 | 209 |
1380195 | 1380195 | 2021-06-02 | Cass | North Dakota | 38017 | 24681 | 209 |
1376950 | 1376950 | 2021-06-01 | Cass | North Dakota | 38017 | 24671 | 209 |
1373704 | 1373704 | 2021-05-31 | Cass | North Dakota | 38017 | 24670 | 209 |
1370459 | 1370459 | 2021-05-30 | Cass | North Dakota | 38017 | 24668 | 209 |
1367213 | 1367213 | 2021-05-29 | Cass | North Dakota | 38017 | 24667 | 209 |
1363967 | 1363967 | 2021-05-28 | Cass | North Dakota | 38017 | 24663 | 209 |
1360721 | 1360721 | 2021-05-27 | Cass | North Dakota | 38017 | 24659 | 209 |
1357475 | 1357475 | 2021-05-26 | Cass | North Dakota | 38017 | 24651 | 209 |
1354229 | 1354229 | 2021-05-25 | Cass | North Dakota | 38017 | 24644 | 209 |
1350983 | 1350983 | 2021-05-24 | Cass | North Dakota | 38017 | 24628 | 209 |
1347737 | 1347737 | 2021-05-23 | Cass | North Dakota | 38017 | 24626 | 209 |
1344489 | 1344489 | 2021-05-22 | Cass | North Dakota | 38017 | 24622 | 209 |
1341241 | 1341241 | 2021-05-21 | Cass | North Dakota | 38017 | 24614 | 209 |
1337993 | 1337993 | 2021-05-20 | Cass | North Dakota | 38017 | 24601 | 209 |
1334746 | 1334746 | 2021-05-19 | Cass | North Dakota | 38017 | 24584 | 208 |
1331499 | 1331499 | 2021-05-18 | Cass | North Dakota | 38017 | 24566 | 208 |
1328252 | 1328252 | 2021-05-17 | Cass | North Dakota | 38017 | 24546 | 208 |
1325006 | 1325006 | 2021-05-16 | Cass | North Dakota | 38017 | 24541 | 208 |
1321760 | 1321760 | 2021-05-15 | Cass | North Dakota | 38017 | 24533 | 208 |
1318514 | 1318514 | 2021-05-14 | Cass | North Dakota | 38017 | 24520 | 208 |
1315266 | 1315266 | 2021-05-13 | Cass | North Dakota | 38017 | 24495 | 208 |
1312020 | 1312020 | 2021-05-12 | Cass | North Dakota | 38017 | 24476 | 208 |
1308773 | 1308773 | 2021-05-11 | Cass | North Dakota | 38017 | 24446 | 208 |
1305527 | 1305527 | 2021-05-10 | Cass | North Dakota | 38017 | 24425 | 208 |
1302281 | 1302281 | 2021-05-09 | Cass | North Dakota | 38017 | 24420 | 208 |
1299033 | 1299033 | 2021-05-08 | Cass | North Dakota | 38017 | 24413 | 208 |
1295787 | 1295787 | 2021-05-07 | Cass | North Dakota | 38017 | 24398 | 208 |
1292541 | 1292541 | 2021-05-06 | Cass | North Dakota | 38017 | 24387 | 208 |
1289295 | 1289295 | 2021-05-05 | Cass | North Dakota | 38017 | 24356 | 207 |
1286049 | 1286049 | 2021-05-04 | Cass | North Dakota | 38017 | 24327 | 205 |
1282803 | 1282803 | 2021-05-03 | Cass | North Dakota | 38017 | 24291 | 205 |
1279556 | 1279556 | 2021-05-02 | Cass | North Dakota | 38017 | 24285 | 205 |
1276309 | 1276309 | 2021-05-01 | Cass | North Dakota | 38017 | 24273 | 205 |
1273062 | 1273062 | 2021-04-30 | Cass | North Dakota | 38017 | 24242 | 204 |
1269815 | 1269815 | 2021-04-29 | Cass | North Dakota | 38017 | 24205 | 203 |
1266568 | 1266568 | 2021-04-28 | Cass | North Dakota | 38017 | 24168 | 203 |
1263321 | 1263321 | 2021-04-27 | Cass | North Dakota | 38017 | 24135 | 203 |
1260074 | 1260074 | 2021-04-26 | Cass | North Dakota | 38017 | 24071 | 203 |
1256827 | 1256827 | 2021-04-25 | Cass | North Dakota | 38017 | 24036 | 203 |
1253580 | 1253580 | 2021-04-24 | Cass | North Dakota | 38017 | 24029 | 203 |
1250333 | 1250333 | 2021-04-23 | Cass | North Dakota | 38017 | 23997 | 203 |
1247086 | 1247086 | 2021-04-22 | Cass | North Dakota | 38017 | 23963 | 202 |
1243839 | 1243839 | 2021-04-21 | Cass | North Dakota | 38017 | 23924 | 202 |
1240592 | 1240592 | 2021-04-20 | Cass | North Dakota | 38017 | 23881 | 201 |
1237345 | 1237345 | 2021-04-19 | Cass | North Dakota | 38017 | 23807 | 200 |
1234098 | 1234098 | 2021-04-18 | Cass | North Dakota | 38017 | 23794 | 200 |
1230850 | 1230850 | 2021-04-17 | Cass | North Dakota | 38017 | 23774 | 200 |
1227602 | 1227602 | 2021-04-16 | Cass | North Dakota | 38017 | 23741 | 200 |
1224354 | 1224354 | 2021-04-15 | Cass | North Dakota | 38017 | 23679 | 199 |
1221107 | 1221107 | 2021-04-14 | Cass | North Dakota | 38017 | 23624 | 199 |
1217859 | 1217859 | 2021-04-13 | Cass | North Dakota | 38017 | 23562 | 199 |
1214611 | 1214611 | 2021-04-12 | Cass | North Dakota | 38017 | 23459 | 199 |
1211364 | 1211364 | 2021-04-11 | Cass | North Dakota | 38017 | 23432 | 199 |
1208115 | 1208115 | 2021-04-10 | Cass | North Dakota | 38017 | 23414 | 199 |
1204867 | 1204867 | 2021-04-09 | Cass | North Dakota | 38017 | 23318 | 199 |
1201619 | 1201619 | 2021-04-08 | Cass | North Dakota | 38017 | 23289 | 199 |
1198370 | 1198370 | 2021-04-07 | Cass | North Dakota | 38017 | 23226 | 199 |
1195121 | 1195121 | 2021-04-06 | Cass | North Dakota | 38017 | 23152 | 199 |
1191873 | 1191873 | 2021-04-05 | Cass | North Dakota | 38017 | 23012 | 198 |
1188624 | 1188624 | 2021-04-04 | Cass | North Dakota | 38017 | 22968 | 198 |
1185377 | 1185377 | 2021-04-03 | Cass | North Dakota | 38017 | 22939 | 198 |
1182130 | 1182130 | 2021-04-02 | Cass | North Dakota | 38017 | 22897 | 198 |
1178883 | 1178883 | 2021-04-01 | Cass | North Dakota | 38017 | 22822 | 198 |
1175636 | 1175636 | 2021-03-31 | Cass | North Dakota | 38017 | 22707 | 198 |
1172389 | 1172389 | 2021-03-30 | Cass | North Dakota | 38017 | 22603 | 198 |
1169142 | 1169142 | 2021-03-29 | Cass | North Dakota | 38017 | 22480 | 198 |
1165894 | 1165894 | 2021-03-28 | Cass | North Dakota | 38017 | 22455 | 198 |
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);