ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Ransom" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, 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 |
2241280 | 2241280 | 2022-02-22 | Ransom | North Dakota | 38073 | 1481 | 27 |
2238029 | 2238029 | 2022-02-21 | Ransom | North Dakota | 38073 | 1479 | 27 |
2234778 | 2234778 | 2022-02-20 | Ransom | North Dakota | 38073 | 1478 | 27 |
2231527 | 2231527 | 2022-02-19 | Ransom | North Dakota | 38073 | 1476 | 27 |
2228276 | 2228276 | 2022-02-18 | Ransom | North Dakota | 38073 | 1475 | 27 |
2225025 | 2225025 | 2022-02-17 | Ransom | North Dakota | 38073 | 1475 | 27 |
2221774 | 2221774 | 2022-02-16 | Ransom | North Dakota | 38073 | 1472 | 27 |
2218523 | 2218523 | 2022-02-15 | Ransom | North Dakota | 38073 | 1468 | 27 |
2215272 | 2215272 | 2022-02-14 | Ransom | North Dakota | 38073 | 1466 | 27 |
2212021 | 2212021 | 2022-02-13 | Ransom | North Dakota | 38073 | 1465 | 27 |
2208768 | 2208768 | 2022-02-12 | Ransom | North Dakota | 38073 | 1463 | 27 |
2205515 | 2205515 | 2022-02-11 | Ransom | North Dakota | 38073 | 1454 | 26 |
2202262 | 2202262 | 2022-02-10 | Ransom | North Dakota | 38073 | 1449 | 26 |
2199008 | 2199008 | 2022-02-09 | Ransom | North Dakota | 38073 | 1445 | 26 |
2195754 | 2195754 | 2022-02-08 | Ransom | North Dakota | 38073 | 1435 | 26 |
2192500 | 2192500 | 2022-02-07 | Ransom | North Dakota | 38073 | 1427 | 26 |
2189246 | 2189246 | 2022-02-06 | Ransom | North Dakota | 38073 | 1421 | 26 |
2185993 | 2185993 | 2022-02-05 | Ransom | North Dakota | 38073 | 1421 | 26 |
2182741 | 2182741 | 2022-02-04 | Ransom | North Dakota | 38073 | 1413 | 26 |
2179489 | 2179489 | 2022-02-03 | Ransom | North Dakota | 38073 | 1408 | 26 |
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);