ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 36053 and state = "New York" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7814 | 7814 | 2020-03-22 | Madison | New York | 36053 | 1 | 0 |
9012 | 9012 | 2020-03-23 | Madison | New York | 36053 | 4 | 0 |
10319 | 10319 | 2020-03-24 | Madison | New York | 36053 | 5 | 0 |
11755 | 11755 | 2020-03-25 | Madison | New York | 36053 | 7 | 0 |
13358 | 13358 | 2020-03-26 | Madison | New York | 36053 | 9 | 0 |
15092 | 15092 | 2020-03-27 | Madison | New York | 36053 | 17 | 0 |
16922 | 16922 | 2020-03-28 | Madison | New York | 36053 | 19 | 0 |
18847 | 18847 | 2020-03-29 | Madison | New York | 36053 | 24 | 0 |
20886 | 20886 | 2020-03-30 | Madison | New York | 36053 | 34 | 0 |
23009 | 23009 | 2020-03-31 | Madison | New York | 36053 | 41 | 0 |
25203 | 25203 | 2020-04-01 | Madison | New York | 36053 | 67 | 2 |
27463 | 27463 | 2020-04-02 | Madison | New York | 36053 | 77 | 2 |
29787 | 29787 | 2020-04-03 | Madison | New York | 36053 | 77 | 2 |
32173 | 32173 | 2020-04-04 | Madison | New York | 36053 | 77 | 2 |
34604 | 34604 | 2020-04-05 | Madison | New York | 36053 | 89 | 2 |
37074 | 37074 | 2020-04-06 | Madison | New York | 36053 | 92 | 2 |
39589 | 39589 | 2020-04-07 | Madison | New York | 36053 | 92 | 2 |
42146 | 42146 | 2020-04-08 | Madison | New York | 36053 | 92 | 1 |
44729 | 44729 | 2020-04-09 | Madison | New York | 36053 | 91 | 1 |
47342 | 47342 | 2020-04-10 | Madison | New York | 36053 | 99 | 1 |
49997 | 49997 | 2020-04-11 | Madison | New York | 36053 | 99 | 1 |
52670 | 52670 | 2020-04-12 | Madison | New York | 36053 | 101 | 1 |
55353 | 55353 | 2020-04-13 | Madison | New York | 36053 | 101 | 1 |
58053 | 58053 | 2020-04-14 | Madison | New York | 36053 | 104 | 1 |
60767 | 60767 | 2020-04-15 | Madison | New York | 36053 | 105 | 1 |
63493 | 63493 | 2020-04-16 | Madison | New York | 36053 | 105 | 1 |
66235 | 66235 | 2020-04-17 | Madison | New York | 36053 | 105 | 1 |
68992 | 68992 | 2020-04-18 | Madison | New York | 36053 | 105 | 1 |
71759 | 71759 | 2020-04-19 | Madison | New York | 36053 | 106 | 3 |
74534 | 74534 | 2020-04-20 | Madison | New York | 36053 | 106 | 3 |
77315 | 77315 | 2020-04-21 | Madison | New York | 36053 | 106 | 3 |
80104 | 80104 | 2020-04-22 | Madison | New York | 36053 | 106 | 3 |
82903 | 82903 | 2020-04-23 | Madison | New York | 36053 | 106 | 3 |
85707 | 85707 | 2020-04-24 | Madison | New York | 36053 | 106 | 3 |
88519 | 88519 | 2020-04-25 | Madison | New York | 36053 | 121 | 3 |
91334 | 91334 | 2020-04-26 | Madison | New York | 36053 | 123 | 3 |
94159 | 94159 | 2020-04-27 | Madison | New York | 36053 | 124 | 3 |
96995 | 96995 | 2020-04-28 | Madison | New York | 36053 | 126 | 3 |
99842 | 99842 | 2020-04-29 | Madison | New York | 36053 | 126 | 3 |
102695 | 102695 | 2020-04-30 | Madison | New York | 36053 | 131 | 3 |
105557 | 105557 | 2020-05-01 | Madison | New York | 36053 | 139 | 3 |
108424 | 108424 | 2020-05-02 | Madison | New York | 36053 | 149 | 3 |
111297 | 111297 | 2020-05-03 | Madison | New York | 36053 | 151 | 3 |
114178 | 114178 | 2020-05-04 | Madison | New York | 36053 | 217 | 3 |
117058 | 117058 | 2020-05-05 | Madison | New York | 36053 | 223 | 3 |
120019 | 120019 | 2020-05-06 | Madison | New York | 36053 | 231 | 3 |
122994 | 122994 | 2020-05-07 | Madison | New York | 36053 | 246 | 3 |
125977 | 125977 | 2020-05-08 | Madison | New York | 36053 | 249 | 3 |
128966 | 128966 | 2020-05-09 | Madison | New York | 36053 | 250 | 3 |
131955 | 131955 | 2020-05-10 | Madison | New York | 36053 | 251 | 3 |
134946 | 134946 | 2020-05-11 | Madison | New York | 36053 | 251 | 3 |
137936 | 137936 | 2020-05-12 | Madison | New York | 36053 | 251 | 3 |
140932 | 140932 | 2020-05-13 | Madison | New York | 36053 | 253 | 3 |
143927 | 143927 | 2020-05-14 | Madison | New York | 36053 | 255 | 3 |
146928 | 146928 | 2020-05-15 | Madison | New York | 36053 | 256 | 3 |
149935 | 149935 | 2020-05-16 | Madison | New York | 36053 | 258 | 3 |
152945 | 152945 | 2020-05-17 | Madison | New York | 36053 | 258 | 3 |
155962 | 155962 | 2020-05-18 | Madison | New York | 36053 | 258 | 3 |
158980 | 158980 | 2020-05-19 | Madison | New York | 36053 | 260 | 3 |
162007 | 162007 | 2020-05-20 | Madison | New York | 36053 | 292 | 3 |
165036 | 165036 | 2020-05-21 | Madison | New York | 36053 | 294 | 3 |
168071 | 168071 | 2020-05-22 | Madison | New York | 36053 | 297 | 4 |
171110 | 171110 | 2020-05-23 | Madison | New York | 36053 | 301 | 4 |
174152 | 174152 | 2020-05-24 | Madison | New York | 36053 | 301 | 4 |
177196 | 177196 | 2020-05-25 | Madison | New York | 36053 | 303 | 4 |
180239 | 180239 | 2020-05-26 | Madison | New York | 36053 | 303 | 4 |
183287 | 183287 | 2020-05-27 | Madison | New York | 36053 | 310 | 4 |
186344 | 186344 | 2020-05-28 | Madison | New York | 36053 | 310 | 4 |
189404 | 189404 | 2020-05-29 | Madison | New York | 36053 | 310 | 4 |
192468 | 192468 | 2020-05-30 | Madison | New York | 36053 | 311 | 4 |
195538 | 195538 | 2020-05-31 | Madison | New York | 36053 | 316 | 4 |
198611 | 198611 | 2020-06-01 | Madison | New York | 36053 | 316 | 4 |
201685 | 201685 | 2020-06-02 | Madison | New York | 36053 | 317 | 4 |
204762 | 204762 | 2020-06-03 | Madison | New York | 36053 | 319 | 4 |
207843 | 207843 | 2020-06-04 | Madison | New York | 36053 | 319 | 4 |
210925 | 210925 | 2020-06-05 | Madison | New York | 36053 | 323 | 4 |
214009 | 214009 | 2020-06-06 | Madison | New York | 36053 | 325 | 4 |
217099 | 217099 | 2020-06-07 | Madison | New York | 36053 | 327 | 4 |
220191 | 220191 | 2020-06-08 | Madison | New York | 36053 | 327 | 4 |
223285 | 223285 | 2020-06-09 | Madison | New York | 36053 | 331 | 4 |
226385 | 226385 | 2020-06-10 | Madison | New York | 36053 | 331 | 4 |
229489 | 229489 | 2020-06-11 | Madison | New York | 36053 | 333 | 4 |
232594 | 232594 | 2020-06-12 | Madison | New York | 36053 | 333 | 4 |
235699 | 235699 | 2020-06-13 | Madison | New York | 36053 | 333 | 4 |
238807 | 238807 | 2020-06-14 | Madison | New York | 36053 | 334 | 4 |
241916 | 241916 | 2020-06-15 | Madison | New York | 36053 | 335 | 4 |
245028 | 245028 | 2020-06-16 | Madison | New York | 36053 | 336 | 4 |
248141 | 248141 | 2020-06-17 | Madison | New York | 36053 | 338 | 4 |
251256 | 251256 | 2020-06-18 | Madison | New York | 36053 | 341 | 4 |
254371 | 254371 | 2020-06-19 | Madison | New York | 36053 | 342 | 4 |
257494 | 257494 | 2020-06-20 | Madison | New York | 36053 | 343 | 4 |
260621 | 260621 | 2020-06-21 | Madison | New York | 36053 | 345 | 4 |
263749 | 263749 | 2020-06-22 | Madison | New York | 36053 | 347 | 4 |
266877 | 266877 | 2020-06-23 | Madison | New York | 36053 | 347 | 4 |
270011 | 270011 | 2020-06-24 | Madison | New York | 36053 | 347 | 4 |
273150 | 273150 | 2020-06-25 | Madison | New York | 36053 | 349 | 4 |
276296 | 276296 | 2020-06-26 | Madison | New York | 36053 | 351 | 4 |
279444 | 279444 | 2020-06-27 | Madison | New York | 36053 | 351 | 4 |
282590 | 282590 | 2020-06-28 | Madison | New York | 36053 | 352 | 4 |
285735 | 285735 | 2020-06-29 | Madison | New York | 36053 | 353 | 4 |
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);