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 county = "McLean" and fips = 38055 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 38055 · 777 ✖

county 1

  • McLean · 777 ✖
Link rowid date ▲ county state fips cases deaths
2501613 2501613 2022-05-13 McLean North Dakota 38055 2737 49
2498355 2498355 2022-05-12 McLean North Dakota 38055 2729 49
2495097 2495097 2022-05-11 McLean North Dakota 38055 2729 49
2491839 2491839 2022-05-10 McLean North Dakota 38055 2729 49
2488581 2488581 2022-05-09 McLean North Dakota 38055 2729 49
2485324 2485324 2022-05-08 McLean North Dakota 38055 2729 49
2482066 2482066 2022-05-07 McLean North Dakota 38055 2729 49
2478808 2478808 2022-05-06 McLean North Dakota 38055 2729 49
2475550 2475550 2022-05-05 McLean North Dakota 38055 2729 49
2472293 2472293 2022-05-04 McLean North Dakota 38055 2729 49
2469037 2469037 2022-05-03 McLean North Dakota 38055 2729 49
2465781 2465781 2022-05-02 McLean North Dakota 38055 2729 49
2462526 2462526 2022-05-01 McLean North Dakota 38055 2729 49
2459270 2459270 2022-04-30 McLean North Dakota 38055 2729 49
2456014 2456014 2022-04-29 McLean North Dakota 38055 2729 49
2452758 2452758 2022-04-28 McLean North Dakota 38055 2725 49
2449502 2449502 2022-04-27 McLean North Dakota 38055 2725 49
2446245 2446245 2022-04-26 McLean North Dakota 38055 2725 49
2442990 2442990 2022-04-25 McLean North Dakota 38055 2725 49
2439734 2439734 2022-04-24 McLean North Dakota 38055 2725 49
2436478 2436478 2022-04-23 McLean North Dakota 38055 2725 49
2433222 2433222 2022-04-22 McLean North Dakota 38055 2725 49
2429966 2429966 2022-04-21 McLean North Dakota 38055 2724 49
2426710 2426710 2022-04-20 McLean North Dakota 38055 2724 49
2423454 2423454 2022-04-19 McLean North Dakota 38055 2724 49
2420197 2420197 2022-04-18 McLean North Dakota 38055 2724 49
2416942 2416942 2022-04-17 McLean North Dakota 38055 2724 49
2413686 2413686 2022-04-16 McLean North Dakota 38055 2724 49
2410430 2410430 2022-04-15 McLean North Dakota 38055 2724 49
2407174 2407174 2022-04-14 McLean North Dakota 38055 2723 49
2403918 2403918 2022-04-13 McLean North Dakota 38055 2723 49
2400663 2400663 2022-04-12 McLean North Dakota 38055 2723 49
2397408 2397408 2022-04-11 McLean North Dakota 38055 2723 49
2394153 2394153 2022-04-10 McLean North Dakota 38055 2723 49
2390897 2390897 2022-04-09 McLean North Dakota 38055 2723 49
2387641 2387641 2022-04-08 McLean North Dakota 38055 2723 49
2384386 2384386 2022-04-07 McLean North Dakota 38055 2723 49
2381131 2381131 2022-04-06 McLean North Dakota 38055 2723 49
2377876 2377876 2022-04-05 McLean North Dakota 38055 2723 49
2374623 2374623 2022-04-04 McLean North Dakota 38055 2723 49
2371371 2371371 2022-04-03 McLean North Dakota 38055 2723 49
2368118 2368118 2022-04-02 McLean North Dakota 38055 2723 49
2364865 2364865 2022-04-01 McLean North Dakota 38055 2723 49
2361611 2361611 2022-03-31 McLean North Dakota 38055 2721 49
2358357 2358357 2022-03-30 McLean North Dakota 38055 2721 49
2355103 2355103 2022-03-29 McLean North Dakota 38055 2721 49
2351850 2351850 2022-03-28 McLean North Dakota 38055 2721 49
2348598 2348598 2022-03-27 McLean North Dakota 38055 2721 49
2345345 2345345 2022-03-26 McLean North Dakota 38055 2721 49
2342092 2342092 2022-03-25 McLean North Dakota 38055 2721 49
2338839 2338839 2022-03-24 McLean North Dakota 38055 2719 49
2335585 2335585 2022-03-23 McLean North Dakota 38055 2719 49
2332331 2332331 2022-03-22 McLean North Dakota 38055 2719 49
2329078 2329078 2022-03-21 McLean North Dakota 38055 2719 49
2325826 2325826 2022-03-20 McLean North Dakota 38055 2719 49
2322573 2322573 2022-03-19 McLean North Dakota 38055 2719 49
2319319 2319319 2022-03-18 McLean North Dakota 38055 2719 49
2316065 2316065 2022-03-17 McLean North Dakota 38055 2721 49
2312812 2312812 2022-03-16 McLean North Dakota 38055 2716 49
2309559 2309559 2022-03-15 McLean North Dakota 38055 2716 49
2306306 2306306 2022-03-14 McLean North Dakota 38055 2716 49
2303055 2303055 2022-03-13 McLean North Dakota 38055 2716 49
2299803 2299803 2022-03-12 McLean North Dakota 38055 2716 49
2296551 2296551 2022-03-11 McLean North Dakota 38055 2717 49
2293299 2293299 2022-03-10 McLean North Dakota 38055 2724 49
2290047 2290047 2022-03-09 McLean North Dakota 38055 2725 49
2286795 2286795 2022-03-08 McLean North Dakota 38055 2726 49
2283543 2283543 2022-03-07 McLean North Dakota 38055 2727 49
2280291 2280291 2022-03-06 McLean North Dakota 38055 2727 49
2277038 2277038 2022-03-05 McLean North Dakota 38055 2725 49
2273785 2273785 2022-03-04 McLean North Dakota 38055 2724 49
2270532 2270532 2022-03-03 McLean North Dakota 38055 2722 49
2267280 2267280 2022-03-02 McLean North Dakota 38055 2720 49
2264028 2264028 2022-03-01 McLean North Dakota 38055 2719 49
2260777 2260777 2022-02-28 McLean North Dakota 38055 2719 49
2257526 2257526 2022-02-27 McLean North Dakota 38055 2719 49
2254275 2254275 2022-02-26 McLean North Dakota 38055 2717 49
2251024 2251024 2022-02-25 McLean North Dakota 38055 2716 49
2247773 2247773 2022-02-24 McLean North Dakota 38055 2715 49
2244522 2244522 2022-02-23 McLean North Dakota 38055 2709 49
2241271 2241271 2022-02-22 McLean North Dakota 38055 2706 49
2238020 2238020 2022-02-21 McLean North Dakota 38055 2706 49
2234769 2234769 2022-02-20 McLean North Dakota 38055 2706 49
2231518 2231518 2022-02-19 McLean North Dakota 38055 2705 49
2228267 2228267 2022-02-18 McLean North Dakota 38055 2702 49
2225016 2225016 2022-02-17 McLean North Dakota 38055 2701 49
2221765 2221765 2022-02-16 McLean North Dakota 38055 2699 49
2218514 2218514 2022-02-15 McLean North Dakota 38055 2697 49
2215263 2215263 2022-02-14 McLean North Dakota 38055 2697 49
2212012 2212012 2022-02-13 McLean North Dakota 38055 2697 49
2208759 2208759 2022-02-12 McLean North Dakota 38055 2694 49
2205506 2205506 2022-02-11 McLean North Dakota 38055 2687 49
2202253 2202253 2022-02-10 McLean North Dakota 38055 2686 49
2198999 2198999 2022-02-09 McLean North Dakota 38055 2681 49
2195745 2195745 2022-02-08 McLean North Dakota 38055 2676 49
2192491 2192491 2022-02-07 McLean North Dakota 38055 2666 49
2189237 2189237 2022-02-06 McLean North Dakota 38055 2657 49
2185984 2185984 2022-02-05 McLean North Dakota 38055 2657 49
2182732 2182732 2022-02-04 McLean North Dakota 38055 2650 49
2179480 2179480 2022-02-03 McLean North Dakota 38055 2643 49

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