johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where active = 58, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3119735 | 3119735 | 2020-10-06 | US | New York | Schuyler | 36097 | 58 | 0 | 0 | 58 | 42.39184015 | -76.8773299 | 2020-10-07 04:23:40 | Schuyler, New York, US |
2516436 | 2516436 | 2020-10-03 | US | New York | Yates | 36123 | 65 | 7 | 0 | 58 | 42.63505484 | -77.10369919 | 2020-10-04 04:23:44 | Yates, New York, US |
3391654 | 3391654 | 2020-10-02 | US | New York | Yates | 36123 | 65 | 7 | 0 | 58 | 42.63505484 | -77.10369919 | 2020-10-03 04:23:40 | Yates, New York, US |
1107771 | 1107771 | 2020-09-02 | US | New York | Franklin | 36033 | 58 | 0 | 0 | 58 | 44.59040891 | -74.29926032 | 2020-09-03 04:28:22 | Franklin, New York, US |
2062100 | 2062100 | 2020-09-01 | US | New York | Franklin | 36033 | 58 | 0 | 0 | 58 | 44.59040891 | -74.29926032 | 2020-09-02 04:28:25 | Franklin, New York, US |
196285 | 196285 | 2020-08-31 | US | New York | Franklin | 36033 | 58 | 0 | 0 | 58 | 44.59040891 | -74.29926032 | 2020-09-01 04:28:31 | Franklin, New York, US |
3934243 | 3934243 | 2020-08-30 | US | New York | Franklin | 36033 | 58 | 0 | 0 | 58 | 44.59040891 | -74.29926032 | 2020-08-31 04:28:27 | Franklin, New York, US |
611905 | 611905 | 2020-08-29 | US | New York | Franklin | 36033 | 58 | 0 | 0 | 58 | 44.59040891 | -74.29926032 | 2020-08-30 04:28:22 | Franklin, New York, US |
1525400 | 1525400 | 2020-08-28 | US | New York | Franklin | 36033 | 58 | 0 | 0 | 58 | 44.59040891 | -74.29926032 | 2020-08-29 04:28:19 | Franklin, New York, US |
2512401 | 2512401 | 2020-08-27 | US | New York | Franklin | 36033 | 58 | 0 | 0 | 58 | 44.59040891 | -74.29926032 | 2020-08-28 04:28:11 | Franklin, New York, US |
3734881 | 3734881 | 2020-07-12 | US | New York | Cortland | 36023 | 58 | 0 | 0 | 58 | 42.59509207 | -76.07048931 | 2020-07-13 04:43:04 | Cortland, New York, US |
3433278 | 3433278 | 2020-07-11 | US | New York | Cortland | 36023 | 58 | 0 | 0 | 58 | 42.59509207 | -76.07048931 | 2020-07-12 04:34:30 | Cortland, New York, US |
529036 | 529036 | 2020-07-04 | US | New York | Schoharie | 36095 | 58 | 0 | 0 | 58 | 42.58831742 | -74.44339029999998 | 2020-07-05 04:33:46 | Schoharie, New York, US |
2233697 | 2233697 | 2020-07-03 | US | New York | Schoharie | 36095 | 58 | 0 | 0 | 58 | 42.58831742 | -74.44339029999998 | 2020-07-04 04:33:51 | Schoharie, New York, US |
3044493 | 3044493 | 2020-07-02 | US | New York | Schoharie | 36095 | 58 | 0 | 0 | 58 | 42.58831742 | -74.44339029999998 | 2020-07-03 04:33:54 | Schoharie, New York, US |
302185 | 302185 | 2020-07-01 | US | New York | Schoharie | 36095 | 58 | 0 | 0 | 58 | 42.58831742 | -74.44339029999998 | 2020-07-02 04:33:46 | Schoharie, New York, US |
2973563 | 2973563 | 2020-06-30 | US | New York | Schoharie | 36095 | 58 | 0 | 0 | 58 | 42.58831742 | -74.44339029999998 | 2020-07-01 04:33:52 | Schoharie, New York, US |
2632040 | 2632040 | 2020-06-29 | US | New York | Schoharie | 36095 | 58 | 0 | 0 | 58 | 42.58831742 | -74.44339029999998 | 2020-06-30 04:33:48 | Schoharie, New York, US |
2305603 | 2305603 | 2020-06-28 | US | New York | Schoharie | 36095 | 58 | 0 | 0 | 58 | 42.58831742 | -74.44339029999998 | 2020-06-29 04:33:44 | Schoharie, New York, US |
2036511 | 2036511 | 2020-06-27 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-28 04:34:04 | Allegany, New York, US |
1132793 | 1132793 | 2020-06-26 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-27 04:33:35 | Allegany, New York, US |
2621781 | 2621781 | 2020-06-25 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-26 04:33:43 | Allegany, New York, US |
2697428 | 2697428 | 2020-06-24 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-25 05:26:54 | Allegany, New York, US |
1519126 | 1519126 | 2020-06-23 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-24 04:33:28 | Allegany, New York, US |
1507325 | 1507325 | 2020-06-22 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-23 04:33:22 | Allegany, New York, US |
3246067 | 3246067 | 2020-06-21 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-22 04:33:20 | Allegany, New York, US |
2434660 | 2434660 | 2020-06-20 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-21 04:33:19 | Allegany, New York, US |
1688242 | 1688242 | 2020-06-19 | US | New York | Allegany | 36003 | 58 | 0 | 0 | 58 | 42.25748406 | -78.02750466 | 2020-06-20 04:33:19 | Allegany, New York, US |
1793193 | 1793193 | 2020-05-31 | US | New York | Seneca | 36099 | 58 | 0 | 0 | 58 | 42.78081007 | -76.82497064 | 2020-06-01 02:32:46 | Seneca, New York, US |
3638086 | 3638086 | 2020-05-30 | US | New York | Seneca | 36099 | 58 | 0 | 0 | 58 | 42.78081007 | -76.82497064 | 2020-05-31 02:32:45 | Seneca, New York, US |
2108534 | 2108534 | 2020-05-06 | US | New York | Delaware | 36025 | 62 | 4 | 0 | 58 | 42.19837623 | -74.96709306 | 2020-05-07 02:32:28 | Delaware, New York, US |
1929580 | 1929580 | 2020-05-05 | US | New York | Delaware | 36025 | 62 | 4 | 0 | 58 | 42.19837623 | -74.96709306 | 2020-05-06 02:32:31 | Delaware, New York, US |
3082447 | 3082447 | 2020-05-04 | US | New York | Delaware | 36025 | 62 | 4 | 0 | 58 | 42.19837623 | -74.96709306 | 2020-05-05 02:32:34 | Delaware, New York, US |
2040820 | 2040820 | 2020-05-02 | US | New York | Clinton | 36019 | 62 | 4 | 0 | 58 | 44.74530905 | -73.67875352 | 2020-05-03 02:32:28 | Clinton, New York, US |
2041432 | 2041432 | 2020-05-02 | US | New York | Herkimer | 36043 | 61 | 3 | 0 | 58 | 43.42034246 | -74.96145307 | 2020-05-03 02:32:28 | Herkimer, New York, US |
271519 | 271519 | 2020-04-28 | US | New York | Wyoming | 36121 | 63 | 5 | 0 | 58 | 42.70145109 | -78.22199579 | 2020-04-29 02:32:29 | Wyoming, New York, US |
3588273 | 3588273 | 2020-04-27 | US | New York | Oswego | 36075 | 61 | 3 | 0 | 58 | 43.42778894 | -76.14635194 | 2020-04-26 00:00:00 | Oswego, New York, US |
3588278 | 3588278 | 2020-04-27 | US | New York | Otsego | 36077 | 62 | 4 | 0 | 58 | 42.63492579 | -75.03151402 | 2020-04-26 00:00:00 | Otsego, New York, US |
3589182 | 3589182 | 2020-04-27 | US | New York | Wyoming | 36121 | 63 | 5 | 0 | 58 | 42.70145109 | -78.22199579 | 2020-04-26 00:00:00 | Wyoming, New York, US |
1457534 | 1457534 | 2020-04-24 | US | New York | Jefferson | 36045 | 58 | 0 | 0 | 58 | 44.04200959 | -75.94653457 | 2020-04-23 00:00:00 | Jefferson, New York, US |
1197021 | 1197021 | 2020-04-22 | US | New York | Delaware | 36025 | 62 | 4 | 0 | 58 | 42.19837623 | -74.96709306 | 2020-04-22 23:30:53 | Delaware, New York, US |
520093 | 520093 | 2020-04-21 | US | New York | Delaware | 36025 | 62 | 4 | 0 | 58 | 42.19837623 | -74.96709306 | 2020-04-21 23:30:50 | Delaware, New York, US |
1247845 | 1247845 | 2020-04-10 | US | New York | Chemung | 36015 | 59 | 1 | 0 | 58 | 42.13891056 | -76.7638805 | 2020-04-10 22:54:07 | Chemung, New York, US |
3947610 | 3947610 | 2020-04-09 | US | New York | Chemung | 36015 | 59 | 1 | 0 | 58 | 42.13891056 | -76.7638805 | 2020-04-09 23:02:37 | Chemung, 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]);