johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
55 rows where active = 3048 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- US 35
- Russia 7
- Central African Republic 2
- Ukraine 2
- Colombia 1
- Estonia 1
- Italy 1
- Kyrgyzstan 1
- Malaysia 1
- Morocco 1
- Netherlands 1
- Qatar 1
- Suriname 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385698 | 3385698 | 2021-07-29 | Suriname | 25218 | 643 | 21527 | 3048 | 3.9193 | -56.0278 | 2021-07-30 04:21:34 | Suriname | |||
2911059 | 2911059 | 2021-06-17 | Estonia | 130695 | 1267 | 126380 | 3048 | 58.5953 | 25.0136 | 2021-06-18 04:22:16 | Estonia | |||
3475978 | 3475978 | 2021-06-08 | Malaysia | Pulau Pinang | 31089 | 101 | 27940 | 3048 | 5.4141 | 100.3288 | 2021-06-09 04:23:31 | Pulau Pinang, Malaysia | ||
1448700 | 1448700 | 2021-06-03 | Morocco | 520423 | 9165 | 508210 | 3048 | 31.7917 | -7.0926 | 2021-06-04 04:23:37 | Morocco | |||
1416674 | 1416674 | 2021-05-24 | Ukraine | Chernihiv Oblast | 56192 | 1281 | 51863 | 3048 | 51.4982 | 31.2893 | 2021-05-25 04:21:08 | Chernihiv Oblast, Ukraine | ||
1425338 | 1425338 | 2021-05-09 | Russia | Perm Krai | 55340 | 2254 | 50038 | 3048 | 58.5951603 | 56.3159546 | 2021-05-10 04:20:38 | Perm Krai, Russia | ||
3242509 | 3242509 | 2021-04-21 | Russia | Altai Krai | 48942 | 2008 | 43886 | 3048 | 52.6932243 | 82.69314240000001 | 2021-04-22 04:20:53 | Altai Krai, Russia | ||
3883771 | 3883771 | 2021-04-11 | Russia | Altai Krai | 48124 | 1934 | 43142 | 3048 | 52.6932243 | 82.69314240000001 | 2021-04-12 04:21:00 | Altai Krai, Russia | ||
2371041 | 2371041 | 2021-02-28 | US | Wisconsin | Juneau | 55057 | 3068 | 20 | 0 | 3048 | 43.92456975 | -90.11120239 | 2021-03-01 05:23:01 | Juneau, Wisconsin, US |
744911 | 744911 | 2021-02-20 | US | Oklahoma | Woodward | 40153 | 3063 | 15 | 0 | 3048 | 36.42316318 | -99.26283045 | 2021-02-21 05:24:33 | Woodward, Oklahoma, US |
3053485 | 3053485 | 2021-02-16 | US | Virginia | Charlottesville | 51540 | 3088 | 40 | 0 | 3048 | 38.03527919 | -78.48569588 | 2021-02-17 05:23:10 | Charlottesville, Virginia, US |
2284160 | 2284160 | 2021-02-14 | US | Florida | Wakulla | 12129 | 3099 | 51 | 0 | 3048 | 30.16548905 | -84.39895211 | 2021-02-15 05:24:49 | Wakulla, Florida, US |
2680021 | 2680021 | 2021-02-13 | US | New Mexico | Otero | 35035 | 3098 | 50 | 0 | 3048 | 32.61348406 | -105.7417604 | 2021-02-14 05:23:43 | Otero, New Mexico, US |
1672949 | 1672949 | 2021-02-07 | US | Arkansas | Lincoln | 5079 | 3090 | 42 | 0 | 3048 | 33.95317155 | -91.74002806 | 2021-02-08 05:22:39 | Lincoln, Arkansas, US |
792618 | 792618 | 2021-02-04 | US | New York | Livingston | 36051 | 3097 | 49 | 0 | 3048 | 42.72596275 | -77.77966158 | 2021-02-05 05:22:38 | Livingston, New York, US |
2484771 | 2484771 | 2021-01-28 | US | South Carolina | Chester | 45023 | 3099 | 51 | 0 | 3048 | 34.69249168 | -81.1583216 | 2021-01-29 05:22:23 | Chester, South Carolina, US |
1760816 | 1760816 | 2021-01-24 | US | Louisiana | St. Bernard | 22087 | 3092 | 44 | 0 | 3048 | 29.87761636 | -89.51887093 | 2021-01-25 05:22:16 | St. Bernard, Louisiana, US |
3101686 | 3101686 | 2021-01-16 | Russia | Stavropol Krai | 38949 | 841 | 35060 | 3048 | 44.86325770000001 | 43.4406913 | 2021-01-17 05:22:17 | Stavropol Krai, Russia | ||
775550 | 775550 | 2021-01-12 | US | Iowa | Lee | 19111 | 3076 | 28 | 0 | 3048 | 40.64181461 | -91.48183025 | 2021-01-13 05:22:15 | Lee, Iowa, US |
3903319 | 3903319 | 2021-01-09 | US | Virginia | Manassas | 51683 | 3077 | 29 | 0 | 3048 | 38.7464321 | -77.48509905 | 2021-01-10 05:22:12 | Manassas, Virginia, US |
1062927 | 1062927 | 2021-01-04 | US | Indiana | Gibson | 18051 | 3120 | 72 | 0 | 3048 | 38.30393723 | -87.58054938 | 2021-01-05 05:21:49 | Gibson, Indiana, US |
2229054 | 2229054 | 2021-01-02 | US | Louisiana | Washington | 22117 | 3135 | 87 | 0 | 3048 | 30.85288548 | -90.03866652 | 2021-01-03 05:22:52 | Washington, Louisiana, US |
1138418 | 1138418 | 2021-01-01 | US | Louisiana | Washington | 22117 | 3135 | 87 | 0 | 3048 | 30.85288548 | -90.03866652 | 2021-01-02 05:22:33 | Washington, Louisiana, US |
3697024 | 3697024 | 2020-12-31 | US | Louisiana | Washington | 22117 | 3135 | 87 | 0 | 3048 | 30.85288548 | -90.03866652 | 2021-01-01 05:23:07 | Washington, Louisiana, US |
2130288 | 2130288 | 2020-12-17 | US | North Carolina | Columbus | 37047 | 3125 | 77 | 0 | 3048 | 34.26744084 | -78.65801424 | 2020-12-18 05:28:18 | Columbus, North Carolina, US |
1037161 | 1037161 | 2020-12-15 | US | Rhode Island | Washington | 44009 | 3144 | 96 | 0 | 3048 | 41.45961631 | -71.61435303 | 2020-12-16 05:28:04 | Washington, Rhode Island, US |
1754055 | 1754055 | 2020-12-14 | US | Rhode Island | Washington | 44009 | 3144 | 96 | 0 | 3048 | 41.45961631 | -71.61435303 | 2020-12-15 05:26:38 | Washington, Rhode Island, US |
3850575 | 3850575 | 2020-12-13 | US | Rhode Island | Washington | 44009 | 3144 | 96 | 0 | 3048 | 41.45961631 | -71.61435303 | 2020-12-14 05:26:27 | Washington, Rhode Island, US |
848357 | 848357 | 2020-12-12 | US | Rhode Island | Washington | 44009 | 3144 | 96 | 0 | 3048 | 41.45961631 | -71.61435303 | 2020-12-13 05:27:20 | Washington, Rhode Island, US |
863464 | 863464 | 2020-12-11 | US | Rhode Island | Washington | 44009 | 3144 | 96 | 0 | 3048 | 41.45961631 | -71.61435303 | 2020-12-12 05:26:19 | Washington, Rhode Island, US |
1603006 | 1603006 | 2020-12-10 | US | Rhode Island | Washington | 44009 | 3144 | 96 | 0 | 3048 | 41.45961631 | -71.61435303 | 2020-12-11 05:26:59 | Washington, Rhode Island, US |
1601207 | 1601207 | 2020-12-10 | US | Illinois | Jackson | 17077 | 3085 | 37 | 0 | 3048 | 37.78595185 | -89.38232563 | 2020-12-11 05:26:59 | Jackson, Illinois, US |
2978015 | 2978015 | 2020-12-09 | US | Rhode Island | Washington | 44009 | 3144 | 96 | 0 | 3048 | 41.45961631 | -71.61435303 | 2020-12-10 05:26:19 | Washington, Rhode Island, US |
2975460 | 2975460 | 2020-12-09 | Russia | Orenburg Oblast | 24805 | 246 | 21511 | 3048 | 52.02692620000001 | 54.7276647 | 2020-12-10 05:26:19 | Orenburg Oblast, Russia | ||
2349966 | 2349966 | 2020-12-07 | US | Oklahoma | Grady | 40051 | 3071 | 23 | 0 | 3048 | 35.0167709 | -97.88339847 | 2020-12-08 05:27:42 | Grady, Oklahoma, US |
2347552 | 2347552 | 2020-12-07 | Netherlands | Unknown | 2061 | 34 | 0 | 3048 | 2020-12-08 05:27:42 | Unknown, Netherlands | ||||
2938819 | 2938819 | 2020-11-28 | US | Wyoming | Albany | 56001 | 3057 | 9 | 0 | 3048 | 41.65498705 | -105.7235415 | 2020-11-29 05:25:55 | Albany, Wyoming, US |
2935462 | 2935462 | 2020-11-28 | Russia | Omsk Oblast | 22074 | 589 | 18437 | 3048 | 56.09352629999999 | 73.5099936 | 2020-11-29 05:25:55 | Omsk Oblast, Russia | ||
3189848 | 3189848 | 2020-11-22 | Colombia | Santander | 50131 | 1930 | 45153 | 3048 | 6.6437 | -73.6536 | 2020-11-23 05:25:26 | Santander, Colombia | ||
3170365 | 3170365 | 2020-11-16 | US | Florida | Suwannee | 12121 | 3130 | 82 | 0 | 3048 | 30.19746066 | -82.99099670000003 | 2020-11-17 05:25:54 | Suwannee, Florida, US |
3480984 | 3480984 | 2020-10-26 | US | Florida | Citrus | 12017 | 3178 | 130 | 0 | 3048 | 28.84804315 | -82.47614748 | 2020-10-27 04:24:45 | Citrus, Florida, US |
1042056 | 1042056 | 2020-10-07 | Russia | Perm Krai | 10430 | 301 | 7081 | 3048 | 58.5951603 | 56.3159546 | 2020-10-08 04:23:56 | Perm Krai, Russia | ||
3801952 | 3801952 | 2020-10-05 | Kyrgyzstan | 47635 | 1066 | 43521 | 3048 | 41.20438 | 74.766098 | 2020-10-06 04:23:33 | Kyrgyzstan | |||
2515735 | 2515735 | 2020-10-03 | US | Maryland | Harford | 24025 | 3124 | 76 | 0 | 3048 | 39.55010644 | -76.30775940000002 | 2020-10-04 04:23:44 | Harford, Maryland, US |
3389383 | 3389383 | 2020-10-02 | Italy | Sicilia | 7414 | 314 | 4052 | 3048 | 38.11569725 | 13.362356699999998 | 2020-10-03 04:23:40 | Sicilia, Italy | ||
1046503 | 1046503 | 2020-09-30 | US | Florida | Hernando | 12053 | 3175 | 127 | 0 | 3048 | 28.55364461 | -82.42700204 | 2020-10-01 04:23:42 | Hernando, Florida, US |
2584296 | 2584296 | 2020-09-27 | US | North Carolina | Iredell | 37097 | 3080 | 32 | 0 | 3048 | 35.80950511 | -80.8743128 | 2020-09-28 04:23:00 | Iredell, North Carolina, US |
668104 | 668104 | 2020-09-16 | US | Mississippi | Rankin | 28121 | 3121 | 73 | 0 | 3048 | 32.26469147 | -89.94537876 | 2020-09-17 04:22:00 | Rankin, Mississippi, US |
2870389 | 2870389 | 2020-09-13 | US | Michigan | Washtenaw | 26161 | 3162 | 114 | 0 | 3048 | 42.253105 | -83.83853204 | 2020-09-14 04:26:00 | Washtenaw, Michigan, US |
548428 | 548428 | 2020-09-12 | US | Michigan | Washtenaw | 26161 | 3162 | 114 | 0 | 3048 | 42.253105 | -83.83853204 | 2020-09-13 04:30:52 | Washtenaw, Michigan, US |
98588 | 98588 | 2020-08-04 | Ukraine | Zakarpattia Oblast | 5384 | 206 | 2130 | 3048 | 48.6208 | 22.2879 | 2020-08-05 04:34:43 | Zakarpattia Oblast, Ukraine | ||
2708907 | 2708907 | 2020-07-17 | Central African Republic | 4389 | 53 | 1288 | 3048 | 6.6111 | 20.9394 | 2020-07-18 04:34:45 | Central African Republic | |||
364575 | 364575 | 2020-07-16 | US | Georgia | Clayton | 13063 | 3132 | 84 | 0 | 3048 | 33.54187245 | -84.35594188 | 2020-07-17 04:34:50 | Clayton, Georgia, US |
2748382 | 2748382 | 2020-07-15 | Central African Republic | 4362 | 53 | 1261 | 3048 | 6.6111 | 20.9394 | 2020-07-16 04:44:59 | Central African Republic | |||
3338197 | 3338197 | 2020-04-14 | Qatar | 3428 | 7 | 373 | 3048 | 25.3548 | 51.1839 | 2020-04-14 23:33:12 | Qatar |
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]);