johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
62 rows where confirmed = 8583 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 58
- Chile 1
- Pakistan 1
- Russia 1
- Tajikistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331451 | 331451 | 2022-12-27 | US | Wisconsin | Door | 55029 | 8583 | 83 | 0 | 44.95856458 | -87.30002707 | 2022-12-28 04:21:04 | Door, Wisconsin, US | |
3463726 | 3463726 | 2022-11-21 | US | Wisconsin | Lincoln | 55069 | 8583 | 157 | 0 | 45.33737523 | -89.73411273 | 2022-11-22 04:20:47 | Lincoln, Wisconsin, US | |
797158 | 797158 | 2022-10-24 | US | Puerto Rico | Fajardo | 72053 | 8583 | 0 | 0 | 18.318373 | -65.666866 | 2022-10-25 04:21:53 | Fajardo, Puerto Rico, US | |
1811365 | 1811365 | 2022-10-05 | US | California | Siskiyou | 6093 | 8583 | 91 | 0 | 41.59198861 | -122.5407434 | 2022-10-06 04:21:22 | Siskiyou, California, US | |
131339 | 131339 | 2022-10-04 | US | California | Siskiyou | 6093 | 8583 | 91 | 0 | 41.59198861 | -122.5407434 | 2022-10-05 04:23:06 | Siskiyou, California, US | |
3769001 | 3769001 | 2022-09-11 | US | Texas | Hockley | 48219 | 8583 | 165 | 0 | 33.60771256 | -102.3431676 | 2022-09-12 04:20:58 | Hockley, Texas, US | |
3827576 | 3827576 | 2022-09-10 | US | Texas | Hockley | 48219 | 8583 | 165 | 0 | 33.60771256 | -102.3431676 | 2022-09-11 04:20:50 | Hockley, Texas, US | |
966033 | 966033 | 2022-09-09 | US | Texas | Hockley | 48219 | 8583 | 165 | 0 | 33.60771256 | -102.3431676 | 2022-09-10 04:21:10 | Hockley, Texas, US | |
2326298 | 2326298 | 2022-08-24 | US | Tennessee | Hardeman | 47069 | 8583 | 123 | 0 | 35.20772017 | -88.99161161 | 2022-08-25 04:21:13 | Hardeman, Tennessee, US | |
2856417 | 2856417 | 2022-08-22 | US | Wisconsin | Juneau | 55057 | 8583 | 70 | 0 | 43.92456975 | -90.11120239 | 2022-08-23 04:20:56 | Juneau, Wisconsin, US | |
3649164 | 3649164 | 2022-08-14 | US | Maryland | Dorchester | 24019 | 8583 | 112 | 0 | 38.45413522 | -76.02752426 | 2022-08-15 04:20:59 | Dorchester, Maryland, US | |
1970170 | 1970170 | 2022-08-13 | US | Maryland | Dorchester | 24019 | 8583 | 112 | 0 | 38.45413522 | -76.02752426 | 2022-08-14 04:20:55 | Dorchester, Maryland, US | |
2889979 | 2889979 | 2022-08-12 | US | Maryland | Dorchester | 24019 | 8583 | 112 | 0 | 38.45413522 | -76.02752426 | 2022-08-13 04:20:52 | Dorchester, Maryland, US | |
2742992 | 2742992 | 2022-07-07 | US | Missouri | Warren | 29219 | 8583 | 104 | 0 | 38.76529479 | -91.16124662 | 2022-07-08 04:20:56 | Warren, Missouri, US | |
1201787 | 1201787 | 2022-07-06 | US | Missouri | Warren | 29219 | 8583 | 104 | 0 | 38.76529479 | -91.16124662 | 2022-07-07 04:20:55 | Warren, Missouri, US | |
3968530 | 3968530 | 2022-07-05 | US | Missouri | Warren | 29219 | 8583 | 104 | 0 | 38.76529479 | -91.16124662 | 2022-07-06 04:20:58 | Warren, Missouri, US | |
3080041 | 3080041 | 2022-07-04 | US | Missouri | Warren | 29219 | 8583 | 104 | 0 | 38.76529479 | -91.16124662 | 2022-07-05 04:20:45 | Warren, Missouri, US | |
1769323 | 1769323 | 2022-07-03 | US | Missouri | Warren | 29219 | 8583 | 104 | 0 | 38.76529479 | -91.16124662 | 2022-07-04 04:20:54 | Warren, Missouri, US | |
3367309 | 3367309 | 2022-07-02 | US | Missouri | Warren | 29219 | 8583 | 104 | 0 | 38.76529479 | -91.16124662 | 2022-07-03 04:20:59 | Warren, Missouri, US | |
596613 | 596613 | 2022-07-01 | US | Tennessee | Henry | 47079 | 8583 | 165 | 0 | 36.33160906 | -88.30121797 | 2022-07-02 04:21:16 | Henry, Tennessee, US | |
595638 | 595638 | 2022-07-01 | US | Missouri | Warren | 29219 | 8583 | 104 | 0 | 38.76529479 | -91.16124662 | 2022-07-02 04:21:16 | Warren, Missouri, US | |
2235737 | 2235737 | 2022-06-12 | US | Alabama | Chambers | 1017 | 8583 | 162 | 0 | 32.91360079 | -85.39072749 | 2022-06-13 04:21:14 | Chambers, Alabama, US | |
3141935 | 3141935 | 2022-06-11 | US | Alabama | Chambers | 1017 | 8583 | 162 | 0 | 32.91360079 | -85.39072749 | 2022-06-12 04:20:53 | Chambers, Alabama, US | |
1944851 | 1944851 | 2022-06-10 | US | Alabama | Chambers | 1017 | 8583 | 162 | 0 | 32.91360079 | -85.39072749 | 2022-06-11 04:21:01 | Chambers, Alabama, US | |
3157990 | 3157990 | 2022-06-09 | US | Alabama | Chambers | 1017 | 8583 | 162 | 0 | 32.91360079 | -85.39072749 | 2022-06-10 04:20:55 | Chambers, Alabama, US | |
3510558 | 3510558 | 2022-06-05 | US | Texas | Matagorda | 48321 | 8583 | 175 | 0 | 28.81955746 | -96.01230294 | 2022-06-06 04:20:57 | Matagorda, Texas, US | |
3136656 | 3136656 | 2022-06-03 | US | Texas | Grimes | 48185 | 8583 | 121 | 0 | 30.54579585 | -95.98902499 | 2022-06-04 04:20:58 | Grimes, Texas, US | |
1464939 | 1464939 | 2022-02-10 | US | Georgia | Oconee | 13219 | 8583 | 95 | 0 | 33.83749973 | -83.43679568 | 2022-02-11 04:21:09 | Oconee, Georgia, US | |
1364265 | 1364265 | 2022-02-08 | US | Missouri | Howell | 29091 | 8583 | 186 | 0 | 36.77383887 | -91.88683935 | 2022-02-09 04:21:04 | Howell, Missouri, US | |
2014451 | 2014451 | 2022-02-06 | US | Minnesota | Morrison | 27097 | 8583 | 95 | 0 | 46.01265363 | -94.27341528 | 2022-02-07 04:21:05 | Morrison, Minnesota, US | |
1296958 | 1296958 | 2022-02-05 | US | Tennessee | Carroll | 47017 | 8583 | 133 | 0 | 35.97366108 | -88.45189331 | 2022-02-06 04:21:00 | Carroll, Tennessee, US | |
1295780 | 1295780 | 2022-02-05 | US | Minnesota | Morrison | 27097 | 8583 | 95 | 0 | 46.01265363 | -94.27341528 | 2022-02-06 04:21:00 | Morrison, Minnesota, US | |
2329108 | 2329108 | 2022-02-04 | US | Minnesota | Morrison | 27097 | 8583 | 95 | 0 | 46.01265363 | -94.27341528 | 2022-02-05 04:21:05 | Morrison, Minnesota, US | |
3427207 | 3427207 | 2022-01-21 | US | New York | Otsego | 36077 | 8583 | 76 | 0 | 42.63492579 | -75.03151402 | 2022-01-22 04:21:13 | Otsego, New York, US | |
3228293 | 3228293 | 2022-01-19 | US | Mississippi | Pontotoc | 28115 | 8583 | 118 | 0 | 34.226046000000004 | -89.03636807 | 2022-01-20 04:21:07 | Pontotoc, Mississippi, US | |
3522792 | 3522792 | 2022-01-02 | US | Virginia | James City | 51095 | 8583 | 100 | 0 | 37.31156958 | -76.76950618 | 2022-01-03 02:22:25 | James City, Virginia, US | |
2170922 | 2170922 | 2022-01-01 | US | Virginia | James City | 51095 | 8583 | 100 | 0 | 37.31156958 | -76.76950618 | 2022-01-02 04:20:52 | James City, Virginia, US | |
2780353 | 2780353 | 2021-12-31 | US | Virginia | James City | 51095 | 8583 | 100 | 0 | 37.31156958 | -76.76950618 | 2022-01-01 04:22:14 | James City, Virginia, US | |
448485 | 448485 | 2021-11-17 | US | Indiana | Marshall | 18099 | 8583 | 145 | 0 | 41.32467367 | -86.26185087 | 2021-11-18 04:21:33 | Marshall, Indiana, US | |
90400 | 90400 | 2021-11-09 | US | Utah | TriCounty | 8583 | 73 | 0 | 40.12491499 | -109.5174415 | 2021-11-10 04:21:38 | TriCounty, Utah, US | ||
656999 | 656999 | 2021-10-22 | US | Tennessee | Warren | 47177 | 8583 | 119 | 0 | 35.672829899999996 | -85.77969117 | 2021-10-23 04:21:32 | Warren, Tennessee, US | |
812056 | 812056 | 2021-09-20 | US | Ohio | Lawrence | 39087 | 8583 | 140 | 0 | 38.59743452 | -82.53466552 | 2021-09-21 04:21:26 | Lawrence, Ohio, US | |
2070828 | 2070828 | 2021-08-31 | US | Tennessee | Coffee | 47031 | 8583 | 127 | 0 | 35.49090731 | -86.07311784 | 2021-09-01 04:21:38 | Coffee, Tennessee, US | |
2425236 | 2425236 | 2021-06-23 | US | North Carolina | Orange | 37135 | 8583 | 101 | 0 | 36.06092947 | -79.12167935 | 2021-06-24 04:21:55 | Orange, North Carolina, US | |
3475105 | 3475105 | 2021-06-08 | US | South Carolina | Darlington | 45031 | 8583 | 180 | 0 | 34.33358335 | -79.96027485 | 2021-06-09 04:23:31 | Darlington, South Carolina, US | |
1414432 | 1414432 | 2021-05-24 | US | Kentucky | Campbell | 21037 | 8583 | 70 | 0 | 38.94384345 | -84.37875208 | 2021-05-25 04:21:08 | Campbell, Kentucky, US | |
1773825 | 1773825 | 2021-05-23 | US | Ohio | Marion | 39101 | 8583 | 138 | 0 | 40.58610662 | -83.15736305 | 2021-05-24 04:20:53 | Marion, Ohio, US | |
890999 | 890999 | 2021-04-26 | US | South Dakota | Lincoln | 46083 | 8583 | 77 | 0 | 43.27841182 | -96.7203905 | 2021-04-27 04:20:52 | Lincoln, South Dakota, US | |
957771 | 957771 | 2021-04-25 | US | Tennessee | Anderson | 47001 | 8583 | 171 | 0 | 36.12684348 | -84.19965764 | 2021-04-26 04:21:04 | Anderson, Tennessee, US | |
3886641 | 3886641 | 2021-04-11 | US | Texas | Coryell | 48099 | 8583 | 85 | 0 | 31.39078397 | -97.79936155 | 2021-04-12 04:21:00 | Coryell, Texas, US | |
2986309 | 2986309 | 2021-04-10 | US | Texas | Coryell | 48099 | 8583 | 85 | 0 | 31.39078397 | -97.79936155 | 2021-04-11 04:20:56 | Coryell, Texas, US | |
1676000 | 1676000 | 2021-02-07 | US | Wisconsin | Jefferson | 55055 | 8583 | 79 | 0 | 8504 | 43.02054068 | -88.77529134 | 2021-02-08 05:22:39 | Jefferson, Wisconsin, US |
1462438 | 1462438 | 2021-01-31 | US | Pennsylvania | Monroe | 42089 | 8583 | 245 | 0 | 8338 | 41.05934058 | -75.34031025 | 2021-02-01 05:22:53 | Monroe, Pennsylvania, US |
3515542 | 3515542 | 2021-01-15 | Pakistan | Azad Jammu and Kashmir | 8583 | 238 | 8063 | 282 | 34.027401 | 73.947253 | 2021-01-16 05:22:40 | Azad Jammu and Kashmir, Pakistan | ||
3779005 | 3779005 | 2020-12-27 | US | Indiana | Madison | 18095 | 8583 | 204 | 0 | 8379 | 40.16143691 | -85.71964711 | 2020-12-28 05:22:06 | Madison, Indiana, US |
923477 | 923477 | 2020-11-26 | Chile | Nuble | 8583 | 174 | 8083 | 326 | -36.7226 | -71.7622 | 2020-11-27 05:26:53 | Nuble, Chile | ||
3651818 | 3651818 | 2020-10-24 | Russia | Tver Oblast | 8583 | 302 | 5081 | 3200 | 57.1134475 | 35.174442799999994 | 2020-10-25 04:24:36 | Tver Oblast, Russia | ||
3782282 | 3782282 | 2020-10-13 | US | Alabama | Madison | 1089 | 8583 | 83 | 0 | 8500 | 34.76327133 | -86.55069633 | 2020-10-14 04:24:05 | Madison, Alabama, US |
2060208 | 2060208 | 2020-09-01 | Tajikistan | 8583 | 68 | 7413 | 1102 | 38.861 | 71.2761 | 2020-09-02 04:28:25 | Tajikistan | |||
585897 | 585897 | 2020-08-13 | US | Texas | Galveston | 48167 | 8583 | 117 | 0 | 9683 | 29.40167322 | -94.90469073 | 2020-08-14 04:51:19 | Galveston, Texas, US |
324730 | 324730 | 2020-07-20 | US | South Carolina | Greenville | 45045 | 8583 | 133 | 0 | 8450 | 34.89502264 | -82.37295012 | 2020-07-21 04:38:46 | Greenville, South Carolina, US |
3248236 | 3248236 | 2020-06-21 | US | Massachusetts | Plymouth | 25023 | 8583 | 643 | 0 | 7940 | 41.94070556 | -70.80802823 | 2020-06-22 04:33:20 | Plymouth, Massachusetts, 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]);