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

795 rows where county = "Adams" and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

state 1

  • Indiana · 795 ✖

fips 1

county 1

  • Adams · 795 ✖
Link rowid date ▲ county state fips cases deaths
2500280 2500280 2022-05-13 Adams Indiana 18001 7288 112
2497022 2497022 2022-05-12 Adams Indiana 18001 7284 112
2493764 2493764 2022-05-11 Adams Indiana 18001 7284 112
2490506 2490506 2022-05-10 Adams Indiana 18001 7281 112
2487249 2487249 2022-05-09 Adams Indiana 18001 7281 112
2483991 2483991 2022-05-08 Adams Indiana 18001 7276 112
2480733 2480733 2022-05-07 Adams Indiana 18001 7276 112
2477475 2477475 2022-05-06 Adams Indiana 18001 7276 112
2474217 2474217 2022-05-05 Adams Indiana 18001 7276 112
2470960 2470960 2022-05-04 Adams Indiana 18001 7276 112
2467704 2467704 2022-05-03 Adams Indiana 18001 7275 112
2464449 2464449 2022-05-02 Adams Indiana 18001 7275 112
2461193 2461193 2022-05-01 Adams Indiana 18001 7275 112
2457937 2457937 2022-04-30 Adams Indiana 18001 7275 112
2454681 2454681 2022-04-29 Adams Indiana 18001 7275 112
2451425 2451425 2022-04-28 Adams Indiana 18001 7273 112
2448169 2448169 2022-04-27 Adams Indiana 18001 7273 112
2444913 2444913 2022-04-26 Adams Indiana 18001 7268 112
2441657 2441657 2022-04-25 Adams Indiana 18001 7268 112
2438401 2438401 2022-04-24 Adams Indiana 18001 7266 112
2435145 2435145 2022-04-23 Adams Indiana 18001 7266 112
2431889 2431889 2022-04-22 Adams Indiana 18001 7266 112
2428633 2428633 2022-04-21 Adams Indiana 18001 7265 112
2425377 2425377 2022-04-20 Adams Indiana 18001 7265 112
2422121 2422121 2022-04-19 Adams Indiana 18001 7264 112
2418865 2418865 2022-04-18 Adams Indiana 18001 7264 112
2415609 2415609 2022-04-17 Adams Indiana 18001 7263 112
2412353 2412353 2022-04-16 Adams Indiana 18001 7263 112
2409097 2409097 2022-04-15 Adams Indiana 18001 7263 112
2405841 2405841 2022-04-14 Adams Indiana 18001 7263 112
2402586 2402586 2022-04-13 Adams Indiana 18001 7263 112
2399331 2399331 2022-04-12 Adams Indiana 18001 7261 112
2396076 2396076 2022-04-11 Adams Indiana 18001 7261 112
2392820 2392820 2022-04-10 Adams Indiana 18001 7259 112
2389564 2389564 2022-04-09 Adams Indiana 18001 7259 112
2386309 2386309 2022-04-08 Adams Indiana 18001 7259 112
2383054 2383054 2022-04-07 Adams Indiana 18001 7259 112
2379799 2379799 2022-04-06 Adams Indiana 18001 7259 112
2376545 2376545 2022-04-05 Adams Indiana 18001 7259 112
2373293 2373293 2022-04-04 Adams Indiana 18001 7259 112
2370040 2370040 2022-04-03 Adams Indiana 18001 7258 112
2366787 2366787 2022-04-02 Adams Indiana 18001 7258 112
2363534 2363534 2022-04-01 Adams Indiana 18001 7258 112
2360280 2360280 2022-03-31 Adams Indiana 18001 7258 112
2357026 2357026 2022-03-30 Adams Indiana 18001 7258 112
2353773 2353773 2022-03-29 Adams Indiana 18001 7331 112
2350521 2350521 2022-03-28 Adams Indiana 18001 7331 112
2347268 2347268 2022-03-27 Adams Indiana 18001 7331 112
2344015 2344015 2022-03-26 Adams Indiana 18001 7331 112
2340762 2340762 2022-03-25 Adams Indiana 18001 7331 112
2337509 2337509 2022-03-24 Adams Indiana 18001 7331 112
2334255 2334255 2022-03-23 Adams Indiana 18001 7329 112
2331001 2331001 2022-03-22 Adams Indiana 18001 7330 112
2327749 2327749 2022-03-21 Adams Indiana 18001 7330 112
2324496 2324496 2022-03-20 Adams Indiana 18001 7330 112
2321242 2321242 2022-03-19 Adams Indiana 18001 7330 112
2317988 2317988 2022-03-18 Adams Indiana 18001 7330 112
2314735 2314735 2022-03-17 Adams Indiana 18001 7329 112
2311482 2311482 2022-03-16 Adams Indiana 18001 7328 112
2308229 2308229 2022-03-15 Adams Indiana 18001 7326 112
2304978 2304978 2022-03-14 Adams Indiana 18001 7324 112
2301726 2301726 2022-03-13 Adams Indiana 18001 7323 112
2298474 2298474 2022-03-12 Adams Indiana 18001 7323 112
2295222 2295222 2022-03-11 Adams Indiana 18001 7323 112
2291970 2291970 2022-03-10 Adams Indiana 18001 7322 112
2288718 2288718 2022-03-09 Adams Indiana 18001 7320 112
2285467 2285467 2022-03-08 Adams Indiana 18001 7319 112
2282215 2282215 2022-03-07 Adams Indiana 18001 7318 112
2278962 2278962 2022-03-06 Adams Indiana 18001 7317 112
2275709 2275709 2022-03-05 Adams Indiana 18001 7317 112
2272456 2272456 2022-03-04 Adams Indiana 18001 7317 112
2269204 2269204 2022-03-03 Adams Indiana 18001 7316 112
2265951 2265951 2022-03-02 Adams Indiana 18001 7314 112
2262700 2262700 2022-03-01 Adams Indiana 18001 7313 112
2259449 2259449 2022-02-28 Adams Indiana 18001 7309 112
2256198 2256198 2022-02-27 Adams Indiana 18001 7305 112
2252947 2252947 2022-02-26 Adams Indiana 18001 7305 112
2249696 2249696 2022-02-25 Adams Indiana 18001 7305 112
2246445 2246445 2022-02-24 Adams Indiana 18001 7303 112
2243194 2243194 2022-02-23 Adams Indiana 18001 7303 111
2239943 2239943 2022-02-22 Adams Indiana 18001 7299 111
2236692 2236692 2022-02-21 Adams Indiana 18001 7297 111
2233441 2233441 2022-02-20 Adams Indiana 18001 7292 111
2230190 2230190 2022-02-19 Adams Indiana 18001 7292 111
2226939 2226939 2022-02-18 Adams Indiana 18001 7292 111
2223688 2223688 2022-02-17 Adams Indiana 18001 7291 111
2220437 2220437 2022-02-16 Adams Indiana 18001 7289 110
2217186 2217186 2022-02-15 Adams Indiana 18001 7288 110
2213935 2213935 2022-02-14 Adams Indiana 18001 7287 109
2210683 2210683 2022-02-13 Adams Indiana 18001 7272 108
2207430 2207430 2022-02-12 Adams Indiana 18001 7272 108
2204177 2204177 2022-02-11 Adams Indiana 18001 7272 108
2200924 2200924 2022-02-10 Adams Indiana 18001 7266 108
2197670 2197670 2022-02-09 Adams Indiana 18001 7245 108
2194416 2194416 2022-02-08 Adams Indiana 18001 7245 108
2191162 2191162 2022-02-07 Adams Indiana 18001 7238 107
2187909 2187909 2022-02-06 Adams Indiana 18001 7215 106
2184656 2184656 2022-02-05 Adams Indiana 18001 7215 106
2181404 2181404 2022-02-04 Adams Indiana 18001 7215 106
2178153 2178153 2022-02-03 Adams Indiana 18001 7204 106

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