johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

34 rows where active = 91, country_or_region = "US" and province_or_state = "Minnesota" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Minnesota · 34 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2691396 2691396 2020-10-08 US Minnesota Lac qui Parle 27073 93 2 0 91 44.9973857 -96.17488219 2020-10-09 04:23:59 Lac qui Parle, Minnesota, US
1043582 1043582 2020-10-07 US Minnesota Wadena 27159 91 0 0 91 46.58589171 -94.96968506 2020-10-08 04:23:56 Wadena, Minnesota, US
1824470 1824470 2020-10-04 US Minnesota Big Stone 27011 91 0 0 91 45.42712824 -96.41403739 2020-10-05 04:23:33 Big Stone, Minnesota, US
1123330 1123330 2020-09-17 US Minnesota Redwood 27127 91 0 0 91 44.40555844 -95.25207021 2020-09-18 05:05:00 Redwood, Minnesota, US
548453 548453 2020-09-12 US Minnesota Fillmore 27045 91 0 0 91 43.67394126 -92.08980382 2020-09-13 04:30:52 Fillmore, Minnesota, US
1174888 1174888 2020-09-10 US Minnesota Houston 27055 91 0 0 91 43.67129565 -91.49143057 2020-09-11 04:46:23 Houston, Minnesota, US
1998353 1998353 2020-08-26 US Minnesota Jackson 27063 91 0 0 91 43.67423373 -95.15398258 2020-08-27 04:28:15 Jackson, Minnesota, US
3564277 3564277 2020-08-25 US Minnesota Jackson 27063 91 0 0 91 43.67423373 -95.15398258 2020-08-26 04:28:11 Jackson, Minnesota, US
2992981 2992981 2020-08-24 US Minnesota Jackson 27063 91 0 0 91 43.67423373 -95.15398258 2020-08-25 04:28:02 Jackson, Minnesota, US
2217391 2217391 2020-08-23 US Minnesota Meeker 27093 93 2 0 91 45.12328869 -94.52839455 2020-08-24 04:27:56 Meeker, Minnesota, US
2301173 2301173 2020-08-22 US Minnesota Meeker 27093 93 2 0 91 45.12328869 -94.52839455 2020-08-23 04:27:48 Meeker, Minnesota, US
3179755 3179755 2020-08-18 US Minnesota Sibley 27143 93 2 0 91 44.5796592 -94.23164924 2020-08-19 04:27:00 Sibley, Minnesota, US
3921770 3921770 2020-08-09 US Minnesota Morrison 27097 92 1 0 91 46.01265363 -94.27341528 2020-08-10 04:34:55 Morrison, Minnesota, US
370900 370900 2020-08-08 US Minnesota Wabasha 27157 91 0 0 91 44.28424356 -92.23121312 2020-08-09 04:34:54 Wabasha, Minnesota, US
3611681 3611681 2020-08-06 US Minnesota Unassigned 90027 132 41 0 91 48.77754106 0.0 2020-08-07 04:35:11 Unassigned, Minnesota, US
1925414 1925414 2020-07-30 US Minnesota Chippewa 27023 92 1 0 91 45.02343421 -95.56403693 2020-07-31 04:35:18 Chippewa, Minnesota, US
2955582 2955582 2020-07-29 US Minnesota Chippewa 27023 92 1 0 91 45.02343421 -95.56403693 2020-07-30 04:35:05 Chippewa, Minnesota, US
1705414 1705414 2020-07-21 US Minnesota Itasca 27061 103 12 0 91 47.51009045 -93.63092229 2020-07-22 04:34:42 Itasca, Minnesota, US
3202009 3202009 2020-07-18 US Minnesota Beltrami 27007 91 0 0 91 47.97373527 -94.93732139 2020-07-19 04:34:58 Beltrami, Minnesota, US
3204152 3204152 2020-07-18 US Minnesota Polk 27119 94 3 0 91 47.77372465 -96.40134647 2020-07-19 04:34:58 Polk, Minnesota, US
2707204 2707204 2020-07-17 US Minnesota Murray 27101 91 0 0 91 44.02216709 -95.76328482 2020-07-18 04:34:45 Murray, Minnesota, US
364824 364824 2020-07-16 US Minnesota Douglas 27041 91 0 0 91 45.93348491 -95.45335469 2020-07-17 04:34:50 Douglas, Minnesota, US
413816 413816 2020-07-05 US Minnesota McLeod 27085 91 0 0 91 44.82367677 -94.27287017 2020-07-06 04:33:57 McLeod, Minnesota, US
3044133 3044133 2020-07-02 US Minnesota Otter Tail 27111 92 1 0 91 46.40846929 -95.70835255 2020-07-03 04:33:54 Otter Tail, Minnesota, US
301825 301825 2020-07-01 US Minnesota Otter Tail 27111 92 1 0 91 46.40846929 -95.70835255 2020-07-02 04:33:46 Otter Tail, Minnesota, US
2973205 2973205 2020-06-30 US Minnesota Otter Tail 27111 92 1 0 91 46.40846929 -95.70835255 2020-07-01 04:33:52 Otter Tail, Minnesota, US
2303621 2303621 2020-06-28 US Minnesota Chisago 27025 92 1 0 91 45.5021011 -92.90861945 2020-06-29 04:33:44 Chisago, Minnesota, US
3680370 3680370 2020-06-18 US Minnesota Goodhue 27049 98 7 0 91 44.40849741 -92.7234195 2020-06-19 04:33:17 Goodhue, Minnesota, US
3328111 3328111 2020-05-11 US Minnesota Benton 27009 93 2 0 91 45.69804958 -93.99514135 2020-05-12 03:32:27 Benton, Minnesota, US
3328323 3328323 2020-05-11 US Minnesota Carver 27019 92 1 0 91 44.82017001 -93.8009918 2020-05-12 03:32:27 Carver, Minnesota, US
2899026 2899026 2020-05-09 US Minnesota Wright 27171 92 1 0 91 45.17297924 -93.96234781 2020-05-10 02:32:30 Wright, Minnesota, US
1382271 1382271 2020-04-19 US Minnesota Anoka 27003 93 2 0 91 45.27476015 -93.24604565 2020-04-19 23:41:01 Anoka, Minnesota, US
40952 40952 2020-04-13 US Minnesota Dakota 27037 95 4 0 91 44.67172617 -93.06299363 2020-04-13 23:07:54 Dakota, Minnesota, US
2575988 2575988 2020-04-12 US Minnesota Dakota 27037 95 4 0 91 44.67172617 -93.06299363 2020-04-12 23:18:00 Dakota, Minnesota, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);