ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Warren" 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 |
---|---|---|---|---|---|---|---|
536313 | 536313 | 2020-09-15 | Warren | New York | 36113 | 348 | 30 |
533077 | 533077 | 2020-09-14 | Warren | New York | 36113 | 348 | 30 |
529842 | 529842 | 2020-09-13 | Warren | New York | 36113 | 348 | 30 |
526605 | 526605 | 2020-09-12 | Warren | New York | 36113 | 348 | 30 |
523369 | 523369 | 2020-09-11 | Warren | New York | 36113 | 341 | 30 |
520133 | 520133 | 2020-09-10 | Warren | New York | 36113 | 332 | 30 |
516897 | 516897 | 2020-09-09 | Warren | New York | 36113 | 331 | 30 |
513662 | 513662 | 2020-09-08 | Warren | New York | 36113 | 331 | 30 |
510429 | 510429 | 2020-09-07 | Warren | New York | 36113 | 326 | 30 |
507196 | 507196 | 2020-09-06 | Warren | New York | 36113 | 326 | 30 |
503964 | 503964 | 2020-09-05 | Warren | New York | 36113 | 325 | 30 |
500730 | 500730 | 2020-09-04 | Warren | New York | 36113 | 324 | 30 |
497496 | 497496 | 2020-09-03 | Warren | New York | 36113 | 323 | 30 |
494263 | 494263 | 2020-09-02 | Warren | New York | 36113 | 322 | 30 |
491029 | 491029 | 2020-09-01 | Warren | New York | 36113 | 322 | 30 |
487796 | 487796 | 2020-08-31 | Warren | New York | 36113 | 321 | 30 |
484563 | 484563 | 2020-08-30 | Warren | New York | 36113 | 321 | 30 |
481328 | 481328 | 2020-08-29 | Warren | New York | 36113 | 321 | 30 |
478095 | 478095 | 2020-08-28 | Warren | New York | 36113 | 320 | 30 |
474862 | 474862 | 2020-08-27 | Warren | New York | 36113 | 318 | 30 |
471628 | 471628 | 2020-08-26 | Warren | New York | 36113 | 316 | 30 |
468396 | 468396 | 2020-08-25 | Warren | New York | 36113 | 316 | 30 |
465168 | 465168 | 2020-08-24 | Warren | New York | 36113 | 315 | 30 |
461939 | 461939 | 2020-08-23 | Warren | New York | 36113 | 315 | 30 |
458711 | 458711 | 2020-08-22 | Warren | New York | 36113 | 315 | 30 |
455483 | 455483 | 2020-08-21 | Warren | New York | 36113 | 314 | 30 |
452255 | 452255 | 2020-08-20 | Warren | New York | 36113 | 313 | 30 |
449027 | 449027 | 2020-08-19 | Warren | New York | 36113 | 313 | 30 |
445799 | 445799 | 2020-08-18 | Warren | New York | 36113 | 313 | 30 |
442573 | 442573 | 2020-08-17 | Warren | New York | 36113 | 312 | 30 |
439346 | 439346 | 2020-08-16 | Warren | New York | 36113 | 312 | 30 |
436121 | 436121 | 2020-08-15 | Warren | New York | 36113 | 312 | 30 |
432895 | 432895 | 2020-08-14 | Warren | New York | 36113 | 312 | 30 |
429669 | 429669 | 2020-08-13 | Warren | New York | 36113 | 312 | 30 |
426444 | 426444 | 2020-08-12 | Warren | New York | 36113 | 312 | 30 |
423221 | 423221 | 2020-08-11 | Warren | New York | 36113 | 312 | 30 |
419998 | 419998 | 2020-08-10 | Warren | New York | 36113 | 312 | 30 |
416778 | 416778 | 2020-08-09 | Warren | New York | 36113 | 308 | 30 |
413557 | 413557 | 2020-08-08 | Warren | New York | 36113 | 308 | 30 |
410337 | 410337 | 2020-08-07 | Warren | New York | 36113 | 307 | 30 |
407117 | 407117 | 2020-08-06 | Warren | New York | 36113 | 304 | 30 |
403898 | 403898 | 2020-08-05 | Warren | New York | 36113 | 304 | 31 |
400680 | 400680 | 2020-08-04 | Warren | New York | 36113 | 302 | 31 |
397465 | 397465 | 2020-08-03 | Warren | New York | 36113 | 300 | 31 |
394248 | 394248 | 2020-08-02 | Warren | New York | 36113 | 300 | 31 |
391032 | 391032 | 2020-08-01 | Warren | New York | 36113 | 300 | 31 |
387815 | 387815 | 2020-07-31 | Warren | New York | 36113 | 300 | 31 |
384598 | 384598 | 2020-07-30 | Warren | New York | 36113 | 298 | 31 |
381380 | 381380 | 2020-07-29 | Warren | New York | 36113 | 298 | 31 |
378163 | 378163 | 2020-07-28 | Warren | New York | 36113 | 298 | 31 |
374947 | 374947 | 2020-07-27 | Warren | New York | 36113 | 294 | 31 |
371735 | 371735 | 2020-07-26 | Warren | New York | 36113 | 294 | 31 |
368523 | 368523 | 2020-07-25 | Warren | New York | 36113 | 293 | 31 |
365314 | 365314 | 2020-07-24 | Warren | New York | 36113 | 292 | 31 |
362108 | 362108 | 2020-07-23 | Warren | New York | 36113 | 290 | 31 |
358902 | 358902 | 2020-07-22 | Warren | New York | 36113 | 288 | 31 |
355698 | 355698 | 2020-07-21 | Warren | New York | 36113 | 288 | 31 |
352495 | 352495 | 2020-07-20 | Warren | New York | 36113 | 287 | 31 |
349292 | 349292 | 2020-07-19 | Warren | New York | 36113 | 287 | 31 |
346091 | 346091 | 2020-07-18 | Warren | New York | 36113 | 286 | 31 |
342892 | 342892 | 2020-07-17 | Warren | New York | 36113 | 286 | 31 |
339694 | 339694 | 2020-07-16 | Warren | New York | 36113 | 285 | 31 |
336498 | 336498 | 2020-07-15 | Warren | New York | 36113 | 284 | 31 |
333304 | 333304 | 2020-07-14 | Warren | New York | 36113 | 280 | 31 |
330114 | 330114 | 2020-07-13 | Warren | New York | 36113 | 280 | 31 |
326927 | 326927 | 2020-07-12 | Warren | New York | 36113 | 277 | 31 |
323743 | 323743 | 2020-07-11 | Warren | New York | 36113 | 274 | 31 |
320563 | 320563 | 2020-07-10 | Warren | New York | 36113 | 274 | 31 |
317386 | 317386 | 2020-07-09 | Warren | New York | 36113 | 273 | 31 |
314212 | 314212 | 2020-07-08 | Warren | New York | 36113 | 273 | 31 |
311041 | 311041 | 2020-07-07 | Warren | New York | 36113 | 273 | 31 |
307873 | 307873 | 2020-07-06 | Warren | New York | 36113 | 272 | 31 |
304706 | 304706 | 2020-07-05 | Warren | New York | 36113 | 269 | 31 |
301543 | 301543 | 2020-07-04 | Warren | New York | 36113 | 268 | 31 |
298380 | 298380 | 2020-07-03 | Warren | New York | 36113 | 266 | 31 |
295220 | 295220 | 2020-07-02 | Warren | New York | 36113 | 264 | 31 |
292065 | 292065 | 2020-07-01 | Warren | New York | 36113 | 263 | 31 |
288913 | 288913 | 2020-06-30 | Warren | New York | 36113 | 263 | 31 |
285763 | 285763 | 2020-06-29 | Warren | New York | 36113 | 263 | 31 |
282618 | 282618 | 2020-06-28 | Warren | New York | 36113 | 263 | 31 |
279472 | 279472 | 2020-06-27 | Warren | New York | 36113 | 263 | 31 |
276324 | 276324 | 2020-06-26 | Warren | New York | 36113 | 263 | 31 |
273178 | 273178 | 2020-06-25 | Warren | New York | 36113 | 263 | 31 |
270039 | 270039 | 2020-06-24 | Warren | New York | 36113 | 262 | 31 |
266905 | 266905 | 2020-06-23 | Warren | New York | 36113 | 262 | 31 |
263777 | 263777 | 2020-06-22 | Warren | New York | 36113 | 262 | 31 |
260649 | 260649 | 2020-06-21 | Warren | New York | 36113 | 261 | 31 |
257522 | 257522 | 2020-06-20 | Warren | New York | 36113 | 261 | 31 |
254399 | 254399 | 2020-06-19 | Warren | New York | 36113 | 261 | 31 |
251284 | 251284 | 2020-06-18 | Warren | New York | 36113 | 258 | 31 |
248169 | 248169 | 2020-06-17 | Warren | New York | 36113 | 257 | 31 |
245056 | 245056 | 2020-06-16 | Warren | New York | 36113 | 257 | 31 |
241944 | 241944 | 2020-06-15 | Warren | New York | 36113 | 257 | 31 |
238835 | 238835 | 2020-06-14 | Warren | New York | 36113 | 257 | 31 |
235727 | 235727 | 2020-06-13 | Warren | New York | 36113 | 257 | 31 |
232622 | 232622 | 2020-06-12 | Warren | New York | 36113 | 257 | 31 |
229517 | 229517 | 2020-06-11 | Warren | New York | 36113 | 257 | 31 |
226413 | 226413 | 2020-06-10 | Warren | New York | 36113 | 257 | 31 |
223313 | 223313 | 2020-06-09 | Warren | New York | 36113 | 257 | 31 |
220219 | 220219 | 2020-06-08 | Warren | New York | 36113 | 257 | 31 |
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);