johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where active = 3299 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3709803 | 3709803 | 2021-07-17 | Malaysia | Pahang | 18107 | 177 | 14631 | 3299 | 3.8126 | 103.3256 | 2021-07-18 04:22:07 | Pahang, Malaysia | ||
3145309 | 3145309 | 2021-06-07 | Brazil | Acre | 83350 | 1692 | 78359 | 3299 | -9.0238 | -70.812 | 2021-06-08 04:22:35 | Acre, Brazil | ||
726733 | 726733 | 2021-05-22 | Russia | Perm Krai | 56595 | 2369 | 50927 | 3299 | 58.5951603 | 56.3159546 | 2021-05-23 04:20:51 | Perm Krai, Russia | ||
2210611 | 2210611 | 2021-03-04 | US | Tennessee | Macon | 47111 | 3374 | 73 | 0 | 3299 | 36.53157855 | -86.00778595 | 2021-03-05 05:26:29 | Macon, Tennessee, US |
1859007 | 1859007 | 2021-02-25 | US | Illinois | Lee | 17103 | 3342 | 43 | 0 | 3299 | 41.74583951 | -89.29977132 | 2021-02-26 05:22:40 | Lee, Illinois, US |
743813 | 743813 | 2021-02-20 | US | Louisiana | Iberville | 22047 | 3390 | 91 | 0 | 3299 | 30.25734305 | -91.3499598 | 2021-02-21 05:24:33 | Iberville, Louisiana, US |
472911 | 472911 | 2021-02-19 | US | Louisiana | Iberville | 22047 | 3390 | 91 | 0 | 3299 | 30.25734305 | -91.3499598 | 2021-02-20 05:22:51 | Iberville, Louisiana, US |
1156214 | 1156214 | 2021-02-18 | US | Texas | Grimes | 48185 | 4008 | 60 | 0 | 3299 | 30.54579585 | -95.98902499 | 2021-02-19 05:24:16 | Grimes, Texas, US |
1155855 | 1155855 | 2021-02-18 | US | Puerto Rico | Guaynabo | 72061 | 3299 | 0 | 0 | 3299 | 18.345114 | -66.11452299999999 | 2021-02-19 05:24:16 | Guaynabo, Puerto Rico, US |
3603238 | 3603238 | 2021-02-17 | US | New Mexico | Rio Arriba | 35039 | 3361 | 62 | 0 | 3299 | 36.51072137 | -106.6931674 | 2021-02-18 05:22:58 | Rio Arriba, New Mexico, US |
3602772 | 3602772 | 2021-02-17 | US | Minnesota | McLeod | 27085 | 3348 | 49 | 0 | 3299 | 44.82367677 | -94.27287017 | 2021-02-18 05:22:58 | McLeod, Minnesota, US |
3052441 | 3052441 | 2021-02-16 | US | New York | Tompkins | 36109 | 3340 | 41 | 0 | 3299 | 42.44945765 | -76.47229843 | 2021-02-17 05:23:10 | Tompkins, New York, US |
1529044 | 1529044 | 2021-02-09 | US | Indiana | Whitley | 18183 | 3333 | 34 | 0 | 3299 | 41.13863784 | -85.50791236 | 2021-02-10 05:22:41 | Whitley, Indiana, US |
616231 | 616231 | 2021-02-08 | US | Oklahoma | Garvin | 40049 | 3337 | 38 | 0 | 3299 | 34.70418038 | -97.30811132 | 2021-02-09 05:23:30 | Garvin, Oklahoma, US |
614403 | 614403 | 2021-02-08 | US | Florida | Okeechobee | 12093 | 3367 | 68 | 0 | 3299 | 27.386336199999995 | -80.88944347 | 2021-02-09 05:23:30 | Okeechobee, Florida, US |
1588727 | 1588727 | 2021-02-05 | US | California | Mendocino | 6045 | 3340 | 38 | 0 | 3299 | 39.4381191 | -123.3911313 | 2021-02-06 05:23:55 | Mendocino, California, US |
1685607 | 1685607 | 2021-02-02 | US | Indiana | Miami | 18103 | 3356 | 57 | 0 | 3299 | 40.76940965 | -86.04525048 | 2021-02-03 05:22:52 | Miami, Indiana, US |
1897652 | 1897652 | 2021-01-29 | US | Arkansas | Miller | 5091 | 3328 | 29 | 0 | 3299 | 33.31403423 | -93.89285258 | 2021-01-30 05:22:49 | Miller, Arkansas, US |
2482454 | 2482454 | 2021-01-28 | US | Arkansas | Independence | 5063 | 3410 | 111 | 0 | 3299 | 35.74242707 | -91.57001641 | 2021-01-29 05:22:23 | Independence, Arkansas, US |
3154802 | 3154802 | 2021-01-27 | US | Iowa | Jasper | 19099 | 3358 | 59 | 0 | 3299 | 41.68576082 | -93.05567785 | 2021-01-28 05:22:24 | Jasper, Iowa, US |
13436 | 13436 | 2021-01-26 | US | Indiana | Knox | 18083 | 3378 | 79 | 0 | 3299 | 38.68861576 | -87.4194665 | 2021-01-27 05:23:41 | Knox, Indiana, US |
2427136 | 2427136 | 2021-01-23 | Russia | Orenburg Oblast | 32732 | 440 | 28993 | 3299 | 52.02692620000001 | 54.7276647 | 2021-01-24 05:22:35 | Orenburg Oblast, Russia | ||
1096613 | 1096613 | 2021-01-20 | US | Oklahoma | Caddo | 40015 | 3342 | 43 | 0 | 3299 | 35.17364557 | -98.37534464 | 2021-01-21 05:22:01 | Caddo, Oklahoma, US |
239800 | 239800 | 2021-01-18 | US | Oklahoma | Logan | 40083 | 3315 | 16 | 0 | 3299 | 35.91899576 | -97.44352845 | 2021-01-19 05:22:15 | Logan, Oklahoma, US |
3504630 | 3504630 | 2021-01-17 | US | Kansas | Ellis | 20051 | 3360 | 61 | 0 | 3299 | 38.91458712 | -99.31751551 | 2021-01-18 05:22:34 | Ellis, Kansas, US |
3102713 | 3102713 | 2021-01-16 | US | Kansas | Ellis | 20051 | 3360 | 61 | 0 | 3299 | 38.91458712 | -99.31751551 | 2021-01-17 05:22:17 | Ellis, Kansas, US |
3516675 | 3516675 | 2021-01-15 | US | Kansas | Ellis | 20051 | 3360 | 61 | 0 | 3299 | 38.91458712 | -99.31751551 | 2021-01-16 05:22:40 | Ellis, Kansas, US |
3780403 | 3780403 | 2020-12-27 | US | Ohio | Sandusky | 39143 | 3375 | 76 | 0 | 3299 | 41.35624126 | -83.137872 | 2020-12-28 05:22:06 | Sandusky, Ohio, US |
2931450 | 2931450 | 2020-12-19 | Russia | Novosibirsk Oblast | 25971 | 874 | 21798 | 3299 | 54.9720169 | 79.48139240000002 | 2020-12-20 05:27:32 | Novosibirsk Oblast, Russia | ||
3847996 | 3847996 | 2020-12-13 | Russia | Khakassia Republic | 14410 | 171 | 10940 | 3299 | 53.72258845 | 91.44293627 | 2020-12-14 05:26:27 | Khakassia Republic, Russia | ||
1601376 | 1601376 | 2020-12-10 | US | Iowa | Buena Vista | 19021 | 3313 | 14 | 0 | 3299 | 42.73545875 | -95.15100162 | 2020-12-11 05:26:59 | Buena Vista, Iowa, US |
123438 | 123438 | 2020-11-18 | US | Florida | Walton | 12131 | 3333 | 34 | 0 | 3299 | 30.64204028 | -86.16935664 | 2020-11-19 05:25:23 | Walton, Florida, US |
272512 | 272512 | 2020-11-10 | US | Alabama | Cullman | 1043 | 3328 | 29 | 0 | 3299 | 34.13020303 | -86.86888037 | 2020-11-11 05:25:30 | Cullman, Alabama, US |
377592 | 377592 | 2020-11-06 | US | Kentucky | Kenton | 21117 | 3350 | 51 | 0 | 3299 | 38.93950319 | -84.53241199 | 2020-11-07 05:24:52 | Kenton, Kentucky, US |
3651816 | 3651816 | 2020-10-24 | Russia | Tomsk Oblast | 11008 | 111 | 7598 | 3299 | 58.6124279 | 82.04753149999998 | 2020-10-25 04:24:36 | Tomsk Oblast, Russia | ||
3651556 | 3651556 | 2020-10-24 | Italy | Marche | 10919 | 1001 | 6619 | 3299 | 43.61675973 | 13.5188753 | 2020-10-25 04:24:36 | Marche, Italy | ||
2192931 | 2192931 | 2020-10-21 | US | Kansas | Shawnee | 20177 | 3376 | 77 | 0 | 3299 | 39.04100763 | -95.7557264 | 2020-10-22 04:24:27 | Shawnee, Kansas, US |
3991942 | 3991942 | 2020-10-20 | US | Kansas | Shawnee | 20177 | 3376 | 77 | 0 | 3299 | 39.04100763 | -95.7557264 | 2020-10-21 04:24:14 | Shawnee, Kansas, US |
1824597 | 1824597 | 2020-10-04 | US | Mississippi | Madison | 28089 | 3389 | 90 | 0 | 3299 | 32.63389156 | -90.03513564 | 2020-10-05 04:23:33 | Madison, Mississippi, US |
2616396 | 2616396 | 2020-09-26 | US | North Carolina | Wayne | 37191 | 3366 | 67 | 0 | 3299 | 35.36438125 | -78.00027268 | 2020-09-27 04:23:00 | Wayne, North Carolina, US |
3316648 | 3316648 | 2020-09-22 | US | Arizona | Apache | 4001 | 3462 | 163 | 0 | 3299 | 35.39465006 | -109.4892383 | 2020-09-23 04:23:00 | Apache, Arizona, US |
2454550 | 2454550 | 2020-09-19 | Canada | Quebec | 67610 | 5821 | 58490 | 3299 | 52.9399 | -73.5491 | 2020-09-20 04:22:00 | Quebec, Canada | ||
2512554 | 2512554 | 2020-08-27 | US | North Dakota | Cass | 38017 | 3434 | 76 | 0 | 3299 | 46.93201724 | -97.2444719 | 2020-08-28 04:28:11 | Cass, North Dakota, US |
1999621 | 1999621 | 2020-08-26 | US | Tennessee | Unassigned | 90047 | 508 | 4 | 0 | 3299 | 36.55606529 | 0.0 | 2020-08-27 04:28:15 | Unassigned, Tennessee, US |
1481980 | 1481980 | 2020-08-21 | US | Ohio | Butler | 39017 | 3374 | 75 | 0 | 3299 | 39.44012838 | -84.57388716 | 2020-08-22 04:27:49 | Butler, Ohio, US |
3180158 | 3180158 | 2020-08-18 | US | New Jersey | Gloucester | 34015 | 3516 | 217 | 0 | 3299 | 39.71581067 | -75.13995546 | 2020-08-19 04:27:00 | Gloucester, New Jersey, US |
3177864 | 3177864 | 2020-08-18 | Colombia | Norte de Santander | 7293 | 415 | 3579 | 3299 | 7.9463 | -72.8988 | 2020-08-19 04:27:00 | Norte de Santander, Colombia | ||
98412 | 98412 | 2020-08-04 | Sweden | Ostergotland | 3560 | 261 | 0 | 3299 | 58.3454 | 15.5198 | 2020-08-05 04:34:43 | Ostergotland, Sweden | ||
97825 | 97825 | 2020-08-04 | US | Texas | Victoria | 48469 | 3125 | 32 | 0 | 3299 | 28.79780988 | -96.96813006 | 2020-08-05 04:34:43 | Victoria, Texas, US |
2737474 | 2737474 | 2020-08-03 | US | Mississippi | DeSoto | 28033 | 3326 | 27 | 0 | 3299 | 34.87625235 | -89.99091418 | 2020-08-04 04:41:59 | DeSoto, Mississippi, US |
2562118 | 2562118 | 2020-07-24 | US | Florida | Martin | 12085 | 3357 | 58 | 0 | 3299 | 27.0772071 | -80.43109784 | 2020-07-25 04:47:39 | Martin, Florida, US |
3680704 | 3680704 | 2020-06-18 | US | Kentucky | Jefferson | 21111 | 3481 | 182 | 0 | 3299 | 38.18664655 | -85.65931031 | 2020-06-19 04:33:17 | Jefferson, Kentucky, US |
1281163 | 1281163 | 2020-06-04 | Peru | Ica | 3919 | 620 | 0 | 3299 | -14.235097 | -75.574821 | 2020-06-05 02:33:06 | Ica, Peru | ||
3259357 | 3259357 | 2020-05-18 | US | Pennsylvania | Lehigh | 42077 | 3472 | 173 | 0 | 3299 | 40.6154815 | -75.59435245 | 2020-05-19 02:32:18 | Lehigh, Pennsylvania, 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]);