johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
229 rows where confirmed = 2657 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2560069 | 2560069 | 2022-11-29 | US | West Virginia | Clay | 54015 | 2657 | 53 | 0 | 38.46231092 | -81.07652217 | 2022-11-30 04:21:07 | Clay, West Virginia, US | |
1243143 | 1243143 | 2022-11-28 | US | West Virginia | Clay | 54015 | 2657 | 53 | 0 | 38.46231092 | -81.07652217 | 2022-11-29 04:21:05 | Clay, West Virginia, US | |
3553442 | 3553442 | 2022-11-27 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-28 04:21:02 | Benton, Mississippi, US | |
2101922 | 2101922 | 2022-11-26 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-27 04:21:05 | Benton, Mississippi, US | |
489413 | 489413 | 2022-11-25 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-26 04:21:11 | Benton, Mississippi, US | |
3525242 | 3525242 | 2022-11-24 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-25 04:21:06 | Benton, Mississippi, US | |
3314025 | 3314025 | 2022-11-23 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-24 04:21:09 | Benton, Mississippi, US | |
1622066 | 1622066 | 2022-11-22 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-23 04:21:06 | Benton, Mississippi, US | |
3461954 | 3461954 | 2022-11-21 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-22 04:20:47 | Benton, Mississippi, US | |
1642139 | 1642139 | 2022-11-20 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-21 04:21:05 | Benton, Mississippi, US | |
2065696 | 2065696 | 2022-11-19 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-20 04:21:08 | Benton, Mississippi, US | |
1757090 | 1757090 | 2022-11-18 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-19 04:21:14 | Benton, Mississippi, US | |
3028083 | 3028083 | 2022-11-17 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-18 04:21:15 | Benton, Mississippi, US | |
2487794 | 2487794 | 2022-11-16 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-17 04:21:11 | Benton, Mississippi, US | |
293805 | 293805 | 2022-11-15 | US | Mississippi | Benton | 28009 | 2657 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-16 04:21:09 | Benton, Mississippi, US | |
2020110 | 2020110 | 2022-09-20 | US | Virginia | Northampton | 51131 | 2657 | 70 | 0 | 37.34062933 | -75.87751591 | 2022-09-21 04:23:22 | Northampton, Virginia, US | |
2017648 | 2017648 | 2022-09-20 | US | Idaho | Benewah | 16009 | 2657 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-09-21 04:23:22 | Benewah, Idaho, US | |
3571521 | 3571521 | 2022-09-19 | US | Idaho | Benewah | 16009 | 2657 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-09-20 04:22:48 | Benewah, Idaho, US | |
3430044 | 3430044 | 2022-07-14 | US | Indiana | Crawford | 18025 | 2657 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-07-15 04:20:53 | Crawford, Indiana, US | |
3110564 | 3110564 | 2022-07-13 | US | Indiana | Crawford | 18025 | 2657 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-07-14 04:20:57 | Crawford, Indiana, US | |
3079547 | 3079547 | 2022-07-04 | US | Kentucky | Wolfe | 21237 | 2657 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-05 04:20:45 | Wolfe, Kentucky, US | |
3078666 | 3078666 | 2022-07-04 | US | Colorado | Bent | 8011 | 2657 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-07-05 04:20:45 | Bent, Colorado, US | |
1768829 | 1768829 | 2022-07-03 | US | Kentucky | Wolfe | 21237 | 2657 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-04 04:20:54 | Wolfe, Kentucky, US | |
3366815 | 3366815 | 2022-07-02 | US | Kentucky | Wolfe | 21237 | 2657 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-03 04:20:59 | Wolfe, Kentucky, US | |
3366002 | 3366002 | 2022-07-02 | US | Connecticut | Unassigned | 90009 | 2657 | 2 | 0 | 41.85853803 | 0.0 | 2022-07-03 04:20:59 | Unassigned, Connecticut, US | |
595144 | 595144 | 2022-07-01 | US | Kentucky | Wolfe | 21237 | 2657 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-02 04:21:16 | Wolfe, Kentucky, US | |
3941545 | 3941545 | 2022-06-30 | US | Kentucky | Wolfe | 21237 | 2657 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-01 04:21:10 | Wolfe, Kentucky, US | |
2491503 | 2491503 | 2022-06-29 | US | Kentucky | Wolfe | 21237 | 2657 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-06-30 04:21:01 | Wolfe, Kentucky, US | |
2240885 | 2240885 | 2022-06-28 | US | Kentucky | Wolfe | 21237 | 2657 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-06-29 04:20:59 | Wolfe, Kentucky, US | |
2149127 | 2149127 | 2022-06-27 | US | Kentucky | Wolfe | 21237 | 2657 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-06-28 04:20:58 | Wolfe, Kentucky, US | |
2190663 | 2190663 | 2022-06-22 | US | Texas | Childress | 48075 | 2657 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-06-23 04:20:55 | Childress, Texas, US | |
3158024 | 3158024 | 2022-06-09 | US | Alabama | Lowndes | 1085 | 2657 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-06-10 04:20:55 | Lowndes, Alabama, US | |
3889646 | 3889646 | 2022-06-06 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-06-07 04:21:08 | Richland, Montana, US | |
3509415 | 3509415 | 2022-06-05 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-06-06 04:20:57 | Richland, Montana, US | |
3529492 | 3529492 | 2022-06-04 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-06-05 04:20:55 | Richland, Montana, US | |
3135578 | 3135578 | 2022-06-03 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-06-04 04:20:58 | Richland, Montana, US | |
3580653 | 3580653 | 2022-06-02 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-06-03 04:20:58 | Richland, Montana, US | |
972946 | 972946 | 2022-06-01 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-06-02 05:20:39 | Richland, Montana, US | |
231253 | 231253 | 2022-05-31 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-06-01 04:20:55 | Richland, Montana, US | |
3188018 | 3188018 | 2022-05-30 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-05-31 04:20:51 | Richland, Montana, US | |
3200167 | 3200167 | 2022-05-29 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-05-30 04:20:50 | Richland, Montana, US | |
2727045 | 2727045 | 2022-05-28 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-05-29 04:20:53 | Richland, Montana, US | |
1316226 | 1316226 | 2022-05-27 | US | Montana | Richland | 30083 | 2657 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-05-28 04:21:07 | Richland, Montana, US | |
3268798 | 3268798 | 2022-05-04 | US | Virginia | Amelia | 51007 | 2657 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-05-05 04:20:55 | Amelia, Virginia, US | |
3733001 | 3733001 | 2022-04-03 | US | Puerto Rico | Orocovis | 72107 | 2657 | 0 | 0 | 18.215046 | -66.433604 | 2022-04-04 04:20:51 | Orocovis, Puerto Rico, US | |
1543337 | 1543337 | 2022-03-31 | US | Virginia | Nelson | 51125 | 2657 | 32 | 0 | 37.78790447 | -78.88498513 | 2022-04-01 04:20:28 | Nelson, Virginia, US | |
921901 | 921901 | 2022-03-08 | US | New Mexico | Torrance | 35057 | 2657 | 51 | 0 | 34.64048375 | -105.8508949 | 2022-03-09 04:20:59 | Torrance, New Mexico, US | |
577788 | 577788 | 2022-02-25 | US | Tennessee | Houston | 47083 | 2657 | 59 | 0 | 36.28872054 | -87.71878828 | 2022-02-26 04:21:12 | Houston, Tennessee, US | |
3913284 | 3913284 | 2022-02-20 | US | Kansas | Brown | 20013 | 2657 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-21 04:21:05 | Brown, Kansas, US | |
3876842 | 3876842 | 2022-02-19 | US | Kansas | Brown | 20013 | 2657 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-20 04:21:00 | Brown, Kansas, US | |
3857098 | 3857098 | 2022-02-18 | US | Kansas | Brown | 20013 | 2657 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-19 04:21:11 | Brown, Kansas, US | |
2476763 | 2476763 | 2022-02-03 | US | South Carolina | Calhoun | 45017 | 2657 | 54 | 0 | 33.66926881 | -80.77722168 | 2022-02-04 04:21:10 | Calhoun, South Carolina, US | |
2473748 | 2473748 | 2022-02-03 | China | Henan | 2657 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-02-04 04:21:10 | Henan, China | |||
459173 | 459173 | 2022-02-02 | China | Henan | 2657 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-02-03 04:21:21 | Henan, China | |||
2658261 | 2658261 | 2022-01-31 | US | Arkansas | Chicot | 5017 | 2657 | 50 | 0 | 33.26458973 | -91.29539209 | 2022-02-01 04:21:11 | Chicot, Arkansas, US | |
3301519 | 3301519 | 2022-01-30 | US | Kansas | Linn | 20107 | 2657 | 24 | 0 | 38.21267844 | -94.84254089 | 2022-01-31 04:21:09 | Linn, Kansas, US | |
3300978 | 3300978 | 2022-01-30 | US | Georgia | Charlton | 13049 | 2657 | 58 | 0 | 30.78371028 | -82.13951596 | 2022-01-31 04:21:09 | Charlton, Georgia, US | |
3063310 | 3063310 | 2022-01-29 | US | Kansas | Linn | 20107 | 2657 | 24 | 0 | 38.21267844 | -94.84254089 | 2022-01-30 04:21:26 | Linn, Kansas, US | |
3062769 | 3062769 | 2022-01-29 | US | Georgia | Charlton | 13049 | 2657 | 58 | 0 | 30.78371028 | -82.13951596 | 2022-01-30 04:21:26 | Charlton, Georgia, US | |
3062410 | 3062410 | 2022-01-29 | US | Alabama | Wilcox | 1131 | 2657 | 38 | 0 | 31.98773215 | -87.30891118 | 2022-01-30 04:21:26 | Wilcox, Alabama, US | |
3811244 | 3811244 | 2022-01-28 | US | Kansas | Linn | 20107 | 2657 | 24 | 0 | 38.21267844 | -94.84254089 | 2022-01-29 04:21:10 | Linn, Kansas, US | |
3810703 | 3810703 | 2022-01-28 | US | Georgia | Charlton | 13049 | 2657 | 58 | 0 | 30.78371028 | -82.13951596 | 2022-01-29 04:21:10 | Charlton, Georgia, US | |
1781909 | 1781909 | 2022-01-27 | US | Ohio | Vinton | 39163 | 2657 | 52 | 0 | 39.25208988 | -82.4831444 | 2022-01-28 04:21:09 | Vinton, Ohio, US | |
1780828 | 1780828 | 2022-01-27 | US | Kentucky | Martin | 21159 | 2657 | 44 | 0 | 37.79990579 | -82.51247478 | 2022-01-28 04:21:09 | Martin, Kentucky, US | |
1228554 | 1228554 | 2022-01-24 | US | Idaho | Idaho | 16049 | 2657 | 43 | 0 | 45.84721541 | -115.4634436 | 2022-01-25 04:21:05 | Idaho, Idaho, US | |
3424780 | 3424780 | 2022-01-21 | Colombia | Guainia | 2657 | 35 | 0 | 2.5854 | -68.5247 | 2022-01-22 04:21:13 | Guainia, Colombia | |||
1961057 | 1961057 | 2022-01-20 | US | Arkansas | Lee | 5077 | 2657 | 54 | 0 | 34.78498904 | -90.78383866 | 2022-01-21 04:21:09 | Lee, Arkansas, US | |
3689954 | 3689954 | 2022-01-13 | US | Ohio | Harrison | 39067 | 2657 | 66 | 0 | 40.29380509 | -81.09068544 | 2022-01-14 04:21:54 | Harrison, Ohio, US | |
130144 | 130144 | 2022-01-09 | US | Virginia | Southampton | 51175 | 2657 | 74 | 0 | 36.72231125 | -77.10642712 | 2022-01-10 04:22:07 | Southampton, Virginia, US | |
1218979 | 1218979 | 2022-01-08 | US | Virginia | Southampton | 51175 | 2657 | 74 | 0 | 36.72231125 | -77.10642712 | 2022-01-09 04:21:46 | Southampton, Virginia, US | |
1393072 | 1393072 | 2022-01-07 | US | Virginia | Southampton | 51175 | 2657 | 74 | 0 | 36.72231125 | -77.10642712 | 2022-01-08 04:21:53 | Southampton, Virginia, US | |
2612406 | 2612406 | 2022-01-06 | US | North Carolina | Polk | 37149 | 2657 | 49 | 0 | 35.27820615 | -82.16812354 | 2022-01-07 04:22:09 | Polk, North Carolina, US | |
1289350 | 1289350 | 2022-01-04 | US | Virginia | Giles | 51071 | 2657 | 38 | 0 | 37.31234791 | -80.70636931 | 2022-01-05 04:21:59 | Giles, Virginia, US | |
1702278 | 1702278 | 2022-01-03 | US | Missouri | Madison | 29123 | 2657 | 41 | 0 | 37.47865134 | -90.34671429999999 | 2022-01-04 04:22:17 | Madison, Missouri, US | |
3521361 | 3521361 | 2022-01-02 | US | Missouri | Madison | 29123 | 2657 | 41 | 0 | 37.47865134 | -90.34671429999999 | 2022-01-03 02:22:25 | Madison, Missouri, US | |
2169491 | 2169491 | 2022-01-01 | US | Missouri | Madison | 29123 | 2657 | 41 | 0 | 37.47865134 | -90.34671429999999 | 2022-01-02 04:20:52 | Madison, Missouri, US | |
2778922 | 2778922 | 2021-12-31 | US | Missouri | Madison | 29123 | 2657 | 41 | 0 | 37.47865134 | -90.34671429999999 | 2022-01-01 04:22:14 | Madison, Missouri, US | |
4000579 | 4000579 | 2021-12-30 | US | Missouri | Madison | 29123 | 2657 | 41 | 0 | 37.47865134 | -90.34671429999999 | 2021-12-31 04:21:50 | Madison, Missouri, US | |
1670869 | 1670869 | 2021-12-29 | US | North Dakota | McKenzie | 38053 | 2657 | 23 | 0 | 47.74133370000001 | -103.395905 | 2021-12-30 04:21:25 | McKenzie, North Dakota, US | |
1254481 | 1254481 | 2021-12-20 | Bhutan | 2657 | 3 | 0 | 27.5142 | 90.4336 | 2021-12-21 03:21:27 | Bhutan | ||||
2906730 | 2906730 | 2021-12-19 | US | Texas | Aransas | 48007 | 2657 | 67 | 0 | 28.10556197 | -96.9995047 | 2021-12-20 04:21:43 | Aransas, Texas, US | |
2903424 | 2903424 | 2021-12-19 | Bhutan | 2657 | 3 | 0 | 27.5142 | 90.4336 | 2021-12-20 04:21:43 | Bhutan | ||||
1661175 | 1661175 | 2021-12-12 | US | Georgia | Bacon | 13005 | 2657 | 64 | 0 | 31.55456473 | -82.45936528 | 2021-12-13 04:22:02 | Bacon, Georgia, US | |
1665191 | 1665191 | 2021-12-11 | US | Georgia | Bacon | 13005 | 2657 | 64 | 0 | 31.55456473 | -82.45936528 | 2021-12-12 04:22:12 | Bacon, Georgia, US | |
3656343 | 3656343 | 2021-12-10 | US | Georgia | Bacon | 13005 | 2657 | 64 | 0 | 31.55456473 | -82.45936528 | 2021-12-11 04:22:45 | Bacon, Georgia, US | |
407809 | 407809 | 2021-12-07 | US | West Virginia | Taylor | 54091 | 2657 | 46 | 0 | 39.33602617 | -80.0421439 | 2021-12-08 04:22:46 | Taylor, West Virginia, US | |
407349 | 407349 | 2021-12-07 | US | Texas | Colorado | 48089 | 2657 | 55 | 0 | 29.622097999999998 | -96.5273805 | 2021-12-08 04:22:46 | Colorado, Texas, US | |
1031242 | 1031242 | 2021-12-06 | US | Georgia | Rabun | 13241 | 2657 | 76 | 0 | 34.88389445 | -83.40304637 | 2021-12-07 04:22:34 | Rabun, Georgia, US | |
1742090 | 1742090 | 2021-12-05 | US | Louisiana | Winn | 22127 | 2657 | 58 | 0 | 31.94449367 | -92.63789413 | 2021-12-06 04:22:34 | Winn, Louisiana, US | |
139522 | 139522 | 2021-12-04 | US | Louisiana | Winn | 22127 | 2657 | 58 | 0 | 31.94449367 | -92.63789413 | 2021-12-05 04:22:25 | Winn, Louisiana, US | |
2197175 | 2197175 | 2021-12-03 | US | Louisiana | Winn | 22127 | 2657 | 58 | 0 | 31.94449367 | -92.63789413 | 2021-12-04 04:22:18 | Winn, Louisiana, US | |
1881 | 1881 | 2021-12-02 | US | Louisiana | Winn | 22127 | 2657 | 58 | 0 | 31.94449367 | -92.63789413 | 2021-12-03 04:23:05 | Winn, Louisiana, US | |
1146480 | 1146480 | 2021-12-01 | US | Louisiana | Winn | 22127 | 2657 | 58 | 0 | 31.94449367 | -92.63789413 | 2021-12-02 04:22:37 | Winn, Louisiana, US | |
3752512 | 3752512 | 2021-11-22 | US | Virginia | Nottoway | 51135 | 2657 | 70 | 0 | 37.1435975 | -78.05065922 | 2021-11-23 04:22:39 | Nottoway, Virginia, US | |
700828 | 700828 | 2021-11-04 | US | North Dakota | Richland | 38077 | 2657 | 20 | 0 | 46.26440649 | -96.94852979 | 2021-11-05 04:21:54 | Richland, North Dakota, US | |
277570 | 277570 | 2021-11-03 | US | Kentucky | Casey | 21045 | 2657 | 53 | 0 | 37.32533118 | -84.92726209 | 2021-11-04 04:22:20 | Casey, Kentucky, US | |
277156 | 277156 | 2021-11-03 | US | Illinois | Clay | 17025 | 2657 | 54 | 0 | 38.75388572 | -88.48914513 | 2021-11-04 04:22:20 | Clay, Illinois, US | |
3513614 | 3513614 | 2021-11-01 | US | New Mexico | San Miguel | 35047 | 2657 | 26 | 0 | 35.48014807 | -104.8163562 | 2021-11-02 04:22:03 | San Miguel, New Mexico, US | |
3512316 | 3512316 | 2021-11-01 | US | Hawaii | Kauai | 15007 | 2657 | 9 | 0 | 22.03935037 | -159.5966786 | 2021-11-02 04:22:03 | Kauai, Hawaii, US | |
568522 | 568522 | 2021-10-29 | US | Kentucky | Jackson | 21109 | 2657 | 50 | 0 | 37.41866422 | -83.99825483 | 2021-10-30 04:22:03 | Jackson, Kentucky, 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]);