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)
state 3
- New York 756
- Pennsylvania 752
- Ohio 751
county 1
- Erie · 2,259 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394205 | 2394205 | 2022-04-10 | Erie | Ohio | 39043 | 19434 | 265 |
2394411 | 2394411 | 2022-04-10 | Erie | Pennsylvania | 42049 | 57122 | 754 |
2390725 | 2390725 | 2022-04-09 | Erie | New York | 36029 | 209842 | 2611 |
2390949 | 2390949 | 2022-04-09 | Erie | Ohio | 39043 | 19434 | 265 |
2391155 | 2391155 | 2022-04-09 | Erie | Pennsylvania | 42049 | 57108 | 754 |
2387469 | 2387469 | 2022-04-08 | Erie | New York | 36029 | 209576 | 2610 |
2387693 | 2387693 | 2022-04-08 | Erie | Ohio | 39043 | 19434 | 265 |
2387899 | 2387899 | 2022-04-08 | Erie | Pennsylvania | 42049 | 57096 | 753 |
2384214 | 2384214 | 2022-04-07 | Erie | New York | 36029 | 209268 | 2609 |
2384438 | 2384438 | 2022-04-07 | Erie | Ohio | 39043 | 19434 | 265 |
2384644 | 2384644 | 2022-04-07 | Erie | Pennsylvania | 42049 | 57071 | 752 |
2380959 | 2380959 | 2022-04-06 | Erie | New York | 36029 | 209046 | 2609 |
2381183 | 2381183 | 2022-04-06 | Erie | Ohio | 39043 | 19412 | 265 |
2381389 | 2381389 | 2022-04-06 | Erie | Pennsylvania | 42049 | 57046 | 752 |
2377704 | 2377704 | 2022-04-05 | Erie | New York | 36029 | 208861 | 2609 |
2377928 | 2377928 | 2022-04-05 | Erie | Ohio | 39043 | 19412 | 265 |
2378134 | 2378134 | 2022-04-05 | Erie | Pennsylvania | 42049 | 57034 | 751 |
2374451 | 2374451 | 2022-04-04 | Erie | New York | 36029 | 208720 | 2608 |
2374674 | 2374674 | 2022-04-04 | Erie | Ohio | 39043 | 19412 | 265 |
2374880 | 2374880 | 2022-04-04 | Erie | Pennsylvania | 42049 | 57022 | 750 |
2371199 | 2371199 | 2022-04-03 | Erie | New York | 36029 | 208616 | 2608 |
2371422 | 2371422 | 2022-04-03 | Erie | Ohio | 39043 | 19412 | 265 |
2371628 | 2371628 | 2022-04-03 | Erie | Pennsylvania | 42049 | 56997 | 750 |
2367946 | 2367946 | 2022-04-02 | Erie | New York | 36029 | 208479 | 2608 |
2368169 | 2368169 | 2022-04-02 | Erie | Ohio | 39043 | 19412 | 265 |
2368375 | 2368375 | 2022-04-02 | Erie | Pennsylvania | 42049 | 56997 | 750 |
2364693 | 2364693 | 2022-04-01 | Erie | New York | 36029 | 208297 | 2608 |
2364916 | 2364916 | 2022-04-01 | Erie | Ohio | 39043 | 19412 | 265 |
2365122 | 2365122 | 2022-04-01 | Erie | Pennsylvania | 42049 | 56984 | 750 |
2361439 | 2361439 | 2022-03-31 | Erie | New York | 36029 | 208149 | 2608 |
2361663 | 2361663 | 2022-03-31 | Erie | Ohio | 39043 | 19412 | 265 |
2361869 | 2361869 | 2022-03-31 | Erie | Pennsylvania | 42049 | 56975 | 750 |
2358185 | 2358185 | 2022-03-30 | Erie | New York | 36029 | 207998 | 2608 |
2358409 | 2358409 | 2022-03-30 | Erie | Ohio | 39043 | 19388 | 265 |
2358615 | 2358615 | 2022-03-30 | Erie | Pennsylvania | 42049 | 56958 | 749 |
2354931 | 2354931 | 2022-03-29 | Erie | New York | 36029 | 207877 | 2608 |
2355155 | 2355155 | 2022-03-29 | Erie | Ohio | 39043 | 19388 | 265 |
2355361 | 2355361 | 2022-03-29 | Erie | Pennsylvania | 42049 | 56947 | 749 |
2351678 | 2351678 | 2022-03-28 | Erie | New York | 36029 | 207777 | 2608 |
2351902 | 2351902 | 2022-03-28 | Erie | Ohio | 39043 | 19388 | 265 |
2352108 | 2352108 | 2022-03-28 | Erie | Pennsylvania | 42049 | 56942 | 749 |
2348426 | 2348426 | 2022-03-27 | Erie | New York | 36029 | 207702 | 2607 |
2348650 | 2348650 | 2022-03-27 | Erie | Ohio | 39043 | 19388 | 265 |
2348856 | 2348856 | 2022-03-27 | Erie | Pennsylvania | 42049 | 56937 | 749 |
2345173 | 2345173 | 2022-03-26 | Erie | New York | 36029 | 207626 | 2606 |
2345397 | 2345397 | 2022-03-26 | Erie | Ohio | 39043 | 19388 | 265 |
2345603 | 2345603 | 2022-03-26 | Erie | Pennsylvania | 42049 | 56932 | 749 |
2341920 | 2341920 | 2022-03-25 | Erie | New York | 36029 | 207516 | 2605 |
2342144 | 2342144 | 2022-03-25 | Erie | Ohio | 39043 | 19388 | 265 |
2342350 | 2342350 | 2022-03-25 | Erie | Pennsylvania | 42049 | 56919 | 749 |
2338667 | 2338667 | 2022-03-24 | Erie | New York | 36029 | 207427 | 2604 |
2338891 | 2338891 | 2022-03-24 | Erie | Ohio | 39043 | 19388 | 265 |
2339097 | 2339097 | 2022-03-24 | Erie | Pennsylvania | 42049 | 56899 | 747 |
2335413 | 2335413 | 2022-03-23 | Erie | New York | 36029 | 207328 | 2604 |
2335637 | 2335637 | 2022-03-23 | Erie | Ohio | 39043 | 19369 | 264 |
2335843 | 2335843 | 2022-03-23 | Erie | Pennsylvania | 42049 | 56890 | 745 |
2332159 | 2332159 | 2022-03-22 | Erie | New York | 36029 | 207216 | 2604 |
2332383 | 2332383 | 2022-03-22 | Erie | Ohio | 39043 | 19369 | 264 |
2332589 | 2332589 | 2022-03-22 | Erie | Pennsylvania | 42049 | 56875 | 745 |
2328906 | 2328906 | 2022-03-21 | Erie | New York | 36029 | 207147 | 2603 |
2329130 | 2329130 | 2022-03-21 | Erie | Ohio | 39043 | 19369 | 264 |
2329336 | 2329336 | 2022-03-21 | Erie | Pennsylvania | 42049 | 56865 | 745 |
2325654 | 2325654 | 2022-03-20 | Erie | New York | 36029 | 207109 | 2603 |
2325878 | 2325878 | 2022-03-20 | Erie | Ohio | 39043 | 19369 | 264 |
2326084 | 2326084 | 2022-03-20 | Erie | Pennsylvania | 42049 | 56856 | 745 |
2322401 | 2322401 | 2022-03-19 | Erie | New York | 36029 | 207048 | 2603 |
2322625 | 2322625 | 2022-03-19 | Erie | Ohio | 39043 | 19369 | 264 |
2322831 | 2322831 | 2022-03-19 | Erie | Pennsylvania | 42049 | 56854 | 745 |
2319147 | 2319147 | 2022-03-18 | Erie | New York | 36029 | 206954 | 2602 |
2319371 | 2319371 | 2022-03-18 | Erie | Ohio | 39043 | 19369 | 264 |
2319577 | 2319577 | 2022-03-18 | Erie | Pennsylvania | 42049 | 56842 | 745 |
2315893 | 2315893 | 2022-03-17 | Erie | New York | 36029 | 206859 | 2601 |
2316117 | 2316117 | 2022-03-17 | Erie | Ohio | 39043 | 19369 | 264 |
2316323 | 2316323 | 2022-03-17 | Erie | Pennsylvania | 42049 | 56825 | 745 |
2312640 | 2312640 | 2022-03-16 | Erie | New York | 36029 | 206779 | 2600 |
2312864 | 2312864 | 2022-03-16 | Erie | Ohio | 39043 | 19355 | 264 |
2313070 | 2313070 | 2022-03-16 | Erie | Pennsylvania | 42049 | 56812 | 743 |
2309387 | 2309387 | 2022-03-15 | Erie | New York | 36029 | 206707 | 2599 |
2309611 | 2309611 | 2022-03-15 | Erie | Ohio | 39043 | 19355 | 264 |
2309817 | 2309817 | 2022-03-15 | Erie | Pennsylvania | 42049 | 56798 | 742 |
2306134 | 2306134 | 2022-03-14 | Erie | New York | 36029 | 206636 | 2599 |
2306358 | 2306358 | 2022-03-14 | Erie | Ohio | 39043 | 19355 | 264 |
2306564 | 2306564 | 2022-03-14 | Erie | Pennsylvania | 42049 | 56785 | 741 |
2302883 | 2302883 | 2022-03-13 | Erie | New York | 36029 | 206602 | 2598 |
2303107 | 2303107 | 2022-03-13 | Erie | Ohio | 39043 | 19355 | 264 |
2303313 | 2303313 | 2022-03-13 | Erie | Pennsylvania | 42049 | 56780 | 741 |
2299631 | 2299631 | 2022-03-12 | Erie | New York | 36029 | 206530 | 2596 |
2299855 | 2299855 | 2022-03-12 | Erie | Ohio | 39043 | 19354 | 264 |
2300061 | 2300061 | 2022-03-12 | Erie | Pennsylvania | 42049 | 56771 | 741 |
2296379 | 2296379 | 2022-03-11 | Erie | New York | 36029 | 206470 | 2596 |
2296603 | 2296603 | 2022-03-11 | Erie | Ohio | 39043 | 19353 | 264 |
2296809 | 2296809 | 2022-03-11 | Erie | Pennsylvania | 42049 | 56748 | 741 |
2293127 | 2293127 | 2022-03-10 | Erie | New York | 36029 | 206391 | 2594 |
2293351 | 2293351 | 2022-03-10 | Erie | Ohio | 39043 | 19349 | 263 |
2293557 | 2293557 | 2022-03-10 | Erie | Pennsylvania | 42049 | 56717 | 740 |
2289875 | 2289875 | 2022-03-09 | Erie | New York | 36029 | 206348 | 2593 |
2290099 | 2290099 | 2022-03-09 | Erie | Ohio | 39043 | 19348 | 263 |
2290305 | 2290305 | 2022-03-09 | Erie | Pennsylvania | 42049 | 56677 | 740 |
2286623 | 2286623 | 2022-03-08 | Erie | New York | 36029 | 206287 | 2593 |
2286847 | 2286847 | 2022-03-08 | Erie | Ohio | 39043 | 19345 | 263 |
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);