johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where confirmed = 12083 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311208 | 311208 | 2022-12-13 | US | Virginia | Charlottesville | 51540 | 12083 | 85 | 0 | 38.03527919 | -78.48569588 | 2022-12-14 04:21:04 | Charlottesville, Virginia, US | |
1966143 | 1966143 | 2022-11-30 | US | Maine | Somerset | 23025 | 12083 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-01 04:21:03 | Somerset, Maine, US | |
1623523 | 1623523 | 2022-11-22 | US | Texas | Van Zandt | 48467 | 12083 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-11-23 04:21:06 | Van Zandt, Texas, US | |
1623489 | 1623489 | 2022-11-22 | US | Texas | Rusk | 48401 | 12083 | 238 | 0 | 32.10773545 | -94.76176432 | 2022-11-23 04:21:06 | Rusk, Texas, US | |
3463411 | 3463411 | 2022-11-21 | US | Texas | Van Zandt | 48467 | 12083 | 297 | 0 | 32.56483801 | -95.83766469 | 2022-11-22 04:20:47 | Van Zandt, Texas, US | |
3463377 | 3463377 | 2022-11-21 | US | Texas | Rusk | 48401 | 12083 | 238 | 0 | 32.10773545 | -94.76176432 | 2022-11-22 04:20:47 | Rusk, Texas, US | |
3279654 | 3279654 | 2022-10-23 | US | Puerto Rico | San Sebastian | 72131 | 12083 | 0 | 0 | 18.328646 | -66.971214 | 2022-10-24 04:22:29 | San Sebastian, Puerto Rico, US | |
3252011 | 3252011 | 2022-10-11 | US | Mississippi | Warren | 28149 | 12083 | 216 | 0 | 32.35810271 | -90.83352619 | 2022-10-12 04:22:51 | Warren, Mississippi, US | |
2969270 | 2969270 | 2022-10-10 | US | Mississippi | Warren | 28149 | 12083 | 216 | 0 | 32.35810271 | -90.83352619 | 2022-10-11 04:23:05 | Warren, Mississippi, US | |
3099306 | 3099306 | 2022-10-09 | US | Mississippi | Warren | 28149 | 12083 | 216 | 0 | 32.35810271 | -90.83352619 | 2022-10-10 04:22:32 | Warren, Mississippi, US | |
4004531 | 4004531 | 2022-10-08 | US | Mississippi | Warren | 28149 | 12083 | 216 | 0 | 32.35810271 | -90.83352619 | 2022-10-09 04:21:16 | Warren, Mississippi, US | |
398128 | 398128 | 2022-10-07 | US | Mississippi | Warren | 28149 | 12083 | 216 | 0 | 32.35810271 | -90.83352619 | 2022-10-08 04:22:56 | Warren, Mississippi, US | |
2531245 | 2531245 | 2022-10-06 | US | Mississippi | Warren | 28149 | 12083 | 216 | 0 | 32.35810271 | -90.83352619 | 2022-10-07 04:23:08 | Warren, Mississippi, US | |
1812639 | 1812639 | 2022-10-05 | US | Mississippi | Warren | 28149 | 12083 | 216 | 0 | 32.35810271 | -90.83352619 | 2022-10-06 04:21:22 | Warren, Mississippi, US | |
132613 | 132613 | 2022-10-04 | US | Mississippi | Warren | 28149 | 12083 | 216 | 0 | 32.35810271 | -90.83352619 | 2022-10-05 04:23:06 | Warren, Mississippi, US | |
1561082 | 1561082 | 2022-09-28 | US | Illinois | Effingham | 17049 | 12083 | 143 | 0 | 39.05935711 | -88.58969584 | 2022-09-29 04:22:34 | Effingham, Illinois, US | |
3953903 | 3953903 | 2022-08-17 | US | Virginia | Shenandoah | 51171 | 12083 | 237 | 0 | 38.85905135 | -78.56813762 | 2022-08-18 04:21:11 | Shenandoah, Virginia, US | |
1068594 | 1068594 | 2022-07-28 | US | Puerto Rico | Aguadilla | 72005 | 12083 | 0 | 0 | 18.459681 | -67.120815 | 2022-07-29 04:20:45 | Aguadilla, Puerto Rico, US | |
3111034 | 3111034 | 2022-07-13 | US | Louisiana | Webster | 22119 | 12083 | 188 | 0 | 32.70847669 | -93.33121835 | 2022-07-14 04:20:57 | Webster, Louisiana, US | |
1419518 | 1419518 | 2022-07-08 | US | North Dakota | Stark | 38089 | 12083 | 86 | 0 | 46.80851182 | -102.6576326 | 2022-07-09 04:20:59 | Stark, North Dakota, US | |
2240263 | 2240263 | 2022-06-28 | US | Georgia | Polk | 13233 | 12083 | 196 | 0 | 34.00267074 | -85.18677781 | 2022-06-29 04:20:59 | Polk, Georgia, US | |
2148505 | 2148505 | 2022-06-27 | US | Georgia | Polk | 13233 | 12083 | 196 | 0 | 34.00267074 | -85.18677781 | 2022-06-28 04:20:58 | Polk, Georgia, US | |
476306 | 476306 | 2022-06-26 | US | Georgia | Polk | 13233 | 12083 | 196 | 0 | 34.00267074 | -85.18677781 | 2022-06-27 04:21:00 | Polk, Georgia, US | |
939681 | 939681 | 2022-06-25 | US | Georgia | Polk | 13233 | 12083 | 196 | 0 | 34.00267074 | -85.18677781 | 2022-06-26 04:21:02 | Polk, Georgia, US | |
3347501 | 3347501 | 2022-06-24 | US | Georgia | Polk | 13233 | 12083 | 196 | 0 | 34.00267074 | -85.18677781 | 2022-06-25 04:20:57 | Polk, Georgia, US | |
1649242 | 1649242 | 2022-06-23 | US | Georgia | Polk | 13233 | 12083 | 196 | 0 | 34.00267074 | -85.18677781 | 2022-06-24 04:20:58 | Polk, Georgia, US | |
2188477 | 2188477 | 2022-06-22 | US | Georgia | Polk | 13233 | 12083 | 196 | 0 | 34.00267074 | -85.18677781 | 2022-06-23 04:20:55 | Polk, Georgia, US | |
1187857 | 1187857 | 2022-05-18 | US | Texas | Hardin | 48199 | 12083 | 251 | 0 | 30.33364686 | -94.38931817 | 2022-05-19 04:20:54 | Hardin, Texas, US | |
2085705 | 2085705 | 2022-05-15 | US | Minnesota | Mower | 27099 | 12083 | 74 | 0 | 43.67142874 | -92.75234549 | 2022-05-16 04:20:47 | Mower, Minnesota, US | |
3356415 | 3356415 | 2022-05-14 | US | Minnesota | Mower | 27099 | 12083 | 74 | 0 | 43.67142874 | -92.75234549 | 2022-05-15 04:20:53 | Mower, Minnesota, US | |
660060 | 660060 | 2022-05-13 | US | Minnesota | Mower | 27099 | 12083 | 74 | 0 | 43.67142874 | -92.75234549 | 2022-05-14 04:20:48 | Mower, Minnesota, US | |
3467772 | 3467772 | 2022-01-18 | US | Wisconsin | Waupaca | 55135 | 12083 | 225 | 0 | 44.47068056 | -88.96534501 | 2022-01-19 04:21:23 | Waupaca, Wisconsin, US | |
3829364 | 3829364 | 2021-12-21 | US | Georgia | Walker | 13295 | 12083 | 172 | 0 | 34.73376362 | -85.30165174 | 2021-12-22 04:21:54 | Walker, Georgia, US | |
3073406 | 3073406 | 2021-11-23 | US | Virginia | Montgomery | 51121 | 12083 | 114 | 0 | 37.17746986 | -80.37868691 | 2021-11-24 04:22:14 | Montgomery, Virginia, US | |
714985 | 714985 | 2021-11-12 | US | Arkansas | Pope | 5115 | 12083 | 159 | 0 | 35.44871474 | -93.03212219 | 2021-11-13 04:21:38 | Pope, Arkansas, US | |
809573 | 809573 | 2021-09-20 | Italy | Valle d'Aosta | 12083 | 473 | 0 | 45.73750286 | 7.320149366 | 2021-09-21 04:21:26 | Valle d'Aosta, Italy | |||
1815444 | 1815444 | 2021-09-19 | US | Connecticut | Windham | 9015 | 12083 | 200 | 0 | 41.82972709 | -71.98182316 | 2021-09-20 04:21:22 | Windham, Connecticut, US | |
1814772 | 1814772 | 2021-09-19 | Italy | Valle d'Aosta | 12083 | 473 | 0 | 45.73750286 | 7.320149366 | 2021-09-20 04:21:22 | Valle d'Aosta, Italy | |||
17024 | 17024 | 2021-09-18 | US | Connecticut | Windham | 9015 | 12083 | 200 | 0 | 41.82972709 | -71.98182316 | 2021-09-19 04:21:34 | Windham, Connecticut, US | |
2618709 | 2618709 | 2021-09-17 | US | Connecticut | Windham | 9015 | 12083 | 200 | 0 | 41.82972709 | -71.98182316 | 2021-09-18 04:21:24 | Windham, Connecticut, US | |
3362347 | 3362347 | 2021-06-21 | Malaysia | Pahang | 12083 | 92 | 11194 | 797 | 3.8126 | 103.3256 | 2021-06-22 04:21:34 | Pahang, Malaysia | ||
608935 | 608935 | 2021-04-09 | US | Texas | Wichita | 48485 | 12083 | 373 | 0 | 33.98842886 | -98.7041034 | 2021-04-10 04:20:59 | Wichita, Texas, US | |
2648999 | 2648999 | 2021-04-08 | US | Texas | Wichita | 48485 | 12083 | 373 | 0 | 33.98842886 | -98.7041034 | 2021-04-09 04:21:13 | Wichita, Texas, US | |
1983133 | 1983133 | 2021-03-25 | US | Ohio | Wood | 39173 | 12083 | 187 | 0 | 41.36224827 | -83.62285108 | 2021-03-26 05:26:55 | Wood, Ohio, US | |
3964713 | 3964713 | 2021-03-10 | US | New Mexico | McKinley | 35031 | 12083 | 451 | 0 | 35.58007720000001 | -108.262245 | 2021-03-11 05:25:48 | McKinley, New Mexico, US | |
3153565 | 3153565 | 2021-01-27 | India | Nagaland | 12083 | 88 | 11938 | 57 | 26.06702 | 94.470302 | 2021-01-28 05:22:24 | Nagaland, India | ||
3779148 | 3779148 | 2020-12-27 | US | Iowa | Woodbury | 19193 | 12083 | 163 | 0 | 11920 | 42.38979414 | -96.0459439 | 2020-12-28 05:22:06 | Woodbury, Iowa, US |
1036851 | 1036851 | 2020-12-15 | US | Ohio | Mahoning | 39099 | 12083 | 407 | 0 | 11676 | 41.01631101 | -80.77287029 | 2020-12-16 05:28:04 | Mahoning, Ohio, US |
1034595 | 1034595 | 2020-12-15 | Russia | Mordovia Republic | 12083 | 76 | 9855 | 2152 | 54.4419829 | 44.4661144 | 2020-12-16 05:28:04 | Mordovia Republic, Russia | ||
662433 | 662433 | 2020-08-11 | North Macedonia | 12083 | 529 | 8248 | 3306 | 41.6086 | 21.7453 | 2020-08-12 04:27:29 | North Macedonia | |||
528437 | 528437 | 2020-07-04 | US | Wisconsin | Milwaukee | 55079 | 12083 | 391 | 0 | 11692 | 43.00486062 | -87.96733172 | 2020-07-05 04:33:46 | Milwaukee, Wisconsin, 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]);