johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
259 rows where confirmed = 2577 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453119 | 453119 | 2022-12-21 | US | Minnesota | Jackson | 27063 | 2577 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-22 04:20:56 | Jackson, Minnesota, US | |
2954276 | 2954276 | 2022-12-20 | US | South Dakota | Lake | 46079 | 2577 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-12-21 04:21:03 | Lake, South Dakota, US | |
2953118 | 2953118 | 2022-12-20 | US | Minnesota | Jackson | 27063 | 2577 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-21 04:21:03 | Jackson, Minnesota, US | |
3176678 | 3176678 | 2022-12-19 | US | South Dakota | Lake | 46079 | 2577 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-12-20 04:21:04 | Lake, South Dakota, US | |
3175520 | 3175520 | 2022-12-19 | US | Minnesota | Jackson | 27063 | 2577 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-20 04:21:04 | Jackson, Minnesota, US | |
1631195 | 1631195 | 2022-12-18 | US | South Dakota | Lake | 46079 | 2577 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-12-19 04:21:03 | Lake, South Dakota, US | |
1630037 | 1630037 | 2022-12-18 | US | Minnesota | Jackson | 27063 | 2577 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-19 04:21:03 | Jackson, Minnesota, US | |
506574 | 506574 | 2022-12-17 | US | South Dakota | Lake | 46079 | 2577 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-12-18 04:21:03 | Lake, South Dakota, US | |
505416 | 505416 | 2022-12-17 | US | Minnesota | Jackson | 27063 | 2577 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-18 04:21:03 | Jackson, Minnesota, US | |
3327146 | 3327146 | 2022-12-16 | US | South Dakota | Lake | 46079 | 2577 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-12-17 04:21:04 | Lake, South Dakota, US | |
3325988 | 3325988 | 2022-12-16 | US | Minnesota | Jackson | 27063 | 2577 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-17 04:21:04 | Jackson, Minnesota, US | |
545658 | 545658 | 2022-12-15 | US | South Dakota | Lake | 46079 | 2577 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-12-16 04:21:01 | Lake, South Dakota, US | |
544500 | 544500 | 2022-12-15 | US | Minnesota | Jackson | 27063 | 2577 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-16 04:21:01 | Jackson, Minnesota, US | |
351186 | 351186 | 2022-12-14 | US | South Dakota | Lake | 46079 | 2577 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-12-15 04:20:58 | Lake, South Dakota, US | |
833441 | 833441 | 2022-12-02 | China | Xinjiang | 2577 | 3 | 0 | 41.1129 | 85.2401 | 2022-12-03 04:21:02 | Xinjiang, China | |||
3312043 | 3312043 | 2022-11-23 | China | Tianjin | 2577 | 3 | 0 | 39.3054 | 117.323 | 2022-11-24 04:21:09 | Tianjin, China | |||
1641806 | 1641806 | 2022-11-20 | US | Kentucky | Nicholas | 21181 | 2577 | 34 | 0 | 38.33342292 | -84.01889177 | 2022-11-21 04:21:05 | Nicholas, Kentucky, US | |
2065363 | 2065363 | 2022-11-19 | US | Kentucky | Nicholas | 21181 | 2577 | 34 | 0 | 38.33342292 | -84.01889177 | 2022-11-20 04:21:08 | Nicholas, Kentucky, US | |
1756757 | 1756757 | 2022-11-18 | US | Kentucky | Nicholas | 21181 | 2577 | 34 | 0 | 38.33342292 | -84.01889177 | 2022-11-19 04:21:14 | Nicholas, Kentucky, US | |
3027750 | 3027750 | 2022-11-17 | US | Kentucky | Nicholas | 21181 | 2577 | 34 | 0 | 38.33342292 | -84.01889177 | 2022-11-18 04:21:15 | Nicholas, Kentucky, US | |
2487461 | 2487461 | 2022-11-16 | US | Kentucky | Nicholas | 21181 | 2577 | 34 | 0 | 38.33342292 | -84.01889177 | 2022-11-17 04:21:11 | Nicholas, Kentucky, US | |
293472 | 293472 | 2022-11-15 | US | Kentucky | Nicholas | 21181 | 2577 | 34 | 0 | 38.33342292 | -84.01889177 | 2022-11-16 04:21:09 | Nicholas, Kentucky, US | |
3598502 | 3598502 | 2022-11-14 | US | Kentucky | Nicholas | 21181 | 2577 | 34 | 0 | 38.33342292 | -84.01889177 | 2022-11-15 04:21:16 | Nicholas, Kentucky, US | |
2506538 | 2506538 | 2022-11-10 | US | Arkansas | Cleveland | 5025 | 2577 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-11 04:21:22 | Cleveland, Arkansas, US | |
2431413 | 2431413 | 2022-11-09 | US | Arkansas | Cleveland | 5025 | 2577 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-10 04:21:16 | Cleveland, Arkansas, US | |
480069 | 480069 | 2022-11-08 | US | Arkansas | Cleveland | 5025 | 2577 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-09 04:21:22 | Cleveland, Arkansas, US | |
2439219 | 2439219 | 2022-11-07 | US | Arkansas | Cleveland | 5025 | 2577 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-08 04:21:21 | Cleveland, Arkansas, US | |
1050317 | 1050317 | 2022-11-06 | US | Arkansas | Cleveland | 5025 | 2577 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-07 04:21:26 | Cleveland, Arkansas, US | |
618341 | 618341 | 2022-11-05 | US | Arkansas | Cleveland | 5025 | 2577 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-06 04:21:24 | Cleveland, Arkansas, US | |
1022845 | 1022845 | 2022-11-04 | US | Arkansas | Cleveland | 5025 | 2577 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-05 04:21:52 | Cleveland, Arkansas, US | |
431836 | 431836 | 2022-11-03 | US | Arkansas | Cleveland | 5025 | 2577 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-04 04:22:11 | Cleveland, Arkansas, US | |
1833353 | 1833353 | 2022-10-25 | US | Texas | Parmer | 48369 | 2577 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-10-26 04:22:19 | Parmer, Texas, US | |
797614 | 797614 | 2022-10-24 | US | Texas | Parmer | 48369 | 2577 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-10-25 04:21:53 | Parmer, Texas, US | |
3253129 | 3253129 | 2022-10-11 | US | Tennessee | Moore | 47127 | 2577 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-12 04:22:51 | Moore, Tennessee, US | |
2532726 | 2532726 | 2022-10-06 | US | Virginia | Franklin City | 51620 | 2577 | 55 | 0 | 36.6831435 | -76.93859681 | 2022-10-07 04:23:08 | Franklin City, Virginia, US | |
134094 | 134094 | 2022-10-04 | US | Virginia | Franklin City | 51620 | 2577 | 55 | 0 | 36.6831435 | -76.93859681 | 2022-10-05 04:23:06 | Franklin City, Virginia, US | |
2689041 | 2689041 | 2022-10-03 | US | Virginia | Franklin City | 51620 | 2577 | 55 | 0 | 36.6831435 | -76.93859681 | 2022-10-04 04:22:55 | Franklin City, Virginia, US | |
2020060 | 2020060 | 2022-09-20 | US | Virginia | Essex | 51057 | 2577 | 37 | 0 | 37.93357639 | -76.94230311 | 2022-09-21 04:23:22 | Essex, Virginia, US | |
3573933 | 3573933 | 2022-09-19 | US | Virginia | Essex | 51057 | 2577 | 37 | 0 | 37.93357639 | -76.94230311 | 2022-09-20 04:22:48 | Essex, Virginia, US | |
256360 | 256360 | 2022-09-08 | US | Texas | Castro | 48069 | 2577 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-09-09 04:21:11 | Castro, Texas, US | |
3748158 | 3748158 | 2022-09-07 | US | Texas | Castro | 48069 | 2577 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-09-08 04:21:02 | Castro, Texas, US | |
3776229 | 3776229 | 2022-08-30 | US | North Carolina | Graham | 37075 | 2577 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-08-31 04:20:57 | Graham, North Carolina, US | |
1682825 | 1682825 | 2022-08-29 | US | North Carolina | Graham | 37075 | 2577 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-08-30 04:21:03 | Graham, North Carolina, US | |
1879309 | 1879309 | 2022-08-28 | US | North Carolina | Graham | 37075 | 2577 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-08-29 04:21:06 | Graham, North Carolina, US | |
2098436 | 2098436 | 2022-08-27 | US | North Carolina | Graham | 37075 | 2577 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-08-28 04:21:02 | Graham, North Carolina, US | |
1534251 | 1534251 | 2022-08-26 | US | North Carolina | Graham | 37075 | 2577 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-08-27 04:20:57 | Graham, North Carolina, US | |
2831138 | 2831138 | 2022-08-25 | US | North Carolina | Graham | 37075 | 2577 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-08-26 04:21:02 | Graham, North Carolina, US | |
2326332 | 2326332 | 2022-08-24 | US | Tennessee | Perry | 47135 | 2577 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-08-25 04:21:13 | Perry, Tennessee, US | |
2325671 | 2325671 | 2022-08-24 | US | North Carolina | Graham | 37075 | 2577 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-08-25 04:21:13 | Graham, North Carolina, US | |
1253969 | 1253969 | 2022-08-23 | US | Texas | Runnels | 48399 | 2577 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-08-24 04:20:46 | Runnels, Texas, US | |
2009613 | 2009613 | 2022-08-04 | US | Idaho | Benewah | 16009 | 2577 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-08-05 04:20:52 | Benewah, Idaho, US | |
1099040 | 1099040 | 2022-08-03 | US | Idaho | Benewah | 16009 | 2577 | 41 | 0 | 47.21754179 | -116.6586851 | 2022-08-04 04:20:58 | Benewah, Idaho, US | |
1214971 | 1214971 | 2022-07-11 | US | Virginia | Sussex | 51183 | 2577 | 43 | 0 | 36.92432914 | -77.25791182 | 2022-07-12 04:20:51 | Sussex, Virginia, US | |
2242856 | 2242856 | 2022-06-28 | US | Washington | Pend Oreille | 53051 | 2577 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-29 04:20:59 | Pend Oreille, Washington, US | |
2151098 | 2151098 | 2022-06-27 | US | Washington | Pend Oreille | 53051 | 2577 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-28 04:20:58 | Pend Oreille, Washington, US | |
478814 | 478814 | 2022-06-26 | US | Virginia | Madison | 51113 | 2577 | 42 | 0 | 38.41531222 | -78.28220331 | 2022-06-27 04:21:00 | Madison, Virginia, US | |
942189 | 942189 | 2022-06-25 | US | Virginia | Madison | 51113 | 2577 | 42 | 0 | 38.41531222 | -78.28220331 | 2022-06-26 04:21:02 | Madison, Virginia, US | |
3350009 | 3350009 | 2022-06-24 | US | Virginia | Madison | 51113 | 2577 | 42 | 0 | 38.41531222 | -78.28220331 | 2022-06-25 04:20:57 | Madison, Virginia, US | |
3347153 | 3347153 | 2022-06-24 | US | Arkansas | Perry | 5105 | 2577 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-06-25 04:20:57 | Perry, Arkansas, US | |
3579705 | 3579705 | 2022-06-02 | US | Indiana | Crawford | 18025 | 2577 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-06-03 04:20:58 | Crawford, Indiana, US | |
971998 | 971998 | 2022-06-01 | US | Indiana | Crawford | 18025 | 2577 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-06-02 05:20:39 | Crawford, Indiana, US | |
1172226 | 1172226 | 2022-05-20 | US | Texas | Blanco | 48031 | 2577 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-05-21 04:20:58 | Blanco, Texas, US | |
1171613 | 1171613 | 2022-05-20 | US | North Dakota | Mercer | 38057 | 2577 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-05-21 04:20:58 | Mercer, North Dakota, US | |
3268898 | 3268898 | 2022-05-04 | US | Virginia | Richmond | 51159 | 2577 | 25 | 0 | 37.937575 | -76.72920628 | 2022-05-05 04:20:55 | Richmond, Virginia, US | |
1573257 | 1573257 | 2022-05-03 | US | Indiana | Newton | 18111 | 2577 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-05-04 04:20:59 | Newton, Indiana, US | |
464517 | 464517 | 2022-05-02 | US | Indiana | Newton | 18111 | 2577 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-05-03 04:21:00 | Newton, Indiana, US | |
3917156 | 3917156 | 2022-05-01 | US | Indiana | Newton | 18111 | 2577 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-05-02 04:21:10 | Newton, Indiana, US | |
2841960 | 2841960 | 2022-04-30 | US | Indiana | Newton | 18111 | 2577 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-05-01 04:20:57 | Newton, Indiana, US | |
1158273 | 1158273 | 2022-04-29 | US | Indiana | Newton | 18111 | 2577 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-04-30 04:21:05 | Newton, Indiana, US | |
1699088 | 1699088 | 2022-04-28 | US | Puerto Rico | Lajas | 72079 | 2577 | 0 | 0 | 18.011661 | -67.040585 | 2022-04-29 04:20:59 | Lajas, Puerto Rico, US | |
1697455 | 1697455 | 2022-04-28 | US | Indiana | Newton | 18111 | 2577 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-04-29 04:20:59 | Newton, Indiana, US | |
3852938 | 3852938 | 2022-04-27 | US | Indiana | Newton | 18111 | 2577 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-04-28 04:20:47 | Newton, Indiana, US | |
1543559 | 1543559 | 2022-03-31 | US | Wyoming | Big Horn | 56003 | 2577 | 60 | 0 | 44.52405055 | -107.9960365 | 2022-04-01 04:20:28 | Big Horn, Wyoming, US | |
2481572 | 2481572 | 2022-03-30 | US | Wyoming | Big Horn | 56003 | 2577 | 60 | 0 | 44.52405055 | -107.9960365 | 2022-03-31 04:20:56 | Big Horn, Wyoming, US | |
161613 | 161613 | 2022-03-29 | US | Wyoming | Big Horn | 56003 | 2577 | 60 | 0 | 44.52405055 | -107.9960365 | 2022-03-30 04:20:45 | Big Horn, Wyoming, US | |
1868214 | 1868214 | 2022-03-10 | US | Puerto Rico | Comerio | 72045 | 2577 | 0 | 0 | 18.224687 | -66.221622 | 2022-03-11 04:20:50 | Comerio, Puerto Rico, US | |
2202941 | 2202941 | 2022-03-06 | US | Virginia | Amelia | 51007 | 2577 | 58 | 0 | 37.34081025 | -77.98584649 | 2022-03-07 04:20:47 | Amelia, Virginia, US | |
2095398 | 2095398 | 2022-03-05 | US | Virginia | Amelia | 51007 | 2577 | 58 | 0 | 37.34081025 | -77.98584649 | 2022-03-06 04:20:49 | Amelia, Virginia, US | |
2669098 | 2669098 | 2022-03-04 | US | Virginia | Amelia | 51007 | 2577 | 58 | 0 | 37.34081025 | -77.98584649 | 2022-03-05 04:21:10 | Amelia, Virginia, US | |
2734096 | 2734096 | 2022-02-27 | US | Indiana | Brown | 18013 | 2577 | 60 | 0 | 39.19605589 | -86.22868909 | 2022-02-28 04:21:05 | Brown, Indiana, US | |
3047249 | 3047249 | 2022-02-26 | US | Indiana | Brown | 18013 | 2577 | 60 | 0 | 39.19605589 | -86.22868909 | 2022-02-27 04:21:04 | Brown, Indiana, US | |
575904 | 575904 | 2022-02-25 | US | Indiana | Brown | 18013 | 2577 | 60 | 0 | 39.19605589 | -86.22868909 | 2022-02-26 04:21:12 | Brown, Indiana, US | |
1512480 | 1512480 | 2022-02-24 | US | Indiana | Brown | 18013 | 2577 | 60 | 0 | 39.19605589 | -86.22868909 | 2022-02-25 04:21:11 | Brown, Indiana, US | |
3074432 | 3074432 | 2022-02-09 | US | Alabama | Lowndes | 1085 | 2577 | 69 | 0 | 32.1597283 | -86.65158371 | 2022-02-10 04:21:14 | Lowndes, Alabama, US | |
1141584 | 1141584 | 2022-01-23 | US | Connecticut | Unassigned | 90009 | 2577 | 12 | 0 | 41.85853803 | 0.0 | 2022-01-24 04:21:12 | Unassigned, Connecticut, US | |
2833502 | 2833502 | 2022-01-22 | US | Connecticut | Unassigned | 90009 | 2577 | 12 | 0 | 41.85853803 | 0.0 | 2022-01-23 04:21:13 | Unassigned, Connecticut, US | |
3425620 | 3425620 | 2022-01-21 | US | Connecticut | Unassigned | 90009 | 2577 | 12 | 0 | 41.85853803 | 0.0 | 2022-01-22 04:21:13 | Unassigned, Connecticut, US | |
1694319 | 1694319 | 2022-01-10 | US | Montana | Glacier | 30035 | 2577 | 63 | 0 | 48.70513576 | -112.9934235 | 2022-01-11 04:22:01 | Glacier, Montana, US | |
3520424 | 3520424 | 2022-01-02 | US | Illinois | Greene | 17061 | 2577 | 40 | 0 | 39.35907414 | -90.388865 | 2022-01-03 02:22:25 | Greene, Illinois, US | |
2168554 | 2168554 | 2022-01-01 | US | Illinois | Greene | 17061 | 2577 | 40 | 0 | 39.35907414 | -90.388865 | 2022-01-02 04:20:52 | Greene, Illinois, US | |
2777985 | 2777985 | 2021-12-31 | US | Illinois | Greene | 17061 | 2577 | 40 | 0 | 39.35907414 | -90.388865 | 2022-01-01 04:22:14 | Greene, Illinois, US | |
3999642 | 3999642 | 2021-12-30 | US | Illinois | Greene | 17061 | 2577 | 40 | 0 | 39.35907414 | -90.388865 | 2021-12-31 04:21:50 | Greene, Illinois, US | |
3605453 | 3605453 | 2021-12-25 | US | Alabama | Lamar | 1075 | 2577 | 57 | 0 | 33.77995024 | -88.09668032 | 2021-12-26 04:21:50 | Lamar, Alabama, US | |
3497569 | 3497569 | 2021-12-15 | US | Kentucky | Butler | 21031 | 2577 | 43 | 0 | 37.20946153 | -86.68748787 | 2021-12-16 04:22:11 | Butler, Kentucky, US | |
1080216 | 1080216 | 2021-12-09 | US | North Carolina | Bertie | 37015 | 2577 | 53 | 0 | 36.0688473 | -76.96545943 | 2021-12-10 04:22:28 | Bertie, North Carolina, US | |
552908 | 552908 | 2021-12-08 | US | Nebraska | York | 31185 | 2577 | 11 | 0 | 40.87272618 | -97.59710186 | 2021-12-09 04:22:49 | York, Nebraska, US | |
3612 | 3612 | 2021-12-02 | US | Vermont | Caledonia | 50005 | 2577 | 21 | 0 | 44.46548598 | -72.10314651 | 2021-12-03 04:23:05 | Caledonia, Vermont, US | |
450211 | 450211 | 2021-11-17 | US | South Carolina | Saluda | 45081 | 2577 | 55 | 0 | 34.00795823 | -81.72713237 | 2021-11-18 04:21:33 | Saluda, South Carolina, US | |
1323844 | 1323844 | 2021-11-14 | US | Michigan | Antrim | 26009 | 2577 | 38 | 0 | 44.99690221 | -85.15503082 | 2021-11-15 04:21:36 | Antrim, Michigan, US | |
687970 | 687970 | 2021-11-13 | US | Michigan | Antrim | 26009 | 2577 | 38 | 0 | 44.99690221 | -85.15503082 | 2021-11-14 04:21:31 | Antrim, Michigan, 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]);