ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38105 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 |
---|---|---|---|---|---|---|---|
2501639 | 2501639 | 2022-05-13 | Williams | North Dakota | 38105 | 10496 | 68 |
2498381 | 2498381 | 2022-05-12 | Williams | North Dakota | 38105 | 10488 | 68 |
2495123 | 2495123 | 2022-05-11 | Williams | North Dakota | 38105 | 10488 | 68 |
2491865 | 2491865 | 2022-05-10 | Williams | North Dakota | 38105 | 10488 | 68 |
2488607 | 2488607 | 2022-05-09 | Williams | North Dakota | 38105 | 10488 | 68 |
2485350 | 2485350 | 2022-05-08 | Williams | North Dakota | 38105 | 10488 | 68 |
2482092 | 2482092 | 2022-05-07 | Williams | North Dakota | 38105 | 10488 | 68 |
2478834 | 2478834 | 2022-05-06 | Williams | North Dakota | 38105 | 10488 | 68 |
2475576 | 2475576 | 2022-05-05 | Williams | North Dakota | 38105 | 10484 | 68 |
2472319 | 2472319 | 2022-05-04 | Williams | North Dakota | 38105 | 10484 | 68 |
2469063 | 2469063 | 2022-05-03 | Williams | North Dakota | 38105 | 10484 | 68 |
2465807 | 2465807 | 2022-05-02 | Williams | North Dakota | 38105 | 10484 | 68 |
2462552 | 2462552 | 2022-05-01 | Williams | North Dakota | 38105 | 10484 | 68 |
2459296 | 2459296 | 2022-04-30 | Williams | North Dakota | 38105 | 10484 | 68 |
2456040 | 2456040 | 2022-04-29 | Williams | North Dakota | 38105 | 10484 | 68 |
2452784 | 2452784 | 2022-04-28 | Williams | North Dakota | 38105 | 10480 | 68 |
2449528 | 2449528 | 2022-04-27 | Williams | North Dakota | 38105 | 10480 | 68 |
2446271 | 2446271 | 2022-04-26 | Williams | North Dakota | 38105 | 10480 | 68 |
2443016 | 2443016 | 2022-04-25 | Williams | North Dakota | 38105 | 10480 | 68 |
2439760 | 2439760 | 2022-04-24 | Williams | North Dakota | 38105 | 10480 | 68 |
2436504 | 2436504 | 2022-04-23 | Williams | North Dakota | 38105 | 10480 | 68 |
2433248 | 2433248 | 2022-04-22 | Williams | North Dakota | 38105 | 10480 | 68 |
2429992 | 2429992 | 2022-04-21 | Williams | North Dakota | 38105 | 10472 | 68 |
2426736 | 2426736 | 2022-04-20 | Williams | North Dakota | 38105 | 10472 | 68 |
2423480 | 2423480 | 2022-04-19 | Williams | North Dakota | 38105 | 10472 | 68 |
2420223 | 2420223 | 2022-04-18 | Williams | North Dakota | 38105 | 10472 | 68 |
2416968 | 2416968 | 2022-04-17 | Williams | North Dakota | 38105 | 10472 | 68 |
2413712 | 2413712 | 2022-04-16 | Williams | North Dakota | 38105 | 10472 | 68 |
2410456 | 2410456 | 2022-04-15 | Williams | North Dakota | 38105 | 10472 | 68 |
2407200 | 2407200 | 2022-04-14 | Williams | North Dakota | 38105 | 10470 | 68 |
2403944 | 2403944 | 2022-04-13 | Williams | North Dakota | 38105 | 10470 | 68 |
2400689 | 2400689 | 2022-04-12 | Williams | North Dakota | 38105 | 10470 | 68 |
2397434 | 2397434 | 2022-04-11 | Williams | North Dakota | 38105 | 10470 | 68 |
2394179 | 2394179 | 2022-04-10 | Williams | North Dakota | 38105 | 10470 | 68 |
2390923 | 2390923 | 2022-04-09 | Williams | North Dakota | 38105 | 10470 | 68 |
2387667 | 2387667 | 2022-04-08 | Williams | North Dakota | 38105 | 10470 | 68 |
2384412 | 2384412 | 2022-04-07 | Williams | North Dakota | 38105 | 10466 | 68 |
2381157 | 2381157 | 2022-04-06 | Williams | North Dakota | 38105 | 10466 | 68 |
2377902 | 2377902 | 2022-04-05 | Williams | North Dakota | 38105 | 10466 | 68 |
2374649 | 2374649 | 2022-04-04 | Williams | North Dakota | 38105 | 10466 | 68 |
2371397 | 2371397 | 2022-04-03 | Williams | North Dakota | 38105 | 10466 | 68 |
2368144 | 2368144 | 2022-04-02 | Williams | North Dakota | 38105 | 10466 | 68 |
2364891 | 2364891 | 2022-04-01 | Williams | North Dakota | 38105 | 10466 | 68 |
2361637 | 2361637 | 2022-03-31 | Williams | North Dakota | 38105 | 10464 | 68 |
2358383 | 2358383 | 2022-03-30 | Williams | North Dakota | 38105 | 10464 | 68 |
2355129 | 2355129 | 2022-03-29 | Williams | North Dakota | 38105 | 10464 | 68 |
2351876 | 2351876 | 2022-03-28 | Williams | North Dakota | 38105 | 10464 | 68 |
2348624 | 2348624 | 2022-03-27 | Williams | North Dakota | 38105 | 10464 | 68 |
2345371 | 2345371 | 2022-03-26 | Williams | North Dakota | 38105 | 10464 | 68 |
2342118 | 2342118 | 2022-03-25 | Williams | North Dakota | 38105 | 10464 | 68 |
2338865 | 2338865 | 2022-03-24 | Williams | North Dakota | 38105 | 10452 | 68 |
2335611 | 2335611 | 2022-03-23 | Williams | North Dakota | 38105 | 10452 | 68 |
2332357 | 2332357 | 2022-03-22 | Williams | North Dakota | 38105 | 10452 | 68 |
2329104 | 2329104 | 2022-03-21 | Williams | North Dakota | 38105 | 10452 | 68 |
2325852 | 2325852 | 2022-03-20 | Williams | North Dakota | 38105 | 10452 | 68 |
2322599 | 2322599 | 2022-03-19 | Williams | North Dakota | 38105 | 10452 | 68 |
2319345 | 2319345 | 2022-03-18 | Williams | North Dakota | 38105 | 10452 | 68 |
2316091 | 2316091 | 2022-03-17 | Williams | North Dakota | 38105 | 10452 | 68 |
2312838 | 2312838 | 2022-03-16 | Williams | North Dakota | 38105 | 10450 | 68 |
2309585 | 2309585 | 2022-03-15 | Williams | North Dakota | 38105 | 10451 | 68 |
2306332 | 2306332 | 2022-03-14 | Williams | North Dakota | 38105 | 10447 | 68 |
2303081 | 2303081 | 2022-03-13 | Williams | North Dakota | 38105 | 10447 | 68 |
2299829 | 2299829 | 2022-03-12 | Williams | North Dakota | 38105 | 10446 | 68 |
2296577 | 2296577 | 2022-03-11 | Williams | North Dakota | 38105 | 10442 | 68 |
2293325 | 2293325 | 2022-03-10 | Williams | North Dakota | 38105 | 10440 | 68 |
2290073 | 2290073 | 2022-03-09 | Williams | North Dakota | 38105 | 10436 | 68 |
2286821 | 2286821 | 2022-03-08 | Williams | North Dakota | 38105 | 10431 | 68 |
2283569 | 2283569 | 2022-03-07 | Williams | North Dakota | 38105 | 10428 | 68 |
2280317 | 2280317 | 2022-03-06 | Williams | North Dakota | 38105 | 10427 | 68 |
2277064 | 2277064 | 2022-03-05 | Williams | North Dakota | 38105 | 10422 | 68 |
2273811 | 2273811 | 2022-03-04 | Williams | North Dakota | 38105 | 10420 | 68 |
2270558 | 2270558 | 2022-03-03 | Williams | North Dakota | 38105 | 10407 | 68 |
2267306 | 2267306 | 2022-03-02 | Williams | North Dakota | 38105 | 10400 | 68 |
2264054 | 2264054 | 2022-03-01 | Williams | North Dakota | 38105 | 10396 | 68 |
2260803 | 2260803 | 2022-02-28 | Williams | North Dakota | 38105 | 10389 | 68 |
2257552 | 2257552 | 2022-02-27 | Williams | North Dakota | 38105 | 10387 | 68 |
2254301 | 2254301 | 2022-02-26 | Williams | North Dakota | 38105 | 10384 | 68 |
2251050 | 2251050 | 2022-02-25 | Williams | North Dakota | 38105 | 10379 | 68 |
2247799 | 2247799 | 2022-02-24 | Williams | North Dakota | 38105 | 10375 | 68 |
2244548 | 2244548 | 2022-02-23 | Williams | North Dakota | 38105 | 10365 | 68 |
2241297 | 2241297 | 2022-02-22 | Williams | North Dakota | 38105 | 10357 | 68 |
2238046 | 2238046 | 2022-02-21 | Williams | North Dakota | 38105 | 10356 | 68 |
2234795 | 2234795 | 2022-02-20 | Williams | North Dakota | 38105 | 10353 | 68 |
2231544 | 2231544 | 2022-02-19 | Williams | North Dakota | 38105 | 10341 | 68 |
2228293 | 2228293 | 2022-02-18 | Williams | North Dakota | 38105 | 10335 | 68 |
2225042 | 2225042 | 2022-02-17 | Williams | North Dakota | 38105 | 10326 | 68 |
2221791 | 2221791 | 2022-02-16 | Williams | North Dakota | 38105 | 10309 | 68 |
2218540 | 2218540 | 2022-02-15 | Williams | North Dakota | 38105 | 10289 | 68 |
2215289 | 2215289 | 2022-02-14 | Williams | North Dakota | 38105 | 10277 | 68 |
2212038 | 2212038 | 2022-02-13 | Williams | North Dakota | 38105 | 10273 | 68 |
2208785 | 2208785 | 2022-02-12 | Williams | North Dakota | 38105 | 10265 | 68 |
2205532 | 2205532 | 2022-02-11 | Williams | North Dakota | 38105 | 10252 | 68 |
2202279 | 2202279 | 2022-02-10 | Williams | North Dakota | 38105 | 10227 | 68 |
2199025 | 2199025 | 2022-02-09 | Williams | North Dakota | 38105 | 10198 | 67 |
2195771 | 2195771 | 2022-02-08 | Williams | North Dakota | 38105 | 10171 | 67 |
2192517 | 2192517 | 2022-02-07 | Williams | North Dakota | 38105 | 10150 | 67 |
2189263 | 2189263 | 2022-02-06 | Williams | North Dakota | 38105 | 10122 | 67 |
2186010 | 2186010 | 2022-02-05 | Williams | North Dakota | 38105 | 10122 | 67 |
2182758 | 2182758 | 2022-02-04 | Williams | North Dakota | 38105 | 10099 | 67 |
2179506 | 2179506 | 2022-02-03 | Williams | North Dakota | 38105 | 10062 | 67 |
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);