ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 194 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 |
---|---|---|---|---|---|---|---|
1425632 | 1425632 | 2021-06-16 | Burleigh | North Dakota | 38015 | 16005 | 194 |
1354272 | 1354272 | 2021-05-25 | Ward | North Dakota | 38101 | 9845 | 194 |
1351026 | 1351026 | 2021-05-24 | Ward | North Dakota | 38101 | 9837 | 194 |
1347780 | 1347780 | 2021-05-23 | Ward | North Dakota | 38101 | 9831 | 194 |
1344532 | 1344532 | 2021-05-22 | Ward | North Dakota | 38101 | 9826 | 194 |
1341284 | 1341284 | 2021-05-21 | Ward | North Dakota | 38101 | 9817 | 194 |
1338036 | 1338036 | 2021-05-20 | Ward | North Dakota | 38101 | 9809 | 194 |
1334789 | 1334789 | 2021-05-19 | Ward | North Dakota | 38101 | 9808 | 194 |
1331542 | 1331542 | 2021-05-18 | Ward | North Dakota | 38101 | 9788 | 194 |
1328295 | 1328295 | 2021-05-17 | Ward | North Dakota | 38101 | 9772 | 194 |
1325049 | 1325049 | 2021-05-16 | Ward | North Dakota | 38101 | 9770 | 194 |
1321803 | 1321803 | 2021-05-15 | Ward | North Dakota | 38101 | 9759 | 194 |
1318557 | 1318557 | 2021-05-14 | Ward | North Dakota | 38101 | 9748 | 194 |
1315309 | 1315309 | 2021-05-13 | Ward | North Dakota | 38101 | 9740 | 194 |
1312063 | 1312063 | 2021-05-12 | Ward | North Dakota | 38101 | 9734 | 194 |
1308816 | 1308816 | 2021-05-11 | Ward | North Dakota | 38101 | 9723 | 194 |
1305570 | 1305570 | 2021-05-10 | Ward | North Dakota | 38101 | 9717 | 194 |
1302324 | 1302324 | 2021-05-09 | Ward | North Dakota | 38101 | 9712 | 194 |
1299076 | 1299076 | 2021-05-08 | Ward | North Dakota | 38101 | 9707 | 194 |
1295830 | 1295830 | 2021-05-07 | Ward | North Dakota | 38101 | 9702 | 194 |
1292584 | 1292584 | 2021-05-06 | Ward | North Dakota | 38101 | 9680 | 194 |
1289338 | 1289338 | 2021-05-05 | Ward | North Dakota | 38101 | 9674 | 194 |
1286092 | 1286092 | 2021-05-04 | Ward | North Dakota | 38101 | 9662 | 194 |
1282846 | 1282846 | 2021-05-03 | Ward | North Dakota | 38101 | 9649 | 194 |
1279599 | 1279599 | 2021-05-02 | Ward | North Dakota | 38101 | 9642 | 194 |
1276352 | 1276352 | 2021-05-01 | Ward | North Dakota | 38101 | 9636 | 194 |
1273105 | 1273105 | 2021-04-30 | Ward | North Dakota | 38101 | 9628 | 194 |
1269858 | 1269858 | 2021-04-29 | Ward | North Dakota | 38101 | 9601 | 194 |
1266611 | 1266611 | 2021-04-28 | Ward | North Dakota | 38101 | 9591 | 194 |
1263364 | 1263364 | 2021-04-27 | Ward | North Dakota | 38101 | 9582 | 194 |
1260117 | 1260117 | 2021-04-26 | Ward | North Dakota | 38101 | 9563 | 194 |
1256870 | 1256870 | 2021-04-25 | Ward | North Dakota | 38101 | 9550 | 194 |
1253623 | 1253623 | 2021-04-24 | Ward | North Dakota | 38101 | 9547 | 194 |
1250376 | 1250376 | 2021-04-23 | Ward | North Dakota | 38101 | 9537 | 194 |
1247129 | 1247129 | 2021-04-22 | Ward | North Dakota | 38101 | 9519 | 194 |
1243882 | 1243882 | 2021-04-21 | Ward | North Dakota | 38101 | 9510 | 194 |
1240635 | 1240635 | 2021-04-20 | Ward | North Dakota | 38101 | 9502 | 194 |
1237388 | 1237388 | 2021-04-19 | Ward | North Dakota | 38101 | 9487 | 194 |
1234141 | 1234141 | 2021-04-18 | Ward | North Dakota | 38101 | 9483 | 194 |
1230893 | 1230893 | 2021-04-17 | Ward | North Dakota | 38101 | 9481 | 194 |
1227645 | 1227645 | 2021-04-16 | Ward | North Dakota | 38101 | 9477 | 194 |
1224397 | 1224397 | 2021-04-15 | Ward | North Dakota | 38101 | 9469 | 194 |
1221150 | 1221150 | 2021-04-14 | Ward | North Dakota | 38101 | 9464 | 194 |
1217902 | 1217902 | 2021-04-13 | Ward | North Dakota | 38101 | 9461 | 194 |
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);