johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where active = 4018 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3472262 | 3472262 | 2021-06-08 | India | Sikkim | 17425 | 275 | 13132 | 4018 | 27.571671 | 88.472712 | 2021-06-09 04:23:31 | Sikkim, India | ||
3093044 | 3093044 | 2021-05-30 | Ukraine | Donetsk Oblast | 89212 | 2233 | 82961 | 4018 | 48.0159 | 37.8028 | 2021-05-31 03:08:59 | Donetsk Oblast, Ukraine | ||
3702179 | 3702179 | 2021-04-27 | Maldives | 28588 | 71 | 24499 | 4018 | 3.2028 | 73.2207 | 2021-04-28 04:20:32 | Maldives | |||
2359433 | 2359433 | 2021-03-08 | India | Tamil Nadu | 855677 | 12521 | 839138 | 4018 | 11.006091 | 78.400624 | 2021-03-09 05:28:19 | Tamil Nadu, India | ||
3668981 | 3668981 | 2021-03-06 | US | Kentucky | Barren | 21009 | 4089 | 71 | 0 | 4018 | 36.96469836 | -85.93338945 | 2021-03-07 05:21:54 | Barren, Kentucky, US |
2369328 | 2369328 | 2021-02-28 | US | Mississippi | Pontotoc | 28115 | 4087 | 69 | 0 | 4018 | 34.226046000000004 | -89.03636807 | 2021-03-01 05:23:01 | Pontotoc, Mississippi, US |
3603996 | 3603996 | 2021-02-17 | US | Tennessee | Lincoln | 47103 | 4057 | 60 | 0 | 4018 | 35.13738622 | -86.58910106 | 2021-02-18 05:22:58 | Lincoln, Tennessee, US |
3602199 | 3602199 | 2021-02-17 | US | Iowa | Buena Vista | 19021 | 4054 | 36 | 0 | 4018 | 42.73545875 | -95.15100162 | 2021-02-18 05:22:58 | Buena Vista, Iowa, US |
3051649 | 3051649 | 2021-02-16 | US | Kentucky | Whitley | 21235 | 4034 | 16 | 0 | 4018 | 36.75700531 | -84.14541217 | 2021-02-17 05:23:10 | Whitley, Kentucky, US |
2285059 | 2285059 | 2021-02-14 | US | Michigan | Ionia | 26067 | 4085 | 67 | 0 | 4018 | 42.94502238 | -85.07413319 | 2021-02-15 05:24:49 | Ionia, Michigan, US |
2679459 | 2679459 | 2021-02-13 | US | Michigan | Ionia | 26067 | 4085 | 67 | 0 | 4018 | 42.94502238 | -85.07413319 | 2021-02-14 05:23:43 | Ionia, Michigan, US |
2484564 | 2484564 | 2021-01-28 | US | Oklahoma | Washington | 40147 | 4094 | 76 | 0 | 4018 | 36.71380786 | -95.90514104 | 2021-01-29 05:22:23 | Washington, Oklahoma, US |
3103943 | 3103943 | 2021-01-16 | US | Ohio | Seneca | 39147 | 4117 | 99 | 0 | 4018 | 41.12351311 | -83.12783209 | 2021-01-17 05:22:17 | Seneca, Ohio, US |
3517837 | 3517837 | 2021-01-15 | US | Ohio | Auglaize | 39011 | 4092 | 74 | 0 | 4018 | 40.55998859 | -84.22421429999999 | 2021-01-16 05:22:40 | Auglaize, Ohio, US |
3309292 | 3309292 | 2021-01-13 | US | Indiana | Jackson | 18071 | 4074 | 56 | 0 | 4018 | 38.90915820000001 | -86.03851889 | 2021-01-14 05:22:32 | Jackson, Indiana, US |
191634 | 191634 | 2021-01-11 | US | Maryland | Cecil | 24015 | 4100 | 82 | 0 | 4018 | 39.56647682 | -75.94627411 | 2021-01-12 05:22:15 | Cecil, Maryland, US |
2865785 | 2865785 | 2021-01-06 | US | Indiana | Dearborn | 18029 | 4067 | 49 | 0 | 4018 | 39.14647946 | -84.97333539 | 2021-01-07 05:22:03 | Dearborn, Indiana, US |
1137994 | 1137994 | 2021-01-01 | US | Indiana | Noble | 18113 | 4081 | 63 | 0 | 4018 | 41.39672484 | -85.41966713 | 2021-01-02 05:22:33 | Noble, Indiana, US |
3761921 | 3761921 | 2020-12-28 | US | Alabama | Autauga | 1001 | 4065 | 47 | 0 | 4018 | 32.53952745 | -86.64408227 | 2020-12-29 05:22:37 | Autauga, Alabama, US |
3770375 | 3770375 | 2020-12-22 | US | Arkansas | Mississippi | 5093 | 4110 | 92 | 0 | 4018 | 35.76271485 | -90.05194370000002 | 2020-12-23 05:22:03 | Mississippi, Arkansas, US |
1634642 | 1634642 | 2020-12-05 | US | North Carolina | Orange | 37135 | 4080 | 62 | 0 | 4018 | 36.06092947 | -79.12167935 | 2020-12-06 05:26:18 | Orange, North Carolina, US |
1634092 | 1634092 | 2020-12-05 | US | Mississippi | Forrest | 28035 | 4107 | 89 | 0 | 4018 | 31.18961454 | -89.25832496 | 2020-12-06 05:26:18 | Forrest, Mississippi, US |
3860267 | 3860267 | 2020-12-04 | US | Arizona | Cochise | 4003 | 4106 | 88 | 0 | 4018 | 31.87934684 | -109.7516088 | 2020-12-05 05:27:36 | Cochise, Arizona, US |
822368 | 822368 | 2020-11-19 | US | Georgia | Glynn | 13127 | 4134 | 116 | 0 | 4018 | 31.23279254 | -81.53811412 | 2020-11-20 05:26:28 | Glynn, Georgia, US |
3338780 | 3338780 | 2020-11-17 | Russia | Bryansk Oblast | 15511 | 99 | 11394 | 4018 | 52.8873315 | 33.41585300000001 | 2020-11-18 05:40:31 | Bryansk Oblast, Russia | ||
2788095 | 2788095 | 2020-11-13 | US | Texas | Gregg | 48183 | 1969 | 97 | 0 | 4018 | 32.47940482 | -94.81591935 | 2020-11-14 05:25:37 | Gregg, Texas, US |
3444429 | 3444429 | 2020-11-11 | Ukraine | Crimea Republic* | 11364 | 184 | 7162 | 4018 | 45.2835 | 34.2008 | 2020-11-12 05:25:55 | Crimea Republic*, Ukraine | ||
2920516 | 2920516 | 2020-11-04 | US | Kansas | Shawnee | 20177 | 4103 | 85 | 0 | 4018 | 39.04100763 | -95.7557264 | 2020-11-05 06:05:03 | Shawnee, Kansas, US |
2499353 | 2499353 | 2020-11-03 | US | Kansas | Shawnee | 20177 | 4103 | 85 | 0 | 4018 | 39.04100763 | -95.7557264 | 2020-11-04 05:25:09 | Shawnee, Kansas, US |
3992112 | 3992112 | 2020-10-20 | US | Louisiana | Livingston | 22063 | 4097 | 79 | 0 | 4018 | 30.44143993 | -90.73061664 | 2020-10-21 04:24:14 | Livingston, Louisiana, US |
1028716 | 1028716 | 2020-10-17 | US | North Carolina | Wayne | 37191 | 4095 | 77 | 0 | 4018 | 35.36438125 | -78.00027268 | 2020-10-18 04:24:25 | Wayne, North Carolina, US |
789582 | 789582 | 2020-10-15 | US | Texas | Smith | 48423 | 2601 | 119 | 0 | 4018 | 32.37474036 | -95.2717568 | 2020-10-16 04:24:01 | Smith, Texas, US |
2605319 | 2605319 | 2020-10-10 | US | Virginia | Arlington | 51013 | 4170 | 152 | 0 | 4018 | 38.8767675 | -77.10139853 | 2020-10-11 04:23:46 | Arlington, Virginia, US |
1042205 | 1042205 | 2020-10-07 | US | Alabama | Marshall | 1095 | 4063 | 45 | 0 | 4018 | 34.36975964 | -86.30486727 | 2020-10-08 04:23:56 | Marshall, Alabama, US |
3319472 | 3319472 | 2020-09-22 | US | Utah | Southwest Utah | 4048 | 30 | 0 | 4018 | 37.85447192 | -111.4418764 | 2020-09-23 04:23:00 | Southwest Utah, Utah, US | |
2872015 | 2872015 | 2020-09-13 | US | Virginia | Chesapeake | 51550 | 4067 | 49 | 0 | 4018 | 36.67670048 | -76.30545744 | 2020-09-14 04:26:00 | Chesapeake, Virginia, US |
1523890 | 1523890 | 2020-08-28 | US | Florida | Okaloosa | 12091 | 4094 | 76 | 0 | 4018 | 30.69143028 | -86.59267105 | 2020-08-29 04:28:19 | Okaloosa, Florida, US |
3562891 | 3562891 | 2020-08-25 | Switzerland | 40262 | 1844 | 34400 | 4018 | 46.8182 | 8.2275 | 2020-08-26 04:28:11 | Switzerland | |||
1918313 | 1918313 | 2020-08-10 | US | Missouri | Jackson | 29095 | 4083 | 65 | 0 | 4018 | 39.01002188 | -94.34724536 | 2020-08-11 04:35:08 | Jackson, Missouri, US |
177609 | 177609 | 2020-07-27 | Morocco | 20887 | 316 | 16553 | 4018 | 31.7917 | -7.0926 | 2020-07-28 04:58:43 | Morocco | |||
414930 | 414930 | 2020-07-05 | US | Arkansas | Washington | 5143 | 4050 | 32 | 0 | 4018 | 35.976844 | -94.21800746 | 2020-07-06 04:33:57 | Washington, Arkansas, US |
3682964 | 3682964 | 2020-06-18 | Cameroon | 9864 | 276 | 5570 | 4018 | 3.8480000000000003 | 11.5021 | 2020-06-19 04:33:17 | Cameroon | |||
1196167 | 1196167 | 2020-06-17 | Cameroon | 9864 | 276 | 5570 | 4018 | 3.8480000000000003 | 11.5021 | 2020-06-18 04:33:18 | Cameroon | |||
2386930 | 2386930 | 2020-06-16 | Cameroon | 9864 | 276 | 5570 | 4018 | 3.8480000000000003 | 11.5021 | 2020-06-17 04:33:21 | Cameroon | |||
287493 | 287493 | 2020-06-15 | Cameroon | 9864 | 276 | 5570 | 4018 | 3.8480000000000003 | 11.5021 | 2020-06-16 04:33:09 | Cameroon | |||
3638755 | 3638755 | 2020-05-30 | Mexico | Ciudad de Mexico | 24265 | 2621 | 17626 | 4018 | 19.4326 | -99.1332 | 2020-05-31 02:32:45 | Ciudad de Mexico, Mexico | ||
267682 | 267682 | 2020-05-21 | US | New Jersey | Somerset | 34035 | 4405 | 387 | 0 | 4018 | 40.56465737 | -74.61683016 | 2020-05-22 02:36:51 | Somerset, New Jersey, 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]);