johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Franklin, New York, US" and province_or_state = "New York" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755144 | 2755144 | 2022-12-29 | US | New York | Franklin | 36033 | 11843 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-30 04:21:04 | Franklin, New York, US | |
1076150 | 1076150 | 2022-12-28 | US | New York | Franklin | 36033 | 11835 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-29 04:21:01 | Franklin, New York, US | |
330147 | 330147 | 2022-12-27 | US | New York | Franklin | 36033 | 11834 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-28 04:21:04 | Franklin, New York, US | |
220220 | 220220 | 2022-12-26 | US | New York | Franklin | 36033 | 11831 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-27 04:21:07 | Franklin, New York, US | |
3224677 | 3224677 | 2022-12-25 | US | New York | Franklin | 36033 | 11830 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-26 04:21:06 | Franklin, New York, US | |
1020591 | 1020591 | 2022-12-24 | US | New York | Franklin | 36033 | 11826 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-25 04:21:04 | Franklin, New York, US | |
692614 | 692614 | 2022-12-23 | US | New York | Franklin | 36033 | 11824 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-24 04:21:02 | Franklin, New York, US | |
2181824 | 2181824 | 2022-12-22 | US | New York | Franklin | 36033 | 11813 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-23 04:21:04 | Franklin, New York, US | |
453628 | 453628 | 2022-12-21 | US | New York | Franklin | 36033 | 11804 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-22 04:20:56 | Franklin, New York, US | |
2953627 | 2953627 | 2022-12-20 | US | New York | Franklin | 36033 | 11800 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-21 04:21:03 | Franklin, New York, US | |
3176029 | 3176029 | 2022-12-19 | US | New York | Franklin | 36033 | 11795 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-20 04:21:04 | Franklin, New York, US | |
1630546 | 1630546 | 2022-12-18 | US | New York | Franklin | 36033 | 11790 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-19 04:21:03 | Franklin, New York, US | |
505925 | 505925 | 2022-12-17 | US | New York | Franklin | 36033 | 11782 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-18 04:21:03 | Franklin, New York, US | |
3326497 | 3326497 | 2022-12-16 | US | New York | Franklin | 36033 | 11777 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-17 04:21:04 | Franklin, New York, US | |
545009 | 545009 | 2022-12-15 | US | New York | Franklin | 36033 | 11774 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-16 04:21:01 | Franklin, New York, US | |
350537 | 350537 | 2022-12-14 | US | New York | Franklin | 36033 | 11762 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-15 04:20:58 | Franklin, New York, US | |
310125 | 310125 | 2022-12-13 | US | New York | Franklin | 36033 | 11746 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-14 04:21:04 | Franklin, New York, US | |
1151186 | 1151186 | 2022-12-12 | US | New York | Franklin | 36033 | 11742 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-13 04:21:01 | Franklin, New York, US | |
871040 | 871040 | 2022-12-11 | US | New York | Franklin | 36033 | 11737 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-12 04:21:01 | Franklin, New York, US | |
259570 | 259570 | 2022-12-10 | US | New York | Franklin | 36033 | 11735 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-11 04:20:50 | Franklin, New York, US | |
3938284 | 3938284 | 2022-12-09 | US | New York | Franklin | 36033 | 11731 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-10 04:21:02 | Franklin, New York, US | |
3379616 | 3379616 | 2022-12-08 | US | New York | Franklin | 36033 | 11724 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-09 04:21:05 | Franklin, New York, US | |
1986887 | 1986887 | 2022-12-07 | US | New York | Franklin | 36033 | 11716 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-08 04:21:07 | Franklin, New York, US | |
3716410 | 3716410 | 2022-12-06 | US | New York | Franklin | 36033 | 11713 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-07 04:20:58 | Franklin, New York, US | |
2417115 | 2417115 | 2022-12-05 | US | New York | Franklin | 36033 | 11710 | 54 | 0 | 44.59040891 | -74.29926032 | 2022-12-06 04:21:03 | Franklin, New York, US | |
720723 | 720723 | 2022-12-04 | US | New York | Franklin | 36033 | 11706 | 53 | 0 | 44.59040891 | -74.29926032 | 2022-12-05 04:20:58 | Franklin, New York, US | |
2819012 | 2819012 | 2022-12-03 | US | New York | Franklin | 36033 | 11705 | 53 | 0 | 44.59040891 | -74.29926032 | 2022-12-04 04:20:56 | Franklin, New York, US | |
835868 | 835868 | 2022-12-02 | US | New York | Franklin | 36033 | 11702 | 53 | 0 | 44.59040891 | -74.29926032 | 2022-12-03 04:21:02 | Franklin, New York, US | |
2138398 | 2138398 | 2022-12-01 | US | New York | Franklin | 36033 | 11697 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-12-02 04:21:07 | Franklin, New York, US | |
1966814 | 1966814 | 2022-11-30 | US | New York | Franklin | 36033 | 11691 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-12-01 04:21:03 | Franklin, New York, US | |
2558828 | 2558828 | 2022-11-29 | US | New York | Franklin | 36033 | 11686 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-30 04:21:07 | Franklin, New York, US | |
1241902 | 1241902 | 2022-11-28 | US | New York | Franklin | 36033 | 11683 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-29 04:21:05 | Franklin, New York, US | |
3553890 | 3553890 | 2022-11-27 | US | New York | Franklin | 36033 | 11681 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-28 04:21:02 | Franklin, New York, US | |
2102370 | 2102370 | 2022-11-26 | US | New York | Franklin | 36033 | 11677 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-27 04:21:05 | Franklin, New York, US | |
489861 | 489861 | 2022-11-25 | US | New York | Franklin | 36033 | 11674 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-26 04:21:11 | Franklin, New York, US | |
3525690 | 3525690 | 2022-11-24 | US | New York | Franklin | 36033 | 11664 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-25 04:21:06 | Franklin, New York, US | |
3314473 | 3314473 | 2022-11-23 | US | New York | Franklin | 36033 | 11662 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-24 04:21:09 | Franklin, New York, US | |
1622514 | 1622514 | 2022-11-22 | US | New York | Franklin | 36033 | 11660 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-23 04:21:06 | Franklin, New York, US | |
3462402 | 3462402 | 2022-11-21 | US | New York | Franklin | 36033 | 11660 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-22 04:20:47 | Franklin, New York, US | |
1642587 | 1642587 | 2022-11-20 | US | New York | Franklin | 36033 | 11660 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-21 04:21:05 | Franklin, New York, US | |
2066144 | 2066144 | 2022-11-19 | US | New York | Franklin | 36033 | 11658 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-20 04:21:08 | Franklin, New York, US | |
1757538 | 1757538 | 2022-11-18 | US | New York | Franklin | 36033 | 11657 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-19 04:21:14 | Franklin, New York, US | |
3028531 | 3028531 | 2022-11-17 | US | New York | Franklin | 36033 | 11654 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-18 04:21:15 | Franklin, New York, US | |
2488242 | 2488242 | 2022-11-16 | US | New York | Franklin | 36033 | 11651 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-17 04:21:11 | Franklin, New York, US | |
294253 | 294253 | 2022-11-15 | US | New York | Franklin | 36033 | 11646 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-16 04:21:09 | Franklin, New York, US | |
3599283 | 3599283 | 2022-11-14 | US | New York | Franklin | 36033 | 11643 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-15 04:21:16 | Franklin, New York, US | |
314141 | 314141 | 2022-11-13 | US | New York | Franklin | 36033 | 11640 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-14 04:21:09 | Franklin, New York, US | |
65302 | 65302 | 2022-11-12 | US | New York | Franklin | 36033 | 11637 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-13 04:21:14 | Franklin, New York, US | |
2929464 | 2929464 | 2022-11-11 | US | New York | Franklin | 36033 | 11634 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-12 04:20:41 | Franklin, New York, US | |
2508300 | 2508300 | 2022-11-10 | US | New York | Franklin | 36033 | 11632 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-11 04:21:22 | Franklin, New York, US | |
2433175 | 2433175 | 2022-11-09 | US | New York | Franklin | 36033 | 11628 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-10 04:21:16 | Franklin, New York, US | |
481831 | 481831 | 2022-11-08 | US | New York | Franklin | 36033 | 11621 | 52 | 0 | 44.59040891 | -74.29926032 | 2022-11-09 04:21:22 | Franklin, New York, US | |
2440981 | 2440981 | 2022-11-07 | US | New York | Franklin | 36033 | 11620 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-11-08 04:21:21 | Franklin, New York, US | |
1052079 | 1052079 | 2022-11-06 | US | New York | Franklin | 36033 | 11618 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-11-07 04:21:26 | Franklin, New York, US | |
620103 | 620103 | 2022-11-05 | US | New York | Franklin | 36033 | 11615 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-11-06 04:21:24 | Franklin, New York, US | |
1024607 | 1024607 | 2022-11-04 | US | New York | Franklin | 36033 | 11610 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-11-05 04:21:52 | Franklin, New York, US | |
433598 | 433598 | 2022-11-03 | US | New York | Franklin | 36033 | 11606 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-11-04 04:22:11 | Franklin, New York, US | |
851840 | 851840 | 2022-11-02 | US | New York | Franklin | 36033 | 11597 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-11-03 04:22:05 | Franklin, New York, US | |
712691 | 712691 | 2022-11-01 | US | New York | Franklin | 36033 | 11592 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-11-02 04:22:09 | Franklin, New York, US | |
3287140 | 3287140 | 2022-10-31 | US | New York | Franklin | 36033 | 11586 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-11-01 04:22:36 | Franklin, New York, US | |
322173 | 322173 | 2022-10-30 | US | New York | Franklin | 36033 | 11583 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-31 04:21:36 | Franklin, New York, US | |
914449 | 914449 | 2022-10-29 | US | New York | Franklin | 36033 | 11577 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-30 04:22:14 | Franklin, New York, US | |
1368718 | 1368718 | 2022-10-28 | US | New York | Franklin | 36033 | 11572 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-29 04:21:13 | Franklin, New York, US | |
3040573 | 3040573 | 2022-10-27 | US | New York | Franklin | 36033 | 11565 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-28 04:22:31 | Franklin, New York, US | |
540993 | 540993 | 2022-10-26 | US | New York | Franklin | 36033 | 11551 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-27 04:22:01 | Franklin, New York, US | |
1832394 | 1832394 | 2022-10-25 | US | New York | Franklin | 36033 | 11541 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-26 04:22:19 | Franklin, New York, US | |
796655 | 796655 | 2022-10-24 | US | New York | Franklin | 36033 | 11536 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-25 04:21:53 | Franklin, New York, US | |
3279110 | 3279110 | 2022-10-23 | US | New York | Franklin | 36033 | 11530 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-24 04:22:29 | Franklin, New York, US | |
2270148 | 2270148 | 2022-10-22 | US | New York | Franklin | 36033 | 11518 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-23 04:22:46 | Franklin, New York, US | |
1594448 | 1594448 | 2022-10-21 | US | New York | Franklin | 36033 | 11507 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-22 04:22:53 | Franklin, New York, US | |
2274164 | 2274164 | 2022-10-20 | US | New York | Franklin | 36033 | 11497 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-21 04:22:23 | Franklin, New York, US | |
200499 | 200499 | 2022-10-19 | US | New York | Franklin | 36033 | 11481 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-20 04:22:59 | Franklin, New York, US | |
2759160 | 2759160 | 2022-10-18 | US | New York | Franklin | 36033 | 11471 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-19 04:22:26 | Franklin, New York, US | |
2026994 | 2026994 | 2022-10-17 | US | New York | Franklin | 36033 | 11466 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-18 04:22:42 | Franklin, New York, US | |
2161772 | 2161772 | 2022-10-16 | US | New York | Franklin | 36033 | 11461 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-17 04:20:31 | Franklin, New York, US | |
517969 | 517969 | 2022-10-15 | US | New York | Franklin | 36033 | 11454 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-16 04:22:39 | Franklin, New York, US | |
2035026 | 2035026 | 2022-10-14 | US | New York | Franklin | 36033 | 11444 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-15 04:22:00 | Franklin, New York, US | |
3755714 | 3755714 | 2022-10-13 | US | New York | Franklin | 36033 | 11431 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-14 04:22:28 | Franklin, New York, US | |
3216539 | 3216539 | 2022-10-12 | US | New York | Franklin | 36033 | 11414 | 51 | 0 | 44.59040891 | -74.29926032 | 2022-10-13 04:22:39 | Franklin, New York, US | |
3252388 | 3252388 | 2022-10-11 | US | New York | Franklin | 36033 | 11406 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-12 04:22:51 | Franklin, New York, US | |
2969647 | 2969647 | 2022-10-10 | US | New York | Franklin | 36033 | 11398 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-11 04:23:05 | Franklin, New York, US | |
3099683 | 3099683 | 2022-10-09 | US | New York | Franklin | 36033 | 11381 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-10 04:22:32 | Franklin, New York, US | |
4004908 | 4004908 | 2022-10-08 | US | New York | Franklin | 36033 | 11363 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-09 04:21:16 | Franklin, New York, US | |
398505 | 398505 | 2022-10-07 | US | New York | Franklin | 36033 | 11351 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-08 04:22:56 | Franklin, New York, US | |
2531622 | 2531622 | 2022-10-06 | US | New York | Franklin | 36033 | 11340 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-07 04:23:08 | Franklin, New York, US | |
1813016 | 1813016 | 2022-10-05 | US | New York | Franklin | 36033 | 11325 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-06 04:21:22 | Franklin, New York, US | |
132990 | 132990 | 2022-10-04 | US | New York | Franklin | 36033 | 11316 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-05 04:23:06 | Franklin, New York, US | |
2687937 | 2687937 | 2022-10-03 | US | New York | Franklin | 36033 | 11307 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-04 04:22:55 | Franklin, New York, US | |
2262004 | 2262004 | 2022-10-02 | US | New York | Franklin | 36033 | 11293 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-03 04:23:11 | Franklin, New York, US | |
2997530 | 2997530 | 2022-10-01 | US | New York | Franklin | 36033 | 11279 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-02 04:21:23 | Franklin, New York, US | |
855856 | 855856 | 2022-09-30 | US | New York | Franklin | 36033 | 11267 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-10-01 04:23:01 | Franklin, New York, US | |
2377782 | 2377782 | 2022-09-29 | US | New York | Franklin | 36033 | 11250 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-09-30 04:23:09 | Franklin, New York, US | |
1562333 | 1562333 | 2022-09-28 | US | New York | Franklin | 36033 | 11232 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-09-29 04:22:34 | Franklin, New York, US | |
3996876 | 3996876 | 2022-09-27 | US | New York | Franklin | 36033 | 11224 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-09-28 04:23:01 | Franklin, New York, US | |
2771204 | 2771204 | 2022-09-26 | US | New York | Franklin | 36033 | 11210 | 49 | 0 | 44.59040891 | -74.29926032 | 2022-09-27 04:23:01 | Franklin, New York, US | |
1978857 | 1978857 | 2022-09-25 | US | New York | Franklin | 36033 | 11210 | 49 | 0 | 44.59040891 | -74.29926032 | 2022-09-26 04:20:52 | Franklin, New York, US | |
2652024 | 2652024 | 2022-09-24 | US | New York | Franklin | 36033 | 11202 | 49 | 0 | 44.59040891 | -74.29926032 | 2022-09-25 04:23:31 | Franklin, New York, US | |
386464 | 386464 | 2022-09-23 | US | New York | Franklin | 36033 | 11194 | 49 | 0 | 44.59040891 | -74.29926032 | 2022-09-24 04:21:40 | Franklin, New York, US | |
1626530 | 1626530 | 2022-09-22 | US | New York | Franklin | 36033 | 11178 | 49 | 0 | 44.59040891 | -74.29926032 | 2022-09-23 04:23:13 | Franklin, New York, US | |
1372734 | 1372734 | 2022-09-21 | US | New York | Franklin | 36033 | 11159 | 49 | 0 | 44.59040891 | -74.29926032 | 2022-09-22 04:22:56 | Franklin, 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]);