johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68 rows where confirmed = 13447 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- US 63
- Andorra 1
- Burkina Faso 1
- Chile 1
- Netherlands 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754580 | 2754580 | 2022-12-29 | US | Michigan | Newaygo | 26123 | 13447 | 180 | 0 | 43.554374 | -85.80070107 | 2022-12-30 04:21:04 | Newaygo, Michigan, US | |
1075586 | 1075586 | 2022-12-28 | US | Michigan | Newaygo | 26123 | 13447 | 180 | 0 | 43.554374 | -85.80070107 | 2022-12-29 04:21:01 | Newaygo, Michigan, US | |
329583 | 329583 | 2022-12-27 | US | Michigan | Newaygo | 26123 | 13447 | 180 | 0 | 43.554374 | -85.80070107 | 2022-12-28 04:21:04 | Newaygo, Michigan, US | |
1987098 | 1987098 | 2022-12-07 | US | Ohio | Brown | 39015 | 13447 | 194 | 0 | 38.93416837 | -83.86788395 | 2022-12-08 04:21:07 | Brown, Ohio, US | |
3716621 | 3716621 | 2022-12-06 | US | Ohio | Brown | 39015 | 13447 | 194 | 0 | 38.93416837 | -83.86788395 | 2022-12-07 04:20:58 | Brown, Ohio, US | |
2417326 | 2417326 | 2022-12-05 | US | Ohio | Brown | 39015 | 13447 | 194 | 0 | 38.93416837 | -83.86788395 | 2022-12-06 04:21:03 | Brown, Ohio, US | |
720934 | 720934 | 2022-12-04 | US | Ohio | Brown | 39015 | 13447 | 194 | 0 | 38.93416837 | -83.86788395 | 2022-12-05 04:20:58 | Brown, Ohio, US | |
2819223 | 2819223 | 2022-12-03 | US | Ohio | Brown | 39015 | 13447 | 194 | 0 | 38.93416837 | -83.86788395 | 2022-12-04 04:20:56 | Brown, Ohio, US | |
836079 | 836079 | 2022-12-02 | US | Ohio | Brown | 39015 | 13447 | 194 | 0 | 38.93416837 | -83.86788395 | 2022-12-03 04:21:02 | Brown, Ohio, US | |
2138609 | 2138609 | 2022-12-01 | US | Ohio | Brown | 39015 | 13447 | 194 | 0 | 38.93416837 | -83.86788395 | 2022-12-02 04:21:07 | Brown, Ohio, US | |
3280089 | 3280089 | 2022-10-23 | US | Texas | San Patricio | 48409 | 13447 | 358 | 0 | 28.00880118 | -97.51763891 | 2022-10-24 04:22:29 | San Patricio, Texas, US | |
2271127 | 2271127 | 2022-10-22 | US | Texas | San Patricio | 48409 | 13447 | 358 | 0 | 28.00880118 | -97.51763891 | 2022-10-23 04:22:46 | San Patricio, Texas, US | |
1595427 | 1595427 | 2022-10-21 | US | Texas | San Patricio | 48409 | 13447 | 358 | 0 | 28.00880118 | -97.51763891 | 2022-10-22 04:22:53 | San Patricio, Texas, US | |
397830 | 397830 | 2022-10-07 | US | Maine | Oxford | 23017 | 13447 | 161 | 0 | 44.49952995 | -70.75682123 | 2022-10-08 04:22:56 | Oxford, Maine, US | |
3376079 | 3376079 | 2022-09-17 | US | Puerto Rico | Aguadilla | 72005 | 13447 | 0 | 0 | 18.459681 | -67.120815 | 2022-09-18 04:22:50 | Aguadilla, Puerto Rico, US | |
2337911 | 2337911 | 2022-07-27 | US | Ohio | Seneca | 39147 | 13447 | 234 | 0 | 41.12351311 | -83.12783209 | 2022-07-28 04:20:56 | Seneca, Ohio, US | |
1490101 | 1490101 | 2022-07-26 | US | Ohio | Seneca | 39147 | 13447 | 234 | 0 | 41.12351311 | -83.12783209 | 2022-07-27 04:21:04 | Seneca, Ohio, US | |
2596547 | 2596547 | 2022-07-25 | US | Ohio | Seneca | 39147 | 13447 | 234 | 0 | 41.12351311 | -83.12783209 | 2022-07-26 04:20:58 | Seneca, Ohio, US | |
898662 | 898662 | 2022-07-24 | US | Ohio | Seneca | 39147 | 13447 | 234 | 0 | 41.12351311 | -83.12783209 | 2022-07-25 04:20:51 | Seneca, Ohio, US | |
93656 | 93656 | 2022-07-23 | US | Ohio | Seneca | 39147 | 13447 | 234 | 0 | 41.12351311 | -83.12783209 | 2022-07-24 04:20:47 | Seneca, Ohio, US | |
902678 | 902678 | 2022-07-22 | US | Ohio | Seneca | 39147 | 13447 | 234 | 0 | 41.12351311 | -83.12783209 | 2022-07-23 04:20:53 | Seneca, Ohio, US | |
672814 | 672814 | 2022-07-21 | US | Ohio | Seneca | 39147 | 13447 | 234 | 0 | 41.12351311 | -83.12783209 | 2022-07-22 04:21:15 | Seneca, Ohio, US | |
2791227 | 2791227 | 2022-07-10 | US | New Mexico | Curry | 35009 | 13447 | 212 | 0 | 34.57421077 | -103.3468876 | 2022-07-11 04:20:46 | Curry, New Mexico, US | |
144180 | 144180 | 2022-07-09 | US | New Mexico | Curry | 35009 | 13447 | 212 | 0 | 34.57421077 | -103.3468876 | 2022-07-10 04:20:54 | Curry, New Mexico, US | |
1419280 | 1419280 | 2022-07-08 | US | New Mexico | Curry | 35009 | 13447 | 212 | 0 | 34.57421077 | -103.3468876 | 2022-07-09 04:20:59 | Curry, New Mexico, US | |
3943065 | 3943065 | 2022-06-30 | US | Tennessee | Warren | 47177 | 13447 | 181 | 0 | 35.6728299 | -85.77969117 | 2022-07-01 04:21:10 | Warren, Tennessee, US | |
2241761 | 2241761 | 2022-06-28 | US | North Carolina | Richmond | 37153 | 13447 | 194 | 0 | 35.00417719 | -79.74491009 | 2022-06-29 04:20:59 | Richmond, North Carolina, US | |
2150003 | 2150003 | 2022-06-27 | US | North Carolina | Richmond | 37153 | 13447 | 194 | 0 | 35.00417719 | -79.74491009 | 2022-06-28 04:20:58 | Richmond, North Carolina, US | |
477804 | 477804 | 2022-06-26 | US | North Carolina | Richmond | 37153 | 13447 | 194 | 0 | 35.00417719 | -79.74491009 | 2022-06-27 04:21:00 | Richmond, North Carolina, US | |
941179 | 941179 | 2022-06-25 | US | North Carolina | Richmond | 37153 | 13447 | 194 | 0 | 35.00417719 | -79.74491009 | 2022-06-26 04:21:02 | Richmond, North Carolina, US | |
3348999 | 3348999 | 2022-06-24 | US | North Carolina | Richmond | 37153 | 13447 | 194 | 0 | 35.00417719 | -79.74491009 | 2022-06-25 04:20:57 | Richmond, North Carolina, US | |
1650740 | 1650740 | 2022-06-23 | US | North Carolina | Richmond | 37153 | 13447 | 194 | 0 | 35.00417719 | -79.74491009 | 2022-06-24 04:20:58 | Richmond, North Carolina, US | |
2189975 | 2189975 | 2022-06-22 | US | North Carolina | Richmond | 37153 | 13447 | 194 | 0 | 35.00417719 | -79.74491009 | 2022-06-23 04:20:55 | Richmond, North Carolina, US | |
2084553 | 2084553 | 2022-05-15 | US | California | Tuolumne | 6109 | 13447 | 182 | 0 | 38.02644018 | -119.9525093 | 2022-05-16 04:20:47 | Tuolumne, California, US | |
3355263 | 3355263 | 2022-05-14 | US | California | Tuolumne | 6109 | 13447 | 182 | 0 | 38.02644018 | -119.9525093 | 2022-05-15 04:20:53 | Tuolumne, California, US | |
658908 | 658908 | 2022-05-13 | US | California | Tuolumne | 6109 | 13447 | 182 | 0 | 38.02644018 | -119.9525093 | 2022-05-14 04:20:48 | Tuolumne, California, US | |
922027 | 922027 | 2022-03-08 | US | North Carolina | McDowell | 37111 | 13447 | 163 | 0 | 35.67736232 | -82.0482425 | 2022-03-09 04:20:59 | McDowell, North Carolina, US | |
187771 | 187771 | 2022-02-13 | US | Minnesota | Benton | 27009 | 13447 | 164 | 0 | 45.69804958 | -93.99514135 | 2022-02-14 04:20:51 | Benton, Minnesota, US | |
317617 | 317617 | 2022-02-12 | US | Minnesota | Benton | 27009 | 13447 | 164 | 0 | 45.69804958 | -93.99514135 | 2022-02-13 04:21:00 | Benton, Minnesota, US | |
234943 | 234943 | 2022-02-11 | US | Minnesota | Benton | 27009 | 13447 | 164 | 0 | 45.69804958 | -93.99514135 | 2022-02-12 04:21:06 | Benton, Minnesota, US | |
2658396 | 2658396 | 2022-01-31 | US | Colorado | Broomfield | 8014 | 13447 | 113 | 0 | 39.95998787 | -105.0566324 | 2022-02-01 04:21:11 | Broomfield, Colorado, US | |
1032646 | 1032646 | 2021-12-06 | US | New York | St. Lawrence | 36089 | 13447 | 146 | 0 | 44.4976179 | -75.06550039 | 2021-12-07 04:22:34 | St. Lawrence, New York, US | |
3752156 | 3752156 | 2021-11-22 | US | Texas | Bowie | 48037 | 13447 | 342 | 0 | 33.44626922 | -94.41834132 | 2021-11-23 04:22:39 | Bowie, Texas, US | |
1017363 | 1017363 | 2021-11-21 | US | Texas | Bowie | 48037 | 13447 | 342 | 0 | 33.44626922 | -94.41834132 | 2021-11-22 04:22:20 | Bowie, Texas, US | |
725527 | 725527 | 2021-11-20 | US | Texas | Bowie | 48037 | 13447 | 342 | 0 | 33.44626922 | -94.41834132 | 2021-11-21 04:22:13 | Bowie, Texas, US | |
699366 | 699366 | 2021-11-04 | US | Illinois | Adams | 17001 | 13447 | 156 | 0 | 39.98815591 | -91.18786813 | 2021-11-05 04:21:54 | Adams, Illinois, US | |
684217 | 684217 | 2021-10-24 | US | Missouri | Buchanan | 29021 | 13447 | 183 | 0 | 39.65816401 | -94.80138942 | 2021-10-25 04:22:31 | Buchanan, Missouri, US | |
2125543 | 2125543 | 2021-10-21 | US | Mississippi | Forrest | 28035 | 13447 | 251 | 0 | 31.18961454 | -89.25832496 | 2021-10-22 04:21:14 | Forrest, Mississippi, US | |
987401 | 987401 | 2021-10-04 | US | Alaska | Fairbanks North Star | 2090 | 13447 | 66 | 0 | 64.80726247 | -146.5692662 | 2021-10-05 04:21:27 | Fairbanks North Star, Alaska, US | |
1387517 | 1387517 | 2021-09-13 | US | Missouri | Clay | 29047 | 13447 | 191 | 0 | 39.31132056 | -94.41850862 | 2021-09-14 04:21:41 | Clay, Missouri, US | |
408413 | 408413 | 2021-07-28 | Netherlands | Curacao | 13447 | 126 | 12659 | 662 | 12.1696 | -68.99 | 2021-07-29 04:21:33 | Curacao, Netherlands | ||
3661340 | 3661340 | 2021-07-11 | US | Minnesota | Olmsted | 27109 | 13447 | 102 | 0 | 44.00374114 | -92.40209944 | 2021-07-12 04:21:34 | Olmsted, Minnesota, US | |
627624 | 627624 | 2021-07-10 | US | Minnesota | Olmsted | 27109 | 13447 | 102 | 0 | 44.00374114 | -92.40209944 | 2021-07-11 04:21:43 | Olmsted, Minnesota, US | |
831343 | 831343 | 2021-07-09 | US | Minnesota | Olmsted | 27109 | 13447 | 102 | 0 | 44.00374114 | -92.40209944 | 2021-07-10 04:21:25 | Olmsted, Minnesota, US | |
3031852 | 3031852 | 2021-06-16 | US | Maine | York | 23031 | 13447 | 134 | 0 | 43.47808377 | -70.71052375 | 2021-06-17 04:22:36 | York, Maine, US | |
2315059 | 2315059 | 2021-06-04 | Burkina Faso | 13447 | 167 | 13263 | 17 | 12.2383 | -1.5616 | 2021-06-05 04:23:03 | Burkina Faso | |||
3090603 | 3090603 | 2021-05-30 | US | Iowa | Dubuque | 19061 | 13447 | 209 | 0 | 42.46815349 | -90.88181925 | 2021-05-31 03:08:59 | Dubuque, Iowa, US | |
3055996 | 3055996 | 2021-05-13 | US | Mississippi | Jackson | 28059 | 13447 | 246 | 0 | 30.54020656 | -88.64184064 | 2021-05-14 04:20:41 | Jackson, Mississippi, US | |
3954182 | 3954182 | 2021-05-11 | Andorra | 13447 | 127 | 13070 | 250 | 42.5063 | 1.5218 | 2021-05-12 04:21:29 | Andorra | |||
956701 | 956701 | 2021-04-25 | US | Mississippi | Rankin | 28121 | 13447 | 277 | 0 | 32.26469147 | -89.94537876 | 2021-04-26 04:21:04 | Rankin, Mississippi, US | |
3925848 | 3925848 | 2021-04-24 | US | Mississippi | Rankin | 28121 | 13447 | 277 | 0 | 32.26469147 | -89.94537876 | 2021-04-25 04:20:32 | Rankin, Mississippi, US | |
1410879 | 1410879 | 2021-04-23 | US | Mississippi | Rankin | 28121 | 13447 | 277 | 0 | 32.26469147 | -89.94537876 | 2021-04-24 04:20:38 | Rankin, Mississippi, US | |
3423591 | 3423591 | 2021-03-19 | US | Pennsylvania | Lebanon | 42075 | 13447 | 264 | 0 | 40.36680311 | -76.45651841 | 2021-03-20 05:25:46 | Lebanon, Pennsylvania, US | |
3422463 | 3422463 | 2021-03-19 | US | Maine | Cumberland | 23005 | 13447 | 184 | 0 | 43.8370751 | -70.37226999 | 2021-03-20 05:25:46 | Cumberland, Maine, US | |
2183787 | 2183787 | 2021-02-26 | Russia | Kamchatka Krai | 13447 | 118 | 12051 | 1278 | 57.1914882 | 160.03838190000005 | 2021-02-27 05:22:28 | Kamchatka Krai, Russia | ||
974702 | 974702 | 2021-02-06 | Chile | Arica y Parinacota | 13447 | 261 | 12552 | 634 | -18.594 | -69.4785 | 2021-02-07 05:23:00 | Arica y Parinacota, Chile | ||
1591305 | 1591305 | 2021-02-05 | US | Texas | Kaufman | 48257 | 13447 | 187 | 0 | 13398 | 32.599141700000004 | -96.28734728 | 2021-02-06 05:23:55 | Kaufman, Texas, US |
3693859 | 3693859 | 2020-12-24 | US | North Dakota | Burleigh | 38015 | 13447 | 168 | 0 | 13304 | 46.97847375 | -100.4645214 | 2020-12-25 05:22:48 | Burleigh, North Dakota, 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]);