johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where active = 39, country_or_region = "US" and province_or_state = "New York" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1352546 | 1352546 | 2020-11-24 | US | New York | Hamilton | 36041 | 40 | 1 | 0 | 39 | 43.66146647 | -74.49721957 | 2020-11-25 05:27:20 | Hamilton, New York, US |
3318468 | 3318468 | 2020-09-22 | US | New York | Schuyler | 36097 | 39 | 0 | 0 | 39 | 42.39184015 | -76.8773299 | 2020-09-23 04:23:00 | Schuyler, New York, US |
456746 | 456746 | 2020-08-07 | US | New York | Lewis | 36049 | 39 | 0 | 0 | 39 | 43.7844157 | -75.44903992 | 2020-08-08 04:34:53 | Lewis, New York, US |
3610431 | 3610431 | 2020-08-06 | US | New York | Lewis | 36049 | 39 | 0 | 0 | 39 | 43.7844157 | -75.44903992 | 2020-08-07 04:35:11 | Lewis, New York, US |
2706163 | 2706163 | 2020-07-17 | US | New York | Franklin | 36033 | 39 | 0 | 0 | 39 | 44.59040891 | -74.29926032 | 2020-07-18 04:34:45 | Franklin, New York, US |
2306222 | 2306222 | 2020-06-28 | US | New York | Yates | 36123 | 45 | 6 | 0 | 39 | 42.63505484 | -77.10369919 | 2020-06-29 04:33:44 | Yates, New York, US |
2039557 | 2039557 | 2020-06-27 | US | New York | Yates | 36123 | 45 | 6 | 0 | 39 | 42.63505484 | -77.10369919 | 2020-06-28 04:34:04 | Yates, New York, US |
1135838 | 1135838 | 2020-06-26 | US | New York | Yates | 36123 | 45 | 6 | 0 | 39 | 42.63505484 | -77.10369919 | 2020-06-27 04:33:35 | Yates, New York, US |
214777 | 214777 | 2020-06-08 | US | New York | Essex | 36031 | 39 | 0 | 0 | 39 | 44.11630765 | -73.77297842 | 2020-06-09 03:33:03 | Essex, New York, US |
1787809 | 1787809 | 2020-05-29 | US | New York | Cortland | 36023 | 39 | 0 | 0 | 39 | 42.59509207 | -76.07048931 | 2020-05-30 02:32:48 | Cortland, New York, US |
2709692 | 2709692 | 2020-05-28 | US | New York | Cortland | 36023 | 39 | 0 | 0 | 39 | 42.59509207 | -76.07048931 | 2020-05-29 02:32:50 | Cortland, New York, US |
2545715 | 2545715 | 2020-05-27 | US | New York | Cortland | 36023 | 39 | 0 | 0 | 39 | 42.59509207 | -76.07048931 | 2020-05-28 02:32:31 | Cortland, New York, US |
1038681 | 1038681 | 2020-05-26 | US | New York | Cortland | 36023 | 39 | 0 | 0 | 39 | 42.59509207 | -76.07048931 | 2020-05-27 02:32:31 | Cortland, New York, US |
1102412 | 1102412 | 2020-05-25 | US | New York | Cortland | 36023 | 39 | 0 | 0 | 39 | 42.59509207 | -76.07048931 | 2020-05-26 02:32:35 | Cortland, New York, US |
873093 | 873093 | 2020-05-24 | US | New York | Cortland | 36023 | 39 | 0 | 0 | 39 | 42.59509207 | -76.07048931 | 2020-05-25 02:32:44 | Cortland, New York, US |
3844627 | 3844627 | 2020-05-13 | US | New York | Chautauqua | 36013 | 43 | 4 | 0 | 39 | 42.22769210000001 | -79.36691763 | 2020-05-14 03:32:28 | Chautauqua, New York, US |
228012 | 228012 | 2020-04-30 | US | New York | Seneca | 36099 | 39 | 0 | 0 | 39 | 42.78081007 | -76.82497064 | 2020-05-01 02:32:28 | Seneca, New York, US |
136733 | 136733 | 2020-04-29 | US | New York | Schoharie | 36095 | 39 | 0 | 0 | 39 | 42.58831742 | -74.44339029999998 | 2020-04-30 02:32:27 | Schoharie, New York, US |
1456668 | 1456668 | 2020-04-24 | US | New York | Cattaraugus | 36009 | 39 | 0 | 0 | 39 | 42.24778241 | -78.67923096 | 2020-04-23 00:00:00 | Cattaraugus, New York, US |
1457783 | 1457783 | 2020-04-24 | US | New York | Livingston | 36051 | 44 | 5 | 0 | 39 | 42.72596275 | -77.77966158 | 2020-04-23 00:00:00 | Livingston, New York, US |
1198811 | 1198811 | 2020-04-22 | US | New York | Tioga | 36107 | 39 | 0 | 0 | 39 | 42.16852837 | -76.30835812 | 2020-04-22 23:30:53 | Tioga, New York, US |
934138 | 934138 | 2020-04-16 | US | New York | Wyoming | 36121 | 42 | 3 | 0 | 39 | 42.70145109 | -78.22199579 | 2020-04-16 23:30:51 | Wyoming, New York, US |
860032 | 860032 | 2020-04-15 | US | New York | Wyoming | 36121 | 42 | 3 | 0 | 39 | 42.70145109 | -78.22199579 | 2020-04-15 22:56:51 | Wyoming, New York, US |
3337824 | 3337824 | 2020-04-14 | US | New York | Washington | 36115 | 40 | 1 | 0 | 39 | 43.31153794 | -73.43043448 | 2020-04-14 23:33:31 | Washington, New York, US |
40998 | 40998 | 2020-04-13 | US | New York | Delaware | 36025 | 42 | 3 | 0 | 39 | 42.19837623 | -74.96709306 | 2020-04-13 23:07:54 | Delaware, New York, US |
3949735 | 3949735 | 2020-04-09 | US | New York | Wayne | 36117 | 39 | 0 | 0 | 39 | 43.15494365 | -77.02976528 | 2020-04-09 23:02:37 | Wayne, New York, US |
3559833 | 3559833 | 2020-04-08 | US | New York | Clinton | 36019 | 39 | 0 | 0 | 39 | 44.74530905 | -73.67875352 | 2020-04-08 22:51:58 | Clinton, New York, US |
3561098 | 3561098 | 2020-04-08 | US | New York | Ontario | 36069 | 39 | 0 | 0 | 39 | 42.85145728 | -77.30874425 | 2020-04-08 22:51:58 | Ontario, New York, US |
3561843 | 3561843 | 2020-04-08 | US | New York | Wayne | 36117 | 39 | 0 | 0 | 39 | 43.15494365 | -77.02976528 | 2020-04-08 22:51:58 | Wayne, New York, US |
3020189 | 3020189 | 2020-04-07 | US | New York | Jefferson | 36045 | 39 | 0 | 0 | 39 | 44.04200959 | -75.94653457 | 2020-04-07 23:04:49 | Jefferson, New York, US |
1748607 | 1748607 | 2020-04-04 | US | New York | Chenango | 36017 | 39 | 0 | 0 | 39 | 42.49430041 | -75.60887553 | 4/4/20 23:34 | Chenango, New York, US |
3701099 | 3701099 | 2020-04-02 | US | New York | St. Lawrence | 36089 | 39 | 0 | 0 | 39 | 44.4976179 | -75.06550039 | 4/2/20 23:25 | St. Lawrence, New York, US |
3362675 | 3362675 | 2020-04-01 | US | New York | Broome | 36007 | 42 | 3 | 0 | 39 | 42.15903158 | -75.81326086 | 2020-04-01 21:58:49 | Broome, New York, US |
1132021 | 1132021 | 2020-03-25 | US | New York | Sullivan | 36105 | 39 | 0 | 0 | 39 | 41.71579493 | -74.76394559 | 2020-03-25 23:33:19 | Sullivan, New York, 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]);