ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36043 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1519 | 1519 | 2020-03-12 | Herkimer | New York | 36043 | 1 | 0 |
1812 | 1812 | 2020-03-13 | Herkimer | New York | 36043 | 1 | 0 |
2161 | 2161 | 2020-03-14 | Herkimer | New York | 36043 | 1 | 0 |
2571 | 2571 | 2020-03-15 | Herkimer | New York | 36043 | 1 | 0 |
3030 | 3030 | 2020-03-16 | Herkimer | New York | 36043 | 1 | 0 |
3546 | 3546 | 2020-03-17 | Herkimer | New York | 36043 | 1 | 0 |
4145 | 4145 | 2020-03-18 | Herkimer | New York | 36043 | 1 | 0 |
4874 | 4874 | 2020-03-19 | Herkimer | New York | 36043 | 1 | 0 |
5723 | 5723 | 2020-03-20 | Herkimer | New York | 36043 | 2 | 0 |
6717 | 6717 | 2020-03-21 | Herkimer | New York | 36043 | 3 | 0 |
7811 | 7811 | 2020-03-22 | Herkimer | New York | 36043 | 4 | 0 |
9009 | 9009 | 2020-03-23 | Herkimer | New York | 36043 | 4 | 0 |
10316 | 10316 | 2020-03-24 | Herkimer | New York | 36043 | 4 | 0 |
11752 | 11752 | 2020-03-25 | Herkimer | New York | 36043 | 5 | 0 |
13355 | 13355 | 2020-03-26 | Herkimer | New York | 36043 | 7 | 0 |
15089 | 15089 | 2020-03-27 | Herkimer | New York | 36043 | 9 | 0 |
16919 | 16919 | 2020-03-28 | Herkimer | New York | 36043 | 9 | 0 |
18843 | 18843 | 2020-03-29 | Herkimer | New York | 36043 | 10 | 0 |
42142 | 42142 | 2020-04-08 | Herkimer | New York | 36043 | 32 | 1 |
44725 | 44725 | 2020-04-09 | Herkimer | New York | 36043 | 32 | 1 |
47338 | 47338 | 2020-04-10 | Herkimer | New York | 36043 | 36 | 1 |
49993 | 49993 | 2020-04-11 | Herkimer | New York | 36043 | 37 | 1 |
52666 | 52666 | 2020-04-12 | Herkimer | New York | 36043 | 37 | 1 |
55349 | 55349 | 2020-04-13 | Herkimer | New York | 36043 | 38 | 1 |
58049 | 58049 | 2020-04-14 | Herkimer | New York | 36043 | 39 | 1 |
60763 | 60763 | 2020-04-15 | Herkimer | New York | 36043 | 40 | 1 |
63489 | 63489 | 2020-04-16 | Herkimer | New York | 36043 | 43 | 1 |
66231 | 66231 | 2020-04-17 | Herkimer | New York | 36043 | 46 | 1 |
68988 | 68988 | 2020-04-18 | Herkimer | New York | 36043 | 47 | 1 |
71755 | 71755 | 2020-04-19 | Herkimer | New York | 36043 | 49 | 1 |
74530 | 74530 | 2020-04-20 | Herkimer | New York | 36043 | 49 | 1 |
77311 | 77311 | 2020-04-21 | Herkimer | New York | 36043 | 50 | 1 |
80100 | 80100 | 2020-04-22 | Herkimer | New York | 36043 | 53 | 1 |
82899 | 82899 | 2020-04-23 | Herkimer | New York | 36043 | 54 | 1 |
85703 | 85703 | 2020-04-24 | Herkimer | New York | 36043 | 56 | 1 |
88515 | 88515 | 2020-04-25 | Herkimer | New York | 36043 | 56 | 1 |
91330 | 91330 | 2020-04-26 | Herkimer | New York | 36043 | 57 | 1 |
94155 | 94155 | 2020-04-27 | Herkimer | New York | 36043 | 58 | 1 |
96991 | 96991 | 2020-04-28 | Herkimer | New York | 36043 | 58 | 1 |
99838 | 99838 | 2020-04-29 | Herkimer | New York | 36043 | 58 | 1 |
102691 | 102691 | 2020-04-30 | Herkimer | New York | 36043 | 58 | 1 |
105553 | 105553 | 2020-05-01 | Herkimer | New York | 36043 | 60 | 1 |
108420 | 108420 | 2020-05-02 | Herkimer | New York | 36043 | 61 | 1 |
111293 | 111293 | 2020-05-03 | Herkimer | New York | 36043 | 62 | 1 |
114174 | 114174 | 2020-05-04 | Herkimer | New York | 36043 | 63 | 1 |
117054 | 117054 | 2020-05-05 | Herkimer | New York | 36043 | 67 | 1 |
120015 | 120015 | 2020-05-06 | Herkimer | New York | 36043 | 68 | 1 |
122990 | 122990 | 2020-05-07 | Herkimer | New York | 36043 | 74 | 1 |
125973 | 125973 | 2020-05-08 | Herkimer | New York | 36043 | 76 | 1 |
128962 | 128962 | 2020-05-09 | Herkimer | New York | 36043 | 77 | 1 |
131951 | 131951 | 2020-05-10 | Herkimer | New York | 36043 | 79 | 1 |
134942 | 134942 | 2020-05-11 | Herkimer | New York | 36043 | 81 | 1 |
137932 | 137932 | 2020-05-12 | Herkimer | New York | 36043 | 81 | 1 |
140928 | 140928 | 2020-05-13 | Herkimer | New York | 36043 | 84 | 1 |
143923 | 143923 | 2020-05-14 | Herkimer | New York | 36043 | 86 | 1 |
146924 | 146924 | 2020-05-15 | Herkimer | New York | 36043 | 87 | 1 |
149931 | 149931 | 2020-05-16 | Herkimer | New York | 36043 | 91 | 1 |
152941 | 152941 | 2020-05-17 | Herkimer | New York | 36043 | 91 | 1 |
155958 | 155958 | 2020-05-18 | Herkimer | New York | 36043 | 92 | 1 |
158976 | 158976 | 2020-05-19 | Herkimer | New York | 36043 | 92 | 1 |
162003 | 162003 | 2020-05-20 | Herkimer | New York | 36043 | 93 | 1 |
165032 | 165032 | 2020-05-21 | Herkimer | New York | 36043 | 93 | 1 |
168067 | 168067 | 2020-05-22 | Herkimer | New York | 36043 | 95 | 1 |
171106 | 171106 | 2020-05-23 | Herkimer | New York | 36043 | 100 | 1 |
174148 | 174148 | 2020-05-24 | Herkimer | New York | 36043 | 101 | 1 |
177192 | 177192 | 2020-05-25 | Herkimer | New York | 36043 | 103 | 1 |
180235 | 180235 | 2020-05-26 | Herkimer | New York | 36043 | 103 | 1 |
183283 | 183283 | 2020-05-27 | Herkimer | New York | 36043 | 105 | 1 |
186340 | 186340 | 2020-05-28 | Herkimer | New York | 36043 | 106 | 1 |
189400 | 189400 | 2020-05-29 | Herkimer | New York | 36043 | 107 | 1 |
192464 | 192464 | 2020-05-30 | Herkimer | New York | 36043 | 107 | 1 |
195534 | 195534 | 2020-05-31 | Herkimer | New York | 36043 | 108 | 1 |
198607 | 198607 | 2020-06-01 | Herkimer | New York | 36043 | 109 | 1 |
201681 | 201681 | 2020-06-02 | Herkimer | New York | 36043 | 111 | 1 |
204758 | 204758 | 2020-06-03 | Herkimer | New York | 36043 | 113 | 1 |
207839 | 207839 | 2020-06-04 | Herkimer | New York | 36043 | 113 | 1 |
210921 | 210921 | 2020-06-05 | Herkimer | New York | 36043 | 115 | 1 |
214005 | 214005 | 2020-06-06 | Herkimer | New York | 36043 | 122 | 1 |
217095 | 217095 | 2020-06-07 | Herkimer | New York | 36043 | 123 | 1 |
220187 | 220187 | 2020-06-08 | Herkimer | New York | 36043 | 124 | 1 |
223281 | 223281 | 2020-06-09 | Herkimer | New York | 36043 | 125 | 1 |
226381 | 226381 | 2020-06-10 | Herkimer | New York | 36043 | 125 | 1 |
229485 | 229485 | 2020-06-11 | Herkimer | New York | 36043 | 125 | 1 |
232590 | 232590 | 2020-06-12 | Herkimer | New York | 36043 | 127 | 1 |
235695 | 235695 | 2020-06-13 | Herkimer | New York | 36043 | 128 | 1 |
238803 | 238803 | 2020-06-14 | Herkimer | New York | 36043 | 128 | 1 |
241912 | 241912 | 2020-06-15 | Herkimer | New York | 36043 | 128 | 1 |
245024 | 245024 | 2020-06-16 | Herkimer | New York | 36043 | 128 | 1 |
248137 | 248137 | 2020-06-17 | Herkimer | New York | 36043 | 128 | 1 |
251252 | 251252 | 2020-06-18 | Herkimer | New York | 36043 | 128 | 1 |
254367 | 254367 | 2020-06-19 | Herkimer | New York | 36043 | 131 | 1 |
257490 | 257490 | 2020-06-20 | Herkimer | New York | 36043 | 134 | 1 |
260617 | 260617 | 2020-06-21 | Herkimer | New York | 36043 | 136 | 1 |
263745 | 263745 | 2020-06-22 | Herkimer | New York | 36043 | 137 | 1 |
266873 | 266873 | 2020-06-23 | Herkimer | New York | 36043 | 137 | 1 |
270007 | 270007 | 2020-06-24 | Herkimer | New York | 36043 | 142 | 1 |
273146 | 273146 | 2020-06-25 | Herkimer | New York | 36043 | 143 | 1 |
276292 | 276292 | 2020-06-26 | Herkimer | New York | 36043 | 149 | 1 |
279440 | 279440 | 2020-06-27 | Herkimer | New York | 36043 | 154 | 1 |
282586 | 282586 | 2020-06-28 | Herkimer | New York | 36043 | 158 | 1 |
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);