home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

748 rows where county = "Jefferson" and state = "Nebraska" sorted by date descending

✎ View and edit SQL

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

state 1

  • Nebraska · 748 ✖

fips 1

  • 31095 748

county 1

  • Jefferson · 748 ✖
Link rowid date ▲ county state fips cases deaths
2501296 2501296 2022-05-13 Jefferson Nebraska 31095 1216 7
2498038 2498038 2022-05-12 Jefferson Nebraska 31095 1215 7
2494780 2494780 2022-05-11 Jefferson Nebraska 31095 1215 7
2491522 2491522 2022-05-10 Jefferson Nebraska 31095 1209 7
2488264 2488264 2022-05-09 Jefferson Nebraska 31095 1209 7
2485007 2485007 2022-05-08 Jefferson Nebraska 31095 1210 7
2481749 2481749 2022-05-07 Jefferson Nebraska 31095 1210 7
2478491 2478491 2022-05-06 Jefferson Nebraska 31095 1210 7
2475233 2475233 2022-05-05 Jefferson Nebraska 31095 1210 7
2471976 2471976 2022-05-04 Jefferson Nebraska 31095 1210 7
2468720 2468720 2022-05-03 Jefferson Nebraska 31095 1210 7
2465464 2465464 2022-05-02 Jefferson Nebraska 31095 1210 7
2462209 2462209 2022-05-01 Jefferson Nebraska 31095 1210 7
2458953 2458953 2022-04-30 Jefferson Nebraska 31095 1210 7
2455697 2455697 2022-04-29 Jefferson Nebraska 31095 1210 7
2452441 2452441 2022-04-28 Jefferson Nebraska 31095 1210 7
2449185 2449185 2022-04-27 Jefferson Nebraska 31095 1210 7
2445928 2445928 2022-04-26 Jefferson Nebraska 31095 1210 7
2442673 2442673 2022-04-25 Jefferson Nebraska 31095 1210 7
2439417 2439417 2022-04-24 Jefferson Nebraska 31095 1210 7
2436161 2436161 2022-04-23 Jefferson Nebraska 31095 1210 7
2432905 2432905 2022-04-22 Jefferson Nebraska 31095 1210 7
2429649 2429649 2022-04-21 Jefferson Nebraska 31095 1210 7
2426393 2426393 2022-04-20 Jefferson Nebraska 31095 1210 7
2423137 2423137 2022-04-19 Jefferson Nebraska 31095 1210 7
2419880 2419880 2022-04-18 Jefferson Nebraska 31095 1210 7
2416625 2416625 2022-04-17 Jefferson Nebraska 31095 1210 7
2413369 2413369 2022-04-16 Jefferson Nebraska 31095 1210 7
2410113 2410113 2022-04-15 Jefferson Nebraska 31095 1210 7
2406857 2406857 2022-04-14 Jefferson Nebraska 31095 1210 7
2403601 2403601 2022-04-13 Jefferson Nebraska 31095 1210 7
2400346 2400346 2022-04-12 Jefferson Nebraska 31095 1209 6
2397091 2397091 2022-04-11 Jefferson Nebraska 31095 1209 6
2393836 2393836 2022-04-10 Jefferson Nebraska 31095 1209 6
2390580 2390580 2022-04-09 Jefferson Nebraska 31095 1209 6
2387324 2387324 2022-04-08 Jefferson Nebraska 31095 1209 6
2384069 2384069 2022-04-07 Jefferson Nebraska 31095 1209 6
2380814 2380814 2022-04-06 Jefferson Nebraska 31095 1209 6
2377559 2377559 2022-04-05 Jefferson Nebraska 31095 1209 6
2374306 2374306 2022-04-04 Jefferson Nebraska 31095 1209 6
2371054 2371054 2022-04-03 Jefferson Nebraska 31095 1209 6
2367801 2367801 2022-04-02 Jefferson Nebraska 31095 1209 6
2364548 2364548 2022-04-01 Jefferson Nebraska 31095 1209 6
2361294 2361294 2022-03-31 Jefferson Nebraska 31095 1209 6
2358040 2358040 2022-03-30 Jefferson Nebraska 31095 1210 6
2354787 2354787 2022-03-29 Jefferson Nebraska 31095 1211 6
2351534 2351534 2022-03-28 Jefferson Nebraska 31095 1210 6
2348282 2348282 2022-03-27 Jefferson Nebraska 31095 1210 6
2345029 2345029 2022-03-26 Jefferson Nebraska 31095 1210 6
2341776 2341776 2022-03-25 Jefferson Nebraska 31095 1210 6
2338523 2338523 2022-03-24 Jefferson Nebraska 31095 1210 6
2335269 2335269 2022-03-23 Jefferson Nebraska 31095 1211 6
2332015 2332015 2022-03-22 Jefferson Nebraska 31095 1211 6
2328762 2328762 2022-03-21 Jefferson Nebraska 31095 1211 6
2325510 2325510 2022-03-20 Jefferson Nebraska 31095 1211 6
2322256 2322256 2022-03-19 Jefferson Nebraska 31095 1211 6
2319002 2319002 2022-03-18 Jefferson Nebraska 31095 1213 6
2315749 2315749 2022-03-17 Jefferson Nebraska 31095 1213 6
2312496 2312496 2022-03-16 Jefferson Nebraska 31095 1213 6
2309243 2309243 2022-03-15 Jefferson Nebraska 31095 1213 6
2305991 2305991 2022-03-14 Jefferson Nebraska 31095 1213 6
2302740 2302740 2022-03-13 Jefferson Nebraska 31095 1213 6
2299488 2299488 2022-03-12 Jefferson Nebraska 31095 1213 6
2296236 2296236 2022-03-11 Jefferson Nebraska 31095 1213 6
2292984 2292984 2022-03-10 Jefferson Nebraska 31095 1213 6
2289732 2289732 2022-03-09 Jefferson Nebraska 31095 1213 6
2286480 2286480 2022-03-08 Jefferson Nebraska 31095 1213 6
2283228 2283228 2022-03-07 Jefferson Nebraska 31095 1213 6
2279975 2279975 2022-03-06 Jefferson Nebraska 31095 1213 6
2276722 2276722 2022-03-05 Jefferson Nebraska 31095 1213 6
2273469 2273469 2022-03-04 Jefferson Nebraska 31095 1213 6
2270217 2270217 2022-03-03 Jefferson Nebraska 31095 1212 6
2266964 2266964 2022-03-02 Jefferson Nebraska 31095 1213 6
2263713 2263713 2022-03-01 Jefferson Nebraska 31095 1213 6
2260462 2260462 2022-02-28 Jefferson Nebraska 31095 1213 6
2257211 2257211 2022-02-27 Jefferson Nebraska 31095 1179 6
2253960 2253960 2022-02-26 Jefferson Nebraska 31095 1179 6
2250709 2250709 2022-02-25 Jefferson Nebraska 31095 1179 6
2247458 2247458 2022-02-24 Jefferson Nebraska 31095 1179 6
2244207 2244207 2022-02-23 Jefferson Nebraska 31095 1180 6
2240956 2240956 2022-02-22 Jefferson Nebraska 31095 1180 6
2237705 2237705 2022-02-21 Jefferson Nebraska 31095 1181 6
2234454 2234454 2022-02-20 Jefferson Nebraska 31095 1181 6
2231203 2231203 2022-02-19 Jefferson Nebraska 31095 1181 6
2227952 2227952 2022-02-18 Jefferson Nebraska 31095 1181 6
2224701 2224701 2022-02-17 Jefferson Nebraska 31095 1182 6
2221450 2221450 2022-02-16 Jefferson Nebraska 31095 1179 6
2218199 2218199 2022-02-15 Jefferson Nebraska 31095 1180 6
2214948 2214948 2022-02-14 Jefferson Nebraska 31095 1177 6
2211696 2211696 2022-02-13 Jefferson Nebraska 31095 1172 6
2208443 2208443 2022-02-12 Jefferson Nebraska 31095 1172 6
2205190 2205190 2022-02-11 Jefferson Nebraska 31095 1172 6
2201937 2201937 2022-02-10 Jefferson Nebraska 31095 1170 6
2198683 2198683 2022-02-09 Jefferson Nebraska 31095 1169 6
2195429 2195429 2022-02-08 Jefferson Nebraska 31095 1169 6
2192175 2192175 2022-02-07 Jefferson Nebraska 31095 1169 6
2188922 2188922 2022-02-06 Jefferson Nebraska 31095 1168 6
2185669 2185669 2022-02-05 Jefferson Nebraska 31095 1168 6
2182417 2182417 2022-02-04 Jefferson Nebraska 31095 1168 6
2179165 2179165 2022-02-03 Jefferson Nebraska 31095 1167 6

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);
Powered by Datasette · Queries took 1505.691ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette