johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
460 rows where confirmed = 1239 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
720912 | 720912 | 2022-12-04 | US | North Dakota | Sargent | 38081 | 1239 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-12-05 04:20:58 | Sargent, North Dakota, US | |
2819201 | 2819201 | 2022-12-03 | US | North Dakota | Sargent | 38081 | 1239 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-12-04 04:20:56 | Sargent, North Dakota, US | |
836057 | 836057 | 2022-12-02 | US | North Dakota | Sargent | 38081 | 1239 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-12-03 04:21:02 | Sargent, North Dakota, US | |
2138587 | 2138587 | 2022-12-01 | US | North Dakota | Sargent | 38081 | 1239 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-12-02 04:21:07 | Sargent, North Dakota, US | |
1967003 | 1967003 | 2022-11-30 | US | North Dakota | Sargent | 38081 | 1239 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-12-01 04:21:03 | Sargent, North Dakota, US | |
3525445 | 3525445 | 2022-11-24 | US | Montana | Chouteau | 30015 | 1239 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-11-25 04:21:06 | Chouteau, Montana, US | |
3314228 | 3314228 | 2022-11-23 | US | Montana | Chouteau | 30015 | 1239 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-11-24 04:21:09 | Chouteau, Montana, US | |
1622269 | 1622269 | 2022-11-22 | US | Montana | Chouteau | 30015 | 1239 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-11-23 04:21:06 | Chouteau, Montana, US | |
1621175 | 1621175 | 2022-11-22 | US | Georgia | Warren | 13301 | 1239 | 33 | 0 | 33.41146451 | -82.67795848 | 2022-11-23 04:21:06 | Warren, Georgia, US | |
3462157 | 3462157 | 2022-11-21 | US | Montana | Chouteau | 30015 | 1239 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-11-22 04:20:47 | Chouteau, Montana, US | |
3461063 | 3461063 | 2022-11-21 | US | Georgia | Warren | 13301 | 1239 | 33 | 0 | 33.41146451 | -82.67795848 | 2022-11-22 04:20:47 | Warren, Georgia, US | |
1642342 | 1642342 | 2022-11-20 | US | Montana | Chouteau | 30015 | 1239 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-11-21 04:21:05 | Chouteau, Montana, US | |
1641248 | 1641248 | 2022-11-20 | US | Georgia | Warren | 13301 | 1239 | 33 | 0 | 33.41146451 | -82.67795848 | 2022-11-21 04:21:05 | Warren, Georgia, US | |
2065899 | 2065899 | 2022-11-19 | US | Montana | Chouteau | 30015 | 1239 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-11-20 04:21:08 | Chouteau, Montana, US | |
2064805 | 2064805 | 2022-11-19 | US | Georgia | Warren | 13301 | 1239 | 33 | 0 | 33.41146451 | -82.67795848 | 2022-11-20 04:21:08 | Warren, Georgia, US | |
1757293 | 1757293 | 2022-11-18 | US | Montana | Chouteau | 30015 | 1239 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-11-19 04:21:14 | Chouteau, Montana, US | |
1756199 | 1756199 | 2022-11-18 | US | Georgia | Warren | 13301 | 1239 | 33 | 0 | 33.41146451 | -82.67795848 | 2022-11-19 04:21:14 | Warren, Georgia, US | |
3027192 | 3027192 | 2022-11-17 | US | Georgia | Warren | 13301 | 1239 | 33 | 0 | 33.41146451 | -82.67795848 | 2022-11-18 04:21:15 | Warren, Georgia, US | |
2486903 | 2486903 | 2022-11-16 | US | Georgia | Warren | 13301 | 1239 | 33 | 0 | 33.41146451 | -82.67795848 | 2022-11-17 04:21:11 | Warren, Georgia, US | |
2377086 | 2377086 | 2022-09-29 | US | Louisiana | Tensas | 22107 | 1239 | 13 | 0 | 32.00760749 | -91.32915234 | 2022-09-30 04:23:09 | Tensas, Louisiana, US | |
3574000 | 3574000 | 2022-09-19 | US | Virginia | Rappahannock | 51157 | 1239 | 12 | 0 | 38.68295619 | -78.15826963 | 2022-09-20 04:22:48 | Rappahannock, Virginia, US | |
3986436 | 3986436 | 2022-09-15 | China | Tibet | 1239 | 0 | 0 | 31.6927 | 88.0924 | 2022-09-16 04:21:19 | Tibet, China | |||
375600 | 375600 | 2022-09-13 | US | Virginia | Rappahannock | 51157 | 1239 | 11 | 0 | 38.68295619 | -78.15826963 | 2022-09-14 04:20:44 | Rappahannock, Virginia, US | |
2326675 | 2326675 | 2022-08-24 | US | Virginia | Craig | 51045 | 1239 | 22 | 0 | 37.48133648 | -80.21072274 | 2022-08-25 04:21:13 | Craig, Virginia, US | |
1254084 | 1254084 | 2022-08-23 | US | Virginia | Craig | 51045 | 1239 | 22 | 0 | 37.48133648 | -80.21072274 | 2022-08-24 04:20:46 | Craig, Virginia, US | |
2010650 | 2010650 | 2022-08-04 | US | Missouri | Reynolds | 29179 | 1239 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-08-05 04:20:52 | Reynolds, Missouri, US | |
1101373 | 1101373 | 2022-08-03 | US | Texas | Wheeler | 48483 | 1239 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-08-04 04:20:58 | Wheeler, Texas, US | |
1100077 | 1100077 | 2022-08-03 | US | Missouri | Reynolds | 29179 | 1239 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-08-04 04:20:58 | Reynolds, Missouri, US | |
1407002 | 1407002 | 2022-08-02 | US | Missouri | Reynolds | 29179 | 1239 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-08-03 04:20:59 | Reynolds, Missouri, US | |
1405922 | 1405922 | 2022-08-02 | US | Georgia | Talbot | 13263 | 1239 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-03 04:20:59 | Talbot, Georgia, US | |
3619040 | 3619040 | 2022-08-01 | US | Missouri | Reynolds | 29179 | 1239 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-08-02 04:20:53 | Reynolds, Missouri, US | |
3617960 | 3617960 | 2022-08-01 | US | Georgia | Talbot | 13263 | 1239 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-02 04:20:53 | Talbot, Georgia, US | |
3873520 | 3873520 | 2022-07-31 | US | Missouri | Reynolds | 29179 | 1239 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-08-01 04:21:03 | Reynolds, Missouri, US | |
3872440 | 3872440 | 2022-07-31 | US | Georgia | Talbot | 13263 | 1239 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-08-01 04:21:03 | Talbot, Georgia, US | |
676274 | 676274 | 2022-07-30 | US | Missouri | Reynolds | 29179 | 1239 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-07-31 04:21:02 | Reynolds, Missouri, US | |
675194 | 675194 | 2022-07-30 | US | Georgia | Talbot | 13263 | 1239 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-31 04:21:02 | Talbot, Georgia, US | |
1785473 | 1785473 | 2022-07-29 | US | Missouri | Reynolds | 29179 | 1239 | 26 | 0 | 37.36085952 | -90.97009925 | 2022-07-30 04:20:42 | Reynolds, Missouri, US | |
1784393 | 1784393 | 2022-07-29 | US | Georgia | Talbot | 13263 | 1239 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-30 04:20:42 | Talbot, Georgia, US | |
1066756 | 1066756 | 2022-07-28 | US | Georgia | Talbot | 13263 | 1239 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-29 04:20:45 | Talbot, Georgia, US | |
2336275 | 2336275 | 2022-07-27 | US | Georgia | Talbot | 13263 | 1239 | 33 | 0 | 32.69642758 | -84.53351366 | 2022-07-28 04:20:56 | Talbot, Georgia, US | |
2597396 | 2597396 | 2022-07-25 | US | Virginia | King and Queen | 51097 | 1239 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-26 04:20:58 | King and Queen, Virginia, US | |
3430464 | 3430464 | 2022-07-14 | US | Louisiana | Cameron | 22023 | 1239 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-07-15 04:20:53 | Cameron, Louisiana, US | |
2743034 | 2743034 | 2022-07-07 | US | Montana | Pondera | 30073 | 1239 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-07-08 04:20:56 | Pondera, Montana, US | |
1201829 | 1201829 | 2022-07-06 | US | Montana | Pondera | 30073 | 1239 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-07-07 04:20:55 | Pondera, Montana, US | |
3968572 | 3968572 | 2022-07-05 | US | Montana | Pondera | 30073 | 1239 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-07-06 04:20:58 | Pondera, Montana, US | |
3081229 | 3081229 | 2022-07-04 | US | Texas | Martin | 48317 | 1239 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-07-05 04:20:45 | Martin, Texas, US | |
3080083 | 3080083 | 2022-07-04 | US | Montana | Pondera | 30073 | 1239 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-07-05 04:20:45 | Pondera, Montana, US | |
3079059 | 3079059 | 2022-07-04 | US | Illinois | Henderson | 17071 | 1239 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-05 04:20:45 | Henderson, Illinois, US | |
1770511 | 1770511 | 2022-07-03 | US | Texas | Martin | 48317 | 1239 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-07-04 04:20:54 | Martin, Texas, US | |
1769365 | 1769365 | 2022-07-03 | US | Montana | Pondera | 30073 | 1239 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-07-04 04:20:54 | Pondera, Montana, US | |
1768341 | 1768341 | 2022-07-03 | US | Illinois | Henderson | 17071 | 1239 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-04 04:20:54 | Henderson, Illinois, US | |
3368497 | 3368497 | 2022-07-02 | US | Texas | Martin | 48317 | 1239 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-07-03 04:20:59 | Martin, Texas, US | |
3367351 | 3367351 | 2022-07-02 | US | Montana | Pondera | 30073 | 1239 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-07-03 04:20:59 | Pondera, Montana, US | |
3366327 | 3366327 | 2022-07-02 | US | Illinois | Henderson | 17071 | 1239 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-03 04:20:59 | Henderson, Illinois, US | |
596826 | 596826 | 2022-07-01 | US | Texas | Martin | 48317 | 1239 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-07-02 04:21:16 | Martin, Texas, US | |
595680 | 595680 | 2022-07-01 | US | Montana | Pondera | 30073 | 1239 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-07-02 04:21:16 | Pondera, Montana, US | |
594656 | 594656 | 2022-07-01 | US | Illinois | Henderson | 17071 | 1239 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-07-02 04:21:16 | Henderson, Illinois, US | |
560544 | 560544 | 2022-06-16 | US | Minnesota | Lincoln | 27081 | 1239 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-06-17 04:20:56 | Lincoln, Minnesota, US | |
3984346 | 3984346 | 2022-06-15 | US | Minnesota | Lincoln | 27081 | 1239 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-06-16 04:20:55 | Lincoln, Minnesota, US | |
1947597 | 1947597 | 2022-06-10 | US | Texas | Goliad | 48175 | 1239 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-06-11 04:21:01 | Goliad, Texas, US | |
3160736 | 3160736 | 2022-06-09 | US | Texas | Goliad | 48175 | 1239 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-06-10 04:20:55 | Goliad, Texas, US | |
1187863 | 1187863 | 2022-05-18 | US | Texas | Hemphill | 48211 | 1239 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-05-19 04:20:54 | Hemphill, Texas, US | |
3585760 | 3585760 | 2022-05-17 | US | Texas | Hemphill | 48211 | 1239 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-05-18 04:20:50 | Hemphill, Texas, US | |
1506717 | 1506717 | 2022-05-16 | US | Texas | Hemphill | 48211 | 1239 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-05-17 04:20:59 | Hemphill, Texas, US | |
2087076 | 2087076 | 2022-05-15 | US | Texas | Hemphill | 48211 | 1239 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-05-16 04:20:47 | Hemphill, Texas, US | |
3357786 | 3357786 | 2022-05-14 | US | Texas | Hemphill | 48211 | 1239 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-05-15 04:20:53 | Hemphill, Texas, US | |
661431 | 661431 | 2022-05-13 | US | Texas | Hemphill | 48211 | 1239 | 7 | 0 | 35.83764858 | -100.2703577 | 2022-05-14 04:20:48 | Hemphill, Texas, US | |
2310503 | 2310503 | 2022-04-20 | US | Texas | San Saba | 48411 | 1239 | 35 | 0 | 31.1577796 | -98.81758731 | 2022-04-21 04:20:46 | San Saba, Texas, US | |
161225 | 161225 | 2022-03-29 | US | Texas | Sabine | 48403 | 1239 | 88 | 0 | 31.34318809 | -93.85440451 | 2022-03-30 04:20:45 | Sabine, Texas, US | |
697674 | 697674 | 2022-03-17 | US | Vermont | Essex | 50009 | 1239 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-03-18 04:20:55 | Essex, Vermont, US | |
2322094 | 2322094 | 2022-03-16 | US | Puerto Rico | Maunabo | 72095 | 1239 | 0 | 0 | 18.017889 | -65.922235 | 2022-03-17 04:20:56 | Maunabo, Puerto Rico, US | |
2319129 | 2319129 | 2022-03-16 | China | Hunan | 1239 | 4 | 0 | 27.6104 | 111.7088 | 2022-03-17 04:20:56 | Hunan, China | |||
2266987 | 2266987 | 2022-03-14 | US | Texas | Garza | 48169 | 1239 | 27 | 0 | 33.17969345 | -101.2984114 | 2022-03-15 04:20:47 | Garza, Texas, US | |
3631053 | 3631053 | 2022-03-13 | US | Texas | Garza | 48169 | 1239 | 27 | 0 | 33.17969345 | -101.2984114 | 2022-03-14 04:20:46 | Garza, Texas, US | |
953961 | 953961 | 2022-03-12 | US | Texas | Garza | 48169 | 1239 | 27 | 0 | 33.17969345 | -101.2984114 | 2022-03-13 04:20:49 | Garza, Texas, US | |
2142208 | 2142208 | 2022-03-09 | US | Montana | Toole | 30101 | 1239 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-03-10 04:20:48 | Toole, Montana, US | |
921719 | 921719 | 2022-03-08 | US | Montana | Toole | 30101 | 1239 | 23 | 0 | 48.65577551 | -111.69424140000001 | 2022-03-09 04:20:59 | Toole, Montana, US | |
2477394 | 2477394 | 2022-02-03 | US | Washington | Ferry | 53019 | 1239 | 20 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-04 04:21:10 | Ferry, Washington, US | |
462819 | 462819 | 2022-02-02 | US | Washington | Ferry | 53019 | 1239 | 20 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-03 04:21:21 | Ferry, Washington, US | |
3301655 | 3301655 | 2022-01-30 | US | Kentucky | Menifee | 21165 | 1239 | 29 | 0 | 37.94090733 | -83.59985712 | 2022-01-31 04:21:09 | Menifee, Kentucky, US | |
3063446 | 3063446 | 2022-01-29 | US | Kentucky | Menifee | 21165 | 1239 | 29 | 0 | 37.94090733 | -83.59985712 | 2022-01-30 04:21:26 | Menifee, Kentucky, US | |
3811380 | 3811380 | 2022-01-28 | US | Kentucky | Menifee | 21165 | 1239 | 29 | 0 | 37.94090733 | -83.59985712 | 2022-01-29 04:21:10 | Menifee, Kentucky, US | |
3227406 | 3227406 | 2022-01-19 | US | Idaho | Power | 16077 | 1239 | 17 | 0 | 42.69254894 | -112.83957420000002 | 2022-01-20 04:21:07 | Power, Idaho, US | |
3227382 | 3227382 | 2022-01-19 | US | Idaho | Caribou | 16029 | 1239 | 23 | 0 | 42.77149116 | -111.5597683 | 2022-01-20 04:21:07 | Caribou, Idaho, US | |
3467080 | 3467080 | 2022-01-18 | US | South Dakota | Spink | 46115 | 1239 | 32 | 0 | 44.93837606 | -98.34626602 | 2022-01-19 04:21:23 | Spink, South Dakota, US | |
1475019 | 1475019 | 2022-01-17 | US | South Dakota | Spink | 46115 | 1239 | 32 | 0 | 44.93837606 | -98.34626602 | 2022-01-18 04:21:04 | Spink, South Dakota, US | |
557693 | 557693 | 2022-01-16 | US | South Dakota | Spink | 46115 | 1239 | 32 | 0 | 44.93837606 | -98.34626602 | 2022-01-17 04:21:08 | Spink, South Dakota, US | |
3843414 | 3843414 | 2022-01-15 | US | South Dakota | Spink | 46115 | 1239 | 32 | 0 | 44.93837606 | -98.34626602 | 2022-01-16 04:21:12 | Spink, South Dakota, US | |
102229 | 102229 | 2022-01-14 | US | South Dakota | Spink | 46115 | 1239 | 32 | 0 | 44.93837606 | -98.34626602 | 2022-01-15 04:21:07 | Spink, South Dakota, US | |
1694937 | 1694937 | 2022-01-10 | US | Oregon | Grant | 41023 | 1239 | 17 | 0 | 44.49024544 | -119.0068631 | 2022-01-11 04:22:01 | Grant, Oregon, US | |
1692004 | 1692004 | 2022-01-10 | Australia | Western Australia | 1239 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-11 04:22:01 | Western Australia, Australia | |||
1671840 | 1671840 | 2021-12-29 | US | Virginia | Northampton | 51131 | 1239 | 49 | 0 | 37.34062933 | -75.87751591 | 2021-12-30 04:21:25 | Northampton, Virginia, US | |
1668967 | 1668967 | 2021-12-29 | US | Arkansas | Monroe | 5095 | 1239 | 26 | 0 | 34.6815935 | -91.20540287 | 2021-12-30 04:21:25 | Monroe, Arkansas, US | |
733245 | 733245 | 2021-12-27 | US | Puerto Rico | Aibonito | 72009 | 1239 | 0 | 0 | 18.131361 | -66.264131 | 2021-12-28 04:21:47 | Aibonito, Puerto Rico, US | |
2112684 | 2112684 | 2021-12-26 | US | Illinois | Edwards | 17047 | 1239 | 21 | 0 | 38.41353228 | -88.05720863 | 2021-12-27 04:21:58 | Edwards, Illinois, US | |
2111505 | 2111505 | 2021-12-26 | China | Shaanxi | 1239 | 3 | 0 | 35.1917 | 108.8701 | 2021-12-27 04:21:58 | Shaanxi, China | |||
3606056 | 3606056 | 2021-12-25 | US | Illinois | Edwards | 17047 | 1239 | 21 | 0 | 38.41353228 | -88.05720863 | 2021-12-26 04:21:50 | Edwards, Illinois, US | |
2964374 | 2964374 | 2021-12-24 | US | Illinois | Edwards | 17047 | 1239 | 21 | 0 | 38.41353228 | -88.05720863 | 2021-12-25 04:21:37 | Edwards, Illinois, US | |
3817406 | 3817406 | 2021-12-23 | US | Illinois | Edwards | 17047 | 1239 | 21 | 0 | 38.41353228 | -88.05720863 | 2021-12-24 04:21:34 | Edwards, Illinois, US | |
3829316 | 3829316 | 2021-12-21 | US | Georgia | Miller | 13201 | 1239 | 24 | 0 | 31.16568912 | -84.73151117 | 2021-12-22 04:21:54 | Miller, 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]);