ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,534 rows where county = "Roberts" 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 |
---|---|---|---|---|---|---|---|
2502099 | 2502099 | 2022-05-13 | Roberts | South Dakota | 46109 | 2436 | 53 |
2502404 | 2502404 | 2022-05-13 | Roberts | Texas | 48393 | 175 | 2 |
2498841 | 2498841 | 2022-05-12 | Roberts | South Dakota | 46109 | 2436 | 53 |
2499146 | 2499146 | 2022-05-12 | Roberts | Texas | 48393 | 175 | 2 |
2495583 | 2495583 | 2022-05-11 | Roberts | South Dakota | 46109 | 2436 | 53 |
2495888 | 2495888 | 2022-05-11 | Roberts | Texas | 48393 | 175 | 2 |
2492325 | 2492325 | 2022-05-10 | Roberts | South Dakota | 46109 | 2434 | 53 |
2492630 | 2492630 | 2022-05-10 | Roberts | Texas | 48393 | 175 | 2 |
2489067 | 2489067 | 2022-05-09 | Roberts | South Dakota | 46109 | 2434 | 53 |
2489372 | 2489372 | 2022-05-09 | Roberts | Texas | 48393 | 175 | 2 |
2485810 | 2485810 | 2022-05-08 | Roberts | South Dakota | 46109 | 2434 | 53 |
2486114 | 2486114 | 2022-05-08 | Roberts | Texas | 48393 | 175 | 2 |
2482552 | 2482552 | 2022-05-07 | Roberts | South Dakota | 46109 | 2434 | 53 |
2482856 | 2482856 | 2022-05-07 | Roberts | Texas | 48393 | 175 | 2 |
2479294 | 2479294 | 2022-05-06 | Roberts | South Dakota | 46109 | 2434 | 53 |
2479598 | 2479598 | 2022-05-06 | Roberts | Texas | 48393 | 175 | 2 |
2476036 | 2476036 | 2022-05-05 | Roberts | South Dakota | 46109 | 2434 | 53 |
2476340 | 2476340 | 2022-05-05 | Roberts | Texas | 48393 | 175 | 2 |
2472779 | 2472779 | 2022-05-04 | Roberts | South Dakota | 46109 | 2434 | 53 |
2473083 | 2473083 | 2022-05-04 | Roberts | Texas | 48393 | 175 | 2 |
2469523 | 2469523 | 2022-05-03 | Roberts | South Dakota | 46109 | 2430 | 53 |
2469827 | 2469827 | 2022-05-03 | Roberts | Texas | 48393 | 175 | 2 |
2466267 | 2466267 | 2022-05-02 | Roberts | South Dakota | 46109 | 2430 | 53 |
2466571 | 2466571 | 2022-05-02 | Roberts | Texas | 48393 | 175 | 2 |
2463012 | 2463012 | 2022-05-01 | Roberts | South Dakota | 46109 | 2430 | 53 |
2463316 | 2463316 | 2022-05-01 | Roberts | Texas | 48393 | 175 | 2 |
2459756 | 2459756 | 2022-04-30 | Roberts | South Dakota | 46109 | 2430 | 53 |
2460060 | 2460060 | 2022-04-30 | Roberts | Texas | 48393 | 175 | 2 |
2456500 | 2456500 | 2022-04-29 | Roberts | South Dakota | 46109 | 2430 | 53 |
2456804 | 2456804 | 2022-04-29 | Roberts | Texas | 48393 | 175 | 2 |
2453244 | 2453244 | 2022-04-28 | Roberts | South Dakota | 46109 | 2430 | 53 |
2453548 | 2453548 | 2022-04-28 | Roberts | Texas | 48393 | 175 | 2 |
2449988 | 2449988 | 2022-04-27 | Roberts | South Dakota | 46109 | 2430 | 53 |
2450292 | 2450292 | 2022-04-27 | Roberts | Texas | 48393 | 175 | 2 |
2446731 | 2446731 | 2022-04-26 | Roberts | South Dakota | 46109 | 2428 | 53 |
2447035 | 2447035 | 2022-04-26 | Roberts | Texas | 48393 | 175 | 2 |
2443476 | 2443476 | 2022-04-25 | Roberts | South Dakota | 46109 | 2428 | 53 |
2443780 | 2443780 | 2022-04-25 | Roberts | Texas | 48393 | 175 | 2 |
2440220 | 2440220 | 2022-04-24 | Roberts | South Dakota | 46109 | 2428 | 53 |
2440524 | 2440524 | 2022-04-24 | Roberts | Texas | 48393 | 175 | 2 |
2436964 | 2436964 | 2022-04-23 | Roberts | South Dakota | 46109 | 2428 | 53 |
2437268 | 2437268 | 2022-04-23 | Roberts | Texas | 48393 | 175 | 2 |
2433708 | 2433708 | 2022-04-22 | Roberts | South Dakota | 46109 | 2428 | 53 |
2434012 | 2434012 | 2022-04-22 | Roberts | Texas | 48393 | 175 | 2 |
2430452 | 2430452 | 2022-04-21 | Roberts | South Dakota | 46109 | 2428 | 53 |
2430756 | 2430756 | 2022-04-21 | Roberts | Texas | 48393 | 175 | 2 |
2427196 | 2427196 | 2022-04-20 | Roberts | South Dakota | 46109 | 2428 | 53 |
2427500 | 2427500 | 2022-04-20 | Roberts | Texas | 48393 | 175 | 2 |
2423940 | 2423940 | 2022-04-19 | Roberts | South Dakota | 46109 | 2427 | 53 |
2424244 | 2424244 | 2022-04-19 | Roberts | Texas | 48393 | 175 | 2 |
2420684 | 2420684 | 2022-04-18 | Roberts | South Dakota | 46109 | 2427 | 53 |
2420988 | 2420988 | 2022-04-18 | Roberts | Texas | 48393 | 175 | 2 |
2417428 | 2417428 | 2022-04-17 | Roberts | South Dakota | 46109 | 2427 | 53 |
2417732 | 2417732 | 2022-04-17 | Roberts | Texas | 48393 | 175 | 2 |
2414172 | 2414172 | 2022-04-16 | Roberts | South Dakota | 46109 | 2427 | 53 |
2414476 | 2414476 | 2022-04-16 | Roberts | Texas | 48393 | 175 | 2 |
2410916 | 2410916 | 2022-04-15 | Roberts | South Dakota | 46109 | 2427 | 53 |
2411220 | 2411220 | 2022-04-15 | Roberts | Texas | 48393 | 175 | 2 |
2407660 | 2407660 | 2022-04-14 | Roberts | South Dakota | 46109 | 2427 | 53 |
2407964 | 2407964 | 2022-04-14 | Roberts | Texas | 48393 | 175 | 2 |
2404404 | 2404404 | 2022-04-13 | Roberts | South Dakota | 46109 | 2427 | 53 |
2404708 | 2404708 | 2022-04-13 | Roberts | Texas | 48393 | 175 | 2 |
2401149 | 2401149 | 2022-04-12 | Roberts | South Dakota | 46109 | 2427 | 53 |
2401453 | 2401453 | 2022-04-12 | Roberts | Texas | 48393 | 175 | 2 |
2397894 | 2397894 | 2022-04-11 | Roberts | South Dakota | 46109 | 2427 | 53 |
2398198 | 2398198 | 2022-04-11 | Roberts | Texas | 48393 | 174 | 2 |
2394639 | 2394639 | 2022-04-10 | Roberts | South Dakota | 46109 | 2427 | 53 |
2394943 | 2394943 | 2022-04-10 | Roberts | Texas | 48393 | 174 | 2 |
2391383 | 2391383 | 2022-04-09 | Roberts | South Dakota | 46109 | 2427 | 53 |
2391687 | 2391687 | 2022-04-09 | Roberts | Texas | 48393 | 174 | 2 |
2388127 | 2388127 | 2022-04-08 | Roberts | South Dakota | 46109 | 2427 | 53 |
2388431 | 2388431 | 2022-04-08 | Roberts | Texas | 48393 | 174 | 2 |
2384872 | 2384872 | 2022-04-07 | Roberts | South Dakota | 46109 | 2427 | 53 |
2385176 | 2385176 | 2022-04-07 | Roberts | Texas | 48393 | 174 | 2 |
2381617 | 2381617 | 2022-04-06 | Roberts | South Dakota | 46109 | 2427 | 53 |
2381921 | 2381921 | 2022-04-06 | Roberts | Texas | 48393 | 174 | 2 |
2378362 | 2378362 | 2022-04-05 | Roberts | South Dakota | 46109 | 2424 | 52 |
2378666 | 2378666 | 2022-04-05 | Roberts | Texas | 48393 | 174 | 2 |
2375108 | 2375108 | 2022-04-04 | Roberts | South Dakota | 46109 | 2424 | 52 |
2375412 | 2375412 | 2022-04-04 | Roberts | Texas | 48393 | 174 | 2 |
2371856 | 2371856 | 2022-04-03 | Roberts | South Dakota | 46109 | 2424 | 52 |
2372160 | 2372160 | 2022-04-03 | Roberts | Texas | 48393 | 174 | 2 |
2368603 | 2368603 | 2022-04-02 | Roberts | South Dakota | 46109 | 2424 | 52 |
2368907 | 2368907 | 2022-04-02 | Roberts | Texas | 48393 | 174 | 2 |
2365350 | 2365350 | 2022-04-01 | Roberts | South Dakota | 46109 | 2424 | 52 |
2365654 | 2365654 | 2022-04-01 | Roberts | Texas | 48393 | 174 | 2 |
2362097 | 2362097 | 2022-03-31 | Roberts | South Dakota | 46109 | 2424 | 52 |
2362401 | 2362401 | 2022-03-31 | Roberts | Texas | 48393 | 174 | 2 |
2358843 | 2358843 | 2022-03-30 | Roberts | South Dakota | 46109 | 2424 | 52 |
2359147 | 2359147 | 2022-03-30 | Roberts | Texas | 48393 | 174 | 2 |
2355589 | 2355589 | 2022-03-29 | Roberts | South Dakota | 46109 | 2423 | 52 |
2355893 | 2355893 | 2022-03-29 | Roberts | Texas | 48393 | 174 | 2 |
2352336 | 2352336 | 2022-03-28 | Roberts | South Dakota | 46109 | 2423 | 52 |
2352640 | 2352640 | 2022-03-28 | Roberts | Texas | 48393 | 173 | 2 |
2349084 | 2349084 | 2022-03-27 | Roberts | South Dakota | 46109 | 2423 | 52 |
2349388 | 2349388 | 2022-03-27 | Roberts | Texas | 48393 | 173 | 2 |
2345831 | 2345831 | 2022-03-26 | Roberts | South Dakota | 46109 | 2423 | 52 |
2346135 | 2346135 | 2022-03-26 | Roberts | Texas | 48393 | 173 | 2 |
2342578 | 2342578 | 2022-03-25 | Roberts | South Dakota | 46109 | 2423 | 52 |
2342882 | 2342882 | 2022-03-25 | Roberts | Texas | 48393 | 173 | 2 |
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);