ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 36015 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536267 | 536267 | 2020-09-15 | Chemung | New York | 36015 | 269 | 2 |
533031 | 533031 | 2020-09-14 | Chemung | New York | 36015 | 251 | 2 |
529796 | 529796 | 2020-09-13 | Chemung | New York | 36015 | 251 | 2 |
526559 | 526559 | 2020-09-12 | Chemung | New York | 36015 | 247 | 2 |
523323 | 523323 | 2020-09-11 | Chemung | New York | 36015 | 239 | 2 |
520087 | 520087 | 2020-09-10 | Chemung | New York | 36015 | 218 | 2 |
516851 | 516851 | 2020-09-09 | Chemung | New York | 36015 | 214 | 2 |
513616 | 513616 | 2020-09-08 | Chemung | New York | 36015 | 211 | 2 |
510383 | 510383 | 2020-09-07 | Chemung | New York | 36015 | 210 | 2 |
507150 | 507150 | 2020-09-06 | Chemung | New York | 36015 | 208 | 2 |
503918 | 503918 | 2020-09-05 | Chemung | New York | 36015 | 206 | 2 |
500684 | 500684 | 2020-09-04 | Chemung | New York | 36015 | 206 | 2 |
497450 | 497450 | 2020-09-03 | Chemung | New York | 36015 | 205 | 2 |
494217 | 494217 | 2020-09-02 | Chemung | New York | 36015 | 205 | 2 |
490983 | 490983 | 2020-09-01 | Chemung | New York | 36015 | 205 | 2 |
487750 | 487750 | 2020-08-31 | Chemung | New York | 36015 | 203 | 2 |
484517 | 484517 | 2020-08-30 | Chemung | New York | 36015 | 200 | 2 |
481282 | 481282 | 2020-08-29 | Chemung | New York | 36015 | 196 | 2 |
478049 | 478049 | 2020-08-28 | Chemung | New York | 36015 | 196 | 2 |
474816 | 474816 | 2020-08-27 | Chemung | New York | 36015 | 194 | 2 |
471582 | 471582 | 2020-08-26 | Chemung | New York | 36015 | 194 | 2 |
468350 | 468350 | 2020-08-25 | Chemung | New York | 36015 | 194 | 2 |
465122 | 465122 | 2020-08-24 | Chemung | New York | 36015 | 194 | 2 |
461893 | 461893 | 2020-08-23 | Chemung | New York | 36015 | 194 | 2 |
458665 | 458665 | 2020-08-22 | Chemung | New York | 36015 | 194 | 2 |
455437 | 455437 | 2020-08-21 | Chemung | New York | 36015 | 193 | 2 |
452209 | 452209 | 2020-08-20 | Chemung | New York | 36015 | 193 | 2 |
448981 | 448981 | 2020-08-19 | Chemung | New York | 36015 | 191 | 2 |
445753 | 445753 | 2020-08-18 | Chemung | New York | 36015 | 190 | 2 |
442527 | 442527 | 2020-08-17 | Chemung | New York | 36015 | 190 | 2 |
439300 | 439300 | 2020-08-16 | Chemung | New York | 36015 | 189 | 2 |
436075 | 436075 | 2020-08-15 | Chemung | New York | 36015 | 188 | 2 |
432849 | 432849 | 2020-08-14 | Chemung | New York | 36015 | 187 | 2 |
429623 | 429623 | 2020-08-13 | Chemung | New York | 36015 | 184 | 2 |
426398 | 426398 | 2020-08-12 | Chemung | New York | 36015 | 177 | 2 |
423175 | 423175 | 2020-08-11 | Chemung | New York | 36015 | 176 | 2 |
419952 | 419952 | 2020-08-10 | Chemung | New York | 36015 | 172 | 2 |
416732 | 416732 | 2020-08-09 | Chemung | New York | 36015 | 171 | 2 |
413511 | 413511 | 2020-08-08 | Chemung | New York | 36015 | 171 | 2 |
410291 | 410291 | 2020-08-07 | Chemung | New York | 36015 | 168 | 2 |
407071 | 407071 | 2020-08-06 | Chemung | New York | 36015 | 165 | 2 |
403852 | 403852 | 2020-08-05 | Chemung | New York | 36015 | 165 | 5 |
400634 | 400634 | 2020-08-04 | Chemung | New York | 36015 | 163 | 5 |
397419 | 397419 | 2020-08-03 | Chemung | New York | 36015 | 163 | 5 |
394202 | 394202 | 2020-08-02 | Chemung | New York | 36015 | 163 | 5 |
390986 | 390986 | 2020-08-01 | Chemung | New York | 36015 | 163 | 5 |
387769 | 387769 | 2020-07-31 | Chemung | New York | 36015 | 163 | 5 |
384552 | 384552 | 2020-07-30 | Chemung | New York | 36015 | 162 | 5 |
381334 | 381334 | 2020-07-29 | Chemung | New York | 36015 | 161 | 5 |
378117 | 378117 | 2020-07-28 | Chemung | New York | 36015 | 160 | 5 |
374901 | 374901 | 2020-07-27 | Chemung | New York | 36015 | 160 | 5 |
371689 | 371689 | 2020-07-26 | Chemung | New York | 36015 | 160 | 5 |
368477 | 368477 | 2020-07-25 | Chemung | New York | 36015 | 160 | 5 |
365268 | 365268 | 2020-07-24 | Chemung | New York | 36015 | 158 | 5 |
362062 | 362062 | 2020-07-23 | Chemung | New York | 36015 | 157 | 5 |
358856 | 358856 | 2020-07-22 | Chemung | New York | 36015 | 156 | 5 |
355652 | 355652 | 2020-07-21 | Chemung | New York | 36015 | 155 | 5 |
352449 | 352449 | 2020-07-20 | Chemung | New York | 36015 | 155 | 5 |
349246 | 349246 | 2020-07-19 | Chemung | New York | 36015 | 154 | 5 |
346045 | 346045 | 2020-07-18 | Chemung | New York | 36015 | 153 | 5 |
342846 | 342846 | 2020-07-17 | Chemung | New York | 36015 | 151 | 5 |
339648 | 339648 | 2020-07-16 | Chemung | New York | 36015 | 151 | 5 |
336452 | 336452 | 2020-07-15 | Chemung | New York | 36015 | 151 | 5 |
333258 | 333258 | 2020-07-14 | Chemung | New York | 36015 | 149 | 5 |
330068 | 330068 | 2020-07-13 | Chemung | New York | 36015 | 148 | 5 |
326881 | 326881 | 2020-07-12 | Chemung | New York | 36015 | 148 | 5 |
323697 | 323697 | 2020-07-11 | Chemung | New York | 36015 | 148 | 5 |
320517 | 320517 | 2020-07-10 | Chemung | New York | 36015 | 148 | 5 |
317340 | 317340 | 2020-07-09 | Chemung | New York | 36015 | 148 | 5 |
314166 | 314166 | 2020-07-08 | Chemung | New York | 36015 | 147 | 5 |
310995 | 310995 | 2020-07-07 | Chemung | New York | 36015 | 147 | 5 |
307827 | 307827 | 2020-07-06 | Chemung | New York | 36015 | 146 | 5 |
304660 | 304660 | 2020-07-05 | Chemung | New York | 36015 | 146 | 5 |
301497 | 301497 | 2020-07-04 | Chemung | New York | 36015 | 146 | 5 |
298334 | 298334 | 2020-07-03 | Chemung | New York | 36015 | 145 | 5 |
295174 | 295174 | 2020-07-02 | Chemung | New York | 36015 | 144 | 5 |
292019 | 292019 | 2020-07-01 | Chemung | New York | 36015 | 144 | 5 |
288867 | 288867 | 2020-06-30 | Chemung | New York | 36015 | 141 | 5 |
285717 | 285717 | 2020-06-29 | Chemung | New York | 36015 | 140 | 5 |
282572 | 282572 | 2020-06-28 | Chemung | New York | 36015 | 140 | 5 |
279426 | 279426 | 2020-06-27 | Chemung | New York | 36015 | 139 | 5 |
276278 | 276278 | 2020-06-26 | Chemung | New York | 36015 | 139 | 5 |
273132 | 273132 | 2020-06-25 | Chemung | New York | 36015 | 139 | 5 |
269993 | 269993 | 2020-06-24 | Chemung | New York | 36015 | 139 | 5 |
266859 | 266859 | 2020-06-23 | Chemung | New York | 36015 | 139 | 5 |
263731 | 263731 | 2020-06-22 | Chemung | New York | 36015 | 139 | 5 |
260603 | 260603 | 2020-06-21 | Chemung | New York | 36015 | 139 | 5 |
257476 | 257476 | 2020-06-20 | Chemung | New York | 36015 | 139 | 5 |
254353 | 254353 | 2020-06-19 | Chemung | New York | 36015 | 139 | 5 |
251238 | 251238 | 2020-06-18 | Chemung | New York | 36015 | 138 | 5 |
248123 | 248123 | 2020-06-17 | Chemung | New York | 36015 | 138 | 5 |
245010 | 245010 | 2020-06-16 | Chemung | New York | 36015 | 138 | 5 |
241898 | 241898 | 2020-06-15 | Chemung | New York | 36015 | 138 | 5 |
238789 | 238789 | 2020-06-14 | Chemung | New York | 36015 | 138 | 5 |
235681 | 235681 | 2020-06-13 | Chemung | New York | 36015 | 138 | 5 |
232576 | 232576 | 2020-06-12 | Chemung | New York | 36015 | 138 | 5 |
229471 | 229471 | 2020-06-11 | Chemung | New York | 36015 | 138 | 5 |
226367 | 226367 | 2020-06-10 | Chemung | New York | 36015 | 138 | 5 |
223267 | 223267 | 2020-06-09 | Chemung | New York | 36015 | 138 | 5 |
220173 | 220173 | 2020-06-08 | Chemung | New York | 36015 | 137 | 5 |
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);