ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Sullivan" 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 |
---|---|---|---|---|---|---|---|
536309 | 536309 | 2020-09-15 | Sullivan | New York | 36105 | 1559 | 37 |
533073 | 533073 | 2020-09-14 | Sullivan | New York | 36105 | 1557 | 37 |
529838 | 529838 | 2020-09-13 | Sullivan | New York | 36105 | 1553 | 37 |
526601 | 526601 | 2020-09-12 | Sullivan | New York | 36105 | 1549 | 37 |
523365 | 523365 | 2020-09-11 | Sullivan | New York | 36105 | 1548 | 37 |
520129 | 520129 | 2020-09-10 | Sullivan | New York | 36105 | 1548 | 37 |
516893 | 516893 | 2020-09-09 | Sullivan | New York | 36105 | 1544 | 37 |
513658 | 513658 | 2020-09-08 | Sullivan | New York | 36105 | 1544 | 37 |
510425 | 510425 | 2020-09-07 | Sullivan | New York | 36105 | 1544 | 37 |
507192 | 507192 | 2020-09-06 | Sullivan | New York | 36105 | 1543 | 37 |
503960 | 503960 | 2020-09-05 | Sullivan | New York | 36105 | 1543 | 37 |
500726 | 500726 | 2020-09-04 | Sullivan | New York | 36105 | 1540 | 37 |
497492 | 497492 | 2020-09-03 | Sullivan | New York | 36105 | 1537 | 37 |
494259 | 494259 | 2020-09-02 | Sullivan | New York | 36105 | 1534 | 37 |
491025 | 491025 | 2020-09-01 | Sullivan | New York | 36105 | 1530 | 37 |
487792 | 487792 | 2020-08-31 | Sullivan | New York | 36105 | 1529 | 37 |
484559 | 484559 | 2020-08-30 | Sullivan | New York | 36105 | 1521 | 37 |
481324 | 481324 | 2020-08-29 | Sullivan | New York | 36105 | 1516 | 37 |
478091 | 478091 | 2020-08-28 | Sullivan | New York | 36105 | 1515 | 37 |
474858 | 474858 | 2020-08-27 | Sullivan | New York | 36105 | 1506 | 37 |
471624 | 471624 | 2020-08-26 | Sullivan | New York | 36105 | 1499 | 37 |
468392 | 468392 | 2020-08-25 | Sullivan | New York | 36105 | 1499 | 37 |
465164 | 465164 | 2020-08-24 | Sullivan | New York | 36105 | 1495 | 37 |
461935 | 461935 | 2020-08-23 | Sullivan | New York | 36105 | 1495 | 37 |
458707 | 458707 | 2020-08-22 | Sullivan | New York | 36105 | 1495 | 37 |
455479 | 455479 | 2020-08-21 | Sullivan | New York | 36105 | 1495 | 37 |
452251 | 452251 | 2020-08-20 | Sullivan | New York | 36105 | 1495 | 37 |
449023 | 449023 | 2020-08-19 | Sullivan | New York | 36105 | 1494 | 37 |
445795 | 445795 | 2020-08-18 | Sullivan | New York | 36105 | 1493 | 37 |
442569 | 442569 | 2020-08-17 | Sullivan | New York | 36105 | 1493 | 37 |
439342 | 439342 | 2020-08-16 | Sullivan | New York | 36105 | 1493 | 37 |
436117 | 436117 | 2020-08-15 | Sullivan | New York | 36105 | 1493 | 37 |
432891 | 432891 | 2020-08-14 | Sullivan | New York | 36105 | 1491 | 37 |
429665 | 429665 | 2020-08-13 | Sullivan | New York | 36105 | 1491 | 37 |
426440 | 426440 | 2020-08-12 | Sullivan | New York | 36105 | 1491 | 37 |
423217 | 423217 | 2020-08-11 | Sullivan | New York | 36105 | 1490 | 37 |
419994 | 419994 | 2020-08-10 | Sullivan | New York | 36105 | 1489 | 37 |
416774 | 416774 | 2020-08-09 | Sullivan | New York | 36105 | 1489 | 37 |
413553 | 413553 | 2020-08-08 | Sullivan | New York | 36105 | 1488 | 37 |
410333 | 410333 | 2020-08-07 | Sullivan | New York | 36105 | 1488 | 37 |
407113 | 407113 | 2020-08-06 | Sullivan | New York | 36105 | 1485 | 37 |
403894 | 403894 | 2020-08-05 | Sullivan | New York | 36105 | 1485 | 32 |
400676 | 400676 | 2020-08-04 | Sullivan | New York | 36105 | 1484 | 32 |
397461 | 397461 | 2020-08-03 | Sullivan | New York | 36105 | 1483 | 32 |
394244 | 394244 | 2020-08-02 | Sullivan | New York | 36105 | 1483 | 32 |
391028 | 391028 | 2020-08-01 | Sullivan | New York | 36105 | 1483 | 32 |
387811 | 387811 | 2020-07-31 | Sullivan | New York | 36105 | 1480 | 32 |
384594 | 384594 | 2020-07-30 | Sullivan | New York | 36105 | 1479 | 32 |
381376 | 381376 | 2020-07-29 | Sullivan | New York | 36105 | 1476 | 32 |
378159 | 378159 | 2020-07-28 | Sullivan | New York | 36105 | 1476 | 32 |
374943 | 374943 | 2020-07-27 | Sullivan | New York | 36105 | 1476 | 32 |
371731 | 371731 | 2020-07-26 | Sullivan | New York | 36105 | 1476 | 32 |
368519 | 368519 | 2020-07-25 | Sullivan | New York | 36105 | 1476 | 32 |
365310 | 365310 | 2020-07-24 | Sullivan | New York | 36105 | 1475 | 32 |
362104 | 362104 | 2020-07-23 | Sullivan | New York | 36105 | 1475 | 32 |
358898 | 358898 | 2020-07-22 | Sullivan | New York | 36105 | 1473 | 32 |
355694 | 355694 | 2020-07-21 | Sullivan | New York | 36105 | 1473 | 32 |
352491 | 352491 | 2020-07-20 | Sullivan | New York | 36105 | 1473 | 32 |
349288 | 349288 | 2020-07-19 | Sullivan | New York | 36105 | 1473 | 32 |
346087 | 346087 | 2020-07-18 | Sullivan | New York | 36105 | 1473 | 31 |
342888 | 342888 | 2020-07-17 | Sullivan | New York | 36105 | 1469 | 31 |
339690 | 339690 | 2020-07-16 | Sullivan | New York | 36105 | 1469 | 31 |
336494 | 336494 | 2020-07-15 | Sullivan | New York | 36105 | 1467 | 31 |
333300 | 333300 | 2020-07-14 | Sullivan | New York | 36105 | 1466 | 31 |
330110 | 330110 | 2020-07-13 | Sullivan | New York | 36105 | 1465 | 31 |
326923 | 326923 | 2020-07-12 | Sullivan | New York | 36105 | 1465 | 31 |
323739 | 323739 | 2020-07-11 | Sullivan | New York | 36105 | 1464 | 31 |
320559 | 320559 | 2020-07-10 | Sullivan | New York | 36105 | 1464 | 31 |
317382 | 317382 | 2020-07-09 | Sullivan | New York | 36105 | 1460 | 31 |
314208 | 314208 | 2020-07-08 | Sullivan | New York | 36105 | 1460 | 31 |
311037 | 311037 | 2020-07-07 | Sullivan | New York | 36105 | 1459 | 31 |
307869 | 307869 | 2020-07-06 | Sullivan | New York | 36105 | 1457 | 31 |
304702 | 304702 | 2020-07-05 | Sullivan | New York | 36105 | 1456 | 31 |
301539 | 301539 | 2020-07-04 | Sullivan | New York | 36105 | 1456 | 31 |
298376 | 298376 | 2020-07-03 | Sullivan | New York | 36105 | 1455 | 31 |
295216 | 295216 | 2020-07-02 | Sullivan | New York | 36105 | 1453 | 31 |
292061 | 292061 | 2020-07-01 | Sullivan | New York | 36105 | 1452 | 31 |
288909 | 288909 | 2020-06-30 | Sullivan | New York | 36105 | 1451 | 31 |
285759 | 285759 | 2020-06-29 | Sullivan | New York | 36105 | 1451 | 31 |
282614 | 282614 | 2020-06-28 | Sullivan | New York | 36105 | 1451 | 31 |
279468 | 279468 | 2020-06-27 | Sullivan | New York | 36105 | 1451 | 31 |
276320 | 276320 | 2020-06-26 | Sullivan | New York | 36105 | 1449 | 31 |
273174 | 273174 | 2020-06-25 | Sullivan | New York | 36105 | 1448 | 31 |
270035 | 270035 | 2020-06-24 | Sullivan | New York | 36105 | 1447 | 31 |
266901 | 266901 | 2020-06-23 | Sullivan | New York | 36105 | 1440 | 31 |
263773 | 263773 | 2020-06-22 | Sullivan | New York | 36105 | 1438 | 31 |
260645 | 260645 | 2020-06-21 | Sullivan | New York | 36105 | 1437 | 31 |
257518 | 257518 | 2020-06-20 | Sullivan | New York | 36105 | 1435 | 31 |
254395 | 254395 | 2020-06-19 | Sullivan | New York | 36105 | 1434 | 31 |
251280 | 251280 | 2020-06-18 | Sullivan | New York | 36105 | 1434 | 31 |
248165 | 248165 | 2020-06-17 | Sullivan | New York | 36105 | 1433 | 31 |
245052 | 245052 | 2020-06-16 | Sullivan | New York | 36105 | 1433 | 31 |
241940 | 241940 | 2020-06-15 | Sullivan | New York | 36105 | 1432 | 31 |
238831 | 238831 | 2020-06-14 | Sullivan | New York | 36105 | 1430 | 31 |
235723 | 235723 | 2020-06-13 | Sullivan | New York | 36105 | 1430 | 31 |
232618 | 232618 | 2020-06-12 | Sullivan | New York | 36105 | 1428 | 31 |
229513 | 229513 | 2020-06-11 | Sullivan | New York | 36105 | 1426 | 31 |
226409 | 226409 | 2020-06-10 | Sullivan | New York | 36105 | 1425 | 31 |
223309 | 223309 | 2020-06-09 | Sullivan | New York | 36105 | 1418 | 31 |
220215 | 220215 | 2020-06-08 | Sullivan | New York | 36105 | 1417 | 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);