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

22 rows where "last_update" is on date 2021-03-26 and province_or_state = "New Jersey" sorted by day descending

✎ View and edit SQL

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

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

province_or_state 1

  • New Jersey · 22 ✖

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
1982770 1982770 2021-03-25 US New Jersey Atlantic 34001 27475 604 0   39.47538693 -74.65848483 2021-03-26 05:26:55 Atlantic, New Jersey, US
1982771 1982771 2021-03-25 US New Jersey Bergen 34003 88162 2706 0   40.96010917 -74.07164325 2021-03-26 05:26:55 Bergen, New Jersey, US
1982772 1982772 2021-03-25 US New Jersey Burlington 34005 38780 785 0   39.87681124 -74.66927768 2021-03-26 05:26:55 Burlington, New Jersey, US
1982773 1982773 2021-03-25 US New Jersey Camden 34007 47701 1215 0   39.80343818 -74.96388753 2021-03-26 05:26:55 Camden, New Jersey, US
1982774 1982774 2021-03-25 US New Jersey Cape May 34009 8006 193 0   39.15008829 -74.80170244 2021-03-26 05:26:55 Cape May, New Jersey, US
1982775 1982775 2021-03-25 US New Jersey Cumberland 34011 15136 397 0   39.37199394 -75.10712559 2021-03-26 05:26:55 Cumberland, New Jersey, US
1982776 1982776 2021-03-25 US New Jersey Essex 34013 82264 2773 0   40.78681335 -74.24657979 2021-03-26 05:26:55 Essex, New Jersey, US
1982777 1982777 2021-03-25 US New Jersey Gloucester 34015 26259 574 0   39.71581067 -75.13995546 2021-03-26 05:26:55 Gloucester, New Jersey, US
1982778 1982778 2021-03-25 US New Jersey Hudson 34017 77390 2098 0   40.73766234 -74.07515667 2021-03-26 05:26:55 Hudson, New Jersey, US
1982779 1982779 2021-03-25 US New Jersey Hunterdon 34019 7929 169 0   40.56335249 -74.91284156 2021-03-26 05:26:55 Hunterdon, New Jersey, US
1982780 1982780 2021-03-25 US New Jersey Mercer 34021 30152 907 0   40.28047017 -74.70479631 2021-03-26 05:26:55 Mercer, New Jersey, US
1982781 1982781 2021-03-25 US New Jersey Middlesex 34023 80900 2188 0   40.43629879 -74.41426991 2021-03-26 05:26:55 Middlesex, New Jersey, US
1982782 1982782 2021-03-25 US New Jersey Monmouth 34025 65718 1479 0   40.26549699 -74.22240686 2021-03-26 05:26:55 Monmouth, New Jersey, US
1982783 1982783 2021-03-25 US New Jersey Morris 34027 43480 1168 0   40.86095313 -74.54553709999998 2021-03-26 05:26:55 Morris, New Jersey, US
1982784 1982784 2021-03-25 US New Jersey Ocean 34029 66291 1981 0   39.8895449 -74.28089251 2021-03-26 05:26:55 Ocean, New Jersey, US
1982785 1982785 2021-03-25 US New Jersey Passaic 34031 62571 1773 0   41.03238628 -74.29954144 2021-03-26 05:26:55 Passaic, New Jersey, US
1982786 1982786 2021-03-25 US New Jersey Salem 34033 5100 168 0   39.58719656 -75.34696629999998 2021-03-26 05:26:55 Salem, New Jersey, US
1982787 1982787 2021-03-25 US New Jersey Somerset 34035 25789 803 0   40.56465737 -74.61683016 2021-03-26 05:26:55 Somerset, New Jersey, US
1982788 1982788 2021-03-25 US New Jersey Sussex 34037 10882 282 0   41.13891592 -74.69118243 2021-03-26 05:26:55 Sussex, New Jersey, US
1982789 1982789 2021-03-25 US New Jersey Unassigned 90034 1244 0 0   41.13891592 0.0 2021-03-26 05:26:55 Unassigned, New Jersey, US
1982790 1982790 2021-03-25 US New Jersey Union 34039 62496 1843 0   40.65835409 -74.30680092 2021-03-26 05:26:55 Union, New Jersey, US
1982791 1982791 2021-03-25 US New Jersey Warren 34041 8157 224 0   40.85951833 -74.99556527 2021-03-26 05:26:55 Warren, New Jersey, 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]);