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

777 rows where fips = 18025 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 · 777 ✖

fips 1

  • 18025 · 777 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500292 2500292 2022-05-13 Crawford Indiana 18025 2560 40
2497034 2497034 2022-05-12 Crawford Indiana 18025 2560 40
2493776 2493776 2022-05-11 Crawford Indiana 18025 2560 40
2490518 2490518 2022-05-10 Crawford Indiana 18025 2559 40
2487261 2487261 2022-05-09 Crawford Indiana 18025 2559 40
2484003 2484003 2022-05-08 Crawford Indiana 18025 2558 40
2480745 2480745 2022-05-07 Crawford Indiana 18025 2558 40
2477487 2477487 2022-05-06 Crawford Indiana 18025 2558 40
2474229 2474229 2022-05-05 Crawford Indiana 18025 2558 40
2470972 2470972 2022-05-04 Crawford Indiana 18025 2558 40
2467716 2467716 2022-05-03 Crawford Indiana 18025 2554 40
2464461 2464461 2022-05-02 Crawford Indiana 18025 2554 40
2461205 2461205 2022-05-01 Crawford Indiana 18025 2554 40
2457949 2457949 2022-04-30 Crawford Indiana 18025 2554 40
2454693 2454693 2022-04-29 Crawford Indiana 18025 2554 40
2451437 2451437 2022-04-28 Crawford Indiana 18025 2552 40
2448181 2448181 2022-04-27 Crawford Indiana 18025 2552 40
2444925 2444925 2022-04-26 Crawford Indiana 18025 2552 40
2441669 2441669 2022-04-25 Crawford Indiana 18025 2552 40
2438413 2438413 2022-04-24 Crawford Indiana 18025 2551 40
2435157 2435157 2022-04-23 Crawford Indiana 18025 2551 40
2431901 2431901 2022-04-22 Crawford Indiana 18025 2551 40
2428645 2428645 2022-04-21 Crawford Indiana 18025 2551 40
2425389 2425389 2022-04-20 Crawford Indiana 18025 2551 40
2422133 2422133 2022-04-19 Crawford Indiana 18025 2551 40
2418877 2418877 2022-04-18 Crawford Indiana 18025 2551 40
2415621 2415621 2022-04-17 Crawford Indiana 18025 2548 40
2412365 2412365 2022-04-16 Crawford Indiana 18025 2548 40
2409109 2409109 2022-04-15 Crawford Indiana 18025 2548 40
2405853 2405853 2022-04-14 Crawford Indiana 18025 2548 40
2402598 2402598 2022-04-13 Crawford Indiana 18025 2548 40
2399343 2399343 2022-04-12 Crawford Indiana 18025 2547 40
2396088 2396088 2022-04-11 Crawford Indiana 18025 2547 40
2392832 2392832 2022-04-10 Crawford Indiana 18025 2546 40
2389576 2389576 2022-04-09 Crawford Indiana 18025 2546 40
2386321 2386321 2022-04-08 Crawford Indiana 18025 2546 40
2383066 2383066 2022-04-07 Crawford Indiana 18025 2546 40
2379811 2379811 2022-04-06 Crawford Indiana 18025 2546 40
2376557 2376557 2022-04-05 Crawford Indiana 18025 2546 39
2373305 2373305 2022-04-04 Crawford Indiana 18025 2546 39
2370052 2370052 2022-04-03 Crawford Indiana 18025 2546 39
2366799 2366799 2022-04-02 Crawford Indiana 18025 2546 39
2363546 2363546 2022-04-01 Crawford Indiana 18025 2546 39
2360292 2360292 2022-03-31 Crawford Indiana 18025 2546 38
2357038 2357038 2022-03-30 Crawford Indiana 18025 2546 38
2353785 2353785 2022-03-29 Crawford Indiana 18025 2548 38
2350533 2350533 2022-03-28 Crawford Indiana 18025 2547 38
2347280 2347280 2022-03-27 Crawford Indiana 18025 2545 38
2344027 2344027 2022-03-26 Crawford Indiana 18025 2545 38
2340774 2340774 2022-03-25 Crawford Indiana 18025 2545 38
2337521 2337521 2022-03-24 Crawford Indiana 18025 2544 38
2334267 2334267 2022-03-23 Crawford Indiana 18025 2544 38
2331013 2331013 2022-03-22 Crawford Indiana 18025 2542 38
2327761 2327761 2022-03-21 Crawford Indiana 18025 2542 38
2324508 2324508 2022-03-20 Crawford Indiana 18025 2542 38
2321254 2321254 2022-03-19 Crawford Indiana 18025 2542 38
2318000 2318000 2022-03-18 Crawford Indiana 18025 2542 38
2314747 2314747 2022-03-17 Crawford Indiana 18025 2541 37
2311494 2311494 2022-03-16 Crawford Indiana 18025 2541 37
2308241 2308241 2022-03-15 Crawford Indiana 18025 2540 37
2304990 2304990 2022-03-14 Crawford Indiana 18025 2539 37
2301738 2301738 2022-03-13 Crawford Indiana 18025 2538 37
2298486 2298486 2022-03-12 Crawford Indiana 18025 2538 37
2295234 2295234 2022-03-11 Crawford Indiana 18025 2538 37
2291982 2291982 2022-03-10 Crawford Indiana 18025 2538 37
2288730 2288730 2022-03-09 Crawford Indiana 18025 2536 37
2285479 2285479 2022-03-08 Crawford Indiana 18025 2535 36
2282227 2282227 2022-03-07 Crawford Indiana 18025 2534 36
2278974 2278974 2022-03-06 Crawford Indiana 18025 2532 36
2275721 2275721 2022-03-05 Crawford Indiana 18025 2532 36
2272468 2272468 2022-03-04 Crawford Indiana 18025 2532 36
2269216 2269216 2022-03-03 Crawford Indiana 18025 2528 36
2265963 2265963 2022-03-02 Crawford Indiana 18025 2526 36
2262712 2262712 2022-03-01 Crawford Indiana 18025 2523 35
2259461 2259461 2022-02-28 Crawford Indiana 18025 2519 35
2256210 2256210 2022-02-27 Crawford Indiana 18025 2513 35
2252959 2252959 2022-02-26 Crawford Indiana 18025 2513 35
2249708 2249708 2022-02-25 Crawford Indiana 18025 2513 35
2246457 2246457 2022-02-24 Crawford Indiana 18025 2509 35
2243206 2243206 2022-02-23 Crawford Indiana 18025 2507 35
2239955 2239955 2022-02-22 Crawford Indiana 18025 2506 35
2236704 2236704 2022-02-21 Crawford Indiana 18025 2505 35
2233453 2233453 2022-02-20 Crawford Indiana 18025 2500 35
2230202 2230202 2022-02-19 Crawford Indiana 18025 2500 35
2226951 2226951 2022-02-18 Crawford Indiana 18025 2500 35
2223700 2223700 2022-02-17 Crawford Indiana 18025 2495 35
2220449 2220449 2022-02-16 Crawford Indiana 18025 2486 35
2217198 2217198 2022-02-15 Crawford Indiana 18025 2482 35
2213947 2213947 2022-02-14 Crawford Indiana 18025 2478 35
2210695 2210695 2022-02-13 Crawford Indiana 18025 2470 35
2207442 2207442 2022-02-12 Crawford Indiana 18025 2470 35
2204189 2204189 2022-02-11 Crawford Indiana 18025 2470 35
2200936 2200936 2022-02-10 Crawford Indiana 18025 2463 35
2197682 2197682 2022-02-09 Crawford Indiana 18025 2438 35
2194428 2194428 2022-02-08 Crawford Indiana 18025 2438 35
2191174 2191174 2022-02-07 Crawford Indiana 18025 2431 35
2187921 2187921 2022-02-06 Crawford Indiana 18025 2420 35
2184668 2184668 2022-02-05 Crawford Indiana 18025 2420 35
2181416 2181416 2022-02-04 Crawford Indiana 18025 2420 35
2178165 2178165 2022-02-03 Crawford Indiana 18025 2410 35

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