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

639 rows where fips = 31017 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 31017 · 639 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501257 2501257 2022-05-13 Brown Nebraska 31017 515 4
2497999 2497999 2022-05-12 Brown Nebraska 31017 512 4
2494741 2494741 2022-05-11 Brown Nebraska 31017 512 4
2491483 2491483 2022-05-10 Brown Nebraska 31017 523 4
2488225 2488225 2022-05-09 Brown Nebraska 31017 523 4
2484968 2484968 2022-05-08 Brown Nebraska 31017 523 4
2481710 2481710 2022-05-07 Brown Nebraska 31017 523 4
2478452 2478452 2022-05-06 Brown Nebraska 31017 523 4
2475194 2475194 2022-05-05 Brown Nebraska 31017 523 4
2471937 2471937 2022-05-04 Brown Nebraska 31017 523 4
2468681 2468681 2022-05-03 Brown Nebraska 31017 523 4
2465425 2465425 2022-05-02 Brown Nebraska 31017 523 4
2462170 2462170 2022-05-01 Brown Nebraska 31017 523 4
2458914 2458914 2022-04-30 Brown Nebraska 31017 523 4
2455658 2455658 2022-04-29 Brown Nebraska 31017 523 4
2452402 2452402 2022-04-28 Brown Nebraska 31017 523 4
2449146 2449146 2022-04-27 Brown Nebraska 31017 523 4
2445889 2445889 2022-04-26 Brown Nebraska 31017 523 4
2442634 2442634 2022-04-25 Brown Nebraska 31017 522 4
2439378 2439378 2022-04-24 Brown Nebraska 31017 522 4
2436122 2436122 2022-04-23 Brown Nebraska 31017 522 4
2432866 2432866 2022-04-22 Brown Nebraska 31017 522 4
2429610 2429610 2022-04-21 Brown Nebraska 31017 508 4
2426354 2426354 2022-04-20 Brown Nebraska 31017 508 4
2423098 2423098 2022-04-19 Brown Nebraska 31017 508 4
2419841 2419841 2022-04-18 Brown Nebraska 31017 508 4
2416586 2416586 2022-04-17 Brown Nebraska 31017 508 4
2413330 2413330 2022-04-16 Brown Nebraska 31017 508 4
2410074 2410074 2022-04-15 Brown Nebraska 31017 508 4
2406818 2406818 2022-04-14 Brown Nebraska 31017 508 4
2403562 2403562 2022-04-13 Brown Nebraska 31017 508 4
2400307 2400307 2022-04-12 Brown Nebraska 31017 508 4
2397052 2397052 2022-04-11 Brown Nebraska 31017 508 4
2393797 2393797 2022-04-10 Brown Nebraska 31017 508 4
2390541 2390541 2022-04-09 Brown Nebraska 31017 508 4
2387285 2387285 2022-04-08 Brown Nebraska 31017 508 4
2384030 2384030 2022-04-07 Brown Nebraska 31017 508 4
2380775 2380775 2022-04-06 Brown Nebraska 31017 507 4
2377520 2377520 2022-04-05 Brown Nebraska 31017 507 4
2374267 2374267 2022-04-04 Brown Nebraska 31017 507 4
2371015 2371015 2022-04-03 Brown Nebraska 31017 507 4
2367762 2367762 2022-04-02 Brown Nebraska 31017 507 4
2364509 2364509 2022-04-01 Brown Nebraska 31017 507 4
2361255 2361255 2022-03-31 Brown Nebraska 31017 507 4
2358001 2358001 2022-03-30 Brown Nebraska 31017 506 4
2354748 2354748 2022-03-29 Brown Nebraska 31017 506 4
2351495 2351495 2022-03-28 Brown Nebraska 31017 506 4
2348243 2348243 2022-03-27 Brown Nebraska 31017 506 4
2344990 2344990 2022-03-26 Brown Nebraska 31017 506 4
2341737 2341737 2022-03-25 Brown Nebraska 31017 506 4
2338484 2338484 2022-03-24 Brown Nebraska 31017 506 4
2335230 2335230 2022-03-23 Brown Nebraska 31017 507 4
2331976 2331976 2022-03-22 Brown Nebraska 31017 508 4
2328723 2328723 2022-03-21 Brown Nebraska 31017 508 4
2325471 2325471 2022-03-20 Brown Nebraska 31017 508 4
2322217 2322217 2022-03-19 Brown Nebraska 31017 508 4
2318963 2318963 2022-03-18 Brown Nebraska 31017 507 4
2315710 2315710 2022-03-17 Brown Nebraska 31017 507 4
2312457 2312457 2022-03-16 Brown Nebraska 31017 508 4
2309204 2309204 2022-03-15 Brown Nebraska 31017 507 4
2305952 2305952 2022-03-14 Brown Nebraska 31017 508 4
2302701 2302701 2022-03-13 Brown Nebraska 31017 508 4
2299449 2299449 2022-03-12 Brown Nebraska 31017 508 4
2296197 2296197 2022-03-11 Brown Nebraska 31017 508 4
2292945 2292945 2022-03-10 Brown Nebraska 31017 508 4
2289693 2289693 2022-03-09 Brown Nebraska 31017 507 4
2286441 2286441 2022-03-08 Brown Nebraska 31017 507 4
2283189 2283189 2022-03-07 Brown Nebraska 31017 506 4
2279936 2279936 2022-03-06 Brown Nebraska 31017 505 4
2276683 2276683 2022-03-05 Brown Nebraska 31017 505 4
2273430 2273430 2022-03-04 Brown Nebraska 31017 505 4
2270178 2270178 2022-03-03 Brown Nebraska 31017 505 4
2266925 2266925 2022-03-02 Brown Nebraska 31017 505 4
2263674 2263674 2022-03-01 Brown Nebraska 31017 504 4
2260423 2260423 2022-02-28 Brown Nebraska 31017 504 4
2257172 2257172 2022-02-27 Brown Nebraska 31017 501 4
2253921 2253921 2022-02-26 Brown Nebraska 31017 501 4
2250670 2250670 2022-02-25 Brown Nebraska 31017 501 4
2247419 2247419 2022-02-24 Brown Nebraska 31017 501 4
2244168 2244168 2022-02-23 Brown Nebraska 31017 501 4
2240917 2240917 2022-02-22 Brown Nebraska 31017 501 4
2237666 2237666 2022-02-21 Brown Nebraska 31017 501 4
2234415 2234415 2022-02-20 Brown Nebraska 31017 501 4
2231164 2231164 2022-02-19 Brown Nebraska 31017 501 4
2227913 2227913 2022-02-18 Brown Nebraska 31017 501 4
2224662 2224662 2022-02-17 Brown Nebraska 31017 501 4
2221411 2221411 2022-02-16 Brown Nebraska 31017 501 4
2218160 2218160 2022-02-15 Brown Nebraska 31017 498 4
2214909 2214909 2022-02-14 Brown Nebraska 31017 492 4
2211657 2211657 2022-02-13 Brown Nebraska 31017 491 4
2208404 2208404 2022-02-12 Brown Nebraska 31017 491 4
2205151 2205151 2022-02-11 Brown Nebraska 31017 491 4
2201898 2201898 2022-02-10 Brown Nebraska 31017 492 4
2198644 2198644 2022-02-09 Brown Nebraska 31017 492 4
2195390 2195390 2022-02-08 Brown Nebraska 31017 489 4
2192136 2192136 2022-02-07 Brown Nebraska 31017 489 4
2188883 2188883 2022-02-06 Brown Nebraska 31017 486 4
2185630 2185630 2022-02-05 Brown Nebraska 31017 486 4
2182378 2182378 2022-02-04 Brown Nebraska 31017 486 4
2179126 2179126 2022-02-03 Brown Nebraska 31017 486 4

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