johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
526 rows where confirmed = 939 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952342 | 2952342 | 2022-12-20 | US | Idaho | Oneida | 16071 | 939 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-21 04:21:03 | Oneida, Idaho, US | |
3174744 | 3174744 | 2022-12-19 | US | Idaho | Oneida | 16071 | 939 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-20 04:21:04 | Oneida, Idaho, US | |
1629261 | 1629261 | 2022-12-18 | US | Idaho | Oneida | 16071 | 939 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-19 04:21:03 | Oneida, Idaho, US | |
504640 | 504640 | 2022-12-17 | US | Idaho | Oneida | 16071 | 939 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-18 04:21:03 | Oneida, Idaho, US | |
3325212 | 3325212 | 2022-12-16 | US | Idaho | Oneida | 16071 | 939 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-17 04:21:04 | Oneida, Idaho, US | |
543724 | 543724 | 2022-12-15 | US | Idaho | Oneida | 16071 | 939 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-16 04:21:01 | Oneida, Idaho, US | |
349252 | 349252 | 2022-12-14 | US | Idaho | Oneida | 16071 | 939 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-15 04:20:58 | Oneida, Idaho, US | |
310166 | 310166 | 2022-12-13 | US | New York | Unassigned | 90036 | 939 | 2 | 0 | 44.74530905 | 0.0 | 2022-12-14 04:21:04 | Unassigned, New York, US | |
490030 | 490030 | 2022-11-25 | US | North Dakota | Hettinger | 38041 | 939 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-11-26 04:21:11 | Hettinger, North Dakota, US | |
294294 | 294294 | 2022-11-15 | US | New York | Unassigned | 90036 | 939 | 2 | 0 | 44.74530905 | 0.0 | 2022-11-16 04:21:09 | Unassigned, New York, US | |
3599324 | 3599324 | 2022-11-14 | US | New York | Unassigned | 90036 | 939 | 2 | 0 | 44.74530905 | 0.0 | 2022-11-15 04:21:16 | Unassigned, New York, US | |
3597489 | 3597489 | 2022-11-14 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-15 04:21:16 | Yakutat, Alaska, US | |
312347 | 312347 | 2022-11-13 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-14 04:21:09 | Yakutat, Alaska, US | |
63508 | 63508 | 2022-11-12 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-13 04:21:14 | Yakutat, Alaska, US | |
2927670 | 2927670 | 2022-11-11 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-12 04:20:41 | Yakutat, Alaska, US | |
2506506 | 2506506 | 2022-11-10 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-11 04:21:22 | Yakutat, Alaska, US | |
2431381 | 2431381 | 2022-11-09 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-10 04:21:16 | Yakutat, Alaska, US | |
480958 | 480958 | 2022-11-08 | US | Kansas | Woodson | 20207 | 939 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-11-09 04:21:22 | Woodson, Kansas, US | |
480037 | 480037 | 2022-11-08 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-09 04:21:22 | Yakutat, Alaska, US | |
2440108 | 2440108 | 2022-11-07 | US | Kansas | Woodson | 20207 | 939 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-11-08 04:21:21 | Woodson, Kansas, US | |
2439187 | 2439187 | 2022-11-07 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-08 04:21:21 | Yakutat, Alaska, US | |
1051206 | 1051206 | 2022-11-06 | US | Kansas | Woodson | 20207 | 939 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-11-07 04:21:26 | Woodson, Kansas, US | |
1050285 | 1050285 | 2022-11-06 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-07 04:21:26 | Yakutat, Alaska, US | |
619230 | 619230 | 2022-11-05 | US | Kansas | Woodson | 20207 | 939 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-11-06 04:21:24 | Woodson, Kansas, US | |
618309 | 618309 | 2022-11-05 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-06 04:21:24 | Yakutat, Alaska, US | |
1023734 | 1023734 | 2022-11-04 | US | Kansas | Woodson | 20207 | 939 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-11-05 04:21:52 | Woodson, Kansas, US | |
1022813 | 1022813 | 2022-11-04 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-05 04:21:52 | Yakutat, Alaska, US | |
432725 | 432725 | 2022-11-03 | US | Kansas | Woodson | 20207 | 939 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-11-04 04:22:11 | Woodson, Kansas, US | |
431804 | 431804 | 2022-11-03 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-04 04:22:11 | Yakutat, Alaska, US | |
850967 | 850967 | 2022-11-02 | US | Kansas | Woodson | 20207 | 939 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-11-03 04:22:05 | Woodson, Kansas, US | |
850046 | 850046 | 2022-11-02 | US | Alaska | Yakutat | 2282 | 939 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-11-03 04:22:05 | Yakutat, Alaska, US | |
2274132 | 2274132 | 2022-10-20 | US | New Mexico | Mora | 35033 | 939 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-10-21 04:22:23 | Mora, New Mexico, US | |
515518 | 515518 | 2022-10-15 | China | Guizhou | 939 | 2 | 0 | 26.8154 | 106.8748 | 2022-10-16 04:22:39 | Guizhou, China | |||
2032575 | 2032575 | 2022-10-14 | China | Guizhou | 939 | 2 | 0 | 26.8154 | 106.8748 | 2022-10-15 04:22:00 | Guizhou, China | |||
375403 | 375403 | 2022-09-13 | US | Texas | Reagan | 48383 | 939 | 15 | 0 | 31.36607041 | -101.5232659 | 2022-09-14 04:20:44 | Reagan, Texas, US | |
2398005 | 2398005 | 2022-09-12 | US | Texas | Reagan | 48383 | 939 | 15 | 0 | 31.36607041 | -101.5232659 | 2022-09-13 04:20:57 | Reagan, Texas, US | |
1683707 | 1683707 | 2022-08-29 | US | Texas | Real | 48385 | 939 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-08-30 04:21:03 | Real, Texas, US | |
1164220 | 1164220 | 2022-08-18 | US | Texas | Cochran | 48079 | 939 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-08-19 04:20:54 | Cochran, Texas, US | |
2597085 | 2597085 | 2022-07-25 | US | Texas | Coke | 48081 | 939 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-07-26 04:20:58 | Coke, Texas, US | |
899200 | 899200 | 2022-07-24 | US | Texas | Coke | 48081 | 939 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-07-25 04:20:51 | Coke, Texas, US | |
1212201 | 1212201 | 2022-07-11 | US | Colorado | Phillips | 8095 | 939 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-07-12 04:20:51 | Phillips, Colorado, US | |
2789683 | 2789683 | 2022-07-10 | US | Colorado | Phillips | 8095 | 939 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-07-11 04:20:46 | Phillips, Colorado, US | |
142636 | 142636 | 2022-07-09 | US | Colorado | Phillips | 8095 | 939 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-07-10 04:20:54 | Phillips, Colorado, US | |
3400187 | 3400187 | 2022-06-18 | US | Puerto Rico | Maricao | 72093 | 939 | 0 | 0 | 18.171795 | -66.942126 | 2022-06-19 04:20:51 | Maricao, Puerto Rico, US | |
949091 | 949091 | 2022-06-14 | US | New York | Hamilton | 36041 | 939 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-06-15 04:20:54 | Hamilton, New York, US | |
2981499 | 2981499 | 2022-06-13 | US | New York | Hamilton | 36041 | 939 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-06-14 04:20:52 | Hamilton, New York, US | |
2979903 | 2979903 | 2022-06-13 | US | Colorado | Ouray | 8091 | 939 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-06-14 04:20:52 | Ouray, Colorado, US | |
2237625 | 2237625 | 2022-06-12 | US | New York | Hamilton | 36041 | 939 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-06-13 04:21:14 | Hamilton, New York, US | |
3143823 | 3143823 | 2022-06-11 | US | New York | Hamilton | 36041 | 939 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-06-12 04:20:53 | Hamilton, New York, US | |
3158557 | 3158557 | 2022-06-09 | US | Idaho | Bear Lake | 16007 | 939 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-06-10 04:20:55 | Bear Lake, Idaho, US | |
1424410 | 1424410 | 2022-06-08 | US | Virginia | Bath | 51017 | 939 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-06-09 04:20:54 | Bath, Virginia, US | |
1422024 | 1422024 | 2022-06-08 | US | Idaho | Bear Lake | 16007 | 939 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-06-09 04:20:54 | Bear Lake, Idaho, US | |
3890926 | 3890926 | 2022-06-06 | US | Virginia | Bath | 51017 | 939 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-06-07 04:21:08 | Bath, Virginia, US | |
229904 | 229904 | 2022-05-31 | US | Delaware | Unassigned | 90010 | 939 | 0 | 0 | 39.57992638 | 0.0 | 2022-06-01 04:20:55 | Unassigned, Delaware, US | |
3186669 | 3186669 | 2022-05-30 | US | Delaware | Unassigned | 90010 | 939 | 0 | 0 | 39.57992638 | 0.0 | 2022-05-31 04:20:51 | Unassigned, Delaware, US | |
1328006 | 1328006 | 2022-04-26 | US | Minnesota | Red Lake | 27125 | 939 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-04-27 04:20:52 | Red Lake, Minnesota, US | |
3723960 | 3723960 | 2022-04-25 | US | Minnesota | Red Lake | 27125 | 939 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-04-26 04:20:51 | Red Lake, Minnesota, US | |
1951382 | 1951382 | 2022-04-12 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-13 04:21:03 | Edmunds, South Dakota, US | |
3209135 | 3209135 | 2022-04-11 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-12 04:20:49 | Edmunds, South Dakota, US | |
1579021 | 1579021 | 2022-04-10 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-11 04:21:02 | Edmunds, South Dakota, US | |
1655263 | 1655263 | 2022-04-09 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-10 04:20:52 | Edmunds, South Dakota, US | |
2118585 | 2118585 | 2022-04-08 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-09 04:20:42 | Edmunds, South Dakota, US | |
3323109 | 3323109 | 2022-04-07 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-08 04:20:48 | Edmunds, South Dakota, US | |
2803645 | 2803645 | 2022-04-06 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-07 04:20:53 | Edmunds, South Dakota, US | |
3870414 | 3870414 | 2022-04-05 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-06 04:20:49 | Edmunds, South Dakota, US | |
2751756 | 2751756 | 2022-04-04 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-05 04:20:48 | Edmunds, South Dakota, US | |
3733102 | 3733102 | 2022-04-03 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-04 04:20:51 | Edmunds, South Dakota, US | |
502537 | 502537 | 2022-04-02 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-03 04:20:48 | Edmunds, South Dakota, US | |
3353522 | 3353522 | 2022-04-01 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-02 04:20:47 | Edmunds, South Dakota, US | |
1542827 | 1542827 | 2022-03-31 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-01 04:20:28 | Edmunds, South Dakota, US | |
2480840 | 2480840 | 2022-03-30 | US | South Dakota | Edmunds | 46045 | 939 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-03-31 04:20:56 | Edmunds, South Dakota, US | |
2140642 | 2140642 | 2022-03-09 | US | Arkansas | Calhoun | 5013 | 939 | 9 | 0 | 33.55598792 | -92.49974403 | 2022-03-10 04:20:48 | Calhoun, Arkansas, US | |
3719133 | 3719133 | 2022-02-21 | US | Idaho | Lincoln | 16063 | 939 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-02-22 04:21:01 | Lincoln, Idaho, US | |
3912967 | 3912967 | 2022-02-20 | US | Idaho | Lincoln | 16063 | 939 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-02-21 04:21:05 | Lincoln, Idaho, US | |
3876525 | 3876525 | 2022-02-19 | US | Idaho | Lincoln | 16063 | 939 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-02-20 04:21:00 | Lincoln, Idaho, US | |
1297854 | 1297854 | 2022-02-17 | China | Liaoning | 939 | 2 | 0 | 41.2956 | 122.6085 | 2022-02-18 04:21:04 | Liaoning, China | |||
3822358 | 3822358 | 2022-02-16 | US | Missouri | Knox | 29103 | 939 | 12 | 0 | 40.12699751 | -92.14780832 | 2022-02-17 04:20:56 | Knox, Missouri, US | |
3822285 | 3822285 | 2022-02-16 | US | Mississippi | Sharkey | 28125 | 939 | 23 | 0 | 32.88149103 | -90.81595379999999 | 2022-02-17 04:20:56 | Sharkey, Mississippi, US | |
2643900 | 2643900 | 2022-02-14 | US | Nevada | Mineral | 32021 | 939 | 15 | 0 | 38.53841696 | -118.4344506 | 2022-02-15 04:21:09 | Mineral, Nevada, US | |
981356 | 981356 | 2022-02-01 | US | North Dakota | LaMoure | 38045 | 939 | 19 | 0 | 46.45681054 | -98.53542355 | 2022-02-02 04:21:09 | LaMoure, North Dakota, US | |
3303407 | 3303407 | 2022-01-30 | US | Texas | Presidio | 48377 | 939 | 32 | 0 | 29.99954402 | -104.24080790000001 | 2022-01-31 04:21:09 | Presidio, Texas, US | |
1320229 | 1320229 | 2022-01-26 | US | Montana | Mineral | 30061 | 939 | 15 | 0 | 47.15283992 | -115.00152390000001 | 2022-01-27 04:21:19 | Mineral, Montana, US | |
2835228 | 2835228 | 2022-01-22 | US | North Dakota | Dunn | 38025 | 939 | 8 | 0 | 47.35423935 | -102.61604679999999 | 2022-01-23 04:21:13 | Dunn, North Dakota, US | |
1284740 | 1284740 | 2022-01-05 | US | Puerto Rico | Jayuya | 72073 | 939 | 0 | 0 | 18.211446 | -66.58878 | 2022-01-06 04:22:09 | Jayuya, Puerto Rico, US | |
2170595 | 2170595 | 2022-01-01 | US | Texas | Brewster | 48043 | 939 | 24 | 0 | 29.81008251 | -103.25203259999999 | 2022-01-02 04:20:52 | Brewster, Texas, US | |
2780110 | 2780110 | 2021-12-31 | US | Texas | Hemphill | 48211 | 939 | 3 | 0 | 35.83764858 | -100.2703577 | 2022-01-01 04:22:14 | Hemphill, Texas, US | |
1671322 | 1671322 | 2021-12-29 | US | South Dakota | Day | 46037 | 939 | 30 | 0 | 45.367281 | -97.60737498 | 2021-12-30 04:21:25 | Day, South Dakota, US | |
1435340 | 1435340 | 2021-12-28 | US | Puerto Rico | Rincon | 72117 | 939 | 0 | 0 | 18.335442999999998 | -67.23174 | 2021-12-29 03:21:43 | Rincon, Puerto Rico, US | |
732264 | 732264 | 2021-12-27 | US | Minnesota | Lincoln | 27081 | 939 | 5 | 0 | 44.41311883 | -96.26688165 | 2021-12-28 04:21:47 | Lincoln, Minnesota, US | |
2090691 | 2090691 | 2021-12-14 | US | Puerto Rico | Aibonito | 72009 | 939 | 0 | 0 | 18.131361 | -66.264131 | 2021-12-15 03:22:16 | Aibonito, Puerto Rico, US | |
2089869 | 2089869 | 2021-12-14 | US | Missouri | Dade | 29057 | 939 | 38 | 0 | 37.431814 | -93.8503345 | 2021-12-15 03:22:16 | Dade, Missouri, US | |
785108 | 785108 | 2021-12-13 | US | Puerto Rico | Aibonito | 72009 | 939 | 0 | 0 | 18.131361 | -66.264131 | 2021-12-14 04:22:38 | Aibonito, Puerto Rico, US | |
784286 | 784286 | 2021-12-13 | US | Missouri | Dade | 29057 | 939 | 38 | 0 | 37.431814 | -93.8503345 | 2021-12-14 04:22:38 | Dade, Missouri, US | |
1663143 | 1663143 | 2021-12-12 | US | Puerto Rico | Aibonito | 72009 | 939 | 0 | 0 | 18.131361 | -66.264131 | 2021-12-13 04:22:02 | Aibonito, Puerto Rico, US | |
1662321 | 1662321 | 2021-12-12 | US | Missouri | Dade | 29057 | 939 | 38 | 0 | 37.431814 | -93.8503345 | 2021-12-13 04:22:02 | Dade, Missouri, US | |
3656202 | 3656202 | 2021-12-10 | US | Colorado | Clear Creek | 8019 | 939 | 7 | 0 | 39.68864463 | -105.6463118 | 2021-12-11 04:22:45 | Clear Creek, Colorado, US | |
1743709 | 1743709 | 2021-12-05 | US | Texas | McCulloch | 48307 | 939 | 39 | 0 | 31.1925468 | -99.34682807 | 2021-12-06 04:22:34 | McCulloch, Texas, US | |
141141 | 141141 | 2021-12-04 | US | Texas | McCulloch | 48307 | 939 | 39 | 0 | 31.1925468 | -99.34682807 | 2021-12-05 04:22:25 | McCulloch, Texas, US | |
140703 | 140703 | 2021-12-04 | US | Puerto Rico | Ciales | 72039 | 939 | 0 | 0 | 18.28885 | -66.516475 | 2021-12-05 04:22:25 | Ciales, Puerto Rico, US | |
2198356 | 2198356 | 2021-12-03 | US | Puerto Rico | Ciales | 72039 | 939 | 0 | 0 | 18.28885 | -66.516475 | 2021-12-04 04:22:18 | Ciales, Puerto Rico, 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]);