ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,564 rows where county = "Roosevelt" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501235 | 2501235 | 2022-05-13 | Roosevelt | Montana | 30085 | 3279 | 74 |
2501416 | 2501416 | 2022-05-13 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2497977 | 2497977 | 2022-05-12 | Roosevelt | Montana | 30085 | 3279 | 74 |
2498158 | 2498158 | 2022-05-12 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2494719 | 2494719 | 2022-05-11 | Roosevelt | Montana | 30085 | 3279 | 74 |
2494900 | 2494900 | 2022-05-11 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2491461 | 2491461 | 2022-05-10 | Roosevelt | Montana | 30085 | 3279 | 74 |
2491642 | 2491642 | 2022-05-10 | Roosevelt | New Mexico | 35041 | 5022 | 97 |
2488203 | 2488203 | 2022-05-09 | Roosevelt | Montana | 30085 | 3279 | 74 |
2488384 | 2488384 | 2022-05-09 | Roosevelt | New Mexico | 35041 | 5019 | 97 |
2484946 | 2484946 | 2022-05-08 | Roosevelt | Montana | 30085 | 3279 | 74 |
2485127 | 2485127 | 2022-05-08 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2481688 | 2481688 | 2022-05-07 | Roosevelt | Montana | 30085 | 3279 | 74 |
2481869 | 2481869 | 2022-05-07 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2478430 | 2478430 | 2022-05-06 | Roosevelt | Montana | 30085 | 3279 | 74 |
2478611 | 2478611 | 2022-05-06 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2475172 | 2475172 | 2022-05-05 | Roosevelt | Montana | 30085 | 3279 | 74 |
2475353 | 2475353 | 2022-05-05 | Roosevelt | New Mexico | 35041 | 5018 | 96 |
2471915 | 2471915 | 2022-05-04 | Roosevelt | Montana | 30085 | 3279 | 74 |
2472096 | 2472096 | 2022-05-04 | Roosevelt | New Mexico | 35041 | 5018 | 96 |
2468659 | 2468659 | 2022-05-03 | Roosevelt | Montana | 30085 | 3278 | 74 |
2468840 | 2468840 | 2022-05-03 | Roosevelt | New Mexico | 35041 | 5016 | 95 |
2465403 | 2465403 | 2022-05-02 | Roosevelt | Montana | 30085 | 3276 | 74 |
2465584 | 2465584 | 2022-05-02 | Roosevelt | New Mexico | 35041 | 5012 | 94 |
2462148 | 2462148 | 2022-05-01 | Roosevelt | Montana | 30085 | 3276 | 74 |
2462329 | 2462329 | 2022-05-01 | Roosevelt | New Mexico | 35041 | 5013 | 93 |
2458892 | 2458892 | 2022-04-30 | Roosevelt | Montana | 30085 | 3276 | 74 |
2459073 | 2459073 | 2022-04-30 | Roosevelt | New Mexico | 35041 | 5013 | 93 |
2455636 | 2455636 | 2022-04-29 | Roosevelt | Montana | 30085 | 3276 | 74 |
2455817 | 2455817 | 2022-04-29 | Roosevelt | New Mexico | 35041 | 5013 | 93 |
2452380 | 2452380 | 2022-04-28 | Roosevelt | Montana | 30085 | 3276 | 74 |
2452561 | 2452561 | 2022-04-28 | Roosevelt | New Mexico | 35041 | 5013 | 93 |
2449124 | 2449124 | 2022-04-27 | Roosevelt | Montana | 30085 | 3275 | 74 |
2449305 | 2449305 | 2022-04-27 | Roosevelt | New Mexico | 35041 | 5010 | 93 |
2445867 | 2445867 | 2022-04-26 | Roosevelt | Montana | 30085 | 3275 | 74 |
2446048 | 2446048 | 2022-04-26 | Roosevelt | New Mexico | 35041 | 5010 | 93 |
2442612 | 2442612 | 2022-04-25 | Roosevelt | Montana | 30085 | 3275 | 74 |
2442793 | 2442793 | 2022-04-25 | Roosevelt | New Mexico | 35041 | 5010 | 93 |
2439356 | 2439356 | 2022-04-24 | Roosevelt | Montana | 30085 | 3275 | 72 |
2439537 | 2439537 | 2022-04-24 | Roosevelt | New Mexico | 35041 | 5008 | 92 |
2436100 | 2436100 | 2022-04-23 | Roosevelt | Montana | 30085 | 3275 | 72 |
2436281 | 2436281 | 2022-04-23 | Roosevelt | New Mexico | 35041 | 5008 | 92 |
2432844 | 2432844 | 2022-04-22 | Roosevelt | Montana | 30085 | 3275 | 72 |
2433025 | 2433025 | 2022-04-22 | Roosevelt | New Mexico | 35041 | 5008 | 92 |
2429588 | 2429588 | 2022-04-21 | Roosevelt | Montana | 30085 | 3274 | 72 |
2429769 | 2429769 | 2022-04-21 | Roosevelt | New Mexico | 35041 | 5003 | 92 |
2426332 | 2426332 | 2022-04-20 | Roosevelt | Montana | 30085 | 3274 | 72 |
2426513 | 2426513 | 2022-04-20 | Roosevelt | New Mexico | 35041 | 5002 | 92 |
2423076 | 2423076 | 2022-04-19 | Roosevelt | Montana | 30085 | 3272 | 72 |
2423257 | 2423257 | 2022-04-19 | Roosevelt | New Mexico | 35041 | 5000 | 92 |
2419819 | 2419819 | 2022-04-18 | Roosevelt | Montana | 30085 | 3272 | 72 |
2420000 | 2420000 | 2022-04-18 | Roosevelt | New Mexico | 35041 | 5000 | 92 |
2416564 | 2416564 | 2022-04-17 | Roosevelt | Montana | 30085 | 3272 | 72 |
2416745 | 2416745 | 2022-04-17 | Roosevelt | New Mexico | 35041 | 4997 | 92 |
2413308 | 2413308 | 2022-04-16 | Roosevelt | Montana | 30085 | 3272 | 72 |
2413489 | 2413489 | 2022-04-16 | Roosevelt | New Mexico | 35041 | 4997 | 92 |
2410052 | 2410052 | 2022-04-15 | Roosevelt | Montana | 30085 | 3272 | 72 |
2410233 | 2410233 | 2022-04-15 | Roosevelt | New Mexico | 35041 | 4997 | 92 |
2406796 | 2406796 | 2022-04-14 | Roosevelt | Montana | 30085 | 3272 | 72 |
2406977 | 2406977 | 2022-04-14 | Roosevelt | New Mexico | 35041 | 4997 | 92 |
2403540 | 2403540 | 2022-04-13 | Roosevelt | Montana | 30085 | 3272 | 72 |
2403721 | 2403721 | 2022-04-13 | Roosevelt | New Mexico | 35041 | 4998 | 92 |
2400285 | 2400285 | 2022-04-12 | Roosevelt | Montana | 30085 | 3272 | 72 |
2400466 | 2400466 | 2022-04-12 | Roosevelt | New Mexico | 35041 | 4998 | 92 |
2397030 | 2397030 | 2022-04-11 | Roosevelt | Montana | 30085 | 3272 | 72 |
2397211 | 2397211 | 2022-04-11 | Roosevelt | New Mexico | 35041 | 4998 | 92 |
2393775 | 2393775 | 2022-04-10 | Roosevelt | Montana | 30085 | 3271 | 72 |
2393956 | 2393956 | 2022-04-10 | Roosevelt | New Mexico | 35041 | 4998 | 92 |
2390519 | 2390519 | 2022-04-09 | Roosevelt | Montana | 30085 | 3271 | 72 |
2390700 | 2390700 | 2022-04-09 | Roosevelt | New Mexico | 35041 | 4998 | 92 |
2387263 | 2387263 | 2022-04-08 | Roosevelt | Montana | 30085 | 3271 | 72 |
2387444 | 2387444 | 2022-04-08 | Roosevelt | New Mexico | 35041 | 4998 | 92 |
2384008 | 2384008 | 2022-04-07 | Roosevelt | Montana | 30085 | 3271 | 72 |
2384189 | 2384189 | 2022-04-07 | Roosevelt | New Mexico | 35041 | 4997 | 92 |
2380753 | 2380753 | 2022-04-06 | Roosevelt | Montana | 30085 | 3270 | 72 |
2380934 | 2380934 | 2022-04-06 | Roosevelt | New Mexico | 35041 | 4997 | 92 |
2377498 | 2377498 | 2022-04-05 | Roosevelt | Montana | 30085 | 3270 | 72 |
2377679 | 2377679 | 2022-04-05 | Roosevelt | New Mexico | 35041 | 4996 | 92 |
2374245 | 2374245 | 2022-04-04 | Roosevelt | Montana | 30085 | 3270 | 72 |
2374426 | 2374426 | 2022-04-04 | Roosevelt | New Mexico | 35041 | 4995 | 92 |
2370993 | 2370993 | 2022-04-03 | Roosevelt | Montana | 30085 | 3270 | 72 |
2371174 | 2371174 | 2022-04-03 | Roosevelt | New Mexico | 35041 | 4991 | 92 |
2367740 | 2367740 | 2022-04-02 | Roosevelt | Montana | 30085 | 3270 | 72 |
2367921 | 2367921 | 2022-04-02 | Roosevelt | New Mexico | 35041 | 4991 | 92 |
2364487 | 2364487 | 2022-04-01 | Roosevelt | Montana | 30085 | 3270 | 72 |
2364668 | 2364668 | 2022-04-01 | Roosevelt | New Mexico | 35041 | 4991 | 92 |
2361233 | 2361233 | 2022-03-31 | Roosevelt | Montana | 30085 | 3270 | 72 |
2361414 | 2361414 | 2022-03-31 | Roosevelt | New Mexico | 35041 | 4989 | 92 |
2357979 | 2357979 | 2022-03-30 | Roosevelt | Montana | 30085 | 3270 | 72 |
2358160 | 2358160 | 2022-03-30 | Roosevelt | New Mexico | 35041 | 4989 | 92 |
2354726 | 2354726 | 2022-03-29 | Roosevelt | Montana | 30085 | 3270 | 72 |
2354907 | 2354907 | 2022-03-29 | Roosevelt | New Mexico | 35041 | 4988 | 92 |
2351473 | 2351473 | 2022-03-28 | Roosevelt | Montana | 30085 | 3271 | 72 |
2351654 | 2351654 | 2022-03-28 | Roosevelt | New Mexico | 35041 | 4987 | 92 |
2348221 | 2348221 | 2022-03-27 | Roosevelt | Montana | 30085 | 3270 | 72 |
2348402 | 2348402 | 2022-03-27 | Roosevelt | New Mexico | 35041 | 4987 | 92 |
2344968 | 2344968 | 2022-03-26 | Roosevelt | Montana | 30085 | 3270 | 72 |
2345149 | 2345149 | 2022-03-26 | Roosevelt | New Mexico | 35041 | 4987 | 92 |
2341715 | 2341715 | 2022-03-25 | Roosevelt | Montana | 30085 | 3270 | 72 |
2341896 | 2341896 | 2022-03-25 | Roosevelt | New Mexico | 35041 | 4987 | 92 |
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);