johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where confirmed = 14364 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 21
- Colombia 1
- Mali 1
- Mauritania 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
712703 | 712703 | 2022-11-01 | US | New York | Montgomery | 36057 | 14364 | 223 | 0 | 42.90123494 | -74.44011632 | 2022-11-02 04:22:09 | Montgomery, New York, US | |
2336029 | 2336029 | 2022-07-27 | US | Colorado | La Plata | 8067 | 14364 | 90 | 0 | 37.28632032 | -107.8429014 | 2022-07-28 04:20:56 | La Plata, Colorado, US | |
2671994 | 2671994 | 2022-04-15 | US | New Jersey | Salem | 34033 | 14364 | 246 | 0 | 39.58719656 | -75.34696629999998 | 2022-04-16 04:20:48 | Salem, New Jersey, US | |
1513887 | 1513887 | 2022-02-24 | US | Ohio | Huron | 39077 | 14364 | 220 | 0 | 41.14651175 | -82.59867951 | 2022-02-25 04:21:11 | Huron, Ohio, US | |
1434838 | 1434838 | 2021-12-28 | US | New York | Steuben | 36101 | 14364 | 209 | 0 | 42.2689144 | -77.3829924 | 2021-12-29 03:21:43 | Steuben, New York, US | |
2398635 | 2398635 | 2021-12-17 | Colombia | Arauca | 14364 | 480 | 0 | 7.0762 | -70.7105 | 2021-12-18 02:22:20 | Arauca, Colombia | |||
2090173 | 2090173 | 2021-12-14 | US | New Mexico | Lea | 35025 | 14364 | 286 | 0 | 32.79215361 | -103.4123733 | 2021-12-15 03:22:16 | Lea, New Mexico, US | |
1896517 | 1896517 | 2021-06-30 | US | Virginia | Newport News | 51700 | 14364 | 239 | 0 | 37.08166899 | -76.51754109 | 2021-07-01 04:21:19 | Newport News, Virginia, US | |
563746 | 563746 | 2021-06-22 | US | Georgia | Coweta | 13077 | 14364 | 229 | 0 | 33.35334302 | -84.76129976 | 2021-06-23 04:21:46 | Coweta, Georgia, US | |
3359448 | 3359448 | 2021-06-21 | US | Georgia | Coweta | 13077 | 14364 | 229 | 0 | 33.35334302 | -84.76129976 | 2021-06-22 04:21:34 | Coweta, Georgia, US | |
2912660 | 2912660 | 2021-06-17 | US | Louisiana | Bossier | 22015 | 14364 | 309 | 0 | 32.67932307 | -93.60460152 | 2021-06-18 04:22:16 | Bossier, Louisiana, US | |
2911242 | 2911242 | 2021-06-17 | Mali | 14364 | 523 | 10001 | 3840 | 17.570692 | -3.996166000000001 | 2021-06-18 04:22:16 | Mali | |||
2586523 | 2586523 | 2021-06-05 | US | California | Butte | 6007 | 14364 | 194 | 0 | 39.66727762 | -121.6005252 | 2021-06-06 04:24:03 | Butte, California, US | |
1082314 | 1082314 | 2021-05-14 | US | Alabama | Morgan | 1103 | 14364 | 280 | 0 | 34.45500589 | -86.85475946 | 2021-05-15 04:20:58 | Morgan, Alabama, US | |
2248312 | 2248312 | 2021-04-07 | US | Idaho | Bonneville | 16019 | 14364 | 161 | 0 | 43.38713372 | -111.6161537 | 2021-04-08 04:21:13 | Bonneville, Idaho, US | |
3713434 | 3713434 | 2021-04-03 | US | Virginia | Arlington | 51013 | 14364 | 246 | 0 | 38.8767675 | -77.10139853 | 2021-04-04 04:20:49 | Arlington, Virginia, US | |
1861217 | 1861217 | 2021-02-25 | US | Texas | Smith | 48423 | 14364 | 396 | 0 | 18237 | 32.37474036 | -95.2717568 | 2021-02-26 05:22:40 | Smith, Texas, US |
283395 | 283395 | 2021-02-24 | US | Texas | Smith | 48423 | 14364 | 391 | 0 | 18242 | 32.37474036 | -95.2717568 | 2021-02-25 05:24:57 | Smith, Texas, US |
615929 | 615929 | 2021-02-08 | US | New York | Niagara | 36063 | 14364 | 286 | 0 | 14078 | 43.19898042 | -78.74777412 | 2021-02-09 05:23:30 | Niagara, New York, US |
1674214 | 1674214 | 2021-02-07 | US | Minnesota | St. Louis | 27137 | 14364 | 259 | 0 | 14105 | 47.6048407 | -92.46879855 | 2021-02-08 05:22:39 | St. Louis, Minnesota, US |
3695562 | 3695562 | 2020-12-31 | Mauritania | 14364 | 347 | 11380 | 2637 | 21.0079 | -10.9408 | 2021-01-01 05:23:07 | Mauritania | |||
3764838 | 3764838 | 2020-12-28 | US | Utah | Bear River | 14364 | 44 | 0 | 14320 | 41.52106798 | -113.0832816 | 2020-12-29 05:22:37 | Bear River, Utah, US | |
1585246 | 1585246 | 2020-11-30 | US | Indiana | Hamilton | 18057 | 14364 | 198 | 0 | 14166 | 40.07306535 | -86.05244729 | 2020-12-01 05:26:18 | Hamilton, Indiana, US |
379420 | 379420 | 2020-11-06 | US | Texas | Webb | 48479 | 14364 | 356 | 0 | 15412 | 27.7610369 | -99.33237355 | 2020-11-07 05:24:52 | Webb, Texas, 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]);