johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where confirmed = 12376 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755660 | 2755660 | 2022-12-29 | US | Puerto Rico | Juncos | 72077 | 12376 | 0 | 0 | 18.223793 | -65.909109 | 2022-12-30 04:21:04 | Juncos, Puerto Rico, US | |
2487747 | 2487747 | 2022-11-16 | US | Minnesota | McLeod | 27085 | 12376 | 117 | 0 | 44.82367677 | -94.27287017 | 2022-11-17 04:21:11 | McLeod, Minnesota, US | |
293758 | 293758 | 2022-11-15 | US | Minnesota | McLeod | 27085 | 12376 | 117 | 0 | 44.82367677 | -94.27287017 | 2022-11-16 04:21:09 | McLeod, Minnesota, US | |
3598788 | 3598788 | 2022-11-14 | US | Minnesota | McLeod | 27085 | 12376 | 117 | 0 | 44.82367677 | -94.27287017 | 2022-11-15 04:21:16 | McLeod, Minnesota, US | |
313646 | 313646 | 2022-11-13 | US | Minnesota | McLeod | 27085 | 12376 | 117 | 0 | 44.82367677 | -94.27287017 | 2022-11-14 04:21:09 | McLeod, Minnesota, US | |
64807 | 64807 | 2022-11-12 | US | Minnesota | McLeod | 27085 | 12376 | 117 | 0 | 44.82367677 | -94.27287017 | 2022-11-13 04:21:14 | McLeod, Minnesota, US | |
2928969 | 2928969 | 2022-11-11 | US | Minnesota | McLeod | 27085 | 12376 | 117 | 0 | 44.82367677 | -94.27287017 | 2022-11-12 04:20:41 | McLeod, Minnesota, US | |
2507805 | 2507805 | 2022-11-10 | US | Minnesota | McLeod | 27085 | 12376 | 117 | 0 | 44.82367677 | -94.27287017 | 2022-11-11 04:21:22 | McLeod, Minnesota, US | |
1832365 | 1832365 | 2022-10-25 | US | New Mexico | Rio Arriba | 35039 | 12376 | 154 | 0 | 36.51072137 | -106.6931674 | 2022-10-26 04:22:19 | Rio Arriba, New Mexico, US | |
795432 | 795432 | 2022-10-24 | US | Illinois | Livingston | 17105 | 12376 | 139 | 0 | 40.89188292 | -88.55784752 | 2022-10-25 04:21:53 | Livingston, Illinois, US | |
4005596 | 4005596 | 2022-10-08 | US | Tennessee | Cheatham | 47021 | 12376 | 135 | 0 | 36.26136216 | -87.08903581 | 2022-10-09 04:21:16 | Cheatham, Tennessee, US | |
3376094 | 3376094 | 2022-09-17 | US | Puerto Rico | Cayey | 72035 | 12376 | 0 | 0 | 18.102851 | -66.14914 | 2022-09-18 04:22:50 | Cayey, Puerto Rico, US | |
256089 | 256089 | 2022-09-08 | US | Puerto Rico | Rio Grande | 72119 | 12376 | 0 | 0 | 18.346329 | -65.813742 | 2022-09-09 04:21:11 | Rio Grande, Puerto Rico, US | |
673229 | 673229 | 2022-07-21 | US | Tennessee | Cocke | 47029 | 12376 | 226 | 0 | 35.9278914 | -83.11828725 | 2022-07-22 04:21:15 | Cocke, Tennessee, US | |
3408207 | 3408207 | 2022-07-17 | US | Puerto Rico | Humacao | 72069 | 12376 | 0 | 0 | 18.145211 | -65.810174 | 2022-07-18 04:20:59 | Humacao, Puerto Rico, US | |
2744597 | 2744597 | 2022-07-07 | US | Wisconsin | Shawano | 55115 | 12376 | 155 | 0 | 44.78902246 | -88.76443896 | 2022-07-08 04:20:56 | Shawano, Wisconsin, US | |
3270626 | 3270626 | 2022-06-19 | US | Indiana | Lawrence | 18093 | 12376 | 264 | 0 | 38.84112637 | -86.48361629 | 2022-06-20 04:21:01 | Lawrence, Indiana, US | |
3398538 | 3398538 | 2022-06-18 | US | Indiana | Lawrence | 18093 | 12376 | 264 | 0 | 38.84112637 | -86.48361629 | 2022-06-19 04:20:51 | Lawrence, Indiana, US | |
2312415 | 2312415 | 2022-06-17 | US | Indiana | Lawrence | 18093 | 12376 | 264 | 0 | 38.84112637 | -86.48361629 | 2022-06-18 04:21:10 | Lawrence, Indiana, US | |
3983584 | 3983584 | 2022-06-15 | US | Illinois | Clinton | 17027 | 12376 | 113 | 0 | 38.60704876 | -89.42385254 | 2022-06-16 04:20:55 | Clinton, Illinois, US | |
3159555 | 3159555 | 2022-06-09 | US | Missouri | Johnson | 29101 | 12376 | 144 | 0 | 38.74719601 | -93.80691168 | 2022-06-10 04:20:55 | Johnson, Missouri, US | |
1423022 | 1423022 | 2022-06-08 | US | Missouri | Johnson | 29101 | 12376 | 144 | 0 | 38.74719601 | -93.80691168 | 2022-06-09 04:20:54 | Johnson, Missouri, US | |
3728136 | 3728136 | 2022-06-07 | US | Missouri | Johnson | 29101 | 12376 | 144 | 0 | 38.74719601 | -93.80691168 | 2022-06-08 04:20:55 | Johnson, Missouri, US | |
3889538 | 3889538 | 2022-06-06 | US | Missouri | Johnson | 29101 | 12376 | 144 | 0 | 38.74719601 | -93.80691168 | 2022-06-07 04:21:08 | Johnson, Missouri, US | |
3509307 | 3509307 | 2022-06-05 | US | Missouri | Johnson | 29101 | 12376 | 144 | 0 | 38.74719601 | -93.80691168 | 2022-06-06 04:20:57 | Johnson, Missouri, US | |
3529384 | 3529384 | 2022-06-04 | US | Missouri | Johnson | 29101 | 12376 | 144 | 0 | 38.74719601 | -93.80691168 | 2022-06-05 04:20:55 | Johnson, Missouri, US | |
3135470 | 3135470 | 2022-06-03 | US | Missouri | Johnson | 29101 | 12376 | 144 | 0 | 38.74719601 | -93.80691168 | 2022-06-04 04:20:58 | Johnson, Missouri, US | |
1188314 | 1188314 | 2022-05-18 | US | Wisconsin | Monroe | 55081 | 12376 | 91 | 0 | 43.94641218 | -90.618819 | 2022-05-19 04:20:54 | Monroe, Wisconsin, US | |
2086205 | 2086205 | 2022-05-15 | US | New York | Livingston | 36051 | 12376 | 118 | 0 | 42.72596275 | -77.77966158 | 2022-05-16 04:20:47 | Livingston, New York, US | |
1719579 | 1719579 | 2021-12-16 | US | Texas | Starr | 48427 | 12376 | 336 | 0 | 26.56150059 | -98.73892358 | 2021-12-17 04:22:14 | Starr, Texas, US | |
1080985 | 1080985 | 2021-12-09 | US | Texas | Coryell | 48099 | 12376 | 168 | 0 | 31.39078397 | -97.79936155 | 2021-12-10 04:22:28 | Coryell, Texas, US | |
553141 | 553141 | 2021-12-08 | US | North Carolina | Stanly | 37167 | 12376 | 206 | 0 | 35.31647813 | -80.25093221 | 2021-12-09 04:22:49 | Stanly, North Carolina, US | |
1912603 | 1912603 | 2021-10-17 | US | Virginia | Portsmouth | 51740 | 12376 | 233 | 0 | 36.85914825 | -76.35971629 | 2021-10-18 04:21:10 | Portsmouth, Virginia, US | |
938192 | 938192 | 2021-10-16 | US | Virginia | Portsmouth | 51740 | 12376 | 233 | 0 | 36.85914825 | -76.35971629 | 2021-10-17 04:21:29 | Portsmouth, Virginia, US | |
2946747 | 2946747 | 2021-10-15 | US | Virginia | Portsmouth | 51740 | 12376 | 233 | 0 | 36.85914825 | -76.35971629 | 2021-10-16 04:21:15 | Portsmouth, Virginia, US | |
1337522 | 1337522 | 2021-09-28 | US | Texas | Walker | 48471 | 12376 | 167 | 0 | 30.73872995 | -95.57440968 | 2021-09-29 04:21:45 | Walker, Texas, US | |
2280209 | 2280209 | 2021-09-08 | US | Illinois | Vermilion | 17183 | 12376 | 171 | 0 | 40.18417171 | -87.73384359 | 2021-09-09 04:21:27 | Vermilion, Illinois, US | |
248874 | 248874 | 2021-08-17 | US | Wyoming | Laramie | 56021 | 12376 | 144 | 0 | 41.30702520000001 | -104.6887497 | 2021-08-18 04:21:35 | Laramie, Wyoming, US | |
402463 | 402463 | 2021-06-29 | US | New Mexico | McKinley | 35031 | 12376 | 478 | 0 | 35.58007720000001 | -108.262245 | 2021-06-30 04:21:41 | McKinley, New Mexico, US | |
3127706 | 3127706 | 2021-06-28 | US | New Mexico | McKinley | 35031 | 12376 | 478 | 0 | 35.58007720000001 | -108.262245 | 2021-06-29 04:21:28 | McKinley, New Mexico, US | |
1916413 | 1916413 | 2021-05-20 | US | Texas | Rockwall | 48397 | 12376 | 154 | 0 | 32.89779518 | -96.40771592 | 2021-05-21 04:20:43 | Rockwall, Texas, US | |
2247355 | 2247355 | 2021-04-07 | India | Nagaland | 12376 | 92 | 12143 | 141 | 26.06702 | 94.470302 | 2021-04-08 04:21:13 | Nagaland, India | ||
3453430 | 3453430 | 2021-03-18 | US | California | Shasta | 6089 | 12376 | 100 | 0 | 40.76391419 | -122.0396884 | 2021-03-19 05:26:09 | Shasta, California, US | |
3670063 | 3670063 | 2021-03-06 | US | Ohio | Clark | 39023 | 12376 | 283 | 0 | 12093 | 39.91592258 | -83.78498252 | 2021-03-07 05:21:54 | Clark, Ohio, US |
2978636 | 2978636 | 2020-12-09 | US | Virginia | Virginia Beach | 51810 | 12376 | 123 | 0 | 12253 | 36.73285734 | -76.04566934 | 2020-12-10 05:26:19 | Virginia Beach, Virginia, US |
3610345 | 3610345 | 2020-08-06 | US | Illinois | Lake | 17097 | 12376 | 444 | 0 | 11932 | 42.3224907 | -88.00367925 | 2020-08-07 04:35:11 | Lake, Illinois, US |
3043256 | 3043256 | 2020-07-02 | US | Florida | Hillsborough | 12057 | 12376 | 145 | 0 | 12231 | 27.9276559 | -82.32013172 | 2020-07-03 04:33:54 | Hillsborough, Florida, 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]);