daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
64,046 rows where province_or_state = "New York" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-01-21 | US | New York | Richmond | 36085 | 45939 | 1392 | 0 | 44547 | 40.58582155 | -74.14808598 | 2021-01-22 05:22:10 | Richmond, New York, US |
2021-10-20 | US | New York | Richmond | 36085 | 88838 | 1935 | 0 | 40.58582155 | -74.14808598 | 2021-10-21 04:21:18 | Richmond, New York, US | |
2021-11-17 | US | New York | Richmond | 36085 | 91117 | 1961 | 0 | 40.58582155 | -74.14808598 | 2021-11-18 04:21:33 | Richmond, New York, US | |
2022-12-21 | US | New York | Richmond | 36085 | 216387 | 2592 | 0 | 40.58582155 | -74.14808598 | 2022-12-22 04:20:56 | Richmond, New York, US | |
2022-02-02 | US | New York | Richmond | 36085 | 161630 | 2183 | 0 | 40.58582155 | -74.14808598 | 2022-02-03 04:21:21 | Richmond, New York, US | |
2022-05-02 | US | New York | Richmond | 36085 | 169805 | 2325 | 0 | 40.58582155 | -74.14808598 | 2022-05-03 04:21:00 | Richmond, New York, US | |
2021-10-07 | US | New York | Richmond | 36085 | 87474 | 1917 | 0 | 40.58582155 | -74.14808598 | 2021-10-08 04:21:25 | Richmond, New York, US | |
2021-02-19 | US | New York | Richmond | 36085 | 54749 | 1542 | 0 | 53207 | 40.58582155 | -74.14808598 | 2021-02-20 05:22:51 | Richmond, New York, US |
2022-06-26 | US | New York | Richmond | 36085 | 183179 | 2369 | 0 | 40.58582155 | -74.14808598 | 2022-06-27 04:21:00 | Richmond, New York, US | |
2022-11-08 | US | New York | Richmond | 36085 | 208654 | 2534 | 0 | 40.58582155 | -74.14808598 | 2022-11-09 04:21:22 | Richmond, New York, US | |
2021-07-19 | US | New York | Richmond | 36085 | 76147 | 1850 | 0 | 40.58582155 | -74.14808598 | 2021-07-20 04:21:48 | Richmond, New York, US | |
2022-11-25 | US | New York | Richmond | 36085 | 210742 | 2551 | 0 | 40.58582155 | -74.14808598 | 2022-11-26 04:21:11 | Richmond, New York, US | |
2021-10-14 | US | New York | Richmond | 36085 | 88141 | 1930 | 0 | 40.58582155 | -74.14808598 | 2021-10-15 04:21:26 | Richmond, New York, US | |
2021-11-06 | US | New York | Richmond | 36085 | 90131 | 1946 | 0 | 40.58582155 | -74.14808598 | 2021-11-07 04:21:53 | Richmond, New York, US | |
2022-04-02 | US | New York | Richmond | 36085 | 165600 | 2310 | 0 | 40.58582155 | -74.14808598 | 2022-04-03 04:20:48 | Richmond, New York, US | |
2022-12-17 | US | New York | Richmond | 36085 | 215261 | 2581 | 0 | 40.58582155 | -74.14808598 | 2022-12-18 04:21:03 | Richmond, New York, US | |
2021-08-14 | US | New York | Richmond | 36085 | 79437 | 1865 | 0 | 40.58582155 | -74.14808598 | 2021-08-15 04:21:41 | Richmond, New York, US | |
2021-08-19 | US | New York | Richmond | 36085 | 80249 | 1870 | 0 | 40.58582155 | -74.14808598 | 2021-08-20 04:21:33 | Richmond, New York, US | |
2022-10-15 | US | New York | Richmond | 36085 | 204872 | 2496 | 0 | 40.58582155 | -74.14808598 | 2022-10-16 04:22:39 | Richmond, New York, US | |
2021-06-09 | US | New York | Richmond | 36085 | 74860 | 1839 | 0 | 40.58582155 | -74.14808598 | 2021-06-10 04:23:17 | Richmond, New York, US | |
2021-02-22 | US | New York | Richmond | 36085 | 55424 | 1551 | 0 | 53873 | 40.58582155 | -74.14808598 | 2021-02-23 05:23:41 | Richmond, New York, US |
2021-10-27 | US | New York | Richmond | 36085 | 89460 | 1942 | 0 | 40.58582155 | -74.14808598 | 2021-10-28 04:22:08 | Richmond, New York, US | |
2022-10-26 | US | New York | Richmond | 36085 | 206858 | 2527 | 0 | 40.58582155 | -74.14808598 | 2022-10-27 04:22:01 | Richmond, New York, US | |
2022-12-15 | US | New York | Richmond | 36085 | 215010 | 2578 | 0 | 40.58582155 | -74.14808598 | 2022-12-16 04:21:01 | Richmond, New York, US | |
2020-09-12 | US | New York | Richmond | 36085 | 15616 | 1084 | 0 | 14532 | 40.58582155 | -74.14808598 | 2020-09-13 04:30:52 | Richmond, New York, US |
2021-12-08 | US | New York | Richmond | 36085 | 94598 | 1978 | 0 | 40.58582155 | -74.14808598 | 2021-12-09 04:22:49 | Richmond, New York, US | |
2022-01-16 | US | New York | Richmond | 36085 | 152730 | 2069 | 0 | 40.58582155 | -74.14808598 | 2022-01-17 04:21:08 | Richmond, New York, US | |
2022-06-16 | US | New York | Richmond | 36085 | 181581 | 2361 | 0 | 40.58582155 | -74.14808598 | 2022-06-17 04:20:56 | Richmond, New York, US | |
2021-06-22 | US | New York | Richmond | 36085 | 75132 | 1843 | 0 | 40.58582155 | -74.14808598 | 2021-06-23 04:21:46 | Richmond, New York, US | |
2021-10-29 | US | New York | Richmond | 36085 | 89609 | 1943 | 0 | 40.58582155 | -74.14808598 | 2021-10-30 04:22:03 | Richmond, New York, US | |
2022-02-25 | US | New York | Richmond | 36085 | 163949 | 2275 | 0 | 40.58582155 | -74.14808598 | 2022-02-26 04:21:12 | Richmond, New York, US | |
2021-07-13 | US | New York | Richmond | 36085 | 75812 | 1846 | 0 | 40.58582155 | -74.14808598 | 2021-07-14 04:21:35 | Richmond, New York, US | |
2021-08-08 | US | New York | Richmond | 36085 | 78388 | 1858 | 0 | 40.58582155 | -74.14808598 | 2021-08-09 04:21:24 | Richmond, New York, US | |
2022-07-01 | US | New York | Richmond | 36085 | 184691 | 2375 | 0 | 40.58582155 | -74.14808598 | 2022-07-02 04:21:16 | Richmond, New York, US | |
2021-10-19 | US | New York | Richmond | 36085 | 88731 | 1933 | 0 | 40.58582155 | -74.14808598 | 2021-10-20 04:21:00 | Richmond, New York, US | |
2021-09-23 | US | New York | Richmond | 36085 | 85840 | 1905 | 0 | 40.58582155 | -74.14808598 | 2021-09-24 04:21:44 | Richmond, New York, US | |
2021-04-09 | US | New York | Richmond | 36085 | 68593 | 1724 | 0 | 40.58582155 | -74.14808598 | 2021-04-10 04:20:59 | Richmond, New York, US | |
2021-02-08 | US | New York | Richmond | 36085 | 51774 | 1490 | 0 | 50284 | 40.58582155 | -74.14808598 | 2021-02-09 05:23:30 | Richmond, New York, US |
2022-11-05 | US | New York | Richmond | 36085 | 208183 | 2533 | 0 | 40.58582155 | -74.14808598 | 2022-11-06 04:21:24 | Richmond, New York, US | |
2022-05-22 | US | New York | Richmond | 36085 | 176416 | 2335 | 0 | 40.58582155 | -74.14808598 | 2022-05-26 04:20:50 | Richmond, New York, US | |
2021-07-10 | US | New York | Richmond | 36085 | 75663 | 1845 | 0 | 40.58582155 | -74.14808598 | 2021-07-11 04:21:43 | Richmond, New York, US | |
2022-07-12 | US | New York | Richmond | 36085 | 187454 | 2381 | 0 | 40.58582155 | -74.14808598 | 2022-07-13 04:20:58 | Richmond, New York, US | |
2021-10-13 | US | New York | Richmond | 36085 | 88048 | 1928 | 0 | 40.58582155 | -74.14808598 | 2021-10-14 04:21:29 | Richmond, New York, US | |
2021-03-31 | US | New York | Richmond | 36085 | 65796 | 1694 | 0 | 40.58582155 | -74.14808598 | 2021-04-01 04:27:05 | Richmond, New York, US | |
2021-09-07 | US | New York | Richmond | 36085 | 83364 | 1892 | 0 | 40.58582155 | -74.14808598 | 2021-09-08 04:21:31 | Richmond, New York, US | |
2021-05-05 | US | New York | Richmond | 36085 | 73277 | 1785 | 0 | 40.58582155 | -74.14808598 | 2021-05-06 04:20:38 | Richmond, New York, US | |
2021-08-09 | US | New York | Richmond | 36085 | 78388 | 1858 | 0 | 40.58582155 | -74.14808598 | 2021-08-10 04:21:27 | Richmond, New York, US | |
2021-10-22 | US | New York | Richmond | 36085 | 89034 | 1936 | 0 | 40.58582155 | -74.14808598 | 2021-10-23 04:21:32 | Richmond, New York, US | |
2022-05-13 | US | New York | Richmond | 36085 | 172680 | 2331 | 0 | 40.58582155 | -74.14808598 | 2022-05-14 04:20:48 | Richmond, New York, US | |
2020-09-16 | US | New York | Richmond | 36085 | 15695 | 1084 | 0 | 14611 | 40.58582155 | -74.14808598 | 2020-09-17 04:22:00 | Richmond, New York, US |
2022-07-21 | US | New York | Richmond | 36085 | 190066 | 2390 | 0 | 40.58582155 | -74.14808598 | 2022-07-22 04:21:15 | Richmond, New York, US | |
2022-07-30 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-07-31 04:21:02 | Richmond, New York, US | |
2020-11-23 | US | New York | Richmond | 36085 | 21942 | 1118 | 0 | 20824 | 40.58582155 | -74.14808598 | 2020-11-24 05:27:31 | Richmond, New York, US |
2021-10-24 | US | New York | Richmond | 36085 | 89034 | 1936 | 0 | 40.58582155 | -74.14808598 | 2021-10-25 04:22:31 | Richmond, New York, US | |
2021-11-13 | US | New York | Richmond | 36085 | 90681 | 1955 | 0 | 40.58582155 | -74.14808598 | 2021-11-14 04:21:31 | Richmond, New York, US | |
2022-12-23 | US | New York | Richmond | 36085 | 217037 | 2598 | 0 | 40.58582155 | -74.14808598 | 2022-12-24 04:21:02 | Richmond, New York, US | |
2022-03-17 | US | New York | Richmond | 36085 | 164734 | 2297 | 0 | 40.58582155 | -74.14808598 | 2022-03-18 04:20:55 | Richmond, New York, US | |
2021-11-04 | US | New York | Richmond | 36085 | 90045 | 1945 | 0 | 40.58582155 | -74.14808598 | 2021-11-05 04:21:54 | Richmond, New York, US | |
2021-03-16 | US | New York | Richmond | 36085 | 61263 | 1639 | 0 | 40.58582155 | -74.14808598 | 2021-03-17 05:25:07 | Richmond, New York, US | |
2021-09-29 | US | New York | Richmond | 36085 | 86563 | 1912 | 0 | 40.58582155 | -74.14808598 | 2021-09-30 04:21:20 | Richmond, New York, US | |
2022-11-01 | US | New York | Richmond | 36085 | 207700 | 2531 | 0 | 40.58582155 | -74.14808598 | 2022-11-02 04:22:09 | Richmond, New York, US | |
2021-11-12 | US | New York | Richmond | 36085 | 90681 | 1955 | 0 | 40.58582155 | -74.14808598 | 2021-11-13 04:21:38 | Richmond, New York, US | |
2022-12-04 | US | New York | Richmond | 36085 | 212356 | 2559 | 0 | 40.58582155 | -74.14808598 | 2022-12-05 04:20:58 | Richmond, New York, US | |
2021-11-20 | US | New York | Richmond | 36085 | 91384 | 1964 | 0 | 40.58582155 | -74.14808598 | 2021-11-21 04:22:13 | Richmond, New York, US | |
2021-05-22 | US | New York | Richmond | 36085 | 74357 | 1817 | 0 | 40.58582155 | -74.14808598 | 2021-05-23 04:20:51 | Richmond, New York, US | |
2021-12-27 | US | New York | Richmond | 36085 | 107908 | 1996 | 0 | 40.58582155 | -74.14808598 | 2021-12-28 04:21:47 | Richmond, New York, US | |
2020-12-02 | US | New York | Richmond | 36085 | 24414 | 1137 | 0 | 23277 | 40.58582155 | -74.14808598 | 2020-12-03 05:28:22 | Richmond, New York, US |
2021-02-20 | US | New York | Richmond | 36085 | 55023 | 1547 | 0 | 53476 | 40.58582155 | -74.14808598 | 2021-02-21 05:24:33 | Richmond, New York, US |
2022-04-23 | US | New York | Richmond | 36085 | 168166 | 2323 | 0 | 40.58582155 | -74.14808598 | 2022-04-24 04:20:56 | Richmond, New York, US | |
2020-10-28 | US | New York | Richmond | 36085 | 17354 | 1095 | 0 | 16259 | 40.58582155 | -74.14808598 | 2020-10-29 04:24:49 | Richmond, New York, US |
2021-11-26 | US | New York | Richmond | 36085 | 92247 | 1967 | 0 | 40.58582155 | -74.14808598 | 2021-11-27 04:22:45 | Richmond, New York, US | |
2020-10-18 | US | New York | Richmond | 36085 | 16781 | 1091 | 0 | 15690 | 40.58582155 | -74.14808598 | 2020-10-19 04:24:16 | Richmond, New York, US |
2020-12-29 | US | New York | Richmond | 36085 | 34134 | 1261 | 0 | 32873 | 40.58582155 | -74.14808598 | 2020-12-30 05:22:34 | Richmond, New York, US |
2021-10-23 | US | New York | Richmond | 36085 | 89034 | 1936 | 0 | 40.58582155 | -74.14808598 | 2021-10-24 04:21:22 | Richmond, New York, US | |
2021-01-12 | US | New York | Richmond | 36085 | 41711 | 1345 | 0 | 40366 | 40.58582155 | -74.14808598 | 2021-01-13 05:22:15 | Richmond, New York, US |
2021-07-08 | US | New York | Richmond | 36085 | 75584 | 1847 | 0 | 40.58582155 | -74.14808598 | 2021-07-09 04:21:21 | Richmond, New York, US | |
2021-12-13 | US | New York | Richmond | 36085 | 96074 | 1982 | 0 | 40.58582155 | -74.14808598 | 2021-12-14 04:22:38 | Richmond, New York, US | |
2020-10-15 | US | New York | Richmond | 36085 | 16639 | 1089 | 0 | 15550 | 40.58582155 | -74.14808598 | 2020-10-16 04:24:01 | Richmond, New York, US |
2021-02-04 | US | New York | Richmond | 36085 | 50646 | 1466 | 0 | 49180 | 40.58582155 | -74.14808598 | 2021-02-05 05:22:38 | Richmond, New York, US |
2022-10-24 | US | New York | Richmond | 36085 | 206635 | 2515 | 0 | 40.58582155 | -74.14808598 | 2022-10-25 04:21:53 | Richmond, New York, US | |
2021-12-22 | US | New York | Richmond | 36085 | 101025 | 1994 | 0 | 40.58582155 | -74.14808598 | 2021-12-23 04:21:21 | Richmond, New York, US | |
2020-03-27 | US | New York | Richmond | 36085 | 0 | 0 | 0 | 0 | 40.58582155 | -74.14808598 | 2020-03-27 22:14:55 | Richmond, New York, US |
2021-09-20 | US | New York | Richmond | 36085 | 85397 | 1901 | 0 | 40.58582155 | -74.14808598 | 2021-09-21 04:21:26 | Richmond, New York, US | |
2020-09-05 | US | New York | Richmond | 36085 | 15452 | 1085 | 0 | 14367 | 40.58582155 | -74.14808598 | 2020-09-06 04:28:33 | Richmond, New York, US |
2020-10-09 | US | New York | Richmond | 36085 | 16411 | 1088 | 0 | 15323 | 40.58582155 | -74.14808598 | 2020-10-10 04:23:57 | Richmond, New York, US |
2020-11-19 | US | New York | Richmond | 36085 | 20941 | 1114 | 0 | 19827 | 40.58582155 | -74.14808598 | 2020-11-20 05:26:28 | Richmond, New York, US |
2021-06-06 | US | New York | Richmond | 36085 | 74801 | 1837 | 0 | 40.58582155 | -74.14808598 | 2021-06-07 04:22:51 | Richmond, New York, US | |
2021-07-09 | US | New York | Richmond | 36085 | 75622 | 1846 | 0 | 40.58582155 | -74.14808598 | 2021-07-10 04:21:25 | Richmond, New York, US | |
2022-12-02 | US | New York | Richmond | 36085 | 212356 | 2559 | 0 | 40.58582155 | -74.14808598 | 2022-12-03 04:21:02 | Richmond, New York, US | |
2020-12-12 | US | New York | Richmond | 36085 | 28459 | 1181 | 0 | 27278 | 40.58582155 | -74.14808598 | 2020-12-13 05:27:20 | Richmond, New York, US |
2022-11-02 | US | New York | Richmond | 36085 | 207829 | 2531 | 0 | 40.58582155 | -74.14808598 | 2022-11-03 04:22:05 | Richmond, New York, US | |
2022-09-30 | US | New York | Richmond | 36085 | 202603 | 2482 | 0 | 40.58582155 | -74.14808598 | 2022-10-01 04:23:01 | Richmond, New York, US | |
2020-12-11 | US | New York | Richmond | 36085 | 28073 | 1178 | 0 | 26895 | 40.58582155 | -74.14808598 | 2020-12-12 05:26:19 | Richmond, New York, US |
2020-11-12 | US | New York | Richmond | 36085 | 19396 | 1104 | 0 | 18292 | 40.58582155 | -74.14808598 | 2020-11-13 05:25:30 | Richmond, New York, US |
2022-12-11 | US | New York | Richmond | 36085 | 213706 | 2569 | 0 | 40.58582155 | -74.14808598 | 2022-12-12 04:21:01 | Richmond, New York, US | |
2022-03-27 | US | New York | Richmond | 36085 | 165226 | 2309 | 0 | 40.58582155 | -74.14808598 | 2022-03-28 04:20:33 | Richmond, New York, US | |
2022-08-05 | US | New York | Richmond | 36085 | 193980 | 2412 | 0 | 40.58582155 | -74.14808598 | 2022-08-06 04:20:56 | Richmond, New York, US | |
2021-04-26 | US | New York | Richmond | 36085 | 72269 | 1765 | 0 | 40.58582155 | -74.14808598 | 2021-04-27 04:20:52 | Richmond, New York, US | |
2020-11-05 | US | New York | Richmond | 36085 | 18148 | 1099 | 0 | 17049 | 40.58582155 | -74.14808598 | 2020-11-06 05:24:55 | Richmond, New York, US |
2022-07-24 | US | New York | Richmond | 36085 | 190366 | 2393 | 0 | 40.58582155 | -74.14808598 | 2022-07-25 04:20:51 | Richmond, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;