johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where latitude = "42.63492579" and province_or_state = "New York" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755166 | 2755166 | 2022-12-29 | US | New York | Otsego | 36077 | 12945 | 105 | 0 | 42.63492579 | -75.03151402 | 2022-12-30 04:21:04 | Otsego, New York, US | |
1076172 | 1076172 | 2022-12-28 | US | New York | Otsego | 36077 | 12937 | 105 | 0 | 42.63492579 | -75.03151402 | 2022-12-29 04:21:01 | Otsego, New York, US | |
330169 | 330169 | 2022-12-27 | US | New York | Otsego | 36077 | 12926 | 105 | 0 | 42.63492579 | -75.03151402 | 2022-12-28 04:21:04 | Otsego, New York, US | |
220242 | 220242 | 2022-12-26 | US | New York | Otsego | 36077 | 12922 | 105 | 0 | 42.63492579 | -75.03151402 | 2022-12-27 04:21:07 | Otsego, New York, US | |
3224699 | 3224699 | 2022-12-25 | US | New York | Otsego | 36077 | 12917 | 105 | 0 | 42.63492579 | -75.03151402 | 2022-12-26 04:21:06 | Otsego, New York, US | |
1020613 | 1020613 | 2022-12-24 | US | New York | Otsego | 36077 | 12908 | 105 | 0 | 42.63492579 | -75.03151402 | 2022-12-25 04:21:04 | Otsego, New York, US | |
692636 | 692636 | 2022-12-23 | US | New York | Otsego | 36077 | 12900 | 105 | 0 | 42.63492579 | -75.03151402 | 2022-12-24 04:21:02 | Otsego, New York, US | |
2181846 | 2181846 | 2022-12-22 | US | New York | Otsego | 36077 | 12890 | 105 | 0 | 42.63492579 | -75.03151402 | 2022-12-23 04:21:04 | Otsego, New York, US | |
453650 | 453650 | 2022-12-21 | US | New York | Otsego | 36077 | 12882 | 104 | 0 | 42.63492579 | -75.03151402 | 2022-12-22 04:20:56 | Otsego, New York, US | |
2953649 | 2953649 | 2022-12-20 | US | New York | Otsego | 36077 | 12869 | 104 | 0 | 42.63492579 | -75.03151402 | 2022-12-21 04:21:03 | Otsego, New York, US | |
3176051 | 3176051 | 2022-12-19 | US | New York | Otsego | 36077 | 12868 | 104 | 0 | 42.63492579 | -75.03151402 | 2022-12-20 04:21:04 | Otsego, New York, US | |
1630568 | 1630568 | 2022-12-18 | US | New York | Otsego | 36077 | 12864 | 104 | 0 | 42.63492579 | -75.03151402 | 2022-12-19 04:21:03 | Otsego, New York, US | |
505947 | 505947 | 2022-12-17 | US | New York | Otsego | 36077 | 12862 | 104 | 0 | 42.63492579 | -75.03151402 | 2022-12-18 04:21:03 | Otsego, New York, US | |
3326519 | 3326519 | 2022-12-16 | US | New York | Otsego | 36077 | 12858 | 104 | 0 | 42.63492579 | -75.03151402 | 2022-12-17 04:21:04 | Otsego, New York, US | |
545031 | 545031 | 2022-12-15 | US | New York | Otsego | 36077 | 12850 | 103 | 0 | 42.63492579 | -75.03151402 | 2022-12-16 04:21:01 | Otsego, New York, US | |
350559 | 350559 | 2022-12-14 | US | New York | Otsego | 36077 | 12846 | 103 | 0 | 42.63492579 | -75.03151402 | 2022-12-15 04:20:58 | Otsego, New York, US | |
310147 | 310147 | 2022-12-13 | US | New York | Otsego | 36077 | 12839 | 103 | 0 | 42.63492579 | -75.03151402 | 2022-12-14 04:21:04 | Otsego, New York, US | |
1151208 | 1151208 | 2022-12-12 | US | New York | Otsego | 36077 | 12833 | 103 | 0 | 42.63492579 | -75.03151402 | 2022-12-13 04:21:01 | Otsego, New York, US | |
871062 | 871062 | 2022-12-11 | US | New York | Otsego | 36077 | 12832 | 103 | 0 | 42.63492579 | -75.03151402 | 2022-12-12 04:21:01 | Otsego, New York, US | |
259592 | 259592 | 2022-12-10 | US | New York | Otsego | 36077 | 12831 | 103 | 0 | 42.63492579 | -75.03151402 | 2022-12-11 04:20:50 | Otsego, New York, US | |
3938306 | 3938306 | 2022-12-09 | US | New York | Otsego | 36077 | 12827 | 103 | 0 | 42.63492579 | -75.03151402 | 2022-12-10 04:21:02 | Otsego, New York, US | |
3379638 | 3379638 | 2022-12-08 | US | New York | Otsego | 36077 | 12823 | 102 | 0 | 42.63492579 | -75.03151402 | 2022-12-09 04:21:05 | Otsego, New York, US | |
1986909 | 1986909 | 2022-12-07 | US | New York | Otsego | 36077 | 12803 | 102 | 0 | 42.63492579 | -75.03151402 | 2022-12-08 04:21:07 | Otsego, New York, US | |
3716432 | 3716432 | 2022-12-06 | US | New York | Otsego | 36077 | 12796 | 102 | 0 | 42.63492579 | -75.03151402 | 2022-12-07 04:20:58 | Otsego, New York, US | |
2417137 | 2417137 | 2022-12-05 | US | New York | Otsego | 36077 | 12790 | 101 | 0 | 42.63492579 | -75.03151402 | 2022-12-06 04:21:03 | Otsego, New York, US | |
720745 | 720745 | 2022-12-04 | US | New York | Otsego | 36077 | 12784 | 101 | 0 | 42.63492579 | -75.03151402 | 2022-12-05 04:20:58 | Otsego, New York, US | |
2819034 | 2819034 | 2022-12-03 | US | New York | Otsego | 36077 | 12777 | 101 | 0 | 42.63492579 | -75.03151402 | 2022-12-04 04:20:56 | Otsego, New York, US | |
835890 | 835890 | 2022-12-02 | US | New York | Otsego | 36077 | 12775 | 101 | 0 | 42.63492579 | -75.03151402 | 2022-12-03 04:21:02 | Otsego, New York, US | |
2138420 | 2138420 | 2022-12-01 | US | New York | Otsego | 36077 | 12769 | 101 | 0 | 42.63492579 | -75.03151402 | 2022-12-02 04:21:07 | Otsego, New York, US | |
1966836 | 1966836 | 2022-11-30 | US | New York | Otsego | 36077 | 12760 | 101 | 0 | 42.63492579 | -75.03151402 | 2022-12-01 04:21:03 | Otsego, New York, US | |
2558850 | 2558850 | 2022-11-29 | US | New York | Otsego | 36077 | 12749 | 101 | 0 | 42.63492579 | -75.03151402 | 2022-11-30 04:21:07 | Otsego, New York, US | |
1241924 | 1241924 | 2022-11-28 | US | New York | Otsego | 36077 | 12747 | 101 | 0 | 42.63492579 | -75.03151402 | 2022-11-29 04:21:05 | Otsego, New York, US | |
3553912 | 3553912 | 2022-11-27 | US | New York | Otsego | 36077 | 12743 | 100 | 0 | 42.63492579 | -75.03151402 | 2022-11-28 04:21:02 | Otsego, New York, US | |
2102392 | 2102392 | 2022-11-26 | US | New York | Otsego | 36077 | 12743 | 100 | 0 | 42.63492579 | -75.03151402 | 2022-11-27 04:21:05 | Otsego, New York, US | |
489883 | 489883 | 2022-11-25 | US | New York | Otsego | 36077 | 12737 | 100 | 0 | 42.63492579 | -75.03151402 | 2022-11-26 04:21:11 | Otsego, New York, US | |
3525712 | 3525712 | 2022-11-24 | US | New York | Otsego | 36077 | 12733 | 100 | 0 | 42.63492579 | -75.03151402 | 2022-11-25 04:21:06 | Otsego, New York, US | |
3314495 | 3314495 | 2022-11-23 | US | New York | Otsego | 36077 | 12728 | 100 | 0 | 42.63492579 | -75.03151402 | 2022-11-24 04:21:09 | Otsego, New York, US | |
1622536 | 1622536 | 2022-11-22 | US | New York | Otsego | 36077 | 12725 | 100 | 0 | 42.63492579 | -75.03151402 | 2022-11-23 04:21:06 | Otsego, New York, US | |
3462424 | 3462424 | 2022-11-21 | US | New York | Otsego | 36077 | 12721 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-22 04:20:47 | Otsego, New York, US | |
1642609 | 1642609 | 2022-11-20 | US | New York | Otsego | 36077 | 12716 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-21 04:21:05 | Otsego, New York, US | |
2066166 | 2066166 | 2022-11-19 | US | New York | Otsego | 36077 | 12712 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-20 04:21:08 | Otsego, New York, US | |
1757560 | 1757560 | 2022-11-18 | US | New York | Otsego | 36077 | 12707 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-19 04:21:14 | Otsego, New York, US | |
3028553 | 3028553 | 2022-11-17 | US | New York | Otsego | 36077 | 12702 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-18 04:21:15 | Otsego, New York, US | |
2488264 | 2488264 | 2022-11-16 | US | New York | Otsego | 36077 | 12700 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-17 04:21:11 | Otsego, New York, US | |
294275 | 294275 | 2022-11-15 | US | New York | Otsego | 36077 | 12696 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-16 04:21:09 | Otsego, New York, US | |
3599305 | 3599305 | 2022-11-14 | US | New York | Otsego | 36077 | 12692 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-15 04:21:16 | Otsego, New York, US | |
314163 | 314163 | 2022-11-13 | US | New York | Otsego | 36077 | 12688 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-14 04:21:09 | Otsego, New York, US | |
65324 | 65324 | 2022-11-12 | US | New York | Otsego | 36077 | 12687 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-13 04:21:14 | Otsego, New York, US | |
2929486 | 2929486 | 2022-11-11 | US | New York | Otsego | 36077 | 12683 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-12 04:20:41 | Otsego, New York, US | |
2508322 | 2508322 | 2022-11-10 | US | New York | Otsego | 36077 | 12678 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-11 04:21:22 | Otsego, New York, US | |
2433197 | 2433197 | 2022-11-09 | US | New York | Otsego | 36077 | 12672 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-10 04:21:16 | Otsego, New York, US | |
481853 | 481853 | 2022-11-08 | US | New York | Otsego | 36077 | 12669 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-09 04:21:22 | Otsego, New York, US | |
2441003 | 2441003 | 2022-11-07 | US | New York | Otsego | 36077 | 12666 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-08 04:21:21 | Otsego, New York, US | |
1052101 | 1052101 | 2022-11-06 | US | New York | Otsego | 36077 | 12661 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-07 04:21:26 | Otsego, New York, US | |
620125 | 620125 | 2022-11-05 | US | New York | Otsego | 36077 | 12657 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-06 04:21:24 | Otsego, New York, US | |
1024629 | 1024629 | 2022-11-04 | US | New York | Otsego | 36077 | 12650 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-05 04:21:52 | Otsego, New York, US | |
433620 | 433620 | 2022-11-03 | US | New York | Otsego | 36077 | 12642 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-04 04:22:11 | Otsego, New York, US | |
851862 | 851862 | 2022-11-02 | US | New York | Otsego | 36077 | 12639 | 99 | 0 | 42.63492579 | -75.03151402 | 2022-11-03 04:22:05 | Otsego, New York, US | |
712713 | 712713 | 2022-11-01 | US | New York | Otsego | 36077 | 12635 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-11-02 04:22:09 | Otsego, New York, US | |
3287162 | 3287162 | 2022-10-31 | US | New York | Otsego | 36077 | 12629 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-11-01 04:22:36 | Otsego, New York, US | |
322195 | 322195 | 2022-10-30 | US | New York | Otsego | 36077 | 12627 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-31 04:21:36 | Otsego, New York, US | |
914471 | 914471 | 2022-10-29 | US | New York | Otsego | 36077 | 12616 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-30 04:22:14 | Otsego, New York, US | |
1368740 | 1368740 | 2022-10-28 | US | New York | Otsego | 36077 | 12606 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-29 04:21:13 | Otsego, New York, US | |
3040595 | 3040595 | 2022-10-27 | US | New York | Otsego | 36077 | 12598 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-28 04:22:31 | Otsego, New York, US | |
541015 | 541015 | 2022-10-26 | US | New York | Otsego | 36077 | 12587 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-27 04:22:01 | Otsego, New York, US | |
1832416 | 1832416 | 2022-10-25 | US | New York | Otsego | 36077 | 12582 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-26 04:22:19 | Otsego, New York, US | |
796677 | 796677 | 2022-10-24 | US | New York | Otsego | 36077 | 12574 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-25 04:21:53 | Otsego, New York, US | |
3279132 | 3279132 | 2022-10-23 | US | New York | Otsego | 36077 | 12568 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-24 04:22:29 | Otsego, New York, US | |
2270170 | 2270170 | 2022-10-22 | US | New York | Otsego | 36077 | 12562 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-23 04:22:46 | Otsego, New York, US | |
1594470 | 1594470 | 2022-10-21 | US | New York | Otsego | 36077 | 12552 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-22 04:22:53 | Otsego, New York, US | |
2274186 | 2274186 | 2022-10-20 | US | New York | Otsego | 36077 | 12542 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-21 04:22:23 | Otsego, New York, US | |
200521 | 200521 | 2022-10-19 | US | New York | Otsego | 36077 | 12531 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-20 04:22:59 | Otsego, New York, US | |
2759182 | 2759182 | 2022-10-18 | US | New York | Otsego | 36077 | 12522 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-19 04:22:26 | Otsego, New York, US | |
2027016 | 2027016 | 2022-10-17 | US | New York | Otsego | 36077 | 12517 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-18 04:22:42 | Otsego, New York, US | |
2161794 | 2161794 | 2022-10-16 | US | New York | Otsego | 36077 | 12507 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-17 04:20:31 | Otsego, New York, US | |
517991 | 517991 | 2022-10-15 | US | New York | Otsego | 36077 | 12501 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-16 04:22:39 | Otsego, New York, US | |
2035048 | 2035048 | 2022-10-14 | US | New York | Otsego | 36077 | 12494 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-15 04:22:00 | Otsego, New York, US | |
3755736 | 3755736 | 2022-10-13 | US | New York | Otsego | 36077 | 12478 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-14 04:22:28 | Otsego, New York, US | |
3216561 | 3216561 | 2022-10-12 | US | New York | Otsego | 36077 | 12461 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-13 04:22:39 | Otsego, New York, US | |
3252410 | 3252410 | 2022-10-11 | US | New York | Otsego | 36077 | 12454 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-12 04:22:51 | Otsego, New York, US | |
2969669 | 2969669 | 2022-10-10 | US | New York | Otsego | 36077 | 12441 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-11 04:23:05 | Otsego, New York, US | |
3099705 | 3099705 | 2022-10-09 | US | New York | Otsego | 36077 | 12433 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-10 04:22:32 | Otsego, New York, US | |
4004930 | 4004930 | 2022-10-08 | US | New York | Otsego | 36077 | 12421 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-09 04:21:16 | Otsego, New York, US | |
398527 | 398527 | 2022-10-07 | US | New York | Otsego | 36077 | 12411 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-08 04:22:56 | Otsego, New York, US | |
2531644 | 2531644 | 2022-10-06 | US | New York | Otsego | 36077 | 12397 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-07 04:23:08 | Otsego, New York, US | |
1813038 | 1813038 | 2022-10-05 | US | New York | Otsego | 36077 | 12386 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-06 04:21:22 | Otsego, New York, US | |
133012 | 133012 | 2022-10-04 | US | New York | Otsego | 36077 | 12374 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-05 04:23:06 | Otsego, New York, US | |
2687959 | 2687959 | 2022-10-03 | US | New York | Otsego | 36077 | 12363 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-04 04:22:55 | Otsego, New York, US | |
2262026 | 2262026 | 2022-10-02 | US | New York | Otsego | 36077 | 12355 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-03 04:23:11 | Otsego, New York, US | |
2997552 | 2997552 | 2022-10-01 | US | New York | Otsego | 36077 | 12339 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-02 04:21:23 | Otsego, New York, US | |
855878 | 855878 | 2022-09-30 | US | New York | Otsego | 36077 | 12328 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-10-01 04:23:01 | Otsego, New York, US | |
2377804 | 2377804 | 2022-09-29 | US | New York | Otsego | 36077 | 12316 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-30 04:23:09 | Otsego, New York, US | |
1562355 | 1562355 | 2022-09-28 | US | New York | Otsego | 36077 | 12308 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-29 04:22:34 | Otsego, New York, US | |
3996898 | 3996898 | 2022-09-27 | US | New York | Otsego | 36077 | 12294 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-28 04:23:01 | Otsego, New York, US | |
2771226 | 2771226 | 2022-09-26 | US | New York | Otsego | 36077 | 12276 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-27 04:23:01 | Otsego, New York, US | |
1978879 | 1978879 | 2022-09-25 | US | New York | Otsego | 36077 | 12276 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-26 04:20:52 | Otsego, New York, US | |
2652046 | 2652046 | 2022-09-24 | US | New York | Otsego | 36077 | 12268 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-25 04:23:31 | Otsego, New York, US | |
386486 | 386486 | 2022-09-23 | US | New York | Otsego | 36077 | 12259 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-24 04:21:40 | Otsego, New York, US | |
1626552 | 1626552 | 2022-09-22 | US | New York | Otsego | 36077 | 12242 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-23 04:23:13 | Otsego, New York, US | |
1372756 | 1372756 | 2022-09-21 | US | New York | Otsego | 36077 | 12232 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-22 04:22:56 | Otsego, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);