daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
201 rows where confirmed = 4153 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 | South Carolina | Bamberg | 45009 | 4153 | 76 | 0 | 33.21927586 | -81.05659969 | 2022-12-30 04:21:04 | Bamberg, South Carolina, US | |
2022-12-28 | US | South Carolina | Bamberg | 45009 | 4153 | 76 | 0 | 33.21927586 | -81.05659969 | 2022-12-29 04:21:01 | Bamberg, South Carolina, US | |
2022-12-27 | US | South Carolina | Bamberg | 45009 | 4153 | 76 | 0 | 33.21927586 | -81.05659969 | 2022-12-28 04:21:04 | Bamberg, South Carolina, US | |
2022-12-06 | US | Texas | Duval | 48131 | 4153 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-12-07 04:20:58 | Duval, Texas, US | |
2022-12-05 | US | Texas | Duval | 48131 | 4153 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-12-06 04:21:03 | Duval, Texas, US | |
2022-12-04 | US | Texas | Duval | 48131 | 4153 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-12-05 04:20:58 | Duval, Texas, US | |
2022-12-03 | US | Texas | Duval | 48131 | 4153 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-12-04 04:20:56 | Duval, Texas, US | |
2022-12-02 | US | Texas | Duval | 48131 | 4153 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-12-03 04:21:02 | Duval, Texas, US | |
2022-12-01 | US | Texas | Duval | 48131 | 4153 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-12-02 04:21:07 | Duval, Texas, US | |
2022-11-30 | US | Texas | Duval | 48131 | 4153 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-12-01 04:21:03 | Duval, Texas, US | |
2022-10-25 | US | Virginia | Alleghany | 51005 | 4153 | 108 | 0 | 37.78636074 | -80.00222498 | 2022-10-26 04:22:19 | Alleghany, Virginia, US | |
2022-10-24 | US | Virginia | Alleghany | 51005 | 4153 | 108 | 0 | 37.78636074 | -80.00222498 | 2022-10-25 04:21:53 | Alleghany, Virginia, US | |
2022-10-04 | US | Texas | Freestone | 48161 | 4153 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-10-05 04:23:06 | Freestone, Texas, US | |
2022-10-03 | US | Texas | Freestone | 48161 | 4153 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-10-04 04:22:55 | Freestone, Texas, US | |
2022-09-27 | US | Illinois | Menard | 17129 | 4153 | 25 | 0 | 40.02742725 | -89.80246001 | 2022-09-28 04:23:01 | Menard, Illinois, US | |
2022-09-18 | US | New Mexico | Los Alamos | 35028 | 4153 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-09-19 04:21:49 | Los Alamos, New Mexico, US | |
2022-09-17 | US | New Mexico | Los Alamos | 35028 | 4153 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-09-18 04:22:50 | Los Alamos, New Mexico, US | |
2022-09-16 | US | New Mexico | Los Alamos | 35028 | 4153 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-09-17 04:20:19 | Los Alamos, New Mexico, US | |
2022-09-16 | China | Beijing | 4153 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-17 04:20:19 | Beijing, China | |||
2022-09-13 | US | Iowa | Kossuth | 19109 | 4153 | 92 | 0 | 43.20405458 | -94.20691791 | 2022-09-14 04:20:44 | Kossuth, Iowa, US | |
2022-09-12 | US | Michigan | Kalkaska | 26079 | 4153 | 65 | 0 | 44.68512729 | -85.09085699 | 2022-09-13 04:20:57 | Kalkaska, Michigan, US | |
2022-09-12 | US | Iowa | Kossuth | 19109 | 4153 | 92 | 0 | 43.20405458 | -94.20691791 | 2022-09-13 04:20:57 | Kossuth, Iowa, US | |
2022-09-11 | US | Michigan | Kalkaska | 26079 | 4153 | 65 | 0 | 44.68512729 | -85.09085699 | 2022-09-12 04:20:58 | Kalkaska, Michigan, US | |
2022-09-11 | US | Iowa | Kossuth | 19109 | 4153 | 92 | 0 | 43.20405458 | -94.20691791 | 2022-09-12 04:20:58 | Kossuth, Iowa, US | |
2022-09-10 | US | Tennessee | Decatur | 47039 | 4153 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-09-11 04:20:50 | Decatur, Tennessee, US | |
2022-09-10 | US | Michigan | Kalkaska | 26079 | 4153 | 65 | 0 | 44.68512729 | -85.09085699 | 2022-09-11 04:20:50 | Kalkaska, Michigan, US | |
2022-09-10 | US | Iowa | Kossuth | 19109 | 4153 | 92 | 0 | 43.20405458 | -94.20691791 | 2022-09-11 04:20:50 | Kossuth, Iowa, US | |
2022-09-09 | US | Tennessee | Decatur | 47039 | 4153 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-09-10 04:21:10 | Decatur, Tennessee, US | |
2022-09-09 | US | Michigan | Kalkaska | 26079 | 4153 | 65 | 0 | 44.68512729 | -85.09085699 | 2022-09-10 04:21:10 | Kalkaska, Michigan, US | |
2022-09-09 | US | Iowa | Kossuth | 19109 | 4153 | 92 | 0 | 43.20405458 | -94.20691791 | 2022-09-10 04:21:10 | Kossuth, Iowa, US | |
2022-09-08 | US | Tennessee | Decatur | 47039 | 4153 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-09-09 04:21:11 | Decatur, Tennessee, US | |
2022-09-08 | US | Michigan | Kalkaska | 26079 | 4153 | 65 | 0 | 44.68512729 | -85.09085699 | 2022-09-09 04:21:11 | Kalkaska, Michigan, US | |
2022-09-08 | US | Iowa | Kossuth | 19109 | 4153 | 92 | 0 | 43.20405458 | -94.20691791 | 2022-09-09 04:21:11 | Kossuth, Iowa, US | |
2022-09-07 | US | Tennessee | Decatur | 47039 | 4153 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-09-08 04:21:02 | Decatur, Tennessee, US | |
2022-09-07 | US | Michigan | Kalkaska | 26079 | 4153 | 65 | 0 | 44.68512729 | -85.09085699 | 2022-09-08 04:21:02 | Kalkaska, Michigan, US | |
2022-09-07 | US | Iowa | Kossuth | 19109 | 4153 | 92 | 0 | 43.20405458 | -94.20691791 | 2022-09-08 04:21:02 | Kossuth, Iowa, US | |
2022-09-06 | US | Vermont | Lamoille | 50015 | 4153 | 19 | 0 | 44.60353043 | -72.64356694 | 2022-09-07 04:20:59 | Lamoille, Vermont, US | |
2022-09-06 | US | Michigan | Kalkaska | 26079 | 4153 | 65 | 0 | 44.68512729 | -85.09085699 | 2022-09-07 04:20:59 | Kalkaska, Michigan, US | |
2022-09-05 | US | Vermont | Lamoille | 50015 | 4153 | 19 | 0 | 44.60353043 | -72.64356694 | 2022-09-06 04:21:02 | Lamoille, Vermont, US | |
2022-09-04 | US | Vermont | Lamoille | 50015 | 4153 | 19 | 0 | 44.60353043 | -72.64356694 | 2022-09-05 04:21:01 | Lamoille, Vermont, US | |
2022-09-03 | US | Vermont | Lamoille | 50015 | 4153 | 19 | 0 | 44.60353043 | -72.64356694 | 2022-09-04 04:21:22 | Lamoille, Vermont, US | |
2022-09-02 | US | Vermont | Lamoille | 50015 | 4153 | 19 | 0 | 44.60353043 | -72.64356694 | 2022-09-03 04:21:04 | Lamoille, Vermont, US | |
2022-09-01 | US | Vermont | Lamoille | 50015 | 4153 | 19 | 0 | 44.60353043 | -72.64356694 | 2022-09-02 04:21:07 | Lamoille, Vermont, US | |
2022-08-31 | US | Vermont | Lamoille | 50015 | 4153 | 19 | 0 | 44.60353043 | -72.64356694 | 2022-09-01 04:21:03 | Lamoille, Vermont, US | |
2022-08-31 | US | Texas | Falls | 48145 | 4153 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-01 04:21:03 | Falls, Texas, US | |
2022-08-22 | US | Texas | Colorado | 48089 | 4153 | 67 | 0 | 29.622098 | -96.5273805 | 2022-08-23 04:20:56 | Colorado, Texas, US | |
2022-06-14 | US | Alabama | Clay | 1027 | 4153 | 82 | 0 | 33.26984193 | -85.85836077 | 2022-06-15 04:20:54 | Clay, Alabama, US | |
2022-05-26 | US | Illinois | Warren | 17187 | 4153 | 84 | 0 | 40.84925021 | -90.6147432 | 2022-05-27 04:20:56 | Warren, Illinois, US | |
2022-05-17 | US | Pennsylvania | Fulton | 42057 | 4153 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-05-18 04:20:50 | Fulton, Pennsylvania, US | |
2022-05-16 | US | Pennsylvania | Fulton | 42057 | 4153 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-05-17 04:20:59 | Fulton, Pennsylvania, US | |
2022-05-15 | US | Virginia | Goochland | 51075 | 4153 | 53 | 0 | 37.71714806 | -77.90381514 | 2022-05-16 04:20:47 | Goochland, Virginia, US | |
2022-05-15 | US | Pennsylvania | Fulton | 42057 | 4153 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-05-16 04:20:47 | Fulton, Pennsylvania, US | |
2022-05-14 | US | Virginia | Goochland | 51075 | 4153 | 53 | 0 | 37.71714806 | -77.90381514 | 2022-05-15 04:20:53 | Goochland, Virginia, US | |
2022-05-14 | US | Pennsylvania | Fulton | 42057 | 4153 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-05-15 04:20:53 | Fulton, Pennsylvania, US | |
2022-05-13 | US | Virginia | Goochland | 51075 | 4153 | 53 | 0 | 37.71714806 | -77.90381514 | 2022-05-14 04:20:48 | Goochland, Virginia, US | |
2022-05-13 | US | Pennsylvania | Fulton | 42057 | 4153 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-05-14 04:20:48 | Fulton, Pennsylvania, US | |
2022-05-12 | US | Pennsylvania | Fulton | 42057 | 4153 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-05-13 04:20:51 | Fulton, Pennsylvania, US | |
2022-05-11 | US | Pennsylvania | Fulton | 42057 | 4153 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-05-12 04:20:54 | Fulton, Pennsylvania, US | |
2022-05-03 | US | Texas | Aransas | 48007 | 4153 | 85 | 0 | 28.10556197 | -96.9995047 | 2022-05-04 04:20:59 | Aransas, Texas, US | |
2022-04-02 | US | Puerto Rico | Coamo | 72043 | 4153 | 0 | 0 | 18.097597 | -66.36014 | 2022-04-03 04:20:48 | Coamo, Puerto Rico, US | |
2022-03-16 | US | Oklahoma | Kingfisher | 40073 | 4153 | 64 | 0 | 35.94530008 | -97.94193268 | 2022-03-17 04:20:56 | Kingfisher, Oklahoma, US | |
2022-03-15 | US | Oklahoma | Kingfisher | 40073 | 4153 | 64 | 0 | 35.94530008 | -97.94193268 | 2022-03-16 04:20:50 | Kingfisher, Oklahoma, US | |
2022-03-14 | US | Oklahoma | Kingfisher | 40073 | 4153 | 64 | 0 | 35.94530008 | -97.94193268 | 2022-03-15 04:20:47 | Kingfisher, Oklahoma, US | |
2022-03-13 | US | Oklahoma | Kingfisher | 40073 | 4153 | 64 | 0 | 35.94530008 | -97.94193268 | 2022-03-14 04:20:46 | Kingfisher, Oklahoma, US | |
2022-03-12 | US | Oklahoma | Kingfisher | 40073 | 4153 | 64 | 0 | 35.94530008 | -97.94193268 | 2022-03-13 04:20:49 | Kingfisher, Oklahoma, US | |
2022-03-11 | US | Oklahoma | Kingfisher | 40073 | 4153 | 64 | 0 | 35.94530008 | -97.94193268 | 2022-03-12 04:20:50 | Kingfisher, Oklahoma, US | |
2022-03-10 | US | Oklahoma | Kingfisher | 40073 | 4153 | 64 | 0 | 35.94530008 | -97.94193268 | 2022-03-11 04:20:50 | Kingfisher, Oklahoma, US | |
2022-03-10 | US | Montana | Park | 30067 | 4153 | 34 | 0 | 45.48965095 | -110.52643940000002 | 2022-03-11 04:20:50 | Park, Montana, US | |
2022-03-03 | US | West Virginia | Hardy | 54031 | 4153 | 48 | 0 | 39.00683177 | -78.85855301 | 2022-03-04 04:21:09 | Hardy, West Virginia, US | |
2022-02-20 | US | West Virginia | Morgan | 54065 | 4153 | 64 | 0 | 39.55439028 | -78.26311676 | 2022-02-21 04:21:05 | Morgan, West Virginia, US | |
2022-02-19 | US | West Virginia | Morgan | 54065 | 4153 | 64 | 0 | 39.55439028 | -78.26311676 | 2022-02-20 04:21:00 | Morgan, West Virginia, US | |
2022-02-18 | US | West Virginia | Morgan | 54065 | 4153 | 64 | 0 | 39.55439028 | -78.26311676 | 2022-02-19 04:21:11 | Morgan, West Virginia, US | |
2022-02-16 | US | Puerto Rico | Morovis | 72101 | 4153 | 0 | 0 | 18.316963 | -66.420383 | 2022-02-17 04:20:56 | Morovis, Puerto Rico, US | |
2022-02-10 | US | Washington | Asotin | 53003 | 4153 | 58 | 0 | 46.18894415 | -117.2022851 | 2022-02-11 04:21:09 | Asotin, Washington, US | |
2022-02-09 | US | Washington | Asotin | 53003 | 4153 | 58 | 0 | 46.18894415 | -117.2022851 | 2022-02-10 04:21:14 | Asotin, Washington, US | |
2022-02-02 | US | Oregon | Clatsop | 41007 | 4153 | 38 | 0 | 45.99712889 | -123.660711 | 2022-02-03 04:21:21 | Clatsop, Oregon, US | |
2022-01-30 | US | Arkansas | Sharp | 5135 | 4153 | 85 | 0 | 36.16258158 | -91.47819342 | 2022-01-31 04:21:09 | Sharp, Arkansas, US | |
2022-01-29 | US | Arkansas | Sharp | 5135 | 4153 | 85 | 0 | 36.16258158 | -91.47819342 | 2022-01-30 04:21:26 | Sharp, Arkansas, US | |
2022-01-28 | US | Arkansas | Sharp | 5135 | 4153 | 85 | 0 | 36.16258158 | -91.47819342 | 2022-01-29 04:21:10 | Sharp, Arkansas, US | |
2022-01-27 | US | Minnesota | Fillmore | 27045 | 4153 | 20 | 0 | 43.67394126 | -92.08980382 | 2022-01-28 04:21:09 | Fillmore, Minnesota, US | |
2022-01-17 | US | New Mexico | Lincoln | 35027 | 4153 | 51 | 0 | 33.74526079 | -105.4586166 | 2022-01-18 04:21:04 | Lincoln, New Mexico, US | |
2022-01-17 | US | Colorado | Chaffee | 8015 | 4153 | 42 | 0 | 38.74745778 | -106.19265729999998 | 2022-01-18 04:21:04 | Chaffee, Colorado, US | |
2022-01-16 | US | New Mexico | Lincoln | 35027 | 4153 | 51 | 0 | 33.74526079 | -105.4586166 | 2022-01-17 04:21:08 | Lincoln, New Mexico, US | |
2022-01-15 | US | New Mexico | Lincoln | 35027 | 4153 | 51 | 0 | 33.74526079 | -105.4586166 | 2022-01-16 04:21:12 | Lincoln, New Mexico, US | |
2022-01-15 | US | Arkansas | Phillips | 5107 | 4153 | 84 | 0 | 34.43268455 | -90.84800154 | 2022-01-16 04:21:12 | Phillips, Arkansas, US | |
2022-01-14 | US | New Mexico | Lincoln | 35027 | 4153 | 51 | 0 | 33.74526079 | -105.4586166 | 2022-01-15 04:21:07 | Lincoln, New Mexico, US | |
2022-01-10 | US | Colorado | Teller | 8119 | 4153 | 54 | 0 | 38.88133511 | -105.16148929999999 | 2022-01-11 04:22:01 | Teller, Colorado, US | |
2021-12-28 | US | Texas | Frio | 48163 | 4153 | 78 | 0 | 28.86751206 | -99.10804207 | 2021-12-29 03:21:43 | Frio, Texas, US | |
2021-12-26 | US | West Virginia | Wyoming | 54109 | 4153 | 76 | 0 | 37.612327 | -81.54511071 | 2021-12-27 04:21:58 | Wyoming, West Virginia, US | |
2021-12-25 | US | West Virginia | Wyoming | 54109 | 4153 | 76 | 0 | 37.612327 | -81.54511071 | 2021-12-26 04:21:50 | Wyoming, West Virginia, US | |
2021-12-24 | US | West Virginia | Wyoming | 54109 | 4153 | 76 | 0 | 37.612327 | -81.54511071 | 2021-12-25 04:21:37 | Wyoming, West Virginia, US | |
2021-12-23 | US | West Virginia | Wyoming | 54109 | 4153 | 76 | 0 | 37.612327 | -81.54511071 | 2021-12-24 04:21:34 | Wyoming, West Virginia, US | |
2021-12-13 | US | Mississippi | Leake | 28079 | 4153 | 92 | 0 | 32.7536828 | -89.52402044 | 2021-12-14 04:22:38 | Leake, Mississippi, US | |
2021-12-12 | US | Arkansas | Sevier | 5133 | 4153 | 61 | 0 | 33.99780401 | -94.2424869 | 2021-12-13 04:22:02 | Sevier, Arkansas, US | |
2021-12-11 | US | Arkansas | Sevier | 5133 | 4153 | 61 | 0 | 33.99780401 | -94.2424869 | 2021-12-12 04:22:12 | Sevier, Arkansas, US | |
2021-11-18 | US | Texas | Moore | 48341 | 4153 | 88 | 0 | 35.83769242 | -101.8930281 | 2021-11-19 04:21:40 | Moore, Texas, US | |
2021-11-17 | US | Texas | Moore | 48341 | 4153 | 88 | 0 | 35.83769242 | -101.8930281 | 2021-11-18 04:21:33 | Moore, Texas, US | |
2021-11-17 | US | Oregon | Columbia | 41009 | 4153 | 50 | 0 | 45.94464254 | -123.08908980000001 | 2021-11-18 04:21:33 | Columbia, Oregon, US | |
2021-11-13 | US | Ohio | Van Wert | 39161 | 4153 | 93 | 0 | 40.8554138 | -84.59111700000003 | 2021-11-14 04:21:31 | Van Wert, Ohio, US | |
2021-11-07 | US | Indiana | Fayette | 18041 | 4153 | 90 | 0 | 39.63684962 | -85.17797541 | 2021-11-08 04:21:43 | Fayette, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;