johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
72 rows where country_or_region = "US" and deaths = 1205 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 23
- Arizona 7
- Florida 7
- Hawaii 7
- Indiana 7
- Colorado 5
- Illinois 5
- New Jersey 5
- Georgia 4
- Texas 4
- California 2
- Delaware 2
- Maryland 2
- Massachusetts 2
- Ohio 2
- Pennsylvania 2
- Wisconsin 2
- Louisiana 1
- Minnesota 1
- Nevada 1
- New York 1
- North Carolina 1
- South Carolina 1
- Tennessee 1
country_or_region 1
- US · 72 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756502 | 2756502 | 2022-12-29 | US | Wisconsin | Waukesha | 55133 | 136875 | 1205 | 0 | 43.01833055 | -88.30431188 | 2022-12-30 04:21:04 | Waukesha, Wisconsin, US | |
1077508 | 1077508 | 2022-12-28 | US | Wisconsin | Waukesha | 55133 | 136775 | 1205 | 0 | 43.01833055 | -88.30431188 | 2022-12-29 04:21:01 | Waukesha, Wisconsin, US | |
1561591 | 1561591 | 2022-09-28 | US | Louisiana | Caddo | 22017 | 81634 | 1205 | 0 | 32.57991587 | -93.88375652 | 2022-09-29 04:22:34 | Caddo, Louisiana, US | |
3995101 | 3995101 | 2022-09-27 | US | Arizona | Yuma | 4027 | 67629 | 1205 | 0 | 32.76895712 | -113.9066674 | 2022-09-28 04:23:01 | Yuma, Arizona, US | |
2769429 | 2769429 | 2022-09-26 | US | Arizona | Yuma | 4027 | 67629 | 1205 | 0 | 32.76895712 | -113.9066674 | 2022-09-27 04:23:01 | Yuma, Arizona, US | |
1977082 | 1977082 | 2022-09-25 | US | Arizona | Yuma | 4027 | 67629 | 1205 | 0 | 32.76895712 | -113.9066674 | 2022-09-26 04:20:52 | Yuma, Arizona, US | |
2650249 | 2650249 | 2022-09-24 | US | Arizona | Yuma | 4027 | 67629 | 1205 | 0 | 32.76895712 | -113.9066674 | 2022-09-25 04:23:31 | Yuma, Arizona, US | |
384689 | 384689 | 2022-09-23 | US | Arizona | Yuma | 4027 | 67629 | 1205 | 0 | 32.76895712 | -113.9066674 | 2022-09-24 04:21:40 | Yuma, Arizona, US | |
1624755 | 1624755 | 2022-09-22 | US | Arizona | Yuma | 4027 | 67629 | 1205 | 0 | 32.76895712 | -113.9066674 | 2022-09-23 04:23:13 | Yuma, Arizona, US | |
1370959 | 1370959 | 2022-09-21 | US | Arizona | Yuma | 4027 | 67629 | 1205 | 0 | 32.76895712 | -113.9066674 | 2022-09-22 04:22:56 | Yuma, Arizona, US | |
2019176 | 2019176 | 2022-09-20 | US | Ohio | Butler | 39017 | 107120 | 1205 | 0 | 39.44012838 | -84.57388716 | 2022-09-21 04:23:22 | Butler, Ohio, US | |
2395530 | 2395530 | 2022-09-12 | US | Florida | Osceola | 12097 | 136661 | 1205 | 0 | 28.06312234 | -81.14882926 | 2022-09-13 04:20:57 | Osceola, Florida, US | |
3766608 | 3766608 | 2022-09-11 | US | Florida | Osceola | 12097 | 136661 | 1205 | 0 | 28.06312234 | -81.14882926 | 2022-09-12 04:20:58 | Osceola, Florida, US | |
3825183 | 3825183 | 2022-09-10 | US | Florida | Osceola | 12097 | 136661 | 1205 | 0 | 28.06312234 | -81.14882926 | 2022-09-11 04:20:50 | Osceola, Florida, US | |
963640 | 963640 | 2022-09-09 | US | Florida | Osceola | 12097 | 136661 | 1205 | 0 | 28.06312234 | -81.14882926 | 2022-09-10 04:21:10 | Osceola, Florida, US | |
254042 | 254042 | 2022-09-08 | US | Florida | Osceola | 12097 | 135543 | 1205 | 0 | 28.06312234 | -81.14882926 | 2022-09-09 04:21:11 | Osceola, Florida, US | |
3745840 | 3745840 | 2022-09-07 | US | Florida | Osceola | 12097 | 135543 | 1205 | 0 | 28.06312234 | -81.14882926 | 2022-09-08 04:21:02 | Osceola, Florida, US | |
115480 | 115480 | 2022-09-06 | US | Florida | Osceola | 12097 | 135543 | 1205 | 0 | 28.06312234 | -81.14882926 | 2022-09-07 04:20:59 | Osceola, Florida, US | |
1251670 | 1251670 | 2022-08-23 | US | Hawaii | Honolulu | 15003 | 232683 | 1205 | 0 | 21.45803166 | -157.9712182 | 2022-08-24 04:20:46 | Honolulu, Hawaii, US | |
2853774 | 2853774 | 2022-08-22 | US | Hawaii | Honolulu | 15003 | 232683 | 1205 | 0 | 21.45803166 | -157.9712182 | 2022-08-23 04:20:56 | Honolulu, Hawaii, US | |
2403746 | 2403746 | 2022-08-21 | US | Hawaii | Honolulu | 15003 | 232683 | 1205 | 0 | 21.45803166 | -157.9712182 | 2022-08-22 04:20:38 | Honolulu, Hawaii, US | |
3798824 | 3798824 | 2022-08-20 | US | Hawaii | Honolulu | 15003 | 232683 | 1205 | 0 | 21.45803166 | -157.9712182 | 2022-08-21 04:20:44 | Honolulu, Hawaii, US | |
2364410 | 2364410 | 2022-08-19 | US | Hawaii | Honolulu | 15003 | 232683 | 1205 | 0 | 21.45803166 | -157.9712182 | 2022-08-20 04:21:01 | Honolulu, Hawaii, US | |
1162081 | 1162081 | 2022-08-18 | US | Hawaii | Honolulu | 15003 | 232683 | 1205 | 0 | 21.45803166 | -157.9712182 | 2022-08-19 04:20:54 | Honolulu, Hawaii, US | |
3951405 | 3951405 | 2022-08-17 | US | Hawaii | Honolulu | 15003 | 232683 | 1205 | 0 | 21.45803166 | -157.9712182 | 2022-08-18 04:21:11 | Honolulu, Hawaii, US | |
1488654 | 1488654 | 2022-07-26 | US | Indiana | Allen | 18003 | 110038 | 1205 | 0 | 41.09194313 | -85.06800636 | 2022-07-27 04:21:04 | Allen, Indiana, US | |
2595100 | 2595100 | 2022-07-25 | US | Indiana | Allen | 18003 | 110038 | 1205 | 0 | 41.09194313 | -85.06800636 | 2022-07-26 04:20:58 | Allen, Indiana, US | |
897215 | 897215 | 2022-07-24 | US | Indiana | Allen | 18003 | 109895 | 1205 | 0 | 41.09194313 | -85.06800636 | 2022-07-25 04:20:51 | Allen, Indiana, US | |
92209 | 92209 | 2022-07-23 | US | Indiana | Allen | 18003 | 109895 | 1205 | 0 | 41.09194313 | -85.06800636 | 2022-07-24 04:20:47 | Allen, Indiana, US | |
901231 | 901231 | 2022-07-22 | US | Indiana | Allen | 18003 | 109895 | 1205 | 0 | 41.09194313 | -85.06800636 | 2022-07-23 04:20:53 | Allen, Indiana, US | |
671367 | 671367 | 2022-07-21 | US | Indiana | Allen | 18003 | 109547 | 1205 | 0 | 41.09194313 | -85.06800636 | 2022-07-22 04:21:15 | Allen, Indiana, US | |
1609330 | 1609330 | 2022-07-20 | US | Indiana | Allen | 18003 | 109547 | 1205 | 0 | 41.09194313 | -85.06800636 | 2022-07-21 04:21:10 | Allen, Indiana, US | |
2331981 | 2331981 | 2022-05-08 | US | Colorado | Arapahoe | 8005 | 161684 | 1205 | 0 | 39.64977461 | -104.3353617 | 2022-05-09 04:20:54 | Arapahoe, Colorado, US | |
360943 | 360943 | 2022-05-07 | US | Colorado | Arapahoe | 8005 | 161566 | 1205 | 0 | 39.64977461 | -104.3353617 | 2022-05-08 04:20:49 | Arapahoe, Colorado, US | |
1398294 | 1398294 | 2022-05-06 | US | Colorado | Arapahoe | 8005 | 161471 | 1205 | 0 | 39.64977461 | -104.3353617 | 2022-05-07 04:21:09 | Arapahoe, Colorado, US | |
2600215 | 2600215 | 2022-05-05 | US | New Jersey | Burlington | 34005 | 105139 | 1205 | 0 | 39.87681124 | -74.66927768 | 2022-05-06 04:21:00 | Burlington, New Jersey, US | |
3267664 | 3267664 | 2022-05-04 | US | New Jersey | Burlington | 34005 | 104925 | 1205 | 0 | 39.87681124 | -74.66927768 | 2022-05-05 04:20:55 | Burlington, New Jersey, US | |
1868568 | 1868568 | 2022-03-10 | US | Texas | Fort Bend | 48157 | 178225 | 1205 | 0 | 29.52704478 | -95.77219463 | 2022-03-11 04:20:50 | Fort Bend, Texas, US | |
3674336 | 3674336 | 2022-02-15 | US | Pennsylvania | Lehigh | 42077 | 88309 | 1205 | 0 | 40.6154815 | -75.59435245 | 2022-02-16 04:21:10 | Lehigh, Pennsylvania, US | |
1364527 | 1364527 | 2022-02-08 | US | New Jersey | Mercer | 34021 | 73365 | 1205 | 0 | 40.28047017 | -74.70479631 | 2022-02-09 04:21:04 | Mercer, New Jersey, US | |
982111 | 982111 | 2022-02-01 | US | Texas | Lubbock | 48303 | 90550 | 1205 | 0 | 33.61008596 | -101.82047890000001 | 2022-02-02 04:21:09 | Lubbock, Texas, US | |
1228288 | 1228288 | 2022-01-24 | US | Delaware | New Castle | 10003 | 137494 | 1205 | 0 | 39.57992638 | -75.64054974 | 2022-01-25 04:21:05 | New Castle, Delaware, US | |
1229371 | 1229371 | 2022-01-24 | US | Minnesota | Ramsey | 27123 | 106676 | 1205 | 0 | 45.01625271 | -93.09872295 | 2022-01-25 04:21:05 | Ramsey, Minnesota, US | |
1141587 | 1141587 | 2022-01-23 | US | Delaware | New Castle | 10003 | 136824 | 1205 | 0 | 39.57992638 | -75.64054974 | 2022-01-24 04:21:12 | New Castle, Delaware, US | |
555646 | 555646 | 2022-01-16 | US | Georgia | Out of GA | 80013 | 61320 | 1205 | 0 | 34.91369188 | 0.0 | 2022-01-17 04:21:08 | Out of GA, Georgia, US | |
3841109 | 3841109 | 2022-01-15 | US | Colorado | Adams | 8001 | 125129 | 1205 | 0 | 39.87432092 | -104.3362578 | 2022-01-16 04:21:12 | Adams, Colorado, US | |
3841367 | 3841367 | 2022-01-15 | US | Georgia | Out of GA | 80013 | 61320 | 1205 | 0 | 34.91369188 | 0.0 | 2022-01-16 04:21:12 | Out of GA, Georgia, US | |
100182 | 100182 | 2022-01-14 | US | Georgia | Out of GA | 80013 | 61320 | 1205 | 0 | 34.91369188 | 0.0 | 2022-01-15 04:21:07 | Out of GA, Georgia, US | |
799025 | 799025 | 2021-12-22 | US | California | Ventura | 6111 | 107895 | 1205 | 0 | 34.44465746 | -119.09106129999999 | 2021-12-23 04:21:21 | Ventura, California, US | |
140903 | 140903 | 2021-12-04 | US | Tennessee | Davidson | 47037 | 125195 | 1205 | 0 | 36.17007426 | -86.78646056 | 2021-12-05 04:22:25 | Davidson, Tennessee, US | |
278430 | 278430 | 2021-11-03 | US | New York | Monroe | 36055 | 87079 | 1205 | 0 | 43.14638895 | -77.69322942 | 2021-11-04 04:22:20 | Monroe, New York, US | |
535353 | 535353 | 2021-10-27 | US | Colorado | El Paso | 8041 | 103394 | 1205 | 0 | 38.83240149 | -104.5251411 | 2021-10-28 04:22:08 | El Paso, Colorado, US | |
493240 | 493240 | 2021-10-14 | US | Massachusetts | Plymouth | 25023 | 57917 | 1205 | 0 | 41.94070556 | -70.80802823 | 2021-10-15 04:21:26 | Plymouth, Massachusetts, US | |
493978 | 493978 | 2021-10-14 | US | North Carolina | Mecklenburg | 37119 | 154435 | 1205 | 0 | 35.24469268 | -80.8317671 | 2021-10-15 04:21:26 | Mecklenburg, North Carolina, US | |
1334863 | 1334863 | 2021-09-28 | US | California | Stanislaus | 6099 | 81882 | 1205 | 0 | 37.55862499 | -120.9970722 | 2021-09-29 04:21:45 | Stanislaus, California, US | |
3014154 | 3014154 | 2021-09-22 | US | South Carolina | Greenville | 45045 | 97586 | 1205 | 0 | 34.89502264 | -82.37295012 | 2021-09-23 04:21:43 | Greenville, South Carolina, US | |
3451519 | 3451519 | 2021-09-10 | US | Pennsylvania | Lancaster | 42071 | 61773 | 1205 | 0 | 40.03904563 | -76.24770128 | 2021-09-11 04:21:30 | Lancaster, Pennsylvania, US | |
2911980 | 2911980 | 2021-06-17 | US | Georgia | Gwinnett | 13135 | 103020 | 1205 | 0 | 33.96044201 | -84.02137802 | 2021-06-18 04:22:16 | Gwinnett, Georgia, US | |
3244496 | 3244496 | 2021-04-21 | US | New Jersey | Morris | 34027 | 48904 | 1205 | 0 | 40.86095313 | -74.54553709999998 | 2021-04-22 04:20:53 | Morris, New Jersey, US | |
1304512 | 1304512 | 2021-04-01 | US | Ohio | Hamilton | 39061 | 76528 | 1205 | 0 | 39.19673558 | -84.54502924 | 2021-04-02 04:20:36 | Hamilton, Ohio, US | |
2360439 | 2360439 | 2021-03-08 | US | Illinois | DuPage | 17043 | 77960 | 1205 | 0 | 41.85116968 | -88.08642662 | 2021-03-09 05:28:19 | DuPage, Illinois, US | |
55777 | 55777 | 2021-03-07 | US | Illinois | DuPage | 17043 | 77882 | 1205 | 0 | 41.85116968 | -88.08642662 | 2021-03-08 05:24:48 | DuPage, Illinois, US | |
3668594 | 3668594 | 2021-03-06 | US | Illinois | DuPage | 17043 | 77796 | 1205 | 0 | 76591 | 41.85116968 | -88.08642662 | 2021-03-07 05:21:54 | DuPage, Illinois, US |
1617215 | 1617215 | 2021-03-05 | US | Illinois | DuPage | 17043 | 77506 | 1205 | 0 | 76301 | 41.85116968 | -88.08642662 | 2021-03-06 04:23:41 | DuPage, Illinois, US |
2639284 | 2639284 | 2021-02-11 | US | Maryland | Baltimore | 24005 | 48976 | 1205 | 0 | 47771 | 39.45784712 | -76.62911955 | 2021-02-12 05:23:29 | Baltimore, Maryland, US |
1760872 | 1760872 | 2021-01-24 | US | Maryland | Prince George's | 24033 | 65562 | 1205 | 0 | 64357 | 38.83070039 | -76.8496441 | 2021-01-25 05:22:16 | Prince George's, Maryland, US |
193098 | 193098 | 2021-01-11 | US | Texas | Cameron | 48061 | 35112 | 1205 | 0 | 29987 | 26.14524221 | -97.48140372 | 2021-01-12 05:22:15 | Cameron, Texas, US |
2120755 | 2120755 | 2020-12-20 | US | Illinois | Unassigned | 90017 | 282 | 1205 | 0 | 0 | 42.36542373 | 0.0 | 2020-12-21 05:27:58 | Unassigned, Illinois, US |
1990218 | 1990218 | 2020-11-09 | US | Massachusetts | Essex | 25009 | 26621 | 1205 | 0 | 25249 | 42.6687626 | -70.94687179 | 2020-11-10 05:40:07 | Essex, Massachusetts, US |
347281 | 347281 | 2020-09-14 | US | Texas | Bexar | 48029 | 58106 | 1205 | 0 | 48811 | 29.44928723 | -98.52019748 | 2020-09-15 03:22:50 | Bexar, Texas, US |
3163740 | 3163740 | 2020-09-06 | US | Nevada | Clark | 32003 | 61237 | 1205 | 0 | 60032 | 36.21458855 | -115.0130241 | 2020-09-07 04:28:30 | Clark, Nevada, US |
1267734 | 1267734 | 2020-06-05 | US | New Jersey | Hudson | 34017 | 18929 | 1205 | 0 | 17724 | 40.73766234 | -74.07515667 | 2020-06-06 02:33:00 | Hudson, New Jersey, 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]);