johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where confirmed = 10460 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453842 | 453842 | 2022-12-21 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-22 04:20:56 | Champaign, Ohio, US | |
2953841 | 2953841 | 2022-12-20 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-21 04:21:03 | Champaign, Ohio, US | |
3176243 | 3176243 | 2022-12-19 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-20 04:21:04 | Champaign, Ohio, US | |
1630760 | 1630760 | 2022-12-18 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-19 04:21:03 | Champaign, Ohio, US | |
506139 | 506139 | 2022-12-17 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-18 04:21:03 | Champaign, Ohio, US | |
3326711 | 3326711 | 2022-12-16 | US | Ohio | Champaign | 39021 | 10460 | 159 | 0 | 40.13923427 | -83.76875242 | 2022-12-17 04:21:04 | Champaign, Ohio, US | |
545223 | 545223 | 2022-12-15 | US | Ohio | Champaign | 39021 | 10460 | 158 | 0 | 40.13923427 | -83.76875242 | 2022-12-16 04:21:01 | Champaign, Ohio, US | |
3379601 | 3379601 | 2022-12-08 | US | New York | Allegany | 36003 | 10460 | 163 | 0 | 42.25748406 | -78.02750466 | 2022-12-09 04:21:05 | Allegany, New York, US | |
835871 | 835871 | 2022-12-02 | US | New York | Greene | 36039 | 10460 | 144 | 0 | 42.275797 | -74.12384884 | 2022-12-03 04:21:02 | Greene, New York, US | |
2987930 | 2987930 | 2022-09-04 | US | Colorado | Montrose | 8085 | 10460 | 170 | 0 | 38.40214114 | -108.2639022 | 2022-09-05 04:21:01 | Montrose, Colorado, US | |
2713615 | 2713615 | 2022-09-03 | US | Colorado | Montrose | 8085 | 10460 | 170 | 0 | 38.40214114 | -108.2639022 | 2022-09-04 04:21:22 | Montrose, Colorado, US | |
1394320 | 1394320 | 2022-09-02 | US | Colorado | Montrose | 8085 | 10460 | 170 | 0 | 38.40214114 | -108.2639022 | 2022-09-03 04:21:04 | Montrose, Colorado, US | |
1683240 | 1683240 | 2022-08-29 | US | Puerto Rico | Corozal | 72047 | 10460 | 0 | 0 | 18.304264 | -66.327738 | 2022-08-30 04:21:03 | Corozal, Puerto Rico, US | |
1253497 | 1253497 | 2022-08-23 | US | Puerto Rico | Dorado | 72051 | 10460 | 0 | 0 | 18.436115 | -66.278669 | 2022-08-24 04:20:46 | Dorado, Puerto Rico, US | |
3408424 | 3408424 | 2022-07-17 | US | Tennessee | Lincoln | 47103 | 10460 | 175 | 0 | 35.13738622 | -86.58910106 | 2022-07-18 04:20:59 | Lincoln, Tennessee, US | |
3585353 | 3585353 | 2022-05-17 | US | Pennsylvania | Wayne | 42127 | 10460 | 172 | 0 | 41.64938475 | -75.29956506 | 2022-05-18 04:20:50 | Wayne, Pennsylvania, US | |
1506310 | 1506310 | 2022-05-16 | US | Pennsylvania | Wayne | 42127 | 10460 | 172 | 0 | 41.64938475 | -75.29956506 | 2022-05-17 04:20:59 | Wayne, Pennsylvania, US | |
2086669 | 2086669 | 2022-05-15 | US | Pennsylvania | Wayne | 42127 | 10460 | 172 | 0 | 41.64938475 | -75.29956506 | 2022-05-16 04:20:47 | Wayne, Pennsylvania, US | |
3357379 | 3357379 | 2022-05-14 | US | Pennsylvania | Wayne | 42127 | 10460 | 172 | 0 | 41.64938475 | -75.29956506 | 2022-05-15 04:20:53 | Wayne, Pennsylvania, US | |
661024 | 661024 | 2022-05-13 | US | Pennsylvania | Wayne | 42127 | 10460 | 172 | 0 | 41.64938475 | -75.29956506 | 2022-05-14 04:20:48 | Wayne, Pennsylvania, US | |
2536107 | 2536107 | 2022-05-12 | US | Pennsylvania | Wayne | 42127 | 10460 | 172 | 0 | 41.64938475 | -75.29956506 | 2022-05-13 04:20:51 | Wayne, Pennsylvania, US | |
3447553 | 3447553 | 2022-05-11 | US | Pennsylvania | Wayne | 42127 | 10460 | 172 | 0 | 41.64938475 | -75.29956506 | 2022-05-12 04:20:54 | Wayne, Pennsylvania, US | |
1695428 | 1695428 | 2022-01-10 | US | Texas | Hardin | 48199 | 10460 | 219 | 0 | 30.33364686 | -94.38931817 | 2022-01-11 04:22:01 | Hardin, Texas, US | |
1703325 | 1703325 | 2022-01-03 | US | Tennessee | Monroe | 47123 | 10460 | 196 | 0 | 35.44550387 | -84.24902965 | 2022-01-04 04:22:17 | Monroe, Tennessee, US | |
2115233 | 2115233 | 2021-12-26 | US | Wisconsin | Calumet | 55015 | 10460 | 89 | 0 | 44.0816316 | -88.21780273 | 2021-12-27 04:21:58 | Calumet, Wisconsin, US | |
3608605 | 3608605 | 2021-12-25 | US | Wisconsin | Calumet | 55015 | 10460 | 89 | 0 | 44.0816316 | -88.21780273 | 2021-12-26 04:21:50 | Calumet, Wisconsin, US | |
2966923 | 2966923 | 2021-12-24 | US | Wisconsin | Calumet | 55015 | 10460 | 89 | 0 | 44.0816316 | -88.21780273 | 2021-12-25 04:21:37 | Calumet, Wisconsin, US | |
2090784 | 2090784 | 2021-12-14 | US | South Carolina | Cherokee | 45021 | 10460 | 260 | 0 | 35.05122251 | -81.61828622 | 2021-12-15 03:22:16 | Cherokee, South Carolina, US | |
406518 | 406518 | 2021-12-07 | US | New York | Cattaraugus | 36009 | 10460 | 166 | 0 | 42.24778241 | -78.67923096 | 2021-12-08 04:22:46 | Cattaraugus, New York, US | |
1148235 | 1148235 | 2021-12-01 | US | Virginia | Bedford | 51019 | 10460 | 167 | 0 | 37.3080028 | -79.5281964 | 2021-12-02 04:22:37 | Bedford, Virginia, US | |
2676532 | 2676532 | 2021-07-18 | US | Puerto Rico | Bayamon | 72021 | 10460 | 0 | 0 | 18.34946 | -66.168435 | 2021-07-19 04:21:24 | Bayamon, Puerto Rico, US | |
2006358 | 2006358 | 2021-05-12 | US | Minnesota | Carver | 27019 | 10460 | 45 | 0 | 44.82017001 | -93.8009918 | 2021-05-13 04:20:51 | Carver, Minnesota, US | |
3129400 | 3129400 | 2021-04-18 | Djibouti | 10460 | 116 | 9172 | 1172 | 11.8251 | 42.5903 | 2021-04-19 04:20:57 | Djibouti | |||
2550632 | 2550632 | 2021-04-15 | US | Minnesota | Sherburne | 27141 | 10460 | 80 | 0 | 45.44447208 | -93.77617511 | 2021-04-16 04:20:46 | Sherburne, Minnesota, US | |
616119 | 616119 | 2021-02-08 | US | Ohio | Allen | 39003 | 10460 | 217 | 0 | 10243 | 40.77285242 | -84.10802343 | 2021-02-09 05:23:30 | Allen, Ohio, US |
1097620 | 1097620 | 2021-01-20 | US | Wisconsin | Eau Claire | 55035 | 10460 | 103 | 0 | 10357 | 44.726614 | -91.28609183 | 2021-01-21 05:22:01 | Eau Claire, Wisconsin, US |
1096775 | 1096775 | 2021-01-20 | US | Pennsylvania | Schuylkill | 42107 | 10460 | 305 | 0 | 10155 | 40.70497338 | -76.2150785 | 2021-01-21 05:22:01 | Schuylkill, Pennsylvania, US |
237082 | 237082 | 2021-01-18 | Colombia | Casanare | 10460 | 203 | 9438 | 819 | 5.7589 | -71.5724 | 2021-01-19 05:22:15 | Casanare, Colombia | ||
1585647 | 1585647 | 2020-11-30 | US | Louisiana | Calcasieu | 22019 | 10460 | 246 | 0 | 10214 | 30.22931235 | -93.35400434 | 2020-12-01 05:26:18 | Calcasieu, Louisiana, US |
3570117 | 3570117 | 2020-11-29 | US | Wisconsin | Marathon | 55073 | 10460 | 139 | 0 | 10321 | 44.89792533 | -89.75863384 | 2020-11-30 05:26:13 | Marathon, Wisconsin, US |
821530 | 821530 | 2020-11-19 | India | Nagaland | 10460 | 54 | 9110 | 1296 | 26.06702 | 94.470302 | 2020-11-20 05:26:28 | Nagaland, India | ||
1447814 | 1447814 | 2020-09-11 | US | Texas | Webb | 48479 | 10460 | 273 | 0 | 12259 | 27.7610369 | -99.33237355 | 2020-09-12 04:25:05 | Webb, Texas, US |
3865565 | 3865565 | 2020-06-03 | US | New York | Orange | 36071 | 10460 | 444 | 0 | 10016 | 41.40337468 | -74.30240757 | 2020-06-04 02:33:14 | Orange, 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]);