johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where latitude = "42.24819348" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755138 | 2755138 | 2022-12-29 | US | New York | Columbia | 36021 | 13336 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-30 04:21:04 | Columbia, New York, US | |
1076144 | 1076144 | 2022-12-28 | US | New York | Columbia | 36021 | 13327 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-29 04:21:01 | Columbia, New York, US | |
330141 | 330141 | 2022-12-27 | US | New York | Columbia | 36021 | 13321 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-28 04:21:04 | Columbia, New York, US | |
220214 | 220214 | 2022-12-26 | US | New York | Columbia | 36021 | 13319 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-27 04:21:07 | Columbia, New York, US | |
3224671 | 3224671 | 2022-12-25 | US | New York | Columbia | 36021 | 13317 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-26 04:21:06 | Columbia, New York, US | |
1020585 | 1020585 | 2022-12-24 | US | New York | Columbia | 36021 | 13310 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-25 04:21:04 | Columbia, New York, US | |
692608 | 692608 | 2022-12-23 | US | New York | Columbia | 36021 | 13300 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-24 04:21:02 | Columbia, New York, US | |
2181818 | 2181818 | 2022-12-22 | US | New York | Columbia | 36021 | 13298 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-23 04:21:04 | Columbia, New York, US | |
453622 | 453622 | 2022-12-21 | US | New York | Columbia | 36021 | 13292 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-22 04:20:56 | Columbia, New York, US | |
2953621 | 2953621 | 2022-12-20 | US | New York | Columbia | 36021 | 13286 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-21 04:21:03 | Columbia, New York, US | |
3176023 | 3176023 | 2022-12-19 | US | New York | Columbia | 36021 | 13278 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-20 04:21:04 | Columbia, New York, US | |
1630540 | 1630540 | 2022-12-18 | US | New York | Columbia | 36021 | 13270 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-19 04:21:03 | Columbia, New York, US | |
505919 | 505919 | 2022-12-17 | US | New York | Columbia | 36021 | 13264 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-18 04:21:03 | Columbia, New York, US | |
3326491 | 3326491 | 2022-12-16 | US | New York | Columbia | 36021 | 13256 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-17 04:21:04 | Columbia, New York, US | |
545003 | 545003 | 2022-12-15 | US | New York | Columbia | 36021 | 13246 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-16 04:21:01 | Columbia, New York, US | |
350531 | 350531 | 2022-12-14 | US | New York | Columbia | 36021 | 13241 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-15 04:20:58 | Columbia, New York, US | |
310119 | 310119 | 2022-12-13 | US | New York | Columbia | 36021 | 13232 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-14 04:21:04 | Columbia, New York, US | |
1151180 | 1151180 | 2022-12-12 | US | New York | Columbia | 36021 | 13228 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-13 04:21:01 | Columbia, New York, US | |
871034 | 871034 | 2022-12-11 | US | New York | Columbia | 36021 | 13221 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-12 04:21:01 | Columbia, New York, US | |
259564 | 259564 | 2022-12-10 | US | New York | Columbia | 36021 | 13216 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-11 04:20:50 | Columbia, New York, US | |
3938278 | 3938278 | 2022-12-09 | US | New York | Columbia | 36021 | 13208 | 163 | 0 | 42.24819348 | -73.63089095 | 2022-12-10 04:21:02 | Columbia, New York, US | |
3379610 | 3379610 | 2022-12-08 | US | New York | Columbia | 36021 | 13202 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-09 04:21:05 | Columbia, New York, US | |
1986881 | 1986881 | 2022-12-07 | US | New York | Columbia | 36021 | 13189 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-08 04:21:07 | Columbia, New York, US | |
3716404 | 3716404 | 2022-12-06 | US | New York | Columbia | 36021 | 13179 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-07 04:20:58 | Columbia, New York, US | |
2417109 | 2417109 | 2022-12-05 | US | New York | Columbia | 36021 | 13174 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-06 04:21:03 | Columbia, New York, US | |
720717 | 720717 | 2022-12-04 | US | New York | Columbia | 36021 | 13169 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-05 04:20:58 | Columbia, New York, US | |
2819006 | 2819006 | 2022-12-03 | US | New York | Columbia | 36021 | 13163 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-04 04:20:56 | Columbia, New York, US | |
835862 | 835862 | 2022-12-02 | US | New York | Columbia | 36021 | 13153 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-03 04:21:02 | Columbia, New York, US | |
2138392 | 2138392 | 2022-12-01 | US | New York | Columbia | 36021 | 13148 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-02 04:21:07 | Columbia, New York, US | |
1966808 | 1966808 | 2022-11-30 | US | New York | Columbia | 36021 | 13139 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-12-01 04:21:03 | Columbia, New York, US | |
2558822 | 2558822 | 2022-11-29 | US | New York | Columbia | 36021 | 13134 | 162 | 0 | 42.24819348 | -73.63089095 | 2022-11-30 04:21:07 | Columbia, New York, US | |
1241896 | 1241896 | 2022-11-28 | US | New York | Columbia | 36021 | 13127 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-29 04:21:05 | Columbia, New York, US | |
3553884 | 3553884 | 2022-11-27 | US | New York | Columbia | 36021 | 13123 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-28 04:21:02 | Columbia, New York, US | |
2102364 | 2102364 | 2022-11-26 | US | New York | Columbia | 36021 | 13120 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-27 04:21:05 | Columbia, New York, US | |
489855 | 489855 | 2022-11-25 | US | New York | Columbia | 36021 | 13116 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-26 04:21:11 | Columbia, New York, US | |
3525684 | 3525684 | 2022-11-24 | US | New York | Columbia | 36021 | 13114 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-25 04:21:06 | Columbia, New York, US | |
3314467 | 3314467 | 2022-11-23 | US | New York | Columbia | 36021 | 13108 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-24 04:21:09 | Columbia, New York, US | |
1622508 | 1622508 | 2022-11-22 | US | New York | Columbia | 36021 | 13099 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-23 04:21:06 | Columbia, New York, US | |
3462396 | 3462396 | 2022-11-21 | US | New York | Columbia | 36021 | 13092 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-22 04:20:47 | Columbia, New York, US | |
1642581 | 1642581 | 2022-11-20 | US | New York | Columbia | 36021 | 13088 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-21 04:21:05 | Columbia, New York, US | |
2066138 | 2066138 | 2022-11-19 | US | New York | Columbia | 36021 | 13082 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-20 04:21:08 | Columbia, New York, US | |
1757532 | 1757532 | 2022-11-18 | US | New York | Columbia | 36021 | 13059 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-19 04:21:14 | Columbia, New York, US | |
3028525 | 3028525 | 2022-11-17 | US | New York | Columbia | 36021 | 13056 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-18 04:21:15 | Columbia, New York, US | |
2488236 | 2488236 | 2022-11-16 | US | New York | Columbia | 36021 | 13049 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-17 04:21:11 | Columbia, New York, US | |
294247 | 294247 | 2022-11-15 | US | New York | Columbia | 36021 | 13048 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-16 04:21:09 | Columbia, New York, US | |
3599277 | 3599277 | 2022-11-14 | US | New York | Columbia | 36021 | 13041 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-15 04:21:16 | Columbia, New York, US | |
314135 | 314135 | 2022-11-13 | US | New York | Columbia | 36021 | 13039 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-14 04:21:09 | Columbia, New York, US | |
65296 | 65296 | 2022-11-12 | US | New York | Columbia | 36021 | 13035 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-13 04:21:14 | Columbia, New York, US | |
2929458 | 2929458 | 2022-11-11 | US | New York | Columbia | 36021 | 13032 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-12 04:20:41 | Columbia, New York, US | |
2508294 | 2508294 | 2022-11-10 | US | New York | Columbia | 36021 | 13027 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-11 04:21:22 | Columbia, New York, US | |
2433169 | 2433169 | 2022-11-09 | US | New York | Columbia | 36021 | 13019 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-10 04:21:16 | Columbia, New York, US | |
481825 | 481825 | 2022-11-08 | US | New York | Columbia | 36021 | 13000 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-09 04:21:22 | Columbia, New York, US | |
2440975 | 2440975 | 2022-11-07 | US | New York | Columbia | 36021 | 12990 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-08 04:21:21 | Columbia, New York, US | |
1052073 | 1052073 | 2022-11-06 | US | New York | Columbia | 36021 | 12984 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-07 04:21:26 | Columbia, New York, US | |
620097 | 620097 | 2022-11-05 | US | New York | Columbia | 36021 | 12972 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-06 04:21:24 | Columbia, New York, US | |
1024601 | 1024601 | 2022-11-04 | US | New York | Columbia | 36021 | 12967 | 160 | 0 | 42.24819348 | -73.63089095 | 2022-11-05 04:21:52 | Columbia, New York, US | |
433592 | 433592 | 2022-11-03 | US | New York | Columbia | 36021 | 12951 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-11-04 04:22:11 | Columbia, New York, US | |
851834 | 851834 | 2022-11-02 | US | New York | Columbia | 36021 | 12944 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-11-03 04:22:05 | Columbia, New York, US | |
712685 | 712685 | 2022-11-01 | US | New York | Columbia | 36021 | 12934 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-11-02 04:22:09 | Columbia, New York, US | |
3287134 | 3287134 | 2022-10-31 | US | New York | Columbia | 36021 | 12931 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-11-01 04:22:36 | Columbia, New York, US | |
322167 | 322167 | 2022-10-30 | US | New York | Columbia | 36021 | 12925 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-10-31 04:21:36 | Columbia, New York, US | |
914443 | 914443 | 2022-10-29 | US | New York | Columbia | 36021 | 12920 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-10-30 04:22:14 | Columbia, New York, US | |
1368712 | 1368712 | 2022-10-28 | US | New York | Columbia | 36021 | 12909 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-10-29 04:21:13 | Columbia, New York, US | |
3040567 | 3040567 | 2022-10-27 | US | New York | Columbia | 36021 | 12902 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-10-28 04:22:31 | Columbia, New York, US | |
540987 | 540987 | 2022-10-26 | US | New York | Columbia | 36021 | 12894 | 159 | 0 | 42.24819348 | -73.63089095 | 2022-10-27 04:22:01 | Columbia, New York, US | |
1832388 | 1832388 | 2022-10-25 | US | New York | Columbia | 36021 | 12885 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-26 04:22:19 | Columbia, New York, US | |
796649 | 796649 | 2022-10-24 | US | New York | Columbia | 36021 | 12875 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-25 04:21:53 | Columbia, New York, US | |
3279104 | 3279104 | 2022-10-23 | US | New York | Columbia | 36021 | 12871 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-24 04:22:29 | Columbia, New York, US | |
2270142 | 2270142 | 2022-10-22 | US | New York | Columbia | 36021 | 12867 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-23 04:22:46 | Columbia, New York, US | |
1594442 | 1594442 | 2022-10-21 | US | New York | Columbia | 36021 | 12859 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-22 04:22:53 | Columbia, New York, US | |
2274158 | 2274158 | 2022-10-20 | US | New York | Columbia | 36021 | 12853 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-21 04:22:23 | Columbia, New York, US | |
200493 | 200493 | 2022-10-19 | US | New York | Columbia | 36021 | 12845 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-20 04:22:59 | Columbia, New York, US | |
2759154 | 2759154 | 2022-10-18 | US | New York | Columbia | 36021 | 12833 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-19 04:22:26 | Columbia, New York, US | |
2026988 | 2026988 | 2022-10-17 | US | New York | Columbia | 36021 | 12827 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-18 04:22:42 | Columbia, New York, US | |
2161766 | 2161766 | 2022-10-16 | US | New York | Columbia | 36021 | 12823 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-17 04:20:31 | Columbia, New York, US | |
517963 | 517963 | 2022-10-15 | US | New York | Columbia | 36021 | 12812 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-16 04:22:39 | Columbia, New York, US | |
2035020 | 2035020 | 2022-10-14 | US | New York | Columbia | 36021 | 12803 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-15 04:22:00 | Columbia, New York, US | |
3755708 | 3755708 | 2022-10-13 | US | New York | Columbia | 36021 | 12789 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-14 04:22:28 | Columbia, New York, US | |
3216533 | 3216533 | 2022-10-12 | US | New York | Columbia | 36021 | 12773 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-13 04:22:39 | Columbia, New York, US | |
3252382 | 3252382 | 2022-10-11 | US | New York | Columbia | 36021 | 12762 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-12 04:22:51 | Columbia, New York, US | |
2969641 | 2969641 | 2022-10-10 | US | New York | Columbia | 36021 | 12754 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-11 04:23:05 | Columbia, New York, US | |
3099677 | 3099677 | 2022-10-09 | US | New York | Columbia | 36021 | 12749 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-10 04:22:32 | Columbia, New York, US | |
4004902 | 4004902 | 2022-10-08 | US | New York | Columbia | 36021 | 12736 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-09 04:21:16 | Columbia, New York, US | |
398499 | 398499 | 2022-10-07 | US | New York | Columbia | 36021 | 12727 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-08 04:22:56 | Columbia, New York, US | |
2531616 | 2531616 | 2022-10-06 | US | New York | Columbia | 36021 | 12710 | 158 | 0 | 42.24819348 | -73.63089095 | 2022-10-07 04:23:08 | Columbia, New York, US | |
1813010 | 1813010 | 2022-10-05 | US | New York | Columbia | 36021 | 12699 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-10-06 04:21:22 | Columbia, New York, US | |
132984 | 132984 | 2022-10-04 | US | New York | Columbia | 36021 | 12690 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-10-05 04:23:06 | Columbia, New York, US | |
2687931 | 2687931 | 2022-10-03 | US | New York | Columbia | 36021 | 12685 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-10-04 04:22:55 | Columbia, New York, US | |
2261998 | 2261998 | 2022-10-02 | US | New York | Columbia | 36021 | 12680 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-10-03 04:23:11 | Columbia, New York, US | |
2997524 | 2997524 | 2022-10-01 | US | New York | Columbia | 36021 | 12676 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-10-02 04:21:23 | Columbia, New York, US | |
855850 | 855850 | 2022-09-30 | US | New York | Columbia | 36021 | 12661 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-10-01 04:23:01 | Columbia, New York, US | |
2377776 | 2377776 | 2022-09-29 | US | New York | Columbia | 36021 | 12652 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-30 04:23:09 | Columbia, New York, US | |
1562327 | 1562327 | 2022-09-28 | US | New York | Columbia | 36021 | 12639 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-29 04:22:34 | Columbia, New York, US | |
3996870 | 3996870 | 2022-09-27 | US | New York | Columbia | 36021 | 12628 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-28 04:23:01 | Columbia, New York, US | |
2771198 | 2771198 | 2022-09-26 | US | New York | Columbia | 36021 | 12591 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-27 04:23:01 | Columbia, New York, US | |
1978851 | 1978851 | 2022-09-25 | US | New York | Columbia | 36021 | 12591 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-26 04:20:52 | Columbia, New York, US | |
2652018 | 2652018 | 2022-09-24 | US | New York | Columbia | 36021 | 12575 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-25 04:23:31 | Columbia, New York, US | |
386458 | 386458 | 2022-09-23 | US | New York | Columbia | 36021 | 12550 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-24 04:21:40 | Columbia, New York, US | |
1626524 | 1626524 | 2022-09-22 | US | New York | Columbia | 36021 | 12471 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-23 04:23:13 | Columbia, New York, US | |
1372728 | 1372728 | 2022-09-21 | US | New York | Columbia | 36021 | 12456 | 157 | 0 | 42.24819348 | -73.63089095 | 2022-09-22 04:22:56 | Columbia, 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]);