ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
414 rows where deaths = 28 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501622 | 2501622 | 2022-05-13 | Ransom | North Dakota | 38073 | 1515 | 28 |
2498364 | 2498364 | 2022-05-12 | Ransom | North Dakota | 38073 | 1504 | 28 |
2495106 | 2495106 | 2022-05-11 | Ransom | North Dakota | 38073 | 1504 | 28 |
2491848 | 2491848 | 2022-05-10 | Ransom | North Dakota | 38073 | 1504 | 28 |
2488590 | 2488590 | 2022-05-09 | Ransom | North Dakota | 38073 | 1504 | 28 |
2485333 | 2485333 | 2022-05-08 | Ransom | North Dakota | 38073 | 1504 | 28 |
2482075 | 2482075 | 2022-05-07 | Ransom | North Dakota | 38073 | 1504 | 28 |
2478817 | 2478817 | 2022-05-06 | Ransom | North Dakota | 38073 | 1504 | 28 |
2475559 | 2475559 | 2022-05-05 | Ransom | North Dakota | 38073 | 1503 | 28 |
2472302 | 2472302 | 2022-05-04 | Ransom | North Dakota | 38073 | 1503 | 28 |
2469046 | 2469046 | 2022-05-03 | Ransom | North Dakota | 38073 | 1503 | 28 |
2465790 | 2465790 | 2022-05-02 | Ransom | North Dakota | 38073 | 1503 | 28 |
2462535 | 2462535 | 2022-05-01 | Ransom | North Dakota | 38073 | 1503 | 28 |
2459279 | 2459279 | 2022-04-30 | Ransom | North Dakota | 38073 | 1503 | 28 |
2456023 | 2456023 | 2022-04-29 | Ransom | North Dakota | 38073 | 1503 | 28 |
2452767 | 2452767 | 2022-04-28 | Ransom | North Dakota | 38073 | 1498 | 28 |
2449511 | 2449511 | 2022-04-27 | Ransom | North Dakota | 38073 | 1498 | 28 |
2446254 | 2446254 | 2022-04-26 | Ransom | North Dakota | 38073 | 1498 | 28 |
2442999 | 2442999 | 2022-04-25 | Ransom | North Dakota | 38073 | 1498 | 28 |
2439743 | 2439743 | 2022-04-24 | Ransom | North Dakota | 38073 | 1498 | 28 |
2436487 | 2436487 | 2022-04-23 | Ransom | North Dakota | 38073 | 1498 | 28 |
2433231 | 2433231 | 2022-04-22 | Ransom | North Dakota | 38073 | 1498 | 28 |
2429975 | 2429975 | 2022-04-21 | Ransom | North Dakota | 38073 | 1497 | 28 |
2426719 | 2426719 | 2022-04-20 | Ransom | North Dakota | 38073 | 1497 | 28 |
2423463 | 2423463 | 2022-04-19 | Ransom | North Dakota | 38073 | 1497 | 28 |
2420206 | 2420206 | 2022-04-18 | Ransom | North Dakota | 38073 | 1497 | 28 |
2416951 | 2416951 | 2022-04-17 | Ransom | North Dakota | 38073 | 1497 | 28 |
2413695 | 2413695 | 2022-04-16 | Ransom | North Dakota | 38073 | 1497 | 28 |
2410439 | 2410439 | 2022-04-15 | Ransom | North Dakota | 38073 | 1497 | 28 |
2407183 | 2407183 | 2022-04-14 | Ransom | North Dakota | 38073 | 1491 | 28 |
2403927 | 2403927 | 2022-04-13 | Ransom | North Dakota | 38073 | 1491 | 28 |
2400672 | 2400672 | 2022-04-12 | Ransom | North Dakota | 38073 | 1491 | 28 |
2397417 | 2397417 | 2022-04-11 | Ransom | North Dakota | 38073 | 1491 | 28 |
2394162 | 2394162 | 2022-04-10 | Ransom | North Dakota | 38073 | 1491 | 28 |
2390906 | 2390906 | 2022-04-09 | Ransom | North Dakota | 38073 | 1491 | 28 |
2387650 | 2387650 | 2022-04-08 | Ransom | North Dakota | 38073 | 1491 | 28 |
2384395 | 2384395 | 2022-04-07 | Ransom | North Dakota | 38073 | 1491 | 28 |
2381140 | 2381140 | 2022-04-06 | Ransom | North Dakota | 38073 | 1491 | 28 |
2377885 | 2377885 | 2022-04-05 | Ransom | North Dakota | 38073 | 1491 | 28 |
2374632 | 2374632 | 2022-04-04 | Ransom | North Dakota | 38073 | 1491 | 28 |
2371380 | 2371380 | 2022-04-03 | Ransom | North Dakota | 38073 | 1491 | 28 |
2368127 | 2368127 | 2022-04-02 | Ransom | North Dakota | 38073 | 1491 | 28 |
2364874 | 2364874 | 2022-04-01 | Ransom | North Dakota | 38073 | 1491 | 28 |
2361620 | 2361620 | 2022-03-31 | Ransom | North Dakota | 38073 | 1486 | 28 |
2358366 | 2358366 | 2022-03-30 | Ransom | North Dakota | 38073 | 1486 | 28 |
2355112 | 2355112 | 2022-03-29 | Ransom | North Dakota | 38073 | 1486 | 28 |
2351859 | 2351859 | 2022-03-28 | Ransom | North Dakota | 38073 | 1486 | 28 |
2348607 | 2348607 | 2022-03-27 | Ransom | North Dakota | 38073 | 1486 | 28 |
2345354 | 2345354 | 2022-03-26 | Ransom | North Dakota | 38073 | 1486 | 28 |
2342101 | 2342101 | 2022-03-25 | Ransom | North Dakota | 38073 | 1486 | 28 |
2338848 | 2338848 | 2022-03-24 | Ransom | North Dakota | 38073 | 1485 | 28 |
2335594 | 2335594 | 2022-03-23 | Ransom | North Dakota | 38073 | 1485 | 28 |
2332340 | 2332340 | 2022-03-22 | Ransom | North Dakota | 38073 | 1485 | 28 |
2329087 | 2329087 | 2022-03-21 | Ransom | North Dakota | 38073 | 1485 | 28 |
2325835 | 2325835 | 2022-03-20 | Ransom | North Dakota | 38073 | 1485 | 28 |
2322582 | 2322582 | 2022-03-19 | Ransom | North Dakota | 38073 | 1485 | 28 |
2319328 | 2319328 | 2022-03-18 | Ransom | North Dakota | 38073 | 1485 | 28 |
2316074 | 2316074 | 2022-03-17 | Ransom | North Dakota | 38073 | 1484 | 28 |
2312821 | 2312821 | 2022-03-16 | Ransom | North Dakota | 38073 | 1484 | 28 |
2309568 | 2309568 | 2022-03-15 | Ransom | North Dakota | 38073 | 1485 | 28 |
2306315 | 2306315 | 2022-03-14 | Ransom | North Dakota | 38073 | 1485 | 28 |
2303064 | 2303064 | 2022-03-13 | Ransom | North Dakota | 38073 | 1485 | 28 |
2299812 | 2299812 | 2022-03-12 | Ransom | North Dakota | 38073 | 1485 | 28 |
2296560 | 2296560 | 2022-03-11 | Ransom | North Dakota | 38073 | 1488 | 28 |
2293308 | 2293308 | 2022-03-10 | Ransom | North Dakota | 38073 | 1489 | 28 |
2290056 | 2290056 | 2022-03-09 | Ransom | North Dakota | 38073 | 1488 | 28 |
2286804 | 2286804 | 2022-03-08 | Ransom | North Dakota | 38073 | 1487 | 28 |
2283552 | 2283552 | 2022-03-07 | Ransom | North Dakota | 38073 | 1487 | 28 |
2280300 | 2280300 | 2022-03-06 | Ransom | North Dakota | 38073 | 1487 | 28 |
2277047 | 2277047 | 2022-03-05 | Ransom | North Dakota | 38073 | 1487 | 28 |
2273794 | 2273794 | 2022-03-04 | Ransom | North Dakota | 38073 | 1486 | 28 |
2270541 | 2270541 | 2022-03-03 | Ransom | North Dakota | 38073 | 1486 | 28 |
2267289 | 2267289 | 2022-03-02 | Ransom | North Dakota | 38073 | 1485 | 28 |
2264037 | 2264037 | 2022-03-01 | Ransom | North Dakota | 38073 | 1484 | 28 |
2260786 | 2260786 | 2022-02-28 | Ransom | North Dakota | 38073 | 1482 | 28 |
2257535 | 2257535 | 2022-02-27 | Ransom | North Dakota | 38073 | 1482 | 28 |
2254284 | 2254284 | 2022-02-26 | Ransom | North Dakota | 38073 | 1482 | 28 |
2251033 | 2251033 | 2022-02-25 | Ransom | North Dakota | 38073 | 1482 | 28 |
2247782 | 2247782 | 2022-02-24 | Ransom | North Dakota | 38073 | 1481 | 28 |
2244531 | 2244531 | 2022-02-23 | Ransom | North Dakota | 38073 | 1480 | 28 |
2150195 | 2150195 | 2022-01-25 | McHenry | North Dakota | 38049 | 1195 | 28 |
2146943 | 2146943 | 2022-01-24 | McHenry | North Dakota | 38049 | 1187 | 28 |
2143689 | 2143689 | 2022-01-23 | McHenry | North Dakota | 38049 | 1187 | 28 |
2140434 | 2140434 | 2022-01-22 | McHenry | North Dakota | 38049 | 1182 | 28 |
2137178 | 2137178 | 2022-01-21 | McHenry | North Dakota | 38049 | 1178 | 28 |
2133925 | 2133925 | 2022-01-20 | McHenry | North Dakota | 38049 | 1169 | 28 |
2130673 | 2130673 | 2022-01-19 | McHenry | North Dakota | 38049 | 1156 | 28 |
2127419 | 2127419 | 2022-01-18 | McHenry | North Dakota | 38049 | 1142 | 28 |
2124167 | 2124167 | 2022-01-17 | McHenry | North Dakota | 38049 | 1137 | 28 |
2120915 | 2120915 | 2022-01-16 | McHenry | North Dakota | 38049 | 1135 | 28 |
2117663 | 2117663 | 2022-01-15 | McHenry | North Dakota | 38049 | 1129 | 28 |
2114412 | 2114412 | 2022-01-14 | McHenry | North Dakota | 38049 | 1123 | 28 |
2111160 | 2111160 | 2022-01-13 | McHenry | North Dakota | 38049 | 1117 | 28 |
2107908 | 2107908 | 2022-01-12 | McHenry | North Dakota | 38049 | 1107 | 28 |
2104657 | 2104657 | 2022-01-11 | McHenry | North Dakota | 38049 | 1100 | 28 |
2101406 | 2101406 | 2022-01-10 | McHenry | North Dakota | 38049 | 1094 | 28 |
2098155 | 2098155 | 2022-01-09 | McHenry | North Dakota | 38049 | 1091 | 28 |
2094903 | 2094903 | 2022-01-08 | McHenry | North Dakota | 38049 | 1089 | 28 |
2091651 | 2091651 | 2022-01-07 | McHenry | North Dakota | 38049 | 1087 | 28 |
2088400 | 2088400 | 2022-01-06 | McHenry | North Dakota | 38049 | 1080 | 28 |
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);