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

2,344 rows where county = "Noble" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 3

fips 3

county 1

  • Noble · 2,344 ✖
Link rowid date ▲ county state fips cases deaths
2500336 2500336 2022-05-13 Noble Indiana 18113 13139 157
2501704 2501704 2022-05-13 Noble Ohio 39121 3220 58
2501784 2501784 2022-05-13 Noble Oklahoma 40103 3050 39
2497078 2497078 2022-05-12 Noble Indiana 18113 13126 157
2498446 2498446 2022-05-12 Noble Ohio 39121 3220 58
2498526 2498526 2022-05-12 Noble Oklahoma 40103 3050 39
2493820 2493820 2022-05-11 Noble Indiana 18113 13126 157
2495188 2495188 2022-05-11 Noble Ohio 39121 3210 58
2495268 2495268 2022-05-11 Noble Oklahoma 40103 3044 39
2490562 2490562 2022-05-10 Noble Indiana 18113 13118 157
2491930 2491930 2022-05-10 Noble Ohio 39121 3210 58
2492010 2492010 2022-05-10 Noble Oklahoma 40103 3044 39
2487305 2487305 2022-05-09 Noble Indiana 18113 13118 157
2488672 2488672 2022-05-09 Noble Ohio 39121 3210 58
2488752 2488752 2022-05-09 Noble Oklahoma 40103 3044 39
2484047 2484047 2022-05-08 Noble Indiana 18113 13100 157
2485415 2485415 2022-05-08 Noble Ohio 39121 3210 58
2485495 2485495 2022-05-08 Noble Oklahoma 40103 3044 39
2480789 2480789 2022-05-07 Noble Indiana 18113 13100 157
2482157 2482157 2022-05-07 Noble Ohio 39121 3210 58
2482237 2482237 2022-05-07 Noble Oklahoma 40103 3044 39
2477531 2477531 2022-05-06 Noble Indiana 18113 13100 157
2478899 2478899 2022-05-06 Noble Ohio 39121 3210 58
2478979 2478979 2022-05-06 Noble Oklahoma 40103 3044 39
2474273 2474273 2022-05-05 Noble Indiana 18113 13100 157
2475641 2475641 2022-05-05 Noble Ohio 39121 3210 58
2475721 2475721 2022-05-05 Noble Oklahoma 40103 3044 39
2471016 2471016 2022-05-04 Noble Indiana 18113 13100 157
2472384 2472384 2022-05-04 Noble Ohio 39121 3207 57
2472464 2472464 2022-05-04 Noble Oklahoma 40103 3041 39
2467760 2467760 2022-05-03 Noble Indiana 18113 13094 157
2469128 2469128 2022-05-03 Noble Ohio 39121 3207 57
2469208 2469208 2022-05-03 Noble Oklahoma 40103 3041 39
2464505 2464505 2022-05-02 Noble Indiana 18113 13094 157
2465872 2465872 2022-05-02 Noble Ohio 39121 3207 57
2465952 2465952 2022-05-02 Noble Oklahoma 40103 3041 39
2461249 2461249 2022-05-01 Noble Indiana 18113 13090 157
2462617 2462617 2022-05-01 Noble Ohio 39121 3207 57
2462697 2462697 2022-05-01 Noble Oklahoma 40103 3041 39
2457993 2457993 2022-04-30 Noble Indiana 18113 13090 157
2459361 2459361 2022-04-30 Noble Ohio 39121 3207 57
2459441 2459441 2022-04-30 Noble Oklahoma 40103 3041 39
2454737 2454737 2022-04-29 Noble Indiana 18113 13090 157
2456105 2456105 2022-04-29 Noble Ohio 39121 3207 57
2456185 2456185 2022-04-29 Noble Oklahoma 40103 3041 39
2451481 2451481 2022-04-28 Noble Indiana 18113 13084 157
2452849 2452849 2022-04-28 Noble Ohio 39121 3207 57
2452929 2452929 2022-04-28 Noble Oklahoma 40103 3041 39
2448225 2448225 2022-04-27 Noble Indiana 18113 13084 157
2449593 2449593 2022-04-27 Noble Ohio 39121 3208 57
2449673 2449673 2022-04-27 Noble Oklahoma 40103 3034 39
2444969 2444969 2022-04-26 Noble Indiana 18113 13081 157
2446336 2446336 2022-04-26 Noble Ohio 39121 3208 57
2446416 2446416 2022-04-26 Noble Oklahoma 40103 3034 39
2441713 2441713 2022-04-25 Noble Indiana 18113 13081 157
2443081 2443081 2022-04-25 Noble Ohio 39121 3208 57
2443161 2443161 2022-04-25 Noble Oklahoma 40103 3034 39
2438457 2438457 2022-04-24 Noble Indiana 18113 13077 157
2439825 2439825 2022-04-24 Noble Ohio 39121 3208 57
2439905 2439905 2022-04-24 Noble Oklahoma 40103 3034 39
2435201 2435201 2022-04-23 Noble Indiana 18113 13077 157
2436569 2436569 2022-04-23 Noble Ohio 39121 3208 57
2436649 2436649 2022-04-23 Noble Oklahoma 40103 3034 39
2431945 2431945 2022-04-22 Noble Indiana 18113 13077 157
2433313 2433313 2022-04-22 Noble Ohio 39121 3208 57
2433393 2433393 2022-04-22 Noble Oklahoma 40103 3034 39
2428689 2428689 2022-04-21 Noble Indiana 18113 13075 157
2430057 2430057 2022-04-21 Noble Ohio 39121 3208 57
2430137 2430137 2022-04-21 Noble Oklahoma 40103 3034 39
2425433 2425433 2022-04-20 Noble Indiana 18113 13075 157
2426801 2426801 2022-04-20 Noble Ohio 39121 3207 57
2426881 2426881 2022-04-20 Noble Oklahoma 40103 3026 38
2422177 2422177 2022-04-19 Noble Indiana 18113 13074 157
2423545 2423545 2022-04-19 Noble Ohio 39121 3207 57
2423625 2423625 2022-04-19 Noble Oklahoma 40103 3026 38
2418921 2418921 2022-04-18 Noble Indiana 18113 13074 157
2420288 2420288 2022-04-18 Noble Ohio 39121 3207 57
2420368 2420368 2022-04-18 Noble Oklahoma 40103 3026 38
2415665 2415665 2022-04-17 Noble Indiana 18113 13069 157
2417033 2417033 2022-04-17 Noble Ohio 39121 3207 57
2417113 2417113 2022-04-17 Noble Oklahoma 40103 3026 38
2412409 2412409 2022-04-16 Noble Indiana 18113 13069 157
2413777 2413777 2022-04-16 Noble Ohio 39121 3207 57
2413857 2413857 2022-04-16 Noble Oklahoma 40103 3026 38
2409153 2409153 2022-04-15 Noble Indiana 18113 13069 157
2410521 2410521 2022-04-15 Noble Ohio 39121 3207 57
2410601 2410601 2022-04-15 Noble Oklahoma 40103 3026 38
2405897 2405897 2022-04-14 Noble Indiana 18113 13069 157
2407265 2407265 2022-04-14 Noble Ohio 39121 3207 57
2407345 2407345 2022-04-14 Noble Oklahoma 40103 3026 38
2402642 2402642 2022-04-13 Noble Indiana 18113 13069 157
2404009 2404009 2022-04-13 Noble Ohio 39121 3205 57
2404089 2404089 2022-04-13 Noble Oklahoma 40103 3025 38
2399387 2399387 2022-04-12 Noble Indiana 18113 13069 157
2400754 2400754 2022-04-12 Noble Ohio 39121 3205 57
2400834 2400834 2022-04-12 Noble Oklahoma 40103 3025 38
2396132 2396132 2022-04-11 Noble Indiana 18113 13069 157
2397499 2397499 2022-04-11 Noble Ohio 39121 3205 57
2397579 2397579 2022-04-11 Noble Oklahoma 40103 3025 38
2392876 2392876 2022-04-10 Noble Indiana 18113 13069 157

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