johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
67 rows where active = 3121 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3030532 | 3030532 | 2021-06-16 | Russia | Sakha (Yakutiya) Republic | 40044 | 723 | 36200 | 3121 | 66.941626 | 129.642371 | 2021-06-17 04:22:36 | Sakha (Yakutiya) Republic, Russia | ||
888353 | 888353 | 2021-04-26 | Russia | Orenburg Oblast | 42068 | 835 | 38112 | 3121 | 52.02692620000001 | 54.7276647 | 2021-04-27 04:20:52 | Orenburg Oblast, Russia | ||
2247336 | 2247336 | 2021-04-07 | India | Chandigarh | 29197 | 388 | 25688 | 3121 | 30.733839 | 76.76827800000002 | 2021-04-08 04:21:13 | Chandigarh, India | ||
3643481 | 3643481 | 2021-03-30 | Guinea | 19793 | 125 | 16547 | 3121 | 9.9456 | -9.6966 | 2021-03-31 04:26:25 | Guinea | |||
3420883 | 3420883 | 2021-03-19 | India | Rajasthan | 324503 | 2796 | 318586 | 3121 | 26.583423 | 73.847973 | 2021-03-20 05:25:46 | Rajasthan, India | ||
1090900 | 1090900 | 2021-03-03 | US | Georgia | Liberty | 13179 | 3174 | 53 | 0 | 3121 | 31.82588896 | -81.49251135 | 2021-03-04 05:24:24 | Liberty, Georgia, US |
283591 | 283591 | 2021-02-24 | US | Virginia | Tazewell | 51185 | 3163 | 42 | 0 | 3121 | 37.12191123 | -81.56685568 | 2021-02-25 05:24:57 | Tazewell, Virginia, US |
282674 | 282674 | 2021-02-24 | US | Ohio | Ottawa | 39123 | 3196 | 75 | 0 | 3121 | 41.53781826 | -83.0940185 | 2021-02-25 05:24:57 | Ottawa, Ohio, US |
530955 | 530955 | 2021-02-22 | Russia | Tatarstan Republic | 17656 | 316 | 14219 | 3121 | 55.7648572 | 52.43104273 | 2021-02-23 05:23:41 | Tatarstan Republic, Russia | ||
2678881 | 2678881 | 2021-02-13 | US | Indiana | Adams | 18001 | 3169 | 48 | 0 | 3121 | 40.7457653 | -84.93671406 | 2021-02-14 05:23:43 | Adams, Indiana, US |
1463217 | 1463217 | 2021-01-31 | US | Washington | Whitman | 53075 | 3157 | 36 | 0 | 3121 | 46.90022523 | -117.5241763 | 2021-02-01 05:22:53 | Whitman, Washington, US |
2215125 | 2215125 | 2021-01-30 | US | Washington | Whitman | 53075 | 3157 | 36 | 0 | 3121 | 46.90022523 | -117.5241763 | 2021-01-31 05:22:42 | Whitman, Washington, US |
2484704 | 2484704 | 2021-01-28 | US | Puerto Rico | Guaynabo | 72061 | 3121 | 0 | 0 | 3121 | 18.345114 | -66.11452299999999 | 2021-01-29 05:22:23 | Guaynabo, Puerto Rico, US |
3156543 | 3156543 | 2021-01-27 | US | Tennessee | Hardeman | 47069 | 3214 | 56 | 0 | 3121 | 35.20772017 | -88.99161161 | 2021-01-28 05:22:24 | Hardeman, Tennessee, US |
13358 | 13358 | 2021-01-26 | US | Illinois | Montgomery | 17135 | 3174 | 53 | 0 | 3121 | 39.23198845 | -89.47809254 | 2021-01-27 05:23:41 | Montgomery, Illinois, US |
2570576 | 2570576 | 2021-01-25 | US | Tennessee | Carroll | 47017 | 3260 | 62 | 0 | 3121 | 35.97366108 | -88.45189331 | 2021-01-26 05:22:02 | Carroll, Tennessee, US |
1762208 | 1762208 | 2021-01-24 | US | Tennessee | Carroll | 47017 | 3254 | 61 | 0 | 3121 | 35.97366108 | -88.45189331 | 2021-01-25 05:22:16 | Carroll, Tennessee, US |
1761669 | 1761669 | 2021-01-24 | US | North Carolina | Yadkin | 37197 | 3156 | 35 | 0 | 3121 | 36.16222629 | -80.66239436 | 2021-01-25 05:22:16 | Yadkin, North Carolina, US |
437975 | 437975 | 2021-01-21 | US | Oregon | Linn | 41043 | 3170 | 49 | 0 | 3121 | 44.48899494 | -122.5373154 | 2021-01-22 05:22:10 | Linn, Oregon, US |
191540 | 191540 | 2021-01-11 | US | Kentucky | Whitley | 21235 | 3131 | 10 | 0 | 3121 | 36.75700531 | -84.14541217 | 2021-01-12 05:22:15 | Whitley, Kentucky, US |
2627547 | 2627547 | 2021-01-10 | US | Michigan | Shiawassee | 26155 | 3181 | 60 | 0 | 3121 | 42.95392800000001 | -84.14585902 | 2021-01-11 05:21:50 | Shiawassee, Michigan, US |
3902379 | 3902379 | 2021-01-09 | US | North Dakota | Stutsman | 38093 | 3167 | 71 | 0 | 3121 | 46.97962541 | -98.95637318 | 2021-01-10 05:22:12 | Stutsman, North Dakota, US |
3901635 | 3901635 | 2021-01-09 | US | Michigan | Shiawassee | 26155 | 3181 | 60 | 0 | 3121 | 42.95392800000001 | -84.14585902 | 2021-01-10 05:22:12 | Shiawassee, Michigan, US |
157481 | 157481 | 2021-01-08 | US | West Virginia | Raleigh | 54081 | 3153 | 32 | 0 | 3121 | 37.76936795 | -81.2456041 | 2021-01-09 05:22:18 | Raleigh, West Virginia, US |
1012630 | 1012630 | 2020-12-30 | US | North Carolina | Lenoir | 37107 | 3191 | 70 | 0 | 3121 | 35.24032589999999 | -77.64245615 | 2020-12-31 05:22:49 | Lenoir, North Carolina, US |
3779647 | 3779647 | 2020-12-27 | US | Minnesota | Polk | 27119 | 3169 | 48 | 0 | 3121 | 47.77372465 | -96.40134647 | 2020-12-28 05:22:06 | Polk, Minnesota, US |
1901421 | 1901421 | 2020-12-18 | Russia | Udmurt Republic | 16870 | 352 | 13397 | 3121 | 57.1961165 | 52.69598320000001 | 2020-12-19 05:27:52 | Udmurt Republic, Russia | ||
1751813 | 1751813 | 2020-12-14 | US | California | Lassen | 6035 | 3613 | 5 | 0 | 3121 | 40.67311306 | -120.59350990000002 | 2020-12-15 05:26:38 | Lassen, California, US |
3848333 | 3848333 | 2020-12-13 | US | California | Lassen | 6035 | 3501 | 5 | 0 | 3121 | 40.67311306 | -120.59350990000002 | 2020-12-14 05:26:27 | Lassen, California, US |
846300 | 846300 | 2020-12-12 | US | Florida | Unassigned | 90012 | 3121 | 0 | 0 | 3121 | 30.86747479 | 0.0 | 2020-12-13 05:27:20 | Unassigned, Florida, US |
846115 | 846115 | 2020-12-12 | US | California | Lassen | 6035 | 3475 | 5 | 0 | 3121 | 40.67311306 | -120.59350990000002 | 2020-12-13 05:27:20 | Lassen, California, US |
861222 | 861222 | 2020-12-11 | US | California | Lassen | 6035 | 3462 | 5 | 0 | 3121 | 40.67311306 | -120.59350990000002 | 2020-12-12 05:26:19 | Lassen, California, US |
860877 | 860877 | 2020-12-11 | Russia | Kaliningrad Oblast | 13659 | 132 | 10406 | 3121 | 54.7293041 | 21.1489473 | 2020-12-12 05:26:19 | Kaliningrad Oblast, Russia | ||
1006141 | 1006141 | 2020-12-06 | Colombia | Cundinamarca | 55177 | 1455 | 50601 | 3121 | 5.026 | -74.03 | 2020-12-07 05:26:14 | Cundinamarca, Colombia | ||
3568306 | 3568306 | 2020-11-29 | US | Minnesota | Otter Tail | 27111 | 3143 | 22 | 0 | 3121 | 46.40846929 | -95.70835255 | 2020-11-30 05:26:13 | Otter Tail, Minnesota, US |
3190020 | 3190020 | 2020-11-22 | Japan | Osaka | 17648 | 277 | 14250 | 3121 | 34.620965000000005 | 135.507481 | 2020-11-23 05:25:26 | Osaka, Japan | ||
2703812 | 2703812 | 2020-11-20 | US | North Carolina | Duplin | 37061 | 3177 | 56 | 0 | 3121 | 34.93449805 | -77.93140529 | 2020-11-21 05:25:51 | Duplin, North Carolina, US |
823855 | 823855 | 2020-11-19 | US | North Carolina | Caldwell | 37027 | 3142 | 21 | 0 | 3121 | 35.95204977 | -81.54799522 | 2020-11-20 05:26:28 | Caldwell, North Carolina, US |
123431 | 123431 | 2020-11-18 | US | Florida | Sumter | 12119 | 3212 | 91 | 0 | 3121 | 28.70181754 | -82.0794267 | 2020-11-19 05:25:23 | Sumter, Florida, US |
3441262 | 3441262 | 2020-11-11 | US | Arizona | Santa Cruz | 4023 | 3187 | 66 | 0 | 3121 | 31.52508998 | -110.8479088 | 2020-11-12 05:25:55 | Santa Cruz, Arizona, US |
3304499 | 3304499 | 2020-11-02 | Sweden | Dalarna | 3306 | 185 | 0 | 3121 | 61.0917 | 14.6664 | 2020-11-03 06:00:16 | Dalarna, Sweden | ||
3409748 | 3409748 | 2020-11-01 | Sweden | Dalarna | 3306 | 185 | 0 | 3121 | 61.0917 | 14.6664 | 2020-11-02 05:25:04 | Dalarna, Sweden | ||
2080712 | 2080712 | 2020-10-31 | US | Georgia | Dougherty | 13095 | 3312 | 191 | 0 | 3121 | 31.53328528 | -84.21722377 | 2020-11-01 04:36:19 | Dougherty, Georgia, US |
2080237 | 2080237 | 2020-10-31 | Sweden | Dalarna | 3306 | 185 | 0 | 3121 | 61.0917 | 14.6664 | 2020-11-01 04:36:19 | Dalarna, Sweden | ||
2243690 | 2243690 | 2020-10-30 | Sweden | Dalarna | 3306 | 185 | 0 | 3121 | 61.0917 | 14.6664 | 2020-10-31 04:24:44 | Dalarna, Sweden | ||
211301 | 211301 | 2020-10-29 | US | Indiana | Clark | 18019 | 3188 | 67 | 0 | 3121 | 38.48015445 | -85.70510334 | 2020-10-30 04:24:49 | Clark, Indiana, US |
757849 | 757849 | 2020-10-28 | US | Wisconsin | Manitowoc | 55071 | 3132 | 11 | 0 | 3121 | 44.11946801 | -87.80928853 | 2020-10-29 04:24:49 | Manitowoc, Wisconsin, US |
1029173 | 1029173 | 2020-10-17 | US | South Carolina | Orangeburg | 45075 | 3250 | 129 | 0 | 3121 | 33.4391073 | -80.79886287 | 2020-10-18 04:24:25 | Orangeburg, South Carolina, US |
786977 | 786977 | 2020-10-15 | US | Colorado | Douglas | 8035 | 3716 | 65 | 0 | 3121 | 39.33133796 | -104.930001 | 2020-10-16 04:24:01 | Douglas, Colorado, US |
1044534 | 1044534 | 2020-10-07 | US | Puerto Rico | Carolina | 72031 | 3121 | 0 | 0 | 3121 | 18.374986 | -65.95683100000001 | 2020-10-08 04:23:56 | Carolina, Puerto Rico, US |
3120195 | 3120195 | 2020-10-06 | US | Puerto Rico | Carolina | 72031 | 3121 | 0 | 0 | 3121 | 18.374986 | -65.95683100000001 | 2020-10-07 04:23:40 | Carolina, Puerto Rico, US |
3118172 | 3118172 | 2020-10-06 | US | Florida | Hernando | 12053 | 3259 | 138 | 0 | 3121 | 28.55364461 | -82.42700204 | 2020-10-07 04:23:40 | Hernando, Florida, US |
2584265 | 2584265 | 2020-09-27 | US | North Carolina | Catawba | 37035 | 3173 | 52 | 0 | 3121 | 35.66211129 | -81.2132617 | 2020-09-28 04:23:00 | Catawba, North Carolina, US |
1108337 | 1108337 | 2020-09-02 | US | South Carolina | Anderson | 45007 | 3246 | 125 | 0 | 3121 | 34.51828081 | -82.63959517 | 2020-09-03 04:28:22 | Anderson, South Carolina, US |
2060669 | 2060669 | 2020-09-01 | US | Georgia | Forsyth | 13117 | 3154 | 33 | 0 | 3121 | 34.22604035 | -84.12315129999998 | 2020-09-02 04:28:25 | Forsyth, Georgia, US |
2511973 | 2511973 | 2020-08-27 | US | Mississippi | Harrison | 28047 | 3174 | 53 | 0 | 3121 | 30.51359752 | -89.12467576 | 2020-08-28 04:28:11 | Harrison, Mississippi, US |
2991396 | 2991396 | 2020-08-24 | Netherlands | Overijssel | 3444 | 313 | 0 | 3121 | 52.444558 | 6.441722 | 2020-08-25 04:28:02 | Overijssel, Netherlands | ||
3179083 | 3179083 | 2020-08-18 | US | Indiana | Hamilton | 18057 | 3231 | 110 | 0 | 3121 | 40.07306535 | -86.05244729 | 2020-08-19 04:27:00 | Hamilton, Indiana, US |
3534420 | 3534420 | 2020-08-12 | US | Tennessee | Unassigned | 90047 | 383 | 3 | 0 | 3121 | 36.55606529 | 0.0 | 2020-08-13 04:29:15 | Unassigned, Tennessee, US |
3531626 | 3531626 | 2020-08-12 | Qatar | 113938 | 190 | 110627 | 3121 | 25.3548 | 51.1839 | 2020-08-13 04:29:15 | Qatar | |||
1925950 | 1925950 | 2020-07-30 | US | Michigan | Genesee | 26049 | 3415 | 294 | 0 | 3121 | 43.02244215 | -83.70589709 | 2020-07-31 04:35:18 | Genesee, Michigan, US |
1706195 | 1706195 | 2020-07-21 | US | New York | Onondaga | 36067 | 3312 | 191 | 0 | 3121 | 43.00491923 | -76.19971155 | 2020-07-22 04:34:42 | Onondaga, New York, US |
2232062 | 2232062 | 2020-07-03 | US | Indiana | Elkhart | 18039 | 3164 | 43 | 0 | 3121 | 41.59761169 | -85.85875695 | 2020-07-04 04:33:51 | Elkhart, Indiana, US |
2974154 | 2974154 | 2020-06-30 | US | Iowa | Woodbury | 19193 | 3165 | 44 | 0 | 3121 | 42.38979414 | -96.0459439 | 2020-07-01 04:33:52 | Woodbury, Iowa, US |
1134562 | 1134562 | 2020-06-26 | US | New Mexico | McKinley | 35031 | 3287 | 166 | 0 | 3121 | 35.58007720000001 | -108.262245 | 2020-06-27 04:33:35 | McKinley, New Mexico, US |
2898499 | 2898499 | 2020-05-09 | US | Tennessee | Shelby | 47157 | 3227 | 68 | 0 | 3121 | 35.1864775 | -89.89692423 | 2020-05-10 02:32:30 | Shelby, Tennessee, US |
3293517 | 3293517 | 2020-05-07 | US | Georgia | Fulton | 13121 | 3258 | 137 | 0 | 3121 | 33.79216944 | -84.46319413 | 2020-05-08 02:32:32 | Fulton, Georgia, 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]);