johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where confirmed = 11839 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 39
- Iceland 3
- Congo (Kinshasa) 1
- Djibouti 1
- Dominica 1
- Netherlands 1
- North Macedonia 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2496293 | 2496293 | 2022-08-15 | US | New York | Otsego | 36077 | 11839 | 97 | 0 | 42.63492579 | -75.03151402 | 2022-08-16 04:20:58 | Otsego, New York, US | |
2155103 | 2155103 | 2022-07-16 | US | Washington | Island | 53029 | 11839 | 86 | 0 | 48.14713305 | -122.5216407 | 2022-07-17 04:21:15 | Island, Washington, US | |
2422336 | 2422336 | 2022-07-15 | US | Washington | Island | 53029 | 11839 | 86 | 0 | 48.14713305 | -122.5216407 | 2022-07-16 04:21:05 | Island, Washington, US | |
3432411 | 3432411 | 2022-07-14 | US | Washington | Island | 53029 | 11839 | 86 | 0 | 48.14713305 | -122.5216407 | 2022-07-15 04:20:53 | Island, Washington, US | |
3112931 | 3112931 | 2022-07-13 | US | Washington | Island | 53029 | 11839 | 86 | 0 | 48.14713305 | -122.5216407 | 2022-07-14 04:20:57 | Island, Washington, US | |
167145 | 167145 | 2022-06-21 | US | Indiana | Huntington | 18069 | 11839 | 158 | 0 | 40.82907273 | -85.48822092 | 2022-06-22 04:20:54 | Huntington, Indiana, US | |
1764428 | 1764428 | 2022-06-20 | US | Indiana | Huntington | 18069 | 11839 | 158 | 0 | 40.82907273 | -85.48822092 | 2022-06-21 04:20:56 | Huntington, Indiana, US | |
1423680 | 1423680 | 2022-06-08 | US | Oklahoma | McClain | 40087 | 11839 | 138 | 0 | 35.01123903 | -97.44572302 | 2022-06-09 04:20:54 | McClain, Oklahoma, US | |
3728794 | 3728794 | 2022-06-07 | US | Oklahoma | McClain | 40087 | 11839 | 138 | 0 | 35.01123903 | -97.44572302 | 2022-06-08 04:20:55 | McClain, Oklahoma, US | |
3890196 | 3890196 | 2022-06-06 | US | Oklahoma | McClain | 40087 | 11839 | 138 | 0 | 35.01123903 | -97.44572302 | 2022-06-07 04:21:08 | McClain, Oklahoma, US | |
3509965 | 3509965 | 2022-06-05 | US | Oklahoma | McClain | 40087 | 11839 | 138 | 0 | 35.01123903 | -97.44572302 | 2022-06-06 04:20:57 | McClain, Oklahoma, US | |
3530042 | 3530042 | 2022-06-04 | US | Oklahoma | McClain | 40087 | 11839 | 138 | 0 | 35.01123903 | -97.44572302 | 2022-06-05 04:20:55 | McClain, Oklahoma, US | |
3136128 | 3136128 | 2022-06-03 | US | Oklahoma | McClain | 40087 | 11839 | 138 | 0 | 35.01123903 | -97.44572302 | 2022-06-04 04:20:58 | McClain, Oklahoma, US | |
3581203 | 3581203 | 2022-06-02 | US | Oklahoma | McClain | 40087 | 11839 | 138 | 0 | 35.01123903 | -97.44572302 | 2022-06-03 04:20:58 | McClain, Oklahoma, US | |
2253801 | 2253801 | 2022-04-19 | US | North Carolina | Vance | 37181 | 11839 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-04-20 04:20:45 | Vance, North Carolina, US | |
1848351 | 1848351 | 2022-04-18 | US | North Carolina | Vance | 37181 | 11839 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-04-19 04:21:00 | Vance, North Carolina, US | |
3419295 | 3419295 | 2022-04-17 | US | North Carolina | Vance | 37181 | 11839 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-04-18 04:21:12 | Vance, North Carolina, US | |
306244 | 306244 | 2022-04-16 | US | North Carolina | Vance | 37181 | 11839 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-04-17 04:20:59 | Vance, North Carolina, US | |
2672189 | 2672189 | 2022-04-15 | US | North Carolina | Vance | 37181 | 11839 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-04-16 04:20:48 | Vance, North Carolina, US | |
1225974 | 1225974 | 2022-04-14 | US | North Carolina | Vance | 37181 | 11839 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-04-15 04:20:57 | Vance, North Carolina, US | |
2445132 | 2445132 | 2022-04-13 | US | North Carolina | Vance | 37181 | 11839 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-04-13 23:21:06 | Vance, North Carolina, US | |
2477836 | 2477836 | 2022-03-30 | Dominica | 11839 | 63 | 0 | 15.415 | -61.371 | 2022-03-31 04:20:56 | Dominica | ||||
1284925 | 1284925 | 2022-01-05 | US | Tennessee | Dickson | 47043 | 11839 | 205 | 0 | 36.14669837 | -87.35891709 | 2022-01-06 04:22:09 | Dickson, Tennessee, US | |
279560 | 279560 | 2021-11-03 | US | Virginia | Montgomery | 51121 | 11839 | 110 | 0 | 37.17746986 | -80.37868691 | 2021-11-04 04:22:20 | Montgomery, Virginia, US | |
2722068 | 2722068 | 2021-10-30 | US | Indiana | Bartholomew | 18005 | 11839 | 181 | 0 | 39.20744865 | -85.89558181 | 2021-10-31 04:22:08 | Bartholomew, Indiana, US | |
2943874 | 2943874 | 2021-10-15 | US | Arkansas | Pope | 5115 | 11839 | 153 | 0 | 35.44871474 | -93.03212219 | 2021-10-16 04:21:15 | Pope, Arkansas, US | |
1274208 | 1274208 | 2021-10-03 | Iceland | 11839 | 33 | 0 | 64.9631 | -19.0208 | 2021-10-04 04:21:31 | Iceland | ||||
3927961 | 3927961 | 2021-10-02 | Iceland | 11839 | 33 | 0 | 64.9631 | -19.0208 | 2021-10-03 04:21:24 | Iceland | ||||
2131941 | 2131941 | 2021-10-01 | Iceland | 11839 | 33 | 0 | 64.9631 | -19.0208 | 2021-10-02 04:21:25 | Iceland | ||||
3448722 | 3448722 | 2021-09-10 | Djibouti | 11839 | 157 | 0 | 11.8251 | 42.5903 | 2021-09-11 04:21:30 | Djibouti | ||||
2281463 | 2281463 | 2021-09-08 | US | North Carolina | Craven | 37049 | 11839 | 134 | 0 | 35.11833364 | -77.08398081 | 2021-09-09 04:21:27 | Craven, North Carolina, US | |
644146 | 644146 | 2021-09-07 | US | New Mexico | Santa Fe | 35049 | 11839 | 157 | 0 | 35.50708973 | -105.9774716 | 2021-09-08 04:21:31 | Santa Fe, New Mexico, US | |
3634938 | 3634938 | 2021-07-14 | US | Tennessee | Putnam | 47141 | 11839 | 179 | 0 | 36.14005459 | -85.50646123 | 2021-07-15 04:21:48 | Putnam, Tennessee, US | |
563394 | 563394 | 2021-06-22 | US | Alaska | Matanuska-Susitna | 2170 | 11839 | 59 | 0 | 62.31305045 | -149.5741743 | 2021-06-23 04:21:46 | Matanuska-Susitna, Alaska, US | |
3359096 | 3359096 | 2021-06-21 | US | Alaska | Matanuska-Susitna | 2170 | 11839 | 59 | 0 | 62.31305045 | -149.5741743 | 2021-06-22 04:21:34 | Matanuska-Susitna, Alaska, US | |
54082 | 54082 | 2021-05-29 | US | Virginia | Alexandria | 51510 | 11839 | 137 | 0 | 38.814003 | -77.08183073 | 2021-05-30 04:20:55 | Alexandria, Virginia, US | |
2258410 | 2258410 | 2021-05-19 | US | Pennsylvania | Lycoming | 42081 | 11839 | 284 | 0 | 41.34310539 | -77.06629984 | 2021-05-20 04:21:05 | Lycoming, Pennsylvania, US | |
1536313 | 1536313 | 2021-03-28 | US | Alabama | Marshall | 1095 | 11839 | 217 | 0 | 34.36975964 | -86.30486727 | 2021-03-29 04:28:35 | Marshall, Alabama, US | |
1219953 | 1219953 | 2021-03-27 | US | Alabama | Marshall | 1095 | 11839 | 217 | 0 | 34.36975964 | -86.30486727 | 2021-03-28 05:28:10 | Marshall, Alabama, US | |
614462 | 614462 | 2021-02-08 | US | Georgia | Coweta | 13077 | 11839 | 129 | 0 | 11710 | 33.35334302 | -84.76129976 | 2021-02-09 05:23:30 | Coweta, Georgia, US |
3691597 | 3691597 | 2020-12-24 | Netherlands | Drenthe | 11839 | 124 | 0 | 11699 | 52.862485 | 6.618435000000002 | 2020-12-25 05:22:48 | Drenthe, Netherlands | ||
3848941 | 3848941 | 2020-12-13 | US | Iowa | Black Hawk | 19013 | 11839 | 184 | 0 | 11655 | 42.4704581 | -92.30524729 | 2020-12-14 05:26:27 | Black Hawk, Iowa, US |
2977374 | 2977374 | 2020-12-09 | US | New Hampshire | Hillsborough | 33011 | 11839 | 350 | 0 | 11489 | 42.91537785 | -71.7200253 | 2020-12-10 05:26:19 | Hillsborough, New Hampshire, US |
3169506 | 3169506 | 2020-11-16 | Congo (Kinshasa) | 11839 | 321 | 11124 | 394 | -4.0383 | 21.7587 | 2020-11-17 05:25:54 | Congo (Kinshasa) | |||
2919735 | 2919735 | 2020-11-04 | US | California | Monterey | 6053 | 11839 | 96 | 0 | 11744 | 36.21862405 | -121.2413397 | 2020-11-05 06:05:03 | Monterey, California, US |
2693133 | 2693133 | 2020-10-08 | US | Washington | Yakima | 53077 | 11839 | 262 | 0 | 11577 | 46.45738486 | -120.7380126 | 2020-10-09 04:23:59 | Yakima, Washington, US |
1042114 | 1042114 | 2020-10-07 | Spain | Extremadura | 11839 | 617 | 2652 | 8570 | 39.4937 | -6.0679 | 2020-10-08 04:23:56 | Extremadura, Spain | ||
3923605 | 3923605 | 2020-08-09 | North Macedonia | 11839 | 527 | 7664 | 3648 | 41.6086 | 21.7453 | 2020-08-10 04:34:55 | North Macedonia |
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]);