ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,500 rows where county = "Holt" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501119 | 2501119 | 2022-05-13 | Holt | Missouri | 29087 | 1060 | 30 |
2501293 | 2501293 | 2022-05-13 | Holt | Nebraska | 31089 | 2179 | 20 |
2497861 | 2497861 | 2022-05-12 | Holt | Missouri | 29087 | 1058 | 30 |
2498035 | 2498035 | 2022-05-12 | Holt | Nebraska | 31089 | 2177 | 20 |
2494603 | 2494603 | 2022-05-11 | Holt | Missouri | 29087 | 1058 | 30 |
2494777 | 2494777 | 2022-05-11 | Holt | Nebraska | 31089 | 2177 | 20 |
2491345 | 2491345 | 2022-05-10 | Holt | Missouri | 29087 | 1058 | 30 |
2491519 | 2491519 | 2022-05-10 | Holt | Nebraska | 31089 | 2163 | 20 |
2488087 | 2488087 | 2022-05-09 | Holt | Missouri | 29087 | 1058 | 30 |
2488261 | 2488261 | 2022-05-09 | Holt | Nebraska | 31089 | 2163 | 20 |
2484830 | 2484830 | 2022-05-08 | Holt | Missouri | 29087 | 1058 | 30 |
2485004 | 2485004 | 2022-05-08 | Holt | Nebraska | 31089 | 2162 | 20 |
2481572 | 2481572 | 2022-05-07 | Holt | Missouri | 29087 | 1058 | 30 |
2481746 | 2481746 | 2022-05-07 | Holt | Nebraska | 31089 | 2162 | 20 |
2478314 | 2478314 | 2022-05-06 | Holt | Missouri | 29087 | 1058 | 30 |
2478488 | 2478488 | 2022-05-06 | Holt | Nebraska | 31089 | 2162 | 20 |
2475056 | 2475056 | 2022-05-05 | Holt | Missouri | 29087 | 1055 | 30 |
2475230 | 2475230 | 2022-05-05 | Holt | Nebraska | 31089 | 2162 | 20 |
2471799 | 2471799 | 2022-05-04 | Holt | Missouri | 29087 | 1055 | 29 |
2471973 | 2471973 | 2022-05-04 | Holt | Nebraska | 31089 | 2162 | 20 |
2468543 | 2468543 | 2022-05-03 | Holt | Missouri | 29087 | 1055 | 29 |
2468717 | 2468717 | 2022-05-03 | Holt | Nebraska | 31089 | 2162 | 20 |
2465287 | 2465287 | 2022-05-02 | Holt | Missouri | 29087 | 1055 | 29 |
2465461 | 2465461 | 2022-05-02 | Holt | Nebraska | 31089 | 2163 | 20 |
2462032 | 2462032 | 2022-05-01 | Holt | Missouri | 29087 | 1055 | 29 |
2462206 | 2462206 | 2022-05-01 | Holt | Nebraska | 31089 | 2163 | 20 |
2458776 | 2458776 | 2022-04-30 | Holt | Missouri | 29087 | 1055 | 29 |
2458950 | 2458950 | 2022-04-30 | Holt | Nebraska | 31089 | 2163 | 20 |
2455520 | 2455520 | 2022-04-29 | Holt | Missouri | 29087 | 1055 | 29 |
2455694 | 2455694 | 2022-04-29 | Holt | Nebraska | 31089 | 2163 | 20 |
2452264 | 2452264 | 2022-04-28 | Holt | Missouri | 29087 | 1055 | 29 |
2452438 | 2452438 | 2022-04-28 | Holt | Nebraska | 31089 | 2161 | 20 |
2449008 | 2449008 | 2022-04-27 | Holt | Missouri | 29087 | 1055 | 29 |
2449182 | 2449182 | 2022-04-27 | Holt | Nebraska | 31089 | 2161 | 20 |
2445751 | 2445751 | 2022-04-26 | Holt | Missouri | 29087 | 1055 | 29 |
2445925 | 2445925 | 2022-04-26 | Holt | Nebraska | 31089 | 2160 | 20 |
2442496 | 2442496 | 2022-04-25 | Holt | Missouri | 29087 | 1055 | 29 |
2442670 | 2442670 | 2022-04-25 | Holt | Nebraska | 31089 | 2157 | 20 |
2439240 | 2439240 | 2022-04-24 | Holt | Missouri | 29087 | 1055 | 29 |
2439414 | 2439414 | 2022-04-24 | Holt | Nebraska | 31089 | 2157 | 20 |
2435984 | 2435984 | 2022-04-23 | Holt | Missouri | 29087 | 1055 | 29 |
2436158 | 2436158 | 2022-04-23 | Holt | Nebraska | 31089 | 2157 | 20 |
2432728 | 2432728 | 2022-04-22 | Holt | Missouri | 29087 | 1055 | 29 |
2432902 | 2432902 | 2022-04-22 | Holt | Nebraska | 31089 | 2157 | 20 |
2429472 | 2429472 | 2022-04-21 | Holt | Missouri | 29087 | 1055 | 29 |
2429646 | 2429646 | 2022-04-21 | Holt | Nebraska | 31089 | 2157 | 20 |
2426216 | 2426216 | 2022-04-20 | Holt | Missouri | 29087 | 1055 | 29 |
2426390 | 2426390 | 2022-04-20 | Holt | Nebraska | 31089 | 2157 | 20 |
2422960 | 2422960 | 2022-04-19 | Holt | Missouri | 29087 | 1055 | 29 |
2423134 | 2423134 | 2022-04-19 | Holt | Nebraska | 31089 | 2157 | 20 |
2419703 | 2419703 | 2022-04-18 | Holt | Missouri | 29087 | 1055 | 29 |
2419877 | 2419877 | 2022-04-18 | Holt | Nebraska | 31089 | 2155 | 20 |
2416448 | 2416448 | 2022-04-17 | Holt | Missouri | 29087 | 1055 | 29 |
2416622 | 2416622 | 2022-04-17 | Holt | Nebraska | 31089 | 2155 | 20 |
2413192 | 2413192 | 2022-04-16 | Holt | Missouri | 29087 | 1055 | 29 |
2413366 | 2413366 | 2022-04-16 | Holt | Nebraska | 31089 | 2155 | 20 |
2409936 | 2409936 | 2022-04-15 | Holt | Missouri | 29087 | 1055 | 29 |
2410110 | 2410110 | 2022-04-15 | Holt | Nebraska | 31089 | 2155 | 20 |
2406680 | 2406680 | 2022-04-14 | Holt | Missouri | 29087 | 1055 | 29 |
2406854 | 2406854 | 2022-04-14 | Holt | Nebraska | 31089 | 2155 | 20 |
2403424 | 2403424 | 2022-04-13 | Holt | Missouri | 29087 | 1055 | 29 |
2403598 | 2403598 | 2022-04-13 | Holt | Nebraska | 31089 | 2155 | 20 |
2400169 | 2400169 | 2022-04-12 | Holt | Missouri | 29087 | 1055 | 29 |
2400343 | 2400343 | 2022-04-12 | Holt | Nebraska | 31089 | 2150 | 18 |
2396914 | 2396914 | 2022-04-11 | Holt | Missouri | 29087 | 1055 | 29 |
2397088 | 2397088 | 2022-04-11 | Holt | Nebraska | 31089 | 2150 | 18 |
2393659 | 2393659 | 2022-04-10 | Holt | Missouri | 29087 | 1055 | 29 |
2393833 | 2393833 | 2022-04-10 | Holt | Nebraska | 31089 | 2150 | 18 |
2390403 | 2390403 | 2022-04-09 | Holt | Missouri | 29087 | 1055 | 29 |
2390577 | 2390577 | 2022-04-09 | Holt | Nebraska | 31089 | 2150 | 18 |
2387147 | 2387147 | 2022-04-08 | Holt | Missouri | 29087 | 1055 | 29 |
2387321 | 2387321 | 2022-04-08 | Holt | Nebraska | 31089 | 2150 | 18 |
2383892 | 2383892 | 2022-04-07 | Holt | Missouri | 29087 | 1055 | 29 |
2384066 | 2384066 | 2022-04-07 | Holt | Nebraska | 31089 | 2150 | 18 |
2380637 | 2380637 | 2022-04-06 | Holt | Missouri | 29087 | 1055 | 29 |
2380811 | 2380811 | 2022-04-06 | Holt | Nebraska | 31089 | 2150 | 18 |
2377382 | 2377382 | 2022-04-05 | Holt | Missouri | 29087 | 1055 | 29 |
2377556 | 2377556 | 2022-04-05 | Holt | Nebraska | 31089 | 2150 | 18 |
2374129 | 2374129 | 2022-04-04 | Holt | Missouri | 29087 | 1055 | 29 |
2374303 | 2374303 | 2022-04-04 | Holt | Nebraska | 31089 | 2150 | 18 |
2370877 | 2370877 | 2022-04-03 | Holt | Missouri | 29087 | 1055 | 29 |
2371051 | 2371051 | 2022-04-03 | Holt | Nebraska | 31089 | 2150 | 18 |
2367624 | 2367624 | 2022-04-02 | Holt | Missouri | 29087 | 1055 | 29 |
2367798 | 2367798 | 2022-04-02 | Holt | Nebraska | 31089 | 2150 | 18 |
2364371 | 2364371 | 2022-04-01 | Holt | Missouri | 29087 | 1055 | 29 |
2364545 | 2364545 | 2022-04-01 | Holt | Nebraska | 31089 | 2150 | 18 |
2361117 | 2361117 | 2022-03-31 | Holt | Missouri | 29087 | 1055 | 29 |
2361291 | 2361291 | 2022-03-31 | Holt | Nebraska | 31089 | 2150 | 18 |
2357863 | 2357863 | 2022-03-30 | Holt | Missouri | 29087 | 1055 | 29 |
2358037 | 2358037 | 2022-03-30 | Holt | Nebraska | 31089 | 2149 | 18 |
2354610 | 2354610 | 2022-03-29 | Holt | Missouri | 29087 | 1055 | 29 |
2354784 | 2354784 | 2022-03-29 | Holt | Nebraska | 31089 | 2147 | 18 |
2351357 | 2351357 | 2022-03-28 | Holt | Missouri | 29087 | 1054 | 29 |
2351531 | 2351531 | 2022-03-28 | Holt | Nebraska | 31089 | 2148 | 18 |
2348105 | 2348105 | 2022-03-27 | Holt | Missouri | 29087 | 1054 | 29 |
2348279 | 2348279 | 2022-03-27 | Holt | Nebraska | 31089 | 2142 | 18 |
2344852 | 2344852 | 2022-03-26 | Holt | Missouri | 29087 | 1054 | 29 |
2345026 | 2345026 | 2022-03-26 | Holt | Nebraska | 31089 | 2142 | 18 |
2341599 | 2341599 | 2022-03-25 | Holt | Missouri | 29087 | 1054 | 29 |
2341773 | 2341773 | 2022-03-25 | Holt | Nebraska | 31089 | 2142 | 18 |
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);