johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where confirmed = 12400 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3938811 | 3938811 | 2022-12-09 | US | Puerto Rico | Moca | 72099 | 12400 | 0 | 0 | 18.377805 | -67.080952 | 2022-12-10 04:21:02 | Moca, Puerto Rico, US | |
1967175 | 1967175 | 2022-11-30 | US | Oklahoma | Sequoyah | 40135 | 12400 | 111 | 0 | 35.49447108 | -94.75463785 | 2022-12-01 04:21:03 | Sequoyah, Oklahoma, US | |
2559189 | 2559189 | 2022-11-29 | US | Oklahoma | Sequoyah | 40135 | 12400 | 111 | 0 | 35.49447108 | -94.75463785 | 2022-11-30 04:21:07 | Sequoyah, Oklahoma, US | |
1242263 | 1242263 | 2022-11-28 | US | Oklahoma | Sequoyah | 40135 | 12400 | 111 | 0 | 35.49447108 | -94.75463785 | 2022-11-29 04:21:05 | Sequoyah, Oklahoma, US | |
3554251 | 3554251 | 2022-11-27 | US | Oklahoma | Sequoyah | 40135 | 12400 | 111 | 0 | 35.49447108 | -94.75463785 | 2022-11-28 04:21:02 | Sequoyah, Oklahoma, US | |
2102731 | 2102731 | 2022-11-26 | US | Oklahoma | Sequoyah | 40135 | 12400 | 111 | 0 | 35.49447108 | -94.75463785 | 2022-11-27 04:21:05 | Sequoyah, Oklahoma, US | |
490222 | 490222 | 2022-11-25 | US | Oklahoma | Sequoyah | 40135 | 12400 | 111 | 0 | 35.49447108 | -94.75463785 | 2022-11-26 04:21:11 | Sequoyah, Oklahoma, US | |
3526051 | 3526051 | 2022-11-24 | US | Oklahoma | Sequoyah | 40135 | 12400 | 111 | 0 | 35.49447108 | -94.75463785 | 2022-11-25 04:21:06 | Sequoyah, Oklahoma, US | |
1622019 | 1622019 | 2022-11-22 | US | Minnesota | McLeod | 27085 | 12400 | 118 | 0 | 44.82367677 | -94.27287017 | 2022-11-23 04:21:06 | McLeod, Minnesota, US | |
3461907 | 3461907 | 2022-11-21 | US | Minnesota | McLeod | 27085 | 12400 | 118 | 0 | 44.82367677 | -94.27287017 | 2022-11-22 04:20:47 | McLeod, Minnesota, US | |
1642092 | 1642092 | 2022-11-20 | US | Minnesota | McLeod | 27085 | 12400 | 118 | 0 | 44.82367677 | -94.27287017 | 2022-11-21 04:21:05 | McLeod, Minnesota, US | |
2065649 | 2065649 | 2022-11-19 | US | Minnesota | McLeod | 27085 | 12400 | 118 | 0 | 44.82367677 | -94.27287017 | 2022-11-20 04:21:08 | McLeod, Minnesota, US | |
1757043 | 1757043 | 2022-11-18 | US | Minnesota | McLeod | 27085 | 12400 | 118 | 0 | 44.82367677 | -94.27287017 | 2022-11-19 04:21:14 | McLeod, Minnesota, US | |
3028036 | 3028036 | 2022-11-17 | US | Minnesota | McLeod | 27085 | 12400 | 118 | 0 | 44.82367677 | -94.27287017 | 2022-11-18 04:21:15 | McLeod, Minnesota, US | |
797398 | 797398 | 2022-10-24 | US | Tennessee | Obion | 47131 | 12400 | 206 | 0 | 36.35732446 | -89.14921589 | 2022-10-25 04:21:53 | Obion, Tennessee, US | |
2162460 | 2162460 | 2022-10-16 | US | Tennessee | Cheatham | 47021 | 12400 | 135 | 0 | 36.26136216 | -87.08903581 | 2022-10-17 04:20:31 | Cheatham, Tennessee, US | |
518657 | 518657 | 2022-10-15 | US | Tennessee | Cheatham | 47021 | 12400 | 135 | 0 | 36.26136216 | -87.08903581 | 2022-10-16 04:22:39 | Cheatham, Tennessee, US | |
2998043 | 2998043 | 2022-10-01 | US | Puerto Rico | Isabela | 72071 | 12400 | 0 | 0 | 18.44981 | -67.005093 | 2022-10-02 04:21:23 | Isabela, Puerto Rico, US | |
3746647 | 3746647 | 2022-09-07 | US | Louisiana | St. John the Baptist | 22095 | 12400 | 185 | 0 | 30.12597499 | -90.4753503 | 2022-09-08 04:21:02 | St. John the Baptist, Louisiana, US | |
2856290 | 2856290 | 2022-08-22 | US | Virginia | Wise | 51195 | 12400 | 204 | 0 | 36.9746148 | -82.62410519 | 2022-08-23 04:20:56 | Wise, Virginia, US | |
962032 | 962032 | 2022-07-19 | US | Texas | Jim Wells | 48249 | 12400 | 211 | 0 | 27.73103938 | -98.0904705 | 2022-07-20 04:20:59 | Jim Wells, Texas, US | |
2050789 | 2050789 | 2022-05-25 | US | Tennessee | Campbell | 47013 | 12400 | 169 | 0 | 36.40355516 | -84.1510856 | 2022-05-26 04:20:50 | Campbell, Tennessee, US | |
2599163 | 2599163 | 2022-05-05 | US | Indiana | Marshall | 18099 | 12400 | 197 | 0 | 41.32467367 | -86.26185087 | 2022-05-06 04:21:00 | Marshall, Indiana, US | |
3266612 | 3266612 | 2022-05-04 | US | Indiana | Marshall | 18099 | 12400 | 197 | 0 | 41.32467367 | -86.26185087 | 2022-05-05 04:20:55 | Marshall, Indiana, US | |
2642746 | 2642746 | 2022-02-14 | US | Illinois | Grundy | 17063 | 12400 | 130 | 0 | 41.28569601 | -88.41905692 | 2022-02-15 04:21:09 | Grundy, Illinois, US | |
784212 | 784212 | 2021-12-13 | US | Mississippi | Lauderdale | 28075 | 12400 | 323 | 0 | 32.40419769 | -88.66229662 | 2021-12-14 04:22:38 | Lauderdale, Mississippi, US | |
3404951 | 3404951 | 2021-11-30 | US | West Virginia | Raleigh | 54081 | 12400 | 196 | 0 | 37.76936795 | -81.2456041 | 2021-12-01 04:22:29 | Raleigh, West Virginia, US | |
247706 | 247706 | 2021-08-17 | US | Ohio | Allen | 39003 | 12400 | 251 | 0 | 40.77285242 | -84.10802343 | 2021-08-18 04:21:35 | Allen, Ohio, US | |
297125 | 297125 | 2021-07-15 | US | Indiana | Monroe | 18105 | 12400 | 178 | 0 | 39.16130004 | -86.52414358 | 2021-07-16 04:21:22 | Monroe, Indiana, US | |
2071996 | 2071996 | 2021-07-02 | Mexico | Chiapas | 12400 | 1678 | 0 | 10722 | 16.7569 | -93.1292 | 2021-07-03 04:21:37 | Chiapas, Mexico | ||
2340498 | 2340498 | 2021-06-15 | US | Indiana | LaPorte | 18091 | 12400 | 221 | 0 | 41.54366008 | -86.74072188 | 2021-06-16 04:22:32 | LaPorte, Indiana, US | |
1313370 | 1313370 | 2021-05-26 | US | Texas | Rockwall | 48397 | 12400 | 154 | 0 | 32.89779518 | -96.40771592 | 2021-05-27 04:20:59 | Rockwall, Texas, US | |
647093 | 647093 | 2021-05-05 | US | Indiana | Vigo | 18167 | 12400 | 244 | 0 | 39.42944561 | -87.39169027 | 2021-05-06 04:20:38 | Vigo, Indiana, US | |
2983217 | 2983217 | 2021-04-10 | India | Nagaland | 12400 | 92 | 12152 | 156 | 26.06702 | 94.470302 | 2021-04-11 04:20:56 | Nagaland, India | ||
389965 | 389965 | 2021-04-04 | US | Minnesota | Olmsted | 27109 | 12400 | 94 | 0 | 44.00374114 | -92.40209944 | 2021-04-05 04:20:35 | Olmsted, Minnesota, US | |
3711881 | 3711881 | 2021-04-03 | US | Minnesota | Olmsted | 27109 | 12400 | 94 | 0 | 44.00374114 | -92.40209944 | 2021-04-04 04:20:49 | Olmsted, Minnesota, US | |
640712 | 640712 | 2021-03-31 | US | Rhode Island | Unassigned | 90044 | 12400 | 23 | 0 | 41.87064746 | 0.0 | 2021-04-01 04:27:05 | Unassigned, Rhode Island, US | |
1293535 | 1293535 | 2021-03-29 | US | Wisconsin | Dodge | 55027 | 12400 | 182 | 0 | 43.41576662 | -88.70928178 | 2021-03-30 04:26:23 | Dodge, Wisconsin, US | |
1983986 | 1983986 | 2021-03-25 | US | Virginia | Newport News | 51700 | 12400 | 204 | 0 | 37.08166899 | -76.51754109 | 2021-03-26 05:26:55 | Newport News, Virginia, US | |
3369051 | 3369051 | 2021-03-21 | Belize | 12400 | 316 | 12026 | 58 | 17.1899 | -88.4976 | 2021-03-22 05:25:43 | Belize | |||
1744261 | 1744261 | 2021-03-20 | Belize | 12400 | 316 | 12026 | 58 | 17.1899 | -88.4976 | 2021-03-21 05:25:44 | Belize | |||
3420641 | 3420641 | 2021-03-19 | Belize | 12400 | 316 | 12026 | 58 | 17.1899 | -88.4976 | 2021-03-20 05:25:46 | Belize | |||
2059362 | 2059362 | 2021-03-15 | US | West Virginia | Kanawha | 54039 | 12400 | 312 | 0 | 38.33860077 | -81.52857054 | 2021-03-16 05:25:13 | Kanawha, West Virginia, US | |
1938223 | 1938223 | 2021-02-23 | US | Minnesota | Wright | 27171 | 12400 | 114 | 0 | 12286 | 45.17297924 | -93.96234781 | 2021-02-24 05:29:16 | Wright, Minnesota, US |
614472 | 614472 | 2021-02-08 | US | Georgia | Douglas | 13097 | 12400 | 158 | 0 | 12242 | 33.70291126 | -84.77026156 | 2021-02-09 05:23:30 | Douglas, Georgia, US |
3156976 | 3156976 | 2021-01-27 | US | Virginia | Norfolk | 51710 | 12400 | 139 | 0 | 12261 | 36.89934014 | -76.26420872 | 2021-01-28 05:22:24 | Norfolk, Virginia, US |
14499 | 14499 | 2021-01-26 | US | New Jersey | Cumberland | 34011 | 12400 | 287 | 0 | 12113 | 39.37199394 | -75.10712559 | 2021-01-27 05:23:41 | Cumberland, New Jersey, US |
2932704 | 2932704 | 2020-12-19 | US | Louisiana | Calcasieu | 22019 | 12400 | 270 | 0 | 12130 | 30.22931235 | -93.35400434 | 2020-12-20 05:27:32 | Calcasieu, Louisiana, US |
1902650 | 1902650 | 2020-12-18 | US | Louisiana | Calcasieu | 22019 | 12400 | 270 | 0 | 12130 | 30.22931235 | -93.35400434 | 2020-12-19 05:27:52 | Calcasieu, Louisiana, US |
1543872 | 1543872 | 2020-11-07 | Guinea | 12400 | 73 | 10780 | 1547 | 9.9456 | -9.6966 | 2020-11-08 05:24:56 | Guinea | |||
2869159 | 2869159 | 2020-09-13 | US | Arizona | Yuma | 4027 | 12400 | 337 | 0 | 12063 | 32.76895712 | -113.9066674 | 2020-09-14 04:26:00 | Yuma, Arizona, US |
1503058 | 1503058 | 2020-07-25 | Netherlands | Zuid-Holland | 12400 | 1313 | 0 | 11045 | 51.937835 | 4.462114 | 2020-07-26 04:35:00 | Zuid-Holland, Netherlands | ||
2898374 | 2898374 | 2020-05-09 | US | New York | Rockland | 36087 | 12400 | 449 | 0 | 11951 | 41.15027894 | -74.02560498 | 2020-05-10 02:32:30 | Rockland, New York, 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]);