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

765 rows where county = "Noble", fips = 39121 and state = "Ohio" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Ohio · 765 ✖

fips 1

  • 39121 · 765 ✖

county 1

  • Noble · 765 ✖
Link rowid date ▲ county state fips cases deaths
2501704 2501704 2022-05-13 Noble Ohio 39121 3220 58
2498446 2498446 2022-05-12 Noble Ohio 39121 3220 58
2495188 2495188 2022-05-11 Noble Ohio 39121 3210 58
2491930 2491930 2022-05-10 Noble Ohio 39121 3210 58
2488672 2488672 2022-05-09 Noble Ohio 39121 3210 58
2485415 2485415 2022-05-08 Noble Ohio 39121 3210 58
2482157 2482157 2022-05-07 Noble Ohio 39121 3210 58
2478899 2478899 2022-05-06 Noble Ohio 39121 3210 58
2475641 2475641 2022-05-05 Noble Ohio 39121 3210 58
2472384 2472384 2022-05-04 Noble Ohio 39121 3207 57
2469128 2469128 2022-05-03 Noble Ohio 39121 3207 57
2465872 2465872 2022-05-02 Noble Ohio 39121 3207 57
2462617 2462617 2022-05-01 Noble Ohio 39121 3207 57
2459361 2459361 2022-04-30 Noble Ohio 39121 3207 57
2456105 2456105 2022-04-29 Noble Ohio 39121 3207 57
2452849 2452849 2022-04-28 Noble Ohio 39121 3207 57
2449593 2449593 2022-04-27 Noble Ohio 39121 3208 57
2446336 2446336 2022-04-26 Noble Ohio 39121 3208 57
2443081 2443081 2022-04-25 Noble Ohio 39121 3208 57
2439825 2439825 2022-04-24 Noble Ohio 39121 3208 57
2436569 2436569 2022-04-23 Noble Ohio 39121 3208 57
2433313 2433313 2022-04-22 Noble Ohio 39121 3208 57
2430057 2430057 2022-04-21 Noble Ohio 39121 3208 57
2426801 2426801 2022-04-20 Noble Ohio 39121 3207 57
2423545 2423545 2022-04-19 Noble Ohio 39121 3207 57
2420288 2420288 2022-04-18 Noble Ohio 39121 3207 57
2417033 2417033 2022-04-17 Noble Ohio 39121 3207 57
2413777 2413777 2022-04-16 Noble Ohio 39121 3207 57
2410521 2410521 2022-04-15 Noble Ohio 39121 3207 57
2407265 2407265 2022-04-14 Noble Ohio 39121 3207 57
2404009 2404009 2022-04-13 Noble Ohio 39121 3205 57
2400754 2400754 2022-04-12 Noble Ohio 39121 3205 57
2397499 2397499 2022-04-11 Noble Ohio 39121 3205 57
2394244 2394244 2022-04-10 Noble Ohio 39121 3205 57
2390988 2390988 2022-04-09 Noble Ohio 39121 3205 57
2387732 2387732 2022-04-08 Noble Ohio 39121 3205 57
2384477 2384477 2022-04-07 Noble Ohio 39121 3205 57
2381222 2381222 2022-04-06 Noble Ohio 39121 3203 56
2377967 2377967 2022-04-05 Noble Ohio 39121 3203 56
2374713 2374713 2022-04-04 Noble Ohio 39121 3203 56
2371461 2371461 2022-04-03 Noble Ohio 39121 3203 56
2368208 2368208 2022-04-02 Noble Ohio 39121 3203 56
2364955 2364955 2022-04-01 Noble Ohio 39121 3203 56
2361702 2361702 2022-03-31 Noble Ohio 39121 3203 56
2358448 2358448 2022-03-30 Noble Ohio 39121 3201 55
2355194 2355194 2022-03-29 Noble Ohio 39121 3201 55
2351941 2351941 2022-03-28 Noble Ohio 39121 3201 55
2348689 2348689 2022-03-27 Noble Ohio 39121 3201 55
2345436 2345436 2022-03-26 Noble Ohio 39121 3201 55
2342183 2342183 2022-03-25 Noble Ohio 39121 3201 55
2338930 2338930 2022-03-24 Noble Ohio 39121 3201 55
2335676 2335676 2022-03-23 Noble Ohio 39121 3201 55
2332422 2332422 2022-03-22 Noble Ohio 39121 3201 55
2329169 2329169 2022-03-21 Noble Ohio 39121 3201 55
2325917 2325917 2022-03-20 Noble Ohio 39121 3201 55
2322664 2322664 2022-03-19 Noble Ohio 39121 3201 55
2319410 2319410 2022-03-18 Noble Ohio 39121 3201 55
2316156 2316156 2022-03-17 Noble Ohio 39121 3201 55
2312903 2312903 2022-03-16 Noble Ohio 39121 3197 55
2309650 2309650 2022-03-15 Noble Ohio 39121 3197 55
2306397 2306397 2022-03-14 Noble Ohio 39121 3197 55
2303146 2303146 2022-03-13 Noble Ohio 39121 3197 55
2299894 2299894 2022-03-12 Noble Ohio 39121 3197 55
2296642 2296642 2022-03-11 Noble Ohio 39121 3196 55
2293390 2293390 2022-03-10 Noble Ohio 39121 3196 55
2290138 2290138 2022-03-09 Noble Ohio 39121 3191 55
2286886 2286886 2022-03-08 Noble Ohio 39121 3191 55
2283634 2283634 2022-03-07 Noble Ohio 39121 3191 54
2280382 2280382 2022-03-06 Noble Ohio 39121 3190 54
2277129 2277129 2022-03-05 Noble Ohio 39121 3189 54
2273876 2273876 2022-03-04 Noble Ohio 39121 3188 54
2270623 2270623 2022-03-03 Noble Ohio 39121 3186 54
2267371 2267371 2022-03-02 Noble Ohio 39121 3186 54
2264118 2264118 2022-03-01 Noble Ohio 39121 3185 54
2260868 2260868 2022-02-28 Noble Ohio 39121 3182 54
2257617 2257617 2022-02-27 Noble Ohio 39121 3181 54
2254366 2254366 2022-02-26 Noble Ohio 39121 3181 54
2251115 2251115 2022-02-25 Noble Ohio 39121 3180 54
2247864 2247864 2022-02-24 Noble Ohio 39121 3177 54
2244613 2244613 2022-02-23 Noble Ohio 39121 3175 54
2241362 2241362 2022-02-22 Noble Ohio 39121 3168 54
2238111 2238111 2022-02-21 Noble Ohio 39121 3162 53
2234860 2234860 2022-02-20 Noble Ohio 39121 3160 53
2231609 2231609 2022-02-19 Noble Ohio 39121 3160 53
2228358 2228358 2022-02-18 Noble Ohio 39121 3158 53
2225107 2225107 2022-02-17 Noble Ohio 39121 3156 53
2221856 2221856 2022-02-16 Noble Ohio 39121 3153 53
2218605 2218605 2022-02-15 Noble Ohio 39121 3149 53
2215354 2215354 2022-02-14 Noble Ohio 39121 3141 53
2212103 2212103 2022-02-13 Noble Ohio 39121 3140 53
2208850 2208850 2022-02-12 Noble Ohio 39121 3139 53
2205597 2205597 2022-02-11 Noble Ohio 39121 3136 53
2202344 2202344 2022-02-10 Noble Ohio 39121 3132 53
2199090 2199090 2022-02-09 Noble Ohio 39121 3128 53
2195836 2195836 2022-02-08 Noble Ohio 39121 3128 53
2192582 2192582 2022-02-07 Noble Ohio 39121 3123 53
2189328 2189328 2022-02-06 Noble Ohio 39121 3121 53
2186075 2186075 2022-02-05 Noble Ohio 39121 3120 53
2182823 2182823 2022-02-04 Noble Ohio 39121 3119 53
2179571 2179571 2022-02-03 Noble Ohio 39121 3117 53

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