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

790 rows where county = "Erie" and state = "New York" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • New York · 790 ✖

fips 1

county 1

  • Erie · 790 ✖
Link rowid date ▲ county state fips cases deaths
2501441 2501441 2022-05-13 Erie New York 36029 227059 2651
2498183 2498183 2022-05-12 Erie New York 36029 227059 2648
2494925 2494925 2022-05-11 Erie New York 36029 226159 2647
2491667 2491667 2022-05-10 Erie New York 36029 225534 2644
2488409 2488409 2022-05-09 Erie New York 36029 224991 2643
2485152 2485152 2022-05-08 Erie New York 36029 224502 2640
2481894 2481894 2022-05-07 Erie New York 36029 224008 2637
2478636 2478636 2022-05-06 Erie New York 36029 223208 2636
2475378 2475378 2022-05-05 Erie New York 36029 222464 2636
2472121 2472121 2022-05-04 Erie New York 36029 221695 2633
2468865 2468865 2022-05-03 Erie New York 36029 221004 2632
2465609 2465609 2022-05-02 Erie New York 36029 220504 2630
2462354 2462354 2022-05-01 Erie New York 36029 220122 2629
2459098 2459098 2022-04-30 Erie New York 36029 219524 2627
2455842 2455842 2022-04-29 Erie New York 36029 218865 2626
2452586 2452586 2022-04-28 Erie New York 36029 218133 2624
2449330 2449330 2022-04-27 Erie New York 36029 217263 2623
2446073 2446073 2022-04-26 Erie New York 36029 216625 2620
2442818 2442818 2022-04-25 Erie New York 36029 216136 2620
2439562 2439562 2022-04-24 Erie New York 36029 215677 2620
2436306 2436306 2022-04-23 Erie New York 36029 215251 2619
2433050 2433050 2022-04-22 Erie New York 36029 214686 2619
2429794 2429794 2022-04-21 Erie New York 36029 214114 2619
2426538 2426538 2022-04-20 Erie New York 36029 213525 2619
2423282 2423282 2022-04-19 Erie New York 36029 213043 2618
2420025 2420025 2022-04-18 Erie New York 36029 212720 2618
2416770 2416770 2022-04-17 Erie New York 36029 212390 2618
2413514 2413514 2022-04-16 Erie New York 36029 212123 2618
2410258 2410258 2022-04-15 Erie New York 36029 211622 2618
2407002 2407002 2022-04-14 Erie New York 36029 211259 2617
2403746 2403746 2022-04-13 Erie New York 36029 210854 2617
2400491 2400491 2022-04-12 Erie New York 36029 210498 2617
2397236 2397236 2022-04-11 Erie New York 36029 210225 2614
2393981 2393981 2022-04-10 Erie New York 36029 210033 2614
2390725 2390725 2022-04-09 Erie New York 36029 209842 2611
2387469 2387469 2022-04-08 Erie New York 36029 209576 2610
2384214 2384214 2022-04-07 Erie New York 36029 209268 2609
2380959 2380959 2022-04-06 Erie New York 36029 209046 2609
2377704 2377704 2022-04-05 Erie New York 36029 208861 2609
2374451 2374451 2022-04-04 Erie New York 36029 208720 2608
2371199 2371199 2022-04-03 Erie New York 36029 208616 2608
2367946 2367946 2022-04-02 Erie New York 36029 208479 2608
2364693 2364693 2022-04-01 Erie New York 36029 208297 2608
2361439 2361439 2022-03-31 Erie New York 36029 208149 2608
2358185 2358185 2022-03-30 Erie New York 36029 207998 2608
2354931 2354931 2022-03-29 Erie New York 36029 207877 2608
2351678 2351678 2022-03-28 Erie New York 36029 207777 2608
2348426 2348426 2022-03-27 Erie New York 36029 207702 2607
2345173 2345173 2022-03-26 Erie New York 36029 207626 2606
2341920 2341920 2022-03-25 Erie New York 36029 207516 2605
2338667 2338667 2022-03-24 Erie New York 36029 207427 2604
2335413 2335413 2022-03-23 Erie New York 36029 207328 2604
2332159 2332159 2022-03-22 Erie New York 36029 207216 2604
2328906 2328906 2022-03-21 Erie New York 36029 207147 2603
2325654 2325654 2022-03-20 Erie New York 36029 207109 2603
2322401 2322401 2022-03-19 Erie New York 36029 207048 2603
2319147 2319147 2022-03-18 Erie New York 36029 206954 2602
2315893 2315893 2022-03-17 Erie New York 36029 206859 2601
2312640 2312640 2022-03-16 Erie New York 36029 206779 2600
2309387 2309387 2022-03-15 Erie New York 36029 206707 2599
2306134 2306134 2022-03-14 Erie New York 36029 206636 2599
2302883 2302883 2022-03-13 Erie New York 36029 206602 2598
2299631 2299631 2022-03-12 Erie New York 36029 206530 2596
2296379 2296379 2022-03-11 Erie New York 36029 206470 2596
2293127 2293127 2022-03-10 Erie New York 36029 206391 2594
2289875 2289875 2022-03-09 Erie New York 36029 206348 2593
2286623 2286623 2022-03-08 Erie New York 36029 206287 2593
2283371 2283371 2022-03-07 Erie New York 36029 206235 2591
2280119 2280119 2022-03-06 Erie New York 36029 206187 2591
2276866 2276866 2022-03-05 Erie New York 36029 206126 2589
2273613 2273613 2022-03-04 Erie New York 36029 205953 2586
2270360 2270360 2022-03-03 Erie New York 36029 205953 2585
2267108 2267108 2022-03-02 Erie New York 36029 205863 2583
2263856 2263856 2022-03-01 Erie New York 36029 205766 2583
2260605 2260605 2022-02-28 Erie New York 36029 205702 2583
2257354 2257354 2022-02-27 Erie New York 36029 205629 2582
2254103 2254103 2022-02-26 Erie New York 36029 205584 2582
2250852 2250852 2022-02-25 Erie New York 36029 205500 2580
2247601 2247601 2022-02-24 Erie New York 36029 205386 2578
2244350 2244350 2022-02-23 Erie New York 36029 205280 2575
2241099 2241099 2022-02-22 Erie New York 36029 205168 2572
2237848 2237848 2022-02-21 Erie New York 36029 205086 2570
2234597 2234597 2022-02-20 Erie New York 36029 205027 2569
2231346 2231346 2022-02-19 Erie New York 36029 204871 2566
2228095 2228095 2022-02-18 Erie New York 36029 204731 2564
2224844 2224844 2022-02-17 Erie New York 36029 204513 2560
2221593 2221593 2022-02-16 Erie New York 36029 204352 2558
2218342 2218342 2022-02-15 Erie New York 36029 204219 2553
2215091 2215091 2022-02-14 Erie New York 36029 204072 2545
2211840 2211840 2022-02-13 Erie New York 36029 203945 2537
2208587 2208587 2022-02-12 Erie New York 36029 203777 2528
2205334 2205334 2022-02-11 Erie New York 36029 203560 2528
2202081 2202081 2022-02-10 Erie New York 36029 203336 2523
2198827 2198827 2022-02-09 Erie New York 36029 203068 2520
2195573 2195573 2022-02-08 Erie New York 36029 202785 2513
2192319 2192319 2022-02-07 Erie New York 36029 202610 2506
2189065 2189065 2022-02-06 Erie New York 36029 202405 2503
2185812 2185812 2022-02-05 Erie New York 36029 202208 2498
2182560 2182560 2022-02-04 Erie New York 36029 201820 2493
2179308 2179308 2022-02-03 Erie New York 36029 201442 2485

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