daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
64,046 rows where province_or_state = "New York" sorted by deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▲ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-08-30 | US | New York | New York City | 36061 | 233969 | 23689 | 0 | 210280 | 40.76727260000001 | -73.97152637 | 2020-08-31 04:28:27 | New York City, New York, US |
2020-08-29 | US | New York | New York City | 36061 | 233688 | 23683 | 0 | 210005 | 40.76727260000001 | -73.97152637 | 2020-08-30 04:28:22 | New York City, New York, US |
2020-08-28 | US | New York | New York City | 36061 | 233410 | 23680 | 0 | 209730 | 40.76727260000001 | -73.97152637 | 2020-08-29 04:28:19 | New York City, New York, US |
2020-08-27 | US | New York | New York City | 36061 | 233140 | 23674 | 0 | 209466 | 40.76727260000001 | -73.97152637 | 2020-08-28 04:28:11 | New York City, New York, US |
2020-08-26 | US | New York | New York City | 36061 | 232825 | 23669 | 0 | 209156 | 40.76727260000001 | -73.97152637 | 2020-08-27 04:28:15 | New York City, New York, US |
2020-08-25 | US | New York | New York City | 36061 | 232565 | 23666 | 0 | 208899 | 40.76727260000001 | -73.97152637 | 2020-08-26 04:28:11 | New York City, New York, US |
2020-08-24 | US | New York | New York City | 36061 | 232334 | 23662 | 0 | 208672 | 40.76727260000001 | -73.97152637 | 2020-08-25 04:28:02 | New York City, New York, US |
2020-08-23 | US | New York | New York City | 36061 | 232120 | 23658 | 0 | 208462 | 40.76727260000001 | -73.97152637 | 2020-08-24 04:27:56 | New York City, New York, US |
2020-08-22 | US | New York | New York City | 36061 | 231841 | 23646 | 0 | 208195 | 40.76727260000001 | -73.97152637 | 2020-08-23 04:27:48 | New York City, New York, US |
2020-08-19 | US | New York | New York City | 36061 | 231015 | 23643 | 0 | 207372 | 40.76727260000001 | -73.97152637 | 2020-08-20 04:27:43 | New York City, New York, US |
2020-08-18 | US | New York | New York City | 36061 | 230742 | 23642 | 0 | 207100 | 40.7672726 | -73.97152637 | 2020-08-19 04:27:00 | New York City, New York, US |
2020-08-21 | US | New York | New York City | 36061 | 231574 | 23641 | 0 | 207933 | 40.76727260000001 | -73.97152637 | 2020-08-22 04:27:49 | New York City, New York, US |
2020-08-20 | US | New York | New York City | 36061 | 231288 | 23639 | 0 | 207649 | 40.76727260000001 | -73.97152637 | 2020-08-21 04:27:41 | New York City, New York, US |
2020-08-17 | US | New York | New York City | 36061 | 230458 | 23634 | 0 | 206824 | 40.76727260000001 | -73.97152637 | 2020-08-18 04:27:56 | New York City, New York, US |
2020-08-16 | US | New York | New York City | 36061 | 230223 | 23628 | 0 | 206595 | 40.76727260000001 | -73.97152637 | 2020-08-17 04:27:20 | New York City, New York, US |
2020-08-15 | US | New York | New York City | 36061 | 229916 | 23621 | 0 | 206295 | 40.76727260000001 | -73.97152637 | 2020-08-16 04:27:42 | New York City, New York, US |
2020-08-14 | US | New York | New York City | 36061 | 229534 | 23615 | 0 | 205919 | 40.76727260000001 | -73.97152637 | 2020-08-15 04:27:31 | New York City, New York, US |
2020-08-13 | US | New York | New York City | 36061 | 229167 | 23610 | 0 | 205557 | 40.76727260000001 | -73.97152637 | 2020-08-14 04:51:19 | New York City, New York, US |
2020-08-12 | US | New York | New York City | 36061 | 228729 | 23602 | 0 | 205127 | 40.76727260000001 | -73.97152637 | 2020-08-13 04:29:15 | New York City, New York, US |
2020-08-11 | US | New York | New York City | 36061 | 228343 | 23592 | 0 | 204751 | 40.76727260000001 | -73.97152637 | 2020-08-12 04:27:29 | New York City, New York, US |
2020-08-10 | US | New York | New York City | 36061 | 228069 | 23586 | 0 | 204483 | 40.76727260000001 | -73.97152637 | 2020-08-11 04:35:08 | New York City, New York, US |
2020-08-09 | US | New York | New York City | 36061 | 227832 | 23580 | 0 | 204252 | 40.76727260000001 | -73.97152637 | 2020-08-10 04:34:55 | New York City, New York, US |
2020-08-08 | US | New York | New York City | 36061 | 227584 | 23575 | 0 | 204009 | 40.76727260000001 | -73.97152637 | 2020-08-09 04:34:54 | New York City, New York, US |
2020-08-07 | US | New York | New York City | 36061 | 227258 | 23567 | 0 | 203691 | 40.76727260000001 | -73.97152637 | 2020-08-08 04:34:53 | New York City, New York, US |
2020-08-06 | US | New York | New York City | 36061 | 226914 | 23563 | 0 | 203351 | 40.76727260000001 | -73.97152637 | 2020-08-07 04:35:11 | New York City, New York, US |
2020-08-05 | US | New York | New York City | 36061 | 226581 | 23563 | 0 | 203018 | 40.76727260000001 | -73.97152637 | 2020-08-06 04:35:02 | New York City, New York, US |
2020-08-04 | US | New York | New York City | 36061 | 226280 | 23556 | 0 | 202724 | 40.76727260000001 | -73.97152637 | 2020-08-05 04:34:43 | New York City, New York, US |
2020-08-03 | US | New York | New York City | 36061 | 225964 | 23550 | 0 | 202414 | 40.76727260000001 | -73.97152637 | 2020-08-04 04:41:59 | New York City, New York, US |
2020-08-02 | US | New York | New York City | 36061 | 225723 | 23541 | 0 | 202182 | 40.76727260000001 | -73.97152637 | 2020-08-03 04:34:35 | New York City, New York, US |
2020-08-01 | US | New York | New York City | 36061 | 225460 | 23536 | 0 | 201924 | 40.76727260000001 | -73.97152637 | 2020-08-02 04:34:47 | New York City, New York, US |
2020-07-31 | US | New York | New York City | 36061 | 225148 | 23531 | 0 | 201617 | 40.76727260000001 | -73.97152637 | 2020-08-01 04:36:27 | New York City, New York, US |
2020-07-30 | US | New York | New York City | 36061 | 224863 | 23525 | 0 | 201338 | 40.76727260000001 | -73.97152637 | 2020-07-31 04:35:18 | New York City, New York, US |
2020-07-29 | US | New York | New York City | 36061 | 224551 | 23512 | 0 | 201039 | 40.76727260000001 | -73.97152637 | 2020-07-30 04:35:05 | New York City, New York, US |
2020-07-28 | US | New York | New York City | 36061 | 224249 | 23507 | 0 | 200742 | 40.76727260000001 | -73.97152637 | 2020-07-29 04:35:11 | New York City, New York, US |
2020-07-27 | US | New York | New York City | 36061 | 224051 | 23500 | 0 | 200551 | 40.76727260000001 | -73.97152637 | 2020-07-28 04:58:43 | New York City, New York, US |
2020-07-26 | US | New York | New York City | 36061 | 223761 | 23485 | 0 | 200276 | 40.76727260000001 | -73.97152637 | 2020-07-27 04:35:02 | New York City, New York, US |
2020-07-25 | US | New York | New York City | 36061 | 223532 | 23476 | 0 | 200056 | 40.76727260000001 | -73.97152637 | 2020-07-26 04:35:00 | New York City, New York, US |
2020-07-24 | US | New York | New York City | 36061 | 223192 | 23465 | 0 | 199727 | 40.76727260000001 | -73.97152637 | 2020-07-25 04:47:39 | New York City, New York, US |
2020-07-23 | US | New York | New York City | 36061 | 222832 | 23463 | 0 | 199369 | 40.76727260000001 | -73.97152637 | 2020-07-24 05:30:40 | New York City, New York, US |
2020-07-22 | US | New York | New York City | 36061 | 222444 | 23428 | 0 | 199016 | 40.76727260000001 | -73.97152637 | 2020-07-23 05:15:04 | New York City, New York, US |
2020-07-21 | US | New York | New York City | 36061 | 222094 | 23424 | 0 | 198670 | 40.76727260000001 | -73.97152637 | 2020-07-22 04:34:42 | New York City, New York, US |
2020-07-20 | US | New York | New York City | 36061 | 221703 | 23411 | 0 | 198292 | 40.76727260000001 | -73.97152637 | 2020-07-21 04:38:46 | New York City, New York, US |
2020-07-19 | US | New York | New York City | 36061 | 221419 | 23400 | 0 | 198019 | 40.76727260000001 | -73.97152637 | 2020-07-20 05:34:40 | New York City, New York, US |
2020-07-18 | US | New York | New York City | 36061 | 221121 | 23388 | 0 | 197733 | 40.76727260000001 | -73.97152637 | 2020-07-19 04:34:58 | New York City, New York, US |
2020-07-17 | US | New York | New York City | 36061 | 220734 | 23377 | 0 | 197357 | 40.76727260000001 | -73.97152637 | 2020-07-18 04:34:45 | New York City, New York, US |
2020-07-16 | US | New York | New York City | 36061 | 220367 | 23371 | 0 | 196996 | 40.76727260000001 | -73.97152637 | 2020-07-17 04:34:50 | New York City, New York, US |
2020-07-15 | US | New York | New York City | 36061 | 219982 | 23353 | 0 | 196629 | 40.76727260000001 | -73.97152637 | 2020-07-16 04:44:59 | New York City, New York, US |
2020-07-14 | US | New York | New York City | 36061 | 219616 | 23336 | 0 | 196280 | 40.76727260000001 | -73.97152637 | 2020-07-15 04:34:39 | New York City, New York, US |
2020-07-13 | US | New York | New York City | 36061 | 219301 | 23323 | 0 | 195978 | 40.76727260000001 | -73.97152637 | 2020-07-14 04:34:46 | New York City, New York, US |
2020-07-12 | US | New York | New York City | 36061 | 219051 | 23283 | 0 | 195768 | 40.76727260000001 | -73.97152637 | 2020-07-13 04:43:04 | New York City, New York, US |
2020-07-11 | US | New York | New York City | 36061 | 218710 | 23278 | 0 | 195432 | 40.76727260000001 | -73.97152637 | 2020-07-12 04:34:30 | New York City, New York, US |
2020-07-10 | US | New York | New York City | 36061 | 218403 | 23267 | 0 | 195136 | 40.76727260000001 | -73.97152637 | 2020-07-11 04:34:26 | New York City, New York, US |
2020-07-09 | US | New York | New York City | 36061 | 218052 | 23247 | 0 | 194805 | 40.76727260000001 | -73.97152637 | 2020-07-10 04:34:24 | New York City, New York, US |
2020-07-08 | US | New York | New York City | 36061 | 217777 | 23224 | 0 | 194553 | 40.76727260000001 | -73.97152637 | 2020-07-09 04:34:23 | New York City, New York, US |
2020-07-07 | US | New York | New York City | 36061 | 217488 | 23218 | 0 | 194270 | 40.76727260000001 | -73.97152637 | 2020-07-08 05:33:48 | New York City, New York, US |
2020-07-06 | US | New York | New York City | 36061 | 217216 | 23201 | 0 | 194015 | 40.76727260000001 | -73.97152637 | 2020-07-07 04:34:00 | New York City, New York, US |
2020-07-05 | US | New York | New York City | 36061 | 216969 | 23190 | 0 | 193779 | 40.76727260000001 | -73.97152637 | 2020-07-06 04:33:57 | New York City, New York, US |
2020-07-04 | US | New York | New York City | 36061 | 216730 | 23159 | 0 | 193571 | 40.76727260000001 | -73.97152637 | 2020-07-05 04:33:46 | New York City, New York, US |
2020-07-03 | US | New York | New York City | 36061 | 216362 | 23140 | 0 | 193222 | 40.76727260000001 | -73.97152637 | 2020-07-04 04:33:51 | New York City, New York, US |
2020-07-02 | US | New York | New York City | 36061 | 215902 | 23123 | 0 | 192779 | 40.76727260000001 | -73.97152637 | 2020-07-03 04:33:54 | New York City, New York, US |
2020-07-01 | US | New York | New York City | 36061 | 215475 | 23104 | 0 | 192371 | 40.76727260000001 | -73.97152637 | 2020-07-02 04:33:46 | New York City, New York, US |
2020-06-30 | US | New York | New York City | 36061 | 215179 | 23096 | 0 | 192083 | 40.76727260000001 | -73.97152637 | 2020-07-01 04:33:52 | New York City, New York, US |
2020-06-28 | US | New York | New York City | 36061 | 214750 | 22470 | 0 | 192280 | 40.76727260000001 | -73.97152637 | 2020-06-29 04:33:44 | New York City, New York, US |
2020-06-29 | US | New York | New York City | 36061 | 214939 | 22470 | 0 | 192469 | 40.76727260000001 | -73.97152637 | 2020-06-29 15:33:52 | New York City, New York, US |
2020-06-27 | US | New York | New York City | 36061 | 214434 | 22441 | 0 | 191993 | 40.76727260000001 | -73.97152637 | 2020-06-28 04:34:04 | New York City, New York, US |
2020-06-26 | US | New York | New York City | 36061 | 214070 | 22421 | 0 | 191649 | 40.76727260000001 | -73.97152637 | 2020-06-27 04:33:35 | New York City, New York, US |
2020-06-25 | US | New York | New York City | 36061 | 213699 | 22384 | 0 | 191315 | 40.76727260000001 | -73.97152637 | 2020-06-26 04:33:43 | New York City, New York, US |
2020-06-24 | US | New York | New York City | 36061 | 213348 | 22365 | 0 | 190983 | 40.76727260000001 | -73.97152637 | 2020-06-25 05:26:54 | New York City, New York, US |
2020-06-23 | US | New York | New York City | 36061 | 213056 | 22343 | 0 | 190713 | 40.76727260000001 | -73.97152637 | 2020-06-24 04:33:28 | New York City, New York, US |
2020-06-22 | US | New York | New York City | 36061 | 212741 | 22321 | 0 | 190420 | 40.76727260000001 | -73.97152637 | 2020-06-23 04:33:22 | New York City, New York, US |
2020-06-21 | US | New York | New York City | 36061 | 212446 | 22278 | 0 | 190168 | 40.76727260000001 | -73.97152637 | 2020-06-22 04:33:20 | New York City, New York, US |
2020-06-20 | US | New York | New York City | 36061 | 212061 | 22244 | 0 | 189817 | 40.76727260000001 | -73.97152637 | 2020-06-21 04:33:19 | New York City, New York, US |
2020-06-19 | US | New York | New York City | 36061 | 211670 | 22236 | 0 | 189434 | 40.76727260000001 | -73.97152637 | 2020-06-20 04:33:19 | New York City, New York, US |
2020-06-18 | US | New York | New York City | 36061 | 211260 | 22199 | 0 | 189061 | 40.76727260000001 | -73.97152637 | 2020-06-19 04:33:17 | New York City, New York, US |
2020-06-17 | US | New York | New York City | 36061 | 210941 | 22171 | 0 | 188770 | 40.76727260000001 | -73.97152637 | 2020-06-18 04:33:18 | New York City, New York, US |
2020-06-16 | US | New York | New York City | 36061 | 210591 | 22145 | 0 | 188446 | 40.76727260000001 | -73.97152637 | 2020-06-17 04:33:21 | New York City, New York, US |
2020-06-15 | US | New York | New York City | 36061 | 210259 | 22124 | 0 | 188135 | 40.76727260000001 | -73.97152637 | 2020-06-16 04:33:09 | New York City, New York, US |
2020-06-14 | US | New York | New York City | 36061 | 209878 | 22103 | 0 | 187775 | 40.76727260000001 | -73.97152637 | 2020-06-15 03:33:14 | New York City, New York, US |
2020-06-13 | US | New York | New York City | 36061 | 209493 | 22076 | 0 | 187417 | 40.76727260000001 | -73.97152637 | 2020-06-14 03:33:15 | New York City, New York, US |
2020-06-12 | US | New York | New York City | 36061 | 208954 | 22043 | 0 | 186911 | 40.76727260000001 | -73.97152637 | 2020-06-13 03:33:14 | New York City, New York, US |
2020-06-11 | US | New York | New York City | 36061 | 208517 | 21993 | 0 | 186524 | 40.76727260000001 | -73.97152637 | 2020-06-12 05:09:52 | New York City, New York, US |
2020-06-10 | US | New York | New York City | 36061 | 208118 | 21960 | 0 | 186158 | 40.76727260000001 | -73.97152637 | 2020-06-11 03:33:41 | New York City, New York, US |
2020-06-09 | US | New York | New York City | 36061 | 207693 | 21918 | 0 | 185775 | 40.76727260000001 | -73.97152637 | 2020-06-10 04:07:00 | New York City, New York, US |
2020-06-08 | US | New York | New York City | 36061 | 207353 | 21877 | 0 | 185476 | 40.76727260000001 | -73.97152637 | 2020-06-09 03:33:03 | New York City, New York, US |
2020-06-07 | US | New York | New York City | 36061 | 206969 | 21844 | 0 | 185125 | 40.76727260000001 | -73.97152637 | 2020-06-08 03:33:22 | New York City, New York, US |
2020-06-06 | US | New York | New York City | 36061 | 206511 | 21815 | 0 | 184696 | 40.76727260000001 | -73.97152637 | 2020-06-07 03:53:30 | New York City, New York, US |
2020-06-05 | US | New York | New York City | 36061 | 205940 | 21782 | 0 | 184158 | 40.76727260000001 | -73.97152637 | 2020-06-06 02:33:00 | New York City, New York, US |
2020-06-04 | US | New York | New York City | 36061 | 205406 | 21752 | 0 | 183654 | 40.76727260000001 | -73.97152637 | 2020-06-05 02:33:06 | New York City, New York, US |
2020-06-03 | US | New York | New York City | 36061 | 204872 | 21688 | 0 | 183184 | 40.76727260000001 | -73.97152637 | 2020-06-04 02:33:14 | New York City, New York, US |
2020-06-02 | US | New York | New York City | 36061 | 204377 | 21649 | 0 | 182728 | 40.76727260000001 | -73.97152637 | 2020-06-03 02:33:13 | New York City, New York, US |
2020-06-01 | US | New York | New York City | 36061 | 203764 | 21607 | 0 | 182157 | 40.76727260000001 | -73.97152637 | 2020-06-02 02:33:08 | New York City, New York, US |
2020-05-31 | US | New York | New York City | 36061 | 203303 | 21569 | 0 | 181734 | 40.76727260000001 | -73.97152637 | 2020-06-01 02:32:46 | New York City, New York, US |
2020-05-30 | US | New York | New York City | 36061 | 202751 | 21512 | 0 | 181239 | 40.76727260000001 | -73.97152637 | 2020-05-31 02:32:45 | New York City, New York, US |
2020-05-29 | US | New York | New York City | 36061 | 201999 | 21477 | 0 | 180522 | 40.76727260000001 | -73.97152637 | 2020-05-30 02:32:48 | New York City, New York, US |
2020-05-28 | US | New York | New York City | 36061 | 201051 | 21415 | 0 | 179636 | 40.76727260000001 | -73.97152637 | 2020-05-29 02:32:50 | New York City, New York, US |
2020-05-27 | US | New York | New York City | 36061 | 199968 | 21362 | 0 | 178606 | 40.76727260000001 | -73.97152637 | 2020-05-28 02:32:31 | New York City, New York, US |
2020-05-26 | US | New York | New York City | 36061 | 199301 | 21314 | 0 | 177987 | 40.76727260000001 | -73.97152637 | 2020-05-27 02:32:31 | New York City, New York, US |
2020-05-25 | US | New York | New York City | 36061 | 198731 | 21259 | 0 | 177472 | 40.76727260000001 | -73.97152637 | 2020-05-26 02:32:35 | New York City, New York, US |
2020-05-24 | US | New York | New York City | 36061 | 198123 | 21216 | 0 | 176907 | 40.76727260000001 | -73.97152637 | 2020-05-25 02:32:44 | New York City, New York, US |
2020-05-23 | US | New York | New York City | 36061 | 197266 | 21138 | 0 | 176128 | 40.76727260000001 | -73.97152637 | 2020-05-24 02:32:43 | New York City, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;