johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where confirmed = 9715 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2417161 | 2417161 | 2022-12-05 | US | New York | Wyoming | 36121 | 9715 | 90 | 0 | 42.70145109 | -78.22199579 | 2022-12-06 04:21:03 | Wyoming, New York, US | |
422459 | 422459 | 2022-09-18 | US | Texas | Hill | 48217 | 9715 | 198 | 0 | 31.99045053 | -97.13423143 | 2022-09-19 04:21:49 | Hill, Texas, US | |
3376483 | 3376483 | 2022-09-17 | US | Texas | Hill | 48217 | 9715 | 198 | 0 | 31.99045053 | -97.13423143 | 2022-09-18 04:22:50 | Hill, Texas, US | |
2358591 | 2358591 | 2022-09-16 | US | Texas | Hill | 48217 | 9715 | 198 | 0 | 31.99045053 | -97.13423143 | 2022-09-17 04:20:19 | Hill, Texas, US | |
1098584 | 1098584 | 2022-08-03 | US | Arkansas | Baxter | 5005 | 9715 | 262 | 0 | 36.28784385 | -92.33782872 | 2022-08-04 04:20:58 | Baxter, Arkansas, US | |
3408173 | 3408173 | 2022-07-17 | US | Puerto Rico | Aguada | 72003 | 9715 | 0 | 0 | 18.360255 | -67.175131 | 2022-07-18 04:20:59 | Aguada, Puerto Rico, US | |
2742803 | 2742803 | 2022-07-07 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-07-08 04:20:56 | Bolivar, Mississippi, US | |
1201598 | 1201598 | 2022-07-06 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-07-07 04:20:55 | Bolivar, Mississippi, US | |
3968341 | 3968341 | 2022-07-05 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-07-06 04:20:58 | Bolivar, Mississippi, US | |
3079852 | 3079852 | 2022-07-04 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-07-05 04:20:45 | Bolivar, Mississippi, US | |
1769134 | 1769134 | 2022-07-03 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-07-04 04:20:54 | Bolivar, Mississippi, US | |
3367120 | 3367120 | 2022-07-02 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-07-03 04:20:59 | Bolivar, Mississippi, US | |
595449 | 595449 | 2022-07-01 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-07-02 04:21:16 | Bolivar, Mississippi, US | |
3941850 | 3941850 | 2022-06-30 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-07-01 04:21:10 | Bolivar, Mississippi, US | |
2491808 | 2491808 | 2022-06-29 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-06-30 04:21:01 | Bolivar, Mississippi, US | |
2241190 | 2241190 | 2022-06-28 | US | Mississippi | Bolivar | 28011 | 9715 | 180 | 0 | 33.79696941 | -90.87372121 | 2022-06-29 04:20:59 | Bolivar, Mississippi, US | |
3002450 | 3002450 | 2022-05-24 | US | Texas | Kerr | 48265 | 9715 | 183 | 0 | 30.06040006 | -99.34930144 | 2022-05-25 04:20:56 | Kerr, Texas, US | |
1187240 | 1187240 | 2022-05-18 | US | Ohio | Mercer | 39107 | 9715 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-05-19 04:20:54 | Mercer, Ohio, US | |
3585137 | 3585137 | 2022-05-17 | US | Ohio | Mercer | 39107 | 9715 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-05-18 04:20:50 | Mercer, Ohio, US | |
1506094 | 1506094 | 2022-05-16 | US | Ohio | Mercer | 39107 | 9715 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-05-17 04:20:59 | Mercer, Ohio, US | |
2086453 | 2086453 | 2022-05-15 | US | Ohio | Mercer | 39107 | 9715 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-05-16 04:20:47 | Mercer, Ohio, US | |
3357163 | 3357163 | 2022-05-14 | US | Ohio | Mercer | 39107 | 9715 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-05-15 04:20:53 | Mercer, Ohio, US | |
660808 | 660808 | 2022-05-13 | US | Ohio | Mercer | 39107 | 9715 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-05-14 04:20:48 | Mercer, Ohio, US | |
2535891 | 2535891 | 2022-05-12 | US | Ohio | Mercer | 39107 | 9715 | 144 | 0 | 40.54043046 | -84.62912742 | 2022-05-13 04:20:51 | Mercer, Ohio, US | |
3267726 | 3267726 | 2022-05-04 | US | New York | Chenango | 36017 | 9715 | 120 | 0 | 42.49430041 | -75.60887553 | 2022-05-05 04:20:55 | Chenango, New York, US | |
2478102 | 2478102 | 2022-03-30 | Netherlands | Sint Maarten | 9715 | 86 | 0 | 18.0425 | -63.0548 | 2022-03-31 04:20:56 | Sint Maarten, Netherlands | |||
2199511 | 2199511 | 2022-03-06 | Eritrea | 9715 | 103 | 0 | 15.1794 | 39.7823 | 2022-03-07 04:20:47 | Eritrea | ||||
2091968 | 2091968 | 2022-03-05 | Eritrea | 9715 | 103 | 0 | 15.1794 | 39.7823 | 2022-03-06 04:20:49 | Eritrea | ||||
1229927 | 1229927 | 2022-01-24 | US | North Carolina | Davie | 37059 | 9715 | 82 | 0 | 35.93099927 | -80.54496571 | 2022-01-25 04:21:05 | Davie, North Carolina, US | |
1474725 | 1474725 | 2022-01-17 | US | Oregon | Benton | 41003 | 9715 | 46 | 0 | 44.49167306 | -123.4316987 | 2022-01-18 04:21:04 | Benton, Oregon, US | |
557399 | 557399 | 2022-01-16 | US | Oregon | Benton | 41003 | 9715 | 46 | 0 | 44.49167306 | -123.4316987 | 2022-01-17 04:21:08 | Benton, Oregon, US | |
3843120 | 3843120 | 2022-01-15 | US | Oregon | Benton | 41003 | 9715 | 46 | 0 | 44.49167306 | -123.4316987 | 2022-01-16 04:21:12 | Benton, Oregon, US | |
101935 | 101935 | 2022-01-14 | US | Oregon | Benton | 41003 | 9715 | 46 | 0 | 44.49167306 | -123.4316987 | 2022-01-15 04:21:07 | Benton, Oregon, US | |
701226 | 701226 | 2021-11-04 | US | South Carolina | Georgetown | 45043 | 9715 | 182 | 0 | 33.43443342 | -79.33202141 | 2021-11-05 04:21:54 | Georgetown, South Carolina, US | |
935713 | 935713 | 2021-10-16 | US | Hawaii | Maui | 15009 | 9715 | 92 | 0 | 20.86399628 | -156.56890969999995 | 2021-10-17 04:21:29 | Maui, Hawaii, US | |
706778 | 706778 | 2021-09-29 | US | Alabama | Autauga | 1001 | 9715 | 140 | 0 | 32.53952745 | -86.64408227 | 2021-09-30 04:21:20 | Autauga, Alabama, US | |
1816365 | 1816365 | 2021-09-19 | US | Maryland | Wicomico | 24045 | 9715 | 197 | 0 | 38.37301947 | -75.62705831 | 2021-09-20 04:21:22 | Wicomico, Maryland, US | |
642359 | 642359 | 2021-09-07 | US | Alaska | Fairbanks North Star | 2090 | 9715 | 51 | 0 | 64.80726247 | -146.5692662 | 2021-09-08 04:21:31 | Fairbanks North Star, Alaska, US | |
177931 | 177931 | 2021-09-02 | Gambia | 9715 | 322 | 0 | 13.4432 | -15.3101 | 2021-09-03 04:21:20 | Gambia | ||||
66966 | 66966 | 2021-09-01 | Gambia | 9715 | 322 | 0 | 13.4432 | -15.3101 | 2021-09-02 04:21:15 | Gambia | ||||
1856441 | 1856441 | 2021-08-20 | US | Ohio | Columbiana | 39029 | 9715 | 236 | 0 | 40.76932373 | -80.78094576 | 2021-08-21 04:21:38 | Columbiana, Ohio, US | |
2372177 | 2372177 | 2021-07-20 | US | Connecticut | Tolland | 9013 | 9715 | 187 | 0 | 41.85853803 | -72.3308481 | 2021-07-21 04:21:40 | Tolland, Connecticut, US | |
487139 | 487139 | 2021-07-19 | US | Wisconsin | Jefferson | 55055 | 9715 | 136 | 0 | 43.02054068 | -88.77529134 | 2021-07-20 04:21:48 | Jefferson, Wisconsin, US | |
580987 | 580987 | 2021-07-13 | US | New Hampshire | Merrimack | 33013 | 9715 | 116 | 0 | 43.29662971 | -71.6811573 | 2021-07-14 04:21:35 | Merrimack, New Hampshire, US | |
3125461 | 3125461 | 2021-06-28 | India | Lakshadweep | 9715 | 48 | 9372 | 295 | 13.6999972 | 72.18333259999999 | 2021-06-29 04:21:28 | Lakshadweep, India | ||
2589673 | 2589673 | 2021-06-05 | Malaysia | Terengganu | 9715 | 53 | 7458 | 2204 | 5.3117 | 103.1324 | 2021-06-06 04:24:03 | Terengganu, Malaysia | ||
1427531 | 1427531 | 2021-05-09 | US | North Dakota | Ward | 38101 | 9715 | 194 | 0 | 48.22390169 | -101.5436763 | 2021-05-10 04:20:38 | Ward, North Dakota, US | |
641138 | 641138 | 2021-03-31 | US | Texas | Starr | 48427 | 9715 | 286 | 0 | 26.56150059 | -98.73892358 | 2021-04-01 04:27:05 | Starr, Texas, US | |
1582827 | 1582827 | 2021-03-13 | US | Pennsylvania | Lycoming | 42081 | 9715 | 253 | 0 | 41.34310539 | -77.06629984 | 2021-03-14 05:25:37 | Lycoming, Pennsylvania, US | |
1581683 | 1581683 | 2021-03-13 | US | Louisiana | Terrebonne | 22109 | 9715 | 210 | 0 | 29.37343766 | -90.82626855 | 2021-03-14 05:25:37 | Terrebonne, Louisiana, US | |
1839462 | 1839462 | 2021-03-12 | US | Louisiana | Terrebonne | 22109 | 9715 | 210 | 0 | 29.37343766 | -90.82626855 | 2021-03-13 05:25:15 | Terrebonne, Louisiana, US | |
3667011 | 3667011 | 2021-03-09 | US | Virginia | Stafford | 51179 | 9715 | 69 | 0 | 38.41758738 | -77.45917053 | 2021-03-10 05:24:35 | Stafford, Virginia, US | |
2362285 | 2362285 | 2021-03-08 | US | South Carolina | Lancaster | 45057 | 9715 | 147 | 0 | 34.68270843 | -80.70513032 | 2021-03-09 05:28:19 | Lancaster, South Carolina, US | |
3052568 | 3052568 | 2021-02-16 | US | North Dakota | Grand Forks | 38035 | 9715 | 73 | 0 | 9655 | 47.92093639 | -97.45450447 | 2021-02-17 05:23:10 | Grand Forks, North Dakota, US |
909174 | 909174 | 2021-01-19 | US | Illinois | Kendall | 17093 | 9715 | 71 | 0 | 9644 | 41.59081014 | -88.42869583 | 2021-01-20 05:21:54 | Kendall, Illinois, US |
2867505 | 2867505 | 2021-01-06 | US | South Carolina | Aiken | 45003 | 9715 | 141 | 0 | 9574 | 33.54338026 | -81.63645384 | 2021-01-07 05:22:03 | Aiken, South Carolina, US |
3691856 | 3691856 | 2020-12-24 | US | Alabama | Lee | 1081 | 9715 | 74 | 0 | 9641 | 32.60154883 | -85.35132246 | 2020-12-25 05:22:48 | Lee, Alabama, US |
2130961 | 2130961 | 2020-12-17 | US | Tennessee | Out of TN | 80047 | 9715 | 62 | 0 | 12943 | 36.55606529 | 0.0 | 2020-12-18 05:28:18 | Out of TN, Tennessee, US |
2171482 | 2171482 | 2020-09-09 | Hungary | 9715 | 628 | 3984 | 5103 | 47.1625 | 19.5033 | 2020-09-10 04:29:01 | Hungary |
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]);