daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
235 rows where confirmed = 2793 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Virginia | Northampton | 51131 | 2793 | 74 | 0 | 37.34062933 | -75.87751591 | 2022-12-30 04:21:04 | Northampton, Virginia, US | |
2022-12-29 | Colombia | Guainia | 2793 | 37 | 0 | 2.5854 | -68.5247 | 2022-12-30 04:21:04 | Guainia, Colombia | |||
2022-12-28 | US | Virginia | Northampton | 51131 | 2793 | 74 | 0 | 37.34062933 | -75.87751591 | 2022-12-29 04:21:01 | Northampton, Virginia, US | |
2022-11-16 | US | Virginia | Poquoson | 51735 | 2793 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-11-17 04:21:11 | Poquoson, Virginia, US | |
2022-11-15 | US | Virginia | Poquoson | 51735 | 2793 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-11-16 04:21:09 | Poquoson, Virginia, US | |
2022-11-12 | China | Jiangsu | 2793 | 0 | 0 | 32.9711 | 119.455 | 2022-11-13 04:21:14 | Jiangsu, China | |||
2022-10-16 | US | Virginia | Richmond | 51159 | 2793 | 27 | 0 | 37.937575 | -76.72920628 | 2022-10-17 04:20:31 | Richmond, Virginia, US | |
2022-10-15 | US | Virginia | Richmond | 51159 | 2793 | 27 | 0 | 37.937575 | -76.72920628 | 2022-10-16 04:22:39 | Richmond, Virginia, US | |
2022-10-14 | US | Virginia | Richmond | 51159 | 2793 | 27 | 0 | 37.937575 | -76.72920628 | 2022-10-15 04:22:00 | Richmond, Virginia, US | |
2022-10-03 | US | Virginia | Richmond | 51159 | 2793 | 27 | 0 | 37.937575 | -76.72920628 | 2022-10-04 04:22:55 | Richmond, Virginia, US | |
2022-09-25 | US | Indiana | Benton | 18007 | 2793 | 24 | 0 | 40.60626947 | -87.31093999 | 2022-09-26 04:20:52 | Benton, Indiana, US | |
2022-09-24 | US | Indiana | Benton | 18007 | 2793 | 24 | 0 | 40.60626947 | -87.31093999 | 2022-09-25 04:23:31 | Benton, Indiana, US | |
2022-09-23 | US | Indiana | Benton | 18007 | 2793 | 24 | 0 | 40.60626947 | -87.31093999 | 2022-09-24 04:21:40 | Benton, Indiana, US | |
2022-09-18 | US | Colorado | Bent | 8011 | 2793 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-19 04:21:49 | Bent, Colorado, US | |
2022-09-17 | US | Colorado | Bent | 8011 | 2793 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-18 04:22:50 | Bent, Colorado, US | |
2022-09-16 | US | Colorado | Bent | 8011 | 2793 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-17 04:20:19 | Bent, Colorado, US | |
2022-09-15 | US | Colorado | Bent | 8011 | 2793 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-16 04:21:19 | Bent, Colorado, US | |
2022-09-15 | US | Arkansas | Pike | 5109 | 2793 | 45 | 0 | 34.16250414 | -93.65789349 | 2022-09-16 04:21:19 | Pike, Arkansas, US | |
2022-09-08 | US | North Dakota | Mercer | 38057 | 2793 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-09-09 04:21:11 | Mercer, North Dakota, US | |
2022-09-01 | US | West Virginia | Ritchie | 54085 | 2793 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-09-02 04:21:07 | Ritchie, West Virginia, US | |
2022-08-27 | US | Connecticut | Unassigned | 90009 | 2793 | 1 | 0 | 41.85853803 | 0.0 | 2022-08-28 04:21:02 | Unassigned, Connecticut, US | |
2022-08-26 | US | Arkansas | Perry | 5105 | 2793 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-08-27 04:20:57 | Perry, Arkansas, US | |
2022-08-25 | US | Missouri | Montgomery | 29139 | 2793 | 60 | 0 | 38.94022054 | -91.47000721 | 2022-08-26 04:21:02 | Montgomery, Missouri, US | |
2022-08-24 | US | Missouri | Montgomery | 29139 | 2793 | 60 | 0 | 38.94022054 | -91.47000721 | 2022-08-25 04:21:13 | Montgomery, Missouri, US | |
2022-08-24 | US | Arkansas | Perry | 5105 | 2793 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-08-25 04:21:13 | Perry, Arkansas, US | |
2022-08-23 | US | Missouri | Montgomery | 29139 | 2793 | 60 | 0 | 38.94022054 | -91.47000721 | 2022-08-24 04:20:46 | Montgomery, Missouri, US | |
2022-08-22 | US | Missouri | Montgomery | 29139 | 2793 | 60 | 0 | 38.94022054 | -91.47000721 | 2022-08-23 04:20:56 | Montgomery, Missouri, US | |
2022-08-21 | US | Missouri | Montgomery | 29139 | 2793 | 60 | 0 | 38.94022054 | -91.47000721 | 2022-08-22 04:20:38 | Montgomery, Missouri, US | |
2022-08-20 | US | Missouri | Montgomery | 29139 | 2793 | 60 | 0 | 38.94022054 | -91.47000721 | 2022-08-21 04:20:44 | Montgomery, Missouri, US | |
2022-08-19 | US | Missouri | Montgomery | 29139 | 2793 | 60 | 0 | 38.94022054 | -91.47000721 | 2022-08-20 04:21:01 | Montgomery, Missouri, US | |
2022-08-18 | US | Missouri | Linn | 29115 | 2793 | 67 | 0 | 39.87001769 | -93.10704106 | 2022-08-19 04:20:54 | Linn, Missouri, US | |
2022-08-17 | US | Missouri | Linn | 29115 | 2793 | 67 | 0 | 39.87001769 | -93.10704106 | 2022-08-18 04:21:11 | Linn, Missouri, US | |
2022-08-16 | US | Missouri | Linn | 29115 | 2793 | 67 | 0 | 39.87001769 | -93.10704106 | 2022-08-17 04:20:59 | Linn, Missouri, US | |
2022-08-15 | US | Missouri | Linn | 29115 | 2793 | 67 | 0 | 39.87001769 | -93.10704106 | 2022-08-16 04:20:58 | Linn, Missouri, US | |
2022-08-14 | US | Missouri | Linn | 29115 | 2793 | 67 | 0 | 39.87001769 | -93.10704106 | 2022-08-15 04:20:59 | Linn, Missouri, US | |
2022-08-13 | US | Missouri | Linn | 29115 | 2793 | 67 | 0 | 39.87001769 | -93.10704106 | 2022-08-14 04:20:55 | Linn, Missouri, US | |
2022-08-12 | US | Missouri | Linn | 29115 | 2793 | 67 | 0 | 39.87001769 | -93.10704106 | 2022-08-13 04:20:52 | Linn, Missouri, US | |
2022-07-19 | US | Texas | Blanco | 48031 | 2793 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-07-20 04:20:59 | Blanco, Texas, US | |
2022-07-18 | US | Virginia | Floyd | 51063 | 2793 | 49 | 0 | 36.9302126 | -80.36738849 | 2022-07-19 04:20:58 | Floyd, Virginia, US | |
2022-06-28 | Nauru | 2793 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2022-06-29 04:20:59 | Nauru | |||
2022-06-17 | US | Tennessee | Lake | 47095 | 2793 | 44 | 0 | 36.3418017 | -89.48921915 | 2022-06-18 04:21:10 | Lake, Tennessee, US | |
2022-03-25 | US | Texas | Eastland | 48133 | 2793 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-03-26 04:20:23 | Eastland, Texas, US | |
2022-03-23 | US | Texas | Callahan | 48059 | 2793 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-03-24 04:20:43 | Callahan, Texas, US | |
2022-03-22 | US | Texas | Callahan | 48059 | 2793 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-03-23 04:20:48 | Callahan, Texas, US | |
2022-03-21 | US | Texas | Callahan | 48059 | 2793 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-03-22 04:20:54 | Callahan, Texas, US | |
2022-03-20 | US | Texas | Callahan | 48059 | 2793 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-03-21 04:20:50 | Callahan, Texas, US | |
2022-03-03 | US | Puerto Rico | Villalba | 72149 | 2793 | 0 | 0 | 18.127951 | -66.473115 | 2022-03-04 04:21:09 | Villalba, Puerto Rico, US | |
2022-03-03 | US | Kansas | Wilson | 20205 | 2793 | 40 | 0 | 37.55937174 | -95.74323255 | 2022-03-04 04:21:09 | Wilson, Kansas, US | |
2022-03-02 | US | Kansas | Wilson | 20205 | 2793 | 40 | 0 | 37.55937174 | -95.74323255 | 2022-03-03 04:21:01 | Wilson, Kansas, US | |
2022-02-27 | US | Connecticut | Unassigned | 90009 | 2793 | 3 | 0 | 41.85853803 | 0.0 | 2022-02-28 04:21:05 | Unassigned, Connecticut, US | |
2022-02-26 | US | Connecticut | Unassigned | 90009 | 2793 | 3 | 0 | 41.85853803 | 0.0 | 2022-02-27 04:21:04 | Unassigned, Connecticut, US | |
2022-02-25 | US | Connecticut | Unassigned | 90009 | 2793 | 3 | 0 | 41.85853803 | 0.0 | 2022-02-26 04:21:12 | Unassigned, Connecticut, US | |
2022-02-18 | US | Washington | Jefferson | 53031 | 2793 | 25 | 0 | 47.75003077 | -123.56097040000002 | 2022-02-19 04:21:11 | Jefferson, Washington, US | |
2022-02-17 | US | Washington | Jefferson | 53031 | 2793 | 25 | 0 | 47.75003077 | -123.56097040000002 | 2022-02-18 04:21:04 | Jefferson, Washington, US | |
2022-02-16 | US | Washington | Jefferson | 53031 | 2793 | 25 | 0 | 47.75003077 | -123.56097040000002 | 2022-02-17 04:20:56 | Jefferson, Washington, US | |
2022-02-08 | US | South Dakota | Todd | 46121 | 2793 | 44 | 0 | 43.19338568 | -100.71955030000001 | 2022-02-09 04:21:04 | Todd, South Dakota, US | |
2022-01-18 | US | Michigan | Kalkaska | 26079 | 2793 | 48 | 0 | 44.68512729 | -85.09085699 | 2022-01-19 04:21:23 | Kalkaska, Michigan, US | |
2022-01-17 | US | Michigan | Kalkaska | 26079 | 2793 | 48 | 0 | 44.68512729 | -85.09085699 | 2022-01-18 04:21:04 | Kalkaska, Michigan, US | |
2022-01-16 | US | Michigan | Kalkaska | 26079 | 2793 | 48 | 0 | 44.68512729 | -85.09085699 | 2022-01-17 04:21:08 | Kalkaska, Michigan, US | |
2022-01-15 | US | Michigan | Kalkaska | 26079 | 2793 | 48 | 0 | 44.68512729 | -85.09085699 | 2022-01-16 04:21:12 | Kalkaska, Michigan, US | |
2022-01-14 | US | Michigan | Kalkaska | 26079 | 2793 | 48 | 0 | 44.68512729 | -85.09085699 | 2022-01-15 04:21:07 | Kalkaska, Michigan, US | |
2022-01-11 | US | Alabama | Cleburne | 1029 | 2793 | 61 | 0 | 33.67679204 | -85.52005899 | 2022-01-12 04:21:44 | Cleburne, Alabama, US | |
2022-01-10 | US | Kentucky | Webster | 21233 | 2793 | 46 | 0 | 37.52168356 | -87.67989953 | 2022-01-11 04:22:01 | Webster, Kentucky, US | |
2022-01-10 | US | Kentucky | Monroe | 21171 | 2793 | 69 | 0 | 36.71225341 | -85.71596443 | 2022-01-11 04:22:01 | Monroe, Kentucky, US | |
2022-01-09 | US | West Virginia | Monroe | 54063 | 2793 | 31 | 0 | 37.56274716 | -80.54577965 | 2022-01-10 04:22:07 | Monroe, West Virginia, US | |
2022-01-05 | US | Virginia | Appomattox | 51011 | 2793 | 38 | 0 | 37.37569884 | -78.81340003 | 2022-01-06 04:22:09 | Appomattox, Virginia, US | |
2021-12-28 | US | Nebraska | Saline | 31151 | 2793 | 2 | 0 | 40.52418865 | -97.14085859 | 2021-12-29 03:21:43 | Saline, Nebraska, US | |
2021-12-26 | US | Montana | Park | 30067 | 2793 | 31 | 0 | 45.48965095 | -110.52643940000002 | 2021-12-27 04:21:58 | Park, Montana, US | |
2021-12-25 | US | Montana | Park | 30067 | 2793 | 31 | 0 | 45.48965095 | -110.52643940000002 | 2021-12-26 04:21:50 | Park, Montana, US | |
2021-12-24 | US | Montana | Park | 30067 | 2793 | 31 | 0 | 45.48965095 | -110.52643940000002 | 2021-12-25 04:21:37 | Park, Montana, US | |
2021-12-23 | US | Montana | Park | 30067 | 2793 | 31 | 0 | 45.48965095 | -110.52643940000002 | 2021-12-24 04:21:34 | Park, Montana, US | |
2021-12-20 | US | Georgia | Greene | 13133 | 2793 | 74 | 0 | 33.5769205 | -83.17139104 | 2021-12-21 03:21:27 | Greene, Georgia, US | |
2021-12-18 | US | Puerto Rico | Humacao | 72069 | 2793 | 0 | 0 | 18.145211 | -65.810174 | 2021-12-19 04:21:11 | Humacao, Puerto Rico, US | |
2021-12-08 | US | Louisiana | LaSalle | 22059 | 2793 | 46 | 0 | 31.67884782 | -92.15907765 | 2021-12-09 04:22:49 | LaSalle, Louisiana, US | |
2021-12-05 | US | Puerto Rico | Gurabo | 72063 | 2793 | 0 | 0 | 18.266461 | -65.97970500000001 | 2021-12-06 04:22:34 | Gurabo, Puerto Rico, US | |
2021-11-30 | US | Oklahoma | Choctaw | 40023 | 2793 | 51 | 0 | 34.02807439 | -95.54771129 | 2021-12-01 04:22:29 | Choctaw, Oklahoma, US | |
2021-11-29 | US | Oklahoma | Choctaw | 40023 | 2793 | 51 | 0 | 34.02807439 | -95.54771129 | 2021-11-30 04:22:53 | Choctaw, Oklahoma, US | |
2021-11-28 | US | Oklahoma | Choctaw | 40023 | 2793 | 51 | 0 | 34.02807439 | -95.54771129 | 2021-11-29 04:22:30 | Choctaw, Oklahoma, US | |
2021-11-27 | US | Oklahoma | Choctaw | 40023 | 2793 | 51 | 0 | 34.02807439 | -95.54771129 | 2021-11-28 04:22:43 | Choctaw, Oklahoma, US | |
2021-11-26 | US | Oklahoma | Choctaw | 40023 | 2793 | 51 | 0 | 34.02807439 | -95.54771129 | 2021-11-27 04:22:45 | Choctaw, Oklahoma, US | |
2021-11-25 | US | Oklahoma | Choctaw | 40023 | 2793 | 51 | 0 | 34.02807439 | -95.54771129 | 2021-11-26 04:22:33 | Choctaw, Oklahoma, US | |
2021-11-24 | US | Oklahoma | Choctaw | 40023 | 2793 | 51 | 0 | 34.02807439 | -95.54771129 | 2021-11-25 04:22:33 | Choctaw, Oklahoma, US | |
2021-11-24 | US | Arkansas | Clay | 5021 | 2793 | 74 | 0 | 36.36826212 | -90.4148172 | 2021-11-25 04:22:33 | Clay, Arkansas, US | |
2021-11-24 | Russia | Chukotka Autonomous Okrug | 2793 | 24 | 0 | 66.0006475 | 169.4900869 | 2021-11-25 04:22:33 | Chukotka Autonomous Okrug, Russia | |||
2021-11-23 | US | Iowa | Fayette | 19065 | 2793 | 53 | 0 | 42.86271799 | -91.84412309999999 | 2021-11-24 04:22:14 | Fayette, Iowa, US | |
2021-11-22 | US | Iowa | Fayette | 19065 | 2793 | 53 | 0 | 42.86271799 | -91.84412309999999 | 2021-11-23 04:22:39 | Fayette, Iowa, US | |
2021-11-21 | US | Iowa | Fayette | 19065 | 2793 | 53 | 0 | 42.86271799 | -91.84412309999999 | 2021-11-22 04:22:20 | Fayette, Iowa, US | |
2021-11-20 | US | Iowa | Fayette | 19065 | 2793 | 53 | 0 | 42.86271799 | -91.84412309999999 | 2021-11-21 04:22:13 | Fayette, Iowa, US | |
2021-11-19 | US | Iowa | Fayette | 19065 | 2793 | 53 | 0 | 42.86271799 | -91.84412309999999 | 2021-11-20 04:22:17 | Fayette, Iowa, US | |
2021-11-18 | US | Iowa | Fayette | 19065 | 2793 | 53 | 0 | 42.86271799 | -91.84412309999999 | 2021-11-19 04:21:40 | Fayette, Iowa, US | |
2021-11-17 | US | Iowa | Fayette | 19065 | 2793 | 53 | 0 | 42.86271799 | -91.84412309999999 | 2021-11-18 04:21:33 | Fayette, Iowa, US | |
2021-11-09 | US | North Carolina | Avery | 37011 | 2793 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-11-10 04:21:38 | Avery, North Carolina, US | |
2021-11-06 | US | Ohio | Meigs | 39105 | 2793 | 58 | 0 | 39.09224872 | -82.0305041 | 2021-11-07 04:21:53 | Meigs, Ohio, US | |
2021-11-04 | US | North Carolina | Currituck | 37053 | 2793 | 27 | 0 | 36.36123664 | -75.95876401 | 2021-11-05 04:21:54 | Currituck, North Carolina, US | |
2021-10-27 | US | Kentucky | Garrard | 21079 | 2793 | 48 | 0 | 37.638866799999995 | -84.53289319 | 2021-10-28 04:22:08 | Garrard, Kentucky, US | |
2021-10-24 | US | Tennessee | Cannon | 47015 | 2793 | 42 | 0 | 35.80990797 | -86.05738983 | 2021-10-25 04:22:31 | Cannon, Tennessee, US | |
2021-10-23 | US | Tennessee | Cannon | 47015 | 2793 | 42 | 0 | 35.80990797 | -86.05738983 | 2021-10-24 04:21:22 | Cannon, Tennessee, US | |
2021-10-21 | US | Mississippi | Calhoun | 28013 | 2793 | 46 | 0 | 33.93683395 | -89.33686647 | 2021-10-22 04:21:14 | Calhoun, Mississippi, US | |
2021-10-18 | US | Illinois | White | 17193 | 2793 | 33 | 0 | 38.08706198 | -88.17657461 | 2021-10-19 04:20:54 | White, Illinois, US | |
2021-10-13 | US | Texas | Jackson | 48239 | 2793 | 50 | 0 | 28.95472367 | -96.57749563 | 2021-10-14 04:21:29 | Jackson, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;