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

7,817 rows where deaths = 91 sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

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
2756120 2756120 2022-12-29 US Texas Sabine 48403 1496 91 0   31.34318809 -93.85440451 2022-12-30 04:21:04 Sabine, Texas, US
2755196 2755196 2022-12-29 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-30 04:21:04 Ashe, North Carolina, US
2754408 2754408 2022-12-29 US Louisiana Concordia 22029 6262 91 0   31.44817835 -91.63814433 2022-12-30 04:21:04 Concordia, Louisiana, US
2754347 2754347 2022-12-29 US Kentucky Marion 21155 7857 91 0   37.55218078 -85.26898542 2022-12-30 04:21:04 Marion, Kentucky, US
2754052 2754052 2022-12-29 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-30 04:21:04 Tipton, Indiana, US
2754038 2754038 2022-12-29 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-30 04:21:04 Pulaski, Indiana, US
2753966 2753966 2022-12-29 US Illinois Wayne 17191 6468 91 0   38.42955355 -88.42586459 2022-12-30 04:21:04 Wayne, Illinois, US
2753724 2753724 2022-12-29 US Georgia Hancock 13141 1897 91 0   33.2721566 -82.99766919 2022-12-30 04:21:04 Hancock, Georgia, US
1077126 1077126 2022-12-28 US Texas Sabine 48403 1496 91 0   31.34318809 -93.85440451 2022-12-29 04:21:01 Sabine, Texas, US
1076202 1076202 2022-12-28 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-29 04:21:01 Ashe, North Carolina, US
1075414 1075414 2022-12-28 US Louisiana Concordia 22029 6262 91 0   31.44817835 -91.63814433 2022-12-29 04:21:01 Concordia, Louisiana, US
1075353 1075353 2022-12-28 US Kentucky Marion 21155 7857 91 0   37.55218078 -85.26898542 2022-12-29 04:21:01 Marion, Kentucky, US
1075058 1075058 2022-12-28 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-29 04:21:01 Tipton, Indiana, US
1075044 1075044 2022-12-28 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-29 04:21:01 Pulaski, Indiana, US
1074972 1074972 2022-12-28 US Illinois Wayne 17191 6463 91 0   38.42955355 -88.42586459 2022-12-29 04:21:01 Wayne, Illinois, US
1074730 1074730 2022-12-28 US Georgia Hancock 13141 1897 91 0   33.2721566 -82.99766919 2022-12-29 04:21:01 Hancock, Georgia, US
331123 331123 2022-12-27 US Texas Sabine 48403 1493 91 0   31.34318809 -93.85440451 2022-12-28 04:21:04 Sabine, Texas, US
330199 330199 2022-12-27 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-28 04:21:04 Ashe, North Carolina, US
330185 330185 2022-12-27 US New York Tioga 36107 13765 91 0   42.16852837 -76.30835812 2022-12-28 04:21:04 Tioga, New York, US
329411 329411 2022-12-27 US Louisiana Concordia 22029 6223 91 0   31.44817835 -91.63814433 2022-12-28 04:21:04 Concordia, Louisiana, US
329350 329350 2022-12-27 US Kentucky Marion 21155 7857 91 0   37.55218078 -85.26898542 2022-12-28 04:21:04 Marion, Kentucky, US
329055 329055 2022-12-27 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-28 04:21:04 Tipton, Indiana, US
329041 329041 2022-12-27 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-28 04:21:04 Pulaski, Indiana, US
328969 328969 2022-12-27 US Illinois Wayne 17191 6452 91 0   38.42955355 -88.42586459 2022-12-28 04:21:04 Wayne, Illinois, US
328727 328727 2022-12-27 US Georgia Hancock 13141 1894 91 0   33.2721566 -82.99766919 2022-12-28 04:21:04 Hancock, Georgia, US
221196 221196 2022-12-26 US Texas Sabine 48403 1493 91 0   31.34318809 -93.85440451 2022-12-27 04:21:07 Sabine, Texas, US
220272 220272 2022-12-26 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-27 04:21:07 Ashe, North Carolina, US
220258 220258 2022-12-26 US New York Tioga 36107 13764 91 0   42.16852837 -76.30835812 2022-12-27 04:21:07 Tioga, New York, US
219484 219484 2022-12-26 US Louisiana Concordia 22029 6223 91 0   31.44817835 -91.63814433 2022-12-27 04:21:07 Concordia, Louisiana, US
219423 219423 2022-12-26 US Kentucky Marion 21155 7831 91 0   37.55218078 -85.26898542 2022-12-27 04:21:07 Marion, Kentucky, US
219128 219128 2022-12-26 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-27 04:21:07 Tipton, Indiana, US
219114 219114 2022-12-26 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-27 04:21:07 Pulaski, Indiana, US
219042 219042 2022-12-26 US Illinois Wayne 17191 6445 91 0   38.42955355 -88.42586459 2022-12-27 04:21:07 Wayne, Illinois, US
218800 218800 2022-12-26 US Georgia Hancock 13141 1894 91 0   33.2721566 -82.99766919 2022-12-27 04:21:07 Hancock, Georgia, US
3225653 3225653 2022-12-25 US Texas Sabine 48403 1493 91 0   31.34318809 -93.85440451 2022-12-26 04:21:06 Sabine, Texas, US
3224729 3224729 2022-12-25 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-26 04:21:06 Ashe, North Carolina, US
3224715 3224715 2022-12-25 US New York Tioga 36107 13761 91 0   42.16852837 -76.30835812 2022-12-26 04:21:06 Tioga, New York, US
3223941 3223941 2022-12-25 US Louisiana Concordia 22029 6223 91 0   31.44817835 -91.63814433 2022-12-26 04:21:06 Concordia, Louisiana, US
3223880 3223880 2022-12-25 US Kentucky Marion 21155 7831 91 0   37.55218078 -85.26898542 2022-12-26 04:21:06 Marion, Kentucky, US
3223585 3223585 2022-12-25 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-26 04:21:06 Tipton, Indiana, US
3223571 3223571 2022-12-25 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-26 04:21:06 Pulaski, Indiana, US
3223499 3223499 2022-12-25 US Illinois Wayne 17191 6445 91 0   38.42955355 -88.42586459 2022-12-26 04:21:06 Wayne, Illinois, US
3223257 3223257 2022-12-25 US Georgia Hancock 13141 1894 91 0   33.2721566 -82.99766919 2022-12-26 04:21:06 Hancock, Georgia, US
1021567 1021567 2022-12-24 US Texas Sabine 48403 1493 91 0   31.34318809 -93.85440451 2022-12-25 04:21:04 Sabine, Texas, US
1020643 1020643 2022-12-24 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-25 04:21:04 Ashe, North Carolina, US
1020629 1020629 2022-12-24 US New York Tioga 36107 13759 91 0   42.16852837 -76.30835812 2022-12-25 04:21:04 Tioga, New York, US
1019855 1019855 2022-12-24 US Louisiana Concordia 22029 6223 91 0   31.44817835 -91.63814433 2022-12-25 04:21:04 Concordia, Louisiana, US
1019794 1019794 2022-12-24 US Kentucky Marion 21155 7831 91 0   37.55218078 -85.26898542 2022-12-25 04:21:04 Marion, Kentucky, US
1019499 1019499 2022-12-24 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-25 04:21:04 Tipton, Indiana, US
1019485 1019485 2022-12-24 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-25 04:21:04 Pulaski, Indiana, US
1019413 1019413 2022-12-24 US Illinois Wayne 17191 6445 91 0   38.42955355 -88.42586459 2022-12-25 04:21:04 Wayne, Illinois, US
1019171 1019171 2022-12-24 US Georgia Hancock 13141 1894 91 0   33.2721566 -82.99766919 2022-12-25 04:21:04 Hancock, Georgia, US
693590 693590 2022-12-23 US Texas Sabine 48403 1493 91 0   31.34318809 -93.85440451 2022-12-24 04:21:02 Sabine, Texas, US
692666 692666 2022-12-23 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-24 04:21:02 Ashe, North Carolina, US
692652 692652 2022-12-23 US New York Tioga 36107 13754 91 0   42.16852837 -76.30835812 2022-12-24 04:21:02 Tioga, New York, US
691878 691878 2022-12-23 US Louisiana Concordia 22029 6223 91 0   31.44817835 -91.63814433 2022-12-24 04:21:02 Concordia, Louisiana, US
691817 691817 2022-12-23 US Kentucky Marion 21155 7831 91 0   37.55218078 -85.26898542 2022-12-24 04:21:02 Marion, Kentucky, US
691522 691522 2022-12-23 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-24 04:21:02 Tipton, Indiana, US
691508 691508 2022-12-23 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-24 04:21:02 Pulaski, Indiana, US
691436 691436 2022-12-23 US Illinois Wayne 17191 6445 91 0   38.42955355 -88.42586459 2022-12-24 04:21:02 Wayne, Illinois, US
691194 691194 2022-12-23 US Georgia Hancock 13141 1894 91 0   33.2721566 -82.99766919 2022-12-24 04:21:02 Hancock, Georgia, US
2182800 2182800 2022-12-22 US Texas Sabine 48403 1493 91 0   31.34318809 -93.85440451 2022-12-23 04:21:04 Sabine, Texas, US
2181876 2181876 2022-12-22 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-23 04:21:04 Ashe, North Carolina, US
2181862 2181862 2022-12-22 US New York Tioga 36107 13744 91 0   42.16852837 -76.30835812 2022-12-23 04:21:04 Tioga, New York, US
2181088 2181088 2022-12-22 US Louisiana Concordia 22029 6223 91 0   31.44817835 -91.63814433 2022-12-23 04:21:04 Concordia, Louisiana, US
2181027 2181027 2022-12-22 US Kentucky Marion 21155 7831 91 0   37.55218078 -85.26898542 2022-12-23 04:21:04 Marion, Kentucky, US
2180732 2180732 2022-12-22 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-23 04:21:04 Tipton, Indiana, US
2180718 2180718 2022-12-22 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-23 04:21:04 Pulaski, Indiana, US
2180646 2180646 2022-12-22 US Illinois Wayne 17191 6444 91 0   38.42955355 -88.42586459 2022-12-23 04:21:04 Wayne, Illinois, US
2180404 2180404 2022-12-22 US Georgia Hancock 13141 1894 91 0   33.2721566 -82.99766919 2022-12-23 04:21:04 Hancock, Georgia, US
454604 454604 2022-12-21 US Texas Sabine 48403 1493 91 0   31.34318809 -93.85440451 2022-12-22 04:20:56 Sabine, Texas, US
453680 453680 2022-12-21 US North Carolina Ashe 37009 7361 91 0   36.43296207 -81.49862729 2022-12-22 04:20:56 Ashe, North Carolina, US
453666 453666 2022-12-21 US New York Tioga 36107 13736 91 0   42.16852837 -76.30835812 2022-12-22 04:20:56 Tioga, New York, US
452892 452892 2022-12-21 US Louisiana Concordia 22029 6223 91 0   31.44817835 -91.63814433 2022-12-22 04:20:56 Concordia, Louisiana, US
452831 452831 2022-12-21 US Kentucky Marion 21155 7831 91 0   37.55218078 -85.26898542 2022-12-22 04:20:56 Marion, Kentucky, US
452536 452536 2022-12-21 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-22 04:20:56 Tipton, Indiana, US
452522 452522 2022-12-21 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-22 04:20:56 Pulaski, Indiana, US
452450 452450 2022-12-21 US Illinois Wayne 17191 6440 91 0   38.42955355 -88.42586459 2022-12-22 04:20:56 Wayne, Illinois, US
452208 452208 2022-12-21 US Georgia Hancock 13141 1894 91 0   33.2721566 -82.99766919 2022-12-22 04:20:56 Hancock, Georgia, US
2954603 2954603 2022-12-20 US Texas Sabine 48403 1492 91 0   31.34318809 -93.85440451 2022-12-21 04:21:03 Sabine, Texas, US
2953679 2953679 2022-12-20 US North Carolina Ashe 37009 7341 91 0   36.43296207 -81.49862729 2022-12-21 04:21:03 Ashe, North Carolina, US
2953665 2953665 2022-12-20 US New York Tioga 36107 13725 91 0   42.16852837 -76.30835812 2022-12-21 04:21:03 Tioga, New York, US
2952891 2952891 2022-12-20 US Louisiana Concordia 22029 5994 91 0   31.44817835 -91.63814433 2022-12-21 04:21:03 Concordia, Louisiana, US
2952830 2952830 2022-12-20 US Kentucky Marion 21155 7831 91 0   37.55218078 -85.26898542 2022-12-21 04:21:03 Marion, Kentucky, US
2952535 2952535 2022-12-20 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-21 04:21:03 Tipton, Indiana, US
2952521 2952521 2022-12-20 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-21 04:21:03 Pulaski, Indiana, US
2952449 2952449 2022-12-20 US Illinois Wayne 17191 6436 91 0   38.42955355 -88.42586459 2022-12-21 04:21:03 Wayne, Illinois, US
2952344 2952344 2022-12-20 US Idaho Payette 16075 6511 91 0   44.00545243 -116.7647695 2022-12-21 04:21:03 Payette, Idaho, US
2952207 2952207 2022-12-20 US Georgia Hancock 13141 1880 91 0   33.2721566 -82.99766919 2022-12-21 04:21:03 Hancock, Georgia, US
3177005 3177005 2022-12-19 US Texas Sabine 48403 1492 91 0   31.34318809 -93.85440451 2022-12-20 04:21:04 Sabine, Texas, US
3176081 3176081 2022-12-19 US North Carolina Ashe 37009 7341 91 0   36.43296207 -81.49862729 2022-12-20 04:21:04 Ashe, North Carolina, US
3176067 3176067 2022-12-19 US New York Tioga 36107 13722 91 0   42.16852837 -76.30835812 2022-12-20 04:21:04 Tioga, New York, US
3175293 3175293 2022-12-19 US Louisiana Concordia 22029 5994 91 0   31.44817835 -91.63814433 2022-12-20 04:21:04 Concordia, Louisiana, US
3175232 3175232 2022-12-19 US Kentucky Marion 21155 7831 91 0   37.55218078 -85.26898542 2022-12-20 04:21:04 Marion, Kentucky, US
3174937 3174937 2022-12-19 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-20 04:21:04 Tipton, Indiana, US
3174923 3174923 2022-12-19 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-20 04:21:04 Pulaski, Indiana, US
3174851 3174851 2022-12-19 US Illinois Wayne 17191 6430 91 0   38.42955355 -88.42586459 2022-12-20 04:21:04 Wayne, Illinois, US
3174746 3174746 2022-12-19 US Idaho Payette 16075 6511 91 0   44.00545243 -116.7647695 2022-12-20 04:21:04 Payette, Idaho, US
3174609 3174609 2022-12-19 US Georgia Hancock 13141 1880 91 0   33.2721566 -82.99766919 2022-12-20 04:21:04 Hancock, Georgia, US
1631522 1631522 2022-12-18 US Texas Sabine 48403 1492 91 0   31.34318809 -93.85440451 2022-12-19 04:21:03 Sabine, Texas, US

Next page

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