ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36041 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4144 | 4144 | 2020-03-18 | Hamilton | New York | 36041 | 1 | 0 |
4873 | 4873 | 2020-03-19 | Hamilton | New York | 36041 | 1 | 0 |
5722 | 5722 | 2020-03-20 | Hamilton | New York | 36041 | 2 | 0 |
6716 | 6716 | 2020-03-21 | Hamilton | New York | 36041 | 2 | 0 |
7810 | 7810 | 2020-03-22 | Hamilton | New York | 36041 | 2 | 0 |
9008 | 9008 | 2020-03-23 | Hamilton | New York | 36041 | 2 | 0 |
10315 | 10315 | 2020-03-24 | Hamilton | New York | 36041 | 2 | 0 |
11751 | 11751 | 2020-03-25 | Hamilton | New York | 36041 | 2 | 0 |
13354 | 13354 | 2020-03-26 | Hamilton | New York | 36041 | 2 | 0 |
15088 | 15088 | 2020-03-27 | Hamilton | New York | 36041 | 2 | 0 |
16918 | 16918 | 2020-03-28 | Hamilton | New York | 36041 | 2 | 0 |
18842 | 18842 | 2020-03-29 | Hamilton | New York | 36041 | 2 | 0 |
20881 | 20881 | 2020-03-30 | Hamilton | New York | 36041 | 2 | 0 |
23004 | 23004 | 2020-03-31 | Hamilton | New York | 36041 | 2 | 0 |
25198 | 25198 | 2020-04-01 | Hamilton | New York | 36041 | 2 | 0 |
27458 | 27458 | 2020-04-02 | Hamilton | New York | 36041 | 2 | 0 |
29782 | 29782 | 2020-04-03 | Hamilton | New York | 36041 | 2 | 0 |
32168 | 32168 | 2020-04-04 | Hamilton | New York | 36041 | 2 | 0 |
34599 | 34599 | 2020-04-05 | Hamilton | New York | 36041 | 2 | 0 |
37069 | 37069 | 2020-04-06 | Hamilton | New York | 36041 | 2 | 0 |
39584 | 39584 | 2020-04-07 | Hamilton | New York | 36041 | 2 | 0 |
42141 | 42141 | 2020-04-08 | Hamilton | New York | 36041 | 2 | 0 |
44724 | 44724 | 2020-04-09 | Hamilton | New York | 36041 | 3 | 0 |
47337 | 47337 | 2020-04-10 | Hamilton | New York | 36041 | 3 | 0 |
49992 | 49992 | 2020-04-11 | Hamilton | New York | 36041 | 3 | 0 |
52665 | 52665 | 2020-04-12 | Hamilton | New York | 36041 | 3 | 0 |
55348 | 55348 | 2020-04-13 | Hamilton | New York | 36041 | 3 | 0 |
58048 | 58048 | 2020-04-14 | Hamilton | New York | 36041 | 3 | 0 |
60762 | 60762 | 2020-04-15 | Hamilton | New York | 36041 | 3 | 0 |
63488 | 63488 | 2020-04-16 | Hamilton | New York | 36041 | 3 | 0 |
66230 | 66230 | 2020-04-17 | Hamilton | New York | 36041 | 3 | 0 |
68987 | 68987 | 2020-04-18 | Hamilton | New York | 36041 | 3 | 0 |
71754 | 71754 | 2020-04-19 | Hamilton | New York | 36041 | 3 | 0 |
74529 | 74529 | 2020-04-20 | Hamilton | New York | 36041 | 3 | 0 |
77310 | 77310 | 2020-04-21 | Hamilton | New York | 36041 | 3 | 0 |
80099 | 80099 | 2020-04-22 | Hamilton | New York | 36041 | 3 | 0 |
82898 | 82898 | 2020-04-23 | Hamilton | New York | 36041 | 3 | 0 |
85702 | 85702 | 2020-04-24 | Hamilton | New York | 36041 | 3 | 0 |
88514 | 88514 | 2020-04-25 | Hamilton | New York | 36041 | 3 | 0 |
91329 | 91329 | 2020-04-26 | Hamilton | New York | 36041 | 3 | 0 |
94154 | 94154 | 2020-04-27 | Hamilton | New York | 36041 | 3 | 0 |
96990 | 96990 | 2020-04-28 | Hamilton | New York | 36041 | 3 | 0 |
99837 | 99837 | 2020-04-29 | Hamilton | New York | 36041 | 3 | 0 |
102690 | 102690 | 2020-04-30 | Hamilton | New York | 36041 | 3 | 0 |
105552 | 105552 | 2020-05-01 | Hamilton | New York | 36041 | 3 | 0 |
108419 | 108419 | 2020-05-02 | Hamilton | New York | 36041 | 3 | 0 |
111292 | 111292 | 2020-05-03 | Hamilton | New York | 36041 | 3 | 0 |
114173 | 114173 | 2020-05-04 | Hamilton | New York | 36041 | 3 | 0 |
117053 | 117053 | 2020-05-05 | Hamilton | New York | 36041 | 3 | 0 |
120014 | 120014 | 2020-05-06 | Hamilton | New York | 36041 | 5 | 0 |
122989 | 122989 | 2020-05-07 | Hamilton | New York | 36041 | 5 | 0 |
125972 | 125972 | 2020-05-08 | Hamilton | New York | 36041 | 5 | 0 |
128961 | 128961 | 2020-05-09 | Hamilton | New York | 36041 | 5 | 0 |
131950 | 131950 | 2020-05-10 | Hamilton | New York | 36041 | 5 | 0 |
134941 | 134941 | 2020-05-11 | Hamilton | New York | 36041 | 5 | 0 |
137931 | 137931 | 2020-05-12 | Hamilton | New York | 36041 | 5 | 0 |
140927 | 140927 | 2020-05-13 | Hamilton | New York | 36041 | 5 | 0 |
143922 | 143922 | 2020-05-14 | Hamilton | New York | 36041 | 5 | 0 |
146923 | 146923 | 2020-05-15 | Hamilton | New York | 36041 | 5 | 0 |
149930 | 149930 | 2020-05-16 | Hamilton | New York | 36041 | 5 | 0 |
152940 | 152940 | 2020-05-17 | Hamilton | New York | 36041 | 5 | 0 |
155957 | 155957 | 2020-05-18 | Hamilton | New York | 36041 | 5 | 0 |
158975 | 158975 | 2020-05-19 | Hamilton | New York | 36041 | 5 | 0 |
162002 | 162002 | 2020-05-20 | Hamilton | New York | 36041 | 5 | 0 |
165031 | 165031 | 2020-05-21 | Hamilton | New York | 36041 | 5 | 0 |
168066 | 168066 | 2020-05-22 | Hamilton | New York | 36041 | 5 | 0 |
171105 | 171105 | 2020-05-23 | Hamilton | New York | 36041 | 5 | 0 |
174147 | 174147 | 2020-05-24 | Hamilton | New York | 36041 | 5 | 0 |
177191 | 177191 | 2020-05-25 | Hamilton | New York | 36041 | 5 | 0 |
180234 | 180234 | 2020-05-26 | Hamilton | New York | 36041 | 5 | 0 |
183282 | 183282 | 2020-05-27 | Hamilton | New York | 36041 | 5 | 0 |
186339 | 186339 | 2020-05-28 | Hamilton | New York | 36041 | 5 | 0 |
189399 | 189399 | 2020-05-29 | Hamilton | New York | 36041 | 5 | 0 |
192463 | 192463 | 2020-05-30 | Hamilton | New York | 36041 | 5 | 0 |
195533 | 195533 | 2020-05-31 | Hamilton | New York | 36041 | 5 | 0 |
198606 | 198606 | 2020-06-01 | Hamilton | New York | 36041 | 5 | 0 |
201680 | 201680 | 2020-06-02 | Hamilton | New York | 36041 | 5 | 0 |
204757 | 204757 | 2020-06-03 | Hamilton | New York | 36041 | 5 | 0 |
207838 | 207838 | 2020-06-04 | Hamilton | New York | 36041 | 5 | 0 |
210920 | 210920 | 2020-06-05 | Hamilton | New York | 36041 | 5 | 0 |
214004 | 214004 | 2020-06-06 | Hamilton | New York | 36041 | 5 | 0 |
217094 | 217094 | 2020-06-07 | Hamilton | New York | 36041 | 5 | 0 |
220186 | 220186 | 2020-06-08 | Hamilton | New York | 36041 | 5 | 0 |
223280 | 223280 | 2020-06-09 | Hamilton | New York | 36041 | 5 | 0 |
226380 | 226380 | 2020-06-10 | Hamilton | New York | 36041 | 5 | 0 |
229484 | 229484 | 2020-06-11 | Hamilton | New York | 36041 | 5 | 0 |
232589 | 232589 | 2020-06-12 | Hamilton | New York | 36041 | 5 | 0 |
235694 | 235694 | 2020-06-13 | Hamilton | New York | 36041 | 5 | 0 |
238802 | 238802 | 2020-06-14 | Hamilton | New York | 36041 | 6 | 0 |
241911 | 241911 | 2020-06-15 | Hamilton | New York | 36041 | 6 | 0 |
245023 | 245023 | 2020-06-16 | Hamilton | New York | 36041 | 6 | 0 |
248136 | 248136 | 2020-06-17 | Hamilton | New York | 36041 | 6 | 0 |
251251 | 251251 | 2020-06-18 | Hamilton | New York | 36041 | 6 | 0 |
254366 | 254366 | 2020-06-19 | Hamilton | New York | 36041 | 6 | 0 |
257489 | 257489 | 2020-06-20 | Hamilton | New York | 36041 | 6 | 0 |
260616 | 260616 | 2020-06-21 | Hamilton | New York | 36041 | 6 | 0 |
263744 | 263744 | 2020-06-22 | Hamilton | New York | 36041 | 6 | 0 |
266872 | 266872 | 2020-06-23 | Hamilton | New York | 36041 | 6 | 0 |
270006 | 270006 | 2020-06-24 | Hamilton | New York | 36041 | 6 | 0 |
273145 | 273145 | 2020-06-25 | Hamilton | New York | 36041 | 6 | 0 |
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);