ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where county = "Westchester" 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 |
---|---|---|---|---|---|---|---|
536316 | 536316 | 2020-09-15 | Westchester | New York | 36119 | 37600 | 1453 |
533080 | 533080 | 2020-09-14 | Westchester | New York | 36119 | 37570 | 1453 |
529845 | 529845 | 2020-09-13 | Westchester | New York | 36119 | 37530 | 1452 |
526608 | 526608 | 2020-09-12 | Westchester | New York | 36119 | 37485 | 1452 |
523372 | 523372 | 2020-09-11 | Westchester | New York | 36119 | 37453 | 1452 |
520136 | 520136 | 2020-09-10 | Westchester | New York | 36119 | 37404 | 1452 |
516900 | 516900 | 2020-09-09 | Westchester | New York | 36119 | 37354 | 1452 |
513665 | 513665 | 2020-09-08 | Westchester | New York | 36119 | 37313 | 1452 |
510432 | 510432 | 2020-09-07 | Westchester | New York | 36119 | 37276 | 1452 |
507199 | 507199 | 2020-09-06 | Westchester | New York | 36119 | 37245 | 1452 |
503967 | 503967 | 2020-09-05 | Westchester | New York | 36119 | 37204 | 1452 |
500733 | 500733 | 2020-09-04 | Westchester | New York | 36119 | 37151 | 1452 |
497499 | 497499 | 2020-09-03 | Westchester | New York | 36119 | 37105 | 1452 |
494266 | 494266 | 2020-09-02 | Westchester | New York | 36119 | 37056 | 1452 |
491032 | 491032 | 2020-09-01 | Westchester | New York | 36119 | 37020 | 1452 |
487799 | 487799 | 2020-08-31 | Westchester | New York | 36119 | 36983 | 1452 |
484566 | 484566 | 2020-08-30 | Westchester | New York | 36119 | 36948 | 1451 |
481331 | 481331 | 2020-08-29 | Westchester | New York | 36119 | 36894 | 1450 |
478098 | 478098 | 2020-08-28 | Westchester | New York | 36119 | 36862 | 1450 |
474865 | 474865 | 2020-08-27 | Westchester | New York | 36119 | 36824 | 1450 |
471631 | 471631 | 2020-08-26 | Westchester | New York | 36119 | 36779 | 1449 |
468399 | 468399 | 2020-08-25 | Westchester | New York | 36119 | 36741 | 1449 |
465171 | 465171 | 2020-08-24 | Westchester | New York | 36119 | 36709 | 1449 |
461942 | 461942 | 2020-08-23 | Westchester | New York | 36119 | 36688 | 1449 |
458714 | 458714 | 2020-08-22 | Westchester | New York | 36119 | 36650 | 1449 |
455486 | 455486 | 2020-08-21 | Westchester | New York | 36119 | 36620 | 1449 |
452258 | 452258 | 2020-08-20 | Westchester | New York | 36119 | 36585 | 1449 |
449030 | 449030 | 2020-08-19 | Westchester | New York | 36119 | 36562 | 1449 |
445802 | 445802 | 2020-08-18 | Westchester | New York | 36119 | 36539 | 1448 |
442576 | 442576 | 2020-08-17 | Westchester | New York | 36119 | 36485 | 1448 |
439349 | 439349 | 2020-08-16 | Westchester | New York | 36119 | 36452 | 1447 |
436124 | 436124 | 2020-08-15 | Westchester | New York | 36119 | 36434 | 1447 |
432898 | 432898 | 2020-08-14 | Westchester | New York | 36119 | 36401 | 1447 |
429672 | 429672 | 2020-08-13 | Westchester | New York | 36119 | 36356 | 1447 |
426447 | 426447 | 2020-08-12 | Westchester | New York | 36119 | 36323 | 1447 |
423224 | 423224 | 2020-08-11 | Westchester | New York | 36119 | 36271 | 1447 |
420001 | 420001 | 2020-08-10 | Westchester | New York | 36119 | 36232 | 1447 |
416781 | 416781 | 2020-08-09 | Westchester | New York | 36119 | 36204 | 1447 |
413560 | 413560 | 2020-08-08 | Westchester | New York | 36119 | 36179 | 1447 |
410340 | 410340 | 2020-08-07 | Westchester | New York | 36119 | 36135 | 1447 |
407120 | 407120 | 2020-08-06 | Westchester | New York | 36119 | 36106 | 1447 |
403901 | 403901 | 2020-08-05 | Westchester | New York | 36119 | 36074 | 1579 |
400683 | 400683 | 2020-08-04 | Westchester | New York | 36119 | 36048 | 1579 |
397468 | 397468 | 2020-08-03 | Westchester | New York | 36119 | 36013 | 1579 |
394251 | 394251 | 2020-08-02 | Westchester | New York | 36119 | 35997 | 1579 |
391035 | 391035 | 2020-08-01 | Westchester | New York | 36119 | 35973 | 1578 |
387818 | 387818 | 2020-07-31 | Westchester | New York | 36119 | 35932 | 1578 |
384601 | 384601 | 2020-07-30 | Westchester | New York | 36119 | 35912 | 1578 |
381383 | 381383 | 2020-07-29 | Westchester | New York | 36119 | 35873 | 1577 |
378166 | 378166 | 2020-07-28 | Westchester | New York | 36119 | 35837 | 1577 |
374950 | 374950 | 2020-07-27 | Westchester | New York | 36119 | 35798 | 1577 |
371738 | 371738 | 2020-07-26 | Westchester | New York | 36119 | 35776 | 1576 |
368526 | 368526 | 2020-07-25 | Westchester | New York | 36119 | 35737 | 1576 |
365317 | 365317 | 2020-07-24 | Westchester | New York | 36119 | 35699 | 1576 |
362111 | 362111 | 2020-07-23 | Westchester | New York | 36119 | 35666 | 1576 |
358905 | 358905 | 2020-07-22 | Westchester | New York | 36119 | 35635 | 1574 |
355701 | 355701 | 2020-07-21 | Westchester | New York | 36119 | 35586 | 1572 |
352498 | 352498 | 2020-07-20 | Westchester | New York | 36119 | 35550 | 1572 |
349295 | 349295 | 2020-07-19 | Westchester | New York | 36119 | 35514 | 1572 |
346094 | 346094 | 2020-07-18 | Westchester | New York | 36119 | 35502 | 1569 |
342895 | 342895 | 2020-07-17 | Westchester | New York | 36119 | 35462 | 1568 |
339697 | 339697 | 2020-07-16 | Westchester | New York | 36119 | 35421 | 1568 |
336501 | 336501 | 2020-07-15 | Westchester | New York | 36119 | 35393 | 1568 |
333307 | 333307 | 2020-07-14 | Westchester | New York | 36119 | 35365 | 1567 |
330117 | 330117 | 2020-07-13 | Westchester | New York | 36119 | 35326 | 1567 |
326930 | 326930 | 2020-07-12 | Westchester | New York | 36119 | 35296 | 1567 |
323746 | 323746 | 2020-07-11 | Westchester | New York | 36119 | 35259 | 1565 |
320566 | 320566 | 2020-07-10 | Westchester | New York | 36119 | 35225 | 1565 |
317389 | 317389 | 2020-07-09 | Westchester | New York | 36119 | 35182 | 1564 |
314215 | 314215 | 2020-07-08 | Westchester | New York | 36119 | 35153 | 1563 |
311044 | 311044 | 2020-07-07 | Westchester | New York | 36119 | 35105 | 1562 |
307876 | 307876 | 2020-07-06 | Westchester | New York | 36119 | 35083 | 1560 |
304709 | 304709 | 2020-07-05 | Westchester | New York | 36119 | 35042 | 1560 |
301546 | 301546 | 2020-07-04 | Westchester | New York | 36119 | 35019 | 1558 |
298383 | 298383 | 2020-07-03 | Westchester | New York | 36119 | 34979 | 1558 |
295223 | 295223 | 2020-07-02 | Westchester | New York | 36119 | 34911 | 1559 |
292068 | 292068 | 2020-07-01 | Westchester | New York | 36119 | 34865 | 1558 |
288916 | 288916 | 2020-06-30 | Westchester | New York | 36119 | 34837 | 1558 |
285766 | 285766 | 2020-06-29 | Westchester | New York | 36119 | 34797 | 1557 |
282621 | 282621 | 2020-06-28 | Westchester | New York | 36119 | 34779 | 1554 |
279475 | 279475 | 2020-06-27 | Westchester | New York | 36119 | 34747 | 1552 |
276327 | 276327 | 2020-06-26 | Westchester | New York | 36119 | 34699 | 1551 |
273181 | 273181 | 2020-06-25 | Westchester | New York | 36119 | 34641 | 1549 |
270042 | 270042 | 2020-06-24 | Westchester | New York | 36119 | 34596 | 1548 |
266908 | 266908 | 2020-06-23 | Westchester | New York | 36119 | 34580 | 1547 |
263780 | 263780 | 2020-06-22 | Westchester | New York | 36119 | 34556 | 1546 |
260652 | 260652 | 2020-06-21 | Westchester | New York | 36119 | 34520 | 1545 |
257525 | 257525 | 2020-06-20 | Westchester | New York | 36119 | 34485 | 1544 |
254402 | 254402 | 2020-06-19 | Westchester | New York | 36119 | 34454 | 1542 |
251287 | 251287 | 2020-06-18 | Westchester | New York | 36119 | 34408 | 1542 |
248172 | 248172 | 2020-06-17 | Westchester | New York | 36119 | 34384 | 1539 |
245059 | 245059 | 2020-06-16 | Westchester | New York | 36119 | 34357 | 1537 |
241947 | 241947 | 2020-06-15 | Westchester | New York | 36119 | 34326 | 1535 |
238838 | 238838 | 2020-06-14 | Westchester | New York | 36119 | 34289 | 1535 |
235730 | 235730 | 2020-06-13 | Westchester | New York | 36119 | 34252 | 1535 |
232625 | 232625 | 2020-06-12 | Westchester | New York | 36119 | 34174 | 1533 |
229520 | 229520 | 2020-06-11 | Westchester | New York | 36119 | 34105 | 1531 |
226416 | 226416 | 2020-06-10 | Westchester | New York | 36119 | 34075 | 1530 |
223316 | 223316 | 2020-06-09 | Westchester | New York | 36119 | 34034 | 1527 |
220222 | 220222 | 2020-06-08 | Westchester | New York | 36119 | 33999 | 1526 |
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);