ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,359 rows where county = "Erie" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 3
- New York 790
- Pennsylvania 785
- Ohio 784
county 1
- Erie · 2,359 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501441 | 2501441 | 2022-05-13 | Erie | New York | 36029 | 227059 | 2651 |
2501665 | 2501665 | 2022-05-13 | Erie | Ohio | 39043 | 19730 | 267 |
2501871 | 2501871 | 2022-05-13 | Erie | Pennsylvania | 42049 | 58218 | 760 |
2498183 | 2498183 | 2022-05-12 | Erie | New York | 36029 | 227059 | 2648 |
2498407 | 2498407 | 2022-05-12 | Erie | Ohio | 39043 | 19730 | 267 |
2498613 | 2498613 | 2022-05-12 | Erie | Pennsylvania | 42049 | 58218 | 760 |
2494925 | 2494925 | 2022-05-11 | Erie | New York | 36029 | 226159 | 2647 |
2495149 | 2495149 | 2022-05-11 | Erie | Ohio | 39043 | 19621 | 267 |
2495355 | 2495355 | 2022-05-11 | Erie | Pennsylvania | 42049 | 58218 | 760 |
2491667 | 2491667 | 2022-05-10 | Erie | New York | 36029 | 225534 | 2644 |
2491891 | 2491891 | 2022-05-10 | Erie | Ohio | 39043 | 19621 | 267 |
2492097 | 2492097 | 2022-05-10 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2488409 | 2488409 | 2022-05-09 | Erie | New York | 36029 | 224991 | 2643 |
2488633 | 2488633 | 2022-05-09 | Erie | Ohio | 39043 | 19621 | 267 |
2488839 | 2488839 | 2022-05-09 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2485152 | 2485152 | 2022-05-08 | Erie | New York | 36029 | 224502 | 2640 |
2485376 | 2485376 | 2022-05-08 | Erie | Ohio | 39043 | 19621 | 267 |
2485582 | 2485582 | 2022-05-08 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2481894 | 2481894 | 2022-05-07 | Erie | New York | 36029 | 224008 | 2637 |
2482118 | 2482118 | 2022-05-07 | Erie | Ohio | 39043 | 19621 | 267 |
2482324 | 2482324 | 2022-05-07 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2478636 | 2478636 | 2022-05-06 | Erie | New York | 36029 | 223208 | 2636 |
2478860 | 2478860 | 2022-05-06 | Erie | Ohio | 39043 | 19621 | 267 |
2479066 | 2479066 | 2022-05-06 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2475378 | 2475378 | 2022-05-05 | Erie | New York | 36029 | 222464 | 2636 |
2475602 | 2475602 | 2022-05-05 | Erie | Ohio | 39043 | 19621 | 267 |
2475808 | 2475808 | 2022-05-05 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2472121 | 2472121 | 2022-05-04 | Erie | New York | 36029 | 221695 | 2633 |
2472345 | 2472345 | 2022-05-04 | Erie | Ohio | 39043 | 19550 | 266 |
2472551 | 2472551 | 2022-05-04 | Erie | Pennsylvania | 42049 | 57747 | 759 |
2468865 | 2468865 | 2022-05-03 | Erie | New York | 36029 | 221004 | 2632 |
2469089 | 2469089 | 2022-05-03 | Erie | Ohio | 39043 | 19550 | 266 |
2469295 | 2469295 | 2022-05-03 | Erie | Pennsylvania | 42049 | 57700 | 760 |
2465609 | 2465609 | 2022-05-02 | Erie | New York | 36029 | 220504 | 2630 |
2465833 | 2465833 | 2022-05-02 | Erie | Ohio | 39043 | 19550 | 266 |
2466039 | 2466039 | 2022-05-02 | Erie | Pennsylvania | 42049 | 57660 | 759 |
2462354 | 2462354 | 2022-05-01 | Erie | New York | 36029 | 220122 | 2629 |
2462578 | 2462578 | 2022-05-01 | Erie | Ohio | 39043 | 19550 | 266 |
2462784 | 2462784 | 2022-05-01 | Erie | Pennsylvania | 42049 | 57638 | 759 |
2459098 | 2459098 | 2022-04-30 | Erie | New York | 36029 | 219524 | 2627 |
2459322 | 2459322 | 2022-04-30 | Erie | Ohio | 39043 | 19550 | 266 |
2459528 | 2459528 | 2022-04-30 | Erie | Pennsylvania | 42049 | 57602 | 759 |
2455842 | 2455842 | 2022-04-29 | Erie | New York | 36029 | 218865 | 2626 |
2456066 | 2456066 | 2022-04-29 | Erie | Ohio | 39043 | 19550 | 266 |
2456272 | 2456272 | 2022-04-29 | Erie | Pennsylvania | 42049 | 57558 | 759 |
2452586 | 2452586 | 2022-04-28 | Erie | New York | 36029 | 218133 | 2624 |
2452810 | 2452810 | 2022-04-28 | Erie | Ohio | 39043 | 19550 | 266 |
2453016 | 2453016 | 2022-04-28 | Erie | Pennsylvania | 42049 | 57517 | 759 |
2449330 | 2449330 | 2022-04-27 | Erie | New York | 36029 | 217263 | 2623 |
2449554 | 2449554 | 2022-04-27 | Erie | Ohio | 39043 | 19484 | 266 |
2449760 | 2449760 | 2022-04-27 | Erie | Pennsylvania | 42049 | 57477 | 759 |
2446073 | 2446073 | 2022-04-26 | Erie | New York | 36029 | 216625 | 2620 |
2446297 | 2446297 | 2022-04-26 | Erie | Ohio | 39043 | 19484 | 266 |
2446503 | 2446503 | 2022-04-26 | Erie | Pennsylvania | 42049 | 57439 | 759 |
2442818 | 2442818 | 2022-04-25 | Erie | New York | 36029 | 216136 | 2620 |
2443042 | 2443042 | 2022-04-25 | Erie | Ohio | 39043 | 19484 | 266 |
2443248 | 2443248 | 2022-04-25 | Erie | Pennsylvania | 42049 | 57417 | 758 |
2439562 | 2439562 | 2022-04-24 | Erie | New York | 36029 | 215677 | 2620 |
2439786 | 2439786 | 2022-04-24 | Erie | Ohio | 39043 | 19484 | 266 |
2439992 | 2439992 | 2022-04-24 | Erie | Pennsylvania | 42049 | 57382 | 758 |
2436306 | 2436306 | 2022-04-23 | Erie | New York | 36029 | 215251 | 2619 |
2436530 | 2436530 | 2022-04-23 | Erie | Ohio | 39043 | 19484 | 266 |
2436736 | 2436736 | 2022-04-23 | Erie | Pennsylvania | 42049 | 57355 | 758 |
2433050 | 2433050 | 2022-04-22 | Erie | New York | 36029 | 214686 | 2619 |
2433274 | 2433274 | 2022-04-22 | Erie | Ohio | 39043 | 19484 | 266 |
2433480 | 2433480 | 2022-04-22 | Erie | Pennsylvania | 42049 | 57328 | 758 |
2429794 | 2429794 | 2022-04-21 | Erie | New York | 36029 | 214114 | 2619 |
2430018 | 2430018 | 2022-04-21 | Erie | Ohio | 39043 | 19484 | 266 |
2430224 | 2430224 | 2022-04-21 | Erie | Pennsylvania | 42049 | 57289 | 758 |
2426538 | 2426538 | 2022-04-20 | Erie | New York | 36029 | 213525 | 2619 |
2426762 | 2426762 | 2022-04-20 | Erie | Ohio | 39043 | 19456 | 266 |
2426968 | 2426968 | 2022-04-20 | Erie | Pennsylvania | 42049 | 57254 | 758 |
2423282 | 2423282 | 2022-04-19 | Erie | New York | 36029 | 213043 | 2618 |
2423506 | 2423506 | 2022-04-19 | Erie | Ohio | 39043 | 19456 | 266 |
2423712 | 2423712 | 2022-04-19 | Erie | Pennsylvania | 42049 | 57242 | 758 |
2420025 | 2420025 | 2022-04-18 | Erie | New York | 36029 | 212720 | 2618 |
2420249 | 2420249 | 2022-04-18 | Erie | Ohio | 39043 | 19456 | 266 |
2420456 | 2420456 | 2022-04-18 | Erie | Pennsylvania | 42049 | 57224 | 755 |
2416770 | 2416770 | 2022-04-17 | Erie | New York | 36029 | 212390 | 2618 |
2416994 | 2416994 | 2022-04-17 | Erie | Ohio | 39043 | 19456 | 266 |
2417200 | 2417200 | 2022-04-17 | Erie | Pennsylvania | 42049 | 57212 | 755 |
2413514 | 2413514 | 2022-04-16 | Erie | New York | 36029 | 212123 | 2618 |
2413738 | 2413738 | 2022-04-16 | Erie | Ohio | 39043 | 19456 | 266 |
2413944 | 2413944 | 2022-04-16 | Erie | Pennsylvania | 42049 | 57201 | 755 |
2410258 | 2410258 | 2022-04-15 | Erie | New York | 36029 | 211622 | 2618 |
2410482 | 2410482 | 2022-04-15 | Erie | Ohio | 39043 | 19456 | 266 |
2410688 | 2410688 | 2022-04-15 | Erie | Pennsylvania | 42049 | 57179 | 755 |
2407002 | 2407002 | 2022-04-14 | Erie | New York | 36029 | 211259 | 2617 |
2407226 | 2407226 | 2022-04-14 | Erie | Ohio | 39043 | 19456 | 266 |
2407432 | 2407432 | 2022-04-14 | Erie | Pennsylvania | 42049 | 57173 | 755 |
2403746 | 2403746 | 2022-04-13 | Erie | New York | 36029 | 210854 | 2617 |
2403970 | 2403970 | 2022-04-13 | Erie | Ohio | 39043 | 19434 | 265 |
2404176 | 2404176 | 2022-04-13 | Erie | Pennsylvania | 42049 | 57150 | 755 |
2400491 | 2400491 | 2022-04-12 | Erie | New York | 36029 | 210498 | 2617 |
2400715 | 2400715 | 2022-04-12 | Erie | Ohio | 39043 | 19434 | 265 |
2400921 | 2400921 | 2022-04-12 | Erie | Pennsylvania | 42049 | 57138 | 755 |
2397236 | 2397236 | 2022-04-11 | Erie | New York | 36029 | 210225 | 2614 |
2397460 | 2397460 | 2022-04-11 | Erie | Ohio | 39043 | 19434 | 265 |
2397666 | 2397666 | 2022-04-11 | Erie | Pennsylvania | 42049 | 57130 | 754 |
2393981 | 2393981 | 2022-04-10 | Erie | New York | 36029 | 210033 | 2614 |
Advanced export
JSON shape: default, array, newline-delimited
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);