johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where confirmed = 10487 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1150902 | 1150902 | 2022-12-12 | US | Missouri | Pulaski | 29169 | 10487 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-12-13 04:21:01 | Pulaski, Missouri, US | |
870756 | 870756 | 2022-12-11 | US | Missouri | Pulaski | 29169 | 10487 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-12-12 04:21:01 | Pulaski, Missouri, US | |
259286 | 259286 | 2022-12-10 | US | Missouri | Pulaski | 29169 | 10487 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-12-11 04:20:50 | Pulaski, Missouri, US | |
3938000 | 3938000 | 2022-12-09 | US | Missouri | Pulaski | 29169 | 10487 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-12-10 04:21:02 | Pulaski, Missouri, US | |
3379332 | 3379332 | 2022-12-08 | US | Missouri | Pulaski | 29169 | 10487 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-12-09 04:21:05 | Pulaski, Missouri, US | |
1986603 | 1986603 | 2022-12-07 | US | Missouri | Pulaski | 29169 | 10487 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-12-08 04:21:07 | Pulaski, Missouri, US | |
3716126 | 3716126 | 2022-12-06 | US | Missouri | Pulaski | 29169 | 10487 | 125 | 0 | 37.82462075 | -92.20783203 | 2022-12-07 04:20:58 | Pulaski, Missouri, US | |
2488975 | 2488975 | 2022-11-16 | US | Tennessee | Marion | 47115 | 10487 | 138 | 0 | 35.12997174 | -85.62265895 | 2022-11-17 04:21:11 | Marion, Tennessee, US | |
2760345 | 2760345 | 2022-10-18 | US | Virginia | Warren | 51187 | 10487 | 169 | 0 | 38.90847745 | -78.20280433 | 2022-10-19 04:22:26 | Warren, Virginia, US | |
373213 | 373213 | 2022-09-13 | US | Illinois | Lee | 17103 | 10487 | 84 | 0 | 41.74583951 | -89.29977132 | 2022-09-14 04:20:44 | Lee, Illinois, US | |
3748256 | 3748256 | 2022-09-07 | US | Texas | Kerr | 48265 | 10487 | 190 | 0 | 30.06040006 | -99.34930144 | 2022-09-08 04:21:02 | Kerr, Texas, US | |
3775129 | 3775129 | 2022-08-30 | US | Iowa | Marshall | 19127 | 10487 | 118 | 0 | 42.03586837 | -92.9990819 | 2022-08-31 04:20:57 | Marshall, Iowa, US | |
3774829 | 3774829 | 2022-08-30 | US | Idaho | Bingham | 16011 | 10487 | 163 | 0 | 43.2167288 | -112.3978437 | 2022-08-31 04:20:57 | Bingham, Idaho, US | |
1681725 | 1681725 | 2022-08-29 | US | Iowa | Marshall | 19127 | 10487 | 118 | 0 | 42.03586837 | -92.9990819 | 2022-08-30 04:21:03 | Marshall, Iowa, US | |
1878209 | 1878209 | 2022-08-28 | US | Iowa | Marshall | 19127 | 10487 | 118 | 0 | 42.03586837 | -92.9990819 | 2022-08-29 04:21:06 | Marshall, Iowa, US | |
2097336 | 2097336 | 2022-08-27 | US | Iowa | Marshall | 19127 | 10487 | 118 | 0 | 42.03586837 | -92.9990819 | 2022-08-28 04:21:02 | Marshall, Iowa, US | |
1533151 | 1533151 | 2022-08-26 | US | Iowa | Marshall | 19127 | 10487 | 118 | 0 | 42.03586837 | -92.9990819 | 2022-08-27 04:20:57 | Marshall, Iowa, US | |
2830038 | 2830038 | 2022-08-25 | US | Iowa | Marshall | 19127 | 10487 | 118 | 0 | 42.03586837 | -92.9990819 | 2022-08-26 04:21:02 | Marshall, Iowa, US | |
2324571 | 2324571 | 2022-08-24 | US | Iowa | Marshall | 19127 | 10487 | 118 | 0 | 42.03586837 | -92.9990819 | 2022-08-25 04:21:13 | Marshall, Iowa, US | |
2403756 | 2403756 | 2022-08-21 | US | Idaho | Bingham | 16011 | 10487 | 163 | 0 | 43.2167288 | -112.3978437 | 2022-08-22 04:20:38 | Bingham, Idaho, US | |
3798834 | 3798834 | 2022-08-20 | US | Idaho | Bingham | 16011 | 10487 | 163 | 0 | 43.2167288 | -112.3978437 | 2022-08-21 04:20:44 | Bingham, Idaho, US | |
2364420 | 2364420 | 2022-08-19 | US | Idaho | Bingham | 16011 | 10487 | 163 | 0 | 43.2167288 | -112.3978437 | 2022-08-20 04:21:01 | Bingham, Idaho, US | |
1088305 | 1088305 | 2022-08-09 | US | New York | Chenango | 36017 | 10487 | 125 | 0 | 42.49430041 | -75.60887553 | 2022-08-10 04:20:57 | Chenango, New York, US | |
3408445 | 3408445 | 2022-07-17 | US | Tennessee | Rhea | 47143 | 10487 | 161 | 0 | 35.60536161 | -84.93076643 | 2022-07-18 04:20:59 | Rhea, Tennessee, US | |
3144828 | 3144828 | 2022-06-11 | US | Texas | Van Zandt | 48467 | 10487 | 281 | 0 | 32.56483801 | -95.83766469 | 2022-06-12 04:20:53 | Van Zandt, Texas, US | |
3267936 | 3267936 | 2022-05-04 | US | North Dakota | Williams | 38105 | 10487 | 68 | 0 | 48.34522353 | -103.4793387 | 2022-05-05 04:20:55 | Williams, North Dakota, US | |
1574575 | 1574575 | 2022-05-03 | US | North Dakota | Williams | 38105 | 10487 | 68 | 0 | 48.34522353 | -103.4793387 | 2022-05-04 04:20:59 | Williams, North Dakota, US | |
3629699 | 3629699 | 2022-03-13 | US | Minnesota | McLeod | 27085 | 10487 | 107 | 0 | 44.82367677 | -94.27287017 | 2022-03-14 04:20:46 | McLeod, Minnesota, US | |
952607 | 952607 | 2022-03-12 | US | Minnesota | McLeod | 27085 | 10487 | 107 | 0 | 44.82367677 | -94.27287017 | 2022-03-13 04:20:49 | McLeod, Minnesota, US | |
358068 | 358068 | 2022-03-11 | US | Minnesota | McLeod | 27085 | 10487 | 107 | 0 | 44.82367677 | -94.27287017 | 2022-03-12 04:20:50 | McLeod, Minnesota, US | |
2447266 | 2447266 | 2022-02-22 | US | Arkansas | Independence | 5063 | 10487 | 190 | 0 | 35.74242707 | -91.57001641 | 2022-02-23 04:21:09 | Independence, Arkansas, US | |
459871 | 459871 | 2022-02-02 | US | Arkansas | Hot Spring | 5059 | 10487 | 116 | 0 | 34.31709259 | -92.95396325 | 2022-02-03 04:21:21 | Hot Spring, Arkansas, US | |
3636 | 3636 | 2021-12-02 | US | Virginia | Bedford | 51019 | 10487 | 167 | 0 | 37.3080028 | -79.5281964 | 2021-12-03 04:23:05 | Bedford, Virginia, US | |
1231833 | 1231833 | 2021-11-28 | Russia | Jewish Autonomous Okrug | 10487 | 336 | 0 | 48.57527615 | 132.66307460000002 | 2021-11-29 04:22:30 | Jewish Autonomous Okrug, Russia | |||
289481 | 289481 | 2021-10-31 | US | Louisiana | Acadia | 22001 | 10487 | 249 | 0 | 30.295064899999996 | -92.41419698 | 2021-11-01 04:22:01 | Acadia, Louisiana, US | |
2722487 | 2722487 | 2021-10-30 | US | Louisiana | Acadia | 22001 | 10487 | 249 | 0 | 30.295064899999996 | -92.41419698 | 2021-10-31 04:22:08 | Acadia, Louisiana, US | |
568589 | 568589 | 2021-10-29 | US | Louisiana | Acadia | 22001 | 10487 | 249 | 0 | 30.295064899999996 | -92.41419698 | 2021-10-30 04:22:03 | Acadia, Louisiana, US | |
2925834 | 2925834 | 2021-08-27 | US | Pennsylvania | Adams | 42001 | 10487 | 191 | 0 | 39.87140411 | -77.21610347 | 2021-08-28 04:21:28 | Adams, Pennsylvania, US | |
380565 | 380565 | 2021-04-30 | US | Alabama | Houston | 1069 | 10487 | 280 | 0 | 31.15197924 | -85.29939599 | 2021-05-01 04:20:47 | Houston, Alabama, US | |
890014 | 890014 | 2021-04-26 | US | Missouri | Franklin | 29071 | 10487 | 179 | 0 | 38.41127108 | -91.07522826 | 2021-04-27 04:20:52 | Franklin, Missouri, US | |
3712816 | 3712816 | 2021-04-03 | US | Pennsylvania | Lycoming | 42081 | 10487 | 265 | 0 | 41.34310539 | -77.06629984 | 2021-04-04 04:20:49 | Lycoming, Pennsylvania, US | |
3645869 | 3645869 | 2021-03-30 | US | North Carolina | Harnett | 37085 | 10487 | 162 | 0 | 35.36731853 | -78.87243571 | 2021-03-31 04:26:25 | Harnett, North Carolina, US | |
353403 | 353403 | 2021-03-11 | US | Indiana | Monroe | 18105 | 10487 | 165 | 0 | 39.16130004 | -86.52414358 | 2021-03-12 05:26:50 | Monroe, Indiana, US | |
3978475 | 3978475 | 2021-02-10 | France | Reunion | 10487 | 47 | 10049 | 391 | -21.1151 | 55.5364 | 2021-02-11 05:23:55 | Reunion, France | ||
1527795 | 1527795 | 2021-02-09 | France | Reunion | 10487 | 47 | 9769 | 671 | -21.1151 | 55.5364 | 2021-02-10 05:22:41 | Reunion, France | ||
613586 | 613586 | 2021-02-08 | France | Reunion | 10487 | 47 | 9769 | 671 | -21.1151 | 55.5364 | 2021-02-09 05:23:30 | Reunion, France | ||
1672355 | 1672355 | 2021-02-07 | France | Reunion | 10487 | 47 | 9769 | 671 | -21.1151 | 55.5364 | 2021-02-08 05:22:39 | Reunion, France | ||
974816 | 974816 | 2021-02-06 | France | Reunion | 10487 | 47 | 9769 | 671 | -21.1151 | 55.5364 | 2021-02-07 05:23:00 | Reunion, France | ||
2568049 | 2568049 | 2021-01-25 | US | Alabama | Marshall | 1095 | 10487 | 123 | 0 | 10364 | 34.36975964 | -86.30486727 | 2021-01-26 05:22:02 | Marshall, Alabama, US |
2931891 | 2931891 | 2020-12-19 | US | Florida | Bay | 12005 | 10487 | 190 | 0 | 10297 | 30.26548745 | -85.62122584 | 2020-12-20 05:27:32 | Bay, Florida, US |
3847908 | 3847908 | 2020-12-13 | Netherlands | Friesland | 10487 | 145 | 0 | 10327 | 53.087337 | 5.7925 | 2020-12-14 05:26:27 | Friesland, Netherlands | ||
3441067 | 3441067 | 2020-11-11 | Russia | Tyva Republic | 10487 | 120 | 9564 | 803 | 51.4017149 | 93.8582593 | 2020-11-12 05:25:55 | Tyva Republic, Russia | ||
3782422 | 3782422 | 2020-10-13 | US | Arkansas | Washington | 5143 | 10487 | 127 | 0 | 10360 | 35.976844 | -94.21800746 | 2020-10-14 04:24:05 | Washington, Arkansas, US |
3786134 | 3786134 | 2020-10-11 | Russia | Sakha (Yakutiya) Republic | 10487 | 105 | 7436 | 2946 | 66.941626 | 129.642371 | 2020-10-12 04:23:45 | Sakha (Yakutiya) Republic, Russia | ||
2815803 | 2815803 | 2020-09-25 | US | Texas | Denton | 48121 | 10487 | 152 | 0 | 11800 | 33.20521901 | -97.11691153 | 2020-09-26 04:23:00 | Denton, Texas, US |
1109160 | 1109160 | 2020-09-02 | Ukraine | Chernivtsi Oblast | 10487 | 287 | 6327 | 3873 | 48.2917 | 25.9352 | 2020-09-03 04:28:22 | Chernivtsi Oblast, Ukraine | ||
663016 | 663016 | 2020-08-11 | US | Florida | Collier | 12021 | 10487 | 143 | 0 | 10344 | 26.11091986 | -81.34687065 | 2020-08-12 04:27:29 | Collier, Florida, US |
97007 | 97007 | 2020-08-04 | US | Louisiana | Orleans | 22071 | 10487 | 560 | 0 | 9927 | 30.06971951 | -89.92660315 | 2020-08-05 04:34:43 | Orleans, Louisiana, US |
574142 | 574142 | 2020-06-06 | Peru | Piura | 10487 | 2511 | 0 | 7976 | -5.133361 | -80.335861 | 2020-06-07 03:53:30 | Piura, Peru |
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]);