johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
88 rows where active = 2535 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
626121 | 626121 | 2021-07-10 | Russia | Saint Petersburg | 487921 | 17392 | 467994 | 2535 | 59.9606739 | 30.158655100000004 | 2021-07-11 04:21:43 | Saint Petersburg, Russia | ||
400475 | 400475 | 2021-06-29 | Russia | Khabarovsk Krai | 55340 | 481 | 52324 | 2535 | 51.6312684 | 136.121524 | 2021-06-30 04:21:41 | Khabarovsk Krai, Russia | ||
3970798 | 3970798 | 2021-06-11 | Russia | Sverdlovsk Oblast | 90439 | 3558 | 84346 | 2535 | 58.6414755 | 61.8021546 | 2021-06-12 04:22:22 | Sverdlovsk Oblast, Russia | ||
3255229 | 3255229 | 2021-03-02 | US | Indiana | Greene | 18055 | 2615 | 80 | 0 | 2535 | 39.03630547 | -86.96223202 | 2021-03-03 05:23:28 | Greene, Indiana, US |
2369428 | 2369428 | 2021-02-28 | US | Missouri | Nodaway | 29147 | 2559 | 24 | 0 | 2535 | 40.36079813 | -94.88133008 | 2021-03-01 05:23:01 | Nodaway, Missouri, US |
3067930 | 3067930 | 2021-02-27 | US | Missouri | Nodaway | 29147 | 2559 | 24 | 0 | 2535 | 40.36079813 | -94.88133008 | 2021-02-28 05:22:20 | Nodaway, Missouri, US |
2185514 | 2185514 | 2021-02-26 | US | Missouri | Nodaway | 29147 | 2559 | 24 | 0 | 2535 | 40.36079813 | -94.88133008 | 2021-02-27 05:22:28 | Nodaway, Missouri, US |
1859936 | 1859936 | 2021-02-25 | US | Missouri | Nodaway | 29147 | 2559 | 24 | 0 | 2535 | 40.36079813 | -94.88133008 | 2021-02-26 05:22:40 | Nodaway, Missouri, US |
282114 | 282114 | 2021-02-24 | US | Missouri | Nodaway | 29147 | 2559 | 24 | 0 | 2535 | 40.36079813 | -94.88133008 | 2021-02-25 05:24:57 | Nodaway, Missouri, US |
280114 | 280114 | 2021-02-24 | Haiti | 12430 | 249 | 9570 | 2535 | 18.9712 | -72.2852 | 2021-02-25 05:24:57 | Haiti | |||
185509 | 185509 | 2021-02-21 | US | West Virginia | Fayette | 54019 | 2605 | 70 | 0 | 2535 | 38.02974928 | -81.08286634 | 2021-02-22 05:24:21 | Fayette, West Virginia, US |
182794 | 182794 | 2021-02-21 | US | Georgia | Butts | 13035 | 2606 | 71 | 0 | 2535 | 33.283094500000004 | -83.95435040000002 | 2021-02-22 05:24:21 | Butts, Georgia, US |
1156203 | 1156203 | 2021-02-18 | US | Texas | Frio | 48163 | 2472 | 38 | 0 | 2535 | 28.86751206 | -99.10804207 | 2021-02-19 05:24:16 | Frio, Texas, US |
3604123 | 3604123 | 2021-02-17 | US | Texas | Frio | 48163 | 2472 | 38 | 0 | 2535 | 28.86751206 | -99.10804207 | 2021-02-18 05:22:58 | Frio, Texas, US |
3053658 | 3053658 | 2021-02-16 | US | West Virginia | Logan | 54045 | 2607 | 72 | 0 | 2535 | 37.8299889 | -81.93528571 | 2021-02-17 05:23:10 | Logan, West Virginia, US |
3053258 | 3053258 | 2021-02-16 | US | Texas | Frio | 48163 | 2472 | 38 | 0 | 2535 | 28.86751206 | -99.10804207 | 2021-02-17 05:23:10 | Frio, Texas, US |
3051484 | 3051484 | 2021-02-16 | US | Kansas | Miami | 20121 | 2568 | 33 | 0 | 2535 | 38.56383358 | -94.83832189 | 2021-02-17 05:23:10 | Miami, Kansas, US |
3051295 | 3051295 | 2021-02-16 | US | Indiana | Posey | 18129 | 2566 | 31 | 0 | 2535 | 38.02097333 | -87.86480429 | 2021-02-17 05:23:10 | Posey, Indiana, US |
3051079 | 3051079 | 2021-02-16 | US | Hawaii | Maui | 15009 | 2564 | 29 | 0 | 2535 | 20.86399628 | -156.56890969999995 | 2021-02-17 05:23:10 | Maui, Hawaii, US |
1341357 | 1341357 | 2021-02-15 | US | Texas | Frio | 48163 | 2472 | 38 | 0 | 2535 | 28.86751206 | -99.10804207 | 2021-02-16 05:24:38 | Frio, Texas, US |
1339583 | 1339583 | 2021-02-15 | US | Kansas | Miami | 20121 | 2568 | 33 | 0 | 2535 | 38.56383358 | -94.83832189 | 2021-02-16 05:24:38 | Miami, Kansas, US |
2286508 | 2286508 | 2021-02-14 | US | Texas | Frio | 48163 | 2472 | 38 | 0 | 2535 | 28.86751206 | -99.10804207 | 2021-02-15 05:24:49 | Frio, Texas, US |
2681429 | 2681429 | 2021-02-13 | US | Wyoming | Park | 56029 | 2560 | 25 | 0 | 2535 | 44.52157546 | -109.5852825 | 2021-02-14 05:23:43 | Park, Wyoming, US |
2680908 | 2680908 | 2021-02-13 | US | Texas | Frio | 48163 | 2472 | 38 | 0 | 2535 | 28.86751206 | -99.10804207 | 2021-02-14 05:23:43 | Frio, Texas, US |
3543062 | 3543062 | 2021-02-12 | US | Wyoming | Park | 56029 | 2560 | 25 | 0 | 2535 | 44.52157546 | -109.5852825 | 2021-02-13 05:22:12 | Park, Wyoming, US |
3540820 | 3540820 | 2021-02-12 | US | Kentucky | Bell | 21013 | 2568 | 33 | 0 | 2535 | 36.73355174 | -83.67766671 | 2021-02-13 05:22:12 | Bell, Kentucky, US |
2640645 | 2640645 | 2021-02-11 | US | Tennessee | DeKalb | 47041 | 2603 | 46 | 0 | 2535 | 35.97616272 | -85.83689361 | 2021-02-12 05:23:29 | DeKalb, Tennessee, US |
1527811 | 1527811 | 2021-02-09 | Germany | Mecklenburg-Vorpommern | 21351 | 579 | 18424 | 2535 | 53.6127 | 12.4296 | 2021-02-10 05:22:41 | Mecklenburg-Vorpommern, Germany | ||
1674729 | 1674729 | 2021-02-07 | US | New York | Wyoming | 36121 | 2583 | 48 | 0 | 2535 | 42.70145109 | -78.22199579 | 2021-02-08 05:22:39 | Wyoming, New York, US |
1591706 | 1591706 | 2021-02-05 | US | Wisconsin | Door | 55029 | 2558 | 23 | 0 | 2535 | 44.95856458 | -87.30002707 | 2021-02-06 05:23:55 | Door, Wisconsin, US |
791163 | 791163 | 2021-02-04 | US | Georgia | Decatur | 13087 | 2592 | 57 | 0 | 2535 | 30.87967778 | -84.57619536 | 2021-02-05 05:22:38 | Decatur, Georgia, US |
341718 | 341718 | 2021-02-03 | US | Kentucky | Muhlenberg | 21177 | 2577 | 42 | 0 | 2535 | 37.21425819 | -87.14632053 | 2021-02-04 05:22:26 | Muhlenberg, Kentucky, US |
1686288 | 1686288 | 2021-02-02 | US | Mississippi | Coahoma | 28027 | 2593 | 58 | 0 | 2535 | 34.22772299 | -90.60415045 | 2021-02-03 05:22:52 | Coahoma, Mississippi, US |
1461268 | 1461268 | 2021-01-31 | US | Louisiana | Morehouse | 22067 | 2596 | 61 | 0 | 2535 | 32.81686191 | -91.80421614 | 2021-02-01 05:22:53 | Morehouse, Louisiana, US |
2213148 | 2213148 | 2021-01-30 | US | Louisiana | Beauregard | 22011 | 2595 | 60 | 0 | 2535 | 30.64836518 | -93.34173616 | 2021-01-31 05:22:42 | Beauregard, Louisiana, US |
2212122 | 2212122 | 2021-01-30 | US | Arkansas | Baxter | 5005 | 2629 | 94 | 0 | 2535 | 36.28784385 | -92.33782872 | 2021-01-31 05:22:42 | Baxter, Arkansas, US |
1898635 | 1898635 | 2021-01-29 | US | Louisiana | Beauregard | 22011 | 2595 | 60 | 0 | 2535 | 30.64836518 | -93.34173616 | 2021-01-30 05:22:49 | Beauregard, Louisiana, US |
2484410 | 2484410 | 2021-01-28 | US | Ohio | Champaign | 39021 | 2584 | 49 | 0 | 2535 | 40.13923427 | -83.76875242 | 2021-01-29 05:22:23 | Champaign, Ohio, US |
13165 | 13165 | 2021-01-26 | US | Georgia | Liberty | 13179 | 2574 | 39 | 0 | 2535 | 31.82588896 | -81.49251135 | 2021-01-27 05:23:41 | Liberty, Georgia, US |
2569584 | 2569584 | 2021-01-25 | US | Missouri | Marion | 29127 | 2569 | 34 | 0 | 2535 | 39.80601912 | -91.62203062 | 2021-01-26 05:22:02 | Marion, Missouri, US |
1761216 | 1761216 | 2021-01-24 | US | Missouri | Marion | 29127 | 2569 | 34 | 0 | 2535 | 39.80601912 | -91.62203062 | 2021-01-25 05:22:16 | Marion, Missouri, US |
1094304 | 1094304 | 2021-01-20 | Russia | Kursk Oblast | 24297 | 336 | 21426 | 2535 | 51.6568453 | 36.4852695 | 2021-01-21 05:22:01 | Kursk Oblast, Russia | ||
3104278 | 3104278 | 2021-01-16 | US | South Dakota | Beadle | 46005 | 2573 | 38 | 0 | 2535 | 44.41464384 | -98.27858469 | 2021-01-17 05:22:17 | Beadle, South Dakota, US |
192902 | 192902 | 2021-01-11 | US | South Carolina | Williamsburg | 45089 | 2600 | 65 | 0 | 2535 | 33.62190129 | -79.72767442 | 2021-01-12 05:22:15 | Williamsburg, South Carolina, US |
190256 | 190256 | 2021-01-11 | Russia | Belgorod Oblast | 23867 | 282 | 21050 | 2535 | 50.7080119 | 37.5837615 | 2021-01-12 05:22:15 | Belgorod Oblast, Russia | ||
3900189 | 3900189 | 2021-01-09 | Russia | Novosibirsk Oblast | 29198 | 1040 | 25623 | 2535 | 54.9720169 | 79.48139240000002 | 2021-01-10 05:22:12 | Novosibirsk Oblast, Russia | ||
1062994 | 1062994 | 2021-01-04 | US | Indiana | Whitley | 18183 | 2564 | 29 | 0 | 2535 | 41.13863784 | -85.50791236 | 2021-01-05 05:21:49 | Whitley, Indiana, US |
2229334 | 2229334 | 2021-01-02 | US | Mississippi | Lincoln | 28085 | 2614 | 79 | 0 | 2535 | 31.53288662 | -90.45391915 | 2021-01-03 05:22:52 | Lincoln, Mississippi, US |
3772789 | 3772789 | 2020-12-22 | US | Tennessee | Cheatham | 47021 | 2564 | 21 | 0 | 2535 | 36.26136216 | -87.08903581 | 2020-12-23 05:22:03 | Cheatham, Tennessee, US |
1035816 | 1035816 | 2020-12-15 | US | Kentucky | Nelson | 21179 | 2547 | 12 | 0 | 2535 | 37.80335779 | -85.4657193 | 2020-12-16 05:28:04 | Nelson, Kentucky, US |
1754440 | 1754440 | 2020-12-14 | US | Texas | Nacogdoches | 48347 | 2843 | 89 | 0 | 2535 | 31.62017125 | -94.61803994 | 2020-12-15 05:26:38 | Nacogdoches, Texas, US |
1752793 | 1752793 | 2020-12-14 | US | Louisiana | St. Mary | 22101 | 2633 | 98 | 0 | 2535 | 29.69262097 | -91.44702164 | 2020-12-15 05:26:38 | St. Mary, Louisiana, US |
1751165 | 1751165 | 2020-12-14 | France | Mayotte | 5551 | 52 | 2964 | 2535 | -12.8275 | 45.166244 | 2020-12-15 05:26:38 | Mayotte, France | ||
3847685 | 3847685 | 2020-12-13 | France | Mayotte | 5551 | 52 | 2964 | 2535 | -12.8275 | 45.166244 | 2020-12-14 05:26:27 | Mayotte, France | ||
846328 | 846328 | 2020-12-12 | US | Georgia | Catoosa | 13047 | 2570 | 35 | 0 | 2535 | 34.89872298 | -85.13757014 | 2020-12-13 05:27:20 | Catoosa, Georgia, US |
845467 | 845467 | 2020-12-12 | France | Mayotte | 5551 | 52 | 2964 | 2535 | -12.8275 | 45.166244 | 2020-12-13 05:27:20 | Mayotte, France | ||
862254 | 862254 | 2020-12-11 | US | Maryland | St. Mary's | 24037 | 2608 | 73 | 0 | 2535 | 38.30058422 | -76.60629279999998 | 2020-12-12 05:26:19 | St. Mary's, Maryland, US |
1603480 | 1603480 | 2020-12-10 | US | Utah | Summit | 49043 | 2540 | 5 | 0 | 2535 | 40.86688146 | -110.9535882 | 2020-12-11 05:26:59 | Summit, Utah, US |
1822311 | 1822311 | 2020-12-08 | US | Wisconsin | Clark | 55019 | 2582 | 47 | 0 | 2535 | 44.73483377 | -90.61207486 | 2020-12-09 05:28:01 | Clark, Wisconsin, US |
3567447 | 3567447 | 2020-11-29 | US | Georgia | Unassigned | 90013 | 2536 | 1 | 0 | 2535 | 34.91369188 | 0.0 | 2020-11-30 05:26:13 | Unassigned, Georgia, US |
923567 | 923567 | 2020-11-26 | El Salvador | 38228 | 1098 | 34595 | 2535 | 13.7942 | -88.8965 | 2020-11-27 05:26:53 | El Salvador | |||
1973470 | 1973470 | 2020-11-25 | US | Georgia | Walker | 13295 | 2586 | 51 | 0 | 2535 | 34.73376362 | -85.30165174 | 2020-11-26 05:27:44 | Walker, Georgia, US |
1351998 | 1351998 | 2020-11-24 | US | Michigan | Van Buren | 26159 | 2569 | 34 | 0 | 2535 | 42.25190229 | -86.01939087 | 2020-11-25 05:27:20 | Van Buren, Michigan, US |
679392 | 679392 | 2020-11-23 | US | Indiana | Grant | 18053 | 2587 | 52 | 0 | 2535 | 40.51587228 | -85.65468702 | 2020-11-24 05:27:31 | Grant, Indiana, US |
678996 | 678996 | 2020-11-23 | US | Florida | Flagler | 12035 | 2577 | 42 | 0 | 2535 | 29.45933576 | -81.31508595 | 2020-11-24 05:27:31 | Flagler, Florida, US |
3193391 | 3193391 | 2020-11-22 | US | Virginia | Suffolk | 51800 | 2615 | 80 | 0 | 2535 | 36.70155394 | -76.63603554 | 2020-11-23 05:25:26 | Suffolk, Virginia, US |
3191607 | 3191607 | 2020-11-22 | US | Michigan | Eaton | 26045 | 2564 | 29 | 0 | 2535 | 42.59599185 | -84.83740035 | 2020-11-23 05:25:26 | Eaton, Michigan, US |
3838417 | 3838417 | 2020-11-21 | US | Missouri | Pettis | 29159 | 2564 | 29 | 0 | 2535 | 38.72798918 | -93.28471706 | 2020-11-22 05:25:45 | Pettis, Missouri, US |
3838101 | 3838101 | 2020-11-21 | US | Michigan | Eaton | 26045 | 2564 | 29 | 0 | 2535 | 42.59599185 | -84.83740035 | 2020-11-22 05:25:45 | Eaton, Michigan, US |
2915664 | 2915664 | 2020-11-14 | US | Arkansas | Hot Spring | 5059 | 2574 | 39 | 0 | 2535 | 34.31709259 | -92.95396325 | 2020-11-15 05:26:53 | Hot Spring, Arkansas, US |
2914923 | 2914923 | 2020-11-14 | Brazil | Maranhao | 189501 | 4171 | 182795 | 2535 | -4.9609 | -45.2744 | 2020-11-15 05:26:53 | Maranhao, Brazil | ||
2919650 | 2919650 | 2020-11-04 | US | Arkansas | Crittenden | 5035 | 2588 | 53 | 0 | 2535 | 35.21247318 | -90.30839406 | 2020-11-05 06:05:03 | Crittenden, Arkansas, US |
3992960 | 3992960 | 2020-10-20 | US | North Carolina | Sampson | 37163 | 2563 | 28 | 0 | 2535 | 34.98820368 | -78.36914061 | 2020-10-21 04:24:14 | Sampson, North Carolina, US |
1044811 | 1044811 | 2020-10-07 | US | Tennessee | Washington | 47179 | 2543 | 38 | 0 | 2535 | 36.29472368 | -82.49454720000001 | 2020-10-08 04:23:56 | Washington, Tennessee, US |
1042859 | 1042859 | 2020-10-07 | US | Illinois | Unassigned | 90017 | 2784 | 249 | 0 | 2535 | 42.36542373 | 0.0 | 2020-10-08 04:23:56 | Unassigned, Illinois, US |
1049190 | 1049190 | 2020-09-30 | US | Virginia | Portsmouth | 51740 | 2594 | 59 | 0 | 2535 | 36.85914825 | -76.35971629 | 2020-10-01 04:23:42 | Portsmouth, Virginia, US |
2614303 | 2614303 | 2020-09-26 | Senegal | 14869 | 306 | 12028 | 2535 | 14.4974 | -14.4524 | 2020-09-27 04:23:00 | Senegal | |||
2871054 | 2871054 | 2020-09-13 | US | North Carolina | Randolph | 37151 | 2584 | 49 | 0 | 2535 | 35.71015088 | -79.80570339 | 2020-09-14 04:26:00 | Randolph, North Carolina, US |
2171833 | 2171833 | 2020-09-09 | Spain | Cantabria | 5049 | 227 | 2287 | 2535 | 43.1828 | -3.9878 | 2020-09-10 04:29:01 | Cantabria, Spain | ||
1523988 | 1523988 | 2020-08-28 | US | Georgia | Houston | 13153 | 2600 | 65 | 0 | 2535 | 32.45802497 | -83.66879087 | 2020-08-29 04:28:19 | Houston, Georgia, US |
3565182 | 3565182 | 2020-08-25 | US | Oregon | Umatilla | 41059 | 2570 | 35 | 0 | 2535 | 45.59073056 | -118.7353826 | 2020-08-26 04:28:11 | Umatilla, Oregon, US |
206659 | 206659 | 2020-08-19 | US | Alaska | Anchorage | 2020 | 2551 | 16 | 0 | 2535 | 61.14998174 | -149.14269860000005 | 2020-08-20 04:27:43 | Anchorage, Alaska, US |
3792499 | 3792499 | 2020-08-05 | US | Georgia | Unassigned | 90013 | 2545 | 10 | 0 | 2535 | 34.91369188 | 0.0 | 2020-08-06 04:35:02 | Unassigned, Georgia, US |
2958628 | 2958628 | 2020-07-29 | Germany | Nordrhein-Westfalen | 47965 | 1730 | 43700 | 2535 | 51.4332 | 7.6616 | 2020-07-30 04:35:05 | Nordrhein-Westfalen, Germany | ||
175142 | 175142 | 2020-07-27 | US | Missouri | Jackson | 29095 | 2591 | 56 | 0 | 2535 | 39.01002188 | -94.34724536 | 2020-07-28 04:58:43 | Jackson, Missouri, US |
62291 | 62291 | 2020-07-23 | Greece | 4110 | 201 | 1374 | 2535 | 39.0742 | 21.8243 | 2020-07-24 05:30:40 | Greece | |||
364992 | 364992 | 2020-07-16 | US | Maryland | Frederick | 24021 | 2655 | 120 | 0 | 2535 | 39.47296601 | -77.39999394 | 2020-07-17 04:34:50 | Frederick, Maryland, US |
2386269 | 2386269 | 2020-06-16 | US | Colorado | Weld | 8123 | 2737 | 133 | 0 | 2535 | 40.55499405 | -104.39296209999999 | 2020-06-17 04:33:21 | Weld, Colorado, 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]);