ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

769 rows where fips = 31097 and state = "Nebraska" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, date (date)

state 1

  • Nebraska · 769 ✖

fips 1

  • 31097 · 769 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501297 2501297 2022-05-13 Johnson Nebraska 31097 873 10
2498039 2498039 2022-05-12 Johnson Nebraska 31097 872 10
2494781 2494781 2022-05-11 Johnson Nebraska 31097 872 10
2491523 2491523 2022-05-10 Johnson Nebraska 31097 895 10
2488265 2488265 2022-05-09 Johnson Nebraska 31097 895 10
2485008 2485008 2022-05-08 Johnson Nebraska 31097 895 10
2481750 2481750 2022-05-07 Johnson Nebraska 31097 895 10
2478492 2478492 2022-05-06 Johnson Nebraska 31097 895 10
2475234 2475234 2022-05-05 Johnson Nebraska 31097 895 10
2471977 2471977 2022-05-04 Johnson Nebraska 31097 892 10
2468721 2468721 2022-05-03 Johnson Nebraska 31097 891 10
2465465 2465465 2022-05-02 Johnson Nebraska 31097 893 10
2462210 2462210 2022-05-01 Johnson Nebraska 31097 893 10
2458954 2458954 2022-04-30 Johnson Nebraska 31097 893 10
2455698 2455698 2022-04-29 Johnson Nebraska 31097 893 10
2452442 2452442 2022-04-28 Johnson Nebraska 31097 894 10
2449186 2449186 2022-04-27 Johnson Nebraska 31097 894 10
2445929 2445929 2022-04-26 Johnson Nebraska 31097 895 10
2442674 2442674 2022-04-25 Johnson Nebraska 31097 895 10
2439418 2439418 2022-04-24 Johnson Nebraska 31097 895 10
2436162 2436162 2022-04-23 Johnson Nebraska 31097 895 10
2432906 2432906 2022-04-22 Johnson Nebraska 31097 895 10
2429650 2429650 2022-04-21 Johnson Nebraska 31097 869 10
2426394 2426394 2022-04-20 Johnson Nebraska 31097 869 10
2423138 2423138 2022-04-19 Johnson Nebraska 31097 869 10
2419881 2419881 2022-04-18 Johnson Nebraska 31097 870 10
2416626 2416626 2022-04-17 Johnson Nebraska 31097 870 10
2413370 2413370 2022-04-16 Johnson Nebraska 31097 870 10
2410114 2410114 2022-04-15 Johnson Nebraska 31097 870 10
2406858 2406858 2022-04-14 Johnson Nebraska 31097 870 10
2403602 2403602 2022-04-13 Johnson Nebraska 31097 870 10
2400347 2400347 2022-04-12 Johnson Nebraska 31097 868 10
2397092 2397092 2022-04-11 Johnson Nebraska 31097 868 10
2393837 2393837 2022-04-10 Johnson Nebraska 31097 868 10
2390581 2390581 2022-04-09 Johnson Nebraska 31097 868 10
2387325 2387325 2022-04-08 Johnson Nebraska 31097 868 10
2384070 2384070 2022-04-07 Johnson Nebraska 31097 868 10
2380815 2380815 2022-04-06 Johnson Nebraska 31097 868 10
2377560 2377560 2022-04-05 Johnson Nebraska 31097 868 10
2374307 2374307 2022-04-04 Johnson Nebraska 31097 868 10
2371055 2371055 2022-04-03 Johnson Nebraska 31097 868 10
2367802 2367802 2022-04-02 Johnson Nebraska 31097 868 10
2364549 2364549 2022-04-01 Johnson Nebraska 31097 868 10
2361295 2361295 2022-03-31 Johnson Nebraska 31097 868 10
2358041 2358041 2022-03-30 Johnson Nebraska 31097 868 10
2354788 2354788 2022-03-29 Johnson Nebraska 31097 868 10
2351535 2351535 2022-03-28 Johnson Nebraska 31097 868 10
2348283 2348283 2022-03-27 Johnson Nebraska 31097 867 10
2345030 2345030 2022-03-26 Johnson Nebraska 31097 867 10
2341777 2341777 2022-03-25 Johnson Nebraska 31097 867 10
2338524 2338524 2022-03-24 Johnson Nebraska 31097 867 10
2335270 2335270 2022-03-23 Johnson Nebraska 31097 867 10
2332016 2332016 2022-03-22 Johnson Nebraska 31097 867 10
2328763 2328763 2022-03-21 Johnson Nebraska 31097 867 10
2325511 2325511 2022-03-20 Johnson Nebraska 31097 867 10
2322257 2322257 2022-03-19 Johnson Nebraska 31097 867 10
2319003 2319003 2022-03-18 Johnson Nebraska 31097 867 10
2315750 2315750 2022-03-17 Johnson Nebraska 31097 867 10
2312497 2312497 2022-03-16 Johnson Nebraska 31097 867 10
2309244 2309244 2022-03-15 Johnson Nebraska 31097 867 10
2305992 2305992 2022-03-14 Johnson Nebraska 31097 867 10
2302741 2302741 2022-03-13 Johnson Nebraska 31097 867 10
2299489 2299489 2022-03-12 Johnson Nebraska 31097 867 10
2296237 2296237 2022-03-11 Johnson Nebraska 31097 867 10
2292985 2292985 2022-03-10 Johnson Nebraska 31097 867 10
2289733 2289733 2022-03-09 Johnson Nebraska 31097 867 10
2286481 2286481 2022-03-08 Johnson Nebraska 31097 867 10
2283229 2283229 2022-03-07 Johnson Nebraska 31097 867 10
2279976 2279976 2022-03-06 Johnson Nebraska 31097 867 10
2276723 2276723 2022-03-05 Johnson Nebraska 31097 867 10
2273470 2273470 2022-03-04 Johnson Nebraska 31097 867 10
2270218 2270218 2022-03-03 Johnson Nebraska 31097 866 10
2266965 2266965 2022-03-02 Johnson Nebraska 31097 866 10
2263714 2263714 2022-03-01 Johnson Nebraska 31097 865 10
2260463 2260463 2022-02-28 Johnson Nebraska 31097 865 10
2257212 2257212 2022-02-27 Johnson Nebraska 31097 878 10
2253961 2253961 2022-02-26 Johnson Nebraska 31097 878 10
2250710 2250710 2022-02-25 Johnson Nebraska 31097 878 10
2247459 2247459 2022-02-24 Johnson Nebraska 31097 878 10
2244208 2244208 2022-02-23 Johnson Nebraska 31097 878 10
2240957 2240957 2022-02-22 Johnson Nebraska 31097 878 10
2237706 2237706 2022-02-21 Johnson Nebraska 31097 878 10
2234455 2234455 2022-02-20 Johnson Nebraska 31097 877 10
2231204 2231204 2022-02-19 Johnson Nebraska 31097 877 10
2227953 2227953 2022-02-18 Johnson Nebraska 31097 877 10
2224702 2224702 2022-02-17 Johnson Nebraska 31097 876 10
2221451 2221451 2022-02-16 Johnson Nebraska 31097 877 10
2218200 2218200 2022-02-15 Johnson Nebraska 31097 877 10
2214949 2214949 2022-02-14 Johnson Nebraska 31097 874 10
2211697 2211697 2022-02-13 Johnson Nebraska 31097 874 10
2208444 2208444 2022-02-12 Johnson Nebraska 31097 874 10
2205191 2205191 2022-02-11 Johnson Nebraska 31097 874 10
2201938 2201938 2022-02-10 Johnson Nebraska 31097 873 10
2198684 2198684 2022-02-09 Johnson Nebraska 31097 872 10
2195430 2195430 2022-02-08 Johnson Nebraska 31097 871 10
2192176 2192176 2022-02-07 Johnson Nebraska 31097 867 10
2188923 2188923 2022-02-06 Johnson Nebraska 31097 866 10
2185670 2185670 2022-02-05 Johnson Nebraska 31097 866 10
2182418 2182418 2022-02-04 Johnson Nebraska 31097 866 10
2179166 2179166 2022-02-03 Johnson Nebraska 31097 859 10

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);