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-17 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

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
704559 704559 2021-03-16 US New Jersey Atlantic 34001 26352 595 0   39.47538693 -74.65848483 2021-03-17 05:25:07 Atlantic, New Jersey, US
704560 704560 2021-03-16 US New Jersey Bergen 34003 84076 2678 0   40.96010917 -74.07164325 2021-03-17 05:25:07 Bergen, New Jersey, US
704561 704561 2021-03-16 US New Jersey Burlington 34005 37336 771 0   39.87681124 -74.66927768 2021-03-17 05:25:07 Burlington, New Jersey, US
704562 704562 2021-03-16 US New Jersey Camden 34007 46111 1207 0   39.80343818 -74.96388753 2021-03-17 05:25:07 Camden, New Jersey, US
704563 704563 2021-03-16 US New Jersey Cape May 34009 7694 189 0   39.15008829 -74.80170244 2021-03-17 05:25:07 Cape May, New Jersey, US
704564 704564 2021-03-16 US New Jersey Cumberland 34011 14800 388 0   39.37199394 -75.10712559 2021-03-17 05:25:07 Cumberland, New Jersey, US
704565 704565 2021-03-16 US New Jersey Essex 34013 78676 2730 0   40.78681335 -74.24657979 2021-03-17 05:25:07 Essex, New Jersey, US
704566 704566 2021-03-16 US New Jersey Gloucester 34015 25318 562 0   39.71581067 -75.13995546 2021-03-17 05:25:07 Gloucester, New Jersey, US
704567 704567 2021-03-16 US New Jersey Hudson 34017 74064 2060 0   40.73766234 -74.07515667 2021-03-17 05:25:07 Hudson, New Jersey, US
704568 704568 2021-03-16 US New Jersey Hunterdon 34019 7523 166 0   40.56335249 -74.91284156 2021-03-17 05:25:07 Hunterdon, New Jersey, US
704569 704569 2021-03-16 US New Jersey Mercer 34021 29195 893 0   40.28047017 -74.70479631 2021-03-17 05:25:07 Mercer, New Jersey, US
704570 704570 2021-03-16 US New Jersey Middlesex 34023 77485 2159 0   40.43629879 -74.41426991 2021-03-17 05:25:07 Middlesex, New Jersey, US
704571 704571 2021-03-16 US New Jersey Monmouth 34025 62277 1450 0   40.26549699 -74.22240686 2021-03-17 05:25:07 Monmouth, New Jersey, US
704572 704572 2021-03-16 US New Jersey Morris 34027 41199 1150 0   40.86095313 -74.54553709999998 2021-03-17 05:25:07 Morris, New Jersey, US
704573 704573 2021-03-16 US New Jersey Ocean 34029 63358 1936 0   39.8895449 -74.28089251 2021-03-17 05:25:07 Ocean, New Jersey, US
704574 704574 2021-03-16 US New Jersey Passaic 34031 60392 1744 0   41.03238628 -74.29954144 2021-03-17 05:25:07 Passaic, New Jersey, US
704575 704575 2021-03-16 US New Jersey Salem 34033 4871 166 0   39.58719656 -75.34696629999998 2021-03-17 05:25:07 Salem, New Jersey, US
704576 704576 2021-03-16 US New Jersey Somerset 34035 24618 798 0   40.56465737 -74.61683016 2021-03-17 05:25:07 Somerset, New Jersey, US
704577 704577 2021-03-16 US New Jersey Sussex 34037 10061 277 0   41.13891592 -74.69118243 2021-03-17 05:25:07 Sussex, New Jersey, US
704578 704578 2021-03-16 US New Jersey Unassigned 90034 1048 0 0   41.13891592 0.0 2021-03-17 05:25:07 Unassigned, New Jersey, US
704579 704579 2021-03-16 US New Jersey Union 34039 60286 1823 0   40.65835409 -74.30680092 2021-03-17 05:25:07 Union, New Jersey, US
704580 704580 2021-03-16 US New Jersey Warren 34041 7658 224 0   40.85951833 -74.99556527 2021-03-17 05:25:07 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]);