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

796 rows where county = "Noble" and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Indiana · 796 ✖

fips 1

county 1

  • Noble · 796 ✖
Link rowid date ▲ county state fips cases deaths
2500336 2500336 2022-05-13 Noble Indiana 18113 13139 157
2497078 2497078 2022-05-12 Noble Indiana 18113 13126 157
2493820 2493820 2022-05-11 Noble Indiana 18113 13126 157
2490562 2490562 2022-05-10 Noble Indiana 18113 13118 157
2487305 2487305 2022-05-09 Noble Indiana 18113 13118 157
2484047 2484047 2022-05-08 Noble Indiana 18113 13100 157
2480789 2480789 2022-05-07 Noble Indiana 18113 13100 157
2477531 2477531 2022-05-06 Noble Indiana 18113 13100 157
2474273 2474273 2022-05-05 Noble Indiana 18113 13100 157
2471016 2471016 2022-05-04 Noble Indiana 18113 13100 157
2467760 2467760 2022-05-03 Noble Indiana 18113 13094 157
2464505 2464505 2022-05-02 Noble Indiana 18113 13094 157
2461249 2461249 2022-05-01 Noble Indiana 18113 13090 157
2457993 2457993 2022-04-30 Noble Indiana 18113 13090 157
2454737 2454737 2022-04-29 Noble Indiana 18113 13090 157
2451481 2451481 2022-04-28 Noble Indiana 18113 13084 157
2448225 2448225 2022-04-27 Noble Indiana 18113 13084 157
2444969 2444969 2022-04-26 Noble Indiana 18113 13081 157
2441713 2441713 2022-04-25 Noble Indiana 18113 13081 157
2438457 2438457 2022-04-24 Noble Indiana 18113 13077 157
2435201 2435201 2022-04-23 Noble Indiana 18113 13077 157
2431945 2431945 2022-04-22 Noble Indiana 18113 13077 157
2428689 2428689 2022-04-21 Noble Indiana 18113 13075 157
2425433 2425433 2022-04-20 Noble Indiana 18113 13075 157
2422177 2422177 2022-04-19 Noble Indiana 18113 13074 157
2418921 2418921 2022-04-18 Noble Indiana 18113 13074 157
2415665 2415665 2022-04-17 Noble Indiana 18113 13069 157
2412409 2412409 2022-04-16 Noble Indiana 18113 13069 157
2409153 2409153 2022-04-15 Noble Indiana 18113 13069 157
2405897 2405897 2022-04-14 Noble Indiana 18113 13069 157
2402642 2402642 2022-04-13 Noble Indiana 18113 13069 157
2399387 2399387 2022-04-12 Noble Indiana 18113 13069 157
2396132 2396132 2022-04-11 Noble Indiana 18113 13069 157
2392876 2392876 2022-04-10 Noble Indiana 18113 13069 157
2389620 2389620 2022-04-09 Noble Indiana 18113 13069 157
2386365 2386365 2022-04-08 Noble Indiana 18113 13069 157
2383110 2383110 2022-04-07 Noble Indiana 18113 13069 157
2379855 2379855 2022-04-06 Noble Indiana 18113 13069 157
2376601 2376601 2022-04-05 Noble Indiana 18113 13066 156
2373349 2373349 2022-04-04 Noble Indiana 18113 13066 156
2370096 2370096 2022-04-03 Noble Indiana 18113 13064 156
2366843 2366843 2022-04-02 Noble Indiana 18113 13064 156
2363590 2363590 2022-04-01 Noble Indiana 18113 13064 156
2360336 2360336 2022-03-31 Noble Indiana 18113 13059 156
2357082 2357082 2022-03-30 Noble Indiana 18113 13059 156
2353829 2353829 2022-03-29 Noble Indiana 18113 13064 156
2350577 2350577 2022-03-28 Noble Indiana 18113 13063 156
2347324 2347324 2022-03-27 Noble Indiana 18113 13059 156
2344071 2344071 2022-03-26 Noble Indiana 18113 13059 156
2340818 2340818 2022-03-25 Noble Indiana 18113 13059 156
2337565 2337565 2022-03-24 Noble Indiana 18113 13057 156
2334311 2334311 2022-03-23 Noble Indiana 18113 13055 156
2331057 2331057 2022-03-22 Noble Indiana 18113 13053 156
2327805 2327805 2022-03-21 Noble Indiana 18113 13053 156
2324552 2324552 2022-03-20 Noble Indiana 18113 13051 156
2321298 2321298 2022-03-19 Noble Indiana 18113 13051 156
2318044 2318044 2022-03-18 Noble Indiana 18113 13051 156
2314791 2314791 2022-03-17 Noble Indiana 18113 13050 156
2311538 2311538 2022-03-16 Noble Indiana 18113 13048 156
2308285 2308285 2022-03-15 Noble Indiana 18113 13047 156
2305034 2305034 2022-03-14 Noble Indiana 18113 13044 156
2301782 2301782 2022-03-13 Noble Indiana 18113 13037 156
2298530 2298530 2022-03-12 Noble Indiana 18113 13037 156
2295278 2295278 2022-03-11 Noble Indiana 18113 13037 156
2292026 2292026 2022-03-10 Noble Indiana 18113 13035 156
2288774 2288774 2022-03-09 Noble Indiana 18113 13033 156
2285523 2285523 2022-03-08 Noble Indiana 18113 13032 156
2282271 2282271 2022-03-07 Noble Indiana 18113 13032 156
2279018 2279018 2022-03-06 Noble Indiana 18113 13032 156
2275765 2275765 2022-03-05 Noble Indiana 18113 13032 156
2272512 2272512 2022-03-04 Noble Indiana 18113 13032 156
2269260 2269260 2022-03-03 Noble Indiana 18113 13027 156
2266007 2266007 2022-03-02 Noble Indiana 18113 13026 155
2262756 2262756 2022-03-01 Noble Indiana 18113 13021 155
2259505 2259505 2022-02-28 Noble Indiana 18113 13020 155
2256254 2256254 2022-02-27 Noble Indiana 18113 13016 155
2253003 2253003 2022-02-26 Noble Indiana 18113 13016 155
2249752 2249752 2022-02-25 Noble Indiana 18113 13016 155
2246501 2246501 2022-02-24 Noble Indiana 18113 13012 154
2243250 2243250 2022-02-23 Noble Indiana 18113 13007 154
2239999 2239999 2022-02-22 Noble Indiana 18113 12998 154
2236748 2236748 2022-02-21 Noble Indiana 18113 12992 153
2233497 2233497 2022-02-20 Noble Indiana 18113 12974 152
2230246 2230246 2022-02-19 Noble Indiana 18113 12974 152
2226995 2226995 2022-02-18 Noble Indiana 18113 12974 152
2223744 2223744 2022-02-17 Noble Indiana 18113 12955 152
2220493 2220493 2022-02-16 Noble Indiana 18113 12943 152
2217242 2217242 2022-02-15 Noble Indiana 18113 12930 151
2213991 2213991 2022-02-14 Noble Indiana 18113 12921 151
2210739 2210739 2022-02-13 Noble Indiana 18113 12901 151
2207486 2207486 2022-02-12 Noble Indiana 18113 12901 151
2204233 2204233 2022-02-11 Noble Indiana 18113 12901 151
2200980 2200980 2022-02-10 Noble Indiana 18113 12881 151
2197726 2197726 2022-02-09 Noble Indiana 18113 12851 149
2194472 2194472 2022-02-08 Noble Indiana 18113 12851 149
2191218 2191218 2022-02-07 Noble Indiana 18113 12839 149
2187965 2187965 2022-02-06 Noble Indiana 18113 12797 149
2184712 2184712 2022-02-05 Noble Indiana 18113 12797 149
2181460 2181460 2022-02-04 Noble Indiana 18113 12797 149
2178209 2178209 2022-02-03 Noble Indiana 18113 12777 149

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