ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where county = "Amherst" and deaths = 33 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1238263 | 1238263 | 2021-04-19 | Amherst | Virginia | 51009 | 2869 | 33 |
1235016 | 1235016 | 2021-04-18 | Amherst | Virginia | 51009 | 2865 | 33 |
1231768 | 1231768 | 2021-04-17 | Amherst | Virginia | 51009 | 2864 | 33 |
1228520 | 1228520 | 2021-04-16 | Amherst | Virginia | 51009 | 2860 | 33 |
1225272 | 1225272 | 2021-04-15 | Amherst | Virginia | 51009 | 2859 | 33 |
1222025 | 1222025 | 2021-04-14 | Amherst | Virginia | 51009 | 2858 | 33 |
1218777 | 1218777 | 2021-04-13 | Amherst | Virginia | 51009 | 2860 | 33 |
1215529 | 1215529 | 2021-04-12 | Amherst | Virginia | 51009 | 2841 | 33 |
1212282 | 1212282 | 2021-04-11 | Amherst | Virginia | 51009 | 2841 | 33 |
1209033 | 1209033 | 2021-04-10 | Amherst | Virginia | 51009 | 2835 | 33 |
1205785 | 1205785 | 2021-04-09 | Amherst | Virginia | 51009 | 2825 | 33 |
1202537 | 1202537 | 2021-04-08 | Amherst | Virginia | 51009 | 2818 | 33 |
1199289 | 1199289 | 2021-04-07 | Amherst | Virginia | 51009 | 2809 | 33 |
1196040 | 1196040 | 2021-04-06 | Amherst | Virginia | 51009 | 2804 | 33 |
1192792 | 1192792 | 2021-04-05 | Amherst | Virginia | 51009 | 2802 | 33 |
1189542 | 1189542 | 2021-04-04 | Amherst | Virginia | 51009 | 2799 | 33 |
1186295 | 1186295 | 2021-04-03 | Amherst | Virginia | 51009 | 2797 | 33 |
1183048 | 1183048 | 2021-04-02 | Amherst | Virginia | 51009 | 2795 | 33 |
1179801 | 1179801 | 2021-04-01 | Amherst | Virginia | 51009 | 2791 | 33 |
1176554 | 1176554 | 2021-03-31 | Amherst | Virginia | 51009 | 2788 | 33 |
1173307 | 1173307 | 2021-03-30 | Amherst | Virginia | 51009 | 2785 | 33 |
1170060 | 1170060 | 2021-03-29 | Amherst | Virginia | 51009 | 2784 | 33 |
1166812 | 1166812 | 2021-03-28 | Amherst | Virginia | 51009 | 2781 | 33 |
1163564 | 1163564 | 2021-03-27 | Amherst | Virginia | 51009 | 2779 | 33 |
1160316 | 1160316 | 2021-03-26 | Amherst | Virginia | 51009 | 2776 | 33 |
1157068 | 1157068 | 2021-03-25 | Amherst | Virginia | 51009 | 2773 | 33 |
1153821 | 1153821 | 2021-03-24 | Amherst | Virginia | 51009 | 2766 | 33 |
1150574 | 1150574 | 2021-03-23 | Amherst | Virginia | 51009 | 2764 | 33 |
1147327 | 1147327 | 2021-03-22 | Amherst | Virginia | 51009 | 2761 | 33 |
1144080 | 1144080 | 2021-03-21 | Amherst | Virginia | 51009 | 2759 | 33 |
1140833 | 1140833 | 2021-03-20 | Amherst | Virginia | 51009 | 2758 | 33 |
1137587 | 1137587 | 2021-03-19 | Amherst | Virginia | 51009 | 2754 | 33 |
1092136 | 1092136 | 2021-03-05 | Amherst | Virginia | 51009 | 2696 | 33 |
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);